CSV Templates

Import item data and market cost prices in bulk from a CSV file. Learn where to download the templates, which fields to fill in and how each import option works.

Use these templates to import data into Item Master and Market Cost Prices. Follow the instructions below for a smooth import.

1

Download the template

Choose the Item Master or Market Cost Prices CSV template from the download links below.

2

Fill in the fields

Enter your data using the field tables below. Keep the template structure unchanged and include all necessary data, because the import overwrites all columns.

3

Choose the import options

Decide whether to update existing records. Only select Clear Existing Items before import if you intend to delete all current records before importing.

4

Import the CSV file

Click Import to process your prepared file with the selected options.

5

Review the summary

Check the imported, updated and skipped counts. Use export codes to download skipped records for review.

Prefer to automate updates? As an alternative to CSV imports, use the Mimeeq public Admin API to create or update records in bulk: Bulk upsert Item Masters or Bulk upsert Market Cost Prices. Each endpoint documents the required API key scope, request fields and update behaviour.

---

Download templates

• Item Master template: Download the Item Master template
• Market Cost Prices template: Download the Market Cost Prices template

Important import information:

• The import overwrites all columns, so include all necessary data.
• Do not change the structure of the template.

---

Fields to import

Item Master fields

Field	Example	Notes
Code	001	Cannot contain spaces
Commerce ID	42853746589754	ID of the external resource that matches the code (e.g. Shopify variant ID). Simple string
Delivery	5	Whole number only
m3	0.1	Can have up to 5 decimal places
Weight	1.5	Can have up to 3 decimal places
Width	10	Can have up to 3 decimal places
Depth	20	Can have up to 3 decimal places
Height	30	Can have up to 3 decimal places
Weight Unit	kg	One of kg/lb

🆕 Commerce ID is a new field that supports dynamic product bundles. It stores external e-commerce resource IDs (such as Shopify variant IDs) that can be used to map variants dynamically. Learn how to create bundles and map variants with Shopify in Shopify Add to Cart Methods.

Market Cost Prices fields

Field	Example
Market	EU
Code	002
Quantity	100
Cost	$5.00
RRP	$10.00

---

Import options

#	Option	What it does
1	Update Existing	Updates records that already exist in the database. Leave it unticked to add new items without affecting existing ones.
2	Clear Existing Items before import	Deletes all current records before the import. This is the same as removing the items manually before importing.

Import dialog with the Update Existing and Clear Existing Items before import options

---

After importing

When you click Import, a summary shows the number of imported, updated and skipped records.

You can download the skipped records using the export codes button.

---

Related articles

Item Master

Store delivery times, weights and dimensions for each item code.

Pricing Overview

Set up currencies, markets, price lists and quantity breaks.

Shopify Add to Cart Methods

Choose how configured products and bundles reach the cart.