Data import

You can upload CSV files straight from the dashboard. 

Contents

  1. Imports overview
  2. Guidelines
  3. Notifications
  4. Troubleshooting & Audit
  5. Examples

Import through API

For more information about importing files through the API, visit the following resources:
    Import vouchers.
    Import vouchers to campaign.
    Import customers.
    Import products.
    Import SKUs.

Imports overview

You can import vouchers, customers, products and SKUs. Importing is a three-step process.

  1. Prepare import CSV file. Below you will find a table with example CSV files.
    2. CSV file template Dedicated tutorial
    Import_standalone_discount_vouchers.CSV
    		 Import standalone discount vouchers
    Import_standalone_gift_cards.CSV
    		 Import standalone gift cards
    Import_loyalty_cards_into_campaign.CSV Import loyalty cards into a campaign
    Import_discount_vouchers_into_campaign.CSV Import discount vouchers into a campaign
    Import_gift_cards_into_campaign.CSV Import gift cards into a campaign
    Import_customers.CSV
    		 Import customers
    Import_products.CSV Import products
    Import_skus.CSV
    		 Import SKUs
  2. Map fields and attributes

    Navigate and click on the import icon for the given import type. Map CSV column titles to Voucherify fields and any custom fields in the dashboard. On the left-hand side, you can see the CSV column names (1) that need to be mapped to fields from a  Select property list (2). After selecting the matching field, choose the Plus (3) to confirm mapping.Mapping screenshot

  3. Import data by clicking import to confirm. You will be notified when the import is completed in the Notifications Center.

    Notifications

Guidelines

There are few things you need to know before starting the import. Here are some guidelines to follow for importing data into Voucherify:

  • Is there a limit to the amount of data I can import? The import file size is 10 megabytes for all import types.
  • Note that dates and date-time attributes need to be provided in compliance with the ISO 8601 norms. For example, 2022-03-11T09:00:00.000Z or 2022-03-11.
  • Columns that can't be mapped to standard fields, will be mapped to Custom attributes and added as metadata. There is no limit on the number of custom attributes that you can import as metadata. To provide the proper data type, you need to add all custom attributes to the metadata schema before importing the file.
  • Headers with metadata names can't contain white-space characters.
  • If you import metadata defined in the schema as arrays (multiple), you need to separate each value using a comma, for example:
    • array of strings: "subscribed,premium"
    • array of numbers: "123,234"
    • array of dates: "2000-01-01,2000-01-02"

Notifications

You can set custom notifications for data import by going to the Notifications Center > Personal Settings.

Troubleshooting & Audit

Once your import is finished you can find its status under the notification bell icon, whether it was successful or failed.

If you receive an error during your data import attempt, you can check the details regarding the problem in your dashboard in the Audit Log. You can find it at the bottom of the left hand side menu as shown on the screenshot below.

This will guide you to what to change in your import CSV to get the import through. 

Note that if the number of errors in one import exceeds 100 then the import process is automatically stopped.

Examples

Below you will find a couple of CSV file examples.

Note that only metadata that is NOT nested will be imported correctly.

Vouchers

We'll begin with showing some examples for the different voucher types that you can import to Voucherify.

Standalone discount vouchers

You can import the following fields for standalone vouchers:

Reference Field Definition
A
Code
*required 		The unique discount code.
B
Voucher Type
*required 		The voucher type for discount vouchers is:  DISCOUNT_VOUCHER
C
Active Use TRUE or FALSE to enable or disable the voucher; this flag can be used to turn off the ability to redeem a voucher even though it is within its start/end validity timeframe.
D
Start Date Provide voucher start date in compliance with the ISO 8601 norms. For example, 2022-09-19T00:00:00.000Z.
E
Expiration Date Provide voucher expiration date in compliance with the ISO 8601 norms. For example, 2022-11-30T00:00:00.000Z.
F
Discount Type
*required 		The options to choose from are:  AMOUNT, PERCENT, FIXED, UNIT.
G
Value
*required
Discount Type
AMOUNT
PERCENT
FIXED
UNIT
The discount value.

