A retail data migration

Lightspeed Retail R Series→Clover

A move from Lightspeed Retail R Series to Clover needs an explicit map from a matrix with several sellable sizes, an existing item and separate store quantities to the receiving records.

Plan this migration Data migration: $2,999. Scope confirmed before booking.

The records we review.

Products & variants
Style, size, and color relationships
SKUs & barcodes
Identifiers used across your stores
Customers
Supported fields and matching decisions
Opening inventory
Quantities mapped to each location
Existing destination records
Products and customers already in your next system

The decisions
we make first.

  1. Source access

    Review representative exports and the available extraction method.

  2. History & balances

    Assess sales history, gift cards, loyalty, and credits separately.

  3. Test & acceptance

    Agree the records and checks before the final transfer.

Assess the Lightspeed Retail R Series source

R Series inventory and item/matrix identity, with separate customer and liability data.

R Series item imports can add stock to existing quantities. A repeated import must be reconciled rather than treated as a replacement snapshot.

Keep an untouched original and a record of account, edition, location coverage and extraction time. The customer must provide full authorized access and be able to access their own data. Do not infer missing fields or access from a vendor family name.

Plan the Clover destination

Merchant inventory/customer workflows with approved write permissions; confirm item variants, modifiers and stock separately.

A modifier and a stock-bearing variation are different relationships. Third-party rewards and payment configuration are separate from merchant catalog records.

Inspect existing receiving records before choosing create, match or update behavior. An exported internal ID should remain in a reconciliation crosswalk unless the receiving specification explicitly accepts it.

Directional data decisions

DatasetLightspeed Retail R Series evidence to preserveClover decision to confirm
Products and variantsComplete grouping, source IDs, sellable combinations and item statusEquivalent parent/variant structure and supported receiving fields
Identifiers and pricesSKUs, full barcode text, unit and price contextMatching rule, permitted identifier representation and accepted price behavior
Customer contactsSource identity and duplicate candidates, separately from liabilitiesReceiving method, existing-profile rules and rejected-row report
Location stockStore/warehouse map, quantity type, unit and snapshot timeCorrect receiving location and set-versus-add operation
History and commitmentsRequired receipts, gift cards, credit, loyalty and open orders listed individuallyNative receiving method, approved transformation, archive or exclusion for each

A representative test for this direction

Use a matrix with several sellable sizes, an existing item and separate store quantities. In the receiving Clover setup, also inspect an item with variants and modifiers plus a customer whose loyalty is held in an app. Use these illustrative examples to plan your project’s sample and agree expected results before a production import.

Write expected identities, grouping and quantities before the sample load. Compare returned records and rejected rows, approve exceptions and capture changes made after the stock snapshot. Test any proposed history or balance operations separately so an item import cannot silently create a second liability or stock movement.

What remains to be confirmed

  • Confirm customer/balance handling, matrix reconstruction and whether the selected stock operation adds or sets quantities for this route.
  • Confirm regional merchant permissions, variant/modifier mapping, contact writes and location stock operation; no general inbound connector is established.
  • Confirm exact source/destination editions, authorized full access, included fields, existing destination records and retailer approval of history/balance treatment.
  • No prior Sqquid test evidence was supplied. Run a representative controlled test and record actual results before executing this migration; do not publish an exercised-route or all-data guarantee.

This route remains under review. Request an assessment to establish the actual method and scope before booking. We confirm the exact edition pairing and supported fields before booking.

Official references

What the vendor documentation establishes

R Series item import/export: New records leave System ID blank; existing records retain it. Store Quantity on Hand adds inventory rather than replacing it. Matrices and serials have separate rules.

R Series customer import: Customer templates go through Retail Imports. Custom fields are excluded; confirm actual supported characters and columns before preparing data.

R Series customer data: Customer exports and identity management are distinct from item exports.

Additional vendor boundaries

Clover data model: Items, variations/modifiers, stock and customer records have separate relationships; an approved field map and operation for the complete direction is still required.

Clover app permissions: Application permissions govern accessible records; a general merchant account does not demonstrate the required dataset access.

Migration scope and responsibilities

The standard migration fee is $2,999 USD for the confirmed scope.

Tailored to your retailer data

Every migration is unique. Your catalog, barcodes, orders and customer information are unique and proprietary to your business. We work closely with you to tailor the migration for the best possible outcome, agree the included records and define acceptance checks for your stores.

Access to both systems

You must provide Sqquid full authorized access to both systems and be able to access your own data. Arrange access through an agreed secure process. Do not put passwords, API tokens, payment information or customer export files into the general enquiry form.

Source data quality

Sqquid is not responsible for migration errors caused by poor data supplied by the customer. Source issues, proposed corrections and exclusions need to be recorded before the transfer is accepted.

Earlier work and guarantee limits

Sqquid does not guarantee a migration that started before Sqquid was hired. Any guarantee is limited to the data migration work performed by Sqquid and expires on the launch date. Record the agreed launch milestone in the written scope; do not assume post-launch guarantee coverage.

Vendor charges and separate work

Vendor charges are passed to the customer in addition to the confirmed migration fee. POS implementation, hardware, payment setup, staff training and ongoing integrations have separate responsibilities and scope. A Sqquid software subscription is not required for the migration service.

Your systems. Your next chapter.

From the first export to the final review.

Tell us where your data is today, and where you’d like to go. We’ll help you understand the next step.

Check my migration Retail data migration for $2,999. Scope confirmed before booking.