Import and export store data
Your store's products, categories, orders, discounts, coupons and gift cards each have an Export button, and the ones a file may change have an Import button. Export lets you pick every field, including computed ones. Import shows you how each column is read and which record each row matches, and asks how to handle every conflict before anything is written.
| What | Where | Import | Export |
|---|---|---|---|
| Products and variants | Products page, above the table | Yes | Yes |
| Categories | Categories & collections card | Yes | Yes |
| Discounts | Discounts card | Yes | Yes |
| Coupons | Coupons card | Yes | Yes |
| Orders | Orders tab, Export orders or Export for shipping | No | Yes |
| Gift cards | Gift cards card | Yes, by issuing each card | Yes |
| Tracking numbers | Orders tab, Import tracking | Yes, by shipping each order | Yes |
You need permission to manage the site's data to import or undo an import. Importing gift cards also takes Import gift cards, which the workspace's owners and admins, and a site's admins, hold by default. Exporting needs read access to the site.
Export
Export opens a dialog with every field the records have, grouped and searchable:
- Presets fill the field list. Re-importable (the default) puts the Aglyn ID and the fields a re-import matches on first, then every field an import can write, so the file comes back in and finds its records. Everything adds computed and system fields. Minimal keeps the ID and the match fields. You can save your own list as a preset, and your last choice is remembered.
- Records: everything, or what the list's filters and search find. On the Products page and the Orders tab, the filter is the same query the table runs, so the file holds every match in the store, not only the page on screen. There is no 5,000-order limit.
- Format: CSV for a spreadsheet (with an optional byte-order mark for Excel), JSON, or NDJSON.
The file is built on the server and checked when it arrives. A download that stops short is refused rather than saved half-written.
Products are a row per variant
A product with three variants is three rows. The product's own fields (title, description, tags and so on) are on its first row, and every row carries the product's Handle and its ID. Images follow the same pattern: the first image on the first row, the next on the second, and extra rows holding only the handle and an image when a product has more images than variants.
The Shopify preset
Products have a Shopify preset. It writes Shopify's product CSV:
Shopify's columns, in Shopify's order, under Shopify's column names
(Handle, Title, Body (HTML), Option1 Name, Variant SKU,
Variant Price, Image Src and the rest), so the file can be uploaded to
Shopify as it is. It leaves out Status, because Published says the
same thing, and Kind, which Shopify's Type column does not mean.
Export for shipping, in the Orders card's header, opens the same dialog on the orders still to ship, laid out for Pirate Ship, Shippo, EasyPost or any label tool. See Use Pirate Ship with Aglyn.
Import
Import opens an eight-step wizard:
- Upload a CSV, JSON or NDJSON file. The separator, encoding and header row are detected, and you can change any of them.
- Columns: each column is matched to a field, with how sure the match is and why. A Shopify product export is recognized column for column. Remap or ignore any column.
- Values: list values the store does not hold. For a product's Kind, Status or When sold out, map each unknown value to one the store has, leave it blank, or refuse the rows. For Categories, you can also add a name as a new category.
- Matching: how many rows find an existing record, how many are new, and which are ambiguous.
- Conflicts: what happens on a match (update, skip or make a copy), on no match (create or skip), and per field (overwrite, fill only blank fields, keep what is there). Rules the store keeps are shown locked with the reason. A gift card import adds a Confirm the cards step here (see Gift cards).
- Review: a dry run of every row, with a before → after table and every class of warning. Each class needs an "I understand" before Import is enabled.
- Import writes in chunks. You can pause and resume it.
- Results: a result file of every row, and Undo for seven days. A record edited since the import is shown to you rather than overwritten.
By default an import fills blank fields and never overwrites what a record already has. To change prices, stock or anything else that is set, choose Overwrite for those fields in the Conflicts step.
Products
Rows that share a Handle are one product: the first row's product fields, every row's variant, every row's image. A row without a handle is a product of its own, and its handle is made from its title.
- Matching tries the Handle, then the SKU, then the Aglyn ID. A matched product is updated. (Before, a file whose handle was taken created a second product under a new handle.) A row with only a SKU and, say, an Inventory column updates that variant's stock.
- Variants are matched within the product by SKU, then by their option values, then, for a product with one variant, that variant. A row naming a variant the product does not have adds it.
- New products need a Title and a Price for each variant. They
count against your plan's product allowance, and a file with more new
products than the plan has room for fails the rest in the dry run. A handle
another product holds, even a deleted one, gets a free one (
mug-2), and the dry run says so. - Stock that a file changes is logged in the stock history as a correction.
- Prices are in US dollars. A price in another currency is not converted; the cell is dropped and the dry run says so.
- Tags keep their case. Smart collections match a tag exactly.
What a file does not change:
- An existing product's handle. It is the product's address. Change it in the product editor.
- An existing option's name. Renaming an option moves every variant, and the product editor does that. A file can name an option a product does not have yet.
- Stock kept by location. Change it per location on the products page. The dry run says which rows it held back.
- Products the store would refuse, such as a compare-at price at or below the price, or more than 100 variants. The dry run fails those rows and gives the reason.
Add-ons, check-in and quick keys
Four columns carry what a product does at the register and the window. Like the other product fields, they go on a product's first row, and Variant check-in goes on the variant's own row. A file without these columns leaves them as they are. So does a blank cell, unless you set A blank cell to clear the field in the Conflicts step.
| Column | What to write |
|---|---|
| Quick key | Yes shows the product under Quick keys on the register's first screen. No doesn't. |
| Check-in | No, Yes, or Yes followed by how many people one item admits and whether to ask the buyer the day: Yes, 4 people, ask which day. |
| Variant check-in | The same words, for one variant. Blank follows the product. |
| Add-ons | The product's add-ons, written as below. |
An Add-ons cell lists the groups, split by semicolons. Each group is its name, a colon, and its choices split by commas. A choice's price comes after its name; a choice with no price is free.
Milk: Whole, Oat +$0.75, Almond +$0.75; Extras (at most 3): Extra shot +$1.00, Syrup +$0.50
Parentheses after a group's name hold its settings, and you can leave out any of them:
at least 1makes the group required. Left out, the group is optional.at most 3is how many choices a customer can pick. Left out, it's 1, or the at least number if that's higher.register onlyturns off Show on the website. Left out, the group is shown on the website.
Parentheses after a choice hold what it adds on a particular variant, by the variant's name as the product editor shows it. A variant you don't list pays the choice's own price:
Walls (at most 2): Back wall +$50.00 (10x20 +$75.00, 20x20 +$90.00), Side wall +$40.00
Put double quotes around a name with a comma, semicolon, colon or parenthesis,
such as "Salt, pepper" +$0.50. Write prices without a comma: +$1000.00.
A group or choice the product already has, by name, stays the same one, so a shopper's cart keeps working. To change add-ons a product already has, choose Overwrite for the field in the Conflicts step. The cell then replaces all of the product's add-ons: a group or choice you leave out of it is removed.
The dry run checks each cell. A cell it can't read is dropped, and the dry run gives the row and the reason. Add-ons the store would refuse fail the product's rows, as the product editor would refuse them: more than 10 groups or 20 choices in a group, a choice over $1,000, an at most above the number of choices, a price for a variant the product doesn't have, or options that make more than 100 combinations.
With Aglyn AI on, the wizard's After import step offers Write descriptions, search listings and tags with AI as they land. The copy waits on the Products page for your review; nothing is saved until you apply it.
Categories
Matched by slug, then by name. Parent names another category by its slug or name, including one created earlier in the same file. A parent the site does not have, or a parent that would put a category under itself, fails that row.
Discounts and coupons
Discounts match by code, then name. Coupons match by code, which is the coupon's ID. A new discount or coupon starts switched off unless the file has an Active column that says otherwise. How many times one has been used is exported but never imported.
Gift cards
Use a gift card import to move cards over from another platform. A file never writes a balance. Each row issues a card the same way Issue gift card does on the Gift cards card: the amount is checked, the code is never overwritten, the card records who issued it, and the site's activity log gets a line for it.
- Code: the code the shopper already holds, so their card keeps working.
Spaces are removed and letters are upper-cased (
abcd efgh 1234becomesABCDEFGH1234). A code is 8 to 40 letters, digits, hyphens or underscores. Leave it blank and a new one is made. - Balance: what the card is issued for, in US dollars. It must be more than $0 and no more than $1,000, the most one card can be issued for. A row in another currency, from the balance cell or a Currency column, is refused, not converted.
- Recipient email and Note are kept on the card, as when you issue one by hand.
A code that another card already holds is never changed. On the Conflicts step, choose per row (or for every match):
- Skip this row: the existing card stays as it is.
- Create a new record instead: the card is issued under a new code. Nobody holds that code yet, so email it to the recipient or share it yourself.
- Update the record is refused for gift cards. The dry run fails the row and says why.
Confirm the cards comes after Conflicts. It lists every card the import will issue, with its code, value, recipient and note, and the total they add up to. Type that total to go on. The server issues nothing unless the total you typed is exactly the total of the cards it is about to issue. If the cards change after you type it, the review warns you and no card is issued until you confirm the new total. The same step asks whether to email each recipient their code. This is off by default, because cards moved from another platform carry codes your shoppers already have.
The Review step shows every card with its code and value, and a warning that states the total. You must check "I understand" before Import is enabled.
Undo voids the cards the import issued. Voiding sets the balance to zero and keeps the card on record, the same as Void on the Gift cards card. A card that has been used, or that a checkout is paying with right now, is never voided. It is listed as a conflict and keeps its balance, even if you choose to undo it.
Orders are exported only
An order is the record of a sale, written by checkout, the register or a paid draft order. A file cannot create or change one.
The Code in a gift card export or import spends the card's balance. Keep the file as safe as the cards themselves.