Run everything you never had time to implement. Define your process once, and keep it

running with Qore.
Qore > Skills > Overstock Clearance Enginer
Retail Readiness

Overstock Clearance Engine

Finds stock headed for the next aged-inventory fee, sizes how much has to sell and by when, and raises ad spend on the ASIN's best targets inside an ACoS ceiling that never goes past break-even plus the fee it avoids.
Deep
·
7 steps
Amazon
READS
Your ad data
LOOKS FOR
SKUs over 90 days of cover, or close to the next aged-inventory fee
PRODUCES
Units to clear, a temporary ACoS ceiling, and a promo pairing
YOU
Approve the ceiling and the promo, and it reverts on its own date
Overview

What it reads, what it checks, what comes back, what you approve.

What it reads
What is aging, and what it costs to hold
  • The FBA inventory age report and aged-inventory fees
  • Units on hand and days of cover
  • Margin and storage fee per unit
  • Thirty days of advertised product data, and the promo calendar
What it checks
Whether stock will hit the next fee
  • More than 90 days of cover, or units within 30 days of the next fee bracket
  • Units to clear, and the daily pace needed to clear them in time
  • A break-even ACoS ceiling, plus the storage fee each sale avoids
  • Discontinued and seasonal stock handled separately
What comes back
A clearance plan, inside the margin
  • Bids and budgets raised 10 to 20% on the ASIN's best-converting targets
  • A coupon or deal recommended to pair with the spend
  • A revert date, set before anything changes
What you approve
The ceiling, the promo, and the bigger raises
  • Any relaxed ACoS target, and any promo
  • Any raise over $200 a day
  • No raise above 20% in one move, and no ceiling above break-even plus fee avoided
  • Prior targets, bids and budgets logged and restored at the revert date

What is aging into the next fee, and how to clear it

Inventory age + unit economics · components

ComponentsStep 1Step 2Step 3Step 4Step 5Step 6Step 7Step 8Load Inventory AgeConfirm the TriggerSize the ClearanceSet the ACoS CeilingJoin Unit EconomicsmergeCompute ACoS CeilinggroupRaise Spend on WinnersPair with a PromoRevert at TargetLoad Unit Economics3122122

The skill's components as built in Qore, with Set the ACoS Ceiling open.

Run Settings
The six things this skill asks you to set.
Cover trigger
The days of cover past which a SKU counts as overstocked.
Fee bracket window
How close to the next aged-inventory fee a SKU has to be before the skill acts.
Margin floor
The lowest margin you will accept. It overrides the ACoS ceiling when it is stricter.
Max raise per move
The largest raise on a bid or budget in one move.
Revert point
The days of cover, or the date, at which every change reverts.
Protected campaigns
Branded campaigns and other ASINs' budgets. These are never touched.

Frequently Asked Questions

How do I clear aged inventory on Amazon before storage fees go up?

This skill flags SKUs with more than 90 days of cover, or units within 30 days of the next aged-inventory fee bracket. It sizes the units to clear and the daily pace, then raises spend on the ASIN's best-converting targets.

How high can ACoS go while clearing stock?

No higher than break-even ACoS plus the storage fee each sale avoids, as a share of price. Your margin floor overrides that when it is stricter.

Why does it recommend a promo?

Ads amplify a promo, and spend alone clears stock slowly. So it pairs the raise with a coupon or deal recommendation for the brand to approve.

When does it stop?

When does it stop?

What about discontinued or seasonal stock?

Discontinued SKUs are flagged, since removal or liquidation may beat ads. Seasonal stock ahead of its season is held rather than pushed.

Does it touch other products' budgets?

No. It raises bids and budgets on the aged ASIN only, and never touches branded campaigns or other ASINs' budgets.

Start
Provisioned on your account at signup.
Try Qore
Use cases
Retail Readiness
Keep spend in line with stock

Ads keep spending while a product runs out, then keep paying after it is gone. This keeps spend and stock in step.

Inventory
3 skills
Amazon
Walmart
Planning & Profitability
Decide which products to push

Budget is finite and your catalog is not. This shows which products have room to take more, and which are already maxed.

Ads
3 skills
Amazon
Walmart

Every one of these runs on your own account.

Sign up, connect an account, and install a skill. The first run produces a real result you can look at before you schedule anything.
Try QoreBrowse The Skill Library