Follow the Product Upload Plan to upload products, and if you’ve created a new SKU in JST, help update in Product Upload Plan and make a note to clarify upload as a new listing or upload to an existing listing.
- For new SKUs, we find SKU images on the Internet(If we can't find one, we can assign tasks to shoot). And for new listings, we'll arrange tasks to shoot.
The stores in Shopee and Lazada use the same standard(Increase efficiency).
✅Lazada Ratio 1:1
✅Shopee Ratio 1:1
❌Ratio 16:9(Can't use the max area of platform to display video whether full screen or not.)
❌Ratio 9:16(It doesn't look good in Lazada.)
Version 1️⃣:
Version 2️⃣
When customers don’t click into the product detail page, there’re limited characters shown to customers. So we have to put the most important key information first.
Search keywords in Lazada, Shopee and Google Image to see the proportion of similar products.(Over 50% is high relevance; lower than 50% is low relevance)
https://lazada.co.th
Ⅰ: Windows Images; Ⅱ: Variation Images; Ⅲ: Detail Images(Shopee normal stores don’t have but Shopeemall have)
Ⅰ. Collect from Internet(First Version Listing)
According to A. Listing Images Collection and B. Free Image Download Tool
Ⅱ. Output by Art Graphic(most of images we used from Art Graphic)
- Image size:1200*1200px to avoid “Main image has low resolution”
Lazmall Store(Wholesale Store):
Simple Aroi LogoSimple Aroi Cossover with Other Brand - Template.png
Wholesale IconIcon-The Cheapest Wholesale.png
Template 1 - with multi-SKUs:
Template 2 - single SKU:
First Version Listing:
(Shopee normal stores don’t have but Shopeemall have)
Same logic with 3.3 Window Images，but add more detail into it.
- First Version Listing(Sequence)
1 Beverage & Drinks
2 Food
- Final Version Listing(Sequence)
Exactly according to Long-image-1.png (outputted by Art Graphic) or Product List Idea - taisun-winterMelonTea(outputted by Sales) upload the images.
Mass update price check 4.1.1 Mass Update Price
- Shopee
Select different template to make a mass update, and generate the template
Update different columns according to need, for example, delete size for all products.
And upload the adjusted file.
- Lazada
Use “Attributes Tool” to edit products images or attribute in bulk
- Lazada
Check in Product Price Rule for different Shops: Simple Aroi Password.xlsx
*Clearance Product Price(With “Clearance” label)
Basic selling Price in all shops or all platform: cost price*110%(If the price is less than 100 THB and remove decimals)
Permission: The leader of EC and TK will have permission to decide to drop the selling price to minimum:cost price*80% (For example, using special voucher, add-on deal, campaign or FlashSale price etc.) If lower than this, please let Manager confirm the price.
- Lazada
Vlookup the adjusted price
Delete the #N/A rows(the products that there’s no need to update price to)
Copy and paste the adjusted price to “Special Price” column.
If not all products were updated, download the Failed Products to check reason.
Frequently Error:
1.THD_IC_ERR_F_IC_ABILITY_PG_003:This product is under campaign participation and cannot be edited during the campaign period. (Error Code:THD_IC_ERR_F_IC_ABILITY_PG_003)
Solution: Record the products and update price after the campaign period ends.
2.Quality Check, Failed by Lazada Policy(R_4933719): ราคาสินค้า ต่ำ/สูงกว่าที่กำหนด กรุณาตรวจสอบราคาสินค้าและแก้ไขราคาสินค้าให้ถูกต้อง/Product price does not seem to be correct. Please check and input the correct price. (Error
Solution: Change the fake price first, and update the adjusted price manually one by one.
You can check History here.
- Shopee
Vlookup the adjusted price.
Formula: =VLOOKUP(IF(F2<>"", F2,C2),'[Adjust Price - 20230323.xlsx]Update price'!$B:$C,2,0)
Copy and paste to “Discount price” column
Download and check the unsuccessful update.
Frequently Error:
1.The price of different models in one item is too large
Solution: Notify Supervisor or Manager to adjust the highest or lowest price to fix the rule.
2. Sold Out
Solution: add 1 stock and modify the price and remove the 1 stock.
For different SKU, turn this option on to set different weight & size for different SKUs according to JST. (If you find that there’s no weight & size of products, notify P. Wien to update as soon as possible)
Because Shopee can’t set different weight & size for different SKUs. So the rule will like this,
1. If the SKUs weight is the same, we set it up according to JST.(Like, “wanglaoji” listing)
2. If the SKUs weight is near, we set the biggest one.(For example, “happy-oil” listing, weight=1 kg)
3. If the SKUs weight is huge different, we set the average.(For example, “wangzai” listing, set weight=(125+245)/2=185g)
Don’t set size for products in Shopee
Because Tiktok is Free-Shipping platform, so If the SKUs weight and size are different, set the biggest one(If the biggest one is over 5kg, set 5kg)
You can check Shelf Life here
Lazmall needs to set a box SKU for all SKU
- According to sequence “*Invoice Available + *Wholesale Available + *Standard Box + *Features + *Specifications* + ‘Package Includes’ + ‘How to use/eat’ + Notes + Q&A”(*required fields) to list Shopee description.
- The format is like the following example.
- Using “*” to separate title
- Using “-” to tidy detail
- Enter a new line to separate different parts of content.
*Wholesale Available
- Short Description
List “*Invoice Available + *Wholesale available + *Features” in Short Description
*Wholesale available
- Need to add Bullet List to tidy Short Description
- Long Description
According to the images that Art Graphic provides to list Long description 3.5 Detail Image. After listing images, list “ *Specifications* + ‘Package Includes’ + ‘How to use/eat’ + Notes + Q&A”(*required fields) in Long Description.
- Font: Arial
- Font Size: 32
- Alignment: left
- Two lines keywords to avoid “No new paragraph in description”
If most of parcels were delivery by J&T, please submit this form to ban J&T to reduce products broken cases, and change to Shopee Express first(We have drop off point, so the warehouse team can scan in order to decrease the late Fulfillment rate).
Lazada Shipping Fee(Until 4 April 2023)
Lazada Shipping Fee(Effect 4 April 2023)
- Remember to open the “Standard Delivery Bulky” option in order to not miss a big order.
Be polite and patient in any cases, greeting first, whatever customers ask or complain. For example, “สวัสดีค่ะ ทางเรายินดีให้บริการ”
Shopee:
Tiktok:
LINE OA(Keep Greeting message):
Shopee:
Lazada:
TikTok:
LINE OA:
Expiration Date: Operation Guideline
If there’s some questions that you’re not sure, please ask your leader
-If there’s a customer who hasn't paid the orders for over 1 hour, set up and send a voucher to notify the customer to pay. If there’s a voucher available for customers, send it. If there’s not, set up a 5 Baht discount private voucher
- There’s a Follow Prize 5 Baht available for the customer, so send this first.
Record cases of Bad Review, Return Case, Claim Logistic, Red Order inPETUS After Service & Bad Review
We accept all order cancellation for any reason from customers before the parcel is sent out.
Check in JST for Red Order:
Check in all Shops for Special Red Order:
For Example:
Regardless what kind of solution you will use, add the solution note to “Offline Remark”
Plan A: Check returned/defective stock or stock on the way
Plan B: If there’s no stock on the way, if the supplier sends fast(can send in next 4-5 days), urgently ordering.
Plan C: If you can't use Plan A or Plan B, please check the related/similar SKU, if the larger size or premium one is less the selling price of oversold orders. Contact the customer to free upgrade. If the customer hasn’t replied the day before the order reaches the cancellation date, send first.
Plan D: Finally, if you can’t use 9.1, 9.2 or 9.3, contact the customers to cancel(Send Image to show how to cancel).
Follow in here SA After Service& Bad Review
Deal with cases offline:
Follow in PETUS After Service & Bad Review SA After Service & Red Order
Save some frequent answer to “Quick Reply” to quickly answer
JST:
Lazada:
Shopee:
Tiktok:
LINE OA:
- Yes, we can issue E-invoices to customers. Ask customers about info to issue an invoice. Fill the sheet and follow up in Simple Aroi Tax Invoice 2023 ใบกำกับภาษี Petus
- After we had opened a Tax invoice feature for Shopee Stores, customers can apply for an invoice by Shopee. Check related orders here, and remember to issue invoices. When the order has been delivered, we create a QR code in order to send an invoice to the customer's Chat.
If the customers want more discounts or other channels, we guide the customers to LINE Official Account using @SimpleAroi @Petus like this way.
- Chat customers here
- We will make note or label here.
Wrong way:
Right way:
You can click the customer name in Order Management to do customer service as well.
Follow here: SA After Service & Red Order
For products that are outside the terms and conditions of the carrier's warranty Which has the following criteria
1) The product is in a group that cannot be claimed according to the conditions of the shipping company.
- Dry and perishable foods such as candy, chocolate, etc.
- Documents such as vouchers, coupons, gift certificates, vouchers, coupons, gift certificates
- Liquid products such as water, oil, cream, serum, gel, battery
- Products that are easily broken such as glass, mirrors, pottery
- living things such as trees
2) Not within the warranty period
- General stores, Delivery Done status, no more than 7 days
- Official Shop / Managed Shop, Delivery Done status within 15 days
3) Packing
- Do not use cushioning devices (or foam or other cushioning objects) to pack the product.
** Case by case **
For the subject: Store inquiry received damaged goods
For products that are unsuccessfully delivered and returned to the store but found damaged / missing products. not received the product Merchants can fill out a request form to submit a claim consideration to Lazada. The shop chooses a topic about claiming.
petition form link https://xform.lazada.co.th/form/show.do?lang=th-TH
In the event that the customer receives the product but the product has a problem Recommend the store, notify the customer, press to request a refund through the system. The store can learn about returning information at link
Need to contact Support center for open problem ticket
Priority 1: Give priority to those who have already generated good data in Business Advisor but have not yet received five-star review with pictures
Priority 2: Then there are other new products (it already was tested by other teams or very optimistic about it), but there are no five-star reviews with pictures
Priority 3: Popular but low rating or affected by bad reviews
Priority 4: Potential product but low rating or affected by bad reviews
Priority 5: Others
Follow the Evaluation Plan
- Lazada Bonus Promotion needed to be confirmed
-Shopee
- Voucher Type
- Store New Buyer Voucher(normally 0 minimum-5 Baht Discount)
-Store Follower Voucher(normally 0 minimum-5 Baht Discount)
- Other Voucher like for Review, After Service etc.(Display Area: Offline)
*For example: After Service Order: 637805061874440
- Voucher Type
- Follow Prize
Normally we set up Free Gift Promotion in shops’ backend, but if there’s no free gift SKU in shops, we can use JST “Order gift rules”.
When you join the above campaigns, the system will lock the “campaign stock” you’ve submitted. You need to submit the minimum quantity for campaign stock, and record in Campaign Lock Stock for every store which you’re responsible for.
For printed red, it means that we don't join the Lock Stock campaigns anymore.
For adjusted to zero, it means that we just don't join temporarily
According to Campaign Lock Stock to set up Inventory Sync Rule
Tick on this for all rules
- Note: if there's a rule with no products. You need to add “box-paper”(0000000000) to be a placeholder. If you leave it blank, the rule will apply for all products.
- Lazada
- Shopee
The main point is that the system will auto update when the stock in the JST system changes, but if you only modify sync-rule, you have to manually update again. Two methods of manually update, check here
You can check the inventory-sync log here, and can use some value to filter records. (The important value: (RuleId):2627, Shop name, Quantity to be updated, updated status)
A. Manually update in “Inventory synchronization log”, select some records to update.(Common cases of use, only few of products needed updated)
B. Manually update in “Product Inventory”, select some records to update or update all products(Common cases of use, update all products for some shops).
Set virtual stock for products to pre-sale.
- If you have found that Violation, please report to EvanLo to do modification
- We have to make sure of excellent performance.
- Lazada
- Tiktok
Before doing any ads, please check your listing first. Make sure listing(images, title, description, variation etc) completed and in good condition, review/rating over 4.8(If too low, you can arrange evaluation). For doing ads, choose S(Super), A label products which are key products to promote first. In the future, some of N(new) products need to be tested as well.
Adjust Bid Price according to real CPC to make ROI around 10(Lowest ROI 8, highest ROI 15)
*Real CPC: 211.67(Expense)/58(Click)=3.64 Bhat/Click
Adjust Bid Price to 2.24(ROI now)/10(ROI Target)=0.224(ROI Ratio), 3.64(Real CPC now)*0.224(ROI Ratio)=0.81(Bid Price Target)(Set minimum 1 Baht)
Sort by ROI Descending(Adjust Bid Price for the keywords with ROI over 8)
Sort by Clicks Descending, and check ROI(Adjust Bid Price for the keywords with ROI less than 8)
Decrease Bid Price:
Delete Keyword:
*When increase Bid price, change Broad Match to Exact Match
Sort by ROI Descending(Adjust Bid Price for the keywords with ROI over 8)
Sort by Clicks Descending, and check ROI(Adjust Bid Price for the keywords with ROI less than 8)
Decrease Bid Price:
Delete Keyword:
Delete Ads:
Add all related keywords into ads and set up Bid price 2
For example,
Select time period is over 3 month, export data file to get more keywords for Shopee Ads
Filter out keywords,
Sort by ROI Descending, add keywords which are ROI over 8 to ads,
Sort by Clicks Descending, and check ROI, add keywords which are ROI over 8 to ads,
Add the high ROI keywords from other search ads for Shop Ads
Add keywords which have an ROI over 8 in old or new ads into the keyword summary sheet to share keywords with other teammates.
Before doing any ads, please check your listing first. Make sure listing images completed and in good condition, review/rating over 4.8. For doing ads, choose S(Super), A label products which are key products to promote first. In the future, some of N(new) products need to be tested as well.
Before doing any ads, please check your listing first. Make sure listing(images, title, description, variation etc) completed and in good condition, review/rating over 4.8(If too low, you can arrange evaluation).
Adjust Bid Price according to real CPC to make ROI around 10(Lowest ROI 8), if the ads can’t meet ROI over 8, close it.
*Real CPC: 21.57(Expense)/16(Click)=1.34 Bhat/Click, adjust Bid Price to 20.39(ROI now)/10(ROI Target)=2.039(ROI Ratio), 1.34(Real ROI now)*2.039(ROI Ratio)=2.73(Bid Price Target)
Additional Commission for specific products
Select one day or yesterday, if Expense reaches the max budget. It means that ads can’t run all day, vice versa.
Select one day or yesterday, if Impressions drop to zero at some time. It means that ads stop running at that time.
Add the high ROI keywords to listing title and and the keywords from related SKU to ads
①You can assign tasks to Art Graphic in Dingtalk and explain your idea to design all material.
②You can design by yourself.
Only set Voucher module(Select Automatically) and no need to set other module
Get 7 keywords from top 7 hot sale product and input here(1 keyword for 1 product)
Open “Display in mobile” option
Turn off option to not show 4-star and negative content reviews.
Using Purchase - Simple Aroi as a calculation template to , go “Alizwellmart Co., Ltd - Purchase-in receipt management” to check whether the production date of products which the warehouse team records is correct or not.
- Important Factors: “Sales volume in 7-15-30”, “Available Quantity”, “Label” and remember to “Display inventory equals 0”.
- If products are attached with a “Clearance” label, it means we don’t purchase it anymore.
- For the products which are out of stock for a long time, the “Sales volume in 7-15-30” data can’t reflect real sales volume, so go to “Sales theme report” to have a check of monthly sales volume of that product before the product is out of stock(go “Entry and exit records” to check out of stock date). And make a purchase quantity of monthly sales volume.
Open “Allow Gift” in LINE MyShop to increase exposure
For wholesale or offline sale, we guide the customers to LINE OA and offer the wholesale price according to this document.Wholesale Price Level
For Simple Aroi, remember to add fake stock for big wholesale orders which are the product quantity of the orders over the existing stock, otherwise the products in online platforms will be out of stock.
1.1 Confirm New Product with Evan Lo first(Assign someone to follow; Nink,Nine, Tunn take turns)
1.2 Notify Nink to add to purchase form
1.3 Create SKU in JST(Follow the Operation Guideline), set up selling price (responsible by sales)
1.4 Assign Shooting Task to Art Graphic
1.5 Plan product in Upload plan
2.2 Platform’s Data
After the Manager approves the Sample Request, please help open a bill in JST to send out samples(1 piece per kind of products) and make a label.
- If a creator requests many samples, send them in one order.
- More info to get address of creators
Make a note “(จาก Simple Aroi)”
Matters Warranting Attention Before/During/After LIVEs - EN Version
Matters Warranting Attention Before/During/After LIVEs - CN Version
TikTok Shop Global Seller Live Guideline (Public Version)
Global Seller Live Guideline (Public Version)
- Translate to your language
Deadline is 2 days after notification. If haven't updated on time, deduct 2 KPI point per SKU
1. If a product package has a barcode, use the barcode as product code.
2. If no existing barcode in product package, using “Automatic Generation” to generate product code.(Rule was set up already)
Rule: brandname-catagory-taste/feature-weight/size(-version)
For example: wangzai-milk-chocolate-145ml
- Download images from the Internet, and upload from computers.
With the “Follow-up” label, you can filter out the orders we need to follow up.
- Quick reply tools.
Because the “Special Order” will let the system not deduct stock.
- When change to abnormal status, don’t use or select “Special Order”
- When tagging a label for After Service, Art Graphic, Employee Order, influencer sample etc, don’t tag with “Special Order” label, and set the unit price with 0(Orders don't have income).
Check here
Username: AroiTeam@alizwellmart.com
Password: AroiTeam@alizwellmart.com
Everyone can check the virtual stock here. And if some products have virtual stock but without stock in the warehouse, it means the products will arrive soon. We can pre sale first, and no need to deactivate SKU or close stock in Platform.
Download JST print app and install
Username: 15521186112
Password: rong123456
*ask Evan Lo to verify.
https://www.jd.co.th
A.7. JD Global(select any province of China like screenshot shows; search by Chinese; Using Google Translate)
For example:
http://www.kingdomcares.com
https://www.migoosmart.com
Download Link:
https://chrome.google.com/webstore/detail/fatkun-batch-download-ima/nnjjahlikiabnchcpehcpkdeckfgnohf?hl=en
How to use:
- Go to Alizwellmart Co. Ltd. JST account
In Lazmall a SKU of a box is necessary, and you can set one or two more Combo products. That'll be enough, No need to set the combination of too few cans. For example, wangzai-milk, 48 cans a box, so we can set a box as a SKU in Lazmall, and there's 12 cans as a pack, we can set a pack as a SKU in Lazmall as well. Finally, there is only a pack and a box SKU in Lazmall. That's enough.
You can check how many cans a box is here.
If you want to take a look of what package it likes, you can find the location here and go look at warehouse
https://shopee.mobduos.com/workbench/home
Username: 15889220959
Password: simple2019
Operation Team
Method 2 in Product information:
Purchase Team
Warehouse Team
- Using for employee orders
- Using for After Service
-Shopee: Ask the customer the address to send out new products.
-Lazada: Find buyer address in Order Detail
Make a note “(จาก Simple Aroi)”
Tae’s Art Graphic Tasks: https://calendar.google.com/calendar/u/0?cid=ZmVhODg2YmE5ZDY3N2IxZTVhZWE4YTNkNzljODNlNTY5YzllMWM5MDcyZmZmYzdkMGMzNzc2ZWZjYzg5ZDk0MkBncm91cC5jYWxlbmRhci5nb29nbGUuY29t
https://c1.xiapizhijia.com/
Username: 15521186112
Password: evanlo122333
- Check whether orders were sent out normally in JST. (if there’s an order has stuck in “Abnormal” status, find out solution in JST System Usage Guideline first)
- Check whether they're red labels for orders in Platform Shops.(We take platform order status as real status)
“SLA Breached” in “To Pack”, “To Arrange Shipment” and “To Handover” 3 columns
“Risk of late shipment” or “Late Shipment” in “To Process”, “Processed” 2 columns.
If there's a 5-star review, do a reply to appreciate and invite him/her to follow our store. And if there’s a bad review, chat with the customers to fix it. For Lazada bad reviews, we have to call the customers if the customers didn't reply in Chat.
At least at 10 A.M., 2 P.M. and 6 P.M.(at least 3 times) checking Lazada and Shopee Chat, if you find a chat that is not replied, please reply immediately. You can use JST Message to check and reply as well
According to Evaluation Plan - Simple Aroi.xlsx to do evaluation orders in the afternoon of every working day. (When selecting pictures for evaluation order, please be careful of background. Pictures with same background can be used for a order. )
Checking and signing up campaigns that will end in 8 days for all platforms once a week.
Title: You must check the search volume of the keywords of the title in ads, and if the meaning of a word is more similar with the product than other keywords , put it ahead. If the two keywords meaning are both similar with the product, put the one with high search volume ahead.
Before uploading, you must check the following two directories to find out whether images of the products were already shot. If they were, use the images. Otherwise assign a shooting task to Art Graphic in Google Calendar.
https://drive.google.com/drive/folders/1kYJ6pNxkWkuEv-YPxoeMTlu9_ekbPvwzhttps://drive.google.com/drive/folders/1jAoHM4dAlGddOsmbe7gwiEH69HKBUI6E
Because Shopee doesn’t have an Auto Withdraw Balance feature, we need to withdraw balance from Shopee weekly.
After Art Graphic finish, they will right-click to make it to green color.
Art Graphic will add a material link here.
