Inventory snapshots

An inventory snapshot is a copy of the inventory overview as it was at a given moment. Boxture makes one automatically every night. You can download it as an Excel file at any time afterwards. Snapshots answer questions like "what did we have on the shelf at the end of last month?", for example for stock valuation, invoicing of storage, or reconciling with a customer's records.

When snapshots are made

• A snapshot is taken every day at midnight (Amsterdam time).
• Each snapshot covers all inventory in the system at that moment. When you download it, you only get the rows for accounts you have access to.
• Boxture keeps the 31 most recent snapshots. Older ones are deleted automatically, so download any snapshot you need to keep for longer.

Downloading a snapshot

1. Go to Inventory and choose Inventory snapshots in the menu.
2. The list shows one row per snapshot with:
   • Created at: the date and time the snapshot was taken. Use the sort control to show the newest or oldest first.
   • kind: always inventory/snapshot/.
   • File: a link named inventory_snapshot_ followed by the timestamp, for example inventory_snapshot_20261110000000.
3. Click the file link to download the snapshot as an .xlsx file.

The inventory snapshots page is available to users with a role other than Account owner or Shopify account owner. Account owners can receive their snapshot by e-mail instead (see below).

What is in a snapshot

The file has one row for each line of the inventory overview at that moment: per account, location, bin location, container, product and status. Columns:

Column	Meaning
account	The account that owns the location.
product_account	The account that owns the product.
location	Location name.
bin_locatione	Bin location name (the column header is spelled this way in the file).
container	Short container name (first eight characters of its ID), if the units are in a container.
product_number	Product or packing material number.
status	new or defective.
expected, available, allocated, picking, picked, packed, hold, expired	Number of units in each state. See Inventory items and states.
total	All units that are not retired.
updated_at	When inventory on that row last changed.

The timestamp in the file name is the time the snapshot was taken, in Amsterdam time. The Created at column on the page shows it in a readable form.

Totals per product

A snapshot has the same level of detail as the inventory overview, so one product can appear on several rows. Use a pivot table on product_number (and location) to get a total per product, the same way the Consolidated screen does.

Receiving snapshots by e-mail

Every night, for each account that has inventory in the snapshot, Boxture registers an inventory snapshot event. Your administrator can set up a messaging template for this event under Messaging. Each account then gets an e-mail with its own snapshot attached as an Excel file, containing only the rows for that account's products. This is a convenient way to give customers (account owners) a daily stock report without giving them access to the warehouse screens.