taobao_export_inventory
Export purchase history into a visual inventory workbook with landed cost calculations, categorized products, and embedded images for easy review.
Instructions
Export the full purchase history as a visual inventory workbook with LANDED cost.
Pages the buyer order list back to since (the only path to full history), computes each
line's landed cost (product price + order shipping allocated by qty), categorizes products,
and writes Image · Date · Category · Seller · Product · Variant · Qty · Unit ¥ · Line ¥ ·
Ship ¥ · Landed/u ¥ · Landed ¥ + a By-Category sheet. embed_images=true embeds thumbnails
(open in Numbers/Excel); false writes =IMAGE() URLs for Google Sheets. refresh=false reuses
the last crawl cache (no Taobao traffic, no login needed) unless the cache doesn't reach
back to since. Food/instant-delivery orders are excluded by the list itself.
Example: {"since":"2025-01-01","embed_images":true}
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| since | No | 2025-01-01 | |
| refresh | No | ||
| filename | No | inventory_2025_2026.xlsx | |
| embed_images | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |