E-commerce Data Ingestion

chord can ingest data from different e commerce systems for analysis two methods are available chord ingest (preferred) a chord built system that will pull data from a customer's e commerce system chord api (optional) customers can use chord's rest api to push data from their source system speak to an chord for more details chord ingest chord ingest is chord's solution for customer not using shopify (e g magento, bigcommerce, salesforce commerce cloud) to get started, simply input the url for your system and a valid api key into your chord instance that's it! sample data mapping since different e commerce platforms use different names for equivalent records, the table below shows how source records are mapped to chord's data model below is an example of a data mapping from magento, a common e commerce system, and chord product chord magento name name slug combination of the name and id sku sku external id id product type type id variant chord magento sku sku price price external id id order chord magento line items order items\[] discount order items\[] discount tax order items\[] tax customer order customer billing address order billing address shipping address order shipping address number increment id state depends on payment state depends on total due if total due > 0 balance due if total due < 0 credit owed if total due == 0 paid otherwise void shipment state depends on status pending pending processing ready complete shipped email email currency base currency code item total subtotal total grand total adjustment total grand total subtotal shipment total shipping incl tax promo total discount amount payment total total paid item count total item count channel chord included tax total base subtotal incl tax external id id line item chord magento quantity qty ordered additional tax total tax amount price price external id item id sku sku adjustment total additional tax total + promo total slug name promo total discount amount line item discount chord magento adjustable id line item id amount discount amount order id line item order id external id " line item id discount" line item tax chord magento external id " line item id tax" adjustable id line item id amount tax amount order id line item order id payment chord magento amount amount paid state if amount paid == amount ordered , then paid ; pending otherwise number " entity id method " shipment chord magento inventory units shipment items\[] external id entity id number entity id state order shipment state cost order shipment total shipped at created at inventory unit chord magento external id " order item id index "; where index is a counter of the number of inventory units listed under the shipment sku sku variant id query the chord database for the variant by sku and use the id user chord magento name " customer firstname customer lastname " email customer email address chord magento city city external id entity id firstname firstname lastname lastname address 1 street first address 2 street second zipcode postcode phone telephone state query the chord database for the region code and return the state id country query the chord database where iso country id and return the country id how it works when a product is synced, all associated variants are also synced when an order is synced, all associated records are also synced line items discount tax shipments inventory units customer billing address shipping address payments chord replicates data 1 1 from the source system, performing the minimum transformations necessary for successful replication chord syncs data daily from a customer's e commerce system product sync sync all products and variants in the customer's catalogue order sync sync completed orders and associated records updated in the previous 24 hours