Shopee
Maintain Cloud Account
-
Select ''- > Maintain Cloud Account (One Time Setting)
-
Click on NEW
-
Enter Description
-
Select Platform
-
Click on Link Button
-
-
Login Shopee Credential
-
Click on Confirm Authorization
-
Press SAVE
- Once linking Successful, system will be returned status Linking Success Message.
Configure E Commerce Setting
-
GL -> Maintain Account
-
Create Shopee Payment Method
-
Create Shopee Voucher / Discount Account Under Sales Adjustment
-
Create Shipping and Transaction Fee under Expenses
- It is up to company want to create under which category. Some of the Company will create under Cost of Goods Sold.
-
-
Customer -> Maintain Customer
-
Stock -> Maintain Stock Group
Create Lazada Shipping / Transaction / Voucher / Discount Stock Group
-
Create Discount Stock Group
-
Create Voucher Stock Group
- Repeat same step to create for Shipping and Transaction Fees Stock Group
-
-
Stock -> Stock Item
-
Create Discount Stock Item
noteUnticked Stock Control
-
Create Voucher Item Code
- Repeat same step to create for Shipping and Transaction Fees Item Code
-
Account Tab
-
Click on ''- > Shopee
-
Click on Account Tab -> Double click on your account
-
Mapping Code
-
Expiry Date
- Is the linking expired with both parties given by Shopee platform for security policy, once expired must relink with Shopee account to fetch the order.
-
Product Tab
-
Step to download product list from Shopee
-
Navigate to “My Products” under “Product” category.
-
Click on “Batch Tools” and select “Mass Update”
-
Click on “Generate” to generate the product list.
-
Click on “Download” to get the generated product list.
You can choose to have Shopee SKU as SQL Item Code by import to SQL, may contact your service agent to assist on this product import.
-
-
Fetch product
-
Click on Product Tab -> Click on Fetch Button -> System will return the message when fetching done.
-
Verify Status: Exist in Stock Item are meaning SQL and Seller SKU are having the same Item Code.
If you decide to use the same item code as Seller Sku, ticked on select All records -> press on Post button for the first time so system will remember the settings.
-
Verified Status: Success when posting done
noteOnce you post successful, system will keep the Shop SKU in Stock Item as Alternative Item
-
You can still manually do the mapping on the item code (system will auto ticked the record you have change the item code), once done all, click on POST button.
-
Orders Tab
-
Click on Orders Tab
-
Status
tipEach order number will be posted once. You can delete the Invoice if you want to repost.
-
Fetch Order
-
Select Date Range -> Click on Refresh Order
Please be patient, system is on the way to fetch the order from Shopee
System will return the message when Fetching Done, Press OK.
-
-
Post Order
-
Click on the status you want to post the order, let us take an example on Completed Status -> Ticked all -> Click on Post
-
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.
-
Click on OK when done posting
-
-
Verify Status
-
Posted
- Earlier Order posted before, system will ignore.
-
Success
- Order had been successfully Posting.
-
Failed – Missing Dataset Property
- Normally repost will be fine.
-
Catastrophic Failure
- Normally repost will be fine (Can restart SQL if unable to post)
-
Failed – Missing Item Code - Is due to Shopee have inactive item code, user can manually map in orders.
-
Ticked on the order
-
Click on Item Code Drop Down, user can manually map the item code
-
Click on Post
-
-
-
Order Details
-
Double click on the order which you want to view the detail.
-
Order details will be displayed.
-
-
Sales Invoice
-
Example of Sales Invoice posted from Shopee | Orders.
-
Formula to calc Shipping Fees:
Escrow Amount - ((Discounted Price *Qty)- Other Fee - Discount - Voucher)
= RM 76.97 - (RM 87.60 - RM 5.63 - RM 0 - RM 5)
= RM 0
noteEscrow Amount will be Shopee release amount.
noteMissing no 10 Discount Item Code?
-
No, is due to Disc is 0, system will not be posting over.
Missing no 12 Shipping Item Code?
- No, is due to Shipping Fees is 0, system will not be posting over.
-
-
-
Sales Credit Note
-
Example of Sales Credit Note posted from Shopee | Orders.
-
Sales -> Invoice
-
Escrow = RM 10.25(Escrow Amt) + 23.50(Product) = RM 33.75
Product = RM 23.50
Others = RM 1.50
Shipping Fees calc on CN will be different when have return refund amount.
= RM 33.75 – (RM23.50 – RM 1.50 – RM 0 – RM 0)
= RM 11.75
-
Sales -> Credit Note
CN will be posting return product without Shipping and Transaction fees.
Customer -> Customer Credit Note
noteSystem will auto knockoff the Invoice.
Customer -> Customer Invoice
- Outstanding Amount will be Shopee Release Amount
-
-
Replace
-
Select the order that need to be replaced and click on Replace.
-
The order selected will be replaced.
-
-
Print
-
Click on Order No -> Print
-
Select Report -> Press OK
-
Sample Report
-
Payment Tab
-
Step to download statement from Shopee
-
Navigate to “My Income” under “Finance” category.
-
Switch to “Released” tab under “Income Details”
-
Click on “Export” button and finally “Download” the file.
-
-
Posting Payment
-
Select Payment Tab -> Select Account (Only if you have more than 1 store)
-
Click Load Excel
-
Select the statement download from Shopee
-
Check on Invoice No Column, make sure no blank Invoice No. It is advisable to post all the order first before do payment. Once done, click on Post
Blank Invoice No mean order yet do the posting.
-
Posting Payment, please be patient
-
Payment Posting done
-
Example of Customer Payment posted from Shopee | Payment
System will group same payment date as 1 payment.
Release Amount will be Shopee release amount.
Example: On 7/12/2020, total payment received RM 1424.71
Customer -> Customer Payment
System will auto do the knockoff.
-
-
Withdrawal
Shopee will release to Seller Wallet and will be released to your bank account through automated / manual withdrawal.
-
Manual withdrawal
-
Both way had to manually reverse out from Shopee Bank Account.
-
GL -> Cash Book Entry -> New OR
-
FAQ
-
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.
-
How to do if i want to split Lazada and Shopee Sales?
- Can set by project under Tools -> Maintain Project.
-
How to handle Serial Number?
-
Use To Ship Status Post to Quotation first, then manually transfer to Invoice, fill Invoice Doc No = Order No and Serial Number as well.
-
When post Payment in Payment Tab, system will auto edit Invoice and fill in Transaction Fees in order tally with Shopee Escrow Amount.
-
-
How system handle the situation when Shipping Fees charges Seller Paid Amount cause escrow amount in negative?
-
This scenario system will post to Sales CN and Customer Refund.
-
In Order Tab, system will Post to Sales CN and set Qty in Negative.
-
When Load in Income statement(.xls) files into Payment Tab, system will auto post to Customer Refund.
-
-
How to handle the order in Cancelled Status but earlier user in Shipped Status already post the Invoice?
-
It is due to seller sending few times to buyer. But nobody at home, so seller decided to cancel the order.
-
Solution: Shopee will not handle any action in Cancelled Status, in this case user can either cancelled the invoice or transfer to CN.
-
It is advise for user to post when order completed.
-