Recipe: email daily stock levels by SKU
Each morning you get a CSV of every product variant with its SKU and available quantity.
The settings
- Schedule name
- Daily stock by SKU
- Resource
- Inventory
- Columns
- SKU, Product title, Variant title, Available quantity
- Runs
- Daily, 06:30
- Email recipients
- you or your buyer
Steps
- In your Shopify admin, open Apps, then MSS Order Export: CSV & Email; it opens on Export schedules. Select Create schedule.
- Enter the Schedule name first, because the app does not save a schedule without one ("Schedule name is required."). Then enter the rest of the settings above, and set your Timezone.
- Select Create schedule.
- After the first run, select the schedule's History and check the row count on the Delivery history page it opens.
Good to know
- Available quantity is the variant's total across your locations; the file does not split stock by location.
- Tag contains narrows the file to products with that tag.