JD Product Price Comparison in Excel

Problem to Solve

In e-commerce price comparison, a spreadsheet may already contain product specs and JD links, but prices, cumulative ratings, and final prices still need to be checked page by page. Manual entry can mistake recent reviews for cumulative reviews, or mis-calculate unit prices when grams, milliliters, bottles, or packs differ. When one SKU maps to multiple rows, price and rating columns can also become inconsistent.

How It Works

The skill operates on an Excel workbook and focuses on writing JD page data back into the existing sheet.
- Reads the Excel file and extracts JD links or SKU IDs
- Visits item.jd.com/{SKU_ID}.html to collect cumulative ratings, list price, and final price
- Writes data into columns S, T, L, and M, then computes O = M - L
- When specs do not match, converts prices using different specs of the same SKU and avoids cross-SKU inference
- Prefers web_fetch for page HTML and falls back to browser capture or manual verification if needed
- Before saving, checks missing values, consistency of T for multiple rows of the same SKU, and uses openpyxl to reduce encoding issues

Boundaries

It fits batch processing of accessible JD products, especially self-operated or flagship-store items. It is not suitable for invalid links, inaccessible pages, unclear spec units, or prices that require manual confirmation. Keep prices to two decimal places, distinguish cumulative ratings from recent reviews, and keep cumulative ratings consistent across rows with the same SKU.