How to Import Products from Lightspeed to a New POS

Why Stores Switch From Lightspeed

Lightspeed is a solid POS system, but it's not for everyone. Common reasons stores migrate:

• Cost — Lightspeed's pricing has increased significantly, especially for advanced features
• Complexity — More features than many specialty retailers need, leading to a cluttered interface
• Speed — Some stores find transaction processing slower than expected during peak hours
• Support — Response times can be long for non-enterprise customers

Whatever your reason, the biggest concern is always the same: how do I move my products without losing data or spending weeks on manual entry?

Step 1: Export Your Catalog From Lightspeed

Lightspeed Retail (R-Series) lets you export your product catalog as a CSV file.

1. Log into Lightspeed Retail back office
2. Navigate to Inventory > Items
3. Click Export (top right)
4. Select All Items and choose CSV format
5. Save the file

What you'll get: A CSV with columns including Item Name, Description, SKU, UPC/Barcode, Default Cost, Price, Category, Brand, Vendor, Tax, and Quantity on Hand.

If You Use Lightspeed X-Series (Vend)

The process is similar:

1. Go to Products in the dashboard
2. Click Export Products
3. Download the CSV

X-Series exports include variant data (size, color) in separate columns, which some migration tools handle better than others.

Step 2: Clean Your Data Before Importing

Before you import into a new system, spend 15 minutes cleaning up obvious issues:

Remove discontinued products. If you haven't sold it in 6 months and have zero stock, leave it behind. Migrating dead products just clutters your new system.

Check for duplicates. Lightspeed sometimes ends up with duplicate entries — same product with slightly different names. Search for your top brands and merge any duplicates in the CSV.

Verify barcodes. Scan a sample of 10-20 products to make sure barcodes in the CSV match what's physically on the shelf. Barcode mismatches are the #1 cause of post-migration headaches.

Standardize brand names. "RAZ" and "Raz" and "raz vape" should all be the same brand. Fix these in the CSV or let your new POS's normalization handle it.

Step 3: Choose Your Import Method

Option A: Smart Migration Wizard (Recommended)

Some modern POS systems include migration wizards that auto-detect Lightspeed's export format and map columns for you. This is the fastest path.

How it works:

1. Upload your Lightspeed CSV
2. The wizard detects the POS format (Lightspeed R-Series or X-Series)
3. Columns are automatically mapped: Item Name → Product Name, UPC → Barcode, etc.
4. Products are classified into categories using intelligent matching
5. Brand names are normalized for consistency
6. You review the mapping, make adjustments, and confirm

Time to complete: Under 30 minutes for a typical 1,000-3,000 product catalog.

Option B: Manual CSV Import

If your new POS has a generic CSV import (no Lightspeed-specific detection), you'll need to:

1. Open the CSV and rename column headers to match your new POS's expected format
2. Manually map categories (Lightspeed category names may not match)
3. Handle variants separately (Lightspeed exports variants as sub-rows)
4. Import and verify

Time to complete: 1-3 hours depending on catalog size and how different the column formats are.

Option C: Manual Entry

Don't do this. For a 2,000-product catalog at 2 minutes per product, you're looking at 66+ hours of work. That's over 8 full days of data entry, and the error rate will make your reporting unreliable for months.

Step 4: Handle Variants and Groups

Lightspeed stores variants (size, color, flavor) as matrix items. When you export, these come out as rows with a parent-child relationship indicated by an "Item Type" or "Matrix" column.

What to watch for:

• Each variant row should have its own barcode and price
• Stock quantities are per-variant, not per-parent
• Some migration tools flatten variants into separate products (bad) — look for one that preserves the grouping

Step 5: Verify After Import

After importing, run these checks:

1. Count check — Does the number of products in your new POS match what you exported?
2. Price spot check — Pick 20 random products and verify prices match
3. Barcode test — Scan 10 barcodes and confirm they pull up the correct product
4. Category review — Are products in the right categories?
5. Stock quantities — Do a physical count of 5-10 products and compare to the imported quantities

Common Migration Mistakes

Importing during business hours. Do your migration after close or before open. If you import while processing sales, stock counts will be wrong.

Skipping the barcode check. If barcodes don't match, your cashiers can't scan products and have to search manually — destroying checkout speed.

Not cleaning duplicates first. Duplicates in Lightspeed become duplicates in your new system. It's easier to fix them in the CSV before import than to merge them after.

Forgetting tax settings. Lightspeed may have tax configured differently than your new POS. Set up your tax rates in the new system before importing products, so tax assignments carry over correctly.

The Bottom Line

Migrating from Lightspeed doesn't have to be painful. Export your CSV, clean it up, use a migration wizard if available, and verify the results. The whole process should take under an hour for most stores — not weeks of manual data entry.