envy2000 Posted March 13, 2003 Share Posted March 13, 2003 hey we do a lot of drop shipping, and therefore don't have inventory. i am trying to get items listed even if they don't have a stock value, but it isn't working for me. Under Admin>stock> Settings are: Title Value Action Check stock level false Subtract stock true Allow Checkout true Mark product out of stock *** Stock Re-order level 0 But when you purchase something of 0 inventory, it sets the inventory to -1 and the status to inactive/out of stock. What else do i need to do? Link to comment Share on other sites More sharing options...
Guest Posted March 13, 2003 Share Posted March 13, 2003 Try changing "subtract stock" to false???????? :D Link to comment Share on other sites More sharing options...
envy2000 Posted March 13, 2003 Author Share Posted March 13, 2003 the problem with that is that i have some items that actually are in stock that i would like to track. i guess that once it hits zero there is no point of -stock, and i don't want it to flip to out of stock. Link to comment Share on other sites More sharing options...
Guest Posted March 13, 2003 Share Posted March 13, 2003 Leave your settings alone and the drop ship stuff will just continue to go "negative". You will need to keep an eye on your in-stock merchandise because it will not show "out-of-stock" at the check-out if you run out. Link to comment Share on other sites More sharing options...
envy2000 Posted March 13, 2003 Author Share Posted March 13, 2003 the problem is though that when the item hits -1 it doesn't show up in the catalog. Link to comment Share on other sites More sharing options...
mattice Posted March 13, 2003 Share Posted March 13, 2003 What happens is the stock substacting has flagged the product status to zero. So if you have the correct settings now try a mySQL update query that sets all status that is 0 to 1 That should fix it I think. Mattice "Politics is the art of preventing people from taking part in affairs which properly concern them" Link to comment Share on other sites More sharing options...
Guest Posted March 13, 2003 Share Posted March 13, 2003 Give your drop ship items large amounts of stock? 10000 in stock? The stock tracking process could use some work it appears....... :? Link to comment Share on other sites More sharing options...
envy2000 Posted March 13, 2003 Author Share Posted March 13, 2003 matt. the problem with setting to 1 (or 10000 etc) is that i would like to be able to track what i actually do have in stock. Link to comment Share on other sites More sharing options...
mattice Posted March 13, 2003 Share Posted March 13, 2003 Okay... then the only solution will be to REMOVE the following from all your queries: <snip> and status = 1 </snip> I'd do it differently; I'd replace that bit of code EVERYWHERE with something like $use_status Then in application_top.php you do: $use_status = ''; // empty OR ' and status = 1 ' (mind spaces!) Get the idea? Should work. Untested. Not my fault. Wasn't there. :) Mattice "Politics is the art of preventing people from taking part in affairs which properly concern them" Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.