This post will show you how to add and update products in mass using the CSV file and will provide you an overview of the structure of the CSV file.
Mass Upload Products(CSV File)
For importing products via the CSV file –
- The Data flow profile could be selected as created by admin or seller to allow few details to upload.
- Just select the File type as “CSV“.
- Then select to Add New Upload New product.
- Upload the CSV file having the Product Information.
You can create a new CSV for uploading new products very easily. In CSV file, the first row defines the column name.
You can write it in both small or capital letter and also in multi-languages. You can write anything in the column name, but you have to match this correctly in the later steps.
Defining Description, Meta-Description, Keywords & Title
You can add a description of multi-language using tab name, separator, field name, and language. Like description:name:English. Here, the description is tab name, the name is the field name and English is a language.
Adding the – meta-description, meta-keywords, and meta-title.
How To – Define Attributes
You can add attributes in multi-language, using the field name and attribute name.
How To – Define Options
You can add multiple options to a single product and also multiple values for an option. Option name, type, value are essential for adding an option in the product. Option type must be in small letter and also in any language.
How To – Define Special Entry For Product
How To – Define Discount Entry For Product
How To – Define Product Image
How To – Define Custom Field
You can add multiple custom fields for the single product. For adding the custom field in CSV file – name, type, and value is mandatory. Custom field type must be in small letter and custom field value must be same as the product option created in the admin side.
**Note – Custom field is applicable for OC version 2.0.X
How To – Update Products(CSV)
Select “Update Old Product’s” as shown in the below screenshot and enter valid parameters.
The seller can select the data flow profile, select seller, file type(as CSV), update old product and upload zip file.
How To – Update Attributes in CSV File
If you want to update an attribute in the existing product then, you have to add product id and model:name combination. The first row defines column field.
How To – Update Option in CSV File
You can update multiple options for a single product and also update multiple values of an option for a single product. Option name, type, value are essential for updating an option. When you will update an option, previous option will be deleted and newly updated option will be applied.
How To – Update Discount Entry in CSV File
If you want to update discount entries in existing product then, you have to add product id and model:name combination in CSV file structure. Like below screenshot.
That’s all for the Opencart Marketplace Version2 Product Mass Upload CSV File Demo. Still, have issues or want to give your suggestions to make this module better just raise a ticket at webkul.uvdesk.com
Current Product Version - 2.0.0.0
Be the first to comment.