Beauty market researchers
Trend checks
Favorable to scraping
Build a spreadsheet from LIPSCOSME product pages, then compare visible ratings, review counts, prices, and review links across sunscreen, lip care, or skincare candidates.
E-commerce Marketplace$50Free
LIPSCOSME Product List Scraper
This LIPSCOSME Product List Scraper turns a curated set of LIPS/LIPSCOSME product URLs into a structured CSV export for cosmetics research. It loops through product pages, waits for the page title, extracts product name, rating, rating count, price, detail URL, and review URL, then appends each row to one local file.
Output
CSV file
Columns
8
Input
6 URL sample
Waits
Load + h1
Template
Free
At a glance
Export LIPSCOSME products from a controlled URL list
The bundled workflow is a best-effort equivalent of a product list scraper for LIPS/LIPSCOSME. Instead of relying on a fragile search-results DOM, it starts with concrete product URLs from a keyword preview, opens each page, creates a hidden structured row in the browser, and sends those attributes into Structured Export.
That makes the template practical for research teams that already have product candidates from LIPS rankings, Best Cosme pages, category pages, or manual search. Add the product URLs you care about, run the local desktop app workflow, and keep the resulting CSV under your own file system.
Export product lists to CSV
Capture keyword, source page label, product name, rating, rating count, price, detail URL, and review URL in fixed columns.
Loop through known product URLs
The Navigate block contains a multi-URL list, and Loop Continue advances one product page at a time until the list is complete.
Keep the workflow local
The browser session and CSV stay in your configured UScraper folder unless you add another upload or sync step.
Use it as a research handoff
Export LIPSCOSME products for beauty market research, content briefs, category tracking, or enrichment in Excel and Sheets.
Who uses it
Built for beauty product research teams
Ecommerce teams
Assortment review
Favorable to scraping
Turn curated product URLs into rows that can be matched against internal SKU catalogs, marketplace listings, supplier notes, or brand watchlists.
SEO and content teams
Buying guides
Favorable to scraping
Collect source URLs and product metadata before writing research around searches like best Tatcha products, Bobbi Brown products, or Charlotte Tilbury product comparisons.
How to use
Run the LIPSCOSME product scraper in five steps
1
Download and import
Download the free JSON template from this page, then import it into UScraper.
2
Review the starting URLs
The sample starts with six LIPSCOSME product URLs from a keyword result preview. Replace or expand them with the product pages you want to track.
3
Keep the waits in place
The workflow waits for page load and the product h1 before extraction, which helps avoid blank rows on slower pages.
4
Confirm the export path
Check the Structured Export file name, save folder, headers, and append mode before running a longer list.
5
Run and open the CSV
Start the workflow, let Loop Continue process each URL, then open lipcosme-product-list-scraper.csv in Excel, Sheets, or your BI tool.
Output preview
What the LIPSCOSME to CSV export includes
lipcosme-product-list-scraper.csvColumn
keyword
The search or research keyword associated with the product set.
Column
page
Source page label, such as the preview page used to seed the URL list.
Column
product_name
Brand plus product title when both are visible.
Column
rating
Visible LIPSCOSME score when detected.
Column
number_of_rating
Rating count, normalized without commas when detected.
Column
price
Visible yen price text from the product page.
Column
detail_url
Canonical product detail URL opened by the workflow.
Column
review_url
Review URL derived from the product detail URL.
Sample rows
2 of many
| keyword | page | product_name | rating | number_of_rating | price | detail_url | review_url |
|---|---|---|---|---|---|---|---|
| sunscreen | 1/15 | Example Brand UV Care Gel | 4.7 | 1842件 | 1980円(税込) | ||
| sunscreen | 1/15 | Sample Cosmetics Tone Up Milk | 4.4 | 736件 | 3080円 |
Headers included - sample values are illustrative - open in Excel, Sheets, or downstream analysis tools
| Column | Why it matters |
|---|---|
product_name | Gives analysts a stable label for category comparisons and product matching. |
rating and number_of_rating | Help separate high-scoring products from products with enough review depth to trust. |
price | Supports quick price-band filtering before deeper marketplace or brand research. |
detail_url and review_url | Preserve the source page and the review entry point for QA, citations, and follow-up extraction. |
Frequently asked questions
Public LIPSCOSME pages can still be governed by LIPS terms, robots rules, copyright, database rights, privacy law, and local regulations. Keep runs modest, respect access controls, avoid collecting personal data beyond your use case, and get legal review before publishing or reselling product datasets.
Before you scale
Limits and maintenance notes
Guardrails for reliable LIPSCOSME exports
Pacing
Do not hammer product pages
Large unattended URL lists can trigger throttling, CAPTCHA checks, partial rendering, or empty exports. Increase delays before increasing volume.
Selectors
Product layouts can change
LIPSCOSME may update product markup, rating text, review links, or price formatting. When rows go blank, verify the page in the browser before trusting the dataset.
Policy
Review terms before commercial reuse
Treat the CSV as research input. Check LIPSCOSME policies and applicable law before redistributing, selling, or combining scraped cosmetics data with other datasets.
Building a broader cosmetics dataset? Pair this workflow with the LIPSCOSME Product Scraper, Rakuten Product Scraper, and Yodobashi Keyword Searching Scraper. You can also browse the UScraper template library or install the local desktop app from the download page.
Get Started
Download and use this template instantly
$50Free
What's Included
- Template JSON file ready to import
- Pre-configured scraping nodes
- Works with UScraper desktop app
Open-source templates
UScraper templates are open source. Improve this workflow or contribute a new one to help the community grow.
Contribute on GitHubBrowse more templates in the library
All Templates