Stock Control
29 posts
• Page 2 of 2 • 1, 2
Re: Stock Control
RArch wrote:Hi, Just joined as we are evaluating OpenCart as a replacement for our current system. Reading through the forum I came across this topic. We discovered a similar situation selling certain items with options and the following setup steps may help.
For an example, take demo data in particular the iPod Classic product. Say we have 15 x 1GB and 5 x 8GB versions in stock, giving us a total quantity of 20 for this product.
Within the Product Data tab for the iPod Classic we set a Quantity of 20 and Subtract Stock 'Yes'.
Within the Option Tab, for the 1GB version we have a Quantity of 15 and Subtract Stock 'No'. Then for the 8GB version we have a Quantity of 5 and Subtract Stock No.
The total stock quantity of the options equals our stock total 20 which held against the Product.
As a customer purchases the products both stock levels drop, ie buy a 1GB iPod and the overall stock total on the Product will drop to 19 and the 1GB option version also drops to 14.
Now the Quantity of the Product is correct being 19 and interrogating the Options data for the Product breaks it down to 14 x 1GB and 5 x 8GB versions.
Please don’t jump all over me but I don’t see what the problem is!
Well what you are doing should work fine, but basically better to just ignore the product stock and leave the options to control it. The easiest way to do this is to set product stock to 9999 and the options to use the correct stock. We will improve this process in future versions but this should work for now.

Donate!|OpenCart Basics|GeoZones
Help me get more development cloud storage - Click Here to get DropBox
-

Qphoria - Administrator
- Posts: 18242
- Joined: Mon Jul 21, 2008 7:02 pm

Re: Stock Control
Hello - I'm going to breathe some life back into this thread, since it seems that there are more than a few folks out there that would really like stock control to work given the examples in this thread. I'm new to OpenCart, and I'm not a stellar programmer, but it seems like someone should be able to write a mod that would treat multiple product options as one. I'll use eyeglass frames as an example, since that's my gig
In this example, Option 1 is the way I must do things today if I want OpenCart to maintain correct stock.
Option 1 - Size - Color
Option 1 Values - 53 / 18 / 145 - Black
58 / 18 / 145 - Black
53 / 18 / 145 - Gun Metal
58 / 18 / 145 - Gun Metal
My idea would be to keep option 1, but hide it. The rest of the options would be visible.
Option 2 - Size
Option 2 Values 53 / 18 / 145
58 / 18 / 145
Option 3 - Color
Option 3 Values Black
Gun Metal
Could a mod be created that would place a check box on the options admin screen that would make Option 1 the "master" option? And when the option 2 and 3 values are selected on the product page some magic happens on the back end so that only the Option 1 values are really used in the inventory process? And then, also by some magic, the option 2 and 3 values are what show up in the cart and on the invoice?
I've got $20 ready for the first programmer/magician to make this happen!
In this example, Option 1 is the way I must do things today if I want OpenCart to maintain correct stock.
Option 1 - Size - Color
Option 1 Values - 53 / 18 / 145 - Black
58 / 18 / 145 - Black
53 / 18 / 145 - Gun Metal
58 / 18 / 145 - Gun Metal
My idea would be to keep option 1, but hide it. The rest of the options would be visible.
Option 2 - Size
Option 2 Values 53 / 18 / 145
58 / 18 / 145
Option 3 - Color
Option 3 Values Black
Gun Metal
Could a mod be created that would place a check box on the options admin screen that would make Option 1 the "master" option? And when the option 2 and 3 values are selected on the product page some magic happens on the back end so that only the Option 1 values are really used in the inventory process? And then, also by some magic, the option 2 and 3 values are what show up in the cart and on the invoice?
I've got $20 ready for the first programmer/magician to make this happen!
- epanico
- Posts: 1
- Joined: Wed May 18, 2011 2:05 pm
Re: Stock Control
Any news about this request to be able to combine products' options?
There is a big need of such a feature. Has it changed (released) anything new which manage this?
There is a big need of such a feature. Has it changed (released) anything new which manage this?
-

Ariskos - Posts: 31
- Joined: Wed Jun 08, 2011 1:28 pm
- Location: Athens
Re: Stock Control
Just got alerted about a new post to this thread so took a look in hope; haven't seen the forum for months.
This one omission kills Opencart for me and for the three sites I did, it is the one aspect that they all complain about and made me stop using it.
I would also be very interested in any developments on this front. I have just seen This Extension which sounds interesting but there is no demo to allow it to be assessed.
This one omission kills Opencart for me and for the three sites I did, it is the one aspect that they all complain about and made me stop using it.
I would also be very interested in any developments on this front. I have just seen This Extension which sounds interesting but there is no demo to allow it to be assessed.
Free v1.4.9 Extensions: Default Specials | Improved Search | Customer Activity Report | Customer Groups | Royal Mail With Handling | Improved Product Page | Random Products | Stock Report | All Products
-

