FAQ E Commerce

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	SKU Item ID
Lazada	Seller SKU Shop SKU
WooCommerce	SKU
AddToCart	SKU Item ID

[top]

What is the Max Character System allow to Keep in Stock Alternative?

Max Character allow is 30

[top]

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...

[top]

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

[top]

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.

[top]

How to do if I want to split different Platform Sales?

You can use Project Code for each Platform

[top]

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)

[top]

Where to Download the Statement for each Platform?

May refer below link

[top]

What/which transaction will use for the Setting set?

Field	Description
Shipping	Shipping Fee (Shopee & Lazada) Auto. Shipping fee subsidy (by Lazada) Shipping Fee (Paid By Customer) (Lazada) Shipping Fee Voucher (by Lazada) SHIPPING FEE + WOORKMANSHIP (Woocommerce)
Transaction	Commission Fee (Shopee) Service Fee (Shopee) Transaction Fee (Shopee) Payment Fee (Lazada)
Voucher	Seller Voucher (Shopee)
Discount	For bundle deal Eg 1 item RM 5 , if you buy 3 , then get at special price RM 12, System will Post Discount as RM3
Claim	as long as in statement, fee type is "Claim" in Lazada example damage claim, lost claim, shipping claim and many other not encountered yet claims

[top]

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.

[top]

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

[top]

How system handle for Payment Withdraw?

How do I get my payment?

How to Post In SQL Accounting?

[top]

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.

[top]

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)

[top]

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.

[top]