Overview
It is easy to bulk upload new product data or update existing product data using the upload tool.
Download Template
For ease of use there is a template to download, which we recommend doing regularly as the template can sometimes change when new fields added:
Click Products then Extras.
Click Upload Products then Download Template.
Complete Upload CSV Sheet
Once the CSV template has downloaded, please populate the values for each field. Mandatory Fields: The template gives you an example for each line but only the following fields are mandatory for first time upload:
StockCode (SKU).
Name (Product Name).
Weight (in KG).
Other values on the spreadsheet are optional and for more advanced features of the system such as dimensions for volumetric storage calculations, or barcode values for barcode picking. Options like Infinite Stock can be set with either TRUE or FALSE.
Upload File
Once you have filled in the CSV file, you can upload it to Mintsoft using the steps below:
Within the Upload Product Spreadsheet page, click Choose file.
Browse and select the saved file.
(3PL Only) Select the Client.
Select the Warehouse.
Click Upload.
Update Existing Products
Bulk Update Option: This spreadsheet can also be used to amend product attributes as well as first-time product setup. If you want to use it to amend product attributes just enter the SKU column data and any other field you want to amend for those products. Any other fields left blank will be ignored.
Updating discontinued products
If you need to make updates to a Discontinued Product, and you do not wish to make the product active, you must ensure the Discontinued field contains TRUE within the CSV. Leaving this blank will default to FALSE and cause the product to go active again.