HOW TO CREATE YOUR OWN BEST SELLERS
HOW TO CREATE YOUR OWN BEST SELLERS
CREATE OWN BEST SELLERS LIST SYSTEM YOU NEED TO HAVE
• STEP 1: Download Open Office
2
CREATE OWN BEST SELLERS LIST HOW TO?
1. Go to Orders Manage Orders 2. Click on Completed 3. Click on Export Export All Orders 3
CREATE OWN BEST SELLERS LIST HOW TO?
4. Click on Download 5. Open the file in OpenOffice 6. Character set: Select Unicode (UTF-8) 7. Click OK 4
CREATE OWN BEST SELLERS LIST HOW TO?
8. Click on Data Create Current Selection OK
5
CREATE OWN BEST SELLERS LIST HOW TO?
9. Drag ‘Item Name’ & ‘Sum – Variation’ into Row and Data Fields respectively 10. To count the sum variation: Click on Options… Count OK 6
CREATE OWN BEST SELLERS LIST HOW TO?
11. Click on More Select ‘-new sheet-’ 12. Scroll down the list to look for your Best Seller •
Since Bea Jumpsuit & Bodycon Midi Dress sold the most quantity, sellers could start stocking up on this 2 products! 7
HOW TO READ SELLER SCORECARD
IDENTIFYING YOUR GAPS
KEY POINTS TO LOOK OUT FOR IN YOUR SELLER SCORECARD MARKDOWN GUIDELINES
Give higher markdowns for skus with broken sizes or shallow stock (less than 5 units/sku)
•
SKU Age
Within 30 days
Update your stock to 0 if you’re not selling them anymore!
9
Recommended markdown
Up to 10% (after 3 weeks)
30 - 60 days
15% - 20%
60 - 90 days
30% - 40%
90 - 120 days
50% - 65%
120 - >180 days
75% - 80%
Are these irrelevant products eg super old trends or season? Low quality? Images are not attractive? Markdown price is not attractive? Broken sizes?
IDENTIFYING YOUR GAPS
KEY POINTS TO LOOK OUT FOR IN YOUR SELLER SCORECARD REDUCE CUSTOMER DISSATISFACTION •
What’s the biggest return reason for you?
Reason
Recommended quick fix
Size too large/small
Ensure accurate size measurement Indicate “Size may run smaller/larger” For one size apparels, select the relevant international sizing instead of One Size
Quality
Adjust your price to reflect the quality of the product Add close-up images of the material
Color
Ensure images reflect product color accurately Add close-up images of the material
Defective item Wrong item sent Style
Check, double & triple check your product to the order list before sending it out! Ensure images reflect all angles of the product, especially if the product has additional detailing
Be sure to fix these hiccups before 12.12! 10
IDENTIFYING YOUR GAPS
KEY POINTS TO LOOK OUT FOR IN YOUR SELLER SCORECARD UNDERSTAND YOUR DEMAND • •
Increase your offerings for products that converts well If you have products with very high age and low CTR that cannot be sold, cut your losses , update stock to 0- there’s some products that just won’t sell no matter how low you mark it down!
Relatively high subcat contribution = less competition = potential higher yield. Stock up on these! CTR and CR is one of the highest – there is potential demand, you need more of these products!
Find out which product has a high CTR/CR to know what to stock up on. 11
IDENTIFYING YOUR GAPS
KEY POINTS TO LOOK OUT FOR IN YOUR SELLER SCORECARD
Look at the highest number of inventory you injected before, and upload more products than that!
DON’T GET BURIED • • •
Inject fresh inventory for 12.12! Slowly increase the number of new products in your offerings so customers have more to look forward to as time progresses Observe your pricing competitiveness and adjust accordingly for the new offerings
12
IDENTIFYING YOUR GAPS
KEY POINTS TO LOOK OUT FOR IN YOUR SELLER SCORECARD AIMING FOR EXCELLENCE
Which operational areas do you require a quick-fix? For the Key Events, you should aim to:
• Process all your orders within the first 24 hrs • Update all your stock on Seller Center at the end of every day (if you are also selling on other platforms/offline retail shop) • Check all packed items are correctly matched to the order, especially for color & size!
Area
Recommended quick fix
Processing order delay
Check your account regularly to ensure you don’t miss out on new orders. If you’re an Android mobile user, download the Seller Center App so you don’t miss out on immediate notification of your orders
Pickup delay
Highlight to ZALORA if your item doesn’t get picked up within the allocated time given to you.
Cancellation (seller)
Ensure you update your stock regularly if you also sell them on other platforms / offline retail space Check your stock before processing any orders
Cancellation (customer)
Cancellation by customer usually occurs when items take a longer time to be delivered than expected. So process your orders quickly!
13
SELLER SCORECARD: TOP 20
Know your Top 20 Best Selling Products based on the scorecard that you have requested.
14
CREATE OWN BEST SELLERS LIST SYSTEM YOU NEED TO HAVE
• STEP 1: Download Open Office
2
CREATE OWN BEST SELLERS LIST HOW TO?
1. Go to Orders Manage Orders 2. Click on Completed 3. Click on Export Export All Orders 3
CREATE OWN BEST SELLERS LIST HOW TO?
4. Click on Download 5. Open the file in OpenOffice 6. Character set: Select Unicode (UTF-8) 7. Click OK 4
CREATE OWN BEST SELLERS LIST HOW TO?
8. Click on Data Create Current Selection OK
5
CREATE OWN BEST SELLERS LIST HOW TO?
9. Drag ‘Item Name’ & ‘Sum – Variation’ into Row and Data Fields respectively 10. To count the sum variation: Click on Options… Count OK 6
CREATE OWN BEST SELLERS LIST HOW TO?
11. Click on More Select ‘-new sheet-’ 12. Scroll down the list to look for your Best Seller •
Since Bea Jumpsuit & Bodycon Midi Dress sold the most quantity, sellers could start stocking up on this 2 products! 7
HOW TO READ SELLER SCORECARD
IDENTIFYING YOUR GAPS
KEY POINTS TO LOOK OUT FOR IN YOUR SELLER SCORECARD MARKDOWN GUIDELINES
Give higher markdowns for skus with broken sizes or shallow stock (less than 5 units/sku)
•
SKU Age
Within 30 days
Update your stock to 0 if you’re not selling them anymore!
9
Recommended markdown
Up to 10% (after 3 weeks)
30 - 60 days
15% - 20%
60 - 90 days
30% - 40%
90 - 120 days
50% - 65%
120 - >180 days
75% - 80%
Are these irrelevant products eg super old trends or season? Low quality? Images are not attractive? Markdown price is not attractive? Broken sizes?
IDENTIFYING YOUR GAPS
KEY POINTS TO LOOK OUT FOR IN YOUR SELLER SCORECARD REDUCE CUSTOMER DISSATISFACTION •
What’s the biggest return reason for you?
Reason
Recommended quick fix
Size too large/small
Ensure accurate size measurement Indicate “Size may run smaller/larger” For one size apparels, select the relevant international sizing instead of One Size
Quality
Adjust your price to reflect the quality of the product Add close-up images of the material
Color
Ensure images reflect product color accurately Add close-up images of the material
Defective item Wrong item sent Style
Check, double & triple check your product to the order list before sending it out! Ensure images reflect all angles of the product, especially if the product has additional detailing
Be sure to fix these hiccups before 12.12! 10
IDENTIFYING YOUR GAPS
KEY POINTS TO LOOK OUT FOR IN YOUR SELLER SCORECARD UNDERSTAND YOUR DEMAND • •
Increase your offerings for products that converts well If you have products with very high age and low CTR that cannot be sold, cut your losses , update stock to 0- there’s some products that just won’t sell no matter how low you mark it down!
Relatively high subcat contribution = less competition = potential higher yield. Stock up on these! CTR and CR is one of the highest – there is potential demand, you need more of these products!
Find out which product has a high CTR/CR to know what to stock up on. 11
IDENTIFYING YOUR GAPS
KEY POINTS TO LOOK OUT FOR IN YOUR SELLER SCORECARD
Look at the highest number of inventory you injected before, and upload more products than that!
DON’T GET BURIED • • •
Inject fresh inventory for 12.12! Slowly increase the number of new products in your offerings so customers have more to look forward to as time progresses Observe your pricing competitiveness and adjust accordingly for the new offerings
12
IDENTIFYING YOUR GAPS
KEY POINTS TO LOOK OUT FOR IN YOUR SELLER SCORECARD AIMING FOR EXCELLENCE
Which operational areas do you require a quick-fix? For the Key Events, you should aim to:
• Process all your orders within the first 24 hrs • Update all your stock on Seller Center at the end of every day (if you are also selling on other platforms/offline retail shop) • Check all packed items are correctly matched to the order, especially for color & size!
Area
Recommended quick fix
Processing order delay
Check your account regularly to ensure you don’t miss out on new orders. If you’re an Android mobile user, download the Seller Center App so you don’t miss out on immediate notification of your orders
Pickup delay
Highlight to ZALORA if your item doesn’t get picked up within the allocated time given to you.
Cancellation (seller)
Ensure you update your stock regularly if you also sell them on other platforms / offline retail space Check your stock before processing any orders
Cancellation (customer)
Cancellation by customer usually occurs when items take a longer time to be delivered than expected. So process your orders quickly!
13
SELLER SCORECARD: TOP 20
Know your Top 20 Best Selling Products based on the scorecard that you have requested.
14
