Lazada

Maintain Cloud Account

1. Select Maintain Cloud Account (One Time Setting)

   

2. Click on NEW

   

   1. Enter Description

   2. Select Platform

   3. Click on Link Button

3. Select Platform

   

4. Login with your credentials

   

5. Press on SAVE

   

   • Once linking Successful, system will be returned status Linking Success Message.

Configure E Commerce Setting

1. GL > Maintain Account

   1. Create Lazada Voucher / Discount Account Under Sales Adjustment

      

   2. Create Shipping and Transaction Fee under Expenses

      

      info

      It is up to company want to create under which category. Some of the Company will create under Cost of Goods Sold.

2. Customer > Maintain Customer

   

3. Stock > Maintain Stock Group

   Create Lazada Shipping / Transaction / Voucher / Discount Stock Group

   1. Create Discount Stock Group

      

   2. Create Voucher Stock Group

      

      • Repeat same step to create for Shipping and Transaction Fees Stock Group

4. Stock > Stock Item

   1. Create Discount Stock Item

      

   2. Create Voucher Item Code

      

      • Repeat same step to create for Shipping and Transaction Fees Item Code

Account Tab

1. Click on > Lazada

2. Click on Account Tab > Double click on your account

   

   1. Mapping Code

      

   2. Expiry Date

      • Is the linking expired with both parties given by Lazada platform for security policy, once expired must relink with Lazada account to fetch the order.

      Youtube

Product Tab

1. Step to download Product list from Lazada

2. Click on “Products” Tab, then click on “Manage Products” and then click “Bulk Manage”

   

3. Select “Bulk Edit” option

   

4. Press “Export Excel Template” and save it to your computer location.

   

   You can choose to have Lazada SKU as SQL Item Code by import to SQL. May contact your service agent to assist on this product import.

5. Fetch Product

6. Click on Product Tab > Click on Fetch Button > System will return the message when fetching done.

   

7. Verify Status: Exist in Stock Item are meaning SQL and Seller SKU are having the same Item Code.

   

   info

   If you decide to use the same item code as Seller Sku, click on select All records > press on Post button for the first time so system will remember the settings.

   

8. Verified Status: Success when posting done

   

   note

   Once you post successful, system will keep the Shop SKU in Stock Item as Alternative Item

   

9. You can still decide to map to different item code (system will auto ticked the record you change the item code), once done all, click on POST button.

   

   Youtube

Orders Tab

1. Click on Orders Tab

   

2. Status – Default Post Action

   

   

   Remark: Each order number will be posted once. You can delete the Invoice if you want to repost.

3. Fetch Order

   1. Select Date Range > Click on Refresh Order

      

      Please be patient, system is on the way to fetch the order from Lazada

      

      

      System will return the message when Fetching Done, Press OK.

4. Post Order

   1. Click on the status you want to post the order, let us take an example on Delivered Status > Ticked all > Click on Post

      

   2. If you did not tick on any order when do the posting, system will raise a message: You have not selected any order. Would you like to select all? If you would like to post all > Press Yes

      

      Please be patient to wait for the order posting.

      

   3. Click on OK when done posting

      

5. Verify Status

   

   1. Posted

      • Earlier Order posted before, system will ignore.

   2. Success

      • Order had been successfully Posting.

   3. Failed – Missing Dataset Property

      • Normally repost will be fine.

      

   4. Failed – Missing Item Code

      • Is due to Lazada have inactive item code, user can manually map in orders.

      1. Click on Item Code Drop Down, user can manually map the item code

      2. Ticked on the record you want to post

      3. Click on Post

         

6. Sales Invoice

   • Example of Sales Invoice posted from Lazada | Orders.

     

     

7. Sales Credit Note

   • Example of Sales Credit Note posted from Lazada | Orders.

     

     Returned Sales will be posted to 1 document only.

     In this scenario it is posted to Sales Invoice.

     Select “Post” to post it to sales invoice.

     

     

     Youtube

8. Status – Others than Default POST Action

   • Beside the post button, press the black triangle, and select ”Post” to post it to sales invoice.

     

     

Payment Tab

1. Step to Download statement from Lazada

   1. Click on Seller Center > Finance Tab on left menu > Account Statement - > Statement Period

      note

      The new version of Lazada Seller Center, has changed the settlement period from weekly to daily.

      

   2. At your Statement Overview, go to Settlement Report to see the weekly statement.

      

   3. Click “Download” and download the file of the weekly statement that contains the payments that you want to export.

      

