Importing and exporting wishlists

Bring your customers' saved lists across from another wishlist app with one spreadsheet upload, so nobody loses what they saved when you switch.

Before you start

  • Import your products first. Every saved item points at a product Meisei already knows, so a list whose products aren't there yet is skipped. On Shopify the first sync does this for you; otherwise see Importing products.
  • Customers are optional. A customer Meisei hasn't seen is created from the email address in the file. Import customers first if you want their names on the new accounts.
  • Coming from Swym, Wishlist King, Growave or Wishlist Hero? Connect your Shopify store first. Those exports name products by Shopify ID, and without the connection every list is skipped.

Import a file

  1. Export your wishlists from your old app. Make sure it's the wishlist export, not a combined report.

  2. Open Wishlists and choose Import from the actions menu.

    The Import wishlists dialog with a file chosen and the Format picker

  3. Pick the Format that matches the app you're leaving, or Meisei if you built the file yourself (see the file format).

  4. Upload the file. The import runs in the background, so you can leave the page.

  5. Check the result under Settings → Imports. Any rows that couldn't be placed are listed with their row number and the reason. A competitor import normally finishes with a list of columns Meisei had no use for. That's expected.

    A finished wishlists import listing the lists it created

Export a file

Choose Export on Wishlists and the finished file appears under Settings → Exports. Any filter or search on the screen applies to the file, and an export can be edited and imported straight back in.

The Exports page with a finished wishlists export

Good to know

  • One row per saved item. Rows with the same customer email and list name are one list, wherever they sit in the file.
  • Importing the same file again updates the lists rather than duplicating them, and the items in the file replace what's on the list. Send the full set every time, not just the rows you changed. Renaming a list in the file creates a new one.
  • Most apps keep one unnamed list per customer. Those rows go on the customer's main list, the one the storefront saves to with one click. A second run is safe, and the customer doesn't end up with two lists. Leave Name for a customer's first list under Settings → Features → Wishlists alone while you're migrating.
  • One bad row skips its whole list, because importing the rest would leave the list half-filled. Fix the rows and import again.

What doesn't come across

  • Share links change. Meisei makes its own link for every list, so a link a customer already sent to a friend stops working. Whether a list was shared does come across.
  • Purchased items reset. Every item arrives unbought.
  • Guest lists are skipped. A list kept in a browser rather than against a customer has no email address to attach it to. Each one is listed on the import with its row number.

If something isn't working

Message on the jobWhat to do
"This file does not look like a ... export."You picked the wrong format or downloaded the wrong report. Nothing was imported; fix it and upload again.
"No product with the slug ... The wishlist ... was skipped."One saved product is missing, so the whole list was left out. Import your products or connect your Shopify store, then run the same file again.
"This row has no wishlist row before it."An item row has to come after its list's row. Fill in its customer and list name, or move it below its list.

See Imports and exports for the messages every import can show.

  • A column in your export has a different name than Meisei expects. Rename it in a spreadsheet to match the format for your platform, and tell us so we can fix the mapping.

Next steps