Lazada Connector Reference

The Lazada connector exposes 41 fields (4 metrics, 37 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Lazada Fields

Lazada Categories fields

The Categories report of the Lazada connector includes 5 fields.

ID	Type	Name	Description
category_id	TEXT	Category ID	The unique identifier of the category.
category_leaf	BOOLEAN	Category Leaf	Whether the category is a leaf category.
category_name	TEXT	Category Name	The name of the category.
category_path	TEXT	Category Path	The full path of the category in the tree.
parent_category_id	TEXT	Parent Category ID	The identifier of the parent category.

Lazada Products fields

The Products report of the Lazada connector includes 15 fields.

ID	Type	Name	Description
brand	TEXT	Brand	The brand of the product.
created_time	TIMESTAMP	Product Created Time	The date and time the product was created.
primary_category	TEXT	Primary Category	The primary category ID of the product.
product_available	NUMERIC	Product Available	The available quantity of the SKU.
product_id	TEXT	Product ID	The unique identifier of the product.
product_name	TEXT	Product Name	The name of the product.
product_price	NUMERIC	Product Price	The price of the SKU.
product_quantity	NUMERIC	Product Quantity	The stock quantity of the SKU.
product_special_price	NUMERIC	Product Special Price	The special (discounted) price of the SKU.
product_status	TEXT	Product Status	The status of the product.
seller_sku	TEXT	Seller SKU	The seller-defined SKU code.
shop_sku	TEXT	Shop SKU	The Lazada shop SKU code.
sku_id	TEXT	SKU ID	The unique identifier of the SKU.
sku_status	TEXT	SKU Status	The status of the SKU.
updated_time	TIMESTAMP	Product Updated Time	The date and time the product was last updated.

Lazada other fields

The Lazada connector has 21 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description	Report
account_id	TEXT	Account ID	The seller ID of the connected Lazada account.
account_name	TEXT	Account Name	The name of the connected Lazada account.
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
date	DATE	Date	The date of the record.
day_of_month	TEXT	Day of month	Day of the month
month	TEXT	Month	Number of the month
now	TIMESTAMP	Now	Current timestamp
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date
week	TEXT	Week	Week (Sun-Sat).
week_day	TEXT	Day of week and day number	Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso	TEXT	Day of week and day number, ISO	Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso	TEXT	Week ISO	Week, ISO format (Mon-Sun).
year	TEXT	Year	Year
year_month	TEXT	Yearmonth	Year and month, e.g. 2024|3
year_month_name	TEXT	Year month name	Year and month with the month name written out, e.g. "Jan 2025".
year_of_week	TEXT	Year of week	The year that contains first day of the week (Sun-Sat).
year_of_week_iso	TEXT	Year of week, ISO	The year that contains first day of the ISO week (Mon-Sun).
year_week	TEXT	Year week	Year and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_iso	TEXT	Year week ISO	Year and week for ISO weeks (Mon-Sun), e.g. 2024|20