Essentially, if you get in bed with Walmart, you will make the money you want in the short term, but eventually, if you want to keep that money coming in, you will lose control of your pricing.
This doesn't even get into exclusivity requirements for products, etc.
See Snapper lawn mowers, for some insight to this process.
Make a deal with the devil... and you'll end up at the behest of the devil.
They do. And they'll start making demands about how you run your business (e.g. "stop buying this local, you need to buy it from China and here are a list of companies we recommend you use"). You will have lots of sales through Walmart but you have to be careful that they don't destroy your business on a whim. See Dill Pickle Co for an example.
That nationwide Wal-Mart "every day low price" cannibalized sales of smaller pickle units at other stores and Vlasic saw it's profits on pickles fall 25%.
In unrelated news, Vlasic filed for bankruptcy a few years later.
The entire tale is told in much better narrative by a 2003 Fats Company article: http://www.fastcompany.com/node/47593/print
The issue quickly becomes a "damned if you do, damned if you don't" issue. If you supply them, they quickly drive your margins to the point where you have to offshore to stay in business. If you don't supply them, you get cut out of the largest retailer in the US and lose that way. Either way, you are screwed.
As I mentioned earlier, if you replace your ERP system (or upgrade it past a certain dollar point), you have to modify it so that Walmart has direct access to the internals. This means that they're placing (and cancelling) orders directly in your system without intervention (if you aren't careful, this can foul up your staffing). This also means that they know your costs, expenses and margins. You aren't going to have any negotiating power when it comes time for them to lower your prices.
But any company making a deal with Walmart should know this by now, so who is really to blame?