LCListing CheckupFree Etsy seller tools

Etsy inventory tool · Free CSV restock planner

Plan Etsy restocks with your active listings and order exports

Match the stock quantity in your active listings CSV with units sold in your Order Items exports. Estimate stock coverage and a restock amount for the lead time you choose, without connecting your Etsy account.

Free Etsy inventory planner · Private in your browser

Plan Etsy restocks from your own shop exports

Combine an active listings CSV with one or more Order Items exports. See which listings may need restocking based on the current quantity and sales in the period you choose.

Active listings CSV

The export needs title and quantity columns. SKU is recommended for more reliable matching.

Order Items CSV files

Select one or more non-overlapping Etsy order exports for the same shop.

Use the number of days covered by the order exports. The tool estimates average daily sales; it does not predict future demand.

Choose both exports to see your restock report.

How the restock estimate works

Average daily sales = units in the uploaded orders ÷ sales-period days. Suggested restock = average daily sales × (lead time + safety buffer) − current stock, rounded up. The estimate is a planning aid, not an automatic inventory update.

Both files stay in this browser. Nothing is uploaded, and buyer names, addresses and order IDs are not used in the report.

What you need for an Etsy restock report

Download your active listings CSV and one or more Order Items CSVs from the same Etsy shop. The listings file supplies current quantities; the order files supply sold units for the period you want to review. Use the period-days field in the planner to tell it how many days those sales cover.

  1. In Etsy Shop Manager, open Settings → Options → Download Data.
  2. Download the CSV for active listings.
  3. Under Orders, choose Order Items and select the month or year to review.
  4. Choose both exports above, then enter the number of sales days and your typical restock lead time.

Etsy’s active-listings export guide ↗ describes the listing fields, including quantity and SKU when added. See Etsy’s sold transaction export guide ↗ for order-file options.

How the stock estimate works

Average daily sales are the units in your uploaded order files divided by the sales-period days you enter. Estimated stock coverage is current listing quantity divided by that daily average. Suggested replenishment is the demand over your chosen lead time plus safety buffer, minus the stock already listed.

The estimate assumes the exports cover the period you entered and that the same order is not present in more than one file. It does not predict seasonal changes or automatically adjust stock. Review unmatched sales and your current Etsy inventory before acting.

Match by SKU, then by exact title

A SKU is the most reliable way to connect sold items to active listings. If an order row has no matching SKU, the planner tries an exact title match after normalizing punctuation, spaces and letter case. Edited titles, ambiguous duplicate titles, bundles, and listing variations may need manual review. The report shows sold units that could not be matched.

Private, local CSV processing

Both files are read in your browser. Nothing is uploaded to this site; buyer names, addresses and order IDs are not included in the restock report. This independent tool cannot edit your Etsy listings or see your live shop inventory.

Review the rest of your shop data

Frequently asked questions

Which Etsy files does the restock planner use?

It combines the active listings CSV with one or more Order Items CSV exports from the same shop. The active listing export needs title and quantity columns; SKU is recommended. Order exports need item titles; SKU and quantity improve matching and unit counts.

Does the Etsy restock planner update my shop?

No. The tool reads the selected files locally in your browser and creates a report. It does not connect to or change your Etsy account.

How does it calculate the suggested restock quantity?

It divides the units in the selected order exports by the sales-period days you enter, multiplies the average by your lead time plus safety buffer, subtracts current stock, and rounds up. It is a planning estimate, not a demand forecast.

How are sold items matched to active listings?

The tool first matches normalized SKUs. If no SKU match is found, it tries an exact normalized title match when only one active listing has that title. Changed titles, ambiguous titles and missing listings may remain unmatched.

Does the report include profit or Etsy fees?

No. The restock report uses product names, SKUs, quantities and stock counts. It does not include revenue, Etsy fees, materials, shipping costs or profit.