Bulk Management: Items with Variants

For stores with many items with variants to add or modify, Bulk Management helps get the job done more efficiently. Manage items in a spreadsheet and upload them all at once when ready.

Bulk Manage Items with Variants

Table of Contents

When to Use Bulk Management

Bulk Management is a powerful tool that can transform how you manage inventory. Before jumping right in, it is important to learn when you should and when you should not use this feature.

Use Bulk Management:

  1. When you have many inventory items to import

    For merchants with large inventories, it’s more efficient to import items via Bulk Management than to add them one-by-one from the Items List.

  2. When you have a digital copy of your items

    If the items you need to add already exist in a spreadsheet file, just copy their information into our template. Once in our template, the items are ready to import via Bulk Management.

  3. If you need to make mass changes to existing inventory items

    Changing the prices of 100 different items via the Items List can be cumbersome. Instead, modify these items in bulk with Bulk Management.

Don’t use Bulk Management:

  1. When you only have a few inventory items to add or modify

    In this case, it is less efficient to spend time preparing a Bulk Management spreadsheet than it is to add/modify these items one-by-one.

  2. If you are not comfortable working with spreadsheets

    Using Bulk Management requires editing, formatting, and saving spreadsheets files. If you don’t feel confident doing these actions, Bulk Management may not be right for you.

Start a New Job

Whether you need to add new items with variants or modify existing ones, begin by starting a new Bulk Management job.

  1. In BackOffice, click 'Items' and select 'Bulk Manage Items'.
  2. Click 'New Job'.
  3. Select either 'Add New Inventory' or 'Modify Inventory' and click 'Next'.

    Items with variants cannot be deleted with Bulk Management.

    Click to Enlarge
  4. Follow the steps below to add or modify inventory.

Add New Inventory

Adding new items with variants to inventory in bulk is a two step process. Prepare your import spreadsheet first, then upload it to BackOffice.

Prep the Spreadsheet

Download an import template from BackOffice and fill it in with your inventory information.

  1. After starting a new job, click 'Download a blank inventory template'.
    Click to Enlarge
  2. Open the template in spreadsheet software.

    If you don’t have spreadsheet software, try Open Office for free.

  3. Enter your inventory into the spreadsheet.

    For a rundown of what goes in each column, click here.

    Click to Enlarge
    Items with variants cannot use open or unit pricing, they must have their Price Type set to system.
    The only required columns are Name and Price. Prices must be the same. Any columns left blank will automatically be assigned the default value (TRUE or 0).
  4. For items with variants, enter values in the 'Option Name' and 'Option Value' columns.
    • Options are the types of variant choices a customer can make (Size, Color, etc).
    • Option Values are selections within each Option (Small, Medium, Large, etc).
      • Option Values must be each be separated by a comma.
    Click to Enlarge
  5. Save or export the completed spreadsheet in .CSV format.

    Visit our Spreadsheets for Bulk Imports article for help saving the file.

Upload the Spreadsheet

With the import spreadsheet saved, return to Bulk Management to upload the new items to BackOffice.

  1. In Bulk Management, click 'Choose File', select the import spreadsheet, and click 'Next'.

    If you get an error, visit our Items Troubleshooting guide for help.

    Click to Enlarge
  2. On the 'Map Fields' page, match 'Your CSV Headers' to the 'Stock Item Fields' and click 'Next'.

    Most fields will automatically map to the correct CSV headers, but you must manually map Cost.

    Click to Enlarge
    Set any fields you are not using to unassigned.
  3. Verify that all fields are mapped correctly, then click 'Confirm & Proceed' to process the import.
    Click to Enlarge
  4. Refresh the Bulk Management page to check the status of the import.
    Click to Enlarge

If the import returns errors, visit the Items Troubleshooting guide for help.

Modify Current Inventory

