To improve your experience, we’d love your feedback on how and why you use the Support Site!
TAKE THE SHOPKEEP SUPPORT SITE SURVEY NOW>>
Stock Items Export
Table of Contents
Export Stock Items
Download all of your stock items to a .CSV spreadsheet in just a few clicks.
- In BackOffice, click 'Analytics' and select 'Stock Items'.
- Click 'Download' to retrieve the report.
- When the download finishes, open it in spreadsheet software.
If you don’t have spreadsheet software, try Open Office for free.
Follow along below for a complete explanation of each of the Stock Item Export’s columns.
Active variants are listed on individual rows with their item name, a dash, and their Option Values in the Name column. For example, ShopKeep T-Shirt – Small Blue.
Identification number that is unique for each item and cannot be changed.
ID number required for modifying/deleting items with Bulk Management. This also cannot be changed.
Name of the item as seen on receipts and in BackOffice reporting.
Subgroup within a Department that is used as for more specific organization.
Number that represents the item’s scannable barcode.
Store Code (SKU)
Barcode labels printed from ShopKeep use this number. It is generated automatically for each item and cannot be changed.
Amount the customer pays for the item. For open priced items, this is 0.
TRUE or FALSE. This determines whether discounts can be applied to the item.
TRUE or FALSE. This determines whether tax gets applied to the item.
TRUE or FALSE. Indicates whether the system keeps track of the item’s Quantity.
When an item is tracked, Cost is the amount the item costs the business to sell. Cost changes as you receive inventory and updates to a weighted average of the current and receiving costs.
Same as Cost, but for untracked items.
Number of units on hand. This changes as items are sold, returned, adjusted, and received into inventory.
Visit our troubleshooting guide to learn how to fix items with negative quantities.
When tracking inventory, Reorder Trigger is the bottom limit for when stock is low. When an item’s Quantity sells down to the trigger, the item appears on the Reorder Report.
Quantity of an item on hand when it is fully stocked. This also appears on the Reorder Report.
Last Sold Date
Date and time the item was last sold.
Vendor from whom the item was acquired for sale.
TRUE or FALSE. This determines whether the item is a liability.
Liability Redemption Tender
For Liability Items, this is the tender linked to the item (Gift Card or Gift Certificate).
Displays the tax group the item is assigned to. If an item is assigned to the default tax, this appears blank.