From your main navigation bar, click on Settings > Company Details > Locations.
Click on Import/ Export Stock Location Data at the top right-hand corner.
The following popup will appear:
Follow the steps as shown. Select your location via the drop-down box.
4. Then, click on Download Import Template.
The two fields you can update are the Reorder Point and Bin Location.
A Reorder Point is the unit quantity that triggers the purchase of a particular stock item.
A Bin Location is a designated inventory storage location in your warehouse.
Proceed to Step 3 and upload your CSV file.
If you are located in the EU, you may face an error when you export CSV from QuickBooks Commerce and open in Excel. This is because Excel in the EU searches for 'semicolons' whereas, in Singapore and other regions, Excel searches for 'commas'.
On Excel, format the commas to semicolons or vice versa depending on your needs.
And you're done! 🎉