How to Configure Product Discount Eligibility (Import/Export Guide)

How to Configure Product Discount Eligibility (Import/Export Guide)

This guide explains how to set products as eligible or ineligible for discount using the Product Amendment Export/Import tool.

This guide is specific to clubs utilising the KORE/Sports Alliance Supporter Role API. 

This logic also applies for those manually uploading csv files into Customer Groups (Season Ticket Applies field also applies in this instance but not KORE/Sports Alliance Supporter Role API)

For those using Loyalty Cash/Points, Allow Loyalty flag can be managed in bulk in the same fashion.

Relevant Columns

Two fields in the export are used to control discount eligibility:

  • Discountable (Column J) - Controls in-store discount eligibility

  • Member Discount Applies (Column R) - Controls online member discount eligibility

Each column accepts:

  • Y = Discount applies

  • N = Discount does not apply

To Enable Discounts for a Product

Set both fields to Y:

DiscountableMember Discount Applies
YY

This makes the product discountable in-store and online.

To Exclude a Product from Discounts

Set both fields to N:

DiscountableMember Discount Applies
NN

This excludes the product from all discounts.

How to Apply

  1. Export your product file using the Product Amendment Import/Export tool.

  2. Update the Discountable and Member Discount Applies fields as needed.

  3. Re-import the file using the Product Amendment  Import/Export tool.

Only these two columns need to be updated to affect discount eligibility.

    • Related Articles

    • Product Amendment Import/Export

      Product Amendment Import/Export The import / export utility has been created to allow for easy updating of a products descriptions, department/sub department and min/max level, loyalty redemptions, bar form till . The program sits under Stock: Style ...

    • Use Customer Group Import Utility

      Import using a CSV with Client Ref, Name and Email Go to Customer Database > Customer Group Import Utility Click on the Import Season Ticket Holder tab. NOTE: The CSV File needs to have 3 columns and in the following order. The Name column can be ...

    • Setup for Season Ticket Holder Discount

      Setup Season Ticket Holder Discount Navigate to File Maintenance > System Configuration > Customer Order tab You will need to scroll down a little and you will see the Season Ticket Discount setup - Set the discount percentage to be given to Season ...

    • Scanner PLU Export

      What is the Stocktake PLU Export Program? The Stocktake PLU Export Program uses the back office to generate files that contain all current PLU’s and exports them to a file that can then be downloaded to the scanners so that the scanner know which ...

    • Uploading Product Video

      Please find the below step by step guide on how to upload video against a product: Customer Order Setup ->Catalogue File Maintenance -> Catalogue Codes Search for the product and click on Edit Once in the product scroll down to the bottom of the page ...