Lightspeed Inventory Reconciler

Reconcile inventory between Lightspeed Retail POS and your eCom platform (Lightspeed eCom or Ecwid). Identify price discrepancies, stock mismatches, and products missing from either system.

Quick Start

By default, this actor runs in Demo Mode with sample data so you can see how it works instantly.

To reconcile your actual inventory:

1. Set demoMode to false
2. Enter your Lightspeed Retail API credentials
3. Enter either Lightspeed eCom OR Ecwid credentials
4. Run the actor

IMPORTANT: Disabling Demo Mode for Real Data

Demo Mode defaults to ON. When you're ready to reconcile your actual inventory:

Step	Action
1	Set demoMode to false
2	Enter your Lightspeed Retail API Key, Secret, and Account ID
3	Enter either Lightspeed eCom OR Ecwid credentials

Demo mode uses sample data and will NOT access your real inventory.

Input Configuration

Demo Mode (Testing)

{
  "demoMode": true
}

Production Mode (Real Data)

{
  "demoMode": false,
  "retailApiKey": "your-lightspeed-retail-api-key",
  "retailApiSecret": "your-lightspeed-retail-api-secret",
  "retailAccountId": "your-account-id",
  "ecwidStoreId": "your-ecwid-store-id",
  "ecwidAccessToken": "your-ecwid-access-token",
  "matchBy": "sku",
  "includeUnmatched": true,
  "generateReport": true
}

Input Parameters

Parameter	Type	Required	Description
demoMode	boolean	No	Run with sample data (default: true). Set to false to use real data!
retailApiKey	string	Yes*	Lightspeed Retail API Key
retailApiSecret	string	Yes*	Lightspeed Retail API Secret
retailAccountId	string	Yes*	Your Lightspeed Retail Account ID
ecomApiKey	string	No	Lightspeed eCom API Key
ecomApiSecret	string	No	Lightspeed eCom API Secret
ecomCluster	string	No	eCom data center: "us" or "eu" (default: "us")
ecwidStoreId	string	No	Ecwid Store ID (alternative to eCom)
ecwidAccessToken	string	No	Ecwid Access Token
matchBy	string	No	Match by: "sku", "barcode", or "name" (default: "sku")
includeUnmatched	boolean	No	Include POS-only and eCom-only products (default: true)
generateReport	boolean	No	Generate summary report (default: true)

*Required when demoMode is false

Output

The actor outputs reconciliation results to the dataset with the following structure:

{
  "matchKey": "SKU-001",
  "matchedBy": "sku",
  "posId": "1001",
  "posSku": "SKU-001",
  "posName": "Widget Pro",
  "posPrice": 29.99,
  "posQuantity": 50,
  "ecomId": 2001,
  "ecomSku": "SKU-001",
  "ecomName": "Widget Pro",
  "ecomPrice": 29.99,
  "ecomQuantity": 50,
  "priceDifference": 0,
  "quantityDifference": 0,
  "status": "matched",
  "issues": []
}

Status Values

• matched - Product found in both systems with no discrepancies
• mismatch - Product found in both systems with price or quantity differences
• pos_only - Product exists only in POS
• ecom_only - Product exists only in eCom

Summary Report

When generateReport is true, a summary is saved to the key-value store under "REPORT":

{
  "summary": {
    "totalProducts": 100,
    "perfectlyMatched": 85,
    "withDiscrepancies": 10,
    "posOnlyProducts": 3,
    "ecomOnlyProducts": 2
  },
  "discrepancies": {
    "priceMismatches": 5,
    "stockMismatches": 8,
    "totalValueDifference": 125.50,
    "totalStockDifference": 42
  },
  "topIssues": [...]
}

Getting Your API Credentials

Lightspeed Retail (R-Series)

1. Log into Lightspeed Retail backoffice
2. Go to Settings > API Access
3. Create a new API client
4. Copy the API Key and Secret

Lightspeed eCom (E-Series)

1. Log into Lightspeed eCom admin
2. Go to Settings > API
3. Create API credentials
4. Note your cluster (US or EU)

Ecwid

1. Log into Ecwid admin
2. Go to Apps > My Apps
3. Create a private app or use an existing one
4. Copy the Store ID and Access Token

Use Cases

• Daily Inventory Sync Check - Identify products that fell out of sync
• Price Auditing - Find pricing discrepancies between POS and online
• Missing Product Detection - Discover products not listed online
• Stock Level Verification - Ensure accurate inventory counts across channels

Pricing

This actor uses pay-per-event pricing:

• Actor Start: $0.00005 per GB of memory
• Per Result: $0.00001 per dataset item
• Per Reconciliation: $0.015 per inventory item reconciled

FAQ

Q: Why do I get an error about missing credentials? A: Make sure demoMode is set to false or removed, then provide your Lightspeed Retail credentials plus either eCom or Ecwid credentials.

Q: Can I use both Lightspeed eCom and Ecwid? A: No, choose one eCom platform per run. If you provide both, Ecwid will be used.

Q: How often should I run this? A: Daily runs are recommended for active stores. Schedule it using Apify's scheduler.

Q: What if my products use different SKUs in POS vs eCom? A: Try matching by product name or barcode instead of SKU.

Support

For issues or questions, contact support@apify.com or open an issue on the actor's GitHub repository.