Lightspeed Inventory Reconciler

Automatically find discrepancies between your Lightspeed Retail POS and your online store (Lightspeed eCom or Ecwid). Identify price mismatches, stock differences, and products that exist in one system but not the other - saving hours of manual inventory auditing.

Why Use This Reconciler?

• Prevent Lost Sales: Find products showing "out of stock" online when they're actually available in your POS
• Stop Revenue Leakage: Catch pricing discrepancies before customers find arbitrage opportunities
• Save Hours of Manual Work: Automate the tedious process of comparing two inventory systems
• Improve Customer Experience: Ensure online customers see accurate stock levels
• Simplify Multi-Channel Retail: Keep POS and eCom in sync without manual spreadsheet comparisons

What Problems Does It Solve?

Problem	How We Solve It
Products priced differently online vs in-store	Flags exact price differences with dollar amounts
Stock counts don't match between systems	Shows quantity differences for each product
Products missing from online store	Lists POS-only products that should be online
Ghost products online (discontinued in POS)	Identifies eCom-only products to clean up
Hours spent on manual inventory audits	Automated reconciliation in minutes

Who Is This For?

• Retailers using Lightspeed Retail + Lightspeed eCom - Full API integration
• Retailers using Lightspeed Retail + Ecwid - Full API integration
• Multi-location businesses needing inventory consistency
• Operations managers responsible for inventory accuracy
• eCommerce teams managing online catalog sync

What You Get

Reconciliation Results

Each product comparison includes:

Field	Description
matchKey	The value used to match products (SKU, barcode, or name)
status	matched, mismatch, pos_only, or ecom_only
posPrice / ecomPrice	Prices in each system
priceDifference	Dollar amount of price discrepancy
posQuantity / ecomQuantity	Stock levels in each system
quantityDifference	Stock discrepancy count
issues	Human-readable list of problems

Summary Report

Automatically generated summary showing:

• Total products reconciled
• Count of perfectly matched products
• Products with discrepancies
• POS-only and eCom-only products
• Total value of price differences
• Top 10 issues to address

Use Cases

Daily Inventory Sync Check

{
  "retailApiKey": "your-pos-api-key",
  "retailApiSecret": "your-pos-secret",
  "retailAccountId": "your-account-id",
  "ecomApiKey": "your-ecom-key",
  "ecomApiSecret": "your-ecom-secret",
  "matchBy": "sku"
}

Ecwid Store Reconciliation

{
  "retailApiKey": "your-pos-api-key",
  "retailApiSecret": "your-pos-secret",
  "retailAccountId": "your-account-id",
  "ecwidStoreId": "your-ecwid-store-id",
  "ecwidAccessToken": "your-ecwid-token",
  "matchBy": "sku"
}

Find Missing Products Only

{
  "retailApiKey": "...",
  "retailApiSecret": "...",
  "retailAccountId": "...",
  "ecwidStoreId": "...",
  "ecwidAccessToken": "...",
  "includeUnmatched": true,
  "matchBy": "name"
}

Input Parameters

Required: Lightspeed Retail (POS) Credentials

Parameter	Description
retailApiKey	Your Lightspeed Retail API key
retailApiSecret	Your Lightspeed Retail API secret
retailAccountId	Your Lightspeed Retail account ID

Required: eCom Credentials (choose one)

Option A: Lightspeed eCom (E-Series)

Parameter	Description
ecomApiKey	Your Lightspeed eCom API key
ecomApiSecret	Your Lightspeed eCom API secret
ecomCluster	us or eu (default: us)

Option B: Ecwid (C-Series)

Parameter	Description
ecwidStoreId	Your Ecwid store ID
ecwidAccessToken	Your Ecwid access token

Options

Parameter	Type	Default	Description
matchBy	string	sku	How to match products: sku, barcode, or name
includeUnmatched	boolean	true	Include products only in one system
generateReport	boolean	true	Generate summary report

Output

Dataset

All reconciliation results stored in the default dataset:

• Download as JSON, CSV, or Excel from Apify Console
• API: https://api.apify.com/v2/datasets/{datasetId}/items

Key-Value Store

• REPORT - Summary statistics and top issues
• OUTPUT - Run status and totals

Sample Output

{
  "matchKey": "SKU-12345",
  "matchedBy": "sku",
  "status": "mismatch",
  "posId": "item-789",
  "posSku": "SKU-12345",
  "posName": "Blue Widget",
  "posPrice": 29.99,
  "posQuantity": 15,
  "ecomId": 456,
  "ecomSku": "SKU-12345",
  "ecomName": "Blue Widget",
  "ecomPrice": 34.99,
  "ecomQuantity": 8,
  "priceDifference": 5.00,
  "quantityDifference": -7,
  "issues": [
    "Price mismatch: POS $29.99 vs eCom $34.99",
    "Stock mismatch: POS 15 vs eCom 8"
  ]
}

Pricing

This actor uses pay-per-result pricing:

• $0.015 per inventory item reconciled
• Only charged for products processed
• No minimum or subscription required

How It Works

1. Connects to Lightspeed Retail API and fetches all products
2. Connects to eCom (Lightspeed or Ecwid) and fetches all products
3. Matches products by SKU, barcode, or name (your choice)
4. Compares prices and quantities for matched products
5. Identifies products existing in only one system
6. Generates detailed discrepancy report

Integrations

Schedule automatic reconciliation checks:

• Daily/Weekly schedules - Run via Apify scheduler
• Zapier - Trigger alerts for discrepancies
• Make (Integromat) - Automated workflow triggers
• Webhooks - Send results to any endpoint
• Google Sheets - Auto-export for team review

Support

Questions or issues? Open an issue or contact support.

---

Common Problems & Solutions

"Invalid API key" error

Cause: Your API key is wrong, expired, or doesn't have the right permissions. Fix: Double-check your API key. Make sure you copied it exactly without extra spaces.

"Rate limit exceeded" error

Cause: You've hit the API's rate limits. Fix: Wait a few minutes, then try again. Consider reducing the number of concurrent requests.

Empty or incomplete results

Cause: The target may have anti-scraping protection or the data doesn't exist. Fix:

• Check if the URL/search query is correct
• Try with different parameters
• Some sites may block automated access

Demo data showing instead of real results

Cause: demoMode is still set to true. Fix: Set demoMode: false and provide your API key(s).

---

Built by John Rippy | Actor Arsenal