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.
In BackOffice, click 'Reports' and select 'Stock Items'.
To learn how to export stock items directly from the Item List, visit our Organize Inventory article.
Click 'Export Stock Items' to download the report.
Click to Enlarge
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.
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. All variants are listed separately on individual rows with the variant’s item name and ‘Option Values’. For example, ShopKeep T-Shirt – Small Blue.
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 Group or Rate
The tax group or rate an item is assigned to. If an item is assigned to the default tax, this appears blank.
Help us improve Lightspeed Support. Was this article helpful?