To update your existing products in Veeqo, you will need to generate a product export from Veeqo first by following this guide.
Before you can update products by CSV:
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 must be filled in when trying to update products:
|
|
|
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. Either provide field or delete the column | 0.2 |
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 and bin locations. 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 | 0.2 |
| 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 |
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 | 0.2 |
|
|
|
|
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