Data Export Approaches

How to configure the required data exports

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.

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

• Option B: In-House

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.

Format: {type}_{datetime}.csv

Type: customers or orders or rewards

Datetime: ISO 8601 date and time in UTC

Examples

customers_20230424T201230Z.csv
orders_20230101T120101Z.csv
rewards_20230101T120101Z.csv