[intro]In this Guide, you can learn how to delete existing Bulk Discounts on your EKM online shop using spreadsheets. [/intro]

Before you begin, you need to have set up a Bulk Discount on at least one Product previously and installed the Import/Export System which enables you to use spreadsheets to update the contents of your EKM online shop. 

1. To begin, you need to export your Products to a spreadsheet, by following the steps in this Guide. You’ll notice that there’s now an extra optional field for Bulk Discounts when you are exporting your spreadsheet - you will need to ensure that this box has been ticked before you click the green button to continue:

2. When you have downloaded your spreadsheet, remove the rows containing any Products that don’t have Bulk Discounts, and if need be, remove any unnecessary columns:

3. You then need to add the Delete command into the Action column for your Bulk Discount rows. Highlight the Product Bulk Discount rows, and then click Find & Select in the top right-hand corner:

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

5. In the window that appears, replace the command as shown - replacing ‘Product Bulk Discount’ with ‘Delete Product Bulk Discounts’ - before clicking the Replace All button:

6. When you have finished adding the Delete command for the Bulk Discount rows, you then need to save your spreadsheet and upload it back onto your EKM online shop, which will remove the existing Bulk Discounts from the Products that you specified. 



[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]