I haven't completely abandoned the cleaning isle at the grocery store however. I did discover that you can refill the foaming hand soap dispensers with any soap you like. Just dilute the soap with water. It really cuts down on how much soap you use, especially if you have anyone in your house that likes to double or triple pump. I've been using Dr. Bronner's Peppermint castile soap in the kitchen and a lavender castile soap made by Seattle Organics. It seems that you're supposed to use a 3:1 or 4:1 water to soap ratio, but I just eyeball it and probably err on the side of more water.
I saw today that Method has a new dish washing soap pump bottle. I buy the big jug of Kirkland dishwashing soap and refill an old grocery store sized bottle to keep on the counter. But the Method bottle is pretty, and the pump controls how much soap comes out. It seems crazy to pay 3.99 for a bottle of dish washing soap, but I only have to buy it once to get the pretty bottle and refill it with what ever i want. The reviews are mixed on the pump bottle, but I really want it to work. We'll see.