# Data Export Approaches

### Scheduled Exports from Apparel21

A scheduled job needs to be configured in Apparel21 in order to bulk export customer and order data into an SFTP service, that we we will provide. It is mandatory that customer data should always be uploaded first, with a delay of 30 minutes then followed by the upload of the order data file.

To best understand what will need to be configured in Apparel21, please reference the below Customer & Order sample files. Apparel21 will need to be configured in order to automatically export CSV files, alongside the frequency of the export task.&#x20;

Once the sample files have been confirmed by the merchant, the scheduled jobs must be set up in Apparel21 to export the CSV files and upload them to the provided SFTP server. Apparel21 supports this natively so if you do not have a team member who is across this, you can either:

* [Option A: Consultant](/customers/data-export-approaches/option-a-consultant.md)
* [Option B: In-House](/customers/data-export-approaches/option-b-in-house.md)

### Frequency of Scheduled Syncs

The frequency of scheduled jobs is determined by the merchant. While many merchants opt for a daily sync, certain brands that send post-purchase emails may require more frequent job runs, even as often as every 30 minutes.

### File Naming Convention

It’s important to note that for our solution to process the uploaded CSV files, a particular naming convention needs to be followed when uploading files to the SFTP server.

{% hint style="info" %}
**Format**: {type}\_{datetime}.csv&#x20;

**Type**: customers or orders or rewards

**Datetime**: ISO 8601 date and time in UTC
{% endhint %}

#### **Examples**

```
customers_20230424T201230Z.csv
orders_20230101T120101Z.csv
rewards_20230101T120101Z.csv
```


---

# 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/data-export-approaches.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.
