How do I replace the Shipping Method data with a special code provided by my supplier?

Your supplier or 3PL provider might require you to use special codes to replace the name of the shipping method you selected in Shopify when you send the exported CSV file to them.

This is possible in EZ Exporter using Calculated Fields.

For example, your supplier might instruct you to do something like this:

  • Evri - 2-3 Day -> use code "HMSIOD2DAY"
  • DHL Express -> use code "DHLEXP"
  • Royal Mail Tracked -> use code "RMINTTRSG"

Shopify stores the shipping method data in a field called shipping_lines.title, so in the Calculated Fields you can use a formula like this to do the replacments:

get_attribute_value('{"Evri - 2-3 Day": "HMSIOD2DAY", "DHL Express": "DHLEXP", "Royal Mail Tracked": "RMINTTRSG"}', {{ shipping_lines.title }})

What the formula above does is do a key/value lookup against a dictionary of key/value pairs, where the "key" is the shipping title in Shopify and the "value" is the shipping code equivalent that your 3PL/supplier's system uses.  On export, our app will automatically replace the shipping method in Shopify with the 3PL's shipping code.

If your supplier provides you a CSV file with the tracking numbers and other tracking info after fulfillment, we have a separate app EZ Fulfill that can import these tracking info into Shopify (and also mark them fulfilled) and also has the option to change the 3PL's shipping code back to the shipping title that Shopify uses to properly map them in Shopify.

If you have a more complex requirement, please don't hesitate to contact us to see if our app can handle it.


Related Articles:


App: EZ Exporter

Tags: advanced features, dropshipping, 3pl, fulifllment, shopify to 3pl