Yoco
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 Yoco to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Import payments, orders, refunds, payouts, catalogue, and staff from your Yoco business.
Create an API key in the Yoco Developer Console. Give the key the scopes for the tables you want to sync: business/orders:read for payments, orders, refunds, and payment links, business/payouts:read for payouts and payout entries, business/catalogue:read for items, categories, brands, and modifier groups, business/locations:read for locations, business/staff:read for staff, and business/devices:read for card machines.
Configuration
| Option | Description |
|---|---|
API keyType: password Required: True | Create a key in the Yoco Developer Console. |
Linking Yoco to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select Yoco
- 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 |
|---|---|---|---|---|
payments | Money collected from a customer, in person on a card machine or online through checkout. | Incremental, Full refresh | updated_at, created_at | — |
orders | A sale recorded on the point of sale or online, with its line items, payments and refunds. | Incremental, Full refresh | updated_at, created_at | — |
refunds | Money returned to a customer against an earlier payment. | Incremental, Full refresh | updated_at, created_at | — |
payouts | A batch of settled transactions paid out to the business bank account. | Incremental, Full refresh | updated_at, created_at | — |
payout_entries | A single transaction that makes up a payout, mapping payments, refunds and fees to the batch they settled in. | Full refresh | — | — |
payment_links | A shareable link that lets a customer pay online without a checkout integration. | Incremental, Full refresh | updated_at, created_at | — |
items | A product or service in the business catalogue, with its variants, options and pricing. | Incremental, Full refresh | updated_at, created_at | — |
item_categories | A grouping of catalogue items, used to organise the point of sale. | Incremental, Full refresh | updated_at, created_at | — |
item_brands | A brand that catalogue products can be attributed to. | Incremental, Full refresh | updated_at, created_at | — |
modifier_groups | A set of modifiers, such as extras or sizes, that customers can pick from when ordering an item. | Incremental, Full refresh | created_at | — |
locations | A trading location of the business, used to attribute orders and catalogue availability. | Full refresh | — | — |
staff | A staff member of the business, used to attribute payments, orders and refunds. | Incremental, Full refresh | updated_at, created_at | — |
card_machines | A Yoco card machine registered to the business. | Incremental, Full refresh | updated_at, created_at | — |