Modifying inventory items is a multi-part process. Export your current inventory, make updates to the export, and return to Bulk Management to import the changes.

  • Only Register Status, Price, Cost, Quantity, Reorder Trigger, and UPC can be modified using Bulk Management.
  • To make an entire item with variants’ Register Status ‘inactive’, not only individual variants, you must manually edit the item.
  • Inactive variants can only be made active by manually editing the associated item.
  • Prep the Spreadsheet

    Since you’re modifying existing items, you need to start with a spreadsheet of your current inventory.

    1. After starting a new job, click 'Export your existing inventory to a CSV'.
      Click to Enlarge
    2. Open the export in spreadsheet software.

      If you don’t have spreadsheet software, try Open Office for free.

    3. Update the spreadsheet to reflect the modifications you want to make.

      Below is an example of a price change. Item UUID is required for import, Name stays as a reference, and Price is the only column that changes. Rows/Columns not being updated are removed.

      Before Editing:

      Click to Enlarge

      After Editing:

      Click to Enlarge
      Items with variants support bulk modifying Register Status, Price, Cost, Quantity, Reorder Trigger, & UPC.
    4. Save or export the updated spreadsheet in .CSV format.

      Visit our Spreadsheets for Bulk Imports article for help saving the file.

    Upload the Spreadsheet

    With your import spreadsheet finished, return to Bulk Management to upload the changes to BackOffice.

    1. In Bulk Management, click 'Choose File', select the updated spreadsheet, and click 'Next'.

      If you get an error, visit our Items Troubleshooting guide for help.

      Click to Enlarge
    2. Set any field not being updated to 'unassigned' and click 'Next'.
      Click to Enlarge
      When modifying inventory, ‘Cost’ is unmapped by default. Modifying cost will override weighted average cost calculations.
    3. Verify that all fields are mapped correctly, then click 'Confirm & Proceed' to process the import.
      Click to Enlarge
    4. Refresh the Bulk Management page to check the status of the import.
      Click to Enlarge

    If the import returns errors, visit the Items Troubleshooting guide for help.

    Template Columns

    This section explains the Bulk Management template’s columns and the information required for each.

    Click to Enlarge

    Name | Name of the item as it appears on the register and receipts. This field is mandatory, must be unique, and must be under 255 characters.
    Option Name | The types of variant choies a customer can make (Size, Color, etc.).
    Discountable | TRUE – Yes, the item should be able to havae a discount applied to it. FALSE – No, the item should not be discountable at the register.
    UPC | 8, 12, or 13 digit barcode from the product that can be scanned at the register. UPC codes cannot begin with 2, 4, 5 or contain letters.
    Taxable | TRUE – Yes, the item should have tax applied to it. FALSE – No, this item should not be taxed.
    Department | Optional field used for item organization, reporting, and ticket printing.
    Category | A subgroup within a Department.
    Supplier | The vendor or party from whom the item is acquiured.
    Supplier Code | Any reorder code associated with the item.
    Price Type | How the item’s price is entered. System – The item has a set price. Open – The price entered at the register when the item is sold. Unit – The item is sold at a per-unit price (e.g. by the pound). NOTE: Items with variants must have their Price Type set to system.
    Unit | Two character abbreviation for unit pricing (oz/lb/etc.). Use only if Price Type is set to Unit. NOTE: Items with variants cannot use unit pricing.
    Tax Rate | Assign the item to a tax group to override the default tax rate. Tax groups must be set up in BackOffice ahead of time. Enter the name of the tax group and its rate, e.g. Alcohol @ 11.25%.
    Track Inventory | TRUE – Yes, BackOffice will keep track of the item’s quantity on hand. FALSE – No, BackOffice will not keep track of the item’s quantity on hand.
    Register Status | active – The item appears on the register and can be sold. inactive – The item appears only in BackOffice and cannot be sold at the register.
    Price | What the customer pays at the register for the item.
    Cost | The cost of the item to the business. If Track Inventory is set to FALSE, leave this blank and enter the cost in the Assigned Cost column instead.
    Quantity | How many of an item is on hand.
    Assigned Cost | The cost of the item to the business. If Track Inventory is set to TRUE, enter the cost in the Cost column instead. NOTE: Leave this field blank for items with variants. To track cost, set Track Inventory to TRUE and enter item cost in the Cost column.
    Reorder Trigger | Low quantity amount that prompts the time to appear on the Reorder Report.
    Recommended Order | Quantity required for the item to be considered fully stocked.


    • Help us improve ShopKeep Support. Was this article helpful?
    • YES   NO