Demos Buy Now

Opencart Marketplace Version2 Product Mass Upload XLS File Demo

This post will show you how to add and update products in mass using the XLS file and will provide you an overview of the structure of the XLS file.


  • You can add multiple options, special, discounts, custom fields for the multiple products.
  • You can add the product description, attributes in multiple languages.
  • Back up files can also be used as Demo XLS file to add the products in bulk.
  • Image path should be correct else the image will not get uploaded.
  • Export products in Bulk.

Mass Upload Products (XLS File)

For importing products via the XLS file

  • Just select the File type as “XLS“.
  • Then select to Add New Upload New product.
  • Upload the XLS file having the Product Information.
  • Select the Column Separator(Separator for Multiple Values in the Option.).
  • Click on the “Category” to assign category if no category has been assigned to the product.
  • Now, click on the “Next” option to go to the next step.

After entering all the information click the “Next” button to go to the next step, now you will have to match the product and in file column values under the different tabs. Lastly, after mapping all the fields for all the tabs click the “Save” button to save the products, after which you can see the success message that the products have been uploaded.

You can create a new XLS for uploading new products very easily. In XLS 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 A Category

You can add the category very easily in XLS file, using the main category, separator, sub-category. You can also add multiple categories for a single product.

The separator that you have defined under the “Subcategory Separator“, same should be used within the XLS file.

How To – Define Attributes

You can add attributes in multi-language, using the field name and attribute name.

If you want to add more attributes then follow this structure.

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

You can add multiple special entries for a single product using the model field in each row.

How To – Define Discount Entry For Product

You can add multiple discount entry for the single or multiple products using the model field as shown below in the snapshot.

How To – Define Product SubImage(Thumbnail)

You can add multiple sub-images for the single product using tab name, separator, field name. Like product images:image. In your XLS image path looks like this catalog/folder_name/file_name.png(extension).

How To – Define Custom Field

You can add multiple custom fields for the single product. For adding the custom field in XLS 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.

**NoteCustom field is applicable for OC version 2.0.X

How To – Update Products(XLS)

Select “Update Old Product’s” as shown in the below screenshot and enter valid parameters.


You can update the product using product id and model name combination. You have to select both product_id and model:name under Update tab.

After that, you have to select Model under a General tab for updating the product. Otherwise, you can’t update the product. It is the mandatory field for updating the product.

How To – Update Attributes in XLS 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 XLS 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, the previous option will be deleted and the newly updated option will be applied.

How To – Update Discount Entry in XLS File

If you want to update discount entries in the existing product then, you have to add product id and model:name combination in XLS file structure. Like below screenshot.

That’s all for the Opencart Marketplace Version2 Product Mass Upload XLS File Demo. Still, have issues or want to give your suggestions to make this module better just raise a ticket at

Current Product Version -

. . .


Add Your Comment

Be the first to comment.

Hire Us!
Brief us about your requirements and we'll get back to you.
Woo! Hooy!
We have just recieved your project brief and our expert will contact you shortly.
Send Again