(Customer-Specific) Articles
Master data for identifying articles. At Workist we distinguish between a customer-specific article list and a general article list. We use the same data structure in Workist for both article lists.
Workist typically requires 2 separate files if both a general and a customer-specific article list are to be provided.
Workist always requires at least one article list!
When providing a customer-specific article list in addition to the general article list, the following columns are usually sufficient: partition_id, article_id1, article_id2, (optional) article_id3
If unit conversion is to be implemented in Workist, the order_units and sales_units must be provided. See: Unit Conversion
Column Description
Red names are mandatory. Purple names are recommended data.
| # | Field Name | Status | Description |
|---|---|---|---|
| 1 | partition_id | Optional | Reference to a customer ID (client_id1). Limits the AI selection list and significantly increases the recognition rate. |
| 2 | article_id1 | Required | Primary unique identifier for an article, typically used for internal tracking. |
| 3 | article_id2 | Optional | Secondary identifier for an article, possibly for external systems or integrations. |
| 4 | article_id3 | Optional | Tertiary identifier, sometimes used for EAN codes. |
| 5 | description | Recommended | Text description of the article with detailed information about its properties and characteristics. |
| 6 | gross_price | Optional | The gross price of the article before deductions or discounts. |
| 7 | order_units | Recommended | Units in which the article is ordered. Can be a list or the row must be duplicated for each option. Controls which units are displayed in the workbench. |
| 8 | sales_units | Optional / Required for conversion | Units in which the article is sold. Required when unit conversion is relevant. Defines the unit in which the value is returned in the output. |
| 9 | sales_organisation | Optional | The sales organisation responsible for selling the article. |
| 10 | variants | Optional | Describes the configurable dimensions of an article (e.g. colour, size, variant). Structured list of dimensions. Not used for article matching/recognition, but serves as additional information for downstream systems. |
Format
Columns that are not needed can be omitted from the data export.
Example file name: article_list.csv
article_id1;article_id2;description;gross_price;order_units
ART001;4001234;Schrauben M8x20 100er Pack;12.50;["Packung","Karton"]
ART002;4005678;Dübel 8mm 50er Pack;5.90;["Packung"]
ART003;4009999;Bohrmaschine XL Pro;149.99;["Stück"]