Appearance
Import & Export
Download your wishlist data as CSV files, or bring wishlists in from a CSV - for example, when moving from another wishlist app.
Overview
The Import & export page has two parts:
- Export - download wishlist items, customers, or wishlisted products as a CSV file.
- Import - upload a CSV of wishlist items. The app checks every row against your store first and shows you what will be added. Nothing is saved until you confirm.
The wishlist items export uses the same format as the import, so you can export, edit, and import the file again without changing the columns.
Benefits
- Move your customers' wishlists from another wishlist app without losing them
- Back up your wishlist data, or analyze it in a spreadsheet
- See exactly which rows will be imported, and why any are skipped, before anything is saved
- Large files import in the background, so you can leave the page while it runs
Where to Find It
Apps → BRIX: Wishlist Plus → Import & export
How to Use
Export your data
- Open the app and click Import & export in the app menu.
- Under Export, find the file you want.
- Click Download CSV.
| Export | What's in it |
|---|---|
| Wishlist items | Every saved item, one row each. This file can be imported back into the app |
| Customers | One row per shopper, with their wishlist count, item count and last activity |
| Wishlisted products | One row per product, with how many shoppers saved it |
Import wishlist items
- Open the app and click Import & export in the app menu.
- Under Import, click Download a sample CSV if you need a template. This opens the format guide, where you can click Download the sample CSV.
- Drop your CSV file into the upload area, or click to choose it.
- Click Check file. The app checks every row against your store.
- Review the results: "X of Y rows are ready". If some rows will be skipped, click Download error report to see why.
- Click Import X rows to save them, or Cancel to stop. Nothing is saved until you click Import.
- When it finishes, you'll see how many items were added, how many were already there, and how many rows were skipped.
The import runs in the background. You can leave the page and come back later.
CSV Format
Click Download a sample CSV on the Import card to open the How to format your CSV guide in the app.
| Column | Required | Description |
|---|---|---|
customer_email | One of these two | The customer's email address |
customer_id | One of these two | The Shopify customer ID |
product_id | One of these two | The Shopify product ID |
product_handle | One of these two | The product handle, for example classic-canvas-tote |
variant_id | Optional | A specific variant. Leave blank to save the product |
wishlist_name | Optional | The wishlist to add the item to. Leave blank to use the customer's default wishlist |
added | Optional | The date the item was saved |
Example:
csv
customer_email,customer_id,product_id,product_handle,variant_id,wishlist_name,added
jane@example.com,,1234567890,,,,
mark@example.com,,2345678901,,,,Good to know
- Every row is one product saved to one customer's wishlist.
- Only two things are required:
customer_emailorcustomer_id, andproduct_idorproduct_handle. - IDs work either way:
1234567890orgid://shopify/Product/1234567890. - Extra columns are ignored, and column names are flexible. For example,
Email,Product ID,product-idandhandleare all recognized, so files from other wishlist apps often work without editing. - If
wishlist_namenames a list the customer doesn't have yet, the app creates it. - Files can have up to 10,000 rows and must be smaller than 5 MB. Only
.csvfiles can be imported.
Recent Imports
The Recent imports table lists your past imports with the date, file name, status, and how many rows were added and skipped. Click Errors to download the error report for any import.
Best Practices
- Start with the sample CSV, so your columns are in the format the app expects.
- Import a small test file first, then check a customer in Customers before importing everything.
- Use
customer_emailwhen moving from another app. Emails are usually easier to export than Shopify customer IDs. - Always read the error report before importing, so you know which rows were skipped and why.
Notes
- Customers must already exist in your Shopify store. Rows for customers who can't be found are skipped.
- Items a customer already has in that wishlist are not added again. They're counted as "already there".
- Guest wishlists can be exported, but they can't be imported, because a guest has no customer email or ID.
- Wishlist items saved to a customer's default wishlist export with a blank
wishlist_name, so they go back into the default wishlist when imported.
Troubleshooting
"Only .csv files can be imported." Save your spreadsheet as CSV (comma-separated values) and upload it again.
"The file must be smaller than 5 MB." Split the file into smaller files and import them one at a time. Each file can have up to 10,000 rows.
Some rows were skipped. Click Download error report to see the reason for each row. Common reasons:
| Reason | What to do |
|---|---|
| Missing customer_id and customer_email | Add an email or customer ID to the row |
| No customer matches that email / Customer not found in this store | The customer doesn't exist in Shopify. Create the customer first, or remove the row |
| Missing product_id and product_handle | Add a product ID or handle to the row |
| Product not found in this store | Check the product ID or handle. The product may have been deleted |
| Variant not found in this store / Variant does not belong to that product | Check the variant ID, or leave variant_id blank to save the product |
My columns weren't recognized. Rename your columns to match the table in CSV Format, or download the sample CSV and copy your data into it.
