Bulk Upload/Update Products on your Store
Created by: Kaushal Gajjar
Modified on: Mon, 7 Mar, 2022 at 6:26 PM
This document will guide you through Importing products in bulk as well as updating existing products.
First of all, this feature is available only to Agency Plan users only. So if you are under Free or other plans, you have to upgrade your account to Agency Plan.
You need to create product categories before initiating import. Login to your Vepaar account at web.vepaar.com and go to Store > Categories. Click on the "Add New" button and create all product categories.
Now go to Products and click on Bulk Actions at the top right corner.
Here you get 3 options:
You should use Import to import new products and update to update existing products in bulk. You can check the History from the History tab.
You can check the past history from the History option and If you are adding it for the first time then there would be no data you can click on the Import menu and start follow the process.
Download the excel template by clicking on the Download button.
Excel file will contain predefined columns. Please find the list of all the values.
Enter the name of the product
Enter product description
Add a category which you have already added or you can also add a new category.
Enter the price of the product
Select Yes value from the dropdown for adding the quantity of the product
Add the quantity of the product. Keep it blank if you have selected No in the "Add Quantity" column. Add numeric value only without decimal.
You can add “Measurement Unit" as suggested on the bulk import page.
Add the URL of any webpage that displays information regarding this product
Define the status of the product here. It can be Active or Inactive.
This option lets you add product images too. You can upload your product image to any cloud server and provide the URL of the image here. Please make sure that the image must be accessible via URL and it must stay on cloud servers otherwise it will stop displaying on your store
You can create an account on Dropbox, and upload the Product image files to Dropbox, you will get the URL like below.
so new URL will be like this,
And use this URL to paste in the sheet under Image URL columns.
Fill up all these details to the sheet and click on Upload to start uploading products.
Click on the History tab and check wait to complete the process.
Note: If there would be any issue with the sheet, you will get that sheet status as “Failed” and you can click on the “View Log” and check which data is missing or where you need to update the data.
As below example, Selling Price & Status is missing in the 2nd row of that Excel sheet.
So, you need to reupload the sheet by correcting values.
Congratulations you have successfully imported your products into the Vepaar store.
Visit the Update tab on left, click on the Download button to download the excel template of your existing products. This file will contain details of all your existing products along with all the details which you had added at the time of creating the product.
You will be able to edit only certain details in this file and you will not be able to add a new Row or column. Update required details and save this file to upload it back to the Vepaar store. Click on the Upload button and upload this file.
Click on the History button after a few seconds to see the status.
You will find the details of processed, success, and failed records in a bulk update.
Congratulations, you have successfully updated your products in Vepaar.
You can reach us anytime at firstname.lastname@example.org if you need any help.
Kaushal is the author of this solution article.
Did you find it helpful?
Sorry we couldn't be helpful. Help us improve this article with your feedback.