[intro]If you populate the Cost Price field for each of your Products, you can use this data to easily identify the most profitable and least profitable lines on your EKM online shop. Before you begin, you will need to install the Import/Export System feature and have added at least one Product onto your EKM online shop. [/intro]

The Cost Price is the amount you purchased the Product for from your supplier, or alternatively, the amount is the cost to create the Product if you create your own items. By adding in a Cost Price to your Products, you can utilise the Most Profitable Products and Least Profitable Products on the Analytics tab of your EKM online shop. 

1. From the Dashboard, you need to click the Features tab:

2. On the Features page, open Import/Export System:

3. Click Export Data:

4. Click Export Products:

5. Click the green button:

6. Keep all the fields ticked and click the green Continue button in the bottom right-hand corner:

7. If you have under 500 products to edit, select a CSV file. If you have more products than this, select an XLXS file:

8. Click the link to download your spreadsheet:

9. When the spreadsheet has downloaded to your computer, open it up and highlight the first column by clicking the header:

10. You then need to click the Find/Select button in the top right-hand corner:

11. From the drop-down menu, select Replace:

[warning]If you have any Products and Product Variants that you do not want to add a Cost Price to, you need to delete entirely them from your spreadsheet. [/warning]

12. In the window that appears, add ‘Product’ to the Find What field, and ‘Edit Product’ to the Replace With field, before clicking Replace all:

13. This will add the correct command to your spreadsheet for you to edit a change - the Cost Price - onto your existing Products. Now you have added the command, the next step is to locate the CostPrice column - this is where you will be adding the Cost Price value. On the spreadsheet in my example, it’s column AY:

[tips]If you have a Product that has Variants, you need to ensure that the Cost Price value on the Product row of your spreadsheet matches the one for the default Product. The easiest way to do this is to highlight the rows of Products with Variants beneath them a bright colour. 

1. You can do this by clicking the number to the far left of the Product row to highlight the entire row, like this:

2. You then need to click the paint pot symbol towards the top left-hand side, and select a colour to highlight that entire row:

3. When you have highlighted the Product rows for each of your Products with Variants, your next step is to highlight the Default Product Variant rows. To do this, scroll to the right on your spreadsheet, and look for the VariantDefault column. In my example, this is column AT:

4. The row that contains ‘Yes’ it the Default Product Variant - it is the Variant that is displayed when your customer clicks onto that particular Product Page. You need to highlight this row too, by once again clicking the row number on the far left-hand side and then clicking the paint pot symbol:

5. Now as you’re working through your spreadsheet, you need to ensure that the Cost Price value for the Product row matches that in the Default Variant row, which is a lot easier when the rows are highlighted. In my example, I need to make sure that the Cost Price value on the yellow row matches what I enter in the orange row below it, like this:

[/tips]

14. You then need to add in a Cost Price value for each of your Products, in the following format:

15. When you have added a Cost Price value to each of your Products and Product Variants, your next step is to save your spreadsheet by clicking in the top left-hand corner of Excel and selecting Save As from the drop-down menu:

When you have saved your spreadsheet, you need to upload it back onto your EKM online shop by following the steps in this Guide.

[more]

[/more]

[contact] If you need our help with your EKM online shop, contact your Account Manager or Customer Support, who will be able to point you in the right direction. We're open from 8am-6pm weekdays and 9am-5.30pm on the weekends. If you'd like to suggest a feature or an upgrade on any of the EKM platforms, please let us know on the EKM Suggestions board. If you have a non-account specific question to ask the EKM Team, join us in EKM Community. [/contact]