Lazada: Most-used fieldsΒΆ
The table below gives information about most-used fields that you can import from Lazada. Other fields might also be available in Adverity.
The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.
address_billing.address1 Dimension
The first line of the billing address for the order.
address_billing.address2 Dimension
The second line of the billing address for the order. This field may not always be used or populated.
address_billing.address3 Dimension
The third line of the billing address, typically representing the state name.
address_billing.address4 Dimension
The fourth line of the billing address, typically representing the city.
address_billing.address5 Dimension
The fifth line of the billing address, typically representing the postal code.
address_billing.city Dimension
The city component of the billing address.
address_billing.country Dimension
The country component of the billing address.
address_billing.first_name Dimension
The first name of the customer for billing purposes.
address_billing.last_name Dimension
The last name of the customer for billing purposes.
address_billing.phone Dimension
The primary phone number for the billing address.
address_billing.phone2 Dimension
The secondary phone number for the billing address.
address_billing.post_code Metric
The postal code of the billing address.
address_shipping.address1 Dimension
The first line of the shipping address for the order.
address_shipping.address2 Dimension
The second line of the shipping address for the order. This field may not always be used or populated.
address_shipping.address3 Dimension
The third line of the shipping address, typically representing the state name.
address_shipping.address4 Dimension
The fourth line of the shipping address, typically representing the city.
address_shipping.address5 Dimension
The fifth line of the shipping address, typically representing the postal code.
address_shipping.city Dimension
The city component of the shipping address.
address_shipping.country Dimension
The country component of the shipping address.
address_shipping.first_name Dimension
The first name of the customer for shipping purposes.
address_shipping.last_name Dimension
The last name of the customer for shipping purposes.
address_shipping.phone Dimension
The primary phone number for the shipping address.
address_shipping.phone2 Dimension
The secondary phone number for the shipping address.
address_shipping.post_code Metric
The postal code of the shipping address.
attributes.{PLACEHOLDER} Dimension
Customizable product attributes, where {PLACEHOLDER} represents the specific attribute name.
buyer_note Dimension
Any notes or special instructions provided by the buyer for the order.
cancel_return_initiator Dimension
Indicates who initiated the cancellation or return of an order. Possible values include 'cancellation-customer', 'cancellation-seller', 'return-customer', etc.
created_at Dimension
The timestamp indicating when the order was created.
created_time Dimension
The timestamp indicating when a product listing was created.
currency Dimension
The currency code used for monetary values within the order, such as 'SGD' for Singapore Dollar or 'MYR' for Malaysian Ringgit.
customer_first_name Dimension
The first name of the customer associated with the order.
customer_last_name Dimension
The last name of the customer associated with the order.
delivery_info Dimension
Information related to the delivery of the order, such as delivery service or estimated delivery date.
delivery_option_sof Metric
Indicates whether the delivery option is 'Seller Own Fleet'. Values can be 1 (yes) or 0 (no).
digital_delivery_info Dimension
Information pertaining to the delivery of digital goods or services for the order.
extra_attributes Dimension
Additional attributes or custom fields associated with the order.
gift_message Dimension
The personalized message provided by the customer for a gift order.
gift_option Dimension
Indicates if the gift option was selected for the order. Values can be 1 (yes) or 0 (no).
images.{NUM} Dimension
A list of URLs for product images, where {NUM} represents the index of the image.
invoice_number Dimension
The unique invoice number associated with the order.
is_cancel_pending Dimension
Boolean flag indicating if the order has a pending cancellation request.
is_digital Metric
Indicates if the order contains digital products.
is_fbl Metric
Indicates if the order is fulfilled by Lazada (FBL). Values can be 1 (yes) or 0 (no).
item_id Dimension
The unique identifier for a product item.
item_price Metric
The price of a single item within the order, before any order-level discounts.
items_count Metric
The total number of distinct items in the order.
name Dimension
The name of the product or item.
national_registration_number Dimension
The customer's national registration number, required in some countries.
need_cancel_confirm Dimension
Indicates whether a cancellation confirmation is required for the order.
order_id Dimension
The unique identifier for the order within the Lazada system.
order_item_id Dimension
The unique identifier for a specific item within an order. Each item in an order has a unique ID, even if multiple identical items are purchased.
order_number Dimension
The human-readable order number.
order_type Dimension
The type of order, such as 'NORMAL', 'GUARANTEE', or 'GLOBAL_COLLECTION'.
paid_price Metric
The total price paid by the customer for the order, including all discounts and adjustments.
payment_method Dimension
The method of payment used for the order.
price Metric
The total order price, excluding product discounts and order discounts.
primary_category Metric
The main category to which a product belongs.
product_detail_url Dimension
The URL linking to the detailed product page on the Lazada platform.
product_main_image Dimension
The URL of the main image for the product.
promised_shipping_time Dimension
The target shipping time for the soonest order item.
promised_shipping_times Dimension
A collection of promised shipping times, potentially for different items or stages of the order.
remarks Dimension
General remarks or comments related to the order.
report_date Dimension
The date for which the report data is generated.
reverse_order_id Dimension
The ID associated with a reverse order (e.g., return or refund).
shipment_provider Dimension
The name of the shipping or logistics provider handling the shipment.
shipping_amount Metric
The total amount charged for shipping.
shipping_fee Metric
The actual shipping cost paid by the seller, including any shipping fee discounts.
shipping_fee_discount_platform Metric
The discount applied to the shipping fee by the Lazada platform.
shipping_fee_discount_seller Metric
The discount applied to the shipping fee by the seller.
shipping_fee_original Metric
The original shipping fee before any discounts were applied.
shipping_provider_type Dimension
The type of shipping provider, which may indicate service speed or other characteristics.
shop_id Dimension
The unique identifier for the shop or seller store.
shop_sku Dimension
The unique SKU identifier assigned by the shop for a specific product variation.
sku Dimension
The Stock Keeping Unit (SKU) identifier for the product, typically assigned by the seller.
sku_id Dimension
The unique identifier for a Stock Keeping Unit (SKU) within the Lazada system.
skus.{NUM}.Available Metric
Indicates the availability status of a specific SKU (Stock Keeping Unit), where {NUM} is the SKU index.
skus.{NUM}.SellerSku Dimension
The unique SKU identifier assigned by the seller for a specific product variation, where {NUM} is the SKU index.
skus.{NUM}.ShopSku Dimension
The unique SKU identifier assigned by the shop for a specific product variation, where {NUM} is the SKU index.
skus.{NUM}.SkuId Metric
The unique identifier for a Stock Keeping Unit (SKU) within the Lazada system, where {NUM} is the SKU index.
skus.{NUM}.Status Dimension
The current status of a specific SKU (e.g., active, inactive), where {NUM} is the SKU index.
skus.{NUM}.Url Dimension
The URL for the product page of a specific SKU, where {NUM} is the SKU index.
skus.{NUM}.multiWarehouseInventories.{NUM}.occupyQuantity Metric
The quantity of a specific SKU currently reserved or occupied across multiple warehouses, where the first {NUM} is the SKU index and the second {NUM} is the warehouse inventory index.
skus.{NUM}.multiWarehouseInventories.{NUM}.quantity Metric
The total quantity of a specific SKU across multiple warehouses, where the first {NUM} is the SKU index and the second {NUM} is the warehouse inventory index.
skus.{NUM}.multiWarehouseInventories.{NUM}.sellableQuantity Metric
The quantity of a specific SKU available for sale across multiple warehouses, where the first {NUM} is the SKU index and the second {NUM} is the warehouse inventory index.
skus.{NUM}.multiWarehouseInventories.{NUM}.totalQuantity Metric
The total physical quantity of a specific SKU across multiple warehouses, where the first {NUM} is the SKU index and the second {NUM} is the warehouse inventory index.
skus.{NUM}.multiWarehouseInventories.{NUM}.warehouseCode Dimension
The code of the warehouse storing a specific SKU, where the first {NUM} is the SKU index and the second {NUM} is the warehouse inventory index.
skus.{NUM}.multiWarehouseInventories.{NUM}.withholdQuantity Metric
The quantity of a specific SKU withheld from sale across multiple warehouses, where the first {NUM} is the SKU index and the second {NUM} is the warehouse inventory index.
skus.{NUM}.package_height Metric
The height of the package for a specific SKU, where {NUM} is the SKU index.
skus.{NUM}.package_length Metric
The length of the package for a specific SKU, where {NUM} is the SKU index.
skus.{NUM}.package_weight Metric
The weight of the package for a specific SKU, where {NUM} is the SKU index.
skus.{NUM}.package_width Metric
The width of the package for a specific SKU, where {NUM} is the SKU index.
skus.{NUM}.price Metric
The regular selling price of a specific SKU, where {NUM} is the SKU index.
skus.{NUM}.quantity Metric
The total available quantity for a specific SKU, where {NUM} is the SKU index.
skus.{NUM}.special_price Metric
The special promotional price of a specific SKU, where {NUM} is the SKU index.
status Dimension
The current status of a product listing.
statuses.{NUM} Dimension
A collection of unique statuses for the items within the order. Lazada processes item statuses individually rather than a single order status.
tax_amount Metric
The total tax amount applied to the order.
tax_code Metric
The tax code applicable to the item or order. This is required in some countries for corporate customers.
tracking_code Dimension
The tracking code provided by the shipment provider for the package.
updated_at Dimension
The timestamp indicating when the order was last updated.
updated_time Dimension
The timestamp indicating when a product listing was last updated.
variation Dimension
Details about the specific variation of a product (e.g., size, color).
voucher Metric
The total value of vouchers applied to the order.
voucher_amount Metric
The monetary value of the voucher applied.
voucher_code Metric
The code of the voucher applied to the order.
voucher_code_platform Dimension
The code for a voucher provided by the Lazada platform.
voucher_code_seller Metric
The code for a voucher provided by the seller.
voucher_platform Metric
The total value of vouchers provided by the Lazada platform applied to the order.
voucher_seller Metric
The total value of vouchers provided by the seller applied to the order.
warehouse_code Dimension
The code of the warehouse from which the order items are shipped.