Tables/APIs

The following is the list of tables or APIs associated with the Stay AI connector:

>Orders

>Subscriptions

Orders

This table contains recurring subscription order and fulfillment information from the Stay AI platform. Each record represents a recurring order event generated through a Stay AI subscription contract and originates from Shopify. The table includes both Stay AI internal order identifiers and Shopify Order IDs, along with order name, associated customer ID, and the parent subscription contract ID that triggered the order.

The table captures key transactional details such as order creation and last-updated timestamps, fulfillment status, currency, total order value, cart-level discount amount, tax totals, and shipping price. Delivery address information is also included at the order level, covering fields such as first name, last name, address lines, city, province, province code, country, country code, zip code, company, and phone number. Order tags are captured to support segmentation and classification of subscription-generated orders within downstream reporting systems.

At the line-item level, the table stores granular product data for each item within the order, including Shopify Line Item ID, product title, Shopify Product ID, variant title, Shopify Variant ID, SKU, quantity, and subtotal price per line. Orders containing more than one subscription-linked product will have multiple line-item rows per order record.

The table supports incremental synchronization through createdAt and updatedAt timestamp filters, with page-based pagination and configurable sort direction, enabling reliable and efficient data extraction for historical record management and continuous pipeline refreshes.

Source API: Query Orders

Schema:   Stay_AI

Subscriptions

This table contains the complete subscription lifecycle and contract data managed within the Stay AI platform. Each record represents a unique subscription contract associated with a Shopify customer and includes both Stay AI internal subscription identifiers and Shopify Subscription Contract IDs for cross-system traceability.

The table captures customer-level attributes such as Shopify Customer ID and email address, along with subscription lifecycle timestamps including creation date, last updated date, next billing date, paused until date, churned date, and cancellation date. Subscription status is recorded as one of three states — ACTIVE, PAUSED, or CANCELLED — enabling point-in-time status tracking and cohort-level churn analysis. Where applicable, cancellation reason is also captured to support retention and churn attribution reporting.

Billing and pricing details include the subscription price, delivery price, and currency. Billing cadence is defined through order interval frequency and order interval unit fields, reflecting the configured subscription recurrence schedule (e.g., every 4 weeks). Order-level notes attached by the customer are also stored.

At the line-item level, the table stores granular product data for each item enrolled in the subscription, including Shopify Subscription Line ID, Shopify Product ID, Shopify Variant ID, quantity, unit price, and subtotal price per line. Subscriptions containing multiple products will have multiple line-item rows per subscription record.

The table supports incremental synchronization through createdAt, updatedAt, nextBillingDate, and prepaid next delivery date timestamp filters, with page-based pagination and configurable sort direction. This enables reliable, efficient data extraction for incremental pipeline refreshes, historical record management, and accurate subscription state tracking across reporting periods.

Source API: Query All Subscriptions

Schema:   Stay_AI