Multibuy Module Dataset
3 min
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 unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type bulk offers csv https //d3jwyy9rhyhl55 cloudfront net/v2/4158/contents/ao6ad4kgfqsn8nts/bulk offers csv 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