# 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

<figure><img src="/files/3UrtLM2ibjQ3UBIlaaX6" alt=""><figcaption></figcaption></figure>

### April, 2024

`customers.csv`

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

The privacy field now has three states.

* `1` = Privacy Ticked / <mark style="color:red;">unsubscribe</mark>
* `0` = Privacy unticked (was ticked) / <mark style="color:green;">subscribe</mark>
* `Null` = Privacy never ticked / <mark style="color:red;">default is unsubscribe but can be modified to set as</mark> <mark style="color:green;">"subscribe"</mark> <mark style="color:red;">depending on the company's privacy policy</mark>

### March 23, 2024

`orders.csv`

Conversion of `SALE_DATE` to ''YYYY-MM-DD"T"HH24:MI:SS<mark style="color:green;">+11:00</mark>'' format.

The date and time of the transaction will reflect as the date of the event in Klaviyo. The <mark style="color:green;">+11:00</mark> 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

{% hint style="info" %}
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.
{% endhint %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.dotapparel.com.au/customers/apparel21-export-changelog.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.