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:

Source Rows Inside Square Item Library Export (.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.

  1. Standalone items export Variation Name = Regular: Square treats every non-variant item as having one variation named Regular. If you map Variation Name straight to Option1 Value on 1-row products, Shopify displays a pointless “Size/Variation: Regular” selector on every single product page! Convert single-row Regular items to Option1 Name = Title and Option1 Value = Default Title.
  2. Open-ring register items export Price = Variable: Gift cards, alterations, cafe market-price items, or custom deposits often carry the literal string Variable in Square’s Price column. Shopify rejects non-numeric strings—or worse, spreadsheet cleanup formulas coerce Variable to 0.00 (see zero-dollar price preflight).
  3. 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, and Enabled Downtown (Y / N)—instead of fixed header names (see header mismatch check).
  4. Excel exports vs. CSV & missing image URLs in older exports: Square defaults to .xlsx unless you explicitly select CSV (.csv) during export, and Square’s standard Item Library CSV includes GTIN (barcode) and SKU but often omits hosted photo URLs unless exported from Square Online.

03 / HEADER DICTIONARYSquare Item Library CSV to canonical Shopify column reference.

Mapping Square POS Item Library columns to canonical Shopify product CSV headers
Square Item Library headerShopify CSV headerRequired transformation
Item Name (slugified)URL handle (Handle)Slugify lowercase a–z/0–9 hyphens; keep identical across all variations of one item.
Item NameTitlePopulate on Row 1 of each handle; leave blank on variation rows 2..N.
DescriptionBody (HTML) / DescriptionCopy plain text or wrap paragraphs cleanly.
Category / Reporting CategoryTypeMap retail department name (e.g., Roastery Beans, Knitwear).
Variation Name + Option Name 1 / Value 1Option1 name & valueUse Title / Default Title if single-row Regular; otherwise map Option Name 1 or Variation.
SKU + GTINSKU + BarcodeCopy verbatim as plain text (format GTIN as text in spreadsheets so 12–13 digit UPCs never turn into 8.12E+11!).
PriceVariant PriceStrip currency symbols ($, £); quarantine Variable rows as Status = draft until priced.
Current Quantity [Location] + Enabled [Location]Inventory quantity + StatusSum 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.

  1. 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.
  2. Collapse single Regular rows & quarantine Variable prices: Convert standalone Regular variations into Default Title and set any open-priced POS service rows to draft before import.
  3. 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.
  4. 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?

Ready to preflight your Square-to-Shopify CSV?

Map location stock columns, audit prices, and verify headers 100% locally in your browser.

Open CSV Preflight Workspace ↗

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 ↗