Marketplace Inventory Turnover Worksheet: Decide What to Reprice, Bundle, Discount, or Liquidate
inventory turnoverrepricingslow-moving stocksell-through rateseller workflow

Marketplace Inventory Turnover Worksheet: Decide What to Reprice, Bundle, Discount, or Liquidate

TTrade Nexus Editorial Team
2026-11-17
7 min read

Use this marketplace inventory worksheet to decide whether slow stock needs better presentation, a new price, a bundle, a promotion, or liquidation.

A slow-moving listing is not automatically a pricing problem. It may have weak visibility, unclear condition details, excessive delivery cost, or a margin that disappears after marketplace fees. This marketplace inventory management worksheet gives you a repeatable way to review aging stock and choose whether to reprice, improve the listing, bundle accessories, run a controlled promotion, or liquidate. Use it during a weekly or monthly inventory review, then record the result so your next decision is based on evidence rather than guesswork.

Overview

Inventory turnover is the pace at which stock sells and is replaced. On buy sell marketplaces, turnover should be considered alongside contribution margin: selling an item quickly is not useful if fees, shipping, discounts, returns, storage, and acquisition cost consume the proceeds.

Begin by separating listings into three groups:

  • Healthy: The item receives relevant traffic and sells at a margin that meets your target.
  • Promising but blocked: The listing gets views, saves, or inquiries, but a correctable issue may be reducing conversions.
  • Aging or unproductive: The item has consumed time, storage capacity, or capital without a reasonable path to sale.

The purpose of the worksheet is not to force every item into a discount. It is to identify the constraint. Low views usually call for better discoverability, categorization, or presentation. Good views with few inquiries can indicate a price, condition, or trust problem. Regular inquiries without completed sales may point to shipping cost, payment friction, missing specifications, or an uncompetitive total price.

For a broader approach to comparing platforms, fees, payouts, and promotions, review this marketplace fees and promotions comparison guide. Your inventory decision should use the actual costs of the marketplace where the item is listed, not a generic fee assumption.

How to estimate

Use one row per SKU or listing and review a consistent period, such as the last 30 days. Copy the following fields into a spreadsheet:

FieldWhat to record
Item or SKUProduct, variant, condition, and quantity available
Days listedElapsed days since the current listing was published or substantially refreshed
ViewsListing visits during the review period
Saves or followsBuyer signals available in the platform analytics
InquiriesQuestions, offers, or messages connected to the listing
Units soldCompleted sales during the review period
Conversion rateUnits sold divided by views, expressed as a percentage
Sell-through rateUnits sold divided by units available at the start of the period, with additions recorded separately
Competitor pricingComparable asking prices and, where visible, completed-sale prices
Storage costAllocated cost of space, handling, insurance, or time spent holding the item
Current marginExpected net proceeds minus product cost and other variable costs

Use these calculations:

  • Conversion rate = units sold ÷ views × 100.
  • Sell-through rate = units sold ÷ starting available units × 100. If stock was added during the period, note that separately rather than treating new stock as old inventory.
  • Expected net proceeds = sale price − marketplace fee − payment fee − seller-paid shipping − packaging − expected return cost − promotion discount.
  • Contribution margin = expected net proceeds − acquisition cost − allocated storage and handling cost.
  • Break-even price = the price required for net proceeds to cover acquisition, shipping, fees, packaging, and other relevant costs.

Do not compare asking prices without comparing the complete buyer cost. A lower headline price may be offset by delivery charges, while a higher price may include useful accessories or better condition. The guide on comparing marketplace listings after shipping, fees, and returns provides a useful framework for making that comparison.

Inputs and assumptions

Make your worksheet useful by defining assumptions before choosing an action. First, decide what counts as a comparable item. For electronics and gaming accessories, match condition, model, compatibility, included cables, storage capacity, warranty status, and tested functionality. A used controller with a verified battery and original adapter should not be compared directly with an untested unit.

Next, set a minimum acceptable contribution margin. This can be a percentage of the sale price, a fixed amount per order, or a return that compensates you for the capital and handling time. Use the same rule across similar items, but allow for different risk levels. Fragile, high-return, or cross-border products may need a larger cushion than easy-to-ship items.

