Connect Shopify to Lovable

Yes. Every question you ask in Lovable triggers a fresh pull from the Shopify API via Windsor MCP, ensuring your order totals, inventory levels, customer data, and fulfillment statuses reflect the current state of your store performance.

Windsor.ai gives you access to a wide range of Shopify metrics and dimensions, including:

• Revenue and orders: Gross sales, net sales, total price, subtotal price, total discounts, net payment, total tax, order count, cost of goods sold, order financial status, fulfillment status.
• Refunds and returns: Refunds subtotal, refunds quantity, returns amount, returns quantity, line item refunds price, line item refund quantity, refund discrepancy amount.
• Customers: Total spent, orders count, average order value, is returning, email marketing consent state, default address country, customer created date, customer tags.
• Products and variants: Product title, product type, vendor, inventory quantity, inventory value, variant price, compare at price, unit cost, variant SKU, product status.
• Marketing attribution: UTM source, UTM medium, UTM campaign, UTM content, order customer last visit source, referrer URL, discount codes.
• Fulfillment and shipping: Fulfillment status, fulfillment created date, fulfillment delivered date, shipping address country, shipping line title, shipping price, carrier identifier.

Yes. Windsor.ai pulls customer_total_spent, customer_orders_count, customer_aov, customer_is_returning, and customer_created_at for every customer in your store. Ask Lovable to rank customers by lifetime value, identify your most loyal buyers, or find high-spend customers who haven’t ordered recently, so your retention campaigns reach the right people.

Yes. Lovable helps you identify which variants are running low relative to their recent sales velocity, which products have the highest inventory value sitting unsold, and where you’re at risk of stockouts before your next reorder.

Yes. Describe what your team tracks daily (revenue by channel, top SKUs, refund rate, new vs. returning customer split, fulfillment delays), and Lovable builds a fully interactive, shareable web app from your live Shopify data.

Beyond basic performance summaries, you can use more advanced, specific prompts to uncover deeper insights. For example:

• Analyze customer retention for the last 6 months. Segment customers into first-time buyers and returning buyers. For each segment, show total revenue, average order value, and average days between orders for returning customers. Which acquisition month produced the highest share of returning buyers?

• For the last 90 days, pull all orders with a discount code applied. Show total revenue, average order value, discount amount, and net sales per discount code. Compare average order value for discounted vs. non-discounted orders and calculate the net revenue impact of each promotion.

• Break down my product inventory by variant. Show current inventory quantity, sellable online quantity, unit cost, and inventory value per variant. Flag all variants with fewer than 10 units remaining and a sales velocity above 5 units per week in the last 30 days.

• Attribute revenue to marketing channels using UTM data for the last 60 days. For each UTM source and medium combination, show order count, total revenue, average order value, and share of total revenue. Which channel drives the highest AOV, and which drives the most order volume?

• Pull all customers with a total spent above $500 who haven't placed an order in the last 60 days. Show their last order date, total orders count, average order value, and email marketing consent state. Flag customers who accept marketing: these are your highest-priority re-engagement targets.

Yes, we have helpful resources to help you get started. You can explore our official documentation and tutorials for seamless Shopify to Lovable integration with Windsor.ai:

• Shopify Field Reference
• Lovable Integration Video Tutorial
• Lovable Integration Documentation

Absolutely. Windsor.ai allows you to blend Shopify 350+ data sources, including Facebook Ads, Google Ads, TikTok, and Klaviyo, in the same Lovable conversation. Ask which ad campaigns drove the highest revenue per order, calculate true ROAS based on Shopify net sales, and identify which channels acquire your highest-value customers.