Differentiate location when combined shipping in Flow app

Shopify Apps

Topic summary

A Shopify merchant operates two fulfillment locations (shop and warehouse) and uses tags to identify which location items come from. Combined orders contain products from both locations and receive both tags.

Current Setup:

  • Flow workflow successfully adds order data to Google Sheets
  • Works well for single-location orders

Challenge:

  • For combined orders (containing items from both locations), the merchant needs to differentiate which specific products come from each location
  • Seeking the correct Flow variable that identifies the fulfillment location at the line-item or product level

Goal:
Determine how to capture individual product fulfillment locations within combined orders in their Flow automation, rather than just the overall order tags.

Summarized with AI on November 8. AI used: claude-sonnet-4-5-20250929.
1

My shopify store has 2 locations (a shop and a warehouse) orders can come from both locations and are classed as combined - I use tagging to tag each order with the location that they come from and therefore my combined orders have both ‘shop’ and ‘warehouse’ as tags.

I currently have a Workflow set up in Flow that adds a line into a Google Sheet that is triggered if an order comes from the shop

This is working well, but when an order comes from the shop AND the warehouse (a combined order) I would like to differentiate what products have come from the shop Vs the warehouse - I need to know the variable which would define the fulfillment location.

Any help would be hugely appreciated.