Turned a frames-based wholesale portal into 14 ready-to-review Shopify products - 330 variants with pricing, images, and 190 auto-generated color swatches - in a single working day.
50 color swatches, generated by sampling supplier product photos - every circle is a real file named for its SKU. Riley Street’s wholesale supplier runs a legacy frames-based ASP portal with no export API, no sitemap, and product data locked inside per-item lookup tables. Adding a product line to the store meant manually re-keying every variant’s SKU, UPC, MSRP, and wholesale cost, hunting down images, and hand-building color swatches - slow enough that whole product lines simply never made it online.
An AI agent (Claude) drives the supplier portal in a real browser session: it searches the catalog tree, extracts the item tables (SKU, UPC, MSRP, wholesale cost, stock), and compiles everything into a CSV for human review before anything touches Shopify. Pricing rules per line - compare-at MSRP with a percentage discount, or straight MSRP - are applied in the build, never by hand.
Color swatches come from the supplier’s own product photos: the agent samples the dominant paint color per variant (with per-photo-style crops so barrel graphics don’t win), runs an automated name-vs-hue sanity check, renders a proof sheet for human eyeballs, then generates and uploads one PNG per SKU matching the theme’s swatch naming convention.
Products are created in draft via single atomic GraphQL calls - options, variants, pricing, cost, barcodes, per-variant images, and metafields in one mutation each - tagged for later audit, with a duplicate-check pass before anything is written.
One working day from “here are 12 product lines” to 14 fully-built draft products in Shopify: 330 variants with correct pricing and wholesale costs, 190 color swatches live in the theme’s picker, and a verification pass that caught 84 catalog items a naive scrape would have missed. The whole process - including the gotchas - is documented as a runbook, so the next import run starts from proven ground instead of zero.