Articles on: Pricing & Codes

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

FieldExampleNotes
Code001Cannot contain Spaces
DescriptionWidget Aany text string containing characters
Delivery5Whole number only
m30.1can be decimals to 5 places
Weight1.5can be decimals to 3 places
Width10can be decimals to 3 places
Depth20can be decimals to 3 places
Height30can be decimals to 3 places


Market Cost Prices Fields

FieldExample
MarketEU
Code002
Quantity100
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.

Import Options

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

Was this article helpful?

Share your feedback

Cancel

Thank you!