01Run it
Replace the <placeholders> with your own values, or use the builder below.
p202 ltv products02What you get
Captured from the real binary, run against a demo store with 30 days of traffic. Switch tabs to see the same run as JSON, the shape scripts and agents parse.
$ p202 ltv products name created_at currency external_product_id price product_id sku updated_at ----------------------- ---------- -------- ------------------- --------- ---------- --------------- ---------- Gift Card $100 1792622022 USD sku:GFT-100 100 18 GFT-100 1790118931 Gift Card $50 1792622022 USD sku:GFT-50 50 17 GFT-50 1792622055 Gift Card $25 1792622022 USD sku:GFT-25 25 16 GFT-25 1792622056 Celebration Cake 1792622022 USD sku:BKY-CAKE 54 15 BKY-CAKE 1792622056 Pastry Box (6) 1792622022 USD sku:BKY-PASTRY-BOX 24 14 BKY-PASTRY-BOX 1792622056 Sourdough Loaf 1792622022 USD sku:BKY-SOURDOUGH 9 13 BKY-SOURDOUGH 1792622055 Team plan, monthly 1792622022 USD sku:PT-TEAM-MONTHLY 29 12 PT-TEAM-MONTHLY 1792531218 Team plan, annual 1792622022 USD sku:PT-TEAM-ANNUAL 588 11 PT-TEAM-ANNUAL 1791754494 Pro plan, annual 1792622022 USD sku:PT-PRO-ANNUAL 348 10 PT-PRO-ANNUAL 1790598577 Cable Tray 1792622022 USD sku:DSK-CABLE 29 9 DSK-CABLE 1792414880 Anti-fatigue Mat 1792622022 USD sku:DSK-MAT 59 8 DSK-MAT 1792607372 Electric Sit-Stand Desk 1792622022 USD sku:DSK-ELECTRIC 489 7 DSK-ELECTRIC 1792414880 Starter Box 1792622022 USD sku:COF-STARTER 58 6 COF-STARTER 1790208784 Monthly Coffee (2 bags) 1792622022 USD sku:COF-MONTHLY 32 5 COF-MONTHLY 1792017216 Relaxed Chino 1792622022 USD sku:SPR-CHINO 78 4 SPR-CHINO 1792622056 Canvas Tote 1792622022 USD sku:SPR-CANVAS-TOTE 34 3 SPR-CANVAS-TOTE 1792622056 Wrap Dress 1792622022 USD sku:SPR-WRAP-DRESS 96 2 SPR-WRAP-DRESS 1792622055 Linen Shirt 1792622022 USD sku:SPR-LINEN-SHIRT 68 1 SPR-LINEN-SHIRT 1792622056
$ p202 ltv products --json { "data": [ { "created_at": 1792622022, "currency": "USD", "external_product_id": "sku:GFT-100", "name": "Gift Card $100", "price": "100.00000", "product_id": 18, "sku": "GFT-100", "updated_at": 1790118931 }, { "created_at": 1792622022, "currency": "USD", "external_product_id": "sku:GFT-50", "name": "Gift Card $50", "price": "50.00000", "product_id": 17, "sku": "GFT-50", "updated_at": 1792622055 }, { "created_at": 1792622022, "currency": "USD", "external_product_id": "sku:GFT-25", "name": "Gift Card $25", "price": "25.00000", "product_id": 16, "sku": "GFT-25", "updated_at": 1792622056 }, { "created_at": 1792622022, "currency": "USD", "external_product_id": "sku:BKY-CAKE", "name": "Celebration Cake", "price": "54.00000", "product_id": 15, "sku": "BKY-CAKE", "updated_at": 1792622056 }, { "created_at": 1792622022, "currency": "USD", "external_product_id": "sku:BKY-PASTRY-BOX", "name": "Pastry Box (6)", "price": "24.00000", "product_id": 14, "sku": "BKY-PASTRY-BOX", "updated_at": 1792622056 }, { "created_at": 1792622022, "currency": "USD", "external_product_id": "sku:BKY-SOURDOUGH", "name": "Sourdough Loaf", "price": "9.00000", "product_id": 13, "sku": "BKY-SOURDOUGH", "updated_at": 1792622055 }, { "created_at": 1792622022, "currency": "USD", "external_product_id": "sku:PT-TEAM-MONTHLY", "name": "Team plan, monthly", "price": "29.00000", "product_id": 12, "sku": "PT-TEAM-MONTHLY", "updated_at": 1792531218 }, { "created_at": 1792622022, "currency": "USD", "external_product_id": "sku:PT-TEAM-ANNUAL", "name": "Team plan, annual", "price": "588.00000", "product_id": 11, "sku": "PT-TEAM-ANNUAL", "updated_at": 1791754494 }, { "created_at": 1792622022, "currency": "USD", "external_product_id": "sku:PT-PRO-ANNUAL", "name": "Pro plan, annual", "price": "348.00000", "product_id": 10, "sku": "PT-PRO-ANNUAL", "updated_at": 1790598577 }, { "created_at": 1792622022, "currency": "USD", "external_product_id": "sku:DSK-CABLE", "name": "Cable Tray", "price": "29.00000", "product_id": 9, "sku": "DSK-CABLE", "updated_at": 1792414880 }, { "created_at": 1792622022, "currency": "USD", "external_product_id": "sku:DSK-MAT", "name": "Anti-fatigue Mat", "price": "59.00000", "product_id": 8, "sku": "DSK-MAT", "updated_at": 1792607372 }, { "created_at": 1792622022, "currency": "USD", "external_product_id": "sku:DSK-ELECTRIC", "name": "Electric Sit-Stand Desk", "price": "489.00000", "product_id": 7, "sku": "DSK-ELECTRIC", "updated_at": 1792414880 }, { "created_at": 1792622022, "currency": "USD", "external_product_id": "sku:COF-STARTER", "name": "Starter Box", "price": "58.00000", "product_id": 6, "sku": "COF-STARTER", "updated_at": 1790208784 }, { "created_at": 1792622022, "currency": "USD", "external_product_id": "sku:COF-MONTHLY", "name": "Monthly Coffee (2 bags)", "price": "32.00000", "product_id": 5, "sku": "COF-MONTHLY", "updated_at": 1792017216 }, { "created_at": 1792622022, "currency": "USD", "external_product_id": "sku:SPR-CHINO", "name": "Relaxed Chino", "price": "78.00000", "product_id": 4, "sku": "SPR-CHINO", "updated_at": 1792622056 }, { "created_at": 1792622022, "currency": "USD", "external_product_id": "sku:SPR-CANVAS-TOTE", "name": "Canvas Tote", "price": "34.00000", "product_id": 3, "sku": "SPR-CANVAS-TOTE", "updated_at": 1792622056 }, { "created_at": 1792622022, "currency": "USD", "external_product_id": "sku:SPR-WRAP-DRESS", "name": "Wrap Dress", "price": "96.00000", "product_id": 2, "sku": "SPR-WRAP-DRESS", "updated_at": 1792622055 }, { "created_at": 1792622022, "currency": "USD", "external_product_id": "sku:SPR-LINEN-SHIRT", "name": "Linen Shirt", "price": "68.00000", "product_id": 1, "sku": "SPR-LINEN-SHIRT", "updated_at": 1792622056 } ] }
03Build your command
Pick values and the command line writes itself, quoted and ready to paste.
p202 ltv productsSet flags below; the command updates as you type.
04Flags
2 flags, plus the global flags every command takes.
| Flag | What it does |
|---|---|
| --limit, -lstring | Rows per page (max 500) |
| --offset, -ostring | Pagination offset |
05For agents
Running this from an agent
- Read the same facts as JSON:
p202 commands ltv products --json. - With
AI_AGENT,CLAUDECODEor another agent variable set, output is compact JSON and errors arrive on stderr as a JSON envelope with ahint. - Exit codes: 0 ok, 1 bad input, 2 auth, 3 network, 4 server error, 5 partial failure, 6 no Pro licence on the install.
{
"path": "p202 ltv products",
"use": "products",
"short": "The product catalog revenue line items and `ltv product upsert` write to, newest first",
"runnable": true,
"flags": [
{
"name": "limit",
"shorthand": "l",
"type": "string",
"default": "",
"usage": "Rows per page (max 500)",
"required": false
},
{
"name": "offset",
"shorthand": "o",
"type": "string",
"default": "",
"usage": "Pagination offset",
"required": false
}
]
}