Manage inventory and sales opportunities

On this page you can review your FBA inventory status to build the basis for restock and cleanup decisions, and weigh whether to dial ads up or down based on inventory status. From identifying stockout risk to detecting overstock and creating a replenishment order brief, use it to streamline the inventory work that sits right next to ad operations.

About this page

Item	Details
What you can do	List FBA inventory and check weeks of cover, identify SKUs at risk of stockout, detect overstock and slow-moving inventory, create a replenishment order brief, and consider ad adjustments based on inventory status
Applies to	FBA inventory (fulfillable inventory / inbound working inventory / weekly shipment pace / weeks of cover) and Subscribe & Save (SnS) performance data
Data & connection needed	Inventory data and Subscribe & Save performance data for the connected account (no additional setup)
Scope	Mostly analysis and proposals only (read-only). Actual ordering and shipment-plan creation are done manually in Seller Central, and Picaro never places orders. Only the inventory-aware ad adjustment (Prompt 5) hands its proposals to the approval flow of the related pages (bids / budgets) for execution. Each prompt states its own in “Changes”

FBA (Fulfillment by Amazon) … a system where you store inventory in Amazon’s warehouses and Amazon handles storage, shipping, and customer support on your behalf.
SKU … the smallest unit of code for managing a product. Even for the same ASIN, SKUs can differ by listing condition.
weeks of cover … an estimate of how many more weeks the fulfillable inventory lasts at the current weekly shipment pace (fulfillable inventory ÷ weekly shipment pace).
days of cover … the same idea as weeks of cover, expressed in days.
lead time … the number of days from placing an order until stock becomes sellable.
safety stock … the buffer inventory you hold against demand swings and inbound delays (specified in days).
Subscribe & Save (SnS) … Amazon’s system where shoppers register recurring purchases and receive them regularly at a discount.

When to use this

You want to grasp the full FBA inventory picture at a glance, with weeks of cover
You want to sort SKUs close to stockout into urgency buckets: “urgent restock / order candidate / watch”
You want to find overstock and slow-moving inventory to use as input for sell-through actions or listing cleanup
You want to consolidate restock and cleanup candidates onto one page for a weekly ordering-review meeting
You want to decide whether to dial ads up or down (hold back / maintain / reinforce) according to inventory status
You want to understand lost opportunities from Subscribe & Save (SnS) stockouts and factor them into restock priority

Before you run

Connected account … if you handle multiple accounts, confirm the target account is correct first.
Lead time / safety stock … these are the basis for the stockout-risk assessment (Prompts 2 and 4). Specify them to match your actual procurement and inbound reality.
Overstock threshold … used in the slow-moving inventory assessment (Prompt 3). Defaults are “over 180 days = overstock candidate” and “over 270 days = long-term storage fee warning,” and you can change them to fit your product’s turnover profile.
Picaro does not place orders … restock and order execution is done manually via shipment-plan creation in Seller Central.

Prompt quick reference

What you want to do	What you learn / what gets created	Changes	Prompt
Check the full FBA inventory picture with weeks of cover	An inventory list with weeks of cover	No change	Prompt 1
Sort SKUs at risk of stockout by urgency	A 3-bucket list: urgent restock / order candidate / watch	No change (ordering is in Seller Central)	Prompt 2
Find overstock and slow-moving inventory	A list of overstock / long-term storage warnings	No change	Prompt 3
Create a replenishment order brief	A Markdown brief for ordering review	No change (draft only)	Prompt 4
Decide whether to dial ads up or down based on inventory	A list of hold back / maintain / reinforce recommendations	No change (proposal only; execution via the bid / budget categories)	Prompt 5
Understand lost opportunities from Subscribe & Save stockouts	A list of undelivered-due-to-stockout and worsening products	No change	Prompt 6

Prompt 1: See the full FBA inventory picture (with weeks of cover)

Review FBA inventory in one list. Beyond fulfillable inventory, it lines up inbound working inventory, weekly shipment pace, and weeks of cover (how many more weeks the stock lasts at the current pace) so you can grasp the full picture.

When to use — when you want to grasp the full inventory picture at a glance, with weeks of cover.

What you need — none (use as is). You can also filter by ASIN or product name.

List the FBA inventory. For each ASIN / SKU, line up fulfillable inventory,
inbound working inventory, weekly shipment pace, and weeks of cover,
sorted by fewest weeks of cover first.

What you can change — the filter target (ASIN, product name).

What you get back — a table of ASIN / SKU × fulfillable inventory × inbound working inventory × weekly shipments × weeks of cover. Weeks of cover is an estimate of “fulfillable inventory ÷ weekly shipment pace,” so it shifts around periods when the shipment pace changes, such as sales.

Changes — no change (read-only).

Next steps — for SKUs with few weeks of cover, assess stockout risk with Prompt 2.

Prompt 2: Identify SKUs at risk of stockout

Using sales pace, days of cover, inbound working inventory, lead time, and safety stock, assess stockout risk in three buckets: “urgent restock / order candidate / watch.”

