Skip to content

Shopify Import Tool V12

Client-side HTML app for editing LEMO product data and producing a Shopify-import CSV. Built for the JBS/LEMO store (lemo-test.myshopify.com).

Status: Active. Tags-column feature added 2026-07-11.

Location

/home/dini/Downloads/work/Shopify_import_tool_V12.html

  • Backup: Shopify_import_tool_V12.bak.html (same folder)
  • Prior versions in .../work/past/ (V9, V10, V11) and Shopify_spec_to_tag_tool_V12.html
  • Related: shopify-backup.py, img-size.py, shopity mcp id (holds the store's Shopify clientId/clientSecret)

What it does

  • Loads a product CSV, edits one product at a time (Prev/Next, jump-to-SKU, arrow keys).
  • Body HTML editor (Quill) + Data Sheet Link per product.
  • 8 metafields per product: Type, Pin Configuration, Series, Size, Termination, Gender, Keyway, Shell Colour — with datalist dropdowns managed in the Admin tab (persisted to localStorage).
  • Bulk-apply any metafield value to all products.
  • Tags (global): a single text box; its comma-separated value is written to the Tags column of every exported row. Persisted to localStorage (v12_global_tags).
  • Exports a Shopify-import CSV: Handle, Title, Body (HTML), Variant SKU, Tags, + the 8 metafield columns. UTF-8 BOM, font-family stripped from HTML.

Usage

  1. Open the HTML in a browser.
  2. Upload CSV → edit Body/link/metafields per product, or bulk-apply.
  3. Type tags in the Tags box (applies to all rows on export).
  4. Export CSV → import into Shopify.

Notes

  • Pure client-side; no network calls. Shopify credentials in shopity mcp id are for the MCP/API, not used by this HTML tool.
  • Tags are global (one value → all rows). Auto-deriving tags from metafields was considered and dropped.
  • Feature history logged in raw/2026-07-11.md.