Request an

or Call

01524 230 252

Adding Extra Costs To Products In Bulk

At Cloud Commerce Pro, we understand that not all products were created equal. Sometimes a small variation of a product can incur vastly different costs, such as extra postage fees or insurance costs.

It is important to add these extra costs so they can be factored into your sales reports to ensure you are calculating the profit on each item correctly. Also, if you are using the built-in re-pricing tool and want to use cost based rules, these extra costs are added to the initial cost of the item to make sure you don’t sell below your real cost price.

If you have a lot of products in need of extra costs, you can save time by importing them in bulk via a spreadsheet.

This guide will take you through the process of how to correctly compile the data needed, right through to importing it into Cloud Commerce Pro.

If you would rather add these extra costs manually, please consult the guide for Manually Adding Additional Costs To Products.

Compiling The Data

Compiling The Data

1. Spreadsheet:

First you must collect the extra cost data into a spreadsheet in a format that Cloud Commerce Pro can understand. Create a new blank spreadsheet in Microsoft Excel. You will need to add the 5 headers to the spreadsheet as shown above. The steps below will show you how to customise the headers and the data in the spreadsheet to fit your needs.

2. Type:

The Channel ID that you want to update should be included, followed by an underscore and the following: “ExtraCosts_Type”.

Example: “160_ExtraCosts_Type”

To target all channels you can set the ID to “0” or “All”

Example: “0_ExtraCosts_Type” or “All ExtraCosts_Type”

The default values you can give for each product are as follows:

0 = Delete

1 = Commission

2 = Packaging

3 = Handling

For any given product, you can apply rules for several channels by repeating the three columns, each with the correct channel ID. You can choose to repeat each one on a new line, repeating the product ID on each.

 

To locate a channel ID, click “Selling” from the Admin Centre.

Find the sales channel you want to use from the list. The channel ID is the second number under the “ShopID-ChanID” header.

3. Value:

The header for this column will follow a similar pattern, but with the “ExtraCosts_Value” in the title.

Example: “All_ExtraCosts_Value”

You can then add a number value for each product.

4. Data-Type:

The header for this column will include “ExtraCost_dataType”

The default values you can give for each product are as follows:

Monetary = 1

Percentage = 2

When you have added all the data, save the document somewhere you can find it easily and name the file something you will recognise.

Import to CCP

Import to CCP

Now we need to import the compiled data into Cloud Commerce Pro.

Click “Products” from your Admin Centre.

Product Range List

Product Range List

At the top of the product range list there are a number of buttons to help you manage your products on the system.

Click “Imports” to continue.

File Handling

File Handling

This page gives you control over the various files you can use to import data into Cloud Commerce Pro.

Click “Upload Spreadsheet”.

Retrieving The Data

Retrieving The Data

1. Navigate to where you saved your spreadsheet at the beginning of the guide.

2. Click “Open” to continue.

Locating Your Upload On CCP

Once you’ve uploaded the spreadsheet, it should appear at the top of the list of previously uploaded files.

Preparing The Data

Preparing The Data

Click the check box next to the uploaded spreadsheet to tell the system that you want to use that file.

Import Extra Costs

Import Extra Costs

Scroll down to the very bottom of the page to “Step 22”, which handles the importing of the Extra Cost data.

If you have never used the function before it will appear blank, as shown here. If you have used it, you will see the results of the previous import.

Click “Import Extra Costs” to begin the process.

Import In Progress

Import In Progress

As the import processes you will notice the screen change to reflect its current status.

1. When you start the import it will appear as “Queued” momentarily while the system handles the request.

2. These fields represent how many products are being processed, but will remain unfilled until the data is successfully imported.

Import Complete

Import Complete

1. The spreadsheet we uploaded for this example contained two products, which can be seen to have successfully processed with this import.

2. This shows the import has completed.

Repeat these steps any time you want to add more extra costs to your products, but be aware, you can only upload one spreadsheet at a time.

Generic Order Importer

By Admin | July 11, 2018

Importing Customer Details

By Admin | June 1, 2018

Exporting Customers

By Admin | June 1, 2018

Deleting Suppliers

By Admin | May 31, 2018

Quickly Add Purchase Order

By Admin | May 30, 2018

Packing Station Video

By Admin | May 23, 2018

Order Management Video

By Admin | May 23, 2018

Dispatching Orders Video

By Admin | May 23, 2018

Order Dispatch Video

By Admin | May 23, 2018

Repricing On Amazon Video

By Admin | May 22, 2018