Linking Lightspeed Retail as a source
This source is currently in alpha. The interface and available tables may change.
Sync your Lightspeed Retail (X-Series) point-of-sale data – sales, customers, products, inventory, and more – into the PostHog data warehouse.
Prerequisites
- A Lightspeed Retail (X-Series) account on the Plus plan or above.
- Admin access to create a personal token in Lightspeed under Setup > Personal Tokens.
Adding a data source
- Go to the sources tab of the data pipeline section in PostHog.
- Click + New source and then click Link next to Lightspeed Retail.
- Enter your Lightspeed Retail credentials:
- Domain prefix – the subdomain of your store URL. For example, if your store is at
mystore.retail.lightspeed.app, entermystore. You can also paste the full URL and PostHog normalizes it automatically. - Personal token – create one in Lightspeed under Setup > Personal Tokens. This requires admin access and a Plus plan or above.
- Domain prefix – the subdomain of your store URL. For example, if your store is at
- Click Next.
- Select the tables you want to sync, set the sync method and frequency, then click Import.
Once the syncs are complete, you can start using Lightspeed Retail data in PostHog.
Available tables
| Table | Description | Sync method |
|---|---|---|
sales | Sales transactions | Incremental |
customers | Customer records | Incremental |
products | Product catalog | Incremental |
inventory | Inventory records | Incremental |
outlets | Store outlet locations | Incremental |
registers | Register devices | Incremental |
users | Staff user accounts | Incremental |
taxes | Tax configurations | Incremental |
Incremental tables sync only new or updated records on each run.
Sync mode
All tables support incremental sync using the version field. Every record in the Lightspeed X-Series API carries a monotonically increasing integer version. PostHog uses this as a cursor to fetch only records that changed since the last sync, so subsequent syncs are fast and efficient.
Configuration
| Option | Type | Required |
|---|---|---|
Domain prefix | text | Yes |
Personal token | password | Yes |
Supported tables
| Table | Description | Sync method | Incremental field | Primary key |
|---|---|---|---|---|
sales | A point-of-sale transaction (a register sale) in Lightspeed Retail. | Incremental, Full refresh | version | — |
customers | A customer record in Lightspeed Retail. | Incremental, Full refresh | version | — |
products | A product in the Lightspeed Retail catalog. | Incremental, Full refresh | version | — |
inventory | Per-outlet stock levels for a product in Lightspeed Retail. | Incremental, Full refresh | version | — |
outlets | A physical store location (outlet) in Lightspeed Retail. | Incremental, Full refresh | version | — |
registers | A point-of-sale register (till) at an outlet in Lightspeed Retail. | Incremental, Full refresh | version | — |
users | A staff user account in Lightspeed Retail. | Incremental, Full refresh | version | — |
taxes | A sales tax rate configured in Lightspeed Retail. | Incremental, Full refresh | version | — |