User Guide
  • Intro
    • Welcome
      • About DotApparel
      • What is DotApparel?
      • Where is it hosted?
      • What platform(s) do we support?
      • How does syncing work?
      • Solution architecture
      • Definition of “Instance”
      • Security Overview
    • Implementation
      • Google Cloud and Firebase
  • Quick Links
  • Core
    • Overview
    • Dashboard
    • Orders
      • Mappings
      • Integrations
    • Returns
      • Mappings
    • Products
      • Mappings
        • Default mapping rules
      • Translations
      • Markets
      • Publishing products
    • Inventory
      • Mappings
        • Examples
          • Ignore Sync
          • Inventory Buffer
          • Keep Items Sold Out
          • Unlimited Inventory
    • Customers
    • Rewards
    • System Alerts
    • Settings
      • Shopify Locations, DotApparel Locations and Inventory Buffers
      • ERP credentials
      • Product images
      • Fulfillments
      • Payment gateways
      • Gift cards
      • Refunds
      • Notifications
      • Harmony Integration with DotApparel
    • Modules
      • Ship From Store
      • Local Pickup/Click & Collect
      • Shopify Markets
      • Returns
        • Australia Post (AusPost)
        • Loop Returns
      • Auto-Refunds
        • Refunding Shopify Orders from POS (In-Store)
      • Integrate with Brauz (app)
      • Integrate with The Wishlist (app)
    • Release Notes
    • Troubleshooting
      • FAQs
      • How to raise a support ticket for an issue
      • Good and bad examples of a problem ticket
      • Want to enable a new omnichannel feature?
      • Want to integrate a marketplace using DotApparel?
  • Customers
    • Overview
      • Email Examples
    • Getting Started
      • Understanding Customer Setup in your ERP
      • Data Sync
      • Configuration
      • Testing
    • Data Export Approaches
      • Option A: Consultant
      • Option B: In-House
    • Apparel21 Export Templates
    • Apparel21 Export Changelog
    • Dashboard
    • Customers
    • Orders
    • Translations
    • Mappings
    • Settings
    • Support
  • Loyalty
    • Overview
    • Getting Started
      • Terminology
    • Data Sync
      • Workflows
    • Front-End Implementation
    • Rewards Redemption
    • Rewards Emails
    • Things To Know
Powered by GitBook
On this page
  • Scheduled Exports from Apparel21
  • Frequency of Scheduled Syncs
  • File Naming Convention

Was this helpful?

Export as PDF
  1. Customers

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
PreviousTestingNextOption A: Consultant

Last updated 1 year ago

Was this helpful?