Import accounts

Giving customers credit should be easy. Thats why with Shopwaive we made it that way

Log in to Shopwaive

First, just open the Shopwaive app, click the left menu item labeled Import

Get the template

In the popup that appears, select to assign or increment customer balances and then click Get template to download a template CSV file to your local drive.

Assign balances using the Balance column

Note, you cannot use both the Balance and Increment columns in the same template

Increment balances using the Increment column

Copy and paste your customer's email address, existing credit balance or incremental deposit or debit, and any note you'd like to attach to the customer import transaction. The Email and either the Balance or Increment are required, while any transaction note is optional. You also have the option to include Shipping credits, this column accepts integer values, each shipping credit is equal to free shipping on a single order. Enter "1" to give free shipping on a single order, or "0" to defer giving newly imported customers shipping credits.

The Balance or Increment column can be any numeric value greater than or equal to 0. It does not require a currency symbol, but you can include it if it is convenient. Your balance currency will always be defined by the currency setting defined in Settings.

The total number of customers that can be imported and at any given time is limited depending on your Shopwaive subscription plan. Our team can temporarily lift these restrictions upon request and based on need, please email us at

Upload your customers

Ensure you save or export the template with your customer data as CSV (.csv file extension). Then simply click Upload or Drag and drop to import your data into Shopwaive. When the file upload is successful, your page will appear similar to the example provided below.

If you receive errors highlighted in red, follow the troubleshooting steps below or you can delete rows, make edits or changes to correct the issues. After making edits, click the Export button to save the file to your local drive and then simply drag it back into Shopwaive for revalidation

If you have trouble importing your customer data, try the troubleshooting steps listed here, otherwise you can skip this section and continue to Confirm and Import your customers

Troubleshooting imported customers

To ensure you are successful with importing your existing customer data, follow the guidance and requirements outlined below.

  1. Ensure you use the CSV template file by clicking Get template

  2. Only include data for the columns in the template, and do not change the column titles

  3. Check to be sure your customers email addresses are valid and are in the correct format

  4. Expiry dates and Shipping are optional, leave blank if you do not need to define an expiration or shipping credit. You can always change this later

  5. Only include numerical amounts greater than or equal to zero in the Balance column. The Increment column accepts values less than zero to perform a debit. In contrast, values greater than zero will perform a credit. Currency symbols are optional, but consider removing them if you receive errors. Define your store credit currency in the app Settings

  6. If you exceed the limit for max number of customers imported, contact our support team at, depending on your subscription plan we may lift these restrictions.

Confirm and Import your customers

After you confirm the data is ready, click Import to proceed to import your customers into Shopwaive. If you have customers that did previously have a Shopify account, a Shopify account is created for them.

Discover the powerful benefits of using Shopwaive. Give store credit to new leads or potential customers that have opted-in for email notifications. You can then send emails within Shopwaive or connect your Klaviyo account and send automated Account activation requests with a store credit offer to encourage first-time customers to visit your site and spend their welcome credit. Pretty neat, right? Yeah, we think so too! 🎉

Successful import

If the import is successful, you'll receive a success message and the import transactions take effect immediately. You can close the popup, you're done and your customer's credit is ready to be redeemed.

Most imports take effect within seconds. For large datasets with new customers without a previous account, allow an additional 2 seconds per new account. For each new customer you can estimate the time to complete using this formula:

No. of new customers x 2 seconds = ETA to complete

For example, you have 1,000 new customers without a previous Shopify account. The estimated time to import is calculated below:

1000 x 2 seconds = 2000 seconds / (60 seconds / 1 minute) = Est. 33 mins to import 1000 new customers

Last updated