Wishlist ImportUpdated a day ago

Import wishlist items into Wysh

Use the wishlist import tool to bulk add existing wishlist items into Wysh from a CSV file. This is useful when you are moving wishlist data from another system or restoring wishlist data for customers in your Shopify store.

Info:
Wishlist Import is available on Core, Premier, and Ultimate plans. It is not available on the Free plan.

Where to find Wishlist Import

In the Wysh app, go to Wishlists. The import area is where you will see the upload panel titled Upload a CSV file to import wishlists and the Import history table below it.

How to import wishlists

1. Open the Wysh dashboard:
In Wysh, go to View More > Import Wishlists to open the import screen.

2. Prepare your CSV file:
Create a CSV file with the required column headers and one wishlist item per row. The first row must be a header row with column names. Comma- or tab-separated files are supported.

3. Upload the file: 
In the Upload a CSV file to import wishlists panel, click Add file or drag and drop your file into the upload area.

4. Start the Import: 
Click Upload CSV to begin the import. Processing runs in the background, so you do not need to keep the page open the entire time.

5. Check the results: 
Review the Import history table to track progress. If some rows fail, those rows are counted separately so you can correct them and import them again.

Tip:
If you are importing a large file, start with a small sample first. This helps you confirm your column names and data format before importing everything.

CSV format

Your file must include a header row with column names. Wysh supports comma-separated and tab-separated files.

Required columns:

• product_id — The Shopify product ID for the wishlist item. The product must be active in your store.

• customer_id — The Shopify customer ID for the customer who owns the wishlist item. Every row must include a valid customer ID.

Optional columns:

• name — The wishlist name. Rows with the same customer and the same name are grouped into one wishlist. If this field is empty, Wysh uses My Wishlist.

• variant_id — The Shopify variant ID. Leave this empty if you want to import a product-level wishlist item without a specific variant.

• date_created — The original date the item was added. This date is applied to the wishlist item and also to the wishlist itself when a new wishlist is created from that row.

Example CSV

1name,product_id,variant_id,customer_id,date_created
2MyWishlist,8234567890123,45678901234567,7123456789012,2024-06-15 10:30:00

Note:
Each row represents one wishlist item. If multiple rows use the same customer_id and name, those items are grouped into the same wishlist.

Monitor import progress

After you upload a file, use the Import history section to review its progress and outcome.

When an import includes failed rows, the import can still complete successfully for the valid rows. Use the failed row count to identify what needs fixing.

When some rows fail:

If only some rows fail, the import still finishes for the rows that passed validation. Click the Rows failed count to download a CSV file containing the failed rows and their failure reasons. After correcting those rows, upload the file again.

Why an entire file can fail:

The whole file fails if any of these problems are found before row processing starts:

• A required column is missing from the header row, such as product_id or customer_id.

• The file is empty or cannot be read.

• The header row is invalid.

Why individual rows can fail:

A single row fails when that row contains invalid or incomplete data. Common reasons include:

• customer_id is missing or empty.

• The customer does not exist in Shopify.

• The product does not exist or is not active.

• variant_id is provided, but the variant does not exist or does not belong to the product.

• date_created is provided, but it cannot be parsed as a valid date.

• The same wishlist already contains that product and variant combination.

• The customer has reached the maximum number of wishlists allowed.

• The wishlist has reached the maximum number of items allowed.

Warning:
If a row fails because the product, variant, or customer does not exist in Shopify, updating the CSV alone will not help unless the Shopify data is valid too.

Best practices before you import

• Confirm that every customer_id belongs to a real Shopify customer.

• Make sure each product_id points to an active Shopify product.

• Only include a variant_id when you want to import a variant-specific wishlist item.

• Keep column names exactly as required in the header row.

• Test with a small file before importing a full dataset.

What happens after import

Imported rows create wishlist items for the matching customers in Wysh. If the wishlist named in the row does not already exist for that customer, Wysh creates it. If the name field is blank, the item is added to My Wishlist.

This means you can import a single default wishlist for each customer or organise data into multiple wishlists by using different values in the name column.