Free template · Google Sheets or Excel · no add-on

Shopify + Etsy inventory in one spreadsheet

Paste your Shopify order export and your Etsy order items export. The sheet adds up what sold on each shop, shows what's on hand for every SKU, and marks anything at or below your reorder level in red.

Download the template (.xlsx)

Google Sheets: open sheets.google.com, then File > Import > Upload, and pick the file. Excel: just open it.

How to use it

  1. Stock tab. List each product once, with the same SKU you use on Shopify and Etsy. Fill the yellow columns: stock at your last count, units received since, and the level where you want to reorder.
  2. Shopify. Admin > Orders > Export, orders since your count, CSV for Excel. Copy everything (header row included) and paste into cell A1 of the Shopify orders tab.
  3. Etsy. Shop Manager > Settings > Options > Download Data > Orders > Order Items CSV for the same month. Paste into cell A1 of the Etsy orders tab.
  4. Done. The Stock tab shows sold on Shopify, sold on Etsy, on hand now, and REORDER in red.

Tired of pasting exports?

We're building a version that pulls Shopify and Etsy orders on its own and keeps the counts in sync. Want to hear when it's ready?

Questions

Does it work if my export columns are in a different order? Yes. The formulas look up columns by their header names (Lineitem sku, Lineitem quantity, Cancelled at on Shopify; SKU, Quantity on Etsy), so the order doesn't matter.

What about cancelled orders? Shopify rows with a Cancelled at date aren't counted. Shopify only fills that column on the first row of an order, so for a cancelled order with several items, delete its other rows.

My Etsy items don't show up. Etsy only includes a SKU in the export if you set one on the listing. Add the same SKU you use on Shopify.

When I do a new count? Update "Stock at last count", set "Received since count" to 0, and paste exports starting from the count date.

Does it change anything in my shops? No. It only reads the files you paste. Nothing connects to Shopify or Etsy.