Skip to content

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 ​

  1. Open the app and click Import & export in the app menu.
  2. Under Export, find the file you want.
  3. Click Download CSV.
ExportWhat's in it
Wishlist itemsEvery saved item, one row each. This file can be imported back into the app
CustomersOne row per shopper, with their wishlist count, item count and last activity
Wishlisted productsOne row per product, with how many shoppers saved it

Import wishlist items ​

  1. Open the app and click Import & export in the app menu.
  2. 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.
  3. Drop your CSV file into the upload area, or click to choose it.
  4. Click Check file. The app checks every row against your store.
  5. Review the results: "X of Y rows are ready". If some rows will be skipped, click Download error report to see why.
  6. Click Import X rows to save them, or Cancel to stop. Nothing is saved until you click Import.
  7. 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.

ColumnRequiredDescription
customer_emailOne of these twoThe customer's email address
customer_idOne of these twoThe Shopify customer ID
product_idOne of these twoThe Shopify product ID
product_handleOne of these twoThe product handle, for example classic-canvas-tote
variant_idOptionalA specific variant. Leave blank to save the product
wishlist_nameOptionalThe wishlist to add the item to. Leave blank to use the customer's default wishlist
addedOptionalThe 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_email or customer_id, and product_id or product_handle.
  • IDs work either way: 1234567890 or gid://shopify/Product/1234567890.
  • Extra columns are ignored, and column names are flexible. For example, Email, Product ID, product-id and handle are all recognized, so files from other wishlist apps often work without editing.
  • If wishlist_name names 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 .csv files 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_email when 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:

ReasonWhat to do
Missing customer_id and customer_emailAdd an email or customer ID to the row
No customer matches that email / Customer not found in this storeThe customer doesn't exist in Shopify. Create the customer first, or remove the row
Missing product_id and product_handleAdd a product ID or handle to the row
Product not found in this storeCheck the product ID or handle. The product may have been deleted
Variant not found in this store / Variant does not belong to that productCheck 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.