No-code pipeline · Tray → MySQL

Send data from Tray to MySQL

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

From Tray to MySQL: managed, scheduled, no code.

Kondado replicates data from Tray to MySQL on a configurable schedule, supporting 14 pipelines including Orders, Customers, Products, and Payments with 328 total fields available for analysis.

Connect Tray now →

Send Tray Data to MySQL Automatically

Kondado provides a direct integration between Tray and MySQL, enabling you to replicate your eCommerce data without writing code. You simply connect your Tray store as a data source, configure MySQL as your destination, and select which pipelines you want to replicate. The platform handles the data extraction and loading on a configurable schedule, ensuring your database stays current with your latest transactions and customer information.

Once your Tray data lands in MySQL, you can build custom reports, perform complex SQL queries, and combine eCommerce metrics with data from other business systems. This setup empowers analysts to create comprehensive dashboards in tools like Power BI or Looker Studio, or feed data into Google Sheets for stakeholder reviews.

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

Available Tray Pipelines for MySQL

With Kondado, you can replicate the Orders and Order Details pipelines to track purchase patterns and delivery status directly in your MySQL database. The Customers pipeline brings registration dates and contact information into your warehouse, while the Sold Products pipeline enables detailed sales performance analysis by connecting order IDs with item quantities. Having this Tray data in MySQL allows you to calculate customer lifetime value, monitor inventory turnover, and build automated reports that refresh on your chosen schedule without manual exports.

Try out all the features for free for 14 days

Replicated to MySQL

Tray data available for MySQL

Tables Kondado writes into your MySQL, on a schedule you control.

available pipelines

328

extractable fields

MySQL

Destination

Available integrations

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 → Send Tray to MySQL →

Try out all the features for free for 14 days

How to send Tray data to MySQL

Sync data automatically — no code, no manual exports.

Connect Tray as Your Data Source

Authenticate your Tray store in Kondado by providing your API credentials, allowing the platform to access your eCommerce data for replication.

Configure MySQL Destination Settings

Enter your MySQL database connection parameters including host, port, and credentials to establish where your Tray data will be stored.

Select Pipelines and Update Schedule

Choose which of the 14 available Tray pipelines to replicate, such as Orders or Customers, and set your preferred update frequency from 5 minutes to daily.

Try out all the features for free for 14 days

Hundreds of data-driven companies trust Kondado

Why Kondado?

Focus on extracting value from your data and leave the rest to us

Wherever you need

With the same platform, you send data to AI (Claude/ChatGPT via MCP), reports, spreadsheets, databases, data warehouses, and data lakes. ETL and ELT

Learn More About Our Platform →

From wherever you need

Data from over 80 sources for Marketing, Ecommerce, ERPs, Customer Service, Finance, Databases, and much more

Learn More About Our Data Sources →

Predictable pricing

No surprise invoices, pick a plan and change it anytime

Check out our plans →

Send data from Tray to other destinations

Tray > Looker Studio

Tray > Power BI

Other visualizations

Tray > Amazon S3

Tray > BigQuery

Tray > Excel

Tray > Google Sheets

Tray > MySQL

Tray > PostgreSQL

Tray > Redshift

Tray > SQL Server

Choose a tool to visualize your Tray data

If the software you need is not listed, drop us a messagem. You can use almost every tool

Tray > Airtable

Tray > Alteryx

Tray > Amazon Quicksight

Tray > BIMachine

Tray > Cortex

Tray > Data Studio

Tray > Geckoboard

Tray > Grafana

Tray > IBM Cognos Analytics

Tray > Klipfolio

Tray > Looker Studio

Tray > Looker

Tray > Looqbox

Tray > Metabase

Tray > Microstrategy

Tray > Pentaho

Tray > Power BI

Tray > Qlik Cloud Analytics

Tray > Qlik Sense

Tray > Qlik

Tray > QlikView

Tray > Redash

Tray > Superset

Tray > Tableau

Tray > BI TOTVS

Tray > Zoho Analytics

Frequently Asked Questions (FAQ)

Answers about sending Tray data to MySQL automatically

How does Tray to MySQL replication work with Kondado? ▼

Kondado connects to your Tray store via API to extract data from selected pipelines, then automatically loads and structures that information into your MySQL database. You control which of the 14 available pipelines to replicate, including Orders, Customers, and Products, while the platform manages the data transformation and loading process on your configured timeline.

What Tray data can I replicate to MySQL? ▼

You can choose from 14 different pipelines covering eCommerce operations, including Orders, Order Details, Customers, Payments, and Discount Coupons. Each pipeline contains specific fields such as order IDs, customer emails, product variants, and transaction values, giving you 328 total fields to analyze in your database.

How often does Kondado update Tray data in MySQL? ▼

Kondado replicates data on a configurable schedule that you set according to your business needs, with options ranging from every 5 minutes to daily intervals. This automated approach ensures your MySQL database reflects recent Tray transactions and customer activities without requiring manual data pulls.

How is Tray data structured in MySQL? ▼

Kondado creates organized tables in MySQL for each pipeline you select, preserving the relational structure of your eCommerce data with appropriate data types for fields like dates, currencies, and identifiers. This structure supports complex SQL queries and joins between tables, such as linking Orders with Customers or Products with Sold Products.

Can I combine Tray data with other sources in MySQL? ▼

Yes, you can replicate data from additional sources into the same MySQL instance, allowing you to join Tray eCommerce metrics with information from marketing platforms, ERP systems, or accounting software. This consolidated view enables comprehensive analysis across your entire business operation within a single database environment.

Do I need coding skills to set up Tray to MySQL replication? ▼

No coding is required to configure the connection, Kondado provides a no-code interface where you authenticate your Tray account, enter your MySQL connection details, and select pipelines through a visual menu. The platform handles the technical aspects of data extraction and schema management automatically.

Try out all the features for free for 14 days

Related on Kondado

Try out all the features for free for 14 days