Lazada
Lazada
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
- Signin to Daton
- Select Lazada from Integrations page
- Provide Integration Name, Replication,Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later
- Provide your Lazada client Id and client Secret (if you don't provide,Daton will use it's keys)
- After providing the keys, select the seller country , provide seller Email and Password to authorize Daton to periodically extract data from Lazada.
- Post successful authentication you will be prompted to choose from the list of available tables
- Then select all required fields for each table
- Submit the integration.
Workflow
- 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
- Users would be able to edit/pause/re-activate/delete integration anytime
- 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 |
