๐ก In this article we will look at:
How to use the Size Calculator for aggregated & individual product analysis
The difference between the 2 curves: True rate of sale & Sales unit curve
The logic behind true rate of sale that analyses size performance only when it's in stock
Your intro to the Size Calculator
We're excited to announce the brand-new Size Calculator - a new and enhanced way to find your perfect size curve. ๐
What is the size calculator?
Style Arcadeโs size calculator is a quick access tool to help you calculate the ideal size curve for any product or group of products with 2 analysis methods: True Rate of Sale curve or Sales Units curve.
Based on the data available through the Size Calculator, you can then take actions and apply it to your future product ranges and know you will be in stock in more sizes for longer.
How can I access the size calculator?
The size calculator can be accessed from the products page via the โActionsโ button. Choose your filter selections so that you have the correct products you want to analyse and then click โsize calculator.โ
How should I use the size calculator?
There are 2 ways you can analyse sizes, at aggregated or individual level.
Aggregated Level Analysis (Recommended for category)
Filter your product selections
In your Products page, use the Launch Date & Add Filter options to narrow down your products selections for analysis
For example, you are looking to analyse size performances of Mini Dresses for Style Arcade brand that have launched in the last 12 weeks.
Category filter = Mini dresses
Brand filter = Style Arcade
Colour filter = black
Launch date filter = last 12 weeks (see FAQ #1 on why we recommend a launch filter instead of a date filter)
Go to the Size Calculator
Select the size calculator from the actions button.
Product Level Analysis
Simply click into the Product on your Products page, and select Size Calculator in the product detail page to start your analysis
How to use the Size Calculator
Choose your analysis method
Choose between True Rate of Sale curve or the Sales Units Curve for your analysis.
True Rate of Sale curve calculates how much a size can sell when it is in stock, whereas Sales Units curve shows the the week on week differences even if the size is out of stock. Read more about the differences between the two here.
Choose your size convention & time period
Click on Size and choose the size convention you'd like to analyse.
Apply a date range in True Rate of Sale curve
OR in Sales Unit curve choose from the number of weeks active
Calculate the ideal buy units
Enter your total buy quantity and Style Arcade will tell you how much to buy per size. You can edit the sizes individually if you decide to no longer range a size.
Copy or download the ideal size curve and voila!
How is the data calculated?
When using the size calculator Style Arcade needs to calculate:
What products to analyse?
How to group the size conventions?
What is the ideal size curve? (sold units %)
What is the bought curve? (bought units %)
1. What products to analyse?
Style Arcade analyses products that fit the following criteria:
Products that had sizes in stock for at least one week during the period analysed.
The example below shows a time filter applied to week 3 & 4. In this scenario we have no sales/stock data (identified by โ ) for size S in the time period but we can see size S has had activity in previous weeks. This product would be excluded from the analysis because Style Arcade cannot recommend a curve when it has no data for size S.
Product example | S | M | L | XL |
week 1 | โ | โ | โ | โ |
week 2 | โ | โ | โ | โ |
week 3 |
| โ | โ | โ |
week 4 |
| โ | โ | โ |
2. How to group the size conventions?
Size conventions are created based on a size having had sales and/or stock to indicate the size that existed for that product.
Sizes are grouped into conventions at the product level. See table below where the โ indicates there have been sales or stock over the time period being analysed.
| S | M | L | XL | Convention |
Product A | โ | โ | โ | โ | S-XL |
Product B | โ | โ | โ |
| S-L |
Product C |
| โ | โ | โ | M-XL |
Style Arcade uses the convention with the highest number of products as the default and shows this one first.
3. What is the True Rate of Sale %?
Style Arcade uses the true rate of sale to calculate the rate of sale when in stock %
Not sure how the true rate of sale is calculated? Check out our article here.
| True rate of sale before returns | True rate of sale before returns % |
S | 2 | 17% |
M | 5 | 42% |
L | 4 | 33% |
XL | 1 | 8% |
Total | 12 | 100% |
4. What is the Available To Sell %?
This is calculated using the metric called available to sell (ATS) at the size level converted to a percentage
| Available to sell (ATS) | Available to Sell % |
S | 20 | 17% |
M | 50 | 42% |
L | 40 | 33% |
XL | 10 | 8% |
Total | 120 | 100% |
FAQs
1. Why do we recommend applying the launch filter when you use the Size Calculator?
To analyse a group of more recent products so that you get the most up-to-date size curve. If you only apply a time filter it will include old products that have old sizes curves.
2. Why does the Size Calculator not analyse all products within the filter search
Not all products within the filter selection will fit the criteria to be analysed. The criteria to be analysed are:
a. Products that had each size in stock for at least one week during the period analysed. Style Arcade cannot include products if we have missing data for some sizes.
b. Products are grouped into size conventions so Style Arcade can accurately recommend a new size curve. Not all products in your search will have the same size convention.
3. How do I test the Size Calculator logic?
You can test the size calculator logic in Rollups by creating a report that looks like the one below. The true rate of sale before returns mix % will match the sold units % in the size calculator. Make sure you are analysing the correct products using the search bar.
4. Where can I can see a breakdown of data & metrics?
Click into 'show metrics' under the graph, you will then be able to see a breakdown of key metrics by size like this:
5. How can I edit my buy units by size?
Once you have the correct size curve you can click to โcalculate buy unitsโ and input the total buy units or edit sizes individually.
6. How can I swap between True rate of Sale or Sales units curve?
You can swap your curve by clicking on the titles of the curve.
7. What is the difference between Sales Units curve and the True Rate of Sale curve?
There are a few differences between the two:
a. The True Rate of Sale curve uses the enhanced logic from the metric called the true rate of sale to recommend an ideal size curve.
The true rate of sale calculates how much a size can sell only when the size is in stock. See the image below which shows an example of how the true rate of sale is calculated for one product across size level:
b. In the Size Calculator, you can now apply a date range when using True Rate of Sale. This is ideal for analysing core products or excluding promotional periods.
Note: if you select a time period where a product has no sales or stock data for one or more sizes, Style Arcade cannot recommend a curve and will therefore exclude this product.
8. Whatโs the difference between the Sales curve % and the Buy curve % in True Rate of Sale Curve?
The sales curve is the recommended curve using the true rate of sale enhanced logic.
The buy curve is reflective of the buy units by size. These will differ if you edit the buy units by size.
9. What happens when I apply a date range filter when using the Sales Units curve?
The date range filter on the top left will not impact the Sales Units curve. The curve will only change when you choose a different No. of weeks active.
This is because by filtering to certain dates, the data is chopped in relation to the filter. This can mean products are removed from the analysis because one or more sizes were out of stock for that period and therefore did not sell.
If Style Arcade does not have the data for one or more sizes for any given product it cannot recommend a curve because it will be wrong.
The table below shows an product example that would be excluded as a result of the time filter has been applied to week 3 & 4. In this scenario we have no sales/stock data for size S in the time period but we can see size S has had activity in previous weeks.
Product example | S | M | L | XL |
week 1 | โ | โ | โ | โ |
week 2 | โ | โ | โ | โ |
week 3 |
| โ | โ | โ |
week 4 |
| โ | โ | โ |
Got any questions? Feel free to reach out to our in-app chat for assistance! ๐คฉ