Value
An integer value, i.e. 20.
An integer value representing a percent, i.e. 10.
An integer value representing a fixed amount, i.e. 30.
An integer value representing the number of units to be applied to the order, i.e. 2.
H
Category A custom tag for the voucher to help you filter codes.
I
Redemption Limit Maximum number of redemptions allowed. If you leave this undefined, it will default to unlimited.
J
Redeemed Quantity Number of times the voucher was redeemed. If you leave this undefined, it will default to 0.
K
Additional Info Any additional information you would like to store about the voucher.
L
Custom_metadata_property Any additional data that you would like to store for the given voucher as a Custom attribute. Remember to define the metadata schema in the Dashboard prior to importing codes. Read more.
CSV example
A B C D E F G H I J K L
Code Voucher Type Active Start Date Expiration Date Discount Type Value Category Redemption Limit Redeemed Quantity Additinal Info Custom_metadata_property
SUMMER2023 DISCOUNT_VOUCHER FALSE 2023-05-19T00:00:00.000Z 2023-09-30T23:59:00.000Z AMOUNT 10 New 3 2 Planned release in Summer 2023 Europe

You can see below how the data will appear in Voucherify. Follow the column headers in the example above to the matched location in the screenshots below. The first screenshot shows how the data will be displayed in the Vouchers section.

Vouchers view

This screenshot shows how the details will be displayed for the given voucher.

Dashboard view
CSV File Template

Import_standalone_discount_vouchers.CSV

Standalone gift cards

You can import the following fields into Voucherify for Gift cards:

Reference Field Definition
A
Code
*required 		The unique gift card code.
B
Voucher Type
*required 		The voucher type for discount vouchers is: GIFT_VOUCHER
C
Active Use TRUE or FALSE to enable or disable the gift card; this flag can be used to turn off the ability to redeem a gift card even though it is within its start/end validity timeframe.
D
Start Date Provide gift card start date in compliance with the ISO 8601 norms. For example, 2022-09-19T00:00:00.000Z.
E
Expiration Date Provide gift card expiration date in compliance with the ISO 8601 norms. For example, 2022-11-30T00:00:00.000Z.
F
Value The initial gift card balance to be added.
G
Category A custom tag for the gift card to help you filter codes.
H
Redemption Limit Maximum number of redemptions allowed. If you leave this undefined, it will default to unlimited.
I
Redeemed Quantity Number of times the gift card was redeemed.
J
Redeemed Amount Amount that was redeemed from the available balance on the gift card.
K
Additional Info Any additional information you would like to store about the gift card.
L
Custom_metadata_property Any additional data that you would like to store for the given gift card as a Custom attribute. Remember to define the metadata schema in the Dashboard prior to importing codes. Read more.
CSV example
A B C D E F G H I J K L
Code Voucher Type Active Start Date Expiration Date Value Category Redemption Limit Redeemed Quantity Redeemed Amount Additional Info Region
GIFT200 GIFT_VOUCHER FALSE 2022-05-01T00:00:00.000Z 2022-12-31T23:59:00.000Z 200 Gift 1 50 Birthday gift card Europe

You can see below how the data will appear in Voucherify. Follow the column headers in the example above to the matched location in the screenshots below. The first screenshot shows how the data will be displayed in the Vouchers section.

Vouchers view

This screenshot shows how the details will be displayed for the given gift card.

Dashboard view
CSV File Template

Import_standalone_gift_cards.CSV

Add loyalty cards to a campaign

You can import the following fields into Voucherify for Loyalty cards into a Loyalty Campaign:

