ProductID or ProductIDTranslation
​
​

Amount or Case Amount
​
​
​

PromotionID or PromotionIDTranslation to link to an existing promotion, or be able to easily update imported promotions in bulk
​
​

Promotion Type to help dictate what type of promotion should be used
​
​

Market
​
​

Participation
​
​

Min Purchase (Quantity necessary for quantity discount)
​
​

Min Product Count
​
​

Start Date
​
​

End Date
​
​

Salesman Override
​
​

Promotion Name

Used to import new pricing or update full promotion records
​
​

Will create products that do not already exist in the system if ProductIDTranslation is mapped
​
​

Will create promotions, promotion products, markets, zones, and promotion customers as needed
​
​

Used to override invoice transactions to a specific promotion
​
​
​

If using PromotionEDBL to update existing pricing, please include all PromotionProducts of the Promotion. PromotionProducts that are not included will be deleted from the Promotion.
​
​

Break the data down by promotion type and import each promotion type separately.
​
​

If importing new promotions, use PromotionIDTranslation to help easily link on promotions in the system.
​
​

If updating existing promotions, map the PromotionID.
​
​

Import initially using markets and later use a table import to import zones to make it simpler to initially map the import.

Pricing Imports
​
​

Pricing Updates. Include all PromotionProducts of the Promotion. PromotionProducts that are not included will be deleted from the Promotion
​
​

The minimum requirement for the Promotions EDBL is a Product column. As long as there is a Product in the source file, the Promotions EDBL can run successfully, and without a Product, the EDBL reports an error.
​
​

When Promotion ID or Promotion ID Translation is mapped, and the EDLB can match an existing Promotion based on it, that Promotion and its related Promotions Products records will get updated.
​
​

When Promotion ID or Promotion ID Translation is not mapped, but PromotionName, Condition, PromotionType, MarketID, StartDate, and EndDate are mapped, those fields will be used to match an existing Promotion ID, and if found, that Promotion and its related Promotions Products records get updated.
​
​

When no existing Promotions record can be match through any of the above conditions, a new Promotions records gets created, and the related tables' records are created or updated accordingly.
​
​
​

Overriding invoice transactions to a specific promotion