Migrating from Etsy
Bring your Etsy listings into a NanoSite store with the listings CSV Etsy lets you download. There is no Etsy login or API key: you download one file and upload it. See Migrating your store for how imports work in general.
Download your listings CSV
- Sign in to Etsy and open Shop Manager.
- Go to Settings → Options and open the Download Data tab.
- Under Currently for Sale Listings, click Download CSV.
Upload that file as it is. Opening and re-saving it in a spreadsheet usually works too, as long as the header row stays.
In NanoSite, open Store → Import store, choose Etsy, pick the file and click Preview import. You can also preview it without signing in on the Etsy import page.
What the file holds
One row per listing that is currently for sale (drafts, sold-out and expired listings aren't in the file; renew them first if you want them). NanoSite reads these columns:
| Etsy column | In NanoSite |
|---|---|
TITLE |
Product title (HTML entities like ' are decoded) |
DESCRIPTION |
Description, with its line breaks |
PRICE |
Price of every variant |
CURRENCY_CODE |
Price currency (you can override it in the importer) |
QUANTITY |
Tracked stock, for listings without variations |
TAGS |
Product tags |
MATERIALS |
A "Materials: …" line at the end of the description |
IMAGE1 … IMAGE10 |
Product photos, copied to NanoSite's CDN |
VARIATION 1/2 NAME, TYPE, VALUES |
Options; every combination becomes a variant |
SKU |
Variant SKU, for listings without variations |
Variations
Etsy's CSV lists each variation's values in one cell (for example Small,Medium,Large) but has no
price, quantity or SKU per option. So for a listing with variations:
- every combination becomes a variant at the listing price;
- stock tracking is off for those variants (the listing quantity is a total that can't be split);
- SKUs are left blank when the listing has several.
The preview warns about these listings. After the import, set per-option prices and stock on the product page. A listing with more than 100 combinations imports without options.
What doesn't come over
Shop sections (collections), reviews, orders, customers, shipping profiles and listing videos aren't in the file. Etsy has no customer export.
Re-running
Re-importing the same file, or a newer download, skips listings you already imported. Etsy's file has no listing id, so a listing is recognized by its SKU, or by its title when it has no SKU (plus its first photo when several listings share a title). Renaming a listing without a SKU and importing again creates a second product, so give listings SKUs if you plan to import more than once.