mystifier - Posts: 779
- Joined: Tue May 18, 2010 9:15 am
Re: Stock Control
Hi mystifier,
Can I ask what cart you are using as an alternative which handles multiple option combinations as individual SKUs?
I have a shoe company that wnats a cart that links to their stock control system and the only way I can see opencart doing it is if I have only one level of options per product (e.g make size the only option and treat different colours of the same style as individual styles - will make for lots and lots of products!)
Cheers.
Can I ask what cart you are using as an alternative which handles multiple option combinations as individual SKUs?
I have a shoe company that wnats a cart that links to their stock control system and the only way I can see opencart doing it is if I have only one level of options per product (e.g make size the only option and treat different colours of the same style as individual styles - will make for lots and lots of products!)
Cheers.
- 900pixels
- Posts: 111
- Joined: Tue Dec 08, 2009 5:36 am
Re: Stock Control
900pixels wrote:Hi mystifier,
Can I ask what cart you are using as an alternative which handles multiple option combinations as individual SKUs?
that's a very good question, and one I've asked him before, and never got an answer. He's been complaining that this missing feature kills opencart, but doesn't ever say which cart actually does have the feature. I know magento does, but it's a royal mess to try to use it.
OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter
- Xsecrets
- Posts: 5042
- Joined: Sat Oct 24, 2009 7:51 pm
- Location: FL US
Re: Stock Control
Yeah I looked at magento's way of tackling this and it seems very contrived.
- 900pixels
- Posts: 111
- Joined: Tue Dec 08, 2009 5:36 am
Re: Stock Control
This may be the wrong place to reply or put this, so apologies for that.
This thread seems to echo the problem I'd like to solve.
I make jewellery, and if I make :-
1)A bracelet containing 10 of 4mm Hematite stones, 10 of 6mm Hematite stones,5 of Coral stones, 14" of beading wire, 2 of terminations and 1 of clasp.
2)A necklace containing 10 of 6mm Hematite, 10 of 10mm Hemeatite and 1 of 12mm Quartz, 18" of gold chain (option of silver chain) , 1 of pendant bail (silver or gold dependent on chain selected), 3 of 4mm jump rings (silver or gold dependent on chain selected) and 1 of clasp (silver or gold dependent on chain selected).
If I now sell those item 2 items, I'd like a way to have my stock of the bracelet drop by 1, the necklace drop by 1 and also have my stock of each bead/stone/material used drop by the right amount. I'd then like oc to alert me when my stock of beads/stones/materials drops below a certain level.
From reading here, assuming I am reading it right, it would seem that at the moment I'd need to set up a product entry for each and every type of stone/bead/material in order to have any form of stock control. Bearing in mind that I have an inventory of 1000's of different beads/stones/materials, this would be extremely time-consuming.
Anyone have any other suggestions as to how to resolve this? Thanks in advance
This thread seems to echo the problem I'd like to solve.
I make jewellery, and if I make :-
1)A bracelet containing 10 of 4mm Hematite stones, 10 of 6mm Hematite stones,5 of Coral stones, 14" of beading wire, 2 of terminations and 1 of clasp.
2)A necklace containing 10 of 6mm Hematite, 10 of 10mm Hemeatite and 1 of 12mm Quartz, 18" of gold chain (option of silver chain) , 1 of pendant bail (silver or gold dependent on chain selected), 3 of 4mm jump rings (silver or gold dependent on chain selected) and 1 of clasp (silver or gold dependent on chain selected).
If I now sell those item 2 items, I'd like a way to have my stock of the bracelet drop by 1, the necklace drop by 1 and also have my stock of each bead/stone/material used drop by the right amount. I'd then like oc to alert me when my stock of beads/stones/materials drops below a certain level.
From reading here, assuming I am reading it right, it would seem that at the moment I'd need to set up a product entry for each and every type of stone/bead/material in order to have any form of stock control. Bearing in mind that I have an inventory of 1000's of different beads/stones/materials, this would be extremely time-consuming.
Anyone have any other suggestions as to how to resolve this? Thanks in advance
- DougieMac
- Posts: 2
- Joined: Wed Feb 01, 2012 2:57 pm
Re: Stock Control
I am using the extension named above and it works well but the only thing i would like to see as an improvement where the number of products is shown next to the product colour when the second selection is made. ... mm think ill go ask the dv if he can do it.
- barry100
- Posts: 12
- Joined: Fri Apr 22, 2011 11:30 am
29 posts
• Page 2 of 2 • 1, 2
Who is online
Users browsing this forum: png22 and 29 guests













