Why Is This Useful?
- You can export all your products into a CSV (spreadsheet) file, which you can then edit on your computer and upload back into Veeqo with all the updates.
- E.g. you might want to bulk add all your barcodes for your products before listing to eBay or Amazon.
- You can also use the CSV bulk update tool to transfer stock from one location to another for all your inventory.
Example csv Download
1. Export the latest version of your Veeqo Products.
2. Edit the data in your CSV file in Excel/OpenOffice or similar programs then save the file. We recommend that you save the file under a new name as this will provide you with a backup file should you make a mistake.
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 are manually adding a new product to Veeqo via CSV then leave this field blank and Veeqo will auto assign a product id. If the product_id column is missing then Veeqo will check to see if the product exists already by comparing the SKU column.
If you do not want to stock quantity to be updated then you can remove the total_qty column and it won't affect the stock level.
The below table shows you the column headers found in a Veeqo Product CSV file. Ones with a * are required for the import.
|sku_code||Your companies own unique product identifier code||GH4472-WHT||YES|
|product_title*||The title you want your product to be called. This will be the title displayed on your printing templates and emails from Veeqo to your customers||Deck Chair||YES|
|variant_title||If your product is available in different sizes, coulours etc. This is where you would enter the name of this paticular type||White||NO|
|sales_price||The retail price of your prodct||5.99||YES|
|cost_price||The price your company pays for the product||2.59||NO|
|description||The product description||A brand new garden chair||NO|
|brand||The product brand associate with this item. If you are adding a new brand that isn't already in Veeqo it will automatically get created when you upload the CSV file||Apple||NO|
|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||NO|
|qty_on_hand||This is the current physical stock level minus the allocated stock. Do not amend this field if you want to adjust your stock level||10||NO|
|total_qty*||This is your physical stock level. If you ware wanting to adjust your actual stock level you should amend this field.||15||YES|
|total_stock_value||This is the financial value of your current stock level||16.97||NO|
|image_url||Location of the image file for your product.||http://www.veeqo.com/product-images/chair.jpg||NO|
|weight||Product weight measure in grams||10||NO|
|product_id*||Do not change this. This number is the unique identity that is assigned to your product. If you are importing new products that you want to create then leave this column blank||54738||NO|
|min_reorder_level||This is the threshold when you want Veeqo to notify you that it's time to re-order the product||50||NO|
|quantity_to_reorder||Enter a typical amount that you would order for this product. This is used as the default re-order amount for the product when creating a PO. The default amount can be amended prior to completing the PO||10||NO|
|location||BIN locations are used to know where your stock is kept in the warehouse. This information is visible on the stock take feature and some printed documents||shelf5-row2||NO|
|width||The width dimension of the product||203||NO|
|height||The height dimension of the product||112||NO|
|depth||The depth dimension of the product||54||NO|
|dimension_unit||The unit of measurement. This can either be CM or Inches. If this is left blank the default of CM will be used||cm||NO|
|tax_rate||The percentage tax rate used for your product.||20||NO|
IMPORTANT! THE ONLY COLUMN YOU SHOULD DELETE PRIOR TO UPLOADING THE FILE IS THE total_qty COLUMN TO PREVENT UNWANTED STOCK CHANGES. ANY OTHER COLUMNS YOU DELETE MAY ERASE PRODUCT DATA
3. When you are ready Save the file under a new name then Import the new file to Veeqo.
The Update Stock Stock In Bulk guide goes into more detail on how to manage large inventory updates in Veeqo.
Adding Product Variants
Each variant should be on its own line in the CSV file. Veeqo will recognise a new variant of a product if the product title already exists in Veeqo. So each of your variants should have exactly the same product title but different variant titles.