Naver & Coupang CSV Cleaner: Won, Dates, Price Changes
Pricing
$1.00 / 1,000 cleaned rows
Naver & Coupang CSV Cleaner: Won, Dates, Price Changes
Clean Korean won amounts and dates in Naver or Coupang tables, then compare prices over time. $0.001 per cleaned row. Failed rows are free.
Pricing
$1.00 / 1,000 cleaned rows
Rating
0.0
(0)
Developer
Marktrade
Maintained by CommunityActor stats
0
Bookmarked
2
Total users
1
Monthly active users
2 days ago
Last modified
Categories
Security
Limited permissionsShare
What it does
Sellers, analysts and agencies often export tables from Naver Smart Store or Coupang, or collect them with other tools. The prices and dates in those tables tend to be messy. Won amounts show up as text like 1,200만원 (12,000,000 won) or 1억2,300만원 (123,000,000 won). Dates come in mixed forms like 2024년 3월 5일 (March 5, 2024) and 24.3.5.
This Actor reads your table and returns one clean row for each input row. Prices become whole won numbers, and dates become 2024-03-05. It adds shipping to get a total, and it can show how each price changed since an earlier observation. It doesn't guess at ranges, formulas or other unclear text.
Example
Input, with keyColumns set to ["상품번호"] and compareByDateColumn set to "날짜". The headers mean product number, date, price and shipping fee.
| 상품번호 | 날짜 | 가격 | 배송비 |
|---|---|---|---|
| DEMO-01 | 2024년 3월 5일 | 38,900원 | 3000 |
| DEMO-01 | 2024.03.08 | 36,900원 | 3000 |
Output:
| rowNumber | dateIso | priceKrw | shippingKrw | totalKrw | previousTotalKrw | differenceKrw | differencePct |
|---|---|---|---|---|---|---|---|
| 2 | 2024-03-05 | 38900 | 3000 | 41900 | null | null | null |
| 3 | 2024-03-08 | 36900 | 3000 | 39900 | 41900 | -2000 | -4.7733 |
Price comparison
Rows are matched by product ID, option ID, seller or URL, never by name alone. There are two ways to compare:
previousDatasetId: compare with an earlier table.compareByDateColumn: compare each product's rows in date order inside one table.
Use one or the other. The earlier observation may be several days back, and the Actor doesn't fill in missing days. By default the comparison uses the total (price plus shipping). Set comparisonBasis to price to compare item price only. If a product is missing from the current table, it is not marked as sold out.
Input options
Give exactly one of the first three. CSV encodings: UTF-8, EUC-KR, CP949.
csvText: pasted CSV or TSV text.csvFile: key of an uploaded CSV, TSV or XLSX file.datasetId: an Apify dataset.keyColumns: columns that identify a product.compareByDateColumn: date column for one-table comparison.previousDatasetId: earlier dataset to compare with.comparisonBasis:total(default) orprice.maxRows: rows to process. Default 100, up to 10,000.
Output fields
Every input row produces one item, failed rows included.
rowNumber,productKey,dateIsopriceKrw,shippingKrw,totalKrwpreviousTotalKrw,differenceKrw,differencePct,changeTypestatusandissuesoriginal: your source columns and values.
Null means missing or unreadable. You can download CSV, Excel or JSON from the dataset.
Pricing
You pay per cleaned row: $0.001 per row, or $1 per 1,000 rows. Failed rows are free. There is no start fee. Reading a previous table is free.
Limits
- File size up to 10 MB, up to 10,000 rows.
- XLSX: active sheet only.
- It does not scrape websites or download URLs.
- If shipping is missing, it stays empty.
FAQ
Does it scrape Naver or Coupang? No. You supply the table.
What if shipping is missing?
Shipping stays empty, and total comparison is blocked. Set comparisonBasis to price to compare item price.
Can I compare by product name? No. Names alone are rejected. Use a product ID, option ID, seller or URL.
