DIEF Templates for Promotions

DIEF

Fred provides you a range of import templates for use with the Data Import/Export Framework (DIEF). These templates are in .csv format (the format required for import), and include both default/system required fields and files for you to add/update (highlighted in yellow). Where applicable each template will include an examples, to help you with additions. These should be overwritten or removed before importing the .csv file into DIEF.

Important Group Promotion Import template fields

Field Options
Category Hierarchy Use only promotion is at Hierarchy level.
Category Name Use only promotion is at Hierarchy level.
Item Number Use only promotion is at Product level.
Discount Method

Enter the discount method as:

  • Amount Off
  • Discount Price including Tax
  • Qty Percentage
  • Quantity Price
Discount Offer

This varies depending on the Discount Method entered in the previous field:

  • If Discount Method is Amount off, then Discount Offer is the dollar amount off. For instance $5 off.
  • If Discount Method is Discount Price including tax, then Discount Offer is the new discounted price for the product. For instance $9.99.
  • If Discount Method is Qty Percentage, then Discount Offer is the percentage off the item. For instance 10% off.
Qty Break (for %)

If you want to add a condition to the discount, then this field can be used.

For example, to set up Buy 1 get 5%, Buy 2 get 15%, two lines would need to be entered for the product where:

  • Line 1:
    • Discount Method = Qty Percentage
    • Discount Offer = 5%
    • Qty Break = 1
  • Line 2
    • Discount Method = Qty Percentage
    • Discount Offer = 15%
    • Qty Break = 2
Qty Offer (for $)

If you want to add a condition to the discount, then this field can be used.

For example, to set up Buy 1 at $4.99, Buy 2 at $8.99, two lines would need to be entered for the product where:

  • Line 1:
    • Discount Method = Discount Price including tax
    • Discount Offer = $4.99
    • Qty Offer = 1
  • Line 2
    • Discount Method = Discount Price including tax
    • Discount Offer = $8.99
    • Qty Offer = 2

Related Topics