Before you Start
Export your products to CSV by following this guide.
Save a copy of this as a back up Product CSV, as changes cannot be undone
Required fields in CSV file
The following key fields are mandatory and must be filled in when updating products. You cannot remove these columns or upload them blank:
|
|
|
SKU | The SKU of the product |
|
product_id | Generated by exporting the products from Veeqo. This is a unique identifier for your product in Veeqo | 123456 |
product_title | The title of your product. NOTE: this field is not required but cannot be uploaded blank. Either provide field or delete the column | White Cotton T-Shirt |
sell_price | The retail price of the product. NOTE: this field is not required but cannot be uploaded blank. Either provide field or delete the column | 9.99 |
tax_rate | The tax rate of the product. NOTE: this field is not required but cannot be uploaded blank, and should be a number between 0-100. Either provide field or delete the column | 20 |
Important:
DO NOT edit the product_id field as this defines which product you are updating. If you change this it may cause duplicates.
If you want to ensure your stock levels are not affected by your product updates, remove the "total_qty" field from the CSV file before you upload your changes
There is a limit of 1000 lines per CSV file to ensure stability during upload, files with more than 1000 lines will not upload correctly.
Available Fields
Occasionally, you may need to update your product details in bulk, such as product barcodes, bin locations, and stock levels. This can be done by uploading the details via CSV. Below are the fields you can update using a CSV import, as well as a brief description and an example of the format we support. This includes:
Simple product |
|
|
|
| sku_code | The SKU of the product |
|
| product_id | Generated by exporting the products from Veeqo. This is a unique identifier for your product in Veeqo | 123456 |
| product_title | The title of your product. NOTE: this field is not required but cannot be uploaded blank. Either provide field or delete the column | White Cotton T-Shirt |
| sell_price | The retail price of the product. NOTE: this field is not required but cannot be uploaded blank. Either provide field or delete the column. This will not update your listings price | 9.99 |
| tax_rate | The tax rate of the product. NOTE: this field is not required but cannot be uploaded blank. Either provide field or delete the column | 20 |
| upc_code | The barcode or unique product code for the item. This can be printed out in barcode format, however it will need to be entered in numerical format on the CSV | 1254387817 |
| cost_price | The cost of the item | 4.99 |
| weight | How much the item weighs. The default uses grams, however if your inventory uses a different unit, Veeqo will convert the value entered. If you want to enter the value using a different unit, add another column "weight_unit" and specify the unit e.g. oz | 130 |
| estimated_delivery | Approximate length of time taken to ship this item (days) | 4 |
| width | Product width | 35 |
| depth | Product depth | 2 |
| height | Product height | 55 |
| location | BIN locations are used to know where your stock is kept in your location. This is information is visible on some printed documents and with Digital Picking | shelf5-row2 |
| total_qty | Product stock level. Uploading this field blank will revert stock to 0, either enter a value or delete the column | 100 |
| hazmat | Use this field to indicate if a product contains dangerous goods | TRUE |
Kits/Bundles |
|
|
|
| sell_price | The retail price of the product. NOTE: this field is not required but cannot be uploaded blank. Either provide field or delete the column. This will not update your listings price | 9.99 |
| product_title | The title of your product. NOTE: this field is not required but cannot be uploaded blank. Either provide field or delete the column | White Cotton T-Shirt |
| tax_rate | The tax rate of the product as a decimal, this example shows a tax rate of 20%. NOTE: this field is not required but cannot be uploaded blank. Either provide field or delete the column | 20 |
NOTE: Stock level can also be updated by CSV.
How to bulk update products details
Once you have exported the CSV file and made the changes to your products please follow these steps -
Click Import on the Inventory Page
If you're also updating stock levels, make sure to select the correct location into which you want to upload stock
Set IMPORT TYPE to All
Click NEXT
Click Upload Data from File
Click Yes for Does this row contain column names?
Review the mapping of your fields:
Set the status to ✔ Confirmed mapping if you are happy that the wizard has matched your CSV column header to the right Veeqo product field
Set the status to Ignored if the CSV column has no data, or you don't want to include it in the import
Edit the mapping if Veeqo has mapped it incorrectly, by clicking the Lookup matching fields dropdown menu and selecting the matching Veeqo data field to your CSV column name
Click Review and you will be shown all of the information you have just imported.
You can now review any issues and correct them by selecting Only show rows with problems
Click Complete
The import can take up to 30 minutes, depending on your file size. Once the import is completed, we send an email to the user who has performed the CSV import.
If your import has failed for any reason, we will notify you with the error so you can correct it in the CSV and re-import. This is also displayed in the email we send to the user
Common Issues
Below are some common issues faced when updating products via CSV and how to fix them:
Duplicate titles
If you update your products via CSV and find the product titles are repeated, this is because you have filled in both the product title and the variant title. Remove the variant title and fill it in as "default", then re-upload the CSV
CSV failing
If your CSV is failing, you probably have missed some of the required fields. Check out the section at the start of the guide and make sure all the required fields are present and filled in for each product