This Christmas season was intense. Had some jarring personnel issues alongside the highest sales I've seen by far. We sold $50K during the Black Friday - Cyber Monday weekend, which is high when our average sales are around 2k per day. Shipped over 1,000 orders on some days.
The programs I built summarized remaining quantity, sold quantity, average sold per day, and the amount of time until sellout. Informed by projections from the previous year, I was able to raise and lower prices based on projected sell-out. Ours is a business of volume -- our fixed price is relatively small compared to operating costs -- so my goal is to price to sell-out given a certain quantity and time frame.
I priced several lower-quantity items quite above the average price, and with few exceptions they all sold-out by Christmas. Rather than bulk pricing, using SAS helped me fine-tune prices in a timely manner. Usually, sales optimization suffers when order fulfillment overwhelms; this year I did both.
