Shilla Duty Free Ranking Scraper — Korea Duty-Free Top 100

Scrape The Shilla Duty Free (신라면세점) — one of Korea's two dominant duty-free retailers — and get its Top-100 best-seller ranking for 11 categories as clean JSON/CSV: rank, brand, product, USD list price, discount rate, discounted price, the mileage-applied price, a derived KRW figure, rating and review count.

Built on the same ranking API the shilladfs.com storefront itself calls, so the numbers match what a shopper sees on the board.

Why duty-free data? Duty-free boards are where Korean beauty, liquor and luxury demand from international shoppers shows first — and prices swing with promotions daily. Track the Top 100 every day and you see both the demand ranking and the real discounted price curve.

What you get

One row per ranked product:

Field	Meaning
ranking_category, rank	Which board, and the product's position (1–100)
name, brand, brand_en	Product and brand (Korean + English)
price_usd	List price before discounts
sale_price_usd, discount_rate	The discounted price shown on the card
mileage_price_usd, mileage_discount_rate	Price after Shilla's mileage (S.Point) discount — the lowest figure the site quotes without a login
price_krw, sale_price_krw, mileage_price_krw, usd_krw_rate	KRW figures derived from the exchange rate the storefront itself posts
rating, review_count	Review score (5-point scale) and count
has_coupon, is_sold_out, is_ad	Flags
product_category, url, image_url, scraped_at	Shilla's own category tag, product link, image, KST timestamp

What is deliberately NOT here

The final amount on Shilla's checkout (주문서) page also applies the shopper's own coupons and point balance. Those are per-account values behind a login — no fixed "final price" exists on the site. This actor collects public data only: no login, no cart, no member or passport data.

Categories

스킨케어(skincare) · 메이크업(makeup) · 향수/바디/헤어(fragrance) · 가방/신발/잡화(bags) · 시계/쥬얼리(watches) · 의류/아이웨어(fashion) · 디지털/리빙(digital) · 식품(food) · 스포츠/레저(sports) · 유아동(kids) · 남성관(men)

Leave categories empty to scrape all 11 boards (1,100 rows). The site's 전체 (overall) and 주류 (liquor) tabs are served differently and are not yet covered — they are excluded rather than approximated.

Input example

{
  "categories": ["스킨케어", "식품"],
  "rankingType": "topSelling",
  "maxItemsPerCategory": 100
}

rankingType also accepts wish (most wish-listed) and review (most reviewed).

Output example (real row)

{
  "source": "shilladfs",
  "ranking_category": "스킨케어",
  "rank": 1,
  "name": "Advanced Night Repair 어드밴스드 나이트 리페어 싱크로나이즈드 멀티-리커버리 콤플렉스 듀오 100ml",
  "brand": "에스티 로더",
  "brand_en": "ESTEE LAUDER",
  "price_usd": 358,
  "sale_price_usd": 193.32,
  "discount_rate": 46,
  "mileage_price_usd": 193.32,
  "price_krw": 505138,
  "usd_krw_rate": 1411,
  "rating": 4.82,
  "review_count": 279,
  "url": "https://www.shilladfs.com/estore/kr/ko/product/4721725"
}

Honest notes

• If a requested board returns nothing, the run warns loudly and records it in an EMPTY_CATEGORIES key-value record instead of exiting quietly.
• KRW columns are derived from the USD price using the rate the storefront posts in its own header that day — the same arithmetic the site uses for its 원 figures.
• No proxy needed for normal use; the board is served to ordinary IPs.