The shipment export gives you information about what needs to get shipped and fulfilled. The number by the field corresponds to what column # has that information.
Tip: To pull faster exports, be sure to use filters on the Shipments page. You can easily pull shipments filtered by batch, status, or product!
1. shipment_ID: The unique ID for the shipment.
2. customer_id: The ID of the customer who purchased the order
3. customer_name: The name of the customer who purchased the order.
4. customer_email: The email address of the customer who purchased the order.
Shipping Address Information. Includes the most recent shipping address for this shipment.
14. verification_status: Verified/Failed. Could we verify the given address?
15. verification_message: If the shipping address is not verified, we give an error message, typically “Unable to verify address.” Shipment Information. Information about this shipment and the customer who ordered it.
Shipment and Order Information. Includes information about the shipment, and the subscriptions/orders that generated the shipment.
16. shipment_status: Shipped/Unshipped/Cancelled.
17. first_shipment: Yes/No. Is this the first shipment your customer has ever received from you? Note that this is useful only if you consistently mark shipments as shipped. It returns as ‘yes’ if the customer has 0 existing shipments that are marked as shipped. Returns as ‘no’ if the customer has at least 1 shipped shipment.
18. shipment_number: What # of shipment is this (across all products, subscriptions, etc.) that this customer has received from you? Note that this is sequential by when the shipment was created. Order Information
19. order_id: The order that generated this shipment.
20. order_date: The date on which that order was placed; note that for renewal orders, this is the date of renewal.
21. target_ship_date: The expected shipment date for this shipment; this is the date that determines what batch a shipment belongs to.
22. subscription_cycle_count: Tells you what shipment number this is for the subscription ID that matches this subscription.
23. customer_cycle_count: Tells you what # of shipment is this (across all products, subscriptions, etc.) that this customer has received from you? Note that this is sequential by when the shipment was created. Order Information The same number as shipment_number.
24. customer_note: Customer notes associated with the customer who purchased this shipment.
25. subscription_notes: Subscription notes that map to the subscription that generated this shipment. Note that Cancellation reasons show up in subscription notes as well.
26. subscription_term: Number form of how many cycles this customer has pre-paid. E.g. 1 for month-to-month subscriptions, 3 for a 3-month prepay, etc.
27. tracking_number: If applicable, the tracking number for the shipment.
28. subscription_metadata: If available, metadata entered about the subscription. Includes survey information.
29. cart_metadata: If available, metadata entered about the shopping cart that generated this shipment. Gift Information
30. is_gift: True/False. Tells you whether the shipment was a gift purchase.
31. gift_message: Includes the gift message if (1) the subscription is part of a gift purchase and (2) if it is the gift subscription’s first shipment.
32. subscription_id: The ID associated with the subscription.
33. will_renew: True/False. Indicates whether the subscription was purchased as a renewing or non-renewing subscription
Gift Recipient Information. Will always be included in the export, but will be blank for non-gifts or for gifts that didn't have this information
Product Information Starting at column #36, you’ll find product information for product_0, the subscription product in each shipment. Additional columns may be at the end that map to the subscription variants selected. E.g. if you offer a subscription product where someone selects a size and color, then column 37 might be size and column 38 might be color.
Use Cases for Shipment Number / Subscription Cycle Count
When a customer first orders from me (no matter what box they purchase!), I want to send them an insert explaining my business and who we are. How can I tell what shipments should receive this insert?
You should look for first_shipment=Yes if you consistently mark your shipments as shipped. If you don't consistently use mark as shipped, you should use shipment_number=1. This will tell you what shipments are the customer's first box with you.
I want to send an intro box for all first-time subs. How can I tell who is on their first box of their subscription?
Use subscription_cycle_count=1 to hit everyone on their first month! If you don’t want to send that intro box for someone who has switched products (say, moved from the Basic Box to a Premium Box, so you don't want to send them the intro box for your Premium product), you can send it to people who have subscription_cycle_count=1 AND shipment_number=1 so you’re only sending it to people who are receiving their very first box from you
I have a sequential box, so all customers get the same box as their first shipment, second shipment, etc. How can I find what box everyone should get in a given month?
Use subscription_cycle_count to tell you where a customer is in their subscription. It will say 1 for the customer’s first shipment in that subscription, 2 for their second shipment, etc.
I get a lot of prepays, and I want to send an insert/coupon on someone’s last- or second-to-last box. How can I find out what boxes should get this?
Use subscription_cycle_count and subscription_term. For example — if you have a 6-month prepay and you want to send a code, insert, or special gift to someone on their second-to-last box in each cycle to incentivize them to renew, you should find shipments that have subscription_term=6 and subscription_cycle_count=5, subscription_cycle_count=11, subscription_cycle_count=17, etc.