# Import from a file

> Bring products or customers into PersonaCart from a CSV or JSON file. Preview first, match columns, try 20 rows, fix problems and undo.

Source: https://docs.personacart.com/commerce/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.

1. Open **Commerce → Import / Export**, tab **From a file**.
2. Choose **Products** or **Customers**, then drop your file.
3. Read the preview. Press **Try with 20 first**.
4. Press **Import the rest**. Products arrive as drafts.

## 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](/storefront/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

1. Under **What's in this file?** choose **Products** or **Customers**.
2. Under **How should this file be used?** (products) choose **Add new only**, or **Update existing, match by product number** (see below).
3. Drop the file on the box, or click to choose it. "Checking &lt;name&gt;…" shows while it is read.
4. 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**).
5. 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.
6. 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.

:::note[Plan limits and problem rows]
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](/commerce/import-job).

- **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 &lt;time&gt;**, and **Undo ended** afterwards.

## Questions
