Where & How do System Keep the Product Information?
- Default all the eCommerce Product Information will keep in the Maintain Item | Alt Tab
| Platform | Platform Field |
|---|---|
| Shopee |
|
| Lazada |
|
| WooCommerce | SKU |
Why after Post & Refetch the Product & ItemCode become all duplicate?
- It due to user had Set Same SKU at the eCommerce Platform for Diff product...
How System Post the Shipping Fee Amount?
- For Shopee it use following formula
shipping fee = (escrow + refund) - product price - commission - service - transaction
- For Lazada & WooCommerce it direct get from the platform field
Shopee - How system post when Shipping Fees charges higher than Seller Paid Amount cause escrow amount in negative?
- System will Post to Sales CN and set Qty in Negative (In the Order Tab).
- When Load in Income statement(.xls) files into Payment Tab, system will auto post to Customer Refund.
Shopee - How system post for Order Cancelled with Posted Invoice?
- This Normally happen when Buyer not at Home after few attempt send & seller decide to cancelled the Order
How to handle Serial Number?
- You can Use To Ship Status Post to Quotation first, then manually transfer to Invoice.
- Make sure Enter the Invoice Doc No = Order No and Serial Number as well.
How to do if I want to split different Platform Sales?
- You can use Project Code for each Platform
Lazada - How system Post Marketing Fees?
- When load in Finance statement(.csv) file in Payment Tab (marketing fees without Order No).
- System will post to Sales CN (Transaction Fee) and Customer Refund.
Lazada - How system handle Reversal Item Price and Adjustment Item Charge?
- System will Delete the CN once load payment file(if the lazada payment release more than Outstanding Invoice amount)
How system handle Opening Invoice?
- users need to fetch & post the last 1-2 months orders (into sales invoice)
- during load payment, if system detect got before system conversion date will prompt red alert please sync all, you need right click check past invoice & post past invoice
- if future payment cycle have any adjustment related to past invoice, system will update both SL_IV(itemise detail) & AR_IV (DocAmt)
Shopee - How system handle for Payment Withdraw?
Lazada - How system handle for first release payment in negative due to shipping fees under charge customer?
- 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.
Lazada - Why the Invoice Amount is changes once Payment is loaded?
- It due to Shipping Fee updated.
- Lazada actual Shipping Fee only known after Payment is Loaded.
Lazada - What is the Claim Field for & What GL Account to Set?
- This only use when there is Damage Claim from Lazada.
- You can create New Account under Sales as it part of Sales too.
Where to Download the Statement for each Platform?
May refer below link