Wishlist Guru supports bulk wishlist data import via a structured CSV file. This allows you to migrate customer wishlists from any third-party wishlist app, internal database, or custom solution into Wishlist Guru without losing your customers’ saved products.
This guide walks you through how to import your existing wishlist data into Wishlist Guru — whether you’re migrating from another wishlist app or uploading data from your own system. Follow the steps below to get your customers’ wishlists restored quickly and accurately.
Step 1 — Prepare Your CSV File #
Your import file must be a comma-separated values (.csv) file. Below is a complete reference of all supported columns.
CSV Column Reference #
| Column Name | Required? | Description | Example Value |
|---|---|---|---|
| Required | Customer email address. Used to identify the customer in Wishlist Guru. | john@example.com | |
| product_id | Required | Shopify Product ID. Identifies which product is saved to the wishlist. | 7921020000000 |
| variant_id | Optional* | Shopify Variant ID. Required only if using the Multi Variant Wishlist feature. | 43999900000000 |
| price | Optional | Product price at time of saving. If omitted, the current product price is displayed. | 40.99 |
| image | Optional | Product image URL. If omitted, the default product image is used. | //cdn.shopify.com/… |
| title | Optional | Product title. If omitted, the current product title is fetched. | Yellow Watering Can |
| handle | Optional | Product handle (URL slug). Used to generate the product URL. | yellow-watering-can |
* variant_id is optional unless you are using the Multi Variant Wishlist feature. See Section 3 for details.
| ⚠️ Required Fields Only email and product_id are mandatory for every row. All other columns are optional — if omitted, Wishlist Guru will use the live product data from your Shopify store. |
Sample CSV Format #
Step 2 — Exporting Data From Your Current App #
How you export your data depends on the app you are currently using. Here are some general tips:
- From another Shopify wishlist app: Look for an “Export” or “Download Data” option inside your current app’s dashboard. Most apps export in CSV or JSON format.
- From a custom database: Run a SQL query to export the relevant fields and save the result as a .csv file. Make sure to map your column names to the Wishlist Guru format shown above.
- From a spreadsheet: If your data is already in Google Sheets or Excel, simply download it as a .csv file (File → Download → CSV).
Once you have your data exported, clean it up and rename columns to match the Wishlist Guru CSV format exactly before importing.
Step 3 — Multi Variant Wishlist Support #
Wishlist Guru includes a powerful Multi Variant Wishlist feature that allows customers to save a specific product variant (e.g., a specific size, color, or material) rather than just the overall product.
Should You Include variant_id in Your Import? #
| ℹ️ Multi Variant Wishlist If you want your customers to see the exact variant they saved (e.g., “Blue / Large”), you must include the variant_id column in your CSV. Without it, Wishlist Guru will default to displaying the overall product rather than a specific variant.If variant_id is not provided, the wishlist will still work — the product will simply appear without a pre-selected variant. |
How the Multi Variant Feature Works #
- Feature Enabled (Premium Plan): When the Multi Variant Wishlist toggle is enabled in your admin panel, Wishlist Guru uses the stored variant_id to display the exact variant the customer saved — including size, color, and other option selections.
- Feature Disabled or Not on Premium Plan: If variant_id is stored in the database but the Multi Variant Wishlist feature is not enabled (or you are not on the Premium plan), the wishlist will function normally. The overall product will be shown without any specific variant pre-selected. The stored variant_id data is preserved and will take effect as soon as you enable the feature.
- No variant_id in import: The first available variant of the product will be shown by default. This is standard behavior for wishlists that track products without variant-level detail.
| 🔒 Plan Requirement The Multi Variant Wishlist feature requires the Premium Plan and must be enabled from Wishlist Guru Admin → Settings → Multi Variant Wishlist. If the toggle is OFF, variant-level wishlist display will not be active regardless of whether variant_id is in the data. |
Step 4 — Submit Your File for Import #
Once your CSV is ready, reach out to the Wishlist Guru support team to process your import. We will review your file, validate the data, and import it into your store’s wishlist database.
- Prepare your CSV file following the column reference in Step 1.
- Double-check that every row has a valid email and product_id.
- If you want Multi Variant support, confirm variant_id is included for each row.
- Contact Wishlist Guru Support via the in-app chat or email support@webframez.com and attach your CSV file.
- Our team will confirm the import and let you know once it’s live.
Frequently Asked Questions #
What happens if a product_id in my CSV no longer exists in my Shopify store? #
Rows with invalid or deleted product IDs will be skipped during import. We recommend cleaning your data before submitting to ensure the best results.
Can I import wishlists for guest customers (no account)? #
Wishlist Guru associates wishlists with customer email addresses. If a guest customer does not have an email on record, their wishlist data cannot be imported.
Will importing overwrite my existing wishlist data? #
No. Imports are additive — existing wishlist items will not be removed. If a customer already has a product saved and the same product appears in your import file, it will not be duplicated.
My variant_id is stored but the Multi Variant feature is not showing — why? #
The Multi Variant Wishlist feature must be explicitly enabled in your Wishlist Guru admin panel. Storing variant_id in the database alone is not enough. Navigate to Wishlist Guru Dashboard→ Multi Variant Wishlist and toggle it ON. This feature is available on the Premium Plan.
