Skip to main content

Exporting Wishlists

Wishlist data is most useful outside the app — in a spreadsheet you sort by demand, an email tool you segment with, or the system you plan restocks in. The export gives you every saved product with ...

Wishlist data is most useful outside the app — in a spreadsheet you sort by demand, an email tool you segment with, or the system you plan restocks in. The export gives you every saved product with the customer who saved it, as a CSV.

Export your wishlists

  1. Go to Wishlist > Wishlists

  2. Click Export CSV

  3. The download starts straight away

If you’ve filtered to Wishlists or Registries, the export follows that filter — so you can pull just your gift registries without editing the file afterwards.

What’s in the file

One row per saved product, not per list, so a customer with eight items appears eight times. Each row carries:

  • Customer email, name, ID - who saved it

  • Customer type - Customer if they were signed in, Guest if not. Guests have no Shopify customer record, so this tells you which rows you can match against your customer list

  • List name, type, event type, event date - which list it came from, and for registries what the occasion is

  • Product, SKU, variant, handle - what was saved

  • Quantity and Purchased quantity - how many they want, and for registries how many guests have already bought

  • Price when added - what it cost at the moment they saved it, which is what price-drop alerts compare against

  • Added at - when it was saved

What you can do with it

  • Restock planning - sort by product to see what’s wanted most, including items that are out of stock

  • Email segmentation - filter to one product and upload those addresses as an audience

  • Registry fulfilment - compare quantity against purchased quantity to see what’s still needed

  • Price-drop campaigns - compare price when added against today’s price

Notes

  • Deleted lists aren’t included

  • Very large stores are capped at 50,000 rows per file. If you hit that, filter to wishlists or registries and export each separately

  • Customers can also export their own single list from their wishlist page, which is a shorter file with just product, SKU and quantity

Did this answer your question?