Community Forums

Stock Control

General discussion about OpenCart - Only post here if you can't place it on any other board.

Re: Stock Control

Postby Qphoria » Mon Mar 21, 2011 6:01 pm

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.
Image Image
Donate!|OpenCart Basics|GeoZones
Help me get more development cloud storage - Click Here to get DropBox
User avatar
Qphoria
Administrator
 
Posts: 18242
Joined: Mon Jul 21, 2008 7:02 pm
Donate to Qphoria

Re: Stock Control

Postby epanico » Wed May 18, 2011 2:19 pm

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 ;D

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

Postby Ariskos » Wed Aug 31, 2011 2:34 pm

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?
Web Developer specialized in Opencart. Visit my extensions:
(1)SKU Generator 1.5.x / (2) Opentasks
User avatar
Ariskos
 
Posts: 31
Joined: Wed Jun 08, 2011 1:28 pm
Location: Athens

Re: Stock Control

Postby mystifier » Thu Sep 01, 2011 1:45 pm

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.
User avatar
mystifier
 
Posts: 779
Joined: Tue May 18, 2010 9:15 am

Re: Stock Control

Postby 900pixels » Mon Sep 05, 2011 2:50 am

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.
900pixels
 
Posts: 111
Joined: Tue Dec 08, 2009 5:36 am

Re: Stock Control

Postby Xsecrets » Mon Sep 05, 2011 4:20 am

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.
Xsecrets
 
Posts: 5042
Joined: Sat Oct 24, 2009 7:51 pm
Location: FL US

Re: Stock Control

Postby 900pixels » Thu Sep 08, 2011 9:56 am

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

Postby DougieMac » Wed Feb 01, 2012 6:42 pm

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
DougieMac
 
Posts: 2
Joined: Wed Feb 01, 2012 2:57 pm

Re: Stock Control

Postby barry100 » Thu Mar 08, 2012 8:06 pm

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

Previous

Return to General Discussion

Who is online

Users browsing this forum: png22 and 29 guests

Hosted by Arvixe Web Hosting