Pricing strategy · NetSuite TD3016323

Pricing Optimization Analysis

Price realization, discount patterns, price movement, and segment pricing for the product catalog over the trailing twelve months, and why this account's pricing is not a discount problem.

Prepared 2026-09-23 · Subsidiaries 1-3, elimination excluded · Source: NetSuite sales lines via SuiteQL · Prompt: Pricing Optimization Analyzer, NetSuite AI Prompt Library v1 · Standard Review depth

Executive Summary

This account does not run a list-and-discount pricing model, and that is the first thing the analysis has to say, because the prompt assumes one. Every sales line in the trailing twelve months was booked at the single "Base Price" level, the item list price is not exposed to the query layer, and no price-level table is populated. The nearest available stand-in for a list price is each item's most common transaction price, and against that benchmark realized prices are 119%: above list, not below. Prices in this account float. Of 109 products with at least three sales in each half of the year, 29 went up more than 5% between halves, 32 went down, and the median change was zero.

Read on its own terms, discounting is rare. 308 of 2,782 product lines (11.1%) were sold below the item's usual price, for $4,472 of discount in the year, or 0.4% of product revenue. What discounting there is runs deep and one-off: a $900 mattress sold twice at $400, a $360 leather valise at $129. Those are the lines an approval policy exists for. The 80 lines sold at zero, which a naive discount query would flag as 100% discounts, are components of bundled sales that carry their price on another line of the same invoice, and are not leakage. Product gross margin is 43.6%, above the 40% threshold.

Price Realization Analysis

Price movement during the year

Based on: the average rate for each product in the first half of the window (to March 22, 2026) against the second half. The largest movers are below. The mattress and cosmetics lines moved most, in both directions, and the sofa table and nightstand in the Estes Park collection came down about a fifth.

On average each product was sold at 3.6 distinct prices during the year. That is consistent with periodic price changes on the item record rather than with negotiated discounts, and it is why the price band analysis below has most of its revenue at or above the benchmark.

Price bands

The lines below 70% are the zero-priced bundle components (80 lines on 20 invoices, 10 items, all in the Miscellaneous class) plus a handful of deep one-off discounts. Every zero-priced line sits on an invoice that also carries priced lines.

Discount Pattern Review

Discount defined as: a line rate below 99.9% of the item's modal price. Sorted by discount dollars.

Two patterns are visible. The first is a small set of items where roughly half the lines fall a little below the usual price, by a dollar or two, which is price movement. The second is the lowest-price column: a $900 item at $400, a $360 item at $129, a $250 backpack at $122. Those are a few lines each and small in total, but they are the transactions a discount policy should have a record of, and the prompt flags discount policy for human review.

Segment Pricing

Segments: the customer category on the customer record. Realization is revenue divided by units times usual price.

Consumers and retail accounts pay above the usual price more often than manufacturing accounts do, which is the expected shape: the manufacturing customers are the largest, buy in volume, and account for most of the discount dollars, small as they are. There is no segment where discounting is frequent. The Information Technology, Consulting, and Construction categories buy the delivery service almost exclusively and were excluded with it.

Margin Analysis

Product gross margin is 43.6% on $1,174,479 of revenue, using the cost estimate on each line. Because discounting is so limited, margin by price band is nearly flat, and the margin story in this account is a product-mix story rather than a pricing story. The product line profitability analysis run alongside this report covers it.

Optimization Recommendations

Price changes, discount policy changes, and segment pricing strategy require human review under the prompt's controls. The recommendations above are measurement fixes first and pricing actions second.

Appendix: Data Lineage

Adaptations from the prompt's templates: item.baseprice is not exposed to SuiteQL and the pricing table returned no rows, so the list price is replaced by each item's modal transaction price and every realization figure is relative to that; the delivery service item, priced per engagement with rates that vary tenfold, is excluded from the product pricing statistics; transaction.subsidiary is not exposed, so the elimination subsidiary is excluded through the line; price movement over time was computed in code from the line history because the templates have no time dimension.

SELECT t.id, t.type, t.trandate, t.entity, tl.item, BUILTIN.DF(tl.item), NVL(BUILTIN.DF(tl.class),'None'),
       NVL(BUILTIN.DF(tl.price),'None') AS price_level, tl.rate, -tl.quantity, -NVL(tl.netamount,0), -NVL(tl.foreignamount,0), NVL(tl.costestimate,0)
FROM transaction t JOIN transactionline tl ON tl.transaction = t.id JOIN item i ON i.id = tl.item
WHERE t.type IN ('CustInvc','CashSale') AND t.posting = 'T' AND tl.mainline = 'F' AND tl.taxline = 'F' AND tl.subsidiary <> 4
  AND t.trandate >= ADD_MONTHS(SYSDATE, -12) AND i.itemtype IN ('InvtPart','Assembly','NonInvtPart','Service')

SELECT c.id, NVL(BUILTIN.DF(c.category),'None') FROM customer c

Appendix: Assumptions and Verification

Confidence: 90% that discounting is rare in this account; 60% in the realization percentages, which depend on the substitute benchmark; the recommendation to maintain a list price does not depend on either.