[intro]Before you being this Guides, it’s essential that you have manually category managed a Product on your EKM online shop beforehand using this Guide and installed the Import/Export System feature which will enable you to create a spreadsheet to work from.
[/intro]

[summary]

[/summary]

Category Management is a term we use for how Products are displayed on your EKM online shop. Products ‘live’ in one place, which is typically a Category or the Homepage. However, using Category Management, you can have one Product display in more than one Category, which increases it’s exposure and encourages additional sales.

Exporting your Products to a spreadsheet

1. Log into your EKM online shop as normal, and click the Features tab:

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

3. Click Export To File:

4. Click Export Products:

5. Click Continue to Choose Fields:

6. Click Continue To Choose Download Type:

7. The download type you select depends on the number of Products you have on your EKM online shop. If you have 1000 or less Products, select a CSV File. If you have more than this, you may want to choose an XLSX File instead. Click the relevant green button for the file type you need:

8. Click the blue text to download your file:

The file will be visible in the bottom of your browser window and will automatically be added to the Downloads folder on your computer. Open the file to begin the process of adding your Promo Stickers.

Preparing your spreadsheet

9. When you have opened the file, you should have a spreadsheet which looks something like this:

The first thing you need to do to the spreadsheet is to add the ‘Edit’ command so that when you upload the file back to your EKM online shop, the system knows that some extra details have been added to an existing Product.

10. Click the A column to highlight it, and then click the Find & Select icon on the top right-hand corner:

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

12. In the window that appears, add the word ‘Product’ in the Find What field and the words ‘Edit Product’ in the Replace With field, before clicking the Replace All button:

This action will amend the ‘Product’ and ‘Product Variant’ rows to read ‘Edit Product’ and ‘Edit Product Variant’ accordingly. When you upload your spreadsheet onto your EKM online shop, the system will be aware that some of the data for the Products has been amended.

Category managing your Products

13. Your first step is to scroll along your spreadsheet until you find the CategoryManagement column:

14. In my example, some of my Products have already be assigned to live in more than one Category. You can see some of these on rows 29 and 31:

14. The format for data added to cells within this column is as follows - remember to replace the square brackets and their contents with the name of one of your existing Categories:

Home > [Main Category]

If you wish to add the Product to a Subcategory, the format would be:

Home > [Main Category] > [Subcategory]

If you wished to add the Product to more than one Category at once, you would separate the Category paths with a colon, but with no spaces either side, like this:

Home > [Main Category] > [Subcategory]:Home > [Main Category]

[remember] When you are category managing your existing Products on a spreadsheet, you only need to add the Additional Categories on the Edit Product rows - and not Edit Product Options or Edit Product Variant. It’s a lot easier to do if you highlight the Edit Product rows a bright colour - like yellow for example - to differentiate these from the rest of the rows.

You can do this by clicking the number of a row to highlight it all, and then clicking the bucket symbol to select a bright colour to highlight it with:

[/remember]

15. Following the formats listed above, you need to populate the relevant rows in the CategoryManagement column accordingly, assigning Additional Categories to your Products. When you have finished working on your spreadsheet, you need to save it by clicking the File button in the top left-hand corner as normal:

Now you have finished working on your spreadsheet, the next step is to upload it onto your EKM online shop.

[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 ask the EKM Team, join us in ekmCommunity.  [/contact]