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

• https://my.cratejoy.com/subscriptions

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

• https://my.cratejoy.com/customers

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

• https://my.cratejoy.com/shipments

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

• https://my.cratejoy.com/orders

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

• https://my.cratejoy.com/analytics/general

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

• https://my.cratejoy.com/subscriptions/#page=1/gift_filter=gifts

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

• https://my.cratejoy.com/tax/export

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

• https://my.cratejoy.com/al/export/monthly

Columns

General Analytics By Week

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

URL

• https://my.cratejoy.com/al/export/weekly

Columns

Notifications

Merchant Portal → Analytics → Notifications → Export → CSV

URL

• https://my.cratejoy.com/analytics/notifs

Columns

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

Subscription Logs (Cancellations)

Merchant Portal → Settings → Import → Export Customers

URL

• https://my.cratejoy.com/import/

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

• https://my.cratejoy.com/shipments

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