Import wishlists

Moving to Toki from another wishlist app? You can bring your customers' saved products with you in one CSV upload. Toki matches each row to a customer by email, creates a profile for anyone who is not a member yet, and adds the products to their wishlist. You can run the import as many times as you need without creating duplicates.

Before you start

Your Toki account needs permission to view and edit members.
The products in your file need to exist in your Shopify store. Toki looks each product up in your store before adding it to a wishlist.
Your file must be a CSV. Other file types are not accepted by the upload area.

Prepare your CSV file

Start from the template so the column names match.

Open the Wishlist Import page in the Toki app. If you can't find it, chat with us and we'll send you the link.
Under CSV File, click Download template. You get a file named wishlist_import_template.csv with the right columns and one example row.
Fill it with your customers' saved products, one product per row. A customer with five saved products gets five rows with the same email.
Save it as a CSV.

Column	Required	Also accepted as	What goes in it
Email	Yes	UserEmail	The customer's email address. Toki uses it to find the member or to create a new profile.
ProductId	Yes	ProductID	The product's Shopify ID, as a number, for example 1234567890.
VariantId	No	VariantID	The Shopify ID of a specific variant, for example a size or color.
Date	No	CreatedDate	A date and time in the same format as the template, for example 2026-04-15 13:18:58.
CustomerId	No	CustomerID	The customer's Shopify customer ID.

A few things that make life easier:

Spaces inside a header are ignored, so Product Id works the same as ProductId.
Toki also accepts the header names some wishlist apps use in their exports (see Also accepted as), so you may be able to upload your old app's export without renaming anything.
Optional columns can be left empty or left out of the file.
Rows without an email are skipped automatically.

To find a product's Shopify ID, open the product in your Shopify admin. The number at the end of the page address is the product ID. Open a variant the same way to see its variant ID.

Import the file

On the Wishlist Import page, drag your CSV into the upload area under CSV File, or click the area to pick the file. The upload takes one file at a time. To swap it, drop another file and it replaces the first.

Check the two lists that appear below the upload area. Expected Columns shows what Toki looks for, Detected Columns shows what it found in your file:

Marker	Meaning
[OK]	Column found.
[X]	Required column not found in your file.
[ ]	Optional column not in your file. That's fine.
[?]	A column in your file that is not part of the template. Handy for spotting typos.

If a required column is not found, Toki shows "Required columns were not found. The file must contain email and product identifiers." Fix the header names in your file and upload it again.

Click Start Wishlist Import. Stay on the page while it runs. The button shows a loading state until the import finishes.

Read the results

When the import finishes, you see a message that says "Wishlist import finished" with the number of users synced, and an Import completed. summary on the page:

Line	What it means
Total rows	How many rows were in your file.
Valid rows	Rows that had both an email and a product ID.
Rows without email	Rows skipped because the Email column was empty.
Rows without product ID	Rows skipped because the ProductId column was empty.
Users attempted	How many different customers Toki tried to update.
Users created	Customers who were not in Toki yet. Toki created a profile for each of them.
Users synced	Customers whose wishlist was updated.

If some rows were skipped, look for rows in your file with an empty Email or ProductId column, fill them in, and run the import again. Re-importing only adds what is not there yet, so the rows that already went through stay untouched.

Where imported items go

Imported items go into a wishlist collection called Favorites on each customer's account. If the customer does not have that collection yet, Toki creates it during the import.

Run the import again

You can run the import more than once, for example to import in batches or to fix rows that were skipped the first time. Each run only adds items that are not in the customer's Favorites collection yet. Items the customer added themselves stay where they are, and nothing gets added twice.