Plans reorders for a small shop, cafe or online store from an items CSV and a settings JSON. Computes safety stock, reorder points and order-up-to levels, rounds orders to case packs and MOQs, caps perishables to shelf life, flags stockouts before delivery, dead stock, overstock and negative margins, groups orders by supplier and fits them into a cash budget. Offline stdlib Python planner.
---
name: small-shop-inventory-reorder-planner
description: Plans reorders for a small shop, cafe or online store from an items CSV and a settings JSON. Computes safety stock, reorder points and order-up-to levels, rounds orders to case packs and MOQs, caps perishables to shelf life, flags stockouts before delivery, dead stock, overstock and negative margins, groups orders by supplier and fits them into a cash budget. Offline stdlib Python planner.
---
# Small Shop Inventory Reorder Planner
You help owners of small shops, cafes, market stalls and online stores decide what to order this week and how much. Running out of a best seller loses sales and regulars; over-ordering ties up cash and, for food, ends up in the bin. You take a simple items sheet and a few settings and produce a clear order list per supplier with the reasoning behind each number.
You do not place orders, contact suppliers or change the user's POS or accounting data. Numbers are planning estimates based on the sales averages the user provides.
## Files in this skill
- `scripts/plan_reorders.py` - reads `items.csv` and `settings.json`; computes safety stock, reorder point (ROP), order-up-to level and suggested order quantity; flags RP01-RP10 (stockout before delivery, open orders too small, at reorder point, MOQ overstock, perishable cap and waste risk, dead stock, overstock, price not above cost, assumed demand variability, cash budget deferrals); groups by supplier and checks supplier minimums (Python 3.8+ standard library only)
- `references/reorder-math.md` - the formulas in plain words, service levels and how to get the inputs from a POS export
- `references/practical-ordering.md` - perishables, MOQs, case packs, cash budgets, dead stock and supplier minimums
- `templates/order-plan.md` - the weekly order note you hand back
- `examples/items.csv` - eleven items for a fictional cafe and pantry, with several traps
- `examples/settings.json` - service level, review period, cash budget and supplier minimums
## Workflow
### 1. Collect the data
Ask for one row per item: `sku`, `name`, `supplier`, `on_hand`, `on_order`, `avg_daily_sales`, `sd_daily_sales` (optional), `lead_time_days`, `moq`, `case_pack`, `unit_cost`, `unit_price`, `shelf_life_days` (blank if not perishable). Help the user get average daily sales from the last 4-8 weeks of POS data (units sold divided by days open). Ask for the review rhythm (how often they order), a service level (0.90-0.98) and this week's cash budget.
### 2. Run the planner
```
python3 scripts/plan_reorders.py examples/items.csv examples/settings.json
python3 scripts/plan_reorders.py items.csv settings.json --json
python3 scripts/plan_reorders.py --self-test
```
Exit 0 = no high findings, 1 = at least one item will run out before an order can arrive, 2 = bad input. Without a shell, apply the formulas in `references/reorder-math.md` row by row.
### 3. Read the result
- High: RP01 runs out before a new order can arrive (order today, consider a faster supplier or a substitute), RP02 open orders are too small to cover the lead time, RP10 when a stockout-risk item does not fit the budget.
- Medium: RP03 at or below the reorder point (order now), RP04 MOQ forces more than two months of stock, RP05 perishable capped to shelf life or waste risk, RP08 price not above cost, RP10 deferred for budget.
- Low: RP06 dead stock, RP07 overstock beyond `overstock_days`, RP09 demand variability assumed.
### 4. Deliver
Fill `templates/order-plan.md`: orders grouped by supplier with totals, items deferred for cash, perishables with a suggested ordering rhythm, and three actions for slow or dead stock. Keep the language simple; owners often read this on a phone between customers.
## Example result
On the sample cafe (95% service level, weekly review, $420 budget), house coffee beans will run out in about 4 days against a 5-day lead time (high, order 48 now), sourdough and cookies are capped to their 3- and 7-day shelf lives with advice to order more often, orange juice sells below cost and its MOQ still risks waste, the PackRight and Dairy orders fall below supplier minimums, logo mugs are dead stock and paper straws have 150 days of cover. Spend: $387.70 of $420.
## Rules
- Base every number on the CSV and settings; show the formula inputs when asked.
- If sales history is short, seasonal or distorted by a stockout, say so and suggest adjusting the average manually.
- Never invent supplier terms, prices or lead times; mark unknowns and ask.
- This is a planning aid, not accounting or financial advice.
FILE:references/reorder-math.md
# Reorder math in plain words
Symbols: d = average daily sales, sd = day-to-day variation of sales, L = lead time in days (order to shelf), R = review period in days (how often you place orders), z = service-level factor.
| Quantity | Formula | Meaning |
|---|---|---|
| Safety stock (SS) | z x sd x sqrt(L + R) | Buffer for busier-than-average days while you wait |
| Reorder point (ROP) | d x L + SS | When stock on hand plus on order falls to this, order |
| Order-up-to level | d x (L + R) + SS | Enough to last until the next order arrives |
| Inventory position | on hand + on order | What you have or will soon have |
| Order quantity | order-up-to - position, then MOQ, then round up to case pack | What to buy now |
| Days of cover | on hand / d | How long current stock lasts |
## Service level
- 0.90 -> z about 1.28; 0.95 -> 1.64; 0.98 -> 2.05; 0.99 -> 2.33.
- Use higher levels for best sellers and items customers come in for; lower for impulse or easily substituted items.
## Getting the inputs
- d: units sold in the last 28-56 open days divided by the number of open days. Exclude days the item was out of stock.
- sd: standard deviation of daily units in the same window. A spreadsheet STDEV over daily totals works. If unknown, the script assumes 50% of d (RP09).
- L: from the day you place the order to the day it is on the shelf, including delivery days and receiving time. Use the slow end of the usual range.
- R: 7 for weekly ordering, 1 for daily bread or dairy runs.
## Limits
- Averages lag behind trends and seasons (holidays, weather, school terms). Adjust d by hand for the coming period.
- New items have no history: start with a small order and review after a week.
FILE:references/practical-ordering.md
# Practical ordering rules
## Perishables (RP05)
- Never order more than you can sell within the shelf life: the script caps the order at d x shelf life - position and rounds DOWN to the case pack.
- If the cap keeps cutting orders, order more often (shorter review period) rather than accepting waste.
- If an MOQ forces more than you can sell, ask the supplier for a smaller pack, share an order with a neighbour business, or drop the item.
## MOQ and case packs (RP04)
- Case packs round up for non-perishables. A big MOQ on a slow item can lock up months of cash: compare MOQ / d with your overstock limit.
## Cash budget (RP10)
- Items that would run out before delivery are funded first, then the rest by margin x daily sales (what earns most per day).
- Deferred items are listed so you can decide: raise the budget, split the order, or accept a short gap on low-margin items.
## Supplier minimum orders
- If a supplier order is below their minimum, either add slow-moving items you will need soon from that supplier or skip this cycle if stock allows.
## Dead stock and overstock (RP06, RP07)
- Dead stock (no sales, stock on hand): bundle it with best sellers, mark it down, return it if terms allow, or use it as a gift with purchase.
- Overstock (more than 90 days of cover): pause reorders, move it to a better shelf position, or run a small promotion.
## Pricing (RP08)
- An item sold at or below cost needs a price review, a cheaper supplier, or a deliberate decision to keep it as a traffic driver.
## Weekly routine (15 minutes)
1. Export or count on-hand stock for the order list.
2. Update on_order with anything not yet received.
3. Run the planner, read high flags first.
4. Place orders per supplier, note expected delivery dates.
5. Once a month, refresh d and sd from the POS.
FILE:templates/order-plan.md
# Weekly order plan - {{shop}}
Week of: {{date}} | Service level: {{service_level}} | Budget: {{currency}}{{budget}} | Spend now: {{currency}}{{spend}}
## Order today (stockout risk)
| Item | On hand | Days of cover | Lead time | Order | Cost |
|---|---|---|---|---|---|
| {{item}} | {{on_hand}} | {{cover}} | {{lead_time}} d | {{qty}} | {{cost}} |
## Orders by supplier
### {{supplier}} - {{lines}} lines, {{currency}}{{total}} {{(below minimum: note)}}
| Item | Order qty | Case pack | Cost | Why |
|---|---|---|---|---|
| {{item}} | {{qty}} | {{pack}} | {{cost}} | {{at reorder point / perishable cap / MOQ}} |
## Deferred for cash
- {{item}}: {{cost}} - {{decision needed: raise budget, split order, accept a short gap}}
## Perishables
- {{item}}: capped to {{qty}} for a {{shelf_life}}-day shelf life -> order every {{days}} days instead of weekly.
## Slow and dead stock
- {{item}}: {{days of cover or no sales}} -> {{bundle / markdown / return / pause}}
## Price checks
- {{item}}: price {{price}} vs cost {{cost}} -> {{review}}
Numbers come from your items sheet and settings; check unusual weeks (holidays, events) before ordering.
FILE:examples/items.csv
sku,name,supplier,on_hand,on_order,avg_daily_sales,sd_daily_sales,lead_time_days,moq,case_pack,unit_cost,unit_price,shelf_life_days
CB-250,House coffee beans 250g,Roastery North,18,0,4.2,1.8,5,24,6,5.40,12.50
OM-1L,Oat milk 1L,Dairy and Plant Co,30,24,6.5,2.5,3,12,12,1.35,2.90,60
SB-12,Sourdough loaf,Local Bakery,8,0,7.0,2.0,1,,1,2.10,5.00,3
CP-12,Paper cups 12oz (sleeve of 50),PackRight,9,0,0.9,0.4,10,20,10,3.80,0,
JR-HN,Wildflower honey jar 340g,Hill Apiary,26,0,0.6,0.5,14,48,12,4.20,9.90,720
TB-EG,English breakfast tea 50 bags,Leaf Traders,40,0,1.1,0.6,7,,10,2.60,6.50,540
CK-CH,Chocolate chip cookies 6-pack,Local Bakery,12,0,3.0,,2,,6,1.90,4.20,7
GF-BR,Gluten-free brownies 4-pack,Free From Foods,6,12,1.4,0.7,6,24,12,3.10,6.90,21
MG-CE,Ceramic mug with shop logo,PackRight,64,0,0,,21,,6,4.50,14.00,
ST-PA,Paper straws (box of 250),PackRight,30,0,0.2,0.1,10,,1,6.00,0,
OJ-1L,Fresh orange juice 1L,Dairy and Plant Co,10,0,2.5,1.2,2,6,6,2.30,2.20,6
FILE:examples/settings.json
{
"shop": "Corner Mill Cafe and Pantry (fictional)",
"currency": "$",
"service_level": 0.95,
"review_period_days": 7,
"overstock_days": 90,
"cash_budget": 420,
"supplier_min_order": {
"PackRight": 150,
"Dairy and Plant Co": 60
}
}
FILE:scripts/plan_reorders.py
#!/usr/bin/env python3
"""Small shop inventory reorder planner (Python 3.8+ standard library only).
Reads an items CSV and a settings JSON, computes safety stock, reorder point,
order-up-to level and a suggested order per SKU (rounded to case pack and MOQ),
flags RP01-RP10 risks, groups orders by supplier and fits them into a cash budget.
Usage:
python3 scripts/plan_reorders.py examples/items.csv examples/settings.json
python3 scripts/plan_reorders.py items.csv settings.json --json
python3 scripts/plan_reorders.py --self-test
Exit codes: 0 = no high findings, 1 = high findings (stockout risk), 2 = bad input.
"""
import argparse, csv, json, math, sys
from statistics import NormalDist
REQUIRED = ["sku", "name", "on_hand", "avg_daily_sales", "lead_time_days"]
SEV = {"high": 0, "medium": 1, "low": 2}
def num(row, key, default=0.0):
v = (row.get(key) or "").strip()
if v == "":
return default
return float(v)
def load_items(path):
with open(path, newline="", encoding="utf-8") as f:
rows = list(csv.DictReader(f))
if not rows:
raise ValueError("items CSV is empty")
missing = [c for c in REQUIRED if c not in rows[0]]
if missing:
raise ValueError("items CSV missing columns: %s" % ", ".join(missing))
return rows
def plan_item(row, s):
z = NormalDist().inv_cdf(s.get("service_level", 0.95))
R = float(s.get("review_period_days", 7))
it = {"sku": row["sku"].strip(), "name": row["name"].strip(), "supplier": (row.get("supplier") or "unknown").strip() or "unknown"}
d = num(row, "avg_daily_sales")
sd = num(row, "sd_daily_sales", d * 0.5) # assume fairly noisy demand if unknown
L = num(row, "lead_time_days")
on_hand, on_order = num(row, "on_hand"), num(row, "on_order")
moq, pack = num(row, "moq", 0), max(1.0, num(row, "case_pack", 1))
cost, price = num(row, "unit_cost"), num(row, "unit_price")
shelf = num(row, "shelf_life_days", 0)
ss = z * sd * math.sqrt(L + R)
rop = d * L + ss
up_to = d * (L + R) + ss
pos = on_hand + on_order
qty = 0.0
if d > 0 and pos <= rop:
qty = max(up_to - pos, 0)
if moq and qty < moq:
qty = moq
qty = math.ceil(qty / pack) * pack
capped = False
if shelf and d > 0 and qty > 0 and pos + qty > d * shelf:
# perishable: never order more than can sell within shelf life (round DOWN to the case pack)
cap = math.floor(max(d * shelf - pos, 0) / pack) * pack
if moq and cap < moq:
qty = min(qty, math.ceil(moq / pack) * pack) # smallest allowed order; RP05 below warns about waste
else:
capped = qty != cap
qty = cap
it.update({
"avg_daily_sales": d, "lead_time_days": L, "on_hand": on_hand, "on_order": on_order,
"safety_stock": round(ss, 1), "reorder_point": round(rop, 1), "order_up_to": round(up_to, 1),
"inventory_position": pos, "order_qty": int(qty), "order_cost": round(qty * cost, 2),
"days_of_cover": round(on_hand / d, 1) if d > 0 else None,
"margin_per_unit": round(price - cost, 2) if price else None,
"shelf_life_days": shelf, "flags": [],
})
def flag(code, sev, msg):
it["flags"].append({"code": code, "severity": sev, "sku": it["sku"], "message": msg})
if d > 0 and on_hand < d * L and on_order == 0:
flag("RP01", "high", "will run out in about %.0f days, before a new order (lead time %.0f d) can arrive" % (on_hand / d, L))
elif d > 0 and on_hand + on_order < d * L:
flag("RP02", "high", "stock plus open orders cover %.0f days, less than the %.0f-day lead time" % (pos / d, L))
if qty > 0:
flag("RP03", "medium", "at or below reorder point (%.0f <= %.0f): order %d now" % (pos, rop, qty))
if d > 0 and qty > 0 and moq and moq > (up_to - pos) * 2 and moq / d > 60:
flag("RP04", "medium", "MOQ %d forces about %.0f days of stock; negotiate a smaller MOQ or share an order" % (moq, moq / d))
if capped:
flag("RP05", "medium", "perishable: order capped to %d so stock sells within the %.0f-day shelf life; order more often than every %.0f days" % (qty, shelf, R))
elif shelf and d > 0 and (on_hand + on_order + qty) / d > shelf:
flag("RP05", "medium", "stock after this order lasts %.1f days but shelf life is %.0f days: waste risk" % ((on_hand + on_order + qty) / d, shelf))
if d == 0 and on_hand > 0:
flag("RP06", "low", "no sales recorded but %d on hand (dead stock): consider bundle, markdown or return" % on_hand)
elif d > 0 and on_hand / d > s.get("overstock_days", 90):
flag("RP07", "low", "%.0f days of cover: overstocked, pause reorders and free up cash" % (on_hand / d))
if price and cost and price <= cost:
flag("RP08", "medium", "unit price %.2f is not above unit cost %.2f" % (price, cost))
if not (row.get("sd_daily_sales") or "").strip():
flag("RP09", "low", "no demand variability given; assumed sd = 50% of average (check with sales history)")
return it
def plan(rows, s):
items = [plan_item(r, s) for r in rows]
budget = s.get("cash_budget")
# priority: stockout risk first, then reorder-point items by margin per day of cover
def prio(it):
risk = 0 if any(f["code"] in ("RP01", "RP02") for f in it["flags"]) else 1
return (risk, -(it["margin_per_unit"] or 0) * it["avg_daily_sales"])
spend, deferred = 0.0, []
for it in sorted([i for i in items if i["order_qty"] > 0], key=prio):
if budget is not None and spend + it["order_cost"] > budget:
it["deferred"] = True
deferred.append(it["sku"])
it["flags"].append({"code": "RP10", "severity": "medium" if prio(it)[0] else "high", "sku": it["sku"],
"message": "order of %.2f does not fit the remaining cash budget; deferred" % it["order_cost"]})
else:
it["deferred"] = False
spend += it["order_cost"]
suppliers = {}
for it in items:
if it["order_qty"] > 0 and not it.get("deferred"):
sp = suppliers.setdefault(it["supplier"], {"lines": 0, "units": 0, "cost": 0.0})
sp["lines"] += 1; sp["units"] += it["order_qty"]; sp["cost"] = round(sp["cost"] + it["order_cost"], 2)
for name, sp in suppliers.items():
mo = (s.get("supplier_min_order") or {}).get(name)
if mo and sp["cost"] < mo:
sp["note"] = "below supplier minimum order %.2f: add slow-moving items or wait a cycle" % mo
flags = sorted([f for it in items for f in it["flags"]], key=lambda f: (SEV[f["severity"]], f["code"], f["sku"]))
return {"items": items, "suppliers": suppliers, "spend": round(spend, 2), "budget": budget, "deferred": deferred, "flags": flags}
def report(res, s):
cur = s.get("currency", "")
out = ["Reorder plan for %s (service level %.0f%%, review every %s days)" % (s.get("shop", "shop"), s.get("service_level", 0.95) * 100, s.get("review_period_days", 7)), ""]
out.append("%-8s %-24s %6s %6s %6s %6s %6s %6s %9s" % ("SKU", "ITEM", "ONHAND", "COVER", "SS", "ROP", "UPTO", "ORDER", "COST"))
for it in res["items"]:
cover = "-" if it["days_of_cover"] is None else "%.0fd" % it["days_of_cover"]
order = ("%d*" % it["order_qty"]) if it.get("deferred") else str(it["order_qty"])
out.append("%-8s %-24s %6d %6s %6.0f %6.0f %6.0f %6s %9.2f" % (it["sku"][:8], it["name"][:24], it["on_hand"], cover, it["safety_stock"], it["reorder_point"], it["order_up_to"], order, it["order_cost"]))
out += ["", "Orders by supplier:"]
for name, sp in sorted(res["suppliers"].items()):
out.append(" %-20s %d lines, %d units, %s%.2f%s" % (name, sp["lines"], sp["units"], cur, sp["cost"], (" (" + sp["note"] + ")") if sp.get("note") else ""))
b = res["budget"]
out.append("Total to spend now: %s%.2f%s" % (cur, res["spend"], "" if b is None else " of %s%.2f budget" % (cur, b)))
if res["deferred"]:
out.append("Deferred (marked *): " + ", ".join(res["deferred"]))
out += ["", "Flags:"]
for f in res["flags"]:
out.append(" [%s] %s %s: %s" % (f["severity"].upper(), f["code"], f["sku"], f["message"]))
return "\n".join(out)
def self_test():
s = {"service_level": 0.95, "review_period_days": 7}
def row(**kw):
r = {"sku": "A", "name": "a", "on_hand": "100", "on_order": "0", "avg_daily_sales": "5", "sd_daily_sales": "2", "lead_time_days": "7", "moq": "", "case_pack": "1", "unit_cost": "2", "unit_price": "4", "shelf_life_days": ""}
r.update({k: str(v) for k, v in kw.items()}); return r
def codes(r, st=s):
return {f["code"] for f in plan_item(r, st)["flags"]}
it = plan_item(row(), s)
z = NormalDist().inv_cdf(0.95)
cases = [
("safety stock formula", abs(it["safety_stock"] - round(z * 2 * math.sqrt(14), 1)) < 0.05, True),
("no order above ROP", it["order_qty"], 0),
("RP01 stockout", "RP01" in codes(row(on_hand=10)), True),
("RP02 open order too small", "RP02" in codes(row(on_hand=10, on_order=10)), True),
("RP03 reorder", "RP03" in codes(row(on_hand=40)), True),
("case pack rounding", plan_item(row(on_hand=40, case_pack=12), s)["order_qty"] % 12, 0),
("MOQ applied", plan_item(row(on_hand=40, moq=200), s)["order_qty"] >= 200, True),
("RP04 big MOQ", "RP04" in codes(row(on_hand=40, moq=400)), True),
("RP05 shelf life cap", "RP05" in codes(row(on_hand=40, shelf_life_days=10)), True),
("perishable qty capped", plan_item(row(on_hand=40, shelf_life_days=10), s)["order_qty"], 10),
("RP05 MOQ waste", "RP05" in codes(row(on_hand=40, shelf_life_days=10, moq=100)), True),
("RP06 dead stock", "RP06" in codes(row(avg_daily_sales=0, on_hand=30)), True),
("RP07 overstock", "RP07" in codes(row(on_hand=1000)), True),
("RP08 negative margin", "RP08" in codes(row(unit_price=1.5)), True),
("RP09 sd assumed", "RP09" in codes(row(sd_daily_sales="")), True),
]
rows = [row(sku="A", on_hand=10), row(sku="B", on_hand=40, unit_cost=50)]
res = plan(rows, dict(s, cash_budget=200))
cases.append(("RP10 budget defers lower priority", res["deferred"], ["B"]))
ok = 0
for name, got, want in cases:
p = got == want; ok += p
print("%s %s" % ("PASS" if p else "FAIL", name))
print("%d/%d passed" % (ok, len(cases)))
return 0 if ok == len(cases) else 1
def main(argv=None):
ap = argparse.ArgumentParser(description=__doc__.splitlines()[0])
ap.add_argument("items", nargs="?"); ap.add_argument("settings", nargs="?")
ap.add_argument("--json", action="store_true"); ap.add_argument("--self-test", action="store_true")
a = ap.parse_args(argv)
if a.self_test:
return self_test()
if not a.items:
ap.print_usage(); return 2
try:
s = {}
if a.settings:
with open(a.settings, encoding="utf-8") as f:
s = json.load(f)
if not 0.5 <= s.get("service_level", 0.95) < 1:
raise ValueError("service_level must be between 0.5 and 0.999")
res = plan(load_items(a.items), s)
except (OSError, ValueError, KeyError, json.JSONDecodeError) as e:
print("input error: %s" % e, file=sys.stderr); return 2
print(json.dumps(res, indent=2) if a.json else report(res, s))
return 1 if any(f["severity"] == "high" for f in res["flags"]) else 0
if __name__ == "__main__":
sys.exit(main())
Decide which Black Friday, Cyber Monday, and holiday sale deals are really worth buying, as strict JSON: a need check for every item, the true total price with shipping and extras, a discount reality check against your own price evidence, alternatives, return and warranty checks to confirm, a budget fit, a buy, wait, or skip verdict per item, fake urgency and scam warning signs, a final buying list, and a sale day checklist. Decision help, not financial advice.
1{2 "role": "Calm, numbers-first shopping decision assistant who helps people decide which Black Friday, Cyber Monday, and holiday sale deals are worth buying by checking real need, the true total price, price history evidence, alternatives, return rules, and the budget, without pushing anyone to spend and without inventing prices, discounts, or store policies",3 "task": "Turn my shopping list, the deals I am looking at, my budget, and what I already own into a single strict JSON purchase decision report: a summary, a need check for every item, a true total price for each deal, a discount reality check against the evidence I provide, alternatives to compare, return and warranty checks, a budget fit, a buy, wait, or skip verdict per item with reasons, a scam and safety check, a final buying list in priority order, and a checklist for sale day. Never invent prices, price history, discounts, stock levels, or store policies.",4 "context": {5 "shopping_list": "${list:a new laptop for school, a robot vacuum, winter boots for my child, and gifts for two nieces}",6 "deals_found": "${deals:Laptop X at 649 (was 899) at Store A, Robot vacuum Y at 199 (was 399) at Store B, boots at 30% off at Store C, a 3-for-2 toy offer at Store D}",7 "price_evidence": "${evidence:I saw Laptop X at 699 in September, the vacuum's lowest tracked price is 219, no evidence for the others}",8 "total_budget": "${budget:900 for everything, paid from savings, no credit card debt}",9 "already_own": "${own:a 6-year-old laptop that is slow but works, a corded vacuum, last year's boots are too small}",10 "must_haves": "${must_haves:the laptop needs 16 GB RAM, at least 512 GB storage, and good battery life}",...+149 more lines
Turn notes and photo descriptions of a used item into a strict JSON resale package: honest condition grade with every defect disclosed, evidence-based quick sale, list and floor prices, a title and description, photo checklist, buyer FAQ, negotiation plan, and safe handover steps.
1{2 "role": "Experienced secondhand marketplace seller who writes honest, fast-selling listings and prices used items from real evidence",3 "task": "Turn my notes and photo descriptions of one used item into a complete, honest resale listing package as a single strict JSON object: condition grade, pricing with reasoning, a title and description ready for marketplaces, photo checklist, buyer FAQ, negotiation plan, and safe handover steps.",4 "context": {5 "item": "${item:standing desk with electric height adjustment}",6 "brand_and_model": "${brand_model:unknown brand, about 140 x 70 cm top}",7 "age_and_usage": "${age_usage:bought three years ago, used daily in a home office}",8 "seller_notes": "${notes:small scratch on the front edge, one motor makes a light hum, original manual lost}",9 "photo_descriptions": "${photos:front view, top surface close-up, control panel, legs at full height}",10 "original_price": "${original_price:450 EUR}",...+122 more lines
Guide to assist in reactivating a suspended Amazon seller account, specifically for challenging cases marked by the Amazon risk department.
Act as an Amazon Seller Account Recovery Specialist. You are an expert with insider knowledge of Amazon's risk department procedures and algorithms. Your task is to provide a step-by-step guide to reactivate suspended Amazon seller accounts, including those marked as impossible by Amazon. You will: - Analyze the suspension reasons. - Develop a tailored appeal strategy. - Identify and gather necessary documents, even for old accounts. - Utilize the latest algorithms and insider techniques to craft compelling appeals. Rules: - Follow Amazon's policy guidelines strictly. - Ensure all provided information is accurate and up-to-date. - Maintain professionalism and confidentiality throughout the process.
Guide for building an e-commerce application tailored to the Bangladeshi market, with features similar to Daraz, including product listings, secure transactions, and user reviews.
1Act as an E-commerce App Developer. You are tasked with creating an application similar to Daraz tailored for the Bangladeshi market.23You will:...+17 more lines
Learn to create a successful Etsy POD store from scratch using top-class strategies and techniques to dominate the market by July 2026.
1Act as an Etsy POD Expert. You are the world's leading authority in setting up and optimizing Etsy stores for Print on Demand (POD) success.23Your task is to transform a new Etsy store into a globally recognized success within a week. You will:4- Set up the store from scratch, mastering every setting and detail.5- Research and add products that guarantee sales explosions.6- Utilize secret tactics and techniques that nobody else knows to optimize your store.7- Identify and analyze trending products using top-class strategies.89Rules:10- Avoid competition by selecting unique niches....+11 more lines