Bulk Management: Items with Variants
Manage your store’s inventory using the bulk management tool. Upload a spreadsheet containing your inventory data, including variants, to add or modify multiple items at once.
Table of Contents
Create a New Job
Create a new job to upload a spreadsheet containing inventory data. Start here to add or modify items.
- Sign into BackOffice.
- Click 'Items', then choose 'Bulk Manage Items'.
- Click 'New Job'.
- Select an action to add or modify inventory.
*Items with variants cannot be deleted using bulk management, but can be deleted from the items list.
- Click 'Next' to begin the new job.
Add New Inventory
Add your inventory items by uploading a spreadsheet containing the item data, including variants.
Prepare the Spreadsheet
Download the blank inventory template and enter your inventory data.
- Click 'Download blank inventory template'.
- Open the template using any spreadsheet software.
If you don’t have a spreadsheet software, try Open Office for free!
- Enter your inventory data, including variants into the spreadsheet.
For a full rundown of what all the spreadsheet columns mean, click here!
*Price type cannot be ‘Open’ or ‘Unit’ for items with variants.
- Save the file in the format based on the spreadsheet software being used. Visit our Bulk Importing article to verify before continuing.
Upload the Spreadsheet
With your spreadsheet completed, upload it from the New Job page.
- The default selection is 'Add New Inventory'. Click 'Next' to continue.
- Click 'Choose File' to select the newly saved spreadsheet.
- Click 'Next' to continue.
- Map the Stock Item Field to Your CSV Headers. Unassigned ﬁelds will be set to their default state.
- Click 'Next'.
- Verify that the correct fields are mapped, then click 'Confirm & Proceed' to complete the import.
- View the Bulk Manage homepage to check the status of your upload.
If you have to make changes to Register Status, Price, Cost, Quantity, Reorder Trigger, and UPC for a number of products, Modify Inventory is the quickest way to do it.
Preparing the Spreadsheet
Since you’re updating existing inventory, you’ll need to start with a spreadsheet of your inventory provided by the BackOffice.
- Select 'Modify Inventory' from the New Job page, then click 'Next'.
- Click the link to Export your existing inventory to a CSV.
- Open the newly downloaded .csv spreadsheet.
The spreadsheet will appear in your downloads folder.
Upload the Spreadsheet
With your inventory exported, you’ll need to edit the file to remove items you aren’t updating, and make changes to the items you’re modifying. This requires spreadsheet software such as Excel, Numbers, or Open Office.
- Edit the spreadsheet. Save or Export as .CSV when finished.
Register Status, Price, Cost, Quantity, Reorder Trigger, and UPC can be updated here. This is an example of a price update. The Item UUID is required for import, Name stays as a reference but isn’t updated; Price is the only parameter that’s changed. Anything not being updated should be removed from the spreadsheet.
- In the BackOffice, choose 'File' to select your .csv then click 'Next'.
- Set any field not being updated to unassigned.
- When finished mapping the import, press 'Next' and then 'Confirm & Proceed'.
- Refresh the page to see the final results of your import.
Template Fields Explanation
Templates have columns that match up with parameters for BackOffice items. For example, entering something under Name in the spreadsheet will make that the item name in the BackOffice. This section explains what these columns mean and what information is required in each.
When modifying inventory, ‘Cost’ is unmapped by default. Modifying cost will override weighted average cost calculations.