Quick Rule Summary · Updated November 2026

Clover POS exports a multi-sheet .xlsx workbook (Items, Categories, Modifier Groups, Tax Rates) where variants share an Item Group name and register items carry Price Type = Fixed, Variable, or Per Unit: flatten the Items sheet to UTF-8 CSV, derive shared Shopify handles from Item Group, quarantine Variable/Per Unit rows as draft, and map Product Code to Variant Barcode.

01 / INTERACTIVE CLOVER-TO-SHOPIFY CONVERTERGroup Clover Item Groups, guard Per Unit / Variable prices & map Product Codes.

Click any Clover POS inventory scenario below—or open the live field drawer to paste your own Clover row values—and download a clean UTF-8 Shopify CSV:

Source Rows Inside Clover Inventory → Items Sheet
Edit or test your own Clover Items sheet fields (live converter)

02 / THE 4 CLOVER INVENTORY TRAPSWhy Clover POS spreadsheets fail when uploaded directly into Shopify.

  1. Multi-tab .xlsx workbook instead of flat UTF-8 CSV: Clover exports separate tabs for Items, Categories, Modifier Groups, and Tax Rates, plus an internal Clover ID column. Shopify requires one flat UTF-8 .csv file with canonical product headers (see Shopify header check).
  2. Item Group vs. concatenated Name on variants: Clover names variant rows like “Artisan Olive Oil - 500ml” while storing the parent family inside Item Group. Derive Shopify’s shared URL handle and Row 1 Title from Item Group so variants stay grouped on one product page!
  3. Price Type = Variable & Per Unit (scale-weighed items): Deli, bulk tea/coffee, fabric, and gift-card buttons in Clover use Per Unit (e.g., $1.75 / oz) or Variable. Importing 1.75 without converting to pre-packed fixed weights lets online shoppers buy a whole pound for $1.75 (audit variant prices first)!
  4. Product Code vs. SKU & Tax Rates = DEFAULT: Clover stores scannable UPC/EAN barcodes inside Product Code (map to Shopify Variant Barcode) and text strings inside Tax Rates (convert non-exempt rows to Variant Taxable = TRUE).

03 / HEADER DICTIONARYClover POS Items sheet to canonical Shopify column reference.

Mapping Clover Inventory Items worksheet columns to canonical Shopify product CSV headers
Clover Items columnShopify CSV headerRequired transformation
Item Group (fallback Name)URL handle (Handle)Slugify Item Group when present so all size/flavor variants share one handle.
Item Group / NameTitleEmit parent title on Row 1 of each handle; leave blank on variant rows 2..N.
CategoriesType / TagsMap primary category to Type and comma-separated categories to Tags.
Variant suffix / OptionOption1 name & valueExtract variant label (e.g., 500ml); use Title / Default Title on single-SKU items.
SKU + Product CodeVariant SKU + Variant BarcodeFormat Product Code as plain text before saving CSV so leading zeroes survive!
Price + Price Type + CostVariant Price + Cost per itemKeep numeric decimal for Fixed items; quarantine Variable / Per Unit rows as draft.
QuantityVariant Inventory QtyMap whole-number stock count + set Variant Inventory Tracker = shopify.
Hidden (Yes / No)Status (draft / active)Map Hidden = Yes (or Non-revenue item = Yes) to Status = draft.

04 / SAFE MIGRATION STEPSMove your Clover POS inventory to Shopify & Shopify POS in 4 steps.

  1. Export Inventory & Format Barcodes as Text First: Export your workbook from Clover Dashboard → Inventory → Items → Export, format the Product Code column as Text so UPCs aren’t converted to scientific notation, and export the Items sheet as UTF-8 .csv.
  2. Group Item Group Variants & Isolate Per Unit / Variable Rows: Convert weighed bulk items into fixed online pack sizes (e.g., 8 oz Bag, 1 lb Bag) or hold them as draft.
  3. Preflight Locally in Row & Record: Drop your UTF-8 CSV into our browser-local workspace to verify column mappings, missing headers, and variant prices without uploading merchant data.
  4. Test Barcode Scanning & Tax Rules on 5 Items: Import a 5-item test batch into Shopify Admin and test physical barcode scans in Shopify POS before importing your full store.

Common questions.

How do I convert Clover’s multi-tab Excel export into a Shopify CSV?

Open the Clover .xlsx export, select the Items worksheet (which holds product names, SKUs, Product Codes, prices, and stock), ensure the Product Code barcode column is formatted as plain text rather than scientific notation, and export that single sheet as a UTF-8 .csv file before mapping headers to Shopify.

What happens to Clover Modifier Groups (like Milk Choice or Add-Ons) in Shopify?

Shopify Product CSVs support up to 3 inventory-tracked Variant Options (such as Size, Roast, Grind) rather than open-ended restaurant modifier trees. Convert retail size/flavor Item Groups into standard Shopify Options, and use a Shopify product-options app or POS tile modifiers for cafe add-ons.

How should I migrate Clover items with Price Type = Per Unit?

Standard Shopify online checkouts sell discrete integer quantities rather than fractional scale weights. Either convert Per Unit items into fixed retail package variants (for example, 250g and 500g pouches with fixed prices) or keep them set to Status = draft for in-person register review.

Where are my UPC barcodes stored in a Clover inventory export?

Clover stores scannable UPC and EAN barcodes in the Product Code column, while internal merchant codes sit in SKU. Map Product Code to Shopify Variant Barcode and SKU to Variant SKU.

05 / RETAIL POS MIGRATION HUBMigrating from another POS system to Shopify?

Ready to preflight your Clover-to-Shopify CSV?

Map Product Codes, audit Price Types, and check headers 100% locally in your browser.

Open CSV Preflight Workspace ↗

Verified November 2026 against Clover Dashboard Inventory (.xlsx / .csv) export columns and Shopify’s Product & POS CSV specification.

Shopify POS & store migration documentationShopify product CSV column referenceRow & Record Chrome Extension ↗