So there is a buy and a sell for each transaction which creates no net demand for bitcoins. And if you consider the alternative where I already have bitcoins because I mined them, then I have bitcoins and I send them to Overstock who sells them for dollars. In that case you actually create downward pressure on the bitcoin price (against the dollar) since there is no buy on my part to net against Overstock's sale of bitcoins.
But it may bring new users who buy/hold BTC, if they see it as a useful store of value or just for convenience sake to make future purchases. Overstock's CEO said they may start holding it for longer if they can pay their vendors in BTC or have derivatives that allow them to hedge against decline in value.
Also, because the exchanges charge a fee to convert to/from fiat (e.g. 1% in coinbase's case), that creates some incentive to stay as BTC.
(Of course, given the current volatility and volumes, it would make no sense for Overstock to do this yet.)