Marketplaces and merchants are sourced live from the ClickHouse merchant table. POD Details and Product Overview enrich responses by joining on jenda_merchant_id.
Competitor Configuration
SKU-keyed comp sets. Each focal SKU has its own competitive set of SKUs and/or individual product records.
SKU Overview lookup
Open SKU Overview, which aggregates data from every product associated with a jenda_sku_id across marketplaces.
Product Overview lookup
Open Product Overview for a product at a specific retailer. Enter a product_id from product_observation and the jenda_marketplace_id for the retailer (product_id is not unique across retailers).
POD Details lookup
Open POD Details for a Total Wine product at a specific merchant. Enter a product_id from product_observation and a jenda_merchant_id from the CH merchant table.