Overview
It is easy to bulk upload new product data or update existing product data using the upload tool.
Note: Uploading products in bulk is a background job to support larger uploads. You'll be notified by email when the results are ready to download from the import to save time waiting for the process to finish on the frontend.
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:
SKU - Must remain unchanged to update existing products.
Name - Product name.
EAN Barcode - European Article Number.
UPC Barcode - Universal Product Code.
Description - Product description text.
Discontinued - Product availability status.
Back Orderable - Allow orders when out of stock.
Commodity Code - Classification code for customs.
Categories - Product categories.
Suppliers - Supplier information.
Has Batch Number - Batch tracking requirement.
Has Serial Number - Serial number tracking requirement.
Low Stock Alert Level - Minimum stock threshold.
Weight - Product weight.
Height - Product height dimension.
Length - Product length dimension.
Depth - Product depth dimension.
Volume - Product volume.
Price - Selling price.
Cost Price - Purchase cost.
Pallet Sizes - Pallet configuration.
First Item Picking Cost - Initial picking charge.
Additional Item Picking Cost - Subsequent item charge.
First Carton Picking Cost - Initial carton charge.
Additional Carton Picking Cost - Subsequent carton charge.
First Pallet Picking Cost - Initial pallet charge.
Additional Pallet Picking Cost - Subsequent pallet charge.
Storage Unit - Storage classification.
Packaging Fee - Additional packaging charges.
Additional Parcels Required - Extra packaging needs.
Image URL - Product image location.
UN Number - Dangerous goods classification.
Handling Time - Processing duration.
Has Expiry Date - Expiry tracking requirement.
Best Before Date Warning Period Days - Alert threshold for expiry.
Units Per Parcel - Packaging quantity.
Free Picking As Additional - Picking charge exemption.
Packing Instructions - Special packing requirements.
Customs Description - Description for customs documentation.
Country of Manufacture - Origin country.
Infinite Stock - Unlimited stock setting.
Set as TRUE or FALSE.
Tax Exempt - Tax exemption status.
Tote Capacity - Number of units that fit in a tote.
When the tote is at capacity you will be required to scan a new tote to continue picking.
MID Code - Manufacturer Identification Code.
Log Batch Inbound - Track batch numbers on inbound.
Log Batch Outbound - Track batch numbers on outbound.
Log Serial Inbound - Track serial numbers on inbound.
Log Serial Outbound - Track serial numbers on outbound.
Log Expiry Date Inbound - Track expiry dates on inbound.
Log Expiry Date Outbound - Track expiry dates on outbound.
Goods In Cost SKU - Goods in cost SKU.
Goods In Cost Unit - Goods in cost unit.
New SKU - Used when updating existing products to change their SKU identifier.
Only applies during UPDATE operations, not NEW product creation.
Original SKU must exist to be updated to NewSKU value.
Opening Stock Level - Sets initial inventory quantity when creating NEW products.
Only processed for NEW products.
Used with Location to determine initial stock quantity.
Location - Warehouse location for product storage.
Creates location if it doesn't exist during product import.
Sets as default picking location for the product.
Used with Opening Stock Level to determine where initial stock is placed.
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.
Note: To learn more about updating products in bulk, please review our Product help guide.
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.