# Sample Import Files

### **Member**

To add multiple members simultaneously, you can import an XML file containing member details. Ensure the file includes the information you need to migrate to Open Loyalty. A sample XML file for member import is available for reference.

{% hint style="info" %}
When not using certain fields, e.g. address details or labels, remove them from the XML file instead of leaving them empty.
{% endhint %}

{% file src="<https://2658975168-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FcNVX03KZzmrGwJihLiEx%2Fuploads%2F5aaXf9vKvxr8yRyPJQWD%2FMember%20Import.xml?alt=media&token=25a2a587-b87d-4fe9-b509-620f5a8caad5>" %}

{% file src="<https://2658975168-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FcNVX03KZzmrGwJihLiEx%2Fuploads%2FI15wpk5Z3shMvsVpYKzB%2FMember%20Import%20Example.xml?alt=media&token=bf02dd7e-935f-4714-8abd-f2a18570e6a0>" %}

***

### Member Segments

Static segments can be populated by importing a CSV file with a list of member identifiers. This method is useful for grouping members based on specific criteria.&#x20;

{% hint style="warning" %}
Ensure the CSV file retains the **header row** and lists the chosen identifiers - do NOT change or remove the header row (memberId), regardless of the identifier chosen
{% endhint %}

{% file src="<https://2658975168-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FcNVX03KZzmrGwJihLiEx%2Fuploads%2FOfTePoHxVvHTRVpye1mK%2FMember%20Segments.csv?alt=media&token=d4ff07bb-0780-4c5a-b847-2c6dcceb95cd>" %}

{% hint style="info" %}
To find out more, please refer to the article below:

[segments](https://help.openloyalty.io/main-features/members/segments "mention")
{% endhint %}

***

### **Transactions**

To record multiple transactions at once, you can import an XML file or a JSON file containing transaction details such as document number, purchase date, document type, SKU, name, quantity, transaction item value, and category.

{% file src="<https://2658975168-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FcNVX03KZzmrGwJihLiEx%2Fuploads%2F9OjhU16MHzf7unAqm6Bf%2FTransactions%20Import.xml?alt=media&token=b7212f97-5949-4ca1-b09b-2423dfb62600>" %}

{% file src="<https://2658975168-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FcNVX03KZzmrGwJihLiEx%2Fuploads%2F59AyYcy8Ih9MIqUYAIZo%2FTransactions%20Import.json?alt=media&token=9d027b81-0098-461e-bd28-d512be778806>" %}

***

### Transaction Matches

If you have transactions that need to be associated with specific members, use the Match Import feature. This involves importing an XML file that includes both transaction and corresponding member data to establish the correct associations. A sample XML file is provided for this purpose.

{% file src="<https://2658975168-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FcNVX03KZzmrGwJihLiEx%2Fuploads%2FdIkjmzIYdRNcbNPZosFQ%2FTransactions%20Match%20Import.xml?alt=media&token=cf48d3ce-2620-40cf-aa8a-a413a2a0c581>" %}

***

### **Redemption Codes**

To add multiple redemption codes to your campaign, import a CSV file containing redemption codes.

{% file src="<https://2658975168-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FcNVX03KZzmrGwJihLiEx%2Fuploads%2Fi370M6aqxomiajWfOLfY%2FRedemption%20Codes%20Import.csv?alt=media&token=4a50b88e-717e-4c61-8283-fe4beed97a13>" %}

Please refer to the Open Loyalty documentation for more detailed instructions on adding redemption codes.

{% hint style="info" %}
To find out more, please refer to the article below:

[redemption-code-campaign](https://help.openloyalty.io/main-features/campaigns/campaigns-and-referral-campaigns/creating-campaigns/trigger-types/redemption-code-campaign "mention")
{% endhint %}

***

### **Coupons**

To add multiple coupons to your rewards system, import a CSV file containing coupon codes and related details. This streamlines the process of updating your coupon database.

{% file src="<https://2658975168-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FcNVX03KZzmrGwJihLiEx%2Fuploads%2FbWfzchDfouCHIpirYiLR%2FCoupons%20Import.csv?alt=media&token=7d851f2f-5359-4405-a86f-9ef846e5cf08>" %}

Please refer to the Open Loyalty documentation for more detailed instructions on adding coupons.

{% hint style="info" %}
To find out more, please refer to the article below:

[adding-coupons](https://help.openloyalty.io/main-features/rewards/reward-list/adding-coupons "mention")
{% endhint %}

***

### Collections

Collections allow you to group values for use in campaign conditions. Import a CSV file with the desired values to create a collection. **Ensure the CSV file contains at least three records.**

{% file src="<https://2658975168-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FcNVX03KZzmrGwJihLiEx%2Fuploads%2FUQa39S0nR83LS3S29tcl%2FCollections%20Import.csv?alt=media&token=111446b9-9371-447a-a2a6-b6b790adf5a6>" %}

{% hint style="info" %}
To find out more, please refer to the article below:

[collections](https://help.openloyalty.io/main-features/collections "mention")
{% endhint %}

***

### Unit Transfers

To manage unit transfers, such as adding or deducting units, import XML or JSON files with the relevant details. Separate sample files are available for adding and spending units

**Adding Units:**

{% file src="<https://2658975168-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FcNVX03KZzmrGwJihLiEx%2Fuploads%2FoQb1lvuLnipHpVtcFylf%2FAdding.json?alt=media&token=41d673fa-6e32-47b0-8b37-f6c624c46fd6>" %}

{% file src="<https://2658975168-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FcNVX03KZzmrGwJihLiEx%2Fuploads%2FIPddc0CWKfob12VDYvCO%2FAdding.xml?alt=media&token=afb0b5ff-435d-433d-a810-f4028ff1f928>" %}

**Spending (Deducting) Units:**

{% file src="<https://2658975168-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FcNVX03KZzmrGwJihLiEx%2Fuploads%2FmfZDuuUZ9IVA3aGbDCuD%2FSpending.json?alt=media&token=e32e78b0-9e30-436b-b300-85af535f023a>" %}

{% file src="<https://2658975168-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FcNVX03KZzmrGwJihLiEx%2Fuploads%2FmhAdoceVfZCuAvs889RT%2FSpending.xml?alt=media&token=38719b19-af2c-473e-b9cc-803674ae68d8>" %}