> For the complete documentation index, see [llms.txt](https://docs.shopwaive.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.shopwaive.com/shopify/customers/import-accounts.md).

# Import accounts

Giving customers a balance should be easy. That's why with Shopwaive we made it that way

{% hint style="info" %}
Start creating, importing, or migrating customer accounts from another platform. Need to create or update existing accounts? See [Create or Update accounts](#create-or-update-accounts-with-bulk-import)
{% endhint %}

## Delete accounts with Bulk import

{% hint style="warning" %}
Deleting accounts is an irreversible action, ensure you create a backup before proceeding
{% endhint %}

Delete inactive, dormant, or terminated accounts with our Bulk import Delete Accounts mode. Follow the steps below to delete accounts via a bulk import operation.

Importing accounts in this mode will mark them for immediate deletion, including all related customer data including transaction history. This action is irreversible, and cannot be changed. Export your customer data first to keep a copy, or contact us at <support@shopwaive.com> before you start.

This action only deletes Shopwaive data associated with customers and does not delete any Shopify data. Delete accounts when they are inactive or you want Shopwaive to stop serving them.

Deleting accounts can help reduce your monthly expenditure by reducing your total accounts subject to usage fees that Shopwaive services. You'll use the same CSV template used for importing customers. When you delete customers the same import template is required but only data in the Email column is used to mark customers for deletion, all other column data is ignored and can be left blank

Open the app, visit the **Customers** menu, and click **Import** at the top right

<figure><img src="https://1743155819-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6HSAZj4RDucpQwVtzMYt%2Fuploads%2Fgit-blob-84685b40554820578fe50926ae9b17c4c192715d%2Fapp-customers.jpg?alt=media" alt="The Customers page, with Import at the top right"><figcaption><p>Click Import at the top right of the Customers page</p></figcaption></figure>

Once you click **Import**, at the bottom right of the top card click the link labeled **I want to delete accounts**, this will activate **Delete mode.** If you need the template, click **Download the CSV import file** before you do: the link is not shown in Delete mode.

To delete accounts, You'll use the same CSV template used for importing customers. In the template, populate the Email column with emails of the accounts that you want to delete. Only the Email column will be used to delete accounts with matching emails on file. All other column data is ignored and can be left blank, however, the header columns of the downloaded import template are still required to complete the bulk delete operation.

<figure><img src="https://1743155819-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6HSAZj4RDucpQwVtzMYt%2Fuploads%2Ffm2N6TjTBYaXgjH3Mp7d%2Fimage.png?alt=media&amp;token=b2731866-c00f-42c2-8e14-39a84fe95f7b" alt=""><figcaption></figcaption></figure>

After adding the account emails, drag and drop your import CSV file into the drop zone or click **Add file** to upload from a local drive.

Before you delete, click **Create a backup** to download the transaction history of the accounts in your file. When you are ready, click the **Delete accounts** button at the top right of the page. A window will appear to ensure you want to proceed. After proceeding, your accounts and associated transaction data will be deleted immediately.

Upon successful deletion, a toast message will appear at the bottom of the page, "*Accounts deleted"*

After accounts are deleted, you are no longer charged usage (servicing) fees for these accounts.

Have any questions on deleting accounts? Reach out to our team at <support@shopwaive.com>, we're here and happy to help

## Delete accounts from Settings

In **Settings** > **General**, find **Delete Accounts**. Click **Delete customer accounts**. In the window, click **Delete all accounts** to delete every Shopwaive account, or **Delete only accounts without a balance**. Either button deletes at once; close the window to keep them. This option is reserved as an irreversible nuclear option and should be avoided unless you have completed an export to backup your data or are working in a development environment where data is not necessary to retain.

<figure><img src="https://1743155819-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6HSAZj4RDucpQwVtzMYt%2Fuploads%2Fgit-blob-8ea235c525b3fe5be190414570fbc415d34cc807%2Fapp-settings-general.jpg?alt=media" alt="Settings, General, with Delete Accounts and its Delete customer accounts button"><figcaption><p>Settings > General</p></figcaption></figure>

## Create or update accounts with Bulk import

{% hint style="info" %}
If you have developer support, you can also create and import accounts using the [Shopwaive API](https://api.shopwaive.com). Have questions? Reach out to our team at <support@shopwaive.com>, we're glad to help
{% endhint %}

First, navigate to the **Customers** menu, then click **Import**

<figure><img src="https://1743155819-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6HSAZj4RDucpQwVtzMYt%2Fuploads%2Fgit-blob-84685b40554820578fe50926ae9b17c4c192715d%2Fapp-customers.jpg?alt=media" alt="The Customers page, with Import at the top right"><figcaption><p>Click Import at the top right of the Customers page</p></figcaption></figure>

## Get the template

Click **Download the CSV import file** to download the template CSV file to your local drive

{% hint style="info" %}
Target Shopify's [Store Credit Primitive and API](https://www.shopify.com/blog/store-credit) during bulk import: under **Choose an import target**, select **Shopify's Store Credit Primitive and API**. Choose the target first, before you choose an import type or add a file. With this target only the Increment import is offered. Shopify's native store credit requires new customer accounts. You can use Shopify's native store credit feature in combination with Shopwaive balances and the Redeem block
{% endhint %}

## Assign balances using the Balance column

Select **Assign customer Shopwaive balances** to set each customer's balance to the value in the **Balance** column. An Expiry date applies to the customer's total balance.

Columns of the template `Set balances.csv`: `First name`, `Last name`, `Email`, `Balance`, `Expiry`, `Tags`, `Note`

{% hint style="info" %}
Note, you cannot use both the Balance and Increment columns in the same template. Choose the import type before you add your file and do not change it afterwards: the type selected when you click **Import** decides whether each amount replaces the customer's balance (Assign) or is added to it (Increment).
{% endhint %}

## Increment balances using the Increment column

Select **Increment customer Shopwaive balances** to add the value in the **Increment** column to each customer's balance. A negative value removes that amount from the balance. With **Multiple expiry dates** selected under **Settings** > **Balances** > **Expiration**, an Expiry date applies only to the added amount. With **Single expiry date**, it becomes the expiration date of the customer's whole balance.

With [Budgets](https://docs.shopwaive.com/shopify/budgets.md) on, each row of an Increment import creates a budget: **Note** is the budget's name, which people see at checkout, and **Expiry** is its expiry date. Before the preview, Shopwaive checks the file and shows anything it tidied or needs you to answer. Answer any question, then click **Import with these changes**, or click **Cancel** to import nothing.

<figure><img src="https://1743155819-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6HSAZj4RDucpQwVtzMYt%2Fuploads%2Fgit-blob-f3a0006908729c3f5b3f7a618d4b08a1a1ad2d79%2Fcustomers-import.png?alt=media" alt="The Customers import: Choose an import type, Download the CSV import file, Choose an import target and Add file"><figcaption><p>Customers, Import: choose the type and the target, then add your file</p></figcaption></figure>

Columns of the template `Increment balances.csv`: `First name`, `Last name`, `Email`, `Increment`, `Expiry`, `Tags`, `Note`

Copy and paste your customer's email address, existing balance or the amount to add or remove, and any note you'd like to attach to the customer import transaction. The Email and either the Balance or Increment are required. First name, Last name, Expiry, Tags and Note can be left empty, but keep every template column. With **Shopify tags and notes** on under **Settings** > **Balances** > **Import tags and notes**, Tags and Note are also added to the Shopify customer.

{% hint style="info" %}
The Balance column takes a number of 0 or more. In an Assign import, an empty or negative Balance is refused before anything imports, with its row: enter 0 to set a balance to zero. The Increment column also takes a negative number, which removes that amount from the balance. Neither column requires 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**: an amount in another currency (for example EUR10.00 or £10 in a USD store), or with a third decimal that is not 0, is refused with its row.
{% endhint %}

The number of rows you can import does not depend on your subscription plan. The import handles 5,000 rows at a time: split a larger list into files of 5,000 rows or fewer.

## Upload your customers

Save or export the template with your customer data as CSV (.csv file extension), or as an Excel workbook (.xlsx) with one sheet. Then click **Add file**, or drag and drop the file, to load your data into Shopwaive. Shopwaive checks the file first (see [Check before import](#check-before-import)). When the file is ready, a preview lists each row with a Totals row at the top, ready to import.

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**

## Check before import

Before anything imports, Shopwaive checks the whole file and shows one banner above the file field. Nothing is imported until the file is ready.

* **A file it cannot read** gets its reason and what to do: an empty file, column names with no customers, a first row that is a customer instead of the column names, no Email or amount column, a PDF, an image, a .zip, an Excel 97-2003 workbook (.xls), a workbook with more than one sheet, or an Apple Numbers file. Save it as CSV UTF-8, or as an .xlsx workbook with one sheet, and add it again.
* **Every problem is listed by row, column, value and what to change**, for example `Row 4, Email (column C): "alex @example.com" has a space in it. Change it to alex@example.com.` Ten show at once (three on a phone); click **Show all** for the rest. On a computer, click **Download problem list** for all of them as a CSV file.
* **Apply suggested fixes** makes the changes that are about how a cell is written: a space or marks around an email address, a column name such as E-mail, Amount or Expiration, a missing Expiry, Tags or Note column (added empty), semicolons or tabs between columns, a date written in your file's or your store's date order, or "never" in the Expiry column. An amount is never changed: in a file with semicolons or tabs between its columns, an amount or Shipping value with a comma and no dot after it (12,500) is refused with its row (write it with no comma and a dot before any decimals); one such as $1,250.00, which Excel's Unicode Text writes, is read as 1250.00. Shopwaive makes up to 50 changes, on no more than 1 row in 10 (5 rows in a small file); past that, change the file and add it again. Check the preview, then click **Import**.
* **Rows to check**: the same customer twice, or a removal larger than the customer's balance. Click **Import anyway** to import the file as written.
* **Dates**: your file's own dates decide first. A date that can mean only one day, such as 12/31/2027 (month first) or 31/12/2028 (day first), shows the file's date order, and a date such as 01/09/2028 is read in that order. A file with no such date is read in your store's date order (day first or month first, from your store's country). Shopwaive asks before it changes a date. In a file with dates written both ways, a date such as 01/09/2028 is refused with its row: write it as YYYY-MM-DD. YYYY-MM-DD, for example 2028-09-01, reads the same in every store. A date Excel saved as a number (46997) and a date with the day first that can mean only one day (31/12/2028) are read as that day.

A file Shopwaive refuses is recorded in the **Change log** and in **Logs**, with how many rows it had and why. No customer data is recorded.

## Wallet and Wallet ID columns (optional)

Leave them out, or leave them blank, to change the Shopwaive balance, as every import does. **Wallet** also takes `Shopwaive balance`, `General` or `Primary wallet`. At a store with [Budgets](https://docs.shopwaive.com/shopify/budgets.md) on, a budget's name in Wallet is moved to Note, where an Increment import reads the budget's name, when you apply the suggested fixes. Any other wallet name, or `Loyalty points` (loyalty points are part of the Shopwaive balance), is refused with its row, never guessed. **Wallet ID**: Shopwaive checks every ID before anything imports, and takes only the customer's own wallet at your store; an ID of another customer's wallet, or of no wallet here, is refused with its row. The 4-digit short ID that **Copy wallet ID** gives on a customer's page is not read by an import: leave Wallet ID blank to change that customer's Shopwaive balance.

## 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 **Download the CSV import file**
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 is optional: leave the cell blank for no expiration. A date must be after today. YYYY-MM-DD, for example 2028-09-01, reads the same in every store; see [Check before import](#check-before-import) for other ways to write a date. Replace the template's example row: its Expiry is the date you downloaded the file, which the import refuses
5. Only include numerical amounts greater than or equal to zero in the **Balance** column. The **Increment** column accepts values less than zero to remove an amount. In contrast, values greater than zero will add to the balance. Currency symbols are optional, but consider removing them if you receive errors. Define your balance currency under **Settings** > **Balances** > **Currency**
6. Split a large list into files of 5,000 rows or fewer: the import handles 5,000 rows at a time.

## 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 not previously have a Shopify account, a Shopify account is created for them.

{% hint style="info" %}
Discover the powerful benefits of using Shopwaive. Add balances for new leads or potential customers that have opted-in for email notifications. The import creates a Shopify customer for each email address that has none; it does not send an account invite. With a [branded sending domain](https://docs.shopwaive.com/shopify/install/setup-branded-email.md) set up, you can then send emails within Shopwaive to encourage first-time customers to visit your site and spend their welcome balance. Pretty neat, right?
{% endhint %}

## Successful import

If the import is successful, you'll receive a success message and the import transactions take effect immediately (with the exception to large datasets described below).

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

**No. of&#x20;*****new*****&#x20;customers** x **7 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:
>
> 1,000 accounts x 7 seconds = 7000 seconds / (60 seconds / 1 minute) = Approximately 2 hours to import and sync 1,000 new Shopify customers

Alternatively, if all your imported accounts already have a Shopify account and you only need to update their Shopwaive data, you can estimate the time to complete an import to update Shopwaive data by assuming 5 ms per transaction.

For example, you have 1,000 transactions to update. The estimated time to complete the Shopwaive data updates with bulk import is:

> 1,000 transactions x 5 milliseconds = 5,000 milliseconds, or approximately 5 seconds to import and sync 1,000 transactions
