commodity_lookup
Look up commodities by SKU, HTS code, Shopify or BP product ID, or title substring. Filter by ERP or manual source; optionally include soft-deleted records.
Instructions
Look up commodities by any business identifier (sku, htsCode, shopifyProductId, bpProductId, or a title/parent-name substring). ERP-synced rows are source='erp'; app-created rows are source='manual' (no shopify_product_id). Soft-deleted rows (removed_at) are excluded unless includeRemoved. Attaches app-owned manual prices.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| env | No | Target database environment (wired now: dev). Defaults to dev (safe). | dev |
| sku | No | ||
| limit | No | ||
| title | No | Substring match on product_title / parent_name. | |
| source | No | ||
| htsCode | No | ||
| bpProductId | No | ||
| includeRemoved | No | ||
| shopifyProductId | No |