Lazada

Need help with something?

Talk to data expert

Lazada ETL connector for data replicatio

Snapshot

Features Details
Release Status Released
Source API Version v2
Table Selection Yes
Column Selection Yes
Edit Integration Yes
Replication Type Selection No
Authentication Parameters Lazada App Id 
Lazada App secret 
Lazada Email
Lazada password
Replication Type Key based Replication
Replication Key DATE
Suggested Replication Frequency 24 hrs
Tables/APIs Supported  
Orders MultipleOrderItems

Integrate Lazada with Daton

  1. Signin to Daton
  2. Select Lazada from Integrations page
  3. Provide Integration Name, Replication,Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later
  4. Provide your Lazada client Id and client Secret (if you don't provide,Daton will use it's keys)
  5. After providing the keys, select the seller country , provide seller Email and Password to authorize Daton to periodically extract data from Lazada.
  6. Post successful authentication you will be prompted to choose from the list of available tables
  7. Then select all required fields for each table
  8. Submit the integration.

Workflow

  1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
  2. Users would be able to edit/pause/re-activate/delete integration anytime
  3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

Lazada Data

Orders

Purpose: Use this API to get all the orders available. This API has list of items for a range of orders.

Source API Documentation  https://open.lazada.com/doc/api.htm?spm=a2o9m.11193487.0.0.3ac413fe5Pix7F#/api?cid=8&path=/orders/get

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name Target Datatype
voucher_platform NUMERIC
warehouse_code STRING
voucher NUMERIC
order_number NUMERIC
voucher_seller NUMERIC
created_at TIMESTAMP
voucher_code NUMERIC
gift_option STRING
shipping_fee_discount_platform NUMERIC
customer_last_name STRING
updated_at TIMESTAMP
promised_shipping_times STRING
price STRING
national_registration_number NUMERIC
shipping_fee_original NUMERIC
payment_method STRING
customer_first_name STRING
shipping_fee_discount_seller NUMERIC
shipping_fee NUMERIC
branch_number STRING
tax_code STRING
items_count NUMERIC
delivery_info STRING
statuses STRING
address_billing RECORD
extra_attributes STRING
order_id NUMERIC
gift_message STRING
remarks STRING
address_shipping RECORD

MultipleOrderItems

Purpose: Use this API to get the item information of all the orders.

Source API Documentation: https://open.lazada.com/doc/api.htm?spm=a2o9m.11193487.0.0.3ac413fe5Pix7F#/api?cid=8&path=/orders/items/get

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name Target Datatype
tax_amount NUMERIC
reason STRING
sla_time_stamp STRING
purchase_order_id STRING
voucher_seller NUMERIC
voucher_code_seller NUMERIC
voucher_code STRING
package_id STRING
variation NUMERIC
voucher_code_platform STRING
purchase_order_number STRING
sku STRING
invoice_number STRING
order_type STRING
cancel_return_initiator STRING
shop_sku STRING
stage_pay_status STRING
tracking_code_pre STRING
order_item_id NUMERIC
shop_id STRING
order_flag STRING
name STRING
order_id NUMERIC
status STRING
paid_price NUMERIC
product_main_image STRING
voucher_platform NUMERIC
product_detail_url STRING
promised_shipping_time STRING
warehouse_code STRING
shipping_type STRING
created_at STRING
updated_at STRING
currency STRING
shipping_provider_type STRING
shipping_fee_original NUMERIC
is_digital NUMERIC
item_price NUMERIC
shipping_service_cost NUMERIC
tracking_code STRING
shipping_amount NUMERIC
reason_detail STRING
return_status STRING
shipment_provider STRING
voucher_amount NUMERIC
digital_delivery_info STRING
extra_attributes STRING