This guide will allow you to bulk update bays so they can be used in CCP for stock locations

1. Head into the Products page

From the main admin centre, click the Product button in the list below. This will take you to the Product page where you can access the exports/import tabs.

2. Click the exports button

Once you are in the product page, you will see a button to 'export' the data. Press this option to head into the exports section

3. Export products

Once you are in the exports section, you will see a number of exports which can be used for updating your product data in bulk.

Hit the 'export products' option which will begin a download of your most recent product data. This is the spreadsheet you will need for updating the warehouse bays.

Once the file has downloaded, you will see an actions option appear against the requested file, hover over this and press the 'download spreadsheet' option

4. Fill out the warehouse Bays

Once you are in the Product Export file, head right in the spreadsheet until you come across the VAR_Bays column. This is often found in column (AB)

Once in the column, you can type out a bay location against the SKU that you wish for the bay to be joined with.

For example if I had a warehouse bay named 'testbay', I would enter testbay1 in the VAR_Bays column. This will then save it against the SKU as that SKUs bay location.

What to do if I have multiple bays against one SKU? - If you have multiple bays against a product, you will need to lay them out next to each other whilst specifying the stock against that specific location with the use of a colon ':' You can then use a semi colon ';' to separate the bays. For example;

Testbay:5;Testbaydupe:5

(It is worth noting, if you are specifying the bays and their unique stock, you will also need to make sure the stock column amounts to this)

5. Importing the bays

Once you have created the bays in the product export file, save the file.

Now that you have the file saved correctly, head into the previous products screen and click into the imports tab

Once in this screen, select the upload spreadsheet option and you will see the file appear with with a filename, date and time.

Tick the file you wish to upload and begin running the import on step 5.

if you have specified stock against multiple bays, you will also need to run the file on step 8. Please ignore this step if you have only included one bay

Did this answer your question?