When to use — when you want to sort SKUs close to stockout by urgency and set restock priority.

What you need — lead time (days from placing an order until stock becomes sellable; 14 days in the example) and safety-stock days (buffer for demand swings and inbound delays; 7 days in the example). If there is an ASIN you want to leave out of the assessment, say “exclude B0XXXXXXXX.”

Assess stockout risk from the FBA inventory.
Assuming a 14-day lead time and 7 days of safety stock,
list SKUs in three buckets: "urgent restock," "order candidate," and "watch."

What you can change — lead time (e.g. 14 days) / safety-stock days (e.g. 7 days) / ASINs to exclude from the assessment. Adjust them to your actual procurement and inbound reality.

What you get back — a table of bucket (urgent restock / order candidate / watch) × SKU × fulfillable inventory × weekly shipments × estimated days of cover. “Urgent restock” means SKUs whose days of cover are below lead time + safety stock (there is stockout risk even if you order now).

Changes — analysis and proposal only (read-only). No orders are placed.

Next steps — once your restock targets are set, consolidate them into the replenishment order brief in Prompt 4. Actual ordering is done via shipment-plan creation in Seller Central.

Prompt 3: Identify overstock and slow-moving inventory

Detect SKUs whose estimated days of cover exceed a threshold as overstock candidates. Inventory that sits too long increases storage-fee load, so this becomes input for decisions on discounts, ad reinforcement, or listing cleanup.

When to use — when you want to find slow-moving inventory to use as input for sell-through actions or listing cleanup.

What you need — none (use as is). Default thresholds are “over 180 days = overstock candidate” and “over 270 days = long-term storage fee warning.”

Detect overstock candidates from the FBA inventory.
List separately the SKUs with estimated days of cover over 180 days,
and the SKUs over 270 days that are at high risk of long-term storage fees.

What you can change — the overstock and long-term storage warning thresholds (e.g. 180 days / 270 days). You can change them to fit your product’s turnover profile.

What you get back — a table of SKU × fulfillable inventory × weekly shipments × estimated days of cover × bucket (overstock / long-term storage warning).

Changes — analysis and proposal only (read-only).

Next steps — to consider sell-through via ads (ad reinforcement, discounts), combine with Adjust bids.

Prompt 4: Create a restock brief

Create a “replenishment order brief” that consolidates order candidates, urgent restocks, and overstock candidates into a single document. It works as the starting draft for a weekly ordering-review meeting.

When to use — when you want to consolidate restock and cleanup candidates onto one page for a weekly ordering-review meeting.

What you need — none (use as is). Lead time, safety stock, and overstock thresholds can be specified the same way as in Prompts 2 / 3.

Create an FBA replenishment order brief.
Consolidate order candidates, urgent restocks, and overstock candidates,
and output it in a format ready to use for ordering review.

What you can change — lead time / safety stock / overstock thresholds (specified the same way as in Prompts 2 and 3).

What you get back — a Markdown brief consolidating a priority-ordered order-candidate list + an urgent-restock list + an overstock-candidate list. This is draft generation only; no actual ordering or external sending is performed.

Changes — analysis and proposal only (draft generation only). No ordering or sending is performed.

Next steps — execute orders via shipment-plan creation in Seller Central.

Prompt 5: Consider ad adjustments based on inventory status

Continuing to pour ad spend into ASINs at stockout risk degrades ad efficiency the moment they run out. Conversely, ASINs with inventory headroom have room for ad reinforcement. This prompt cross-references inventory with ad performance and proposes adjustment candidates.

When to use — when you want to decide whether to dial ads up or down (hold back / maintain / reinforce) according to inventory status.

What you need — none (use as is). The target period can be changed.

Identify the ASINs that fall under stockout risk (urgent restock / order candidate),
and line each up with its ad spend, sales, and ROAS for the last 30 days.
Propose separately the ASINs whose ads should be held back until inventory recovers,
and the ASINs with inventory headroom whose ads can be reinforced.

What you can change — the target period.

What you get back — a table of ASIN × inventory status (estimated days of cover) × ad spend × sales × ROAS × recommendation (hold back / maintain / reinforce). Since there is no mechanism that automatically pauses ads on stockout, ads for ASINs close to running out must always be adjusted by human judgment.

Changes — on this page, analysis and proposal only (ad settings are not changed). Actual adjustment is done through the approval flow (analyze → approve → execute) of Adjust bids / Adjust budgets.

Next steps — to execute a hold-back or reinforcement, use the approval flow of Adjust bids / Adjust budgets.

With Subscribe & Save (SnS), a stockout means registered subscriptions go undelivered, directly creating a loss of sales opportunity. Review “undelivered due to stockout” per product and use it as input for restock prioritization.

When to use — when you want to understand lost opportunities from Subscribe & Save stockouts and factor them into restock priority.

What you need — none (use as is). You can also specify a period like “last month.”

Show Subscribe & Save (SnS) performance by product,
sorted by the number of shipments undelivered due to stockout.
Compare the most recent period with the prior period and identify products
where the opportunity loss from stockouts is growing.