JackChar Posted July 4, 2003 Posted July 4, 2003 Hi, We are building a web site with osCommerce and run into a show stopper. It appears that we cannot use inventory or out of stock on the sizes of a product. Example. Product VL511N - Mens Motorcycle Jacket comes in sizes 36-60. I can set out of stock or use inventory count on the Product level but we need it on the size level. If we run out of size 40 but have all other sizes how do I stop people from ordering size 40. I cannot make each size a product. Help - this is critical. Jack Charrette [email protected]
equilla Posted July 4, 2003 Posted July 4, 2003 Hi Jack, My wife has a similar problem on her site and is currently managing this manually, which is not foolproof. To my knowledge there is not a contribution to do this, or I would be using it. I have got half way to coding one though. What is required is to add a quantity field for each of the attribute values and then only show those that have quantity of more than zero when the customer views the product. This much is easy....... Then the admin side needs a utility with which to update the available quantities for each size, color or whatever, again pretty straightforward to do..... Then the checkout process needs to be updated to decrement the quantities according to what the customer has purchased - it is this part that have yet to code - trying to do about 3 zillion projects at once has meant that I haven't gotten round to this yet. Course, if anyone else is working on a solution I'd be interested to here about it! Cheers, Mark Mark Stephens Contribs: http://www.oscommerce.com/community/contributions,1680 http://www.oscommerce.com/community/contributions,1467 http://www.oscommerce.com/community/contributions,1422
JackChar Posted July 4, 2003 Author Posted July 4, 2003 Thanks Mark, I am very new to osCommerce - just started looking at it this week. Can you (or anyone) give me some clues on how to proceed with this? I have done a lot of programming in the past including C but not with php. Any recommedations ie how to find the module I need etc. etc. Thanks Jack Charrette [email protected]
Guest Posted July 4, 2003 Posted July 4, 2003 To my knowledge there is not a contribution to do this, or I would be using it.Isn't this what QTPro does? --Matt
equilla Posted July 4, 2003 Posted July 4, 2003 Cool! You are absolutely right. Thanks for that - I'll be having a play with that over the weekend then. Cheers, Mark Mark Stephens Contribs: http://www.oscommerce.com/community/contributions,1680 http://www.oscommerce.com/community/contributions,1467 http://www.oscommerce.com/community/contributions,1422
JackChar Posted July 4, 2003 Author Posted July 4, 2003 Maybe but since I'm a newbie to osCommerce I didn't know and need advise from people like you but ... I cannot get on to their web site www.vary.net/qtpro - server not found?? Jack Charrette [email protected]
Guest Posted July 4, 2003 Posted July 4, 2003 Just download the package from the contributions area. I'm not sure what is up with the home page. Good luck, Matt
equilla Posted July 4, 2003 Posted July 4, 2003 Hmmm, this one's going to be interesting as I have options as images installed on my wife's site too (which was a painful experience and I really don't want to break it!). As the changed code in this contrib isn't commented I'm gonna have to compare line by line to install it :o( Mark Mark Stephens Contribs: http://www.oscommerce.com/community/contributions,1680 http://www.oscommerce.com/community/contributions,1467 http://www.oscommerce.com/community/contributions,1422
equilla Posted July 5, 2003 Posted July 5, 2003 OK, so I've had a chance to play with QTPro now on one of my demostores (doesn't matter so much if I break things!). QTPro is based on quite an old version, plus I have some contribs installed which impact some of the same files/database tables (additional images, improved attribute manager, etc). With a little judicioius use of Winmerge I managed to copy across the lines of code required to get it installed without losing any other features accidently. But, I don't think that QTPro is the complete solution here, unless I've missed something in the install. None of the files that are involved in the checkout process are modified and therefore the quantities for each of the options/values involved in a transaction are not updated. For example, if I have 10 of product A in Blue and 10 of Product A in Red, this contrib correctly adjusts the total for product A to 20 when I enter these details in admin. If someone buys a Blue product A then I end up with 19 in total in stock, but still 10 Blue and 10 Red as these values are updated automatically! Needs some more work before I can use it I think..... Cheers, Mark :roll: Mark Stephens Contribs: http://www.oscommerce.com/community/contributions,1680 http://www.oscommerce.com/community/contributions,1467 http://www.oscommerce.com/community/contributions,1422
equilla Posted July 5, 2003 Posted July 5, 2003 Oops, of course that last line of my example should read are NOT updated automatically! Mark Mark Stephens Contribs: http://www.oscommerce.com/community/contributions,1680 http://www.oscommerce.com/community/contributions,1467 http://www.oscommerce.com/community/contributions,1422
freezehell Posted July 5, 2003 Posted July 5, 2003 http://www.oscommerce.com/forums/viewtopic.php...highlight=qtpro download version 2.1 by paul here do a search for "qtpro" in the forum for more details.
equilla Posted July 5, 2003 Posted July 5, 2003 Excellent! I thought there would be an update on this by now, but when I did a search for qtpro on the contribs section this one didn't come up for some reason. Thanks again, Mark Mark Stephens Contribs: http://www.oscommerce.com/community/contributions,1680 http://www.oscommerce.com/community/contributions,1467 http://www.oscommerce.com/community/contributions,1422
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.