[intro]Before you begin this Guide, you need to make sure that you have added some Categories to your EKM online shop, you have installed the Import/Export System feature and exported your Categories to a spreadsheet by following the steps in this Guide.[/intro]

Depending on the type of Products you sell and the purpose of your EKM online shop, hiding Categories may be something you need to do often. This Guide will take you through the process of hiding Categories using spreadsheets, which can often be quicker than the manual method if you have a lot of Categories that need to be hidden from the front end.

[warning]Don’t forget, hiding Categories also hides the Products within them if that Category is the Product’s Master Category. If the Products within the Category you’re hiding are Category Managed within it (so the Category is one of their Additional Categories), you should have no problem. For more information about Category Managing your Products, please see this Guide. [/warning]

1. When you have exported your Categories, you should have a spreadsheet which looks something like this:

2. The next step is to add the Edit command to the Action column. To do this, click the column header to highlight the entire column and then click the Find & Replace icon on the top right-hand side:

3. Click Replace from the drop-down menu:

4. In the window that appears, add ‘Category’ into the Find What field, and then add ‘Edit Category’ in the Replace With field, before clicking Replace All:

5. This will add the Edit command into the Action column, so when your spreadsheet is uploaded onto your EKM online shop, the system will be aware that some of the information on the Categories has changed:

Hiding your Categories

6. You now need to scroll along your spreadsheet until you find the Hidden column:

7. In this column, any visible Categories are indicated as ‘No’ and hidden Categories are marked with ‘Yes’. Adjust this column to suit your Categories:

8. Now you have finished working on your spreadsheet, click the icon in the top left-hand corner to save it:

Your next step is to upload the spreadsheet onto your EKM online shop.

[more]

[/more]

[contact] If you need our help with your EKM online shop, contact your Ecommerce Expert or the Customer Support Team, who will be able to point you in the right direction. We're open from 8am-6pm weekdays and 9am-5.30pm 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 the EKM Community. [/contact]