This guide will walk you through the process of assigning single or multiple warehouse bays to products from your Cloud Commerce Pro inventory in bulk using spreadsheets.
Please note, this guide is intended for users of the Complex warehouse mode. For a guide on assigning warehouse bays to products for Simplex warehouse mode, click the link below:
1. Admin Centre
From the Admin Centre in Cloud Commerce Pro, click the Products button.
2. Product Ranges
On the Product Ranges screen, click the Exports button.
3. Product Exports
When working with products in bulk it is always best practice to work from a freshly generated spreadsheet.
From the Products Exports screen, click the Export Products button to generate an export of your entire inventory.
4. Actions Menu
Your export will appear at the top of the list of exported items.
Hover over the Actions Menu beside your export and click Download Spreadsheet.
Save the spreadsheet to your device. Feel free to rename it to something easier to remember.
From your device, open your saved spreadsheet using your preferred software such as Microsoft Excel, Google Sheets or LibreOffice Calc.
If you only want to work on certain products, you can copy and paste them into a blank spreadsheet along with the headers. This is will also save time when uploading them back into the system and ensures you don't accidentally change products you did not intend to.
On your spreadsheet, find the header VAR_Bays. The names of your warehouse bays can be input here against any of your products using the bay name as it appears in CCP followed by the amount in stock, separated by a colon (:).
For example, if your warehouse bay is called "inbound stock" and you have 5 in stock of the item you would input "inbound stock:5" into the spreadsheet.
If your product is kept across multiple bays, these can be entered on the spreadsheet separated by a semi-colon (;).
As an example, if we had 5 of the product in a bay called "inboundstock01" and 4 in a bay called "inboundstock02" we would input "inboundstock01:5;inboundstock02:4" on the spreadsheet.
If you are not sure of the exact names of your warehouse bays, follow the guide below to find where in CCP to view them:
Warehouse - Adding New Bays
When you are happy with the bays you have entered, save your spreadsheet to your device and head back to Cloud Commerce Pro.
6. Return to the Product Ranges Screen
Navigate back to the Product Ranges screen from earlier and press the Imports button.
7. Upload Spreadsheet
Click the Upload Spreadsheet button and select the spreadsheet you just made changes to on your device.
8. Use Spreadsheet
Once uploaded your new spreadsheet will appear at the top of the list.
Click the checkbox under "Use" to mark this specific spreadsheet as the one to use for your import.
9. Import Step
Scroll down the import steps and find Step 5: Variations Import.
Click the Import Variations button to begin importing the information from your new spreadsheet.
If the spreadsheet is large, this can take some time, so feel free to leave it running while you do other things.
Once it has finished it will show "Complete" under Status. If any errors have occurred, they will be listed here along with the SKU's of the products involved so you can easily track them down and fix them.
Finally, when using Complex Warehouse Mode, your stock levels are tied to your warehouse bay locations. This means up to date stock levels must also be imported.
Scroll down to Step 8: Stock Import and click the Import Stock button.
Allow the import to run as you did in the previous step. Once complete, your new warehouse bays have been fully assigned.