Optional Dataset
15 min
these files are not mandatory, but they help improve the user experience and allow the tool to be customized for each client they also enable important features and functions, such as attribute based filtering and product family creation each table indicates the column name in the file, the data type, and a description primary keys (unique values) are highlighted in bold brands a comprehensive list of brands for each product can be provided as optional data it makes it possible to set brand specific constraints and use the brand as a filter brand name must be unique for each brand id variants such as ‘brand’, ‘brand’, ‘brand’, or ‘brand’ must appear in the data as a single brand with a single brand id column data type description product id string unique product identifier brand id string brand identifier brand name string name of the brand brands csv https //d3jwyy9rhyhl55 cloudfront net/v2/4158/contents/yrubap6vbq8muq5h/brands csv other options for export export brand id as a new column in the products file the brands file should contain only two fields brand id and brand name product brands limited csv https //d3jwyy9rhyhl55 cloudfront net/v2/4158/contents/jbpaw33huowmzuik/product brands limited csv brands only csv https //d3jwyy9rhyhl55 cloudfront net/v2/56396/contents/wdrxwhkfjjj1qyj2/brands only csv export brand id and brand name as new columns in the products file (see examples in the products section) product brands csv https //d3jwyy9rhyhl55 cloudfront net/v2/4158/contents/oyne4wede3yywhno/product brands csv suppliers a comprehensive list of suppliers for each product can be provided as an optional data input it is visible throughout the ui and allows for filtering by supplier supplier name must be unique for each supplier id variants such as ‘supplier’, ‘supplier’, ‘supplier’, or ‘suppllier’ must appear in the data as a single supplier with a single supplier id do you have a leading supplier for this product? if multiple suppliers exist, please select only the primary supplier for each zone column data type description product id string unique product identifier zone id string unique zone identifier supplier id string supplier identifier supplier name string name of the supplier suppliers csv https //d3jwyy9rhyhl55 cloudfront net/v2/4158/contents/wicqqycr17mi9gwl/suppliers csv other options for export export supplier id and supplier name in the actual prices file actual prices suppliers csv https //d3jwyy9rhyhl55 cloudfront net/v2/4158/contents/waas35xodvcyd4tg/actual prices suppliers csv export supplier id and supplier recommended sale price in the actual prices file in addition, export both supplier id and supplier name in the suppliers file suppliers only csv https //d3jwyy9rhyhl55 cloudfront net/v2/4158/contents/teu0njvyyzgkkjwu/suppliers only csv actual prices suppliers limited csv https //d3jwyy9rhyhl55 cloudfront net/v2/4158/contents/ghnvsytbuq4dbngp/actual prices suppliers limited csv product classes assigning products to different classes helps categorize them according to how clients perceive them or other attributes to be used in the pricing strategy setup this makes it possible to define the attributes per each product zone combination typical product classes include kvi, tail, organic, etc 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 product classes csv https //d3jwyy9rhyhl55 cloudfront net/v2/4158/contents/xqufvpf2olizn6co/product classes csv data checks the class name column should contain only values from a limited, predefined set of options other options for export export class id as a new column in the products file the product classes file should contain only two fields class id and class name product classes only csv https //d3jwyy9rhyhl55 cloudfront net/v2/4158/contents/cdiuvgitkw4cgpr2/product classes only csv product and product classes limited csv https //d3jwyy9rhyhl55 cloudfront net/v2/4158/contents/spqh4hgy9aekvtvp/product and product classes limited csv export class id and class name as new columns in the products file product and article classes csv https //d3jwyy9rhyhl55 cloudfront net/v2/4158/contents/x6oovoek5lfuicke/product and article classes csv segments a list of customer segments, if applicable the segment id is referenced in sales transactions history column data type description segment id string unique segment identifier name string name of the segment families a product family is a group of products that share identical or interdependent pricing for example, juices of the same brand and type but with different flavors should have the same price if no product family records exist, yieldigo provides a module within the tool to help create them this module includes a suggestion mechanism that can quickly propose product groups for approval to use this functionality, please ensure that the unit count and unit size fields are filled in the products file family ratio is derived from the combination of unit size and unit count in the products table if family ratio is not provided, all products within the same family are expected to have the same price column data type description product id string unique product identifier family id string family identifier optional columns unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type families csv https //d3jwyy9rhyhl55 cloudfront net/v2/4158/contents/ww6ndbsegnnlxq7c/families csv other options for export export family id and family ratio as new columns in the products file product families csv https //d3jwyy9rhyhl55 cloudfront net/v2/4158/contents/kzorjamqsnsjism9/product families csv promotions (planned) future promotional data to be used in the regular pricing process for example, to prevent regular price changes in a set period before a planned promotion or to set up constraints so that the regular prices are at least x% above the planned or most recent promotional price it is not needed in case the promotions planner module is used to plan the promotions directly in the integrated system in that case, the relations to regular price management are kept automatically 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 promotions csv https //d3jwyy9rhyhl55 cloudfront net/v2/4158/contents/dy844ro7lj3pgbye/promotions csv data checks the promo type id must correspond to the values defined in the promotion types table the promo price should generally be lower than the current regular price in the price list, if it is a discount promotion competitor prices a summary of competitors and their prices if available, historical data for e shops is also highly recommended how often do you collect and update competitor data? how long should the system keep these records, and for how long is a “collected” price considered valid? are you continuously sending all valid prices? which competitors do you consider the most relevant? 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 optional columns column data type description url string the url links directly to the competitor’s price on their website detail string any additional information competitors csv https //d3jwyy9rhyhl55 cloudfront net/v2/4158/contents/dn6rmnrbynqfvh89/competitors csv data checks regular competitor prices should approximately correspond to the regular sale price locked products a list of products that should not be repriced these products are locked and excluded from the pricing process and will not be exported typical examples include items restricted by law (e g , alcohol, tobacco, medicines) or products with the price printed on the cover (e g , magazines) if the products are identical across all zones, the zone id column is not required column data type description product id string product identifier zone id string the price must be exported for the zone, as the system plans prices at the zone level locked products csv https //d3jwyy9rhyhl55 cloudfront net/v2/4158/contents/arhta7l6xrri7ga4/locked products csv product architecture allows pricing teams to define product ladders (such as good–better–best ) as reusable rules that enforce minimum and maximum percentage gaps between levels based on item or unit price, applied across custom defined product groups it provides item level visibility and alerts when a rule cannot be met once the product architecture , architecture groups , and architecture levels are set up manually in the application, the assigned product ids can be imported automatically the names of the product architecture , architecture groups , and architecture levels must exactly match those defined in the application column data type description product id string unique product identifier architecture name string architecture identifier architecture group name string architecture group identifier architecture level name string architecture level identifier product architecture csv https //d3jwyy9rhyhl55 cloudfront net/v2/4158/contents/qb1wnfochz3ocgn4/product architecture csv rounding rules please provide the rounding rules using the rounding rules xlsx template rounding rules xlsx https //d3jwyy9rhyhl55 cloudfront net/v2/4158/contents/ewuvx5vziwjppyrm/rounding rules xlsx logo you can provide your logo for display in the application; it will appear in the upper left corner logo requirements format https //en wikipedia org/wiki/svg (scalable vector graphics, svg ) so the app can scale the logo automatically size constraint the logo displays in a 24×24 px area avoid long text only logos—they’ll be hard to read at this size background use a transparent background if you only have png/jpeg, you can use an https //www google com/search?q=online+svg+converter to create an svg