How can I export the shipping label price and who made the purchase from a Shopify order?

EZ Exporter can extract the shipping label info from the Order Timeline (Events) entries via the Calculated Fields feature.

If the timeline entry looks something like below:

John Doe purchased a $6.16 shipping label and the included shipping insurance premium.

Then you can use the formulas below to extract the name of the person who purchased the shipping label and the cost/price.

Shipping Label Purchased By

get_value_by_position([i.message.partition(" purchased")[0] for i in load_json_data({{ events }}) if i.action == "shipping_label_created_success"], -1)

Shipping Label Price (without the currency symbol)

strip_non_numeric_chars(get_value_by_position([i.message for i in load_json_data({{ events }}) if i.action == "shipping_label_created_success"], -1).split("purchased a")[1].split("shipping label")[0].strip(), except_chars=".")

If the event/timeline message looks different in your store, then please contact us and we can help you create a formula for it.


Related Articles:


App: EZ Exporter

Tags: shipping cost, shopify shipping labels, order timeline