Skip to main content

How to import Wishlist data into Growave

Learn how to prepare wishlist import file and import your customers' wishlists into Growave

Written by Simon Akhrameev

Overview

If you’re transitioning to Growave’s Wishlist feature from another app within the Shopify platform, this guide will assist you in importing your existing data seamlessly. By following the steps outlined below, you can ensure that your customers retain their favorite products in their wishlists, enabling you to utilize Growave's buying triggers effectively and boost your sales.


Step 1 – Download and prepare CSV files for wishlists import

Before you start importing wishlists, you need to download and fill relevant templates with correct data.

Growave - Import/Export - Import - Wishlists - Download wishlist CSV template

Required and optional fields in the Wishlist import template

Here are the required and optional fields for the CSV file with customers’ wishlists.

Column header name

Description

Requirement

email

Customer's email address

Required

Unique numerical Shopify ID of a customer (not required if email is provided)

Optional

product

Required

variant

Selected product variant (numbers at the end of the product URL)

Optional

date

Date the product was added to wishlist (format: YYYY-MM-DD; defaults to current date)

Optional

list_name

Name of the wishlist. If this field contains a value, the imported product will automatically be added to a wishlist with that name.

Optional

How to find customer and product details

Product ID

In Shopify admin, go to Products → select the product → the product ID is the number after "products/ " at the end of the URL:

Shopify admin - Products - select the product - product ID at the end of the URL

Product handle

Visit the live product page on your shop → the product handle is the text after "products/ " at the end of the URL:

Shopify product variant ID

Product variant

Visit the live product page on your shop → the product variant is the number after "variant= " at the end of the URL:

Shopify product variant ID

Customer ID

In Shopify admin, go to Customers → select the customer → the customer ID is the number after "customers/ " at the end of the URL:

Shopify customer ID

In this example, we will use the Google Sheets import template:

  • Click File menu → select Make a copy.

  • Add your customer's wishlist data into relevant columns.

  • Click File menu → DownloadComma separated values (.csv):

Growave Wishlist import CSV template - Google Sheets example

⚠️ Important

The CSV file size must be no more than 10 MB.


Step 2 – Upload the CSV file with wishlist data

After filling in the template with wishlist data, upload the file:

  • Go to your Growave admin → Import/Export → Import tab.

  • Click the Start import button to open the import modal.

  • Select Wishlist tab → click Upload file.

  • Click Next to start validation.

Growave admin - Import/Export - Import tab - Start import - Wishlist tab - Upload file.

Step 3 – Validate wishlist import file

Once you upload the CSV file and clicked Next, Growave starts validating the data to ensure it meets the required parameters.

  • If everything is correct, you’ll see a success message: "All records are valid and ready to be imported. Note: Some records might be skipped during import." Click Start import to proceed.

    Growave - Import/Export - Rewards - File validation completed successfully
  • If some records are invalid, Growave can still import the valid entries. You will see a message: "X records have errors and will be skipped. Note: Some records might be skipped during import." You can click Start import or Download error report to identify and fix the issues.

    Growave - Import/Export - Rewards - File validation completed with errors
  • If there are no valid records, you’ll be prompted to Download error report and fix the errors. Click Close after downloading the report.

    Growave - Import/Export - Rewards - File validation completed with no valid records

Step 4 – Start importing wishlists

  • Click Start import after successful validation.

  • The modal window will close and you will see the import history table with data on each import operation.

  • Depending on the number of lines in the file, importing may take some time.

  • After successful importing, you will see the Completed status and details about imported entries.

Growave - Import/Export - Import - Wishlist - Start import - Completed

Step 5 – View and manage import history

After you have completed validation or imported at least one file, you will see the Import history table under Growave adminImport/Export Import tab.

Growave - Import/Export - Import - Import history table - Wishlist

The Import history table includes the following columns:

  • Date: Date and time of the importing operation.

  • Type: The type of import operation corresponding to the selected option:

    • Wishlist.

  • Status: Shows import operation status, may display the following status:

    • Validating — validation is in progress.

    • Errors found — no valid records found, import cannot be continued.

    • Ready to import — validation is completed, import can be started.

    • Importing — importing is in progress.

    • Completed — import successfully completed.

    • Reverting — reverting data import is in progress.

    • Reverted — imported data has been deleted from the database.

  • Total: Total records found in the file.

  • Invalid: Invalid records that could not be imported.

  • Imported: Successfully imported records.

  • Skipped: Records that are valid but skipped during importing, e.g., because the same data already exists in the database. The Skipped records report will be available via Download icon.

  • Actions: Includes clickable links to perform certain actions:

    • Import: Appears when validation has been completed but importing is not started yet. Clicking it opens a modal displaying validation results. You can click Start import to proceed.

    • View: Appears when errors have been found. Clicking it opens a modal displaying validation results and a link to download error report.

    • Revert: Appears when import has been completed. Clicking it opens a confirmation modal with the following message: "All records imported from [filename].csv will be removed. This action cannot be undone." Click Revert to delete the imported wishlist data.


If you encounter any issues while importing wishlist data, contact us at [email protected] or use the chat icon in the bottom-right corner of you Growave admin panel. We're here to help! 🤗

Did this answer your question?