--- title: Optional Dataset slug: optional-dataset createdAt: 2026-03-18T16:36:32.000Z --- 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. :::hint{type="info"} 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. :::hint{type="info"} 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 | ::File{src="https://api.archbee.com/api/presign/xX31HJQLjJcLNeK2EhfOl/qNJEoDYG8DVUuFDHGCpsR-20260323-142249.csv" label="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. ::File{src="https://api.archbee.com/api/presign/xX31HJQLjJcLNeK2EhfOl/mOGzCiOvCXmyj_0pTYagM-20260323-142249.csv" label="product_brands_limited.csv"} ::File{src="https://api.archbee.com/api/presign/xX31HJQLjJcLNeK2EhfOl/ENzNkcUD7Tx1hpWdbe9Mo-20260323-142249.csv" label="brands_only.csv"} Export brand\_id and brand\_name as new columns in the products file (see examples in the Products section). ::File{src="https://api.archbee.com/api/presign/xX31HJQLjJcLNeK2EhfOl/EwV-Ok8xG2BVQd5sCOpWe-20260323-142249.csv" label="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. :::hint{type="info"} 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 | ::File{src="https://api.archbee.com/api/presign/xX31HJQLjJcLNeK2EhfOl/kAcjg0U7PgorDrmI_VeWD-20260323-142250.csv" label="suppliers.csv"} **Other Options for Export** Export supplier\_id and supplier\_name in the actual\_prices file. ::File{src="https://api.archbee.com/api/presign/xX31HJQLjJcLNeK2EhfOl/50JwYHnDu18MTUGKSK4qL-20260323-142249.csv" label="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. ::File{src="https://api.archbee.com/api/presign/xX31HJQLjJcLNeK2EhfOl/FIrFbBS2S3OFbHA-1gqL1-20260323-142250.csv" label="suppliers_only.csv"} ::File{src="https://api.archbee.com/api/presign/xX31HJQLjJcLNeK2EhfOl/mC8gJsBToBm1OCIU-n6Xu-20260323-142249.csv" label="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. | **Column** | **Data type** | **Description** | | --------------- | ------------- | ------------------------------------------------------------------- | | **product\_id** | string | Unique product identifier | | class\_id | string | Class identifier | | class\_name | string | Name of the class | | zone\_id | string | Zone identifier.
Leave empty if the rule applies to all zones. | ::File{src="https://api.archbee.com/api/presign/xX31HJQLjJcLNeK2EhfOl/TK9aNP2TcVkfkA9SToF_Q-20260323-142249.csv" label="product_classes.csv"} :::hint{type="warning"} **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. ::File{src="https://api.archbee.com/api/presign/xX31HJQLjJcLNeK2EhfOl/Gyp7h82csxilqBdO_IZr7-20260323-142249.csv" label="product_classes_only.csv"} ::File{src="https://api.archbee.com/api/presign/xX31HJQLjJcLNeK2EhfOl/E57BaclCeVd54UbCt36L1-20260323-142249.csv" label="product_and_product_classes_limited.csv"} Export class\_id and class\_name as new columns in the products file. ::File{src="https://api.archbee.com/api/presign/xX31HJQLjJcLNeK2EhfOl/cN-ApqTQ9-IdbC3ZR7uMz-20260323-142249.csv" label="product_and_article_classes.csv"} ## Segments A list of customer segments, if applicable. The segment\_id is referenced in the sales transaction 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. ![](https://d3jwyy9rhyhl55.cloudfront.net/v2/4158/contents/Q2DTp325NjjocVvI/mw1920_mw1920_families.png "Families") :::hint{type="info"} 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** | **Column** | **Data Type** | **Description** | | ------------- | ------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | family\_ratio | decimal | The ratio of products within the same family.
If the products in a family are identical, the ratio must be the same.
If the products differ in size, the ratio defines their proportion. | ::File{src="https://api.archbee.com/api/presign/xX31HJQLjJcLNeK2EhfOl/Rznw5tY5FjrxR0G6IiskK-20260323-142249.csv" label="families.csv"} **Other Options for Export** Export family\_id and family\_ratio as new columns in the products file. ::File{src="https://api.archbee.com/api/presign/xX31HJQLjJcLNeK2EhfOl/iVts2vXe5ms1NG8n012Oa-20260323-142249.csv" label="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 if the Promotions Planner module is used to plan promotions directly in the integrated system. In that case, the relations to Regular Price Management are kept automatically. | **Column** | **Data type** | **Description** | | ---------------------- | ------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | **planned\_promo\_id** | string | Identifier of a planned promotion | | **zone\_id** | string | Pricing zone where the promotion is valid.
Use the value -1 if the promotion is always valid for all zones. | | **product\_id** | string | Product identifier | | promo\_type\_id | string | Identifier of a Promotion Type.
Relates to the definition in the Promotion Types table. | | valid\_from | date | First day of the promotion. | | valid\_to | date | Last day of the promotion. | | promo\_price | decimal | Promotional price, incl. VAT | | discount\_promotion | bool | 0/1 indicator specifying whether the promotion is a discount.
A value of 0 means the promotion is not discount-based (e.g., a free gift), while 1 indicates a discount promotion. | ::File{src="https://api.archbee.com/api/presign/xX31HJQLjJcLNeK2EhfOl/Bn-hY5u0M6NoxrmukT-EN-20260323-142249.csv" label="promotions.csv"} :::hint{type="warning"} **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. :::hint{type="info"} 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? ::: | **Column** | **Data type** | **Description** | | ----------------------- | ------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | **product\_id** | string | Product identifier  | | **zone\_id** | string | Use this field only if the competitor’s price is valid for specific zones. Leave it empty if the price applies to all zones. | | **competitor\_id** | string | Competitor identifier | | **date** | date | Date when the price was collected.
If this field is not provided, the import date will be used as the validity date. | | competitor\_price | decimal | Price of the competitor, incl. VAT | | competitor\_price\_type | integer | 0 - Regular standard price
1 - Regular individual price (VIP customer discount, Golden Card)
2 - Global promotion (discounted price available to all customers - leaflets, special offers)
99 - Other
The default value is 0. | | competitor\_name | string | Name of the competitor | **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 | ::File{src="https://api.archbee.com/api/presign/xX31HJQLjJcLNeK2EhfOl/UsFfSjc_9EF0103GO3cs7-20260323-142249.csv" label="competitors.csv"} :::hint{type="warning"} **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). :::hint{type="info"} 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. | ::File{src="https://api.archbee.com/api/presign/xX31HJQLjJcLNeK2EhfOl/KRuCuViHyapCBkr-1xr2s-20260323-142249.csv" label="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. :::hint{type="info"} 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 | **Optional Columns** | **Column** | **Data type** | **Description** | | ------------- | ------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | min\_distance | integer | Minimum distance configured for the specified Architecture Group Level. If omitted together with
max\_distance, the default defined for the Architecture Level is used. | | max\_distance | integer | Maximum distance configured for the specified Architecture Group Level. Can only be provided when
min\_distance is also specified. | :::hint{type="warning"} **Data Checks** Min/Max distance values must be greater than 0. All products belonging to the same combination of **Architecture + Architecture Group + Architecture Level** must have identical distance values. If different values are provided for the same Group Level, the affected Group Level assignments are not imported. ::: ::File{src="https://api.archbee.com/api/presign/xX31HJQLjJcLNeK2EhfOl/jTCPzVXxl_OJnqncheBwG_product-architecture.csv" label="product_architecture.csv" isUploading="false"} ## Rounding Rules Please provide the rounding rules using the rounding\_rules.xlsx template. ::File{src="https://api.archbee.com/api/presign/xX31HJQLjJcLNeK2EhfOl/8gmILGPkx1a6Lh2vfoHRn-20260323-142250.xlsx" label="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: [SVG](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 for colored logos. If the logo is black, provide it with a **white** background to ensure sufficient contrast and visibility. :::hint{type="info"} If you only have PNG/JPEG, you can use an [online converter](https://www.google.com/search?q=online+svg+converter) to create an SVG. :::