Stock Items Export

Run the Stock Items Export to download a copy of your current inventory to analyze in spreadsheet software. This report contains the names, prices, and other attributes of all basic items and items with variants.

Table of Contents

Export Stock Items

Download all of the business’s stock items to a .CSV spreadsheet in just a few clicks.

  1. In BackOffice, click 'Analytics' and select 'Stock Items'.
  2. Click 'Export Stock Items' to download the report.
    Click to Enlarge
  3. After downloading, the export is ready to open in spreadsheet software.

Export Explained

Follow along below for a complete explanation of each of the Stock Item Export’s columns. Open the export in any spreadsheet software to filter and organize its data according to your specific needs.

Click to Enlarge

Item ID
Unique item identification number that cannot be changed.

Item UUID
ID code required for modifying and deleting items with Bulk Management. This also cannot be changed.

Name
Name of each basic item and variant as seen on receipts and in BackOffice reporting.
Active variants are listed separately on individual rows with the variant’s item name and ‘Option Values’. For example, ShopKeep T-Shirt – Small Blue.

Department
General inventory grouping used for organization, reporting, and ticket printing.

Category
Subgroup within a Department. Also used for organization, reporting, and ticket printing.

UPC
Number that represents an item’s scannable barcode.

Store Code (SKU)
Used to create barcodes for labels printed from BackOffice. Automatically generated and cannot be changed.

Price
Amount the customer pays. For open priced items, this is 0.

Discountable
TRUE or FALSE. Determines whether discounts can be applied to an item.

Taxable
TRUE or FALSE. Determines whether tax is charged on an item.

Tracking Inventory
TRUE or FALSE. Indicates whether the system keeps track of an item’s Quantity.

Cost
How much the business pays to acquire an item. This changes to a weighted average as the item is received.

Assigned Cost
Same as Cost, but for untracked items.

Quantity
Number of units on hand. This changes as items are sold, returned, adjusted, and received.
Visit our troubleshooting guide to learn how to fix items with negative quantities.

Reorder Trigger
Low quantity amount that prompts a tracked item to appear on the Reorder Report.

Recommended Order
Quantity required for a tracked item to be considered fully stocked. Also appears on the Reorder Report.

Last Sold Date
Date and time an item was last purchased.

Supplier
Vendor from whom an item is acquired.

Liability Item
TRUE or FALSE. Determines whether an item is a liability.

Liability Redemption Tender
For Liability Items, this is the tender linked to the item (Gift Card, Gift Certificate, or Deposit).

Tax Rate
Displays the tax group an item is assigned to. If an item is assigned to the default tax, this appears blank.


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