Medusa
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 Medusa to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Sync orders, products, customers and more from your self-hosted Medusa server into the PostHog Data warehouse.
Requires Medusa v2. Create a secret API key in your Medusa Admin dashboard under Settings > Secret API Keys, then enter it here with your server's URL. Publishable API keys only work with the Store API and will not work here.
Configuration
| Option | Type | Required |
|---|---|---|
Medusa server URL | text | Yes |
Secret API key | password | Yes |
Linking Medusa to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select Medusa
- 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 purchase placed in the store, with its items, totals, and fulfillment and payment status. | Incremental, Full refresh | updated_at | — |
DraftOrders | An order created manually in the admin that has not been completed by a customer. | Incremental, Full refresh | updated_at | — |
Products | A product in the store's catalog, with its options, images, and organization metadata. | Incremental, Full refresh | updated_at | — |
ProductVariants | A purchasable variant of a product, such as a specific size or color, with its own SKU and inventory settings. | Incremental, Full refresh | updated_at | — |
Customers | A customer of the store, registered or created from a guest checkout. | Incremental, Full refresh | updated_at | — |
CustomerGroups | A named group of customers, used to target promotions and price lists. | Incremental, Full refresh | updated_at | — |
Regions | A region the store sells in, defining its currency and countries. | Incremental, Full refresh | updated_at | — |
PriceLists | A set of prices that override default prices, for a sale or an override scoped to customer groups. | Full refresh | — | — |
Returns | A return of one or more items from an order. | Incremental, Full refresh | updated_at | — |