NetSKU

Calculate your retail.

Cost includes internal markup. Find the retail price for each shipping option.

How to use the Retail Calculator
  1. Choose your price endings. Vanity pricing rounds a calculated price to a familiar selling price, such as $21.99. Choose the rounding option you want under Vanity Pricing.
  2. Enter your item details. For one item, use Pricing & costs per item. For multiple items, download and complete the Excel template, then upload it and select Calculate.
  3. Enter your cost and percentages. Advertising is the share of each sale you set aside for ads. Enter 5 for 5%, or $1 on a $20 sale. Commission is Walmart’s fee for selling the item.
  4. Group items that need the same price. A Variant Group connects related items, such as blanket colors. Enter 1 for each item in one group, 2 for another group, or leave blank to price separately. Grouped items share promo vanity and everyday prices.
  5. Review your prices. Lowest Possible Retail covers the costs included in the calculator. Promo Vanity Retail is the rounded promotional price. EDLP means everyday low price, the regular price outside a promotion. EDLP pricing allows a 20% discount while protecting the lowest possible retail.
  6. Review costs and download results. Retail Spread is the difference between calculated and rounded prices. Available Funds is what remains after item cost, fulfillment, commission, and planned advertising. Show costs at lets you view costs at different prices without changing the suggested retails. Bulk results can be downloaded to Excel.

Shipping from your warehouse to Walmart and returns are not included.

How your retail is calculated

Start with your Cost, calculate the lowest possible retail, then apply your selected Vanity Pricing option to promo and everyday pricing.

1. Build your Cost

Landed=Materials+Duty+Freight
Cost=Landed+Internal Markup

Internal markup is Idea Nuova’s markup, already included in the cost from leadership. Enter that Cost once; the calculator does not add another markup.

2. Find the lowest possible retail

Lowest Possible Retail=
Cost + Shipping & Fulfillment
1 − Commission % − Advertising %

This is your floor for the costs included here. It rounds up to cents and, when needed, to cover cent-rounded fees. Vanity rules never change this floor.

Commission is Walmart’s selling fee (15% by default). Advertising is your Walmart Connect allowance (5% by default). Both are adjustable percentages of retail and must total less than 100%.

3. Set promo vanity using your selection

The Vanity Pricing dropdown controls both promo and EDLP vanity prices:

  • Current rules: dollar endings 3, 4, 8, or 9.
  • Closest .99 / whole dollar: every dollar is eligible; for example, $21.36 → $21.99 and $52.20 → $53.00.
  • 4 and 9 only: dollar endings 4 or 9; for example, $21.36 → $24.99 and $52.20 → $54.00.

Allowed prices below $50 end in .99; allowed prices from $50 upward end in .00. Promo vanity can round down by less than 15¢; otherwise it rounds up to the next allowed price. A difference of exactly 15¢ rounds up. Promo vanity may therefore be slightly below the floor.

Promo Spread=Promo Vanity Retail−Lowest Possible Retail

4. Set everyday pricing with room for 20% off

EDLP Retail=Lowest Possible Retail÷0.80

EDLP is your everyday, non-promo retail. Dividing by 0.80 makes it 25% above the floor, leaving room for a 20% discount. EDLP rounds up to cents.

EDLP Vanity applies your selected vanity rule, but never rounds below EDLP Retail. Taking 20% off EDLP Vanity will therefore stay at or above the floor. That discounted amount does not necessarily equal Promo Vanity Retail.

EDLP Spread=EDLP Vanity−EDLP Retail

5. Keep variants at the same price

In bulk uploads, matching Variant Group values share the highest member’s Promo Vanity Retail. Shared EDLP Retail is the group’s highest floor ÷ 0.80, rounded up; shared EDLP Vanity uses your selected rule with 20%-off protection. Blank groups stay independent.

Each item keeps its own Lowest Possible Retail and Promo Spread. Group pricing stays blank until every member has a successful calculation.

Example · $10 Cost + $6 shipping

$10 + $6
1 − 15% − 5%
=$20 floor
$20 ÷ 0.80=$25 EDLP

$20 floor = $10 Cost + $6 shipping + $3 commission + $1 advertising.

Vanity prices then depend on your dropdown selection. This is an illustrative example, not a shipping quote.

Reading the cost breakdown: Advertising, commission and shipping dollars follow the selling price chosen in “Show costs at” above the bulk results. Spreads show price differences before additional fees; they are not automatically extra advertising budget or profit.

What shipping includes: UPS and FedEx use published residential estimates equally averaged across zones 2–8. Bulk retail uses WFS only. Commission uses your entered rate and does not automatically detect category-specific rates. WFS estimates assume non-apparel, non-hazardous items; clothing and hazardous-material surcharges are not included. WFS includes fulfillment, applicable ITS, and one month of storage. Shipping from your warehouse to Walmart and returns are excluded.

WFS’s $1 fulfillment fee for prices below $10 is included in the floor when applicable. At the boundary, $10 can avoid that fee. If Promo Vanity drops from a floor of $10 or more to below $10, an additional $1 fee applies at that promo price and is called out separately.

Use final parcel measurements for UPS/FedEx and the item’s own packaging for WFS. Returns, prep services, taxes, and overhead are not added. “Lowest possible” covers only the costs included in this calculator.

Available funds after planned expenses

Available Funds=Selling Price − Cost − Shipping & Fulfillment − Commission − Planned Advertising

Fees are recalculated and rounded to cents for each selling price. Promo and EDLP Available Funds use their vanity prices. Spreads remain price differences before fees. Negative available funds indicate a shortfall. Returns and warehouse-to-Walmart shipping are excluded.

Applies to single-item and bulk results. Below $50: .99 endings. From $50: whole dollars. Promo may round down by less than 15¢; EDLP always protects 20% off.

Pricing & costs per item

* Internal markup is Idea Nuova's markup, already included in the cost provided by leadership.
Commission and advertising are percentages of each scenario’s selling price.

Shipping & fulfillment

UPS and FedEx average all zones (2–8). WFS includes fulfillment, applicable ITS, and one month of storage. Shipping from your warehouse to Walmart and returns are excluded.

Calculate your retail in bulk

Upload your completed Excel template to calculate retail prices for up to 200 items at once.

  • What to enter: Item details, package measurements and Cost.
  • Advertising and commission: Enter 5 for advertising to allocate 5% of the retail price to ads. For example, a $20 retail allocates $1 to advertising. Leave percentages blank to use 5% advertising and 15% commission.
  • Items that need the same price: Give them the same Variant Group number. For example, enter 1 for a blue blanket and 1 for a pink blanket to give both the same suggested retail. Use 2 for a different group, or leave it blank to price an item separately.
  • WFS costs included: Fulfillment, one month of storage and any applicable inventory transfer fee (ITS).

Shipping from your warehouse to Walmart and returns are not included.

Download the template, fill in your items, and upload. Calculations start automatically.

Walmart commission and your planned advertising are percentages of the selling price, so their dollar amounts change between promo and everyday pricing. Choose a price to see its cost breakdown. This only changes what you’re viewing. Your retail prices and available funds stay the same.