Special Sale

Standalone Inventory menu program that walks an operator through preparing a special sale, previewing calculated sale prices, backing up the current oc_product_special rows, and making the new offers live. Sale definitions are stored in pd_special_sale. New rows are written as working drafts (live = W) so they can be previewed and deleted before a live cutover (live = L). Products listed in pd_special_sales_excluded_products, plus disabled, out-of-stock, discontinued, or part-flagged catalog rows, are omitted from the offer set. Each customer group receives its own special price: the regular Base Price comes from oc_product_discount (quantity 1) when present, otherwise from oc_product.price, then the sale takes a percentage of that group's remaining profit and clamps % off that same base.

PREPARE NEW SPECIAL OFFERS:

1. Add a new special sale entry into the database.
   All products will be included except the products listed to be excluded from special sales, disabled, out of stock, or discontinued.
2. Click on Preview Offer to view calculations for each new special offer.

MAKE NEW SPECIAL OFFERS LIVE:

1. Click Backup Current Offers to park current specials for the sale's store context (All Stores clears the full backup table; any other store_id parks only products assigned in oc_product_to_store) and adjust their dates for after the special sale.
2. Click Create New Offers to empty current specials for that same store context and add the new special offers. A sub-store sale will not wipe Journal 3 main-storefront specials. (Takes a while)
3. Clear the browser cache to see the new triangle color.
4. Check the special offers on the website.
5. Create the rotating banner for the special sale.
6. Create the Shipping Easy Email Campaign and send out the emails.
7. If product prices have changed, click UpdatePrices to update the sale price from the product's current price for each existing Special Offer.
8. When the Special Sale has ended, the special sale products are removed and the previously backed up special offers are inserted.