[intro]In this Guide, you can learn how to edit 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. Your next step is to add the Edit command into the Action column:

4. You can then amend the data in the Price and FromQuantity columns accordingly:

[tips]You can also use percentages as opposed to prices in the Price column. These must be entered as the figure and then the percentage symbol - '5%' - and always be between 1-100. [/tips] 

5. Then you need to save your spreadsheet and upload it back onto your EKM online shop. You’ll then be able to see the amended Bulk Discount prices within the Add/Edit Product window:

6. And, of course, on the Product Page too:

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