This historical Shopee Thailand export covers the Shampoo Conditioner category. The surviving December 2024 archive contains 660 listing rows from 293 distinct shop IDs, each dated December 22, 2024. All rows identify Thailand and use THB. This is a dated marketplace snapshot, not a current product catalog or a complete measure of the Thai shampoo market.
What is in the shampoo and conditioner archive?
The reviewed source is the Shampoo Conditioner tab in Shopee Category Thailand Data – Dec 2024. It contains 23 fields and category code 11046066. The old individual spreadsheet was deleted. The form email now links to a ZIP containing a frozen Excel copy of this surviving tab, reviewed on October 4, 2026. The replacement is not established as an identical copy of the deleted file. All 660 rows and 23 source fields were retained, including blank cells and the original date representation.
| Field group | Available fields and interpretation |
|---|---|
| Identity and source |
category, name, url, imageUrl, itemId, shopId, shop_name, brand, flex_name, country and updateTime. Keep item and shop IDs as identifiers. |
| Prices |
currency, price, price_before_discount, discountPercent, price_min, price_max, price_min_before_discount and price_max_before_discount. Compare like-for-like sizes and packs before summarizing. |
| Sales and ratings |
sold, historySold, rating_count and rating. The archive does not define the reporting windows for the sales counters or provide order-level transactions. |
Checks before using the data
The full-tab check found 660 unique (shopId, itemId) pairs and no repeated pairs. That does not mean every row is a different product model: different sellers may list the same product. Brand is blank in 120 rows, and flex_name is blank in 367. Do not infer an absent brand from the shop name or interpret an undocumented shop label as a verified seller classification.
There are 264 rows where the minimum and maximum prices differ, and 158 rows have a zero price_before_discount. These values require interpretation before computing discounts or average prices. The first listing, for example, has price of 1 THB but a 1–187 THB price range. It would be misleading to treat that one value as the price of every variation or pack. The file does not include shipping, voucher eligibility or variant-level quantities as separate fields.
A practical way to use this snapshot
Worked listing check: the first source row identifies shop 151233742 and item 24557173995, with a Sunsilk title advertising a pack of two. Its stored price is 1 THB and reference price is 79 THB: (79 - 1) / 79 × 100 = 98.73%, which rounds to the stored discountPercent of 99. This arithmetic does not verify that a two-bottle pack could be purchased for 1 THB. The same row spans 1–187 THB, and the archive has no separate variant-quantity or voucher fields. Flag it for review before making a per-bottle comparison.
For a separate worked example using a stated bottle volume, see the November 2024 shampoo and conditioner archive. It shows how to calculate a conditional price per 100 ml after confirming the product and pack quantity. These monthly samples are not a matched price series; compare the same shop, item and variant before drawing a month-to-month conclusion.
For a historical assortment exercise, retain the original row values and source date, filter to comparable product types and pack sizes, and count the listings included in each comparison. Keep missing brand values separate from named brands. Reconcile a small sample against its recorded product URLs when possible, while noting that current listings may have changed or disappeared.
Do not label sold as December sales, convert a displayed sales counter into revenue by multiplying it by a current price, or infer growth from this single observation. The archive supplies no sampling-method notes, transaction ledger or independent verification of seller claims. The promotional artwork does not prove best-selling status or the completeness of brand coverage.
For a new collection with agreed fields, categories and dates, see our Shopee data collection service. The historical archive is separate from a custom collection request.
How to access the historical archive
- Fill Out the Form: Complete the required form with your details. This requests the historical archive described above. A custom collection requires a separate brief.
- Submit the Form: After filling, submit the form. Ensure all provided information is accurate to avoid delays.
- Check Your Email: Upon form submission, a link to download the data set will be sent to your email. This may take a few minutes.
- Download from Email: Open the email and use its December 2024 archive link to download the ZIP containing the reviewed Excel workbook.
- Open & Review Data: Extract the ZIP, then open the Excel workbook. Read the source note beside the data and retain the original values before making comparisons.
Leave a Reply