Sample

 

https://connectors.windsor.ai/shopify?api_key=[your API key]&date_preset=last_7d&fields=order_id,order_current_total_price,order_email,order_updated_at&_renderer=csv

The Shopify connector lets you pull Shopify data on an object level (e.g. order, contact). If you specify the fields date_from and date_to it will filter for a date range in which the objects were created.

Fields

IDTypeNameDescription
customer_created_atTIMESTAMPCustomer Created at (Timestamp)The date and time (ISO 8601 format) when the customer was created.
customer_currencyTEXTCustomer CurrencyThe three-letter code (ISO 4217 format) for the currency that the customer used when they paid for their last order. Defaults to the shop currency. Returns the shop currency for test orders.
customer_dateDATECustomer Created At (Date)The date and time (ISO 8601 format) when the customer information was last updated.
customer_emailTEXTCustomer E-Mail AddressThe unique email address of the customer. Attempting to assign the same email address to multiple customers returns an error.
customer_first_nameTEXTCustomer First NameThe customer's first name.
customer_idNUMERICCustomer IDA unique identifier for the customer.
customer_last_nameTEXTCustomer Last NameThe customer's last name.
customer_last_order_idNUMERICCustomer Last Order IDThe ID of the customer's last order.
customer_last_order_nameTEXTCustomer Last Order NameThe name of the customer's last order. This is directly related to the name field on the Order resource.
customer_multipass_identifierNUMERICCustomer Multipass IdentifierA unique identifier for the customer that's used with Multipass login.
customer_noteTEXTCustomer NoteA note about the customer.
customer_orders_countNUMERICCustomer Orders CountThe number of orders associated with this customer.
customer_phoneTEXTCustomer Phone NumberThe unique phone number (E.164 format) for this customer.
customer_stateTEXTCustomer stateThe state of the customer's account with a shop (Can be disabled, invited, enabled and declined)
customer_tagsTEXTCustomer TagsTags that the shop owner has attached to the customer, formatted as a string of comma-separated values.
customer_tax_exemptBOOLEANCustomer Tax ExemptWhether the customer is exempt from paying taxes on their order. If true, then taxes won't be applied to an order at checkout. If false, then taxes will be applied at checkout.
customer_total_spentNUMERICCustomer Total SpentThe total amount of money that the customer has spent across their order history.
customer_updated_atTIMESTAMPCustomer Updated at (Timestamp)The date and time (ISO 8601 format) when the customer information was last updated.
customer_verified_emailBOOLEANCustomer Email VerifiedWhether the customer has verified their email address.
dateDATECustomer Created at (Timestamp)The date and time (ISO 8601 format) of the queried object.
emailTEXTOrder EmailThe customers email address.
order_app_idNUMERICOrder App IDThe ID of the app that created the order.
order_cancel_reasonTEXTOrder Cancel ReasonThe reason why the order was canceled.
order_cancelled_atTIMESTAMPOrder Cancelled AtThe date and time ( ISO 8601 format) when the order was canceled.
order_closed_atTIMESTAMPOrder Closed AtThe date and time (ISO 8601 format) when the order was closed.
order_created_atTIMESTAMPOrder Created AtThe autogenerated date and time (ISO 8601 format) when the order was created in Shopify. The value for this property cannot be changed.
order_currencyTEXTOrder CurrencyThe three-letter code (ISO 4217 format) for the shop currency.
order_current_subtotal_priceNUMERICOrder Current Subtotal PriceThe current subtotal price of the order in the shop currency. The value of this field reflects order edits, returns, and refunds.
order_current_total_discountsNUMERICOrder Current Total DiscountsThe current total discounts on the order in the shop currency. The value of this field reflects order edits, returns, and refunds.
order_current_total_priceNUMERICOrder Current Total PriceThe current total price of the order in the shop currency. The value of this field reflects order edits, returns, and refunds.
order_current_total_taxNUMERICOrder Current Total TaxThe current total taxes charged on the order in the shop currency. The value of this field reflects order edits, returns, or refunds.
order_emailTEXTOrder EmailThe customers email address.
order_financial_statusTEXTOrder Payment StatusThe status of payments associated with the order. Can only be set when the order is created.
order_fulfillable_quantityNUMERICOrder Fullfillable QuantityThe fullfillable quantity of the order.
order_fulfillment_serviceTEXTOrder Fulfillment ServiceThe order fulfillment service.
order_gross_salesNUMERICOrder Gross SalesThe order gross sales (Equates to order_product_price x order_quantity (before taxes, shipping, discounts, and returns) for a collection of sales).
order_idTEXTOrder IDThe unique identifier of the order
order_line_itemsTEXTOrder Line ItemsThe line items of the order.
order_nameTEXTOrder nameThe name of the order
order_net_salesNUMERICOrder Net SalesThe order net sales (Equates to order_gross_sales - order_total_discounts - order_refunds_net).
order_noteTEXTOrder noteAn optional note that a shop owner can attach to the order.
order_product_priceNUMERICOrder Product PriceThe order price.
order_quantityNUMERICOrder QuantityThe order quantity.
order_refundsTEXTOrder RefundsA list of refunds applied to the order.
order_refunds_netNUMERICAggregated Order Refunds NetSum of order_refunds_subtotal and order_refunds_refunds_total_tax.
order_refunds_subtotalNUMERICAggregated Order Refunds SubtotalThe subtotal of the refund line items.
order_refunds_total_taxNUMERICAggregated Order Refunds Total TaxThe total tax on the refund line items.
order_sales_channelNUMERICOrder Sales Channel (A duplicate of `order_app_id`)The ID of the app that created the order.
order_tagsTEXTOrder tagsTags attached to the order
order_total_discountsNUMERICOrder Total DiscountsThe total discounts applied to the price of the order in the shop currency.
order_total_discounts_setNUMERICOrder Total Discounts SetThe total discounts applied to the price of the order in shop and presentment currencies.
order_total_priceNUMERICOrder Total PriceThe sum of all line item prices, discounts, shipping, taxes, and tips in the shop currency. Must be positive.
order_updated_atTIMESTAMPOrder Updated AtThe date and time (ISO 8601 format) when the order was last modified.