CSV Import Templates - Pricing and Item Master
Help Article: Importing Data Templates
To ensure a smooth data import process for both Item Master and Market Cost Prices, please follow the instructions below.
Download Templates
Item Master Template: đź”— LINK
Market Cost Prices Template: đź”— LINK
âť—Important Import Information
The import process will overwrite all columns. It is crucial to include all necessary data.
Make sure you do not alter the structure of the template.
Fields to Import
Item Master Fields
| Field | Example | Notes |
|---|---|---|
| Code | 001 | Cannot contain Spaces |
| Description | Widget A | any text string containing characters |
| Delivery | 5 | Whole number only |
| m3 | 0.1 | can be decimals to 5 places |
| Weight | 1.5 | can be decimals to 3 places |
| Width | 10 | can be decimals to 3 places |
| Depth | 20 | can be decimals to 3 places |
| Height | 30 | can be decimals to 3 places |
Market Cost Prices Fields
| Field | Example |
|---|---|
| Market | EU |
| Code | 002 |
| Quantity | 100 |
| Cost | $5.00 |
| RRP | $10.00 |
Import Options
Update Existing: Select this option to update records that already exist in the database. Leave it unchecked to add new items without affecting existing ones.
Clear Existing Items before import: Check this option to delete all current records before the import. This is equivalent to manually removing items prior to the import.
After Importing
Once you click the 'Import' button, a summary will display, showing the count of imported, updated, and skipped records.
You can download the skipped records to using the export codes button
Updated on: 14/01/2024
Thank you!