Import file format and CSV file example
This table displays the format that is required for the file. You must specify each header name in the same order as displayed.
| Element number | Header name | Data | Required element | Example |
|---|---|---|---|---|
| 1 | erpItemKey | ERP product number | Yes | 10-0251-0000 |
| 2 | customerItemKey | Customer product number | Yes | Customer Import3026 |
| 3 | generalLedgerAccountKey | General ledger account number | No | 1000 |
| 4 | lastPricePaid | Last price paid | No | 250 |
| 5 | activeStatus | True or false | No* | TRUE |
*By default, this value is set to TRUE.
This is an example of a CSV file that is accessed in a text editor. You can see the second row for an example of a comma that is used as a placeholder for an element that is not required.
erpItemKey,customerItemKey,generalLedgerAccountKey,lastPricePaid,activeStatus
10-0251-0000,Test Customer Import3026, 1000,250,TRUE
10-0251-0000,Test Customer Import3026,,,TRUE