Joyce,
Don't forget to check with the customer service centers for Walmart, K-Mart, etc. ask if they can look up inventory from across the country for a pallet sitting somewhere. I bought "all remaining stock" of L'Oreal Ultra Rich shampoo many years back from K-Mart when it was discontinued. Assuming shelf-life isn't an issue, I should have shampoo until I'm 70.
At the time, I was hyper allergic to everything I'd tried on the market and the Ultra Rich product was the only thing I could handle. These days, either the products or my sensitivities have mellowed. Phew!
Good luck with your search!