How Does Pricing Work?
Pricing is a tiered system:
- Bid price is a sum of all the room prices plus the shipping price and hotlist fee.
- Room prices are a sum of all the product prices.
- Product prices are a sum of all the product pricing formulas, attribute prices, and modification prices.
- Modification prices are a sum of any modification pricing formulas and attribute prices.
Pricing Breakdown
A product's pricing breakdown (see Image 1) can be viewed by clicking on the product price wherever it is visible (on product lists or the product editor). The pricing breakdown shows a breakdown of all the pricing that goes into the final price of the product, any green line items can be clicked to see a popup of the pricing formula and it's variables (see Image 2). If there are any errors in the pricing formula or any of it's variables, it will be outlined in red and will tell you the error in the formula breakdown.
Image 1. Pricing breakdown of Base 3 Drawer product.
Image 2. Formula Breakdown of Drawer Front Option Sum formula.
While in edit mode, all pricing formulas will be shown, even those that are $0.00. By clicking the edit icon on the right end of the line item, the pricing formula editor will open for this pricing formula in a new tab (see Image 3).
Image 3. Pricing breakdown in edit mode.
Pricing Versions
In order to ensure accurate pricing on orders as pricing factors change, we keep a record of all pricing factors (materials, door styles, product base prices, etc.) when they are changed. These records are called Versions and can be viewed in the database admin by clicking on the History button from within the item editor (see Image 4). A Version is basically a snapshot of the database entry when it is saved so we can keep track of what changes and when.
All bids are assigned a Pricing Date when they are created which determines which Version should be used. For example, a bid with a pricing date of August 22th, 2023 would use the Version from Nov. 10, 2022, 12:01 a.m. in the image below because it is the first Version before the pricing date. If a bid were created today, it would use the Version from Aug. 25, 2023, 12:02 p.m. because it is the most recent Version before the pricing date. This essentially allows us to lock in pricing for dealers on bids even though prices change quite frequently.
Image 4. Version history for Oak, White, Rustic Plain Sliced.