Related Articles:

Item Families

Stock Reservations by team

What can you do with bulk update items?

With this feature, you can update and edit all editable fields for all SKUs via a CSV upload. In this article, you will find the instructions on how to do this successfully. 

The fields you can update are:

• SKU Name
• SKU Description
• Item Family
• Unit Cost
• Currency
• Manufacturing Country
• Tariff Code
• Team Access
• Reserve Stock by Teams

Step 1: Download CSV

Important before you start!

Whenever using any bulk CSV updates make sure to save the original export, then duplicate it and update 1 of them, so that you have a copy of what everything was previously before bulk updating. This way, if you were to make a mistake you can import the original export and reset everything back to how it was. 

Click on 'more options' next to 'filters' and select 'Bulk update items'.

This will open a modal. In here you can export your SKUs with the 'download CSV' link. This will export a CSV that contains all of your SKUs and their fields.

In the exported CSV you will find each SKU per row and the columns you can edit. You will find in the column titles which fields are mandatory and which are optional. 

When editing the CSV make sure of the following validations and rules:

• DO NOT edit the SKU, this is how we map the updates to the correct SKU
  • If there are SKUs you do not want to update, simply leave them or you can remove the row
• The CSV must include the SKU Name, any changes to this field will update the platform
• The CSV must include the SKU Description, any changes to this field will update the platform
  • The description must be a minimum of 6 characters 
• Make sure if you are creating new or assigning Item Families that they have been spelled correctly, to avoid creating duplicate families
  • Learn more about Item Families here
• By updating Unit Cost, Currency, Manufacturing country, and Tariff Code we will automatically turn on trade zone shipping for this item 
• Make sure when adding teams to team access that the team name already exists and is spelled correctly to avoid the row from failing
• Reserve Stock by team will turn on the stock reservation toggle for this SKU
  • This WILL NOT assign stock it just turns on the ability to reserve stock. Items which have this turned on but no stock has been assigned will not be available for shipment until assigned, to assign stock follow this guide for Stock Reservations by team

Edit all fields you wish to update and then export the CSV. Return to the platform and upload or drag and drop the CSV into the modal. Then click 'upload'.

You will receive an email once the updating process has been completed. In this email it will tell you how many rows were successfully updated, and if any, how many failed. This will also come with CSVs informing you where failures happened and why. 

Please note, that the larger the file and the more SKUs contained you upload, the longer it will take to process. A banner will be displayed to all users with access to the inventory tab and items informing them there is a bulk operation underway and to not edit any items. Once all bulk operations have been completed and the page has been refreshed, this banner will be removed.