Save Shopify Orders to a Database

This step automatically activates whenever a customer completes a purchase in your Shopify store. The trigger captures the complete order information including customer details, shipping address, payment status, and all line items. No configuration is needed - it connects directly to your Shopify store and begins monitoring for new orders immediately. The captured order data gets passed to the next step for shop information retrieval.

This step automatically retrieves your Shopify shop information including your store domain, which is used to create clickable admin URLs for easy order management. The system makes a call to Shopify's shop API to get current store details like your myshopify.com domain name. No configuration is required as it uses the same connection as your order trigger. The shop domain gets combined with order IDs in later steps to create direct links to orders in your Shopify admin.

This step takes each line item from the order and processes it individually through the database creation step. For orders with multiple products, this ensures you get separate database records for each item with its own quantity, price, SKU, and vendor information. The loop automatically iterates through all line items in the order without requiring configuration. Each product's details get passed individually to the database creation step, allowing for granular product-level reporting and analysis.

This step creates a new database record for each product in the order, storing comprehensive information across 21 different fields including order details, customer information, shipping address, and individual product data. You'll need to configure your database connection and specify the table name "Shopify Orders" where records will be stored. The step automatically maps order data to database fields like Order Name, Customer Email, Product Title, SKU, Quantity, and Price. Each record includes a direct admin URL link for quick access to the original order in Shopify.