Editing items individually is useful when you need to fine-tune details like cost, category, or brand for a single product. But when you need to update many items at once (for example, after a price change or a new shipment), the bulk update tool is faster.
The bulk update process has three parts:
- Export a bulk update CSV file from your inventory.
- Edit the file in a spreadsheet program (Excel, Google Sheets, etc.).
- Import the edited file back into the system to apply the changes.
Step 1: Export the bulk update CSV
- Go to the Export button in your inventory.
- You will see two options: Full Inventory Export and the bulk update export. Choose the bulk update export.
- Click Export to CSV or Excel and download the file.
Understanding the CSV columns
| Column | Editable? | Purpose |
|---|---|---|
| Item ID | No | Uniquely identifies the item. Used to match the row to the correct item in the system. Do not change. |
| Variant ID | No | Uniquely identifies the item's variant. Do not change. |
| SKU | Reference only | Helps you locate the correct item while editing. Not used for matching. |
| UPC | Reference only | Helps you locate the correct item while editing. Not used for matching. |
| Description | Reference only | Helps you locate the correct item while editing. |
| Category | Yes | Updates the item's category. |
| Subcategory | Yes | Updates the item's subcategory. |
| Price | Yes | Updates the item's price. |
| Quantity | Yes | Updates the item's quantity on hand. |
Note: Item ID and Variant ID are used to match each row to the correct item in the system. Only items assigned to you as a vendor can be updated. If a row refers to an item that is not yours, the system will ignore it and will not apply the update.
Step 2: Edit the CSV file
- Open the downloaded CSV in your spreadsheet program of choice (Excel, Google Sheets, etc.).
- Use the SKU, UPC, or Description columns to locate the item(s) you want to update.
- Edit the Category, Subcategory, Price, and/or Quantity fields for each item you want to change.
- Repeat for as many items as needed. You can edit one row or every row in the file.
- Save the file, keeping it in CSV format.
Step 3: Import the updated file
- In the system, go to Bulk Update.
- Click Browse and upload your edited CSV file.
- Go to Map Columns. Category, Subcategory, Price, Quantity, Item ID, and Variant ID will map automatically. (SKU, UPC, and Description are not mapped, since they aren't used for updates.)
- Click Next to preview the items that will be updated. You can make further edits here if needed.
- Click Save Edits.
- Click Apply Changes, then click OK to confirm
Once the import finishes, you'll see a confirmation showing how many items were updated.
