Skip to main content

Automate stock exports for historical record of inventory snapshots

Schedule a stock export by email to keep a history of inventory snapshots, such as month-end or quarter-end stock counts.

SKULabs can email you a stock export on a schedule, so you keep a history of your inventory, such as a month-end or quarter-end snapshot. Each export is a CSV file with your current stock counts per warehouse at the time it runs.

How to schedule a stock export

Step 1. Go to Settings > Advanced > Scheduled Automations and click Add.

Scheduled Automations section with the Add button

Click Add in Scheduled Automations.

Step 2. In the window that opens:

  • Enter the E-mail that should receive the export, and an optional Title.

  • Under Automation, choose Warehouses stock export.

  • Choose the Frequency (Hourly, Daily, Weekly, Monthly, or Custom) and the Time. For a month-end snapshot, choose Monthly.

  • Click Save.

Add automation rule window with e-mail, automation, frequency and time fields

The Add automation rule window.

Step 3. Download each export from the email within 30 days. Export links are deleted after 30 days under the SKULabs data retention policy.

Manual export

You can also run the same export any time from Import/Export > Inventory: under Exports, click Warehouse stock. It lists each item's name, SKU, tags, stock per warehouse, retail price, and average cost.

Warehouse stock button under Exports on the Import/Export page

The Warehouse stock export on the Import/Export page.

Past exports

Your past exports, including automated ones, are listed on Import/Export > Historical.

Data retention varies by report, so older links may no longer download. Only administrators and managers can open this page, and only administrators can see automations and other users' past exports.

Historical tab on the Import/Export page listing past exports

The Historical tab lists past exports.

Did this answer your question?