Quick Rule Summary · Updated November 2026
Lightspeed R-Series appends color and size into each child row’s Description while keeping the parent title in Matrix Description: always derive Shopify’s shared URL handle from Matrix Description (or X-Series handle), prefer Custom SKU over 12-digit System ID, keep leading zeroes on UPC/EAN barcodes, and review negative Qty On Hand rows before import.
01 / INTERACTIVE LIGHTSPEED-TO-SHOPIFY CONVERTERGroup R-Series matrices, map X-Series options & guard leading-zero UPCs.
Click any Lightspeed Retail scenario below—or open the live field drawer to test your own matrix attributes and barcodes—and download a clean UTF-8 Shopify CSV:
Edit or test your own Lightspeed Matrix / UPC fields (live converter)
02 / THE 4 LIGHTSPEED RETAIL CSV TRAPSWhy specialty bike, apparel & boutique exports break raw Shopify imports.
- R-Series
Descriptionvs.Matrix Descriptionsplit: On matrix items, Lightspeed R-Series writes “Trail Shell Jacket Alpine M” inDescriptionand “Trail Shell Jacket” inMatrix Description. If you generate handles fromDescription, Shopify creates 8 standalone products instead of 1 jacket with 8 variants! System IDvs.Custom SKUvs.Manufact. SKU: Lightspeed assigns a 12-digit internalSystem IDto every row even when your barcode labels useCustom SKU. Populate Shopify’sVariant SKUfromCustom SKUfirst, falling back toManufact. SKUorSystem IDonly when blank.- Dropped leading zeroes on 12-digit
UPCbarcodes: Opening a Lightspeed export in Excel strips the leading0from North American UPC-A codes (turning045912008812into 11-digit45912008812), causing every handheld scanner in Shopify POS to fail on opening day! - Negative
Qty On Hand&Supply Priceleakage: Retail layaways and special orders often leaveQOH = -2or-4in Lightspeed (check headers & structure), and mappingDefault Cost/supply_priceinto the wrong price column exposes wholesale cost on your storefront (verify retail prices).
03 / HEADER DICTIONARYLightspeed R-Series & X-Series (Vend) to Shopify column reference.
| Lightspeed R-Series / X-Series | Shopify CSV header | Required transformation |
|---|---|---|
Matrix Description (R) / handle (X) | URL handle (Handle) | Slugify Matrix Description when non-empty (else Description) so all matrix variants share one handle. |
Matrix Description / name | Title | Emit on Row 1 of each handle; leave blank on child variant rows 2..N. |
Brand / brand_name | Vendor | Copy manufacturer or brand label cleanly. |
Category / product_category | Type | Map top or leaf retail category. |
Matrix Attribute Set + Attribute 1..3 | Option1..3 name & value | Split set name (Color/Size → Color, Size); use Title / Default Title for non-matrix items. |
Custom SKU (fallback System ID) | Variant SKU | Prefer human-readable Custom SKU; keep System ID in tags or metafields if needed for audit history. |
UPC / EAN | Variant Barcode | Keep exact 12/13-digit string with leading zeroes intact (never save through unformatted Excel!). |
Default Price / retail_price + Default Cost | Variant Price + Cost per item | Format plain 2-decimal retail price; map wholesale cost strictly to Cost per item. |
04 / SAFE MIGRATION STEPSMigrate Lightspeed Retail to Shopify & Shopify POS in 4 steps.
- Export Both Single & Matrix Items Together: In R-Series (Inventory → Item Search → Export) or X-Series (Catalog → Products → Export List), include active matrix attributes,
UPC,Default Cost, and per-shopQOH. - Group Matrix Children by
Matrix Description: Sort rows so all children of one matrix sit contiguously under a single sharedHandlewithTitleonly on the first row. - Preflight Barcodes, Prices & Negative QOH in Row & Record: Open the file inside our browser-local CSV workspace (zero server upload) to verify leading-zero UPCs and retail vs. cost columns before import.
- Scan-Test 5 Physical Barcodes in Shopify POS: Import a small 5-product pilot batch and scan physical hangtags with your barcode scanner before running your full catalog cutover.
Common questions.
How do I stop Lightspeed R-Series Matrix items from importing as separate products in Shopify?
Generate Shopify’s URL handle from Lightspeed’s Matrix Description column rather than the item-level Description column (which includes each variant’s color and size), split Matrix Attribute Set (e.g., Color/Size) into Option1 Name and Option2 Name, and leave Title blank on rows 2..N of each matrix.
Should I map Lightspeed System ID or Custom SKU to Shopify Variant SKU?
Map Custom SKU (or Manufact. SKU) whenever populated so your existing warehouse bins and printed hangtags stay recognizable. Fall back to Lightspeed’s 12-digit System ID only on rows where Custom SKU is empty.
How do I keep Excel from deleting the leading zero on Lightspeed UPC barcodes?
Never double-click a Lightspeed CSV to open and re-save it in Excel—Excel treats 045912008812 as an integer and strips the leading zero. Inspect, map, and export your UTF-8 CSV directly inside Row & Record’s browser workspace so every 12- and 13-digit barcode stays plain text.
What should I do with negative Qty On Hand (-2, -5) rows from Lightspeed?
Lightspeed records negative QOH when floor staff sell unreceived special orders or uncounted stock. Decide before cutover whether to zero out negative QOH to 0 for accurate physical shelf counts or preserve negative values while fulfilling open layaways.
05 / RETAIL POS & STORE MIGRATION HUBMoving from another POS or e-commerce platform?
Variation: Regular rows and quarantine Variable prices.
BigCommerce
BigCommerce → Shopify Converter
Resolve [ADD]/[FIXED] SKU price rules and strip [RB]/[CS] option tags.
Wholesale Catalog
Supplier & Vendor CSV Mapper
Map distributor price sheets, UPCs, and MSRP columns to Shopify headers.
Ready to preflight your Lightspeed-to-Shopify CSV?
Verify matrix handles, leading-zero UPC barcodes, and retail prices locally in your browser.
Verified November 2026 against Lightspeed Retail R-Series & X-Series (Vend) item export schemas and Shopify’s Product & POS CSV specification.
Shopify POS & store migration documentationShopify product CSV column referenceRow & Record Chrome Extension ↗