The Mystery Bags category only has products in the 50-100 and 100-250 price ranges, with a very small sample size, suggesting a limited product offering or potential data entry issue.
The Kids category has very few items outside the 0-25 price range. There are 20 items in the 25-50 range, all at exactly $27.00.
The price spread percentage for gift cards is extremely high compared to other categories, which is likely due to a data entry error.
The average price spread for women's products is 0, while the maximum price spread is 6.8. Given the large number of total products, this discrepancy warrants further investigation
The 'Mystery Bags' category has an exceptionally high percentage of high-resolution images (90%), which is significantly higher than all other categories. This is particularly surprising given the relatively small number of total products in this category.
Accessories have a significant presence in the 0-25 price range, accounting for a substantial portion of the total items in that range.
The Mens and Womens categories are heavily concentrated in the 25-50 price range, indicating that this is a crucial price point for these categories.
Almost all products in the Kids category are priced under $25, indicating a strategy to offer affordable options.
The Mystery Bags category only has products in the 50-100 and 100-250 price ranges, with a very small sample size, suggesting a limited product offering or potential data entry issue.
The Kids category has very few items outside the 0-25 price range. There are 20 items in the 25-50 range, all at exactly $27.00.
The analysis reveals a strong emphasis on affordable pricing across several categories, particularly Accessories and Kids. Mens and Womens categories are concentrated in the 25-50 range. Anomalies such as the limited price range for Mystery Bags and the lack of price variety for Kids items suggest potential areas for optimization or further investigation.
| Product Type | Variants | Min Price | Max Price | Avg Price | Price Distribution |
|---|---|---|---|---|---|
| Accessories | 664 | $3.20 | $159.00 | $28.98 | 0-25 (55.9%)100-250 (5.9%)25-50 (34.8%)50-100 (3.5%) |
| Climate+ | 49 | $1.00 | $144.00 | $19.78 | 0-25 (81.6%)100-250 (4.1%)25-50 (6.1%)50-100 (8.2%) |
| Gift Cards | 11 | $10.00 | $200.00 | $70.00 | 0-25 (18.2%)100-250 (27.3%)25-50 (27.3%)50-100 (27.3%) |
| Kids | 827 | $4.50 | $27.00 | $10.25 | 0-25 (97.6%)25-50 (2.4%) |
| Mens | 9784 | $10.00 | $348.00 | $37.98 | 0-25 (35.2%)100-250 (3.3%)25-50 (45.7%)250-500 (0.2%)50-100 (15.6%) |
| Mystery Bags | 25 | $65.00 | $130.00 | $94.00 | 100-250 (40.0%)50-100 (60.0%) |
| Unisex | 256 | $12.00 | $124.00 | $37.47 | 0-25 (65.6%)100-250 (13.7%)25-50 (12.5%)50-100 (8.2%) |
| Womens | 12866 | $7.50 | $328.00 | $42.00 | 0-25 (24.8%)100-250 (3.4%)25-50 (52.0%)250-500 (0.5%)50-100 (19.2%) |
The 'Womens' product type significantly outweighs all other categories in terms of total products, representing a substantial portion of the entire catalog.
Gift Cards exhibit a high number of unique prices relative to the number of products, suggesting a diverse range of denomination options.
The majority of product types have a very high percentage of products with a single price, indicating a limited range of pricing options within those categories.
The price spread percentage for gift cards is extremely high compared to other categories, which is likely due to a data entry error.
The average price spread for women's products is 0, while the maximum price spread is 6.8. Given the large number of total products, this discrepancy warrants further investigation
The analysis reveals a product catalog heavily skewed towards women's products. While most categories exhibit simplified pricing with a single price point, gift cards show a high degree of price variation. Data anomalies in gift card price spread and women's price spread suggests potential data quality issues needing review.
| Product Type | Products | Variants/Product | Unique Prices | Price Spread | Max Spread | Spread % | Single Price % |
|---|---|---|---|---|---|---|---|
| Gift Cards | 1 | 11.0 | 11.0 | $190.0 | $190.0 | 1900.0% | 0.0% |
| Accessories | 571 | 1.2 | 1.0 | $0.0 | $0.0 | 0.0% | 100.0% |
| Mystery Bags | 5 | 5.0 | 1.0 | $0.0 | $0.0 | 0.0% | 100.0% |
| Womens | 2,523 | 5.1 | 1.0 | $0.0 | $6.8 | 0.0% | 100.0% |
| Climate+ | 49 | 1.0 | 1.0 | $0.0 | $0.0 | 0.0% | 100.0% |
| Unisex | 39 | 6.6 | 1.0 | $0.0 | $0.0 | 0.0% | 100.0% |
| Kids | 167 | 5.0 | 1.0 | $0.0 | $0.0 | 0.0% | 100.0% |
| Mens | 1,904 | 5.1 | 1.0 | $0.0 | $8.8 | 0.0% | 99.9% |
The 'Womens' and 'Mens' categories constitute the vast majority of the product catalog, representing 2523 and 1903 products respectively. This suggests a strong focus on these demographics.
Despite having a relatively small number of products (39), the 'Unisex' category has the highest average number of images per product at 9.59. This could indicate a different marketing or presentation strategy for these items.
Except for 'Mystery Bags', the percentage of high-resolution images is generally quite low across all categories, with several categories having less than 5% high-resolution images. This could impact the perceived quality of product listings.
The 'Mystery Bags' category has an exceptionally high percentage of high-resolution images (90%), which is significantly higher than all other categories. This is particularly surprising given the relatively small number of total products in this category.
The 'Climate+' product type has a different aspect ratio (0.67) compared to all other product types (0.8).
The product catalog is heavily focused on 'Womens' and 'Mens' categories. 'Unisex' products receive the most visual attention in terms of the number of images. There is a low adoption rate of high-resolution images across most categories, with the exception of 'Mystery Bags', which appears to be an anomaly. The aspect ratio of 'Climate+' product images differs from the rest of the catalog. Improving image resolution and standardizing image presentation across all categories could enhance the overall customer experience.
| Product Type | Products | Avg Images | Min/Max | Aspect Ratio | High Res % |
|---|---|---|---|---|---|
| Unisex | 39 | 9.59 | 4/20 | 0.80 | 0.00% |
| Mystery Bags | 5 | 6.00 | 3/8 | 0.80 | 90.00% |
| Womens | 2523 | 4.55 | 1/14 | 0.80 | 1.54% |
| Mens | 1903 | 4.41 | 1/12 | 0.80 | 2.88% |
| Accessories | 571 | 3.49 | 1/12 | 0.80 | 4.36% |
| Kids | 167 | 3.30 | 1/7 | 0.80 | 1.27% |
| Climate+ | 49 | 1.82 | 1/2 | 0.67 | 7.87% |
| Gift Cards | 1 | 1.00 | 1/1 | 0.80 | 0.00% |
The 'Womens' product type has the highest total number of products in the catalog, significantly more than any other category.
A large percentage of products are discounted across several categories, suggesting an aggressive pricing strategy or potential overstocking.
The availability rate differs widely across product types, with some categories like 'Climate+' and 'Gift Cards' having 100% availability, while others like 'Kids' and 'Mystery Bags' have 0%.
The 'Kids' and 'Mystery Bags' product types have no available items, yet all items are marked as 'discounted'. This is contradictory.
The 'Climate+' product type has 100% availability and 0% discount rate, which is a stark contrast to most other categories.
The product catalog is heavily weighted towards Womens products and employs a high-discount strategy across many categories. Significant variations in availability exist across product types, with anomalies suggesting potential data quality issues or unusual business practices related to 'Kids', 'Mystery Bags', and 'Climate+' product lines. Further investigation into these anomalies is recommended.
| Product Type | Total | Available | In Stock % | Discounted | Discount % | Avg Discount |
|---|---|---|---|---|---|---|
| Womens | 12866.0 | 3179.0 | 24.7% | 11259.0 | 87.5% | 50.2% |
| Mens | 9784.0 | 1659.0 | 17.0% | 8499.0 | 86.9% | 52.5% |
| Kids | 827.0 | 0.0 | 0.0% | 827.0 | 100.0% | 68.5% |
| Accessories | 664.0 | 178.0 | 26.8% | 505.0 | 76.0% | 52.9% |
| Unisex | 256.0 | 9.0 | 3.5% | 256.0 | 100.0% | 57.8% |
| Climate+ | 49.0 | 49.0 | 100.0% | 0.0 | 0.0% | 0.0% |
| Mystery Bags | 25.0 | 0.0 | 0.0% | 25.0 | 100.0% | 56.7% |
| Gift Cards | 11.0 | 11.0 | 100.0% | 0.0 | 0.0% | 0.0% |
Example has a significantly larger product catalog compared to Climate+.
Climate+ focuses exclusively on its own branded category, while Example diversifies across multiple categories.
Example's top categories are Womens and Mens, indicating a strong focus on apparel.
Example's availability rate is significantly lower than Climate+.
Climate+ boasts a perfect 100% availability rate.
Example and Climate+ exhibit drastically different characteristics. Example has a large, diverse product catalog but suffers from a low availability rate, potentially indicating inventory management challenges. Climate+ has a small, focused product line with perfect availability, which could indicate a specialized niche or potential data anomalies. Further investigation into Example's inventory management and the validity of Climate+'s availability data is recommended.
| Vendor | Products | Categories | Avg Price | Availability | Top Categories |
|---|---|---|---|---|---|
| Example | 5,208 | 7 | $45.82 | 28.5% | Womens (2523)Mens (1904)Accessories (569) |
| Climate+ | 49 | 1 | $19.78 | 100.0% | Climate+ (49) |