[intro]Before you begin this Guide, you must install the Import/Export System which will enable you to export all of your Product information onto a spreadsheet to delete existing Products from your EKM online shop. [/intro]

In this Guide, you’ll learn how to delete Products using a spreadsheet, which is a quick way of removing large amounts of stock from your shop all at once.

It is also useful if your EKM online shop retails seasonal stock that is only sold at specific points during the year. This is because you can export the Products to a spreadsheet and copy it. Save one copy to delete the Products, whilst the other copy is stored somewhere safe until you want to re-add those same Product lines to your EKM online shop at a later date.

1. To begin, you need to export your products to a spreadsheet by following the steps in this Guide. When you have opened the file, you should have a spreadsheet which looks something like this:

[warning] Before you continue, you need to delete any rows that include Products and Product Variants that you DON’T want to delete, leaving only the Products and Product Variants that you want to delete from your EKM online shop. [/warning]

2. Your next step is to amend the commands in the Action column. To do this, click the header of the column to highlight it all and then click Find & Select in the top right-hand corner:

3. Select Replace from the drop-down menu:

4. In the window that appears, add ‘Product’ to the Find What field, and add ‘Delete Product’ in the Replace With field, before clicking Replace All:

5. When you have added the delete command to all of your Product and Product Variant Rows, you need to save your spreadsheet by clicking the File button in the top left-hand corner as normal:

6. 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 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]