1. Overview

Uploaded lists and column mapping, edited cells, cleanup rules, words to remove, category rules, and saved jobs are saved in the browser. They stay in place after a refresh or a later visit. Uploaded files are read only inside this browser and are never sent anywhere.

Connected at rollout: direct upload to stores and marketplaces, downloading and editing product photos, reading Excel (xlsx) files directly, and shared server storage for multiple users.

2. Challenges

1. Every supplier writes things differently.

Ad tags like "[무료배송]" (free shipping) and "★베스트★" (best), 500ML vs. 500 ㎖, 12,900원 vs. ₩8500 (₩/원 = Korean won) — the same information arrives in different forms and can't be uploaded as is.

2. One product is scattered across several lines.

Products that differ only by color or size come in as separate lines. They need to be grouped as option products to sell on a single product page.

3. Mistakes show up only after listing.

A wrong barcode digit, a missing image, or an empty stock field shows up only after upload. They must be caught before export to avoid rejection.

3. Structure

Cleanup happens on the first screen; change a rule on the left and the table on the right re-cleans at once. Saved Jobs has its own address, so the back button and refresh keep you on the same screen.

4. Key Features

Before and After in One Table

Edited cells show the original value struck through next to the new, highlighted value. Removing ad tags · spacing · volume units (500ML → 500ml, 1000ml → 1L) · options as "name=value" · price as numbers only · matching sold-out status — all in one pass.

Grouping Identical Products

If cleaned names match (e.g. "호텔수건" / "호텔 수건", hotel towel), they are grouped under the first product code and exported as an option product. The group goes into the parent product code column of the upload CSV.

Checks — Barcodes, Empty Fields, Categories

Finds bad 13-digit barcode check digits, duplicate barcodes, empty barcode, image, price, or stock fields, and missing categories. Click a cell to fix it on the spot; fixing it re-runs the check.

Changing Rules — Words to Remove and Categories

Add or remove words to strip and category rules (search term → category), and the whole table is cleaned again. Rules are saved and reused for the next list.

• Store-Upload CSV and Saved JobsEverything except lines that need review downloads in upload format, including parent product code, options, sale status, and category. The problem list downloads separately, and jobs are saved with their rules and edited cells to reopen later.

6. QA

Results from running the pages on PC 1440 and mobile 390 screens and clicking through in the order a real user would. We also checked that data is still there after saving and refreshing. (2026-09-23)

The 18 function tests: load the 26-item sample list and clean it at once · clean ad tags, volume units, and spacing · options as "name=value", numeric prices, sold-out matching · group identical products as options · checks: barcode validation, duplicates, empty fields, missing category · turning a rule off and on (options) · adding a word to remove (3P) · adding a category rule (chair → outdoor) · editing a cell directly → re-check · rules and edited cells kept after refresh · download store-upload CSV (lines needing review excluded) · download problem list CSV · save job → saved job after refresh · upload CSV from a saved job · uploading your own CSV (EUC-KR, different column names) · picking columns manually when names differ · reopen a saved job → back button · delete a saved job

Speed and quality scores (out of 100; mobile measured three times on a slow connection, median shown)

Mobile: First Contentful Paint 1.7s · Largest Contentful Paint 2.0s · Layout Shift 0.01 · Blocking Time 0ms PC: First Contentful Paint 0.4s · Largest Contentful Paint 0.4s · Layout Shift 0.00 · Blocking Time 0ms

7. Result