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: 

1. History

2. Import

3. Update


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.


1. History


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.




2. Import

Download the excel template by clicking on the Download button.




Excel file will contain predefined columns. Please find the list of all the values.


Name

Enter the name of the product

Description

Enter product description

Category

Add a category which you have already added or you can also add a new category.

Price

Enter the price of the product

Add Quantity

Select Yes value from the dropdown for adding the quantity of the product

Quantity

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.

Unit

You can add “Measurement Unit" as suggested on the bulk import page. 

URL

Add the URL of any webpage that displays information regarding this product

Status

Define the status of the product here. It can be Active or Inactive.

Image URL1

Image URL2

Image URL3

Image URL4

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. 


https://www.dropbox.com/sh/4qngupdy1bf6xkn/AADVjS4_4faoAFpV0VN2ClTsa/Frank_Sofia_The_First_Puzzle_for_4_Year_325.jpg


Replace https://www.dropbox.com/ with https://dl.dropboxusercontent.com/


so new URL will be like this, 


https://dl.dropboxusercontent.com/sh/4qngupdy1bf6xkn/AADVjS4_4faoAFpV0VN2ClTsa/Frank_Sofia_The_First_Puzzle_for_4_Year_325.jpg


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.



3. Update


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 support@vepaar.com if you need any help.