Apparel21 Export Changelog

May, 2024

Sync products between the Klaviyo Catalogue synced for Shopify and Apparel21 data. It involves retrieving Shopify products via API, and matching barcodes.

• Placed In-Store Order

  • Contains the transaction details and the various products within that

• Ordered Product

  • Contains only the one product

April, 2024

customers.csv

If privacy is null (not set) set privacy = 0

The privacy field now has three states.

• 1 = Privacy Ticked / unsubscribe

• 0 = Privacy unticked (was ticked) / subscribe

• Null = Privacy never ticked / default is unsubscribe but can be modified to set as "subscribe" depending on the company's privacy policy

March 23, 2024

orders.csv

Conversion of SALE_DATE to ''YYYY-MM-DD"T"HH24:MI:SS+11:00'' format.

The date and time of the transaction will reflect as the date of the event in Klaviyo. The +11:00 at end represents the timezone.

Example: 2018-12-27T12:30:00+011:00

Feb 8, 2024

orders.csv

• Product REFs

• Markdown: Y / N

• Dispatch Store ID + Dispatch Store Name

• Dispatch Order Number

customers.csv

• Person REFs

Jan 25, 2024

To ensure smooth syncing to Klaviyo, make sure that all files, especially large ones like bulk files, contain up to 20,000 records or fewer. This will prevent timeouts and syncing issues between DotApparel Customers into Klaviyo.