I’m working on connecting one of my Shopify shops to an outside fulfillment partner via Zapier. There are two parts: us sending them orders, and them sending us shipping confirmations.
The first part is easy, and doesn’t involve Zapier: I use DataChamp to schedule a daily export of relevant orders and send it to the partner’s FTP site.
The second part is very Zapier: Using EasyFTP, I monitor one folder on their site for new files—the shipping confirmation CSV, which triggers the Zap. Then I run the CSV through formatter to extract line items, and create a loop to process each line item in turn. This is where I’m not quite sure what to do!
The CSV contains, among other things, the original order number, the ship date, the carrier, and the tracking number. Should I be pushing this back into Shopify? If so, there are not automatic, obvious fields for 3 of those 4 data points. (Should those go into “Additional Details” in the Zap configuration?) Or should it all go into Klaviyo to trigger a shipping notice? It’s a little hazy here, and I could use some direction!