I'm working on a store with about 80,000 skus, on a quad-core dedicated server with 12GB ram and applying a Catalog Price Rule is just not working for some reason. No discounts show, even after i've done the following:
- Create Rule
- Status: Enabled
- Customer Groups selected
- From/To Dates created
- No Conditions set (sitewide)
- Actions - apply percentage of original price, 20 percent
- Click "Save & Apply
After a good 5 minutes, i'll get the green notification saying the rule has been applied. I'll then proceed to flush Cache and also Re-Index. Proceeding to view the site on the front-end, It's as if nothing ever happened. Not a template issue because it's worked previously.
I was assuming it may have to do with Cron not being executed yet, so i manually have accessed Cron.php in my web browser- which hangs and eventually gives the entire site a 503 error which lasts for a couple minutes and goes away.
I've tried everything from upping Memory Limits in PHP / MySQL settings and Max_Execution_Time, and I'm at my wits end as I just can't get this to work.