Multibuy Module Dataset

the required dataset applies only to the multibuy pricing module it must include the list of products that offer multibuy pricing multibuy prices are proposed in a way that maintains an optimal proportion between tiers each table indicates the column name in the file, the data type, and a description primary keys (unique values) are highlighted in bold bulk offers a complete list of all bulk offers must be provided this dataset should include all essential information required to define product bulks, specific tiers, prices, and the validity period of each offer for bulk offers data, we distinguish between two types historical data – one time export of the entire three year history into a single file named bulk offers history csv daily incremental data – prices from the previous day must be exported in the file bulk offers csv column data type description bulk offer id string bulk offer identifier product id string product identifier zone id string zone identifier can be set to 1 or all in the case of global bulk offers date from date start date of bulk price offer date to date end date of the bulk price offer this field may be left empty to indicate that the bulk offer has no end date bulk tier limit decimal(2) quantity tier limit for the discounted price price decimal(2) bulk price of one unit of the product for specific bulk tier limit discount type integer 0/1/2 0 percentual (i e 5% down) 1 absolute (i e 5€ down) 2 fixed (i e 5€) data checks the higher tier limit must always have a lower price than the base price or any lower tiers the base price for every bulk offer × product is defined as the price for bulk tier limit = 1 the maximum number of tiers is 6 (the base tier plus up to 5 additional tiers) sales the standard sales file will be extended with one additional column to indicate the tier in which the product was sold, if the transaction was part of a multibuy offer can all multibuy offers be identified in the sales data? their price type should always be set to 6 does the sales file include shelf price information? does the sales file include bulk tier limit information? if yes, do multibuy limits change over time? column data type description bulk tier limit decimal(2) quantity tier limit that defines when the discounted price applies