How do I connect my Tray store to Airtable without coding?

You simply select Tray as your data source in Kondado and authenticate your store credentials. Then choose Airtable as your destination and map the pipelines you want to replicate. The entire setup happens through Kondado's interface with no technical configuration required.

What kind of dashboards can I build with Tray data in Airtable?

You can create custom views showing sales performance by combining Orders, Sold Products, and Payments pipelines to track revenue trends. Marketing teams often build reports analyzing Discount Coupons effectiveness alongside Customer data to measure campaign ROI and retention rates.

How often does Tray data update in Airtable?

You control the refresh schedule based on your business needs, choosing from every 5 minutes, 15 minutes, hourly, or daily updates. This keeps your reports current with near-real-time visibility into your ecommerce operations without overwhelming your workflow.

Which KPIs should I track from my Tray ecommerce data?

Focus on metrics like conversion rates from Order Details, inventory turnover using Products and Sold Products pipelines, and customer lifetime value calculated from Orders and Customers data. You can also monitor payment success rates through the Payments pipeline to identify transaction issues.

Can I share Tray reports with my team in Airtable?

Yes, once your data replicates to Airtable, you can share specific views or entire bases with team members, giving them immediate access to current sales figures. This collaborative approach keeps marketing, operations, and finance teams aligned on the same data.

Do I need a separate database to connect Tray and Airtable?

No, Kondado provides a direct connection that sends your Tray data straight to Airtable without requiring intermediate storage like PostgreSQL or BigQuery . This simplifies your setup and reduces technical complexity for business users.

What specific Tray data can I visualize in Airtable?

You can access 14 different pipelines including Orders, Order Details, Customers, Payments, Products, Sold Products, Discount Coupons, and Newsletters. This covers everything from transaction values and inventory levels to customer contact information and marketing subscription status.

Connect Tray to Airtable: Dashboards in Minutes

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

Visualize Tray Data in Airtable for Business Insights

How to visualize Tray data in Airtable? Kondado makes it simple with a direct connection that requires no technical expertise. You can replicate your ecommerce information from Tray into Airtable on a configurable schedule, keeping your business reports current without manual exports. Whether you need to track orders, analyze customer behavior, or monitor inventory, your data flows automatically into Airtable’s flexible interface.

Kondado connects Tray to Airtable through a direct integration with no intermediate databases, allowing business teams to access 14 data pipelines including Orders, Customers, and Payments with updates every 5 minutes, 15 minutes, hourly, or daily.

Our prices start from $19 USD/month, and you can try Kondado for free for 14 days with no credit card required

With your Tray data in Airtable, marketing teams can analyze Discount Coupons performance alongside Customer segments to optimize campaigns, while operations teams track Orders and Sold Products to manage inventory levels. Combining Order Details with Payment information helps finance teams reconcile transactions quickly, giving everyone a single source of truth for daily decisions. The visual format makes it easy to spot trends in your ecommerce performance and share actionable insights across your organization.

Try out all the features for free for 14 days

Tray data available in Airtable

available pipelines

328

extractable fields

Available integrations

Integration	Description
Customers	Includes information such as name, email, and registration date, along with modification date and last visit.
Discount Coupons	Contains details such as coupon code, creation date, and discount value, along with usage restrictions.
Newsletters	Presents information about the customer's email, newsletter status, and creation and modification dates.
Payments	Includes data on payment methods, status, and values of transactions made by customers.
Orders	Provides information such as order ID, order date, and delivery status, along with customer details.
Order Details	Includes detailed information such as order ID, billing address, and additional cart values.
Order Details: Mercado Livre	Presents data such as customer ID, estimated delivery date, and information about the purchased product.
Additional Product Information for Orders	Contains additional information such as product ID and product name related to each order.
Order Invoices	Includes data such as invoice ID and product CFOP, essential for accounting.
Order Transactions	Provides information on transaction status and values associated with each order made.
Products	Table contains information about products, including id, name, and variants. Fields such as attributes_id and attributes_value provide additional details.
Products (Kits)	Table presents product kits, detailing id and attributes. Fields such as attributes_customer_attribute_id provide information about the characteristics of the kits.
Sold Products	Table displays sold products, including id and sales information. Fields such as order_id and order_item_quantity help understand sales performance.
Products: Variants	Table details product variants, including id and attributes. Fields such as additionalproductinfo_product_id and additionalproductinfo_variant_id provide specific information about each variant.

Customers

Includes information such as name, email, and registration date, along with modification date and last visit.

Discount Coupons

Contains details such as coupon code, creation date, and discount value, along with usage restrictions.

Newsletters

Presents information about the customer's email, newsletter status, and creation and modification dates.

Payments

Includes data on payment methods, status, and values of transactions made by customers.

Orders

Provides information such as order ID, order date, and delivery status, along with customer details.

Order Details

Includes detailed information such as order ID, billing address, and additional cart values.

Order Details: Mercado Livre

Presents data such as customer ID, estimated delivery date, and information about the purchased product.

Additional Product Information for Orders

Contains additional information such as product ID and product name related to each order.

Order Invoices

Includes data such as invoice ID and product CFOP, essential for accounting.

Order Transactions

Provides information on transaction status and values associated with each order made.

Products

Table contains information about products, including id, name, and variants. Fields such as attributes_id and attributes_value provide additional details.

Products (Kits)

Table presents product kits, detailing id and attributes. Fields such as attributes_customer_attribute_id provide information about the characteristics of the kits.

Sold Products

Table displays sold products, including id and sales information. Fields such as order_id and order_item_quantity help understand sales performance.

Products: Variants

Table details product variants, including id and attributes. Fields such as additionalproductinfo_product_id and additionalproductinfo_variant_id provide specific information about each variant.

See all available data →

Try out all the features for free for 14 days

How to create Tray dashboards in Airtable

Visualize your data automatically — no spreadsheet exports or custom scripts.

Connect Tray as your data source

Log into Kondado and add Tray by entering your store credentials to establish the connection. Select which of the 14 available pipelines you want to replicate, such as Orders, Customers, or Products.

Select Airtable as your destination

Choose Airtable as where you want to visualize your Tray data, or explore alternatives like Power BI or Looker Studio if you prefer different reporting tools. Configure which base will receive your pipeline data.

Configure refresh schedule and build reports

Set your preferred update frequency, from every 5 minutes to daily, and start building custom views in Airtable. Create visual reports combining Order Details with Sold Products data to track business performance automatically.