Apparel21 Export Templates

File Templates for DotApparel Customers

• Customers CSV

• Orders CSV

• Rewards CSV

• Gift Cards CSV

File Templates for DotApparel Loyalty

For merchants that have DotApparel Customers already, then the same Orders CSV can be used.

• Orders CSV

• Refunds CSV

Please note, a specific file naming convention for the CSV files must be followed before they can succesfully be uploaded to the SFTP server.

Distinguishing Loyalty and Rewards

Despite the name, there's a clear distinction between Loyalty and Rewards in Apparel21.

• Loyalty: Encompasses staff discounts and VIP levels.

• Rewards: Refers to the Apparel21 rewards program module, covering tiers, spending, gifts, points, etc.

During the project kick-off, notify us of the status of your rewards program. If enabled, specify the precise rewards data you wish to incorporate into your rewards.csv This file is tailored to meet your specific requirements, aligning seamlessly with the type of emails you intend to send.

Field Definitions

Customers Export Fields

Apparel21 Field	Klaviyo Field Name	Purpose of Field
PERIDX	AP21 Person ID	Internal AP21 Person IDX
PERSON_CODE	Person Code	Person code
FIRSTNAME	First Name	First name
SURNAME	Last Name	Last name
ADRS1	Location Address 1	Address line 1
ADRS2	Location Address 2	Address line 2
CITY	Location City	City
STATE	Location State	State
POSTCODE	Location Post Code	Post code
COUNTRY	Location Country	Country
MOBILE	Mobile Number	First mobile number
EMAIL	Email	Person's primary Email
DOB	Date Of Birth	Date of Birth (YYYY-MM-DD)
PRIVACY	Privacy	Privacy status (Yes is unsubscribed, No is subscribed)
RETAIL_REP	Retail Rep	Retail Representative (Yes if ticked, No if not ticked/blank)
LAST_UPDATED	Last Updated	Last updated date (YYYY-MM-DD"T"HH24:MI:SS)
CREATED_DATE	Created Date	Creation date (YYYY-MM-DD"T"HH24:MI:SS)
JOINED_STORE_ID	Joined Store ID	Internal Store ID where the person was created
JOINED_STORE_CODE	Joined Store Code	Store Code where the person was created
STORE_ID	Latest Store ID	Last purchase store ID
STORE_CODE	Latest Store Code	Last purchase store code
STORE_NUMBER	Latest Store Number	Last purchase store number
REF1_GROUP	Ref1 Group	For Reference (as required)
REF1_ID	Ref1 ID	For Reference (as required)
REF1_CODE	Ref1 Code	For Reference (as required)
LOYALTY_CODE	Loyalty Code	Most recent loyalty code if active, empty otherwise
LOYALTY_NAME	Loyalty Name	Loyalty Name/Description

Orders Export Fields

Apparel21 Field	Klaviyo Field Name	Purpose of Field
PERSON_IDX	AP21 Person ID	Person IDX
TRANSACTION_ID	Transaction ID	Transaction IDX
TRANSACTION_NUMBER	Transaction Number	Online order number
SALE_DATE	Sale Date	Sale date (YYYY-MM-DD"T"HH24:MI:SS)
STORE_CODE	Store Code	Store code
STORE_NAME	Store Name	Store Name
LINE_ID	Line ID	Index of the product
SKUIDX	SKU IDX	SKU ID
STYLE_CODE	Style Code	Product code
STYLE_NAME	Style Name	Product description
COLOUR_CODE	Colour Code	Colour code
COLOUR_NAME	Colour Name	Colour description
SIZE_CODE	Size Code	Size code
CATEGORIES	Categories	Existing product reference (array of categories)
BARCODE	Barcode	EAN number
QUANTITY	Quantity	Quantity
PRICE	Price	Recommended Retail Price (RRP price)
VALUE	Value	Total value of the order
DISCOUNT_REASON	Discount Reason	Discount reasons for retail orders in AP21 ("None" or empty for online)
DISCOUNT_AMOUNT	Discount Amount	Discount amount for retail orders (0 for online)
MARKDOWN	Indicator for sale items	Logic is based on difference between original RRP and current RRP "Y" = Markdown "N" = Full Price

Additional Data

If you would like additional data beyond the standard CSV file templates, please inform us so that we can configure the necessary mapping in the solution during setup.

Please note that the rewards data is not part of the standard templates and will require extra customisations when exporting from Apparel21.

Rewards Export Fields

The following will update the Klaviyo customer properties

Apparel21 Field	Klaviyo Field Name	Purpose of Field
PERIDX	AP21 Person ID	Internal AP21 ID
EMAIL	Email	Customer Email
PERSON_CODE	Person Code	Customer Code
EVENT	Event	Description of the activity
REASON	Reason	Reason for the reward activity
EVENT_DATE	Event Date	Date of activity
PROGRAM_NAME	Program Name	Reward program the customer is enrolled in
TIER_NAME	Tier Name	Current tier/level
TIER_DESCRIPTION	Tier Description	Description of the current tier
EXPIRY_DATE	Expiry Date	Expiry date for the current tier
POINTS_TOTAL	Points Total	Total points earned by the customer
POINTS_REDEEMED	Points Redeemed	Total points redeemed by the customer in transactions
POINTS_REMAINING	Points Remaining	Total current points available for the customer

The following will be added as a Klaviyo event

AP21 Field	Klaviyo Field	Purpose of Field
REWARD_TOTAL	Reward Total	Event points earned in the reward activity
REWARD_REDEEMED	Reward Redeemed	Event points redeemed in the same transaction
REWARD_REMAINING	Reward Remaining	Event points left available for the customer
GIFT_REDEEMED	Gift Redeemed	Event gift redeemed by the customer

Here's How The Data Will Appear in Klaviyo

Customer Properties will populate in the respective field in the "Details" section

Orders and Rewards Events will appear in the "Activity Log" section.