Import from a file
In short: Bring products or customers into PersonaCart from a CSV or JSON file. Preview first, match columns, try 20 rows, fix problems and undo.
Use From a file when you have a spreadsheet or an export from another tool. PersonaCart checks the file first and shows exactly what will happen before anything changes.
Where to find it
- Sidebar → COMMERCE → Import / Export, tab From a file.
- The Import button at the top right asks what you want to import and opens the right tool: Products and customers (file, Shopify, a Google Sheet or a product link), A section or design into a page (paste HTML or a link; needs a page open in the editor), or A whole page from a website (copies a page into a new page; see Pages).
On the right, Recent imports lists your latest imports, and Files that import twice safely explains that every export carries a hidden product number, so a file you sorted in Sheets still matches the right rows.
What files work
- A Shopify product export (CSV), a PersonaCart CSV, a PersonaCart catalog JSON, or any spreadsheet saved as CSV. The preview tells you which kind it found: Shopify CSV, PersonaCart CSV, PersonaCart catalog JSON or Other CSV.
- Up to 15 MB and 10,000 rows per file. A bigger file is refused with a message to split it.
- Not sure of the layout? Press Download a Shopify-style template.
Import a file
- Under What's in this file? choose Products or Customers.
- Under How should this file be used? (products) choose Add new only, or Update existing, match by product number (see below).
- Drop the file on the box, or click to choose it. "Checking <name>…" shows while it is read.
- Read the preview.
- For products you see counts: New · draft, Updated, Skipped, With problems, and where relevant Skipped — already in another store's link and Over your plan.
- A table of the first rows shows each row's price, variants and what will happen to it (New · draft, Update, Skip, Problem).
- If the file already has products or customers in your store, choose what to do with them.
- For products: Update them with the details from the file or Skip them and keep what's there.
- For customers (matched by email): Update them: fill empty details, add new tags and notes, never erase anything or skip.
- Press Import N products (or Import N customers), or Try with 20 first.
Every product comes in as a draft, so nothing goes live on your store until you publish it. Customers are matched by email and nobody gets an email because of an import. A customers file only gives someone email permission when it says they are subscribed; otherwise people arrive without it.
If some products will not fit your plan, a notice lists them as Over your plan and they are left out. Rows with problems are left out too; you can fix them and import them again.
Map columns
If the column names are unfamiliar, a card says "Tell us which column is which". Press Map columns, match each field to a column of your file (or Not imported), and Apply & re-check rows. Columns the importer suggested are marked AI suggested. Nothing is saved until you confirm.
Fix a problem row
Under Rows we'll leave out each problem shows "Row N · field: message". Fix here lets you correct that row in place and Save; the preview re-checks it.
Try a small batch first
Try with 20 first (the number can differ) brings in a small batch so you can see how it looks. A card reads "The first 20 are in your store. Open your products and check how they came out." When they look right, press Import the rest.
Update products you already have
- Choose Update existing, match by product number, then Choose file.
- Use a CSV you exported from PersonaCart: every row carries its product number, so a file you sorted in Sheets still updates the right products.
- A preview lists what will change before anything is saved, grouped as name, status, price, compare price, SKU, stock and other changes, plus how many products stay the same, how many are new and how many rows have a problem and will be skipped.
- Press Apply N changes; Go back changes nothing.
While it runs and afterwards
-
Large imports run in the background.
-
You can close the page.
-
Progress shows ("N of N rows done") and the import appears under Recent imports with a status: Reading, Checking, Waiting for you, Importing, Done, Failed or Cancelled.
-
When it finishes, the result page shows what happened.
-
See The import page.
-
Undo this import removes what the import created and puts back what it changed.
-
It tells you first how many things it would remove, restore and keep.
-
It keeps anything that has a real order, anything you changed after the import, and anything imported before undo existed.
-
Under Recent imports an import shows Undo until <time>, and Undo ended afterwards.
Questions
Will importing email my customers?
No. Nobody is emailed because of an import.
Can I import the same file twice?
Yes. Choose to skip or update existing items, and nothing is added twice. A file that was stopped halfway can be imported again; the rows already in are skipped.
My columns have different names. What now?
Press Map columns, pick which column feeds each field, and apply. The rows are re-checked.
Why are my products drafts?
Imported products always arrive as drafts so nothing goes live by surprise. Publish them from Products.
I imported the wrong file.
Open the import under Recent imports and press Undo this import.