As well as manually booking stock you have the option to update inventory in bulk with a spreadsheet (.CSV file) upload. This is useful if you want to add or remove stock from multiple products at once without using ASNs. The spreadsheet needs to be uploaded using the correct format and layout. If you already have the spreadsheet populated, skip to the How to upload a spreadsheet section.
Prerequisite - Removing stock in bulk
When removing stock using the bulk CSV method, please make sure the quantity doesn’t go below zero in Mintsoft. For example, if you currently have 10 units and want to reduce it to zero, only remove 10, removing more would result in a negative stock level, like -1.
Downloading and populating a spreadsheet
Updating inventory in bulk to Mintsoft is done through a spreadsheet, to create and upload a Goods In spreadsheet please do the following:
Click Products then Extras.
Next, click Upload Goods In / Out Spreadsheet.
Click Download Template.
A CSV file will be downloaded.
Populate the template.
The Client, SKU, Warehouse, Quantity and Comment columns are mandatory.
(3PL Only) Enter the Client.
Enter the SKU.
Enter the Warehouse.
(Recommended) Enter the Location.
Leaving it blank will book inventory into your Unassigned location.
(Optional/ if used) Enter the BestBefore, BatchNo, and SerialNo.
Enter the Quantity.
To book in (Add stock) to Mintsoft use a positive number e.g. 5.
To book out (Remove stock) from Mintsoft use a negative number e.g. -5.
Enter a Comment.
Continue populating the spreadsheet with all the adjustments.
Once finished, click Save.
Spreadsheet Example
How to upload a spreadsheet
Once you have populated a Goods In Spreadsheet, the next step is to upload it:
Click Products then Extras.
Next, click Upload Goods In / Out Spreadsheet.
Click Choose File and find the spreadsheet.
Finally, click Upload.
If the template has been completed correctly, you should see a Stock Successfully Updated results screen.
The updated stock will be reflected in the system.
Upload Example
