Available exports

  • Subscription
  • Customer
  • Shipments
  • Order
  • All Transactions
  • Gifting 1.0 Gift
  • General Analytics By Month
  • General Analytics By Week
  • Tax
  • Notification
  • Subscription Logs (Cancellations)
  • Importer Customer List

Subscription

Merchant Portal → Subscriptions → Action → Export CSV

URL

Columns

  1. subscription_id
  2. customer
  3. email
  4. ship_to
  5. ship_street_address
  6. ship_unit
  7. ship_city
  8. ship_state
  9. ship_zip_code
  10. ship_country
  11. bill_street_address
  12. bill_unit
  13. bill_city
  14. bill_state
  15. bill_zip_code
  16. bill_country
  17. status
  18. total_revenue
  19. mrr
  20. wrr
  21. fulfillment_status
  22. products (product 1, Variant Name, product 2...)
  23. start_date
  24. end_date
  25. term
  26. contents
  27. note
  28. coupon
  29. skipped
  30. metafields
  31. is_gift
  32. gift_message
  33. cancel_date

Customer

Merchant Portal → Customers → Export → CSV

URL

Columns

  • customer_id
  • first_name
  • last_name
  • name
  • email
  • note
  • ship_to
  • ship_street
  • ship_unit
  • ship_city
  • ship_state
  • ship_zip_code
  • ship_country
  • location
  • country
  • total_revenue
  • mrr
  • wrr
  • num_orders
  • num_subscriptions
  • subscription_status
  • payment_provider
  • last4
  • source
  • marketplace_source
  • customer_metadata

Optional columns: referral_url

Shipments

Merchant Portal → Shipments → Export → CSV

URL

Columns

  • shipment_id
  • customer_id
  • customer_name
  • customer_email
  • ship_to ship_company
  • ship_street
  • ship_unit
  • ship_city
  • ship_phone_number
  • ship_state
  • ship_zip_code
  • ship_country
  • verification_status
  • verification_message
  • shipment_status
  • first_shipment
  • shipment_number
  • order_id
  • order_date
  • target_ship_date
  • subscription_cycle_count
  • customer_cycle_count
  • customer_notes
  • subscription_notes
  • subscription_term
  • tracking_number
  • subscription_metadata
  • cart_metadata
  • is_gift
  • gift_message
  • subscription_id
  • product_0_id
  • product_0_instance_id
  • product_0_name
  • product_0_sku
  • product_0_Size
  • product_0_Color (Each of the above by product)

Order

Merchant Portal → Orders → Export CSV

One-time product purchases.

URL

Columns

  • order_id
  • customer
  • email order_status
  • financial_status
  • fulfillment_status
  • products
  • note
  • placed_at
  • total
  • total_price
  • total_tax
  • total_shipping
  • coupon
  • is_gift
  • gift_message

All Transactions

Merchant Portal → Analytics → General → General Analytics by Month → Export → All Transactions

URL

Columns

  • Customer Name
  • Order ID
  • Order Date
  • Total Tax
  • Total Price
  • Total Refunded
  • Total Shipping
  • County Desc. (Name of country tax, if any)
  • County Total
  • City Desc.(Name of city tax, if any)
  • City Total
  • State Desc. (Name of state tax, if any)
  • State Total
  • Municipal Desc. (Name of municipal tax, if any)
  • Municipal Total
  • Email
  • Order Status
  • Financial Status
  • Fulfillment Status
  • Products
  • Note
  • Total
  • Coupon
  • Gift
  • Gift Message
  • Referrer
  • Member Only (True/False) - True iff an order has a coupon from the Customer Pricing app
  • Transaction Fee
  • Payment Processor
  • Marketplace (True/False)

Gifting 1.0 Gifts

Merchant Portal → Subscriptions → Gift Subscriptions → Export → CSV

URL

Columns

  • gift_id
  • gift_order_placed_at
  • gift_date
  • gift_sender
  • gift_receiver
  • gift_product
  • gift_code email
  • gift_status
  • gift_sending_order_id
  • gift_receiving_order_id
  • Tax

Sales Tax

Merchant Portal → Analytics → General → Sales Tax Export → CSV

URL

Columns

  • Customer Name
  • Order ID
  • Order Date
  • Total Tax
  • Total Price
  • Total Refunded
  • Total Shipping
  • County Desc.
  • County Total
  • City Desc.
  • City Total
  • State Desc.
  • State Total
  • Municipal Desc.
  • Municipal Total
  • General Analytics By Month


General Analytics By Month

Merchant Portal → Analytics → General → General Analytics by Month → Export → Subscriptions by Month

URL

Columns

General Analytics By Week

Merchant Portal → Analytics → General → General Analytics by Month → Export → Subscriptions by Month

URL

Columns

Notifications

Merchant Portal → Analytics → Notifications → Export → CSV

URL

Columns

  • notification_id
  • customer 
  • email
  • subject
  • status
  • last_updated

Subscription Logs (Cancellations)

Merchant Portal → Settings → Import → Export Customers

URL

Columns

  • id
  • customer_id
  • first_name
  • last_name
  • name
  • email
  • phone_number
  • log_type
  • product_names
  • product_ids
  • subscription_id
  • subscription_term
  • subscription_start_date
  • cancel_reason
  • note
  • log_time
  • ship_to
  • ship_street
  • ship_unit
  • ship_city
  • ship_state
  • ship_zip_code
  • ship_country
  • location
  • country
  • months_subscribed
  • Importer Customer List

Shipment Label Batch Export

Merchant Portal → Shipping → Print Labels → Completed → Export Label Data

URL

Columns

  • shipment_id
  • customer_id
  • customer_name
  • customer_email
  • ship_to
  • ship_company
  • ship_street
  • ship_unit
  • ship_city
  • ship_phone_number
  • ship_state
  • ship_zip_code
  • ship_country
  • verification_status
  • verification_message
  • shipment_status
  • first_shipment
  • shipment_number
  • order_id
  • order_date
  • target_ship_date
  • subscription_cycle_count
  • customer_cycle_count
  • customer_notes
  • subscription_notes
  • subscription_term
  • tracking_number
  • subscription_metadata
  • cart_metadata is_gift
  • gift_message
  • subscription_id
  • product_0_id
  • product_0_instance_id
  • product_0_name
  • product_0_sku