Lazada

Lazada ETL connector for data replication

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	BOOLEAN
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	STRING
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