2. Posting Payment

   1. Select Account (Only if you have more than 1 store)

   2. Click Load CSV (Statement downloaded from Step 1.6)

      

   3. Select the statement download from Lazada

      

   4. Click on Post

      

   5. Error in Red: Please sync all orders before posting payment.

      • Due to some order yet posting to Invoice. Before you do the posting, you can check on Invoice No column, post the orders with empty Invoice No.

      

      info

      Lazada required you to sync all order before can posting payment due to have to tally with bank recon.

   6. Once you check all the order have been posting (without empty Invoice No), click on Post

      

   7. Posting Payment / Editing Invoice for Lazada Fees, please be patient

      

   8. Cheque number already exists

      • Press Yes, system capture Lazada Payment ref ID as Cheque number.

      

      User can choose to turn off prompt duplicate cheque number at Tools > Option > Miscellaneous > Unticked Prompt Duplicate Cheque Number.

      

   9. Posting done

      

   10. System will skip posting when Item Price is 0

       

   11. Example of Sales Invoice with added in Transaction Fees Posted from Lazada | Payment

       

       note

       Version 794 – 801 will post to Sales CN

       Version 802 & above is Edit Sales Invoice and added in

   12. Example of Customer Payment posted from Lazada | Payment

       • System will auto do the knockoff

         note

         Same Transaction Date will be posting as 1 Customer Payment.

   13. Example of Bank Deposit posted from Lazada | Payment

       • 7 Days of payment will group as 1 row in bank recon for easier bank recon.

         

         note

         Bank Slip No is Lazada Payment Ref ID

         Example of Bank Recon

         

         Youtube

3. Verify Status

   1. Not Paid

      • Paid Status is status for user to know the order have or have not pay to seller.

      • Not paid status will not posting to Customer payment.

        

   2. Payment ref id not found

      • Lazada allows seller to forward date download finance statement, without Payment ref ID which mean Lazada yet release payment to Seller, SQL will not posting without payment ref ID.

FAQ

1. How to do if have multiple location for each store?

   • It is advisable user to create one Location called Ecommerce, use the stock transfer from location A to Ecommerce, Location B to Ecommerce, in Ecommerce | Shopee | Account | Location set to Ecommerce.

2. How to do if I want to split Lazada and Shopee Sales?

   • Can separate by Project

   • Tools > Maintain Project

3. How system handle Lazada Marketing Fees?

   When load in Payment file(.csv) file in Payment Tab with marketing fees, if the amount is in positive, system will raise IV and payment, else system will post to Sales CN and Customer Refund.

   Marketing Fees will post to Transaction Item Code.

4. Error sending data : (12002) The operation timed out

   1. User Internet unstable. Please check your internet connection. May try on others wifi or using mobile data.

   2. Lazada server down, please try again later.

5. How system handle Reversal Item Price and Adjustment Item Charge?

   • When load payment file, once the lazada payment release more than Outstanding Invoice amount, will deleted CN.

6. How system handle Opening Invoice?

   • Load in payment, when order date before system conversion date, right click Select Check Past Invoice, Click on Post Past Invoice

     

   • User required to post the past invoice in Order

7. Order Not Post when load in payment, how do I know the Order Date?

   • Make sure in payment choose the correct store name, right click select Check Past Invoice

   • Look for Order Date, system will show the Order Date on Verify Status with Order Not Posted

     

8. How system handle for the scenario when first release payment in negative due to overcharge on shipping fees

   • When load payment, once release amount is in negative, system will delete earlier Invoice, and raise CN(amount will be exactly same as Payment file) and Refund.

   • When 2nd payment(Adjustment), if the amount is in negative, append to CN and Refund, if in positive, will raise Invoice(Adjustment value) and Payment.

9. Fetch Order raise error : E097 : Offset and limit sum 5100 must less than 5000, request id : 2101235d16xxxx

   

   • Lazada API Returned error as too huge transaction being fetched, the only way is to shorten the date period.

10. The specified access token is invalid or expired

    

    • Lazada API link expired, you are required to go back maintain cloud and link again with Lazada platform (Refer Step 1.1.3 – 1.1.5)

11. API access frequently exceeds the limit. This ban will last 1 seconds

    

    • Error appears after click Fetch. Solution, close your Lazada tab in SQL Account > re-open it > click “Fetch” button again

12. How system handle “Failed Delivery" in SQL?

Orders with “Failed Delivery” in Lazada will be fetch into SQL with the status as canceled.

If the order has transaction fees to offset, the canceled order can be posted as Cancelled Sales Invoice.

To post as invoice, click the black arrow beside the “Post” button and select “Post as Cancelled Sales Invoice”.