Material CSV import specification - Sheets
version: 1.2
File format description
- coma separated values ","
- each value quoted by double quotes ""
- header row must be included
- one item per line
- text encoding: Unicode(UTF-8)
- numbers and currencies should be with no formatting and should include only decimal separator
- decimal separator: "."
Fields format description
| Field name | Value description | Adding material |
Updating material |
| substrate | text, possible options are ("Aluminium","Stainless Steel","Uncoated Steel","Coated Steel","Brass","Copper") | required |
required / not updated |
| alloy_ finish | required, text, one of the standard alloy designation e.g. "1050A / 3.0255 / Al99.5 - H24" with description of the finish in which this material is supplied | required |
required / not updated |
| density_kg_m3 |
required, number, in kg/m3 |
required |
required / not updated |
| thickness |
required, number, thickness of imported plate |
required |
required / not updated |
| width |
required, number, width of imported plate (the shorter dimension) |
required |
required / not updated |
| length |
required, number, length of imported plate (the longer dimension) |
required |
required / not updated |
| price_per_piece |
optional, number, individual price of the single plate, note: 0 is considered as valid price |
optional | optional |
| price_per_kg | optional, number, price per piece will be automatically calculated, this field is ignored if price_per_piece was not empty |
optional |
optional |
| price_date_valid |
optional, text, ISO date in format "YYYY-MM-DD" indicates until what date the price is considered as valid |
optional |
optional |
| item_description |
optional, text, additional text notes describing the item (max 512 characters) |
optional |
optional |
| external_id |
required, text, unique identifier in source database (ERP), this value will be used to match the item in external system and to update record if re-importing |
required |
optional |
