Quick Rule Summary · Updated November 2026
Square POS Item Library exports assign Variation Name = Regular to every standalone product and allow text Price = Variable on open-ring items: before importing into Shopify, convert standalone Regular items to Option1 Name = Title / Default Title, quarantine Variable prices so nothing imports at $0.00, and map Enabled [Location] = Y/N to active / draft.
01 / INTERACTIVE SQUARE-TO-SHOPIFY CONVERTERStrip “Regular” dropdowns, catch “Variable” POS prices & merge location stock.
Click any Square POS catalog scenario below—or open the live field drawer to paste your own Square row values—and download a clean UTF-8 Shopify CSV:
Edit or test your own Square Item Library fields (live converter)
02 / THE 4 SQUARE POS CSV TRAPSWhy Square Item Library exports create messy Shopify storefronts if imported raw.
- Standalone items export
Variation Name = Regular: Square treats every non-variant item as having one variation namedRegular. If you mapVariation Namestraight toOption1 Valueon 1-row products, Shopify displays a pointless “Size/Variation: Regular” selector on every single product page! Convert single-rowRegularitems toOption1 Name = TitleandOption1 Value = Default Title. - Open-ring register items export
Price = Variable: Gift cards, alterations, cafe market-price items, or custom deposits often carry the literal stringVariablein Square’sPricecolumn. Shopify rejects non-numeric strings—or worse, spreadsheet cleanup formulas coerceVariableto0.00(see zero-dollar price preflight). - Location-suffixed inventory & visibility columns: Square names stock and status headers after each brick-and-mortar register location—such as
Current Quantity Downtown,Stock Alert Enabled Downtown, andEnabled Downtown(Y/N)—instead of fixed header names (see header mismatch check). - Excel exports vs. CSV & missing image URLs in older exports: Square defaults to
.xlsxunless you explicitly select CSV (.csv) during export, and Square’s standard Item Library CSV includesGTIN(barcode) andSKUbut often omits hosted photo URLs unless exported from Square Online.
03 / HEADER DICTIONARYSquare Item Library CSV to canonical Shopify column reference.
| Square Item Library header | Shopify CSV header | Required transformation |
|---|---|---|
Item Name (slugified) | URL handle (Handle) | Slugify lowercase a–z/0–9 hyphens; keep identical across all variations of one item. |
Item Name | Title | Populate on Row 1 of each handle; leave blank on variation rows 2..N. |
Description | Body (HTML) / Description | Copy plain text or wrap paragraphs cleanly. |
Category / Reporting Category | Type | Map retail department name (e.g., Roastery Beans, Knitwear). |
Variation Name + Option Name 1 / Value 1 | Option1 name & value | Use Title / Default Title if single-row Regular; otherwise map Option Name 1 or Variation. |
SKU + GTIN | SKU + Barcode | Copy verbatim as plain text (format GTIN as text in spreadsheets so 12–13 digit UPCs never turn into 8.12E+11!). |
Price | Variant Price | Strip currency symbols ($, £); quarantine Variable rows as Status = draft until priced. |
Current Quantity [Location] + Enabled [Location] | Inventory quantity + Status | Sum active retail locations (or map primary warehouse) + convert Y / N to active / draft. |
04 / SAFE MIGRATION STEPSMove your Square POS catalog to Shopify in 4 clean steps.
- Export as UTF-8 CSV (not Excel
.xlsx): In Square Dashboard, go to Items & orders → Items → Item library → Actions → Export Library and choose Comma-Separated Values (.csv) so UPC/GTIN barcodes aren’t mangled by Excel scientific notation. - Collapse single
Regularrows & quarantineVariableprices: Convert standaloneRegularvariations intoDefault Titleand set any open-priced POS service rows todraftbefore import. - Preflight your UTF-8 CSV in Row & Record: Open your file in our zero-upload browser workspace to map location-named headers (
Current Quantity [Store]) and audit every variant price locally. - Import a 5-item pilot batch into Shopify & Shopify POS: Verify barcode scanning, variant dropdowns, and inventory counts on 5 test items before importing the full retail catalog.
Common questions.
Why do all my imported Square products show a "Regular" dropdown on Shopify?
Square POS assigns Variation Name = Regular to every single-SKU product. If you map Variation Name directly to Option1 Value on standalone items, Shopify treats Regular as a visible storefront option. Replace single-row Regular values with Option1 Name = Title and Option1 Value = Default Title.
How do I handle Square items where Price says "Variable"?
Shopify online storefronts do not allow blank or open-ring Variable prices at checkout. Filter out Variable rows before import, or assign a numeric placeholder price with Status = draft so the item never goes live at $0.00.
Why did Excel turn my Square GTIN barcodes into 8.4012E+11?
Opening a CSV directly in Excel converts 12- and 13-digit UPC/EAN numbers into scientific notation and truncates trailing digits when re-saved. Export CSV directly from Square and inspect or map columns inside Row & Record’s browser workspace without opening in Excel.
Does Square’s Item Library CSV include product images?
Square’s standard POS Item Library CSV exports text metadata, SKUs, GTINs, prices, and location stock, while hosted image URLs are only included in certain Square Online / Weebly catalog exports.
05 / PLATFORM MIGRATION HUBConverting from another POS or storefront to Shopify?
[ADD]/[FIXED] SKU price rules and strip [RB]/[CS] option tags.
Wix Stores
Wix → Shopify CSV Converter
Fold variant surcharges into base prices and prefix bare ~mv2.jpg media slugs.
Wholesale / POS
Supplier & Distributor CSV Mapper
Map custom vendor price lists, barcodes, and inventory columns to Shopify headers.
Ready to preflight your Square-to-Shopify CSV?
Map location stock columns, audit prices, and verify headers 100% locally in your browser.
Verified November 2026 against Square Dashboard Item Library CSV export columns and Shopify’s Product & POS CSV specification.
Shopify store & POS migration documentationShopify product CSV column referenceRow & Record Chrome Extension ↗