Handling time, sometimes referred to as fulfilment latency, is the number of business days between when you receive payment for an item and when you ship it. Under normal circumstances this is done on a ASAP basis and, generally speaking, all of your items would have the same handling time. But what if you sell a product that requires assembly or customisation before it can be dispatched? This is where product based handling times enter play.

While handling time can be changed in CCP via the Products screen, if you have many products that require it, changing them in bulk will get the job done in no time with minimum effort.

Contents:

  1. Admin Centre

  2. Products

  3. Product Exports

  4. Actions Menu

  5. Spreadsheet

  6. Product Ranges

  7. Product Imports

  8. Use Spreadsheet

  9. Import

1. Admin Centre

From the Admin Centre in Cloud Commerce Pro, click the "Products" button.

2. Products

On the Product Ranges screen, click "Exports" to continue.

3. Product Exports

In order to make changes or additions to your products in bulk, you need to edit them on a spreadsheet.

To ensure you are working with the most up to date information, click "Export Products" to generate a fresh spreadsheet of your inventory.

4. Actions Menu

Your new spreadsheet will appear at the top of the list when it has completed exporting.

Hover your mouse over the "Actions" tab and click "Download Spreadsheet". Save it to your device in a convenient location. Feel free to rename it to something memorable to help you distinguish it from any other spreadsheets you might be working on.

Once you've saved the spreadsheet, open it up in your preferred editor such as Microsoft Excel, LibreOffice Calc or Google Sheets.

5. Spreadsheet

When you open your spreadsheet, navigate to the column headed "VAR_HandlingTime".

Simply change the value for each SKU based on the number of days handling time that product requires.

When you have entered all the handling time changes, save the spreadsheet and head back to the Products screen in Cloud Commerce Pro.

6. Product Ranges

Back on the Product Ranges screen, click the "Imports" button to continue.

7. Product Imports

To begin, we need to upload the spreadsheet to ready it for importation.

Click the "Upload Spreadsheet" button and follow the prompts to select the edited spreadsheet on your device where you saved it.

8. Use Spreadsheet

Once your new spreadsheet has been uploaded to the system it will show at the top of the list of available items.

Tick the box under "Use" to mark your new spreadsheet for importation.

9. Import

Before you continue, be aware that handling time is updated on a product level and will feed out to ALL of your sales channels.

Scroll down the page and find "Step 5". Click the "Import Variations" button to begin the import process.

Once the status shows as "Complete" your handling time will begin to filter out to your sales channels and update your products.

Did this answer your question?