Picqer
Let AI connect your sources for you
Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.
Connect Picqer to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Enter your Picqer account name and API key to pull your Picqer warehouse and fulfilment data into the PostHog Data warehouse.
Create an API key under Settings → API keys in your Picqer account. The key inherits its permissions from its scope, so it can read the records that scope allows.
Configuration
| Option | Type | Required |
|---|---|---|
Account name | text | Yes |
API key | password | Yes |
Linking Picqer to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select Picqer
- Fill in the required configuration fields
- Click Next, select the tables you want to sync, and then press Import
Supported tables
| Table | Description | Sync method | Incremental field | Primary key |
|---|---|---|---|---|
orders | A sales order in Picqer, containing the products a customer ordered and their fulfilment state. | Full refresh | — | — |
picklists | A picklist — the set of products to pick from stock to fulfil one or more orders. | Full refresh | — | — |
purchaseorders | A purchase order sent to a supplier to replenish stock. | Incremental, Full refresh | updated | — |
receipts | A receipt recording the goods received against a purchase order. | Full refresh | — | — |
returns | A return (RMA) of products a customer sent back. | Incremental, Full refresh | updated_at | — |
products | A product in the Picqer catalog, including its stock and supplier information. | Full refresh | — | — |
customers | A customer record in Picqer. | Full refresh | — | — |
suppliers | A supplier products can be purchased from. | Full refresh | — | — |
warehouses | A warehouse where stock is held and orders are fulfilled. | Full refresh | — | — |
locations | A physical stock location within a warehouse. | Full refresh | — | — |
users | A user account in the Picqer application. | Full refresh | — | — |
vatgroups | A VAT (tax) group applied to products and orders. | Full refresh | — | — |
tags | A tag that can be attached to orders, customers, and other records. | Full refresh | — | — |