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.
1. Compiling Data - Admin Centre
Before we begin, we need to compile the data needed to populate your new spreadsheet.
Click “Selling” from the Admin Centre.
2. Sales Channel List
We need to find and make note of the channel ID of the sales channel we want to add extra costs to.
Find the sales channel you want to use from the list. The channel ID is the second number under the “Channel ID” header. Make a note of this number as we will need it for the next step.
Click the sales channel you want to work with to continue.
3. Sales Channel
Next we need to get a spreadsheet export of the products on this channel.
Click the "Import/Export" button.
4. Import / Export
Click the "Listings Export" button to start the export. When it is done, it will show under "Last Spreadsheet Exported".
Hit the download button as shown below and save the spreadsheet to your device before opening it in your preferred spreadsheet editing tool such as Microsoft Excel, Google Sheets or LibraOffice Calc.
5. Exported Spreadsheet
While it will be useful to keep this spreadsheet to hand to reference any details about a product on this channel quickly, we mostly just need two pieces of information from here: ID and SKU as shown below.
Continue on to find out how we will use this information.
6. Compiling The Data
Now we need to collect the extra cost data into a spreadsheet in a format that Cloud Commerce Pro can understand. Create a new blank spreadsheet and add these 5 headers as shown below. For the final 3 that begin with the number "25", replace this with your channel ID, which we made note of in step 2:
7. Headers Explained
This is the variation SKU of the item you want to add extra costs to. You can find this information on the listing export you generated in step 4. There are various different SKU's used for products that have different functions, so be careful to use the correct one.
Again, this can be found on your listing export spreadsheet. As with SKU's, there are multiple types of listing ID's. Ensure you are using the one shown below.
This column requires a number which defines the type of extra cost you are adding.
The values you can give for each product are as follows:
- Delete = 0
- Commission = 1
- Packaging = 2
- Handling = 3
Remember to change the number at the start of the header to match your channel ID.
Alternatively you can have this spreadsheet apply to all of your sales channels by changing the number to "0" or "All".
Example: “0_ExtraCosts_Type” or “All ExtraCosts_Type”
Here you can add a number value for each product to represent the actual extra cost. This will either be a monetary value or a percentage. Which of those two you are using will be defined by the next column.
As with the previous column, remember to change the number at the start of the header to match your channel ID.
As mentioned above, this column controls whether your extra cost is a monetary value or a percentage. Simply add the corresponding number for your preference.
The values you can give for each product are as follows:
- Monetary = 1
- Percentage = 2
Again, remember to change the number at the start of the header to match your channel ID.
8. Adding Extra Costs To Multiple Channels
You can add extra costs for multiple sales channels by repeating the three columns, each with the correct channel ID.
See the example below:
When you have added all the data, save the document somewhere you can find it easily and name the file something you will recognise.
9. Import to CCP
Now we need to import the compiled data into Cloud Commerce Pro.
Click the “Products” button from the Admin Centre menu.
10. 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.
Here we can upload our spreadsheet into Cloud Commerce Pro so we can use it to import the extra data to our products.
Click the “Upload Spreadsheet” button and navigate to where you saved your spreadsheet at the beginning of the guide before opening it.
12. Locating Your Upload On CCP
Once you’ve uploaded the spreadsheet, it should appear at the top of the list of previously uploaded files.
13. Preparing The Data
Click the check box next to the uploaded spreadsheet to tell the system that you want to use that file.
14. 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.
15. Import In Progress
As the import processes you will notice the screen change to reflect its current status.
- When you start the import it will appear as “Queued” momentarily while the system handles the request.
- These fields represent how many products are being processed, but will remain unfilled until the data is successfully imported.
16. Import Complete
- The spreadsheet we uploaded for this example contained two products, which can be seen to have successfully processed with this import.
- 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.