No edit summary |
|||
| Line 1: | Line 1: | ||
==Where & How do System Keep the Product Information?== | |||
: Default all the eCommerce Product Information will keep in the Maintain Item | Alt Tab | |||
{| class="wikitable" style="margin: 1em auto 1em auto;" | |||
|- | |||
! Platform !! Platform Field | |||
|- | |||
| Shopee || | |||
* SKU | |||
* Item ID | |||
|- | |||
| Lazada || | |||
* Seller SKU | |||
* Shop SKU | |||
|- | |||
| WooCommerce || SKU | |||
|} | |||
<div style="float: right;"> [[#top|[top]]]</div> | |||
==Why after Post & Refetch the Product & ItemCode become all duplicate?== | ==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... | :It due to user had Set Same SKU at the eCommerce Platform for Diff product... | ||
| Line 18: | Line 37: | ||
<div style="float: right;"> [[#top|[top]]]</div> | <div style="float: right;"> [[#top|[top]]]</div> | ||
==See also== | ==See also== | ||
* [https://wiki.sql.com.my/wiki/account4:Contents SQL Accounting] | * [https://wiki.sql.com.my/wiki/account4:Contents SQL Accounting] | ||
Revision as of 02:24, 27 July 2021
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.