> For the complete documentation index, see [llms.txt](https://help.mimeeq.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.mimeeq.com/pricing-and-codes/pricing-setup/csv-templates.md).

# 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.

{% stepper %}
{% step %}

#### Download the template

Choose the Item Master or Market Cost Prices CSV template from the download links below.
{% endstep %}

{% step %}

#### 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.
{% endstep %}

{% step %}

#### 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.
{% endstep %}

{% step %}

#### Import the CSV file

Click **Import** to process your prepared file with the selected options.
{% endstep %}

{% step %}

#### Review the summary

Check the imported, updated and skipped counts. Use **export codes** to download skipped records for review.
{% endstep %}
{% endstepper %}

{% hint style="info" %}
**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](https://help.mimeeq.com/developers/item-masters/bulk-upsert-item-masters) or [Bulk upsert Market Cost Prices](https://help.mimeeq.com/developers/market-cost-prices/bulk-upsert-market-cost-prices). Each endpoint documents the required API key scope, request fields and update behaviour.
{% endhint %}

***

## Download templates

* **Item Master template:** [Download the Item Master template](https://d1bd8jihtqzqs4.cloudfront.net/help_articles/Item%20Master%20Import%20Template.csv)
* **Market Cost Prices template:** [Download the Market Cost Prices template](https://d1bd8jihtqzqs4.cloudfront.net/help_articles/MCP%20ImportTemplate.csv)

{% hint style="warning" %}
**Important import information:**

* The import overwrites all columns, so include all necessary data.
* Do not change the structure of the template.
  {% endhint %}

***

## Fields to import

### Item Master fields

<table><thead><tr><th width="163.796875">Field</th><th width="127.33203125">Example</th><th>Notes</th></tr></thead><tbody><tr><td><strong>Code</strong></td><td>001</td><td>Cannot contain spaces</td></tr><tr><td><strong>Commerce ID</strong></td><td>42853746589754</td><td>ID of the external resource that matches the code (e.g. Shopify variant ID). Simple string</td></tr><tr><td><strong>Delivery</strong></td><td>5</td><td>Whole number only</td></tr><tr><td><strong>m3</strong></td><td>0.1</td><td>Can have up to 5 decimal places</td></tr><tr><td><strong>Weight</strong></td><td>1.5</td><td>Can have up to 3 decimal places</td></tr><tr><td><strong>Width</strong></td><td>10</td><td>Can have up to 3 decimal places</td></tr><tr><td><strong>Depth</strong></td><td>20</td><td>Can have up to 3 decimal places</td></tr><tr><td><strong>Height</strong></td><td>30</td><td>Can have up to 3 decimal places</td></tr><tr><td><strong>Weight Unit</strong></td><td>kg</td><td>One of kg/lb</td></tr></tbody></table>

{% hint style="info" %}
**🆕 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](/commerce-and-integrations/shopify/add-to-cart.md).
{% endhint %}

### Market Cost Prices fields

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

***

## Import options

<table><thead><tr><th width="50.28515625">#</th><th>Option</th><th>What it does</th></tr></thead><tbody><tr><td>1</td><td><strong>Update Existing</strong></td><td>Updates records that already exist in the database. Leave it unticked to add new items without affecting existing ones.</td></tr><tr><td>2</td><td><strong>Clear Existing Items before import</strong></td><td>Deletes all current records before the import. This is the same as removing the items manually before importing.</td></tr></tbody></table>

![Import dialog with the Update Existing and Clear Existing Items before import options](https://621103948-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsqWfi8ifBhTdkvf1vOlY%2Fuploads%2F85lby3XpqGRWXs4MSCCM%2Fitem-master-article-2_jqufm3.png?alt=media)

***

## After importing

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

{% hint style="success" %}
You can download the skipped records using the **export codes** button.
{% endhint %}

***

## Related articles

<table data-view="cards"><thead><tr><th></th><th></th><th data-hidden data-card-target data-type="content-ref"></th></tr></thead><tbody><tr><td><strong>Item Master</strong></td><td>Store delivery times, weights and dimensions for each item code.</td><td><a href="/pricing-and-codes/pricing-setup/item-master.md">Item Master</a></td></tr><tr><td><strong>Pricing Overview</strong></td><td>Set up currencies, markets, price lists and quantity breaks.</td><td><a href="/pricing-and-codes/pricing-setup/pricing-overview.md">Pricing Overview</a></td></tr><tr><td><strong>Shopify Add to Cart Methods</strong></td><td>Choose how configured products and bundles reach the cart.</td><td><a href="/commerce-and-integrations/shopify/add-to-cart.md">Shopify Add to Cart Methods</a></td></tr></tbody></table>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://help.mimeeq.com/pricing-and-codes/pricing-setup/csv-templates.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.