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.
App: EZ Exporter