Reference Field Definition
A
Code
*required 		The unique loyalty card code.
B
Active Use TRUE or FALSE to enable or disable the loyalty card; this flag can be used to turn off the ability to redeem a loyalty card even though it is within the campaign's start/end validity timeframe.
C
Loyalty Points The number of points to be added to the loyalty card. If you leave this undefined, then the initial number of points will be set according to the campaign settings.
Note that this option works only for the newly added loyalty cards. If the card existed before, the update of points is not possible this way - the balance put in the CSV file will be ignored. However, there is a dedicated API endpoint to adding points: Add or Remove Loyalty Card Balance, so you can use it to implement changes.
D
Category A custom tag for the loyalty card to help you filter codes.
E
Custom_metadata_property Any additional data that you would like to store for the given loyalty card as a Custom attribute. Remember to define the metadata schema in the Dashboard prior to importing codes. Read more.
CSV example
A B C D E
Code Active Loyalty Points Category Season
Loyalty100 FALSE 100 Grand-Opening Spring

You can see below how the data will appear in Voucherify. Follow the column headers in the example above to the matched location in the screenshots below. The first screenshot shows how the data will be displayed in the Vouchers section.

Vouchers List View
Vouchers view

This screenshot shows how the details will be displayed for the given loyalty card.

Loyalty Card View
Dashboard view
CSV File Template

Import_loyalty_cards_into_campaign.CSV

Add discount vouchers to a campaign

You can import the following fields for vouchers into a specific campaign:

Reference Field Definition
A
Code
*required 		The unique discount voucher code.
B
Active Use TRUE or FALSE to enable or disable the voucher; this flag can be used to turn off the ability to redeem a voucher even though it is within the campaign's start/end validity timeframe.
C
Category A custom tag for the voucher to help you filter codes.
D
Redeemed Quantity The number of times the voucher was already redeemed.
E
Custom_metadata_property Any additional data that you would like to store for the given voucher as a Custom attribute. Remember to define the metadata schema in the Dashboard prior to importing codes. Read more.
CSV example
A B C D E
Code Active Category Redeemed Quantity Region
FALL2022 FALSE New 4 Europe

You can see below how the data will appear in Voucherify. Follow the column headers in the example above to the matched location in the screenshots below. The first screenshot shows how the data will be displayed in the Vouchers section.

Vouchers List View
Vouchers view

This screenshot shows how the details will be displayed for the given discount voucher.

Dashboard view
CSV File Template

Import_discount_vouchers_into_campaign.CSV

Add gift cards to a campaign

You can import the following fields for gift cards into a specific campaign:

Reference Field Definition
A
Code
*required 		A unique gift card code.
B
Active Use TRUE or FALSE to enable or disable the gift card; this flag can be used to turn off the ability to redeem a voucher even though it is within the campaign's start/end validity timeframe.
C
Gift Amount The initial gift card balance.
D
Category A custom tag for the gift card to help you filter codes.
E
Redeemed Quantity The number of times the gift card was redeemed.
F
Redeemed Amount The amount that has been redeemed from the available balance on the gift card.
G
Custom_metadata_property Any additional data that you would like to store for the given gift card as a Custom attribute. Remember to define the metadata schema in the Dashboard prior to importing codes. Read more.
CSV example
A B C D E F G
Code Active Gift Amount Category Redeemed Quantity Redeemed Amount Region
GIFT1000 FALSE 1000 New 4 25 Europe

You can see below how the data will appear in Voucherify. Follow the column headers in the example above to the matched location in the screenshots below. The first screenshot shows how the data will be displayed in the Vouchers section.

Gift Card in Voucher List View
Gift Card in Vouchers view

This screenshot shows how the details will be displayed for the given gift card.

Gift Card View
Dashboard layout for given gift card
CSV File Template

Import_gift_cards_into_campaign.CSV

Customers

You can import the following fields into Voucherify for Customers:

Reference Field Definition
A
Name Customer's first and last name.
B
Source_id

Custom unique customer ID; for example, a customer ID stored in your CRM database that will help you easily identify this customer.

