This document will guide you through Importing products in bulk as well as updating existing products.

First of all, this feature is available only in 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 "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 2 options: 

1. Bulk Import 
2. Bulk Update

You should use Bulk Import to import new products and Bulk update to update existing products in bulk. 

Download the excel template by clicking on the Download button.



1. Bulk Import





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

This will be a dropdown with prefilled category values that you had created before downloading the template. Make sure to select the value from the dropdown and do not type.

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

Select Unit from the dropdown

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 Refresh button after 1 min and you will see the Import log



Here you can see that 1 Product was imported properly and 1 failed due to a Blank cell for the Status column.


Note: If you want to reupload the sheet by correcting values in the sheet again, make sure you only keep the failed records in the sheet. Otherwise accepted products will be added again and duplicated on your store.


Congratulations you have successfully imported your products into the Vepaar store.



2. Bulk Update


Visit the Bulk 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 Refresh button after a few seconds to see the status.



You will find the details of processed, success, and failed records in a bulk update in this update log.


Congratulations, you have successfully updated your products in Vepaar.

You can reach us anytime at support@vepaar.com if you find any queries in Bulk Import/Update.