---
title: How to import SKUs in SUPPLY
description: How to use a template to import or update multiple SKUs into SUPPLY
---
[Skip to content](https://support.innovint.us/hc/en-us/how-to-import-skus-in-supply#main-content)
[Submit a help ticket](https://support.innovint.us/hc/en-us/kb-tickets/new?hsLang=en)
![InnoVintSupportCenter - header.png\]](https://support.innovint.us/hs-fs/hubfs/InnoVintSupportCenter%20-%20header.png?width=300&height=22&name=InnoVintSupportCenter%20-%20header.png)
Open main navigation
Close main navigation
- [Submit a help ticket](https://support.innovint.us/hc/en-us/kb-tickets/new)
How can we help you today?
- There are no suggestions because the search field is empty.
1. [Support Center](https://support.innovint.us/hc/en-us?hsLang=en)
2. [SUPPLY](https://support.innovint.us/hc/en-us/supply?hsLang=en)
3. [Getting Started with SUPPLY](https://support.innovint.us/hc/en-us/supply?hsLang=en#getting-started-with-supply)
# How to import SKUs in SUPPLY
Create SKUs in bulk, or update attributes on many SKUs at once, by uploading a single CSV or XLSX file.
This article covers:
- [What are the SKU importers?](https://support.innovint.us/hc/en-us/how-to-import-skus-in-supply#what)
- [Before you start](https://support.innovint.us/hc/en-us/how-to-import-skus-in-supply#before)
- [How to import new SKUs](https://support.innovint.us/hc/en-us/how-to-import-skus-in-supply#how)
- [How to import SKU updates](https://docs.google.com/document/d/1cEfMNzS6wLAQ25kfUMtEqXbMJfFCT7m2EhxBFuIO5Rk/edit#import-sku-updates)
- File specifications
- [Import new SKUs](https://support.innovint.us/hc/en-us/how-to-import-skus-in-supply#file_spec_new)
- [Import SKU updates](https://support.innovint.us/hc/en-us/how-to-import-skus-in-supply#file_spec_update)
- [Tracking imported SKUs and changes](https://support.innovint.us/hc/en-us/how-to-import-skus-in-supply#tracking)
- [Troubleshooting the import](https://support.innovint.us/hc/en-us/how-to-import-skus-in-supply#troubleshooting)
- [FAQ](https://support.innovint.us/hc/en-us/how-to-import-skus-in-supply#faq)
### What are the SKU importers?
Creating SKUs one at a time with the [**Add SKU**](https://support.innovint.us/hc/en-us/how-to-add-skus?hsLang=en) form works well for a few SKUs, but it takes a long time when you're setting up your full catalog or updating prices across your portfolio. SUPPLY has two importers for this, both on the **Add SKU** button in the SKU Explorer:
SUPPLY has two importers:
- **Import new SKUs:** Create many new SKUs at once, with all their attributes (color, style, format, group, tax class, stage, weight, price, COGS).
- **Import SKU updates:** Change attributes on SKUs that already exist, such as rolling out new prices or COGS, adding weights, updating stages, or renaming or re-coding SKUs.
Choose your importer, download the sample file, fill it in, upload it, fix any errors SUPPLY flags, and import.
📌 **Commerce7 users:** The SKU importers do **not** create, change or remove links between SUPPLY SKUs and Commerce7 products. After importing new SKUs, link each one to its C7 product manually. See [SUPPLY + Commerce7 Integration](https://support.innovint.us/hc/en-us/supply-commerce7-integration?hsLang=en).
### Before you start
- **Always start from the sample file:** Each importer has its own sample XLSX file (**Download sample xlsx file** on the importer screen). The sample file has dropdowns for the pick-list columns and shows required columns in **bold**, so it's the easiest way to get your headers and values right.
- **Know what can't be changed later:** **Format**, **Group name** and **Tax class** can't be edited after a SKU is created, and that includes edits made through the importer. Check these three columns carefully before you run **Import new SKUs**.
- **Onboard inventory after importing SKUs:** Importing SKUs creates the SKUs only. It doesn't add any inventory. Once your SKUs are in, use [Onboard Inventory](https://support.innovint.us/hc/en-us/how-to-onboard-inventory-in-supply?hsLang=en) to load your starting on-hand quantities.
### How to import new SKUs
1. Go to the **SKU Explorer** (wine bottle icon in the left-hand navigation).
2. Click the **caret (▾)** on the right side of the **+ Add SKU** button in the top right corner, then select **Import new SKUs**. *Clicking the main part of the button still opens the regular Add SKU form.*
3. Click **Download sample xlsx file** and fill in one row per SKU. The sample file will provide instructions to help fill out the template. See [File specifications: Import new SKUs](https://docs.google.com/document/d/1cEfMNzS6wLAQ25kfUMtEqXbMJfFCT7m2EhxBFuIO5Rk/edit#specs-new) below.
4. Back on the importer screen, click **Choose file** and select your completed CSV or XLSX file.
5. SUPPLY checks the file and lists any errors, row by row, in the validation table.
❌ Delete the instruction lines before saving your file!
6. Fix the errors in your file, save it, and click **Choose file** again to re-check it.
7. When the file passes validation, click the green **Import SKUs** button to create your SKUs.
Your new SKUs appear right away in the SKU Explorer, the Inventory Explorer and the SKU pickers used in actions and orders.
If your account uses the QuickBooks Online integration, they're also added to **Settings \> QuickBooks mapping \> SKU mapping**.
Importing SKUs creates new SKUs in your account - it does not add inventory, or link SKUs to Commerce7.
### How to import SKU updates
1. Go to the **SKU Explorer**.
2. Click the **caret (▾)** on the **+ Add SKU** button and select **Import SKU updates**.
3. Click **Download sample xlsx file**. Enter one row per SKU you want to change, with that SKU's current code in the **Existing SKU code** column and only the values you want to change in the other cells. See [File specifications: Import SKU updates](https://docs.google.com/document/d/1cEfMNzS6wLAQ25kfUMtEqXbMJfFCT7m2EhxBFuIO5Rk/edit#specs-updates) below.
4. Click **Choose file** and select your completed CSV or XLSX file.
5. Review the validation table. Fix any errors in your file, save it, and click **Choose file** again.
6. When the file passes validation, click the green **Import updates** button to apply your updates.
Updated values show up right away everywhere that attribute is displayed, including the SKU Explorer, the SKU details page, the Inventory Explorer and the SKU pickers.
### File specifications
#### Import new SKUs
**General rules**
- Always use the sample file to get started. Required column headers are shown in **bold**.
- Headers go in Row 1, and your SKU data starts in Row 2. Don't leave blank rows between them.
- Enter one SKU per row.
- Text values are **not** case-sensitive (for example, red, RED and Red all match the color **Red**). The one exception is **SKU name**, which is saved exactly as you type it.
- Weight, price and COGS values accept numbers with up to **2 decimal places**. Zero is allowed. Values with more than 2 decimal places are flagged as errors.
- There's no column for items per group. SUPPLY works that out from the **Format** and **Group name** you choose, the same way the Add SKU form does.
- Columns SUPPLY doesn't recognize are ignored.
- Each SKU code must be new. If a code already exists in SUPPLY, that row is flagged. If the same new code appears on more than one row, the first row is created and the later rows are flagged.
**Columns** \[CONFIRM: exact header names against the "Sample Create SKU import file" before publishing\]
| **Column** | **Required?** | **Notes** |
| --- | --- | --- |
| **SKU code** | Required | Must be unique. Letters, numbers, dashes and underscores only, with a 50-character limit. Accented characters (such as ü or ã) aren't accepted. |
| SKU name | Optional | Up to 250 characters. Saved exactly as entered. If left blank, the SKU shows *No name*. |
| **Color** | Required | Red, white, rosé, orange. Choose from the dropdown in the sample file. |
| **Style** | Required | Still or Sparkling. Choose from the dropdown. |
| **Format** | Required | Bottle format (for example, 750mL Bottle). Choose from the dropdown. ⚠️ Can't be changed after creation. |
| **Stage** | Required | Choose from the dropdown (for example, Pre-release, Released, Library). |
| **Tax class** | Required | Choose from the dropdown. ⚠️ Can't be changed after creation. |
| **Group name** | Required | The packaging for the format, such as a 6-pack or a case. Choose from the dropdown. ⚠️ Can't be changed after creation. |
| Weight per item (lbs) | Optional | Used to calculate BOL weight when a BOL includes single bottles. Two decimals. |
| Weight per group (lbs) | Optional | Include the weight of the group, including box or inserts. It isn't calculated from bottle weight. Two decimals. |
| Price per item | Optional | Fills in the item price automatically when the SKU is added to an order. Two decimals. |
| Price per group | Optional | Fills in the group price automatically when the SKU is added to an order. Two decimals. |
| COGS per item | Optional | COGS per case is calculated from this value. Two decimals. |
| QuickBooks SKU name | Optional | Only used if your account has the SUPPLY + QuickBooks Online integration. Otherwise it's ignored. If left blank, the QuickBooks name stays blank on the SKU mapping page. See [SUPPLY + QuickBooks Online Invoicing](https://support.innovint.us/hc/en-us/supply-quickbooks-online-invoicing?hsLang=en) for the category format. |
#### Import SKU updates
**General rules**
- Use the sample file to get started. Required column headers are shown in **bold**.
- Headers go in Row 1, and data starts in Row 2.
- **Only fill in what you want to change.** A blank cell, or a column that isn't in your file, leaves that value as it is. For example, a file with just **Existing SKU code** and **Price per item** updates item prices and nothing else. Blank cells will not override current values.
- Each row must change at least one value. A row with only the Existing SKU code will trigger an error.
- Weight, price and COGS values accept numbers with up to **2 decimal places**. Zero is allowed. Values with more than 2 decimal places are flagged as errors.
- Columns SUPPLY doesn't recognize are ignored.
- **Format, Group name and Tax class columns aren't allowed.** These can't be edited after a SKU is created, so a file that contains any of these columns is rejected. Delete those columns and upload the file again. To correct one of these attributes, delete the SKU and re-create it (see [How to Archive or Delete SKUs in SUPPLY](https://support.innovint.us/hc/en-us/how-to-archive-or-delete-skus?hsLang=en)).
| **Column** | **Required?** | **Notes** |
| --- | --- | --- |
| **Existing SKU code** | Required | The SKU's current code. This is how SUPPLY finds the SKU to update. It must match an existing SKU. |
| New SKU code | Optional | Enter a new code only if you want to **change** the SKU's code. Leave blank to keep the current code. Same rules as a new SKU code (unique, 50 characters, letters, numbers, dashes and underscores). |
| SKU name | Optional | New name, saved exactly as entered. |
| Color | Optional | Red, white, rosé, orange. Choose from the dropdown in the sample file. |
| Style | Optional | Still or Sparkling. Choose from the dropdown. |
| Stage | Optional | Choose from the dropdown (for example, Pre-release, Released, Library). |
| Weight per item / Weight per group | Optional | Used to calculate BOL weight. Two decimals. |
| Price per item / Price per group | Optional | Fills in the price automatically when the SKU is added to an order. Two decimals. |
| COGS per item | Optional | COGS per case is calculated from this value. Two decimals. |
📌 **Changing a SKU code:** When you enter a new code in the **SKU code** column, the SKU keeps all its inventory and history. Only the code changes, and the change is recorded in the SKU's history.
📌 **QuickBooks names:** The update importer doesn't change QuickBooks SKU names. To update those in bulk, use the export/import option on **Settings \> QuickBooks mapping \> SKU mapping**. See [SUPPLY + QuickBooks Online Invoicing](https://support.innovint.us/hc/en-us/supply-quickbooks-online-invoicing?hsLang=en).
### Tracking imported SKUs and changes
Every SKU created or changed by an import is labeled in the **History** section of its [SKU Details Page](https://support.innovint.us/hc/en-us/sku-details-page?hsLang=en):
- **New SKUs:** The *Add SKU* entry shows **via import** with the file name below the SKU code line.
- **Updated SKUs:** The *Edit SKU* entry shows one line for each attribute that changed, with **via import** and the file name below.
- SKUs added or edited by hand don't show the "via import" line, so you can always tell how a change was made.
### Troubleshooting the import
**Seeing red?** Before anything is imported, SUPPLY checks every row: headers, required values, dropdown values, number formats, duplicate codes, and (for updates) whether each Existing SKU code exists. Row-level error messages match the ones you'd see if you entered the same value in the Add SKU form or Edit SKU window.
Any highlighted error must be fixed **in your file**. Save the file, then click **Choose file** again to re-check it.
Common reasons a file or row is flagged:
- The file isn't saved as a CSV or XLSX. Re-save it in one of these formats.
- The file is empty, or has headers but no data rows.
- A required column is missing, or a required cell is blank. Required columns are **bold** in the sample file.
- A value doesn't match a dropdown option (for example, a color that doesn't exist in SUPPLY). Use the dropdowns in the sample file.
- A weight, price or COGS value has more than 2 decimal places, or isn't a number.
- **Import new SKUs:** the SKU code already exists in SUPPLY, or appears more than once in the file.
- **Import new SKUs:** the SKU code has spaces, accents or symbols other than dashes and underscores, or is over 50 characters.
- **Import SKU updates:** the Existing SKU code doesn't match any SKU in SUPPLY.
- **Import SKU updates:** the new SKU code is already used by another SKU.
- **Import SKU updates:** the file includes a **Format**, **Group name** or **Tax class** column. Delete these columns.
- **Import SKU updates:** a row has an Existing SKU code but nothing to update.
- You haven't deleted the instructions on the sheet.
### FAQ
**Q: Can I use the importer to add inventory to my SKUs?**
*A: No. The importers only create and update SKUs. To load starting inventory, use [Onboard Inventory](https://support.innovint.us/hc/en-us/how-to-onboard-inventory-in-supply?hsLang=en). For new inventory from bottling or bond-to-bond transfers, use [Add Inventory](https://support.innovint.us/hc/en-us/how-to-add-inventory?hsLang=en).*
**Q: I imported a SKU with the wrong format, group or tax class. Can I fix it with Import SKU updates?**
*A: No. These three attributes can't be edited after creation, by import or by hand. Delete the SKU (if it has no inventory activity) and import it again with the correct values. See [How to Archive or Delete SKUs in SUPPLY](https://support.innovint.us/hc/en-us/how-to-archive-or-delete-skus?hsLang=en).*
**Q: Can I clear a value, such as removing a price, with the update importer?**
*A: No. A blank cell means "don't change this value." To remove a value, edit the SKU on its SKU details page.*
**Q: Will importing link my SKUs to Commerce7?**
*A: No. The importers never create, change or remove Commerce7 product links, including when you change a linked SKU's code or name. Link new SKUs to C7 products from the SKU details page (**More \> Edit C7 product**).*
**Q: Does Import SKU updates change past actions or reports?**
*A: Updated attributes show right away everywhere that attribute is displayed. The change itself is recorded in the SKU's History with the "via import" label.*
**Q: I have a CSV template for SKUs from another system. Can I use it?**
*A: Yes, if the headers match the SUPPLY sample file. The simplest approach is to paste your data into the sample file, so you get the dropdowns and correct headers.*
- [New to InnoVint](https://support.innovint.us/hc/en-us/new-to-innovint?hsLang=en#main-content)
- [Accessing InnoVint](https://support.innovint.us/hc/en-us/new-to-innovint?hsLang=en#accessing-innovint)
- [Settings - MAKE, GROW & FINANCE](https://support.innovint.us/hc/en-us/new-to-innovint?hsLang=en#settings-make-grow-finance)
- [Getting Started - MAKE, GROW & FINANCE](https://support.innovint.us/hc/en-us/new-to-innovint?hsLang=en#getting-started-make-grow-finance)
- [MAKE](https://support.innovint.us/hc/en-us/make?hsLang=en#main-content)
- [Dashboard & Calendar](https://support.innovint.us/hc/en-us/make?hsLang=en#dashboard-calendar)
- [Lots](https://support.innovint.us/hc/en-us/make?hsLang=en#lots)
- [Vessels](https://support.innovint.us/hc/en-us/make?hsLang=en#vessels)
- [Work Orders](https://support.innovint.us/hc/en-us/make?hsLang=en#work-orders)
- [Recording Actions](https://support.innovint.us/hc/en-us/make?hsLang=en#recording-actions)
- [Movement Actions](https://support.innovint.us/hc/en-us/make?hsLang=en#movement-actions)
- [Topping](https://support.innovint.us/hc/en-us/make?hsLang=en#topping)
- [Analysis](https://support.innovint.us/hc/en-us/make?hsLang=en#analysis)
- [Analysis Reports](https://support.innovint.us/hc/en-us/make?hsLang=en#analysis-reports)
- [Additions](https://support.innovint.us/hc/en-us/make?hsLang=en#additions)
- [Case Goods in MAKE](https://support.innovint.us/hc/en-us/make?hsLang=en#case-goods-in-make)
- [Dry Goods](https://support.innovint.us/hc/en-us/make?hsLang=en#dry-goods)
- [Vineyards](https://support.innovint.us/hc/en-us/make?hsLang=en#vineyards)
- [Reporting](https://support.innovint.us/hc/en-us/make?hsLang=en#reporting)
- [Compliance](https://support.innovint.us/hc/en-us/make?hsLang=en#compliance)
- [Tags & Notes](https://support.innovint.us/hc/en-us/make?hsLang=en#tags-notes)
- [Printing Labels from InnoVint](https://support.innovint.us/hc/en-us/make?hsLang=en#printing-labels-from-innovint)
- [AI](https://support.innovint.us/hc/en-us/make?hsLang=en#ai)
- [GROW](https://support.innovint.us/hc/en-us/grow?hsLang=en)
- [FINANCE](https://support.innovint.us/hc/en-us/finance?hsLang=en#main-content)
- [Getting Started](https://support.innovint.us/hc/en-us/finance?hsLang=en#getting-started)
- [Reporting](https://support.innovint.us/hc/en-us/finance?hsLang=en#reporting)
- [Guidance & FAQ](https://support.innovint.us/hc/en-us/finance?hsLang=en#guidance-faq)
- [Harvest](https://support.innovint.us/hc/en-us/harvest?hsLang=en#main-content)
- [Preparing for Harvest](https://support.innovint.us/hc/en-us/harvest?hsLang=en#preparing-for-harvest)
- [Vineyard Harvest Reports](https://support.innovint.us/hc/en-us/harvest?hsLang=en#vineyard-harvest-reports)
- [Harvest Workflow & Fermentation Tracking](https://support.innovint.us/hc/en-us/harvest?hsLang=en#harvest-workflow-fermentation-tracking)
- [Settings & Preferences](https://support.innovint.us/hc/en-us/harvest?hsLang=en#settings-preferences)
- [MAKE: Advanced Features](https://support.innovint.us/hc/en-us/make-advanced-features?hsLang=en#main-content)
- [Owner-based Permissions System](https://support.innovint.us/hc/en-us/make-advanced-features?hsLang=en#owner-based-permissions-system)
- [Custom Attributes](https://support.innovint.us/hc/en-us/make-advanced-features?hsLang=en#custom-attributes)
- [Blend Trials](https://support.innovint.us/hc/en-us/make-advanced-features?hsLang=en#blend-trials)
- [Tank Maps](https://support.innovint.us/hc/en-us/make-advanced-features?hsLang=en#tank-maps)
- [Sparkling Wine Module](https://support.innovint.us/hc/en-us/make-advanced-features?hsLang=en#sparkling-wine-module)
- [Intended Use](https://support.innovint.us/hc/en-us/make-advanced-features?hsLang=en#intended-use)
- [Integrations](https://support.innovint.us/hc/en-us/make-advanced-features?hsLang=en#integrations)
- [SUPPLY](https://support.innovint.us/hc/en-us/supply?hsLang=en#main-content)
- [Getting Started with SUPPLY](https://support.innovint.us/hc/en-us/supply?hsLang=en#getting-started-with-supply)
- [Actions in SUPPLY](https://support.innovint.us/hc/en-us/supply?hsLang=en#actions-in-supply)
- [Using SUPPLY](https://support.innovint.us/hc/en-us/supply?hsLang=en#using-supply)
- [Order Management](https://support.innovint.us/hc/en-us/supply?hsLang=en#order-management)
- [InnoApp](https://support.innovint.us/hc/en-us/innoapp?hsLang=en#main-content)
- [InnoApp](https://support.innovint.us/hc/en-us/innoapp?hsLang=en#innoapp)
- [InnoApp - Work Orders](https://support.innovint.us/hc/en-us/innoapp?hsLang=en#innoapp-work-orders)
- [Guidance & FAQs](https://support.innovint.us/hc/en-us/guidance-faqs?hsLang=en#main-content)
- [Frequently Asked Questions](https://support.innovint.us/hc/en-us/guidance-faqs?hsLang=en#frequently-asked-questions)
- [Specialized Workflows](https://support.innovint.us/hc/en-us/guidance-faqs?hsLang=en#specialized-workflows)
- [Best Practices](https://support.innovint.us/hc/en-us/guidance-faqs?hsLang=en#best-practices)
- [Templates](https://support.innovint.us/hc/en-us/guidance-faqs?hsLang=en#templates)
- [InnoVint Academy](https://support.innovint.us/hc/en-us/innovint-academy?hsLang=en#main-content)
- [Video Trainings/Tutorials](https://support.innovint.us/hc/en-us/innovint-academy?hsLang=en#video-trainings-tutorials)
- [Video Informational Sessions](https://support.innovint.us/hc/en-us/innovint-academy?hsLang=en#video-informational-sessions)
- [Quick Video Tutorials](https://support.innovint.us/hc/en-us/innovint-academy?hsLang=en#quick-video-tutorials)
- [Product Updates](https://support.innovint.us/hc/en-us/product-updates?hsLang=en#main-content)
- [Product Updates: 2025-2026](https://support.innovint.us/hc/en-us/product-updates?hsLang=en#product-updates-2025-2026)
- [Product Updates: 2024](https://support.innovint.us/hc/en-us/product-updates?hsLang=en#product-updates-2024)
- [Product Updates: 2023](https://support.innovint.us/hc/en-us/product-updates?hsLang=en#product-updates-2023)
- [Product Updates: 2017 - 2022](https://support.innovint.us/hc/en-us/product-updates?hsLang=en#product-updates-2017-2022)
- [Support Hours & FAQs](https://support.innovint.us/hc/en-us/support-hours-faqs?hsLang=en)
[](https://support.innovint.us/hc/en-us?hsLang=en)
Copyright © 2025, InnoVint