Skip to content
Browse documentation

Importing CSV files

A CSV export is the offline way to migrate: it works when your old store is paused, password-protected, or blocks automated requests. Export the file from your platform's admin, then in NanoSite open Store → Import store, choose the platform and CSV export, and upload it. See Migrating your store for how imports work in general.

Limits

  • Up to 10 MB per file. For bigger catalogs, export in batches (e.g. by category) and import them one after another — re-running is safe.
  • CSV exports carry no currency. Enter the price currency (e.g. USD) in the form; it defaults to your store's currency.
  • Only https:// image URLs are downloaded.

Shopify CSV

Export from Shopify admin: Products → Export and/or Customers → Export. You can upload either file or both.

Products CSV — one row per variant plus extra image rows, grouped by Handle. NanoSite reads:

Column Used for
Handle Product URL and grouping of rows
Title, Body (HTML), Vendor, Type, Tags Product details
Status / Published Published vs draft
Option1..3 Name / Option1..3 Value Options and variant combinations
Variant SKU, Variant Price, Variant Compare At Price Variant SKU and prices
Variant Inventory Tracker, Variant Inventory Qty Stock tracking and quantity
Variant Inventory Policy continue = allow backorder
Image Src, Image Position, Variant Image Images, in order

Customers CSV — one row per customer: name, email, phone, tags, email marketing consent and default address.

Collections aren't in Shopify's product export; use the store URL or Admin API token source to bring them over.

Preview a Shopify CSV without signing in on the Shopify CSV page.

WooCommerce CSV

Export from WordPress admin: Products → Export (all columns). There is no built-in customer export.

WooCommerce writes each variation as its own row, pointing at its product through the Parent column (id:123 or the parent's SKU). NanoSite reads:

Column Used for
ID Source id (matches the REST API, so CSV and API imports dedupe)
Type simple, variable, variation (grouped/external rows are skipped)
Name, Description / Short description, Tags Product details; the URL is derived from the name
Published 1 = published, 0 / -1 = draft
SKU, Regular price, Sale price SKU and prices (sale price becomes the price)
Stock, In stock?, Backorders allowed? Stock quantity and backorders
Categories Collections; Clothing > Tops creates both levels
Images Comma-separated image URLs
Parent Links a variation to its product
Attribute N name / Attribute N value(s) Options and each variation's value

Variation rows whose parent isn't in the file are skipped with a warning.