Directory Image
This website uses cookies to improve user experience. By using our website you consent to all cookies in accordance with our Privacy Policy.

Opencart Multivendor Bulk Import Products Using MS-Excel By Seller

Author: Birendra Kumar
by Birendra Kumar
Posted: Jul 12, 2019
update product

This post is for you if you are a seller working on a multivendor eCommerce platform and if the seller wants to update the product which is to be done update product manually. It will very time to be consuming. Through Opencart multivendor extension, sellers can bulk update products on one click. Seller can update the product using.xls or.xlsx file.Seller wants to update large volumes of product data at one time by excel data file then should use it. This way is actually very easy to use and bulk product updates. Purpletree multivendor support multiple languages to update product data.

Features:

  • The seller can update bulk products at a time.
  • The seller can use.xls or.xlsx files, to update bulk products.
  • The seller can view changes in updated products in the frontend instantly.
  • The seller can update the product in multiple languages.
The seller should use the following step to update products

Login to your seller dashboard. Locate the seller panel. Click on Opencart bulk upload.

  1. The maximum upload time comes from the PHP server. It must be more if the file size is bigger to allow upload to complete successfully.
  2. The maximum file size must allow less than the PHP server size limit for update the product.
  3. Click on the Download template link.

If you need to update the product then you can download the sample excel data file.

The seller should use the exported data sheet for update products. If you want to change the data of any tab, then you have to fill the product id in the data and the General tab and"new product"column will leave empty.

If you do not know product_id then you can export data sheet with product_id and use it.

General Tab:

First, we will fill the valid product id in the product_id column. We can not leave the empty product_id column of the General tab even for a new product. This filed must be filled if inserting new product use any assumed product id in this field.

Data Tab:

First, we will fill the valid product id in the product_id column. We can not leave the empty product_id column of the Data tab. If any validation failed for any particular product id in this tab, no data will be updated for any of the tabs for that particular product id.

For Example: How to update product price?

The first seller should use the export data sheet and change price on the excel data sheet. Check on Overwrite existing Data and select language after that click on the import button.

Images Tab:

A product can keep one or more images so it cannot leave the empty product_image_id and product_id column. If you do not know product_image_id and product_id then you can export data and use it. The seller can update any existing image use exported data.

Discount Tab:

If you want to update discount any existing discount use exported data. To update any product data enter product_discount_id and product id. The seller can not update the product without product_discount_id and product_id.

Special Tab:

If you want to update the product any existing special-use exported data. To update any product data enter product_special_id and product id. The seller can not update the product without product_special_id and product_id.

Overwrite existing Data must check for update products. You can choose to select multiple languages for update products. Next click "Browse" to upload a single excel data file, navigate to the needed folder on your computer and select the file you want to upload. the file must be upload only in excel data sheet which accepts only.xls or.xlsx extension after that Click on the import button to update the product.

About the Author

VynZ Research is a market research firm offering research, analytics, and consulting services on business strategies. The company focuses on providing valuable insights on various technology verticals.

Rate this Article
Leave a Comment
Author Thumbnail
I Agree:
Comment 
Pictures
Author: Birendra Kumar

Birendra Kumar

Member since: Aug 31, 2017
Published articles: 60

Related Articles