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
âť—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 |
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: 05/01/2025
Thank you!