The following information applies to updating Products (Excluding Bundles) in bulk within Mintsoft. If you want to bulk update products, the quickest way is via CSV. This is useful when making mass changes, such as weights, commodity codes and prices as it can save you a lot of time. To do this, you can export your current data, make any changes to the spreadsheet, and then import the changes.
Note: (3PL Only) This needs to be updated client-by-client, mixing client SKUs in the same CSV can cause new products to be incorrectly created.
Updating Products in Bulk
To update products in bulk using a CSV upload, please do the following:
Click Products then Overview.
(3PL Only) Filter by the Client whose products require updating.
Click Bulk Export Products.
A CSV file will be downloaded.
Make any changes you need to the product data, the following fields are available -
SKU: Please ensure the SKU is entered and stays the same, changing this will cause new products to be created instead.
Name.
EAN Barcode.
UPC Barcode.
Description.
Discontinued.
Back Orderable.
Commodity Code.
Categories.
Suppliers.
Has Batch Number.
Has Serial Number.
Low Stock Alert Level.
Weight.
Height.
Length.
Depth.
Volume.
Price.
Cost Price.
Pallet Sizes.
First Item Picking Cost.
Additional Item Picking Cost.
First Carton Picking Cost.
Additional Carton Picking Cost.
First Pallet Picking Cost.
Additional Pallet Picking Cost.
Storage Unit.
Packaging Fee.
Additional Parcels Required.
Image URL.
UN Number.
Handling Time.
Has Expiry Date.
Best Before Date Warning Period Days.
Units Per Parcel.
Free Picking As Additional.
Packing Instructions.
Customs Description.
Country of Manufacture.
Infinite Stock.
Amazon FBA Active.
Tax Exempt.
Save the CSV file.
To upload your changes, click Products, then Extras next click Upload Products.
(3PL Only) Select the Client.
Click Choose File then browse to the file you just saved.
Click Upload.
Your changes are imported and information about each record imported appears advising if it was successful. To transfer products in bulk please review the Stock Transfer article, alternatively, to book inventory in bulk please review the Book Inventory article.
Updating products - FAQ
What is PriceType?
PriceType refers to additional pricing within the Extended Pricing section on the Product. This is not supported with 3rd Party Order Integrations and was initially set up for Manual Input Orders. Please follow the steps in the Updating Products in Bulk section above to correctly download and update product data.
What product data can be updated in bulk?
All attributes of product data can be updated in bulk, this includes such fields as the Weight, Product Dimensions, Price, Name, etc. The only field you cannot update in bulk is the SKU field as this would create a new product on Mintsoft instead of updating the existing one.