Organize Shopify Orders by Order Date

This step automatically monitors your Shopify store for new orders and triggers the workflow when one is created. The trigger captures comprehensive order information including customer details, shipping addresses, product line items, pricing, and timestamps. No configuration is required - it connects to your Shopify store through your existing MESA integration. When an order is placed, all the order data becomes available for processing by the subsequent workflow steps.

This step automatically retrieves your Shopify store's basic information, particularly the myshopify domain name that will be used to create admin order URLs. The step runs without any user input and pulls data like your shop's domain, timezone, and other store settings. This information gets passed forward to help format the admin order links that appear in your final database records. The shop data ensures that when you view your organized orders, you can click directly through to manage them in Shopify.

This step takes the line items array from the order and processes each product individually through the loop. For orders with multiple products, this creates separate database records for each item, capturing product-specific details like title, variant, SKU, individual price, and quantity ordered. The loop ensures that multi-product orders are broken down into granular data points for better analysis and inventory tracking. Each iteration passes both the original order data and the specific product details to the database creation step.

This step creates a new database record for each product in the order, storing comprehensive information in the "Shopify Orders" table. The record includes order details (ID, name, email, totals, shipping address, tags, notes), customer information (name and email), and product-specific data (title, variant, SKU, price, quantity, line item ID). It also generates an admin order URL using the shop domain retrieved in step 2, allowing you to click directly from your database to the order in Shopify. Each time a product loops through, a new record gets created with the complete dataset for analysis and reporting.