> ## Documentation Index
> Fetch the complete documentation index at: https://docs.adriel.com/llms.txt
> Use this file to discover all available pages before exploring further.
# Data reference
> Metrics, breakdowns, refresh cadence, and limits for the Lazada data source in Adriel.
## Introduction
Lazada is a Southeast Asian marketplace e-commerce platform. The connector syncs a seller's shop orders and products from the Lazada Open Platform REST API, exposing order-level revenue, sales, and product catalog data for dashboards. Each connected account maps to exactly one shop in one country, and the shop's reporting currency and timezone are derived automatically from that country.
Like other e-commerce connectors, Lazada does not directly provide the aggregated sales analytics shown in its own seller center. Adriel reconstructs shop sales performance from raw order and product data so that order, revenue, and product metrics can aggregate alongside ad-platform sources without extra configuration. Lazada exposes no connector-specific metrics or breakdowns — it relies entirely on the standard e-commerce metric and breakdown set.
Lazada is a **beta** connector and access is restricted to an allowlist of workspaces. If the connector does not appear for a workspace, it has not been enabled for that account.
To connect this data source, see [How to connect Lazada to Adriel](/data-sources/g-n/lazada/how-to-connect).
## Data refresh strategy
### Architecture data
Architecture covers the shop's product catalog. Products are fully refreshed **once per day**. Each Lazada product is expanded into one record **per SKU**, so a listing with several variants produces one record per variant. Each record includes the product name, SKU-level detailed name, price, image, status, and created / updated timestamps.
### Reports data
Reports cover order-level financial and status data.
**Refresh schedule.** Orders sync on a **daily** cadence (not hourly). At every refresh, orders created or modified in the last **1 day** are pulled, one day at a time. The sync captures orders that were *updated* within the window, not only newly created ones.
**Today is excluded.** The current day is not included in the sync range, so a full day of data becomes available after that day closes in the shop's timezone.
**Historical window.** Up to **90 days** of historical orders and products can be back-filled. Data older than 90 days cannot be retrieved from Lazada through this connector.
## Architecture levels
Shop → Product → SKU, and Order → Line item.
Each product SKU is a separate record. Each order's line items contribute to the order's financial totals and to product-order metrics.
## Date range limits
| Breakdown | Max range |
| ---------------------------- | --------------------------------------------------------- |
| Daily | 93 days |
| Weekly | 1 year |
| Monthly / Quarterly / Yearly | No explicit cap (bounded by the 90-day historical window) |
## Metrics
**How to read the columns**
The **Data type** column uses this vocabulary: Number, Currency, Percentage, Ratio, Duration, Date, Text, URL, Array, Boolean.
The **API Key** column uses code style like `shipping_fee` for the literal Lazada raw field the value maps to. *Italic text* describes how a value is produced when it doesn't map to a single Lazada field — typically an Adriel-side computation, an aggregation across order rows, or a value that Lazada does not provide.
### Orders
| Metric | Description | Data type | API Key |
| ------------------ | --------------------------------------------------------------------------------------------------------------------------------------- | --------- | -------------------------------------------- |
| Order Count | Distinct number of orders. | Number | *Aggregated from order rows* |
| Order Buyer Count | Distinct number of buyers. Buyer identity is stored as a privacy-preserving hash, never as raw names. | Number | *Distinct count of hashed buyer* |
| Order Date | Order date, converted to the shop's country timezone before storage. | Date | *Derived from the Lazada order created date* |
| Order Updated Date | Order last-updated date, converted to the shop's country timezone. | Date | *Derived from the Lazada order update date* |
| Order Payment Date | Always empty for Lazada — payment timestamps are only available at line-item level, so the order-level payment date is never populated. | Date | *Not provided by Lazada (always empty)* |
| Order Currency | Reporting currency, auto-assigned from the shop's country (VND, SGD, PHP, MYR, THB, IDR; USD as fallback). | Text | *Auto-assigned from shop country* |
| Order Status | Order status, passed through from Lazada. | Text | `statuses[0]` |
### Revenue & sales
| Metric | Description | Data type | API Key |
| --------------------- | ----------------------------------------------------------------------------------------------- | --------- | -------------------------------------------- |
| Order Price Amount | Order total: price minus voucher plus shipping. | Currency | *Computed:* `price - voucher + shipping_fee` |
| Order Payment Amount | Payment total. Uses the same formula as Order Price Amount, so the two values match for Lazada. | Currency | *Computed:* `price - voucher + shipping_fee` |
| Order Amount Due | Amount due: price plus shipping minus voucher. | Currency | *Computed:* `price + shipping_fee - voucher` |
| Order Discount Amount | Voucher / discount applied to the order. | Currency | `voucher` |
| Order Shipping Fee | Shipping fee charged on the order. | Currency | `shipping_fee` |
| Order Tax Amount | Sum of line-item tax across the order's items. | Currency | *Summed from line-item* `tax_amount` |
### Products
| Metric | Description | Data type | API Key |
| -------------------------- | ------------------------------------------------------------------------------- | --------- | ---------------------------------------------- |
| Product Price | Listed SKU price. | Currency | `price` |
| Product Retail Price | Retail price. Lazada exposes a single SKU price, so this matches Product Price. | Currency | `price` |
| Product Image | Primary product image URL (first image on the listing). | URL | `images[0]` |
| Product Currency | Reporting currency, auto-assigned from the shop's country. | Text | *Auto-assigned from shop country* |
| Product Created Date | Date the product was created, converted to the shop's country timezone. | Date | *Derived from the Lazada product created date* |
| Product Updated Date | Date the product was last updated, converted to the shop's country timezone. | Date | *Derived from the Lazada product update date* |
| Product Order Price Amount | Revenue tied to a specific product within an order. | Currency | *Computed from line items* |
| Product Order Quantity | Units of a specific product within an order. | Number | *Computed from line items* |
**Product Order metrics link products with their orders.** When a Product Order metric is used with a product filter, only the portion of the order tied to that product is included, and only orders containing at least one matching product are shown. If a product can no longer be retrieved from Lazada (for example, if it was deleted), its related orders may not appear — use Product Order metrics only when necessary.
## Breakdowns
**Lazada-sourced vs Adriel-provided**
Breakdowns whose API Key is a Lazada field (e.g. `order_id`, `warehouse_code`) come directly from the Lazada order or product data. Breakdowns marked *Adriel-derived* are computed on top of the raw data — such as mapping Lazada's status strings to Adriel's status set, or joining the product name with its sale properties. Time-grouping and overview breakdowns are provided by Adriel and have no Lazada field.
### Products
| Breakdown | Description | API Key |
| --------------------- | ----------------------------------------------------------------------------------------------------- | ----------------------------- |
| Product ID | SKU-level product identifier. | `SkuId` |
| Product Name | Product listing name. | `attributes.name` |
| Product Detailed Name | Product name joined with its sale-property values (falls back to the product name alone). | *Adriel-derived* |
| Product SKU | Stock keeping unit (SKU-level identifier). | `SkuId` |
| Product Status | Lazada status mapped to Adriel's status set (active, hidden, denied, reviewing, deleted, or unknown). | *Adriel-mapped from* `status` |
### Order details
| Breakdown | Description | API Key |
| -------------------- | ------------------------------------------------------ | ------------------------ |
| Order ID | Lazada order identifier. | `order_id` |
| Order Status | Order status, passed through from Lazada. | `statuses[0]` |
| Order Source | Fulfillment warehouse the order ships from. | `warehouse_code` |
| Order Payment Method | Payment method on the order, when Lazada provides one. | *From Lazada order data* |
### Time & date grouping
Time-grouping breakdowns are Adriel-side aggregations of the same underlying order data; none map to a Lazada field.
| Breakdown | Description |
| ------------------- | --------------------------------------------------------------------- |
| Auto Time Breakdown | Automatically picks the best granularity for the selected date range. |
| Daily | Split reports by day. Max range 93 days. |
| Weekly (Start: Mon) | Split reports by week starting Monday. Max range 1 year. |
| Weekly (Start: Sun) | Split reports by week starting Sunday. Max range 1 year. |
| Monthly | Split reports by calendar month. |
| Quarterly | Split reports by calendar quarter. |
| Yearly | Split reports by calendar year. |
### Overview
Overview breakdowns are provided by Adriel and have no Lazada field.
| Breakdown | Description |
| --------------- | --------------------------------------------- |
| No Grouping | Do not break down; return one aggregated row. |
| Datasource Name | Group by Adriel datasource name. |
## Limitations
Based on the current connector, Lazada has:
* **Beta, allowlist-only access.** The connector is enabled only for an allowlist of workspaces; it does not appear for other accounts.
* **A 90-day historical limit.** Orders and products older than 90 days from today cannot be back-filled.
* **Daily refresh only.** Order sync runs once per day on a rolling 1-day window; there is no hourly refresh, and the current day is excluded until it closes.
* **No order payment date.** Lazada provides payment timestamps only at line-item level, so the order-level Order Payment Date is always empty.
* **Order Price Amount and Order Payment Amount are identical.** Both use the same formula (`price - voucher + shipping_fee`), so they do not distinguish list price from captured payment.
* **Product Price and Product Retail Price are identical.** Lazada exposes a single SKU price, so there is no separate compare-at / retail value.
* **One shop, one country per account.** Each connection is tied to a single Lazada shop and country; the currency and timezone follow that country automatically.
* **Indonesia timezone offset.** Indonesian shops are normalized using `Asia/Kolkata` (+05:30) rather than `Asia/Jakarta` (+07:00), so Indonesian timestamps are offset. (Known issue — flagged for engineering.)
* **Buyer identity is hashed.** Buyer names are stored only as a hash, so no personally identifiable buyer breakdown is available.
* **No preview / example data.** Example data is not available for this connector.
## API references (Lazada)
* [Lazada Open Platform](https://open.lazada.com/)
The connector reads orders from the Lazada Open Platform REST endpoints `/orders/get` and `/orders/items/get`, and products from `/products/get`.
## See also
* [How to connect Lazada](/data-sources/g-n/lazada/how-to-connect) (paired how-to)
* [Shopee data reference](/data-sources/o-z/shopee/data-reference) — another Southeast Asian marketplace commerce platform
* [Shopify data reference](/data-sources/o-z/shopify/data-reference) — direct-to-consumer commerce platform