A retail data migration

Rain POS→Lightspeed Retail R Series

Plan this direction around an existing online product, a serialized stock item and an open repair or rental commitment, then verify the receiving Lightspeed Retail R Series 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.

Review the Rain POS source

Rain product export with original identity and a separately agreed quantity/customer extract; identify website and service records.

Website links, rentals, repairs and customer commitments need a separate outcome from ordinary products. An existing-item update format does not prove a full inbound migration method.

Record the original identifiers, account/edition, included stores, extraction time and any source issues. Preserve an untouched original and verify that files or responses include the full intended record set.

Establish the Lightspeed Retail R Series receiving method

R Series item/matrix template plus a separately confirmed customer and stock workflow.

An item import can add quantities to existing stock. Confirm the specific operation before repeating a partial load.

Agree create, match and update behavior before preparing a full file. Keep a source-to-destination identity crosswalk rather than placing unrelated internal IDs into receiving fields.

Directional data plan

DatasetSource evidenceReceiving decision
Products and optionsFull parents, sellable combinations, original IDs and active/archive statusEquivalent grouping, approved fields and existing-record behavior
Identifiers and pricesFull barcode/SKU text, units and price contextAccepted identifiers, selling units and price rules
CustomersSource IDs, supported contacts and duplicate candidatesMatch rules, receiving method and created/updated/rejected records
Location stockStore/warehouse mapping, quantity state, unit and snapshotReceiving location and verified set/add behavior
History and obligationsRequired receipts, cards, credit, rewards and open orders listed separatelyApproved native method, transformation, archive or exclusion

Proposed representative test

Use an existing online product, a serialized stock item and an open repair or rental commitment. In Lightspeed Retail R Series, also check a matrix with multiple sizes, an existing item and location-specific quantities. These are illustrative planning cases. Write expected identities, grouping and quantities before the sample and compare returned records with the approved map.

Investigate rejected rows, changed identities and stock differences. If history or balances are included, test their side effects separately. Record trading changes after the inventory snapshot and approve exceptions before the launch milestone.

Official references

What the vendor documentation establishes

Rain product import/export: Product bulk updates do not establish the complete customer, serial, repair or rental migration workflow.

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.

Technical method still to establish

Obtain a complete Rain customer-record and quantity/serial export specification to supplement the existing product export. Map identities and stock to Lightspeed Retail R Series; a marketing email-list export is not a customer-record method.

Verify variant, serialized and repair/rental/service references where they are part of the proposed planning example.

Sqquid’s technical reviewer owns this follow-up with vendor support or implementation partners. Account credentials, an actual customer sample, named approvers and a previous completed project are engagement matters, not blanket publication requirements. The offer remains subject to feasibility while the technical planning content is completed.

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.

Routes offered subject to feasibility

We offer the currently listed migration routes subject to retailer-specific feasibility and an agreed scope. This includes POS migrations into Runit.

A project lead for your migration

Sqquid assigns a project lead to each migration. The lead is responsible for migration correctness and oversight of the entire migration dataset, including planning and managing data reversal when needed. The reversal method, dependencies and acceptance checks are agreed for your retailer’s systems and data.

Retailer-provided ERP and finance approvers

For ERP-related work, the retailer must provide an ERP approver and a finance approver. They approve the receiving requirements, included retail data, financial treatment and acceptance results within their responsibilities. Sqquid’s project lead coordinates the migration with them; full ERP implementation remains separate work.

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.

Corrections before launch

We correct errors in our own migration work at no additional charge before launch.

Refunds for errors caused by Sqquid

If a migration error occurs and Sqquid is at fault, we will refund the fees the retailer paid us.

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.