Please note that if you would like your data to sync based on the source_id of the customer, you need to import the source_id on the first customer upload. You will not be able to change or update the source_id later on.
C
Description Any additional information you would like to store about the customer.
D
Email Customer's email address.
E
Phone Customer's phone number.
F
Address_line_1 Address line
G
Address_line_2 Address line
H
City City
I
Postal Code Postal code
J
State State
K
Country Country
L
Birthdate Customer's birthdate; format:  YYYY-MM-DD
M
Custom_metadata_property Any additional data that you would like to store for the given customer as a Custom attribute. Remember to define the metadata schema in the Dashboard prior to importing customers. Read more.
CSV example
A B C D E F G H I J K L M
Name Source_id Description Email Phone Adress_line_1 Adress_line_2 City Postal_Code State Country Birthdate favorite_brands
John Smith test-user@voucherify.io A good customer. test-user@voucherify.io 1 (989) 123-4632 100 Main St Blg 2 Apt 3 New York 12345 New York United States 2022-07-03 "Nike, Fenty, Reebok"

You can see below how the data will appear in Voucherify. Follow the column headers in the example above to the matched location in the screenshot below.

Customer Dashboard Screenshot
Dashboard layout
CSV File Template

Import_customers.CSV

Products

You can import the following fields into Voucherify for Products:

Reference Field Definition
A
name
*required 		Product name
B
source_id Custom unique product ID; for example, a product ID stored in your CRM database that will help you easily identify this product.
C
price Product price
D
attributes A list of product attributes whose values you can customize for given SKUs. Define your attributes here and then you can set a value for these attributes in SKUs. For example,  "color,size,ranking".
E
image_url The HTTPS URL pointing to the .png or .jpg file.
F
Custom_metadata_property Any additional data that you would like to store for the given product as a Custom attribute. Remember to define the metadata schema in the Dashboard prior to importing products. Read more.
CSV example
A B C D E F
name source_id price attributes image_url Metadata_property_name
Shirts productSourceID11 21 "color,size,ranking" https://images.com/original.jpg 2000-01-01T10:00:00.000Z

You can see below how the data will appear in Voucherify. Follow the column headers in the example above to the matched location in the screenshot below.

Product Dashboard Screenshot
Dashboard layout
CSV File Template

Import_products.CSV

SKUs

You can import the following fields into Voucherify for SKUs:

Reference Field Definition
A
product_id
*required 		This value is the source_id that belongs to the parent product. This is required in order to connect the child SKU to the parent Product.
B
sku The name of the given SKU.
C
source_id
*required 		Custom unique SKU ID; for example, a SKU ID stored in your CRM database that will help you easily identify this product.
D
price The SKU price.
E
image_url The HTTPS URL pointing to a .png or .jpg file.
F
attributes Once you have attributes defined for the product, you can set a value for this attribute for a given SKU. Format is important here. Within brackets { } surrounded by double quotations " ", you create a list separated by commas ,. Each list item consists of 1) the attribute defined on the product level, 2) the value for the given SKU. These elements are separated by a colon :. Each attribute must be surrounded by a single quotation ' '. The value can be surrounded by a single quotation if it is a string, and left without the quotation if it is a number. For example, "{'color':'blue','size':'XS','ranking':4}".
CSV example
A B C D E F
product_id sku source_id price image_url attributes
productSourceID11 Extra Small Blue Shirt sku_source_id_1 13 https://images.com/blue-extra-small.jpg "{'color':'blue','size':'XS','ranking':1}"
productSourceID11 Small Red Shirt sku_source_id_2 14 https://images.com/red-small.jpg "{'color':'red','size':'S','ranking':2}"
productSourceID11 Medium Yellow Shirt sku_source_id_3 14.50 https://images.com/yellow-medium.jpg "{'color':'yellow','size':'M','ranking':3}"
productSourceID11 Large Pink Shirt sku_source_id_4 17 https://images.com/pink-large.jpg "{'color':'pink','size':'L','ranking':4}"

You can see below how the data will appear in Voucherify. Follow the column headers in the example above to the matched location in the screenshot below. The product_id (A) will be displayed in the Dashboard tab. The attributes (F) and SKU image (E) can be found by clicking on the three dots ⋮ under the Actions column and then choosing either Show attributes or Show image.

SKU Dashboard Screenshot
Dashboard layout
CSV File Template

Import_skus.CSV

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us