Record whether the marketplace analytics use views, impressions, visits, or another term. These measures are not interchangeable. Also record the period covered, because a short promotion or seasonal change can make a monthly comparison misleading.

A practical decision tree is:

  1. Are views materially below comparable listings? Improve the title, category, attributes, photographs, and search terms before cutting price. Use the electronics and gaming accessories listing template to check for missing information.
  2. Are views healthy but saves and inquiries weak? Test the price against comparable total costs, then clarify condition, compatibility, included items, and return expectations.
  3. Are inquiries strong but sales absent? Review delivery cost, response time, payment instructions, pickup options, and buyer concerns. Do not assume a larger discount is the answer.
  4. Is there a complementary low-value accessory available? Test a bundle when the combined offer solves a clear buyer need and remains profitable after extra packing and shipping.
  5. Is the item profitable but aging? Run one controlled promotion with a defined end date, minimum price, and success measure.
  6. Is the item below break-even or consuming disproportionate storage? Consider liquidation, a wholesale lot, parts sale, return to supplier where applicable, or removal from the channel.

For pricing formulas and margin checks, see the marketplace break-even and margin guide. A discount should be treated as an experiment, not as a permanent response to slow sales.

Worked examples

Example 1: Low traffic. A gaming accessory has been listed for 45 days. It has 22 views, no inquiries, and no sale, while comparable listings receive more visible engagement. Before reducing the price, inspect the title, category, compatibility statement, photos, and condition notes. If the listing omits the console model or does not show the included adapter, the likely action is a listing improvement. Recheck views and inquiries after a defined test period. Record the change and the result.

Example 2: Traffic but weak conversion. An electronics listing receives 180 views, 12 saves, four inquiries, and no completed sale. The asking price is near comparable listings, but seller-paid shipping and packaging reduce the margin. Test one change at a time: either adjust the total buyer cost, improve delivery options, or clarify the product test results. Set a floor price using the break-even calculation. If the revised offer produces a sale above that floor, the test may be successful even if the headline price is lower.

Example 3: Bundle opportunity. A console is attracting inquiries, but a compatible cable and stand remain unsold. A bundle may improve perceived usefulness and reduce separate listing work. Calculate the bundle's net proceeds, additional packing cost, shipping weight, and expected margin. Compare it with selling each item separately. Bundle only if the combined offer remains above the target contribution margin and the added contents are clearly described.

Example 4: Liquidation decision. A low-demand item has been listed for 120 days, receives minimal traffic, and has a contribution margin below your floor after storage and handling. A small price cut is unlikely to change the economics. Liquidation through a lot sale, parts listing, or another channel may release capital and space. Record the realized proceeds and use them to improve future purchasing decisions.

When to recalculate

Review active inventory weekly if you carry a small, high-value range, or monthly if your catalog is larger and sales are less frequent. Recalculate immediately when a marketplace changes fees, payout rules, promotion mechanics, analytics definitions, shipping options, tax treatment, or return-related costs. Also update the worksheet when supplier costs, packaging, storage, exchange rates, or delivery rates change.

Refresh competitor comparisons on a schedule that matches the product. Fast-moving electronics may need more frequent checks than durable accessories. Avoid reacting to one unusually low listing; compare several relevant listings and distinguish asking prices from completed sales when that information is available.

At every review, choose one next action, define a time window, and record the outcome:

  • Listing change: measure views, saves, inquiries, and conversion.
  • Price test: measure net proceeds, units sold, and contribution margin.
  • Bundle test: measure bundle conversion and additional fulfillment cost.
  • Promotion: record the discount, duration, incremental sales, and margin after the discount.
  • Liquidation: record proceeds, costs avoided, and capital released.

Keep a change log beside the worksheet. This prevents repeated experiments and shows which actions improve sell-through without damaging profitability. When reviewing electronics, also use the used-electronics inspection checklist so condition and testing information support the price. The best marketplace inventory decision is rarely the fastest discount; it is the action that addresses the actual constraint while protecting cash flow and margin.

Related Topics

#inventory turnover#repricing#slow-moving stock#sell-through rate#seller workflow
T

Trade Nexus Editorial Team

Marketplace Growth Editor

Senior editor and content strategist. Writing about technology, design, and the future of digital media. Follow along for deep dives into the industry's moving parts.