Taobao Flash Sale Combination Plan Generator

Problem

For Taobao Flash Sale or local retail bundle operations, operators often need to turn one core item into a batch of sellable bundles quickly. The repetitive work includes choosing companion products, writing scenario-based selling points, setting prices, checking margins, and producing an Excel configuration sheet. Manual spreadsheets can become inconsistent, especially when the core item is an OTC medicine, symptom-based product, or functional consumer good. This skill turns the core item + companion item planning workflow into a repeatable template.

How It Works

• Trigger and input: provide a core item name, UPC, or code, then request bundle generation, companion pairing, or core item planning.
• Core item lookup: read product name, Ele.me UPC, delivery cost, and online price from the price sheet.
• Companion retrieval: map the core item’s indication, function, or use case to a candidate pool, such as fever pain relief, cough relief, stomach comfort, or anti-inflammatory support.
• Bundle design: keep the core item fixed, add one companion product, and generate the bundle ID, name, scenario, price, and margin estimate.
• Pricing and margin: calculate the bundle price from combined cost and a multiplier; margin must be above 0%, and bundles below 5% margin should be repriced. A 15% target margin is recommended.
• Excel output: generate a configuration sheet with bundle ID, name, scenario, cost, price, customer savings, margin, core and companion details, and status, with pending as the default status.
• Memory update: append the new batch to MEMORY.md and write to the daily work log so later bundles continue numbering and reuse known pairings.

Boundaries and Notes

This skill fits business operations where a price sheet, core item list, and companion candidate pool already exist. It is useful for medicines, OTC products, and functional consumer goods that can be paired by symptom or use case. It does not verify product qualifications, inventory, regional compliance, or platform campaign rules. Unknown companion codes must be filled in manually, and pricing, margin, and status should be reviewed before activation. If the core item is missing from the price sheet, add the base fields first before generating bundles.