Special Offers Control Panel

Standalone Inventory menu program that builds a ranked shortlist of active, in-stock catalog products (excluding discontinued -Disc- models) and lets the operator assign a percent-of-profit cut that becomes an oc_product_special row. Ranking modes include fastest/slowest sellers, newest/oldest inventory, products with no sales, highest retail, highest profit margin, and largest available stock. Sales volume is read from pd_orders_accumulated. Product titles join oc_product_description with language_id = 1. Excluded SKUs in pd_special_sales_excluded_products and pd_special_offers_excluded_products are omitted. Existing specials expand in a nested drawer under each product name.

Operator guidelines

• Choose a ranking type, time span, customer group, and display count, then click Create list of products.
• Viewing filters live in the URL (GET) so the shortlist survives refresh, column sorts, and pagination jumps.
• Set offer start and end dates with the native date controls. Empty dates default to today.
• Enter a percent of profit to take off each SKU on the current page, then create the specials (POST). Each group uses its oc_product_discount quantity-1 price when present. Groups 3 and 7 are omitted.
• Click a product name badge to expand current oc_product_special dates without leaving the grid.