Etsy Product Download

Etsy Product Download — Functional Description

Interactive inventory admin screen for importing Etsy Shop Manager listing CSV exports into the custom pd_etsy_products table. Operators download active listings from the Tonic Suite Music Etsy shop, upload the CSV here, and the script resets staging flags, parses each row through a canonical column whitelist, upserts product data idempotently, and enriches rows with OpenCart catalog price (OC_PRICE) and calculated USPS shipping.

  • Download CSV — Open your Etsy shop download page and export active listings as CSV.
  • Update Etsy Products — Upload the CSV to refresh the pd_etsy_products staging queue.
  • Price & quantity changes — Scan staged rows against OpenCart price, shipping, and quantity; update mismatches on Etsy.
  • Relist products — Find catalog items with OpenCart stock but zero Etsy quantity and stage relist quantities.
  • End listing / sales lookup — Review order counts by SKU and mark listings as not allowed when retiring products.
Import Etsy Listing CSV

Download the products listed. Click here.

Select “Download CSV”, then upload the file below and click Update Etsy Products.

Price & Quantity Review

Update Etsy, then update OpenCart

Relist Candidates
Listing Retirement & Sales Lookup

Etsy products whose listings are about to end