Stock by Attribute v4.0 addon for v1.3.5-1.3.9

[vibrantdesignz]

Hello. I am trying to figure out this SBA addon. My question is, say I have 3 pink shirts (S,M,L) and I have 1 of each size. These shirts have a monogram on them. Say I also am using these same 3 shirt for a different product that has a different monogram. Since these will be personalized I don't make them upfront.

HOW do I put the stock of these attributes when they are used on different products using the color attribute to define what is in stock.

[bn17311]

Hello. I am trying to figure out this SBA addon. My question is, say I have 3 pink shirts (S,M,L) and I have 1 of each size. These shirts have a monogram on them. Say I also am using these same 3 shirt for a different product that has a different monogram. Since these will be personalized I don't make them upfront.

HOW do I put the stock of these attributes when they are used on different products using the color attribute to define what is in stock.

do you only have a few monograms or is this something you want to do over lots of products using the same 3 tshirts

bn

[vibrantdesignz]

I mainly want to define the stock by the size and color. On adult shirts I have 2-3 products that use the same size/color shirts.

Product #1: Left chest monogram
Product #2: Applique/Pocket Monogram

Both listed products use the same size/color shirts.
The monogram part is just an addon for people to choose the variety of the shirt.

[DivaVocals]

I mainly want to define the stock by the size and color. On adult shirts I have 2-3 products that use the same size/color shirts.

Product #1: Left chest monogram
Product #2: Applique/Pocket Monogram

Both listed products use the same size/color shirts.
The monogram part is just an addon for people to choose the variety of the shirt.

Is this a GENERIC stock pool to which an OPTIONAL applique/monogram can be applied?? You say that you have 2-3 products which use the same size/color combo.. Do you keep these size/color combos as unique counts separate or are they from the SAME pool of shirts..

Let try and clarify what I mean.. You have 20 large pink shirts in total. Are 10 allocated for one product and 10 allocated for another product with the ONLY difference between the two products being the applique/monogram??

Either way if I understand you correctly, are you saying that the applique/monogram is an OPTIONAL attribute and is not to be INCLUDED in the stock tracking..

[vibrantdesignz]

The amount of shirts are the total shirts I have. I have 3 shirts in total that I want to use for both listings. Yes, the monogram/applique is an optional attribute.

[DivaVocals]

The amount of shirts are the total shirts I have. I have 3 shirts in total that I want to use for both listings. Yes, the monogram/applique is an optional attribute.

That's what I thought you were getting at.. the short answer is you can't have TWO products sharing the SAME stock.. If you have 10 large pink t-shirts you can't SHARE them with two products..

SBA allows you to create product variants based on attribute combos. (color/size for example) you can then track stock for each variant.. So if you have two products which vary because of a logo or some other variance you will need to decide how many of your large pink t-shirts will be allocated to each product.

[vibrantdesignz]

Okay. I thought that was probably the answer, but I wanted to double check. Thank you for you quick reply. I appreciate the help.

[CoffeeOwl]

I took over the size that somebody else built and then disappeared. The site uses Zen Cart 1.5.0 and some old version of the Stock by Attribute addon. Its files have a date stamp of 10/16.12.

As of 3/2/14, stock numbers stopped updating when a product with an attribute is sold. The addon was working flawlessly before that. No changes were made to the site around that time, so my guess is something changed in the host environment. The host is GoDaddy, pretty unhelpful with the issue.

I want to update the addon to its latest version, but http://www.zen-cart.com/downloads.php?do=file&id=202 says the addon only works with Zen Cart 1.5.1.

Do I have to update Zen Cart in order to update the addon? I would rather not doing it right now because the previous designer left no documentation, and I am still wandering through the code figuring out what other addons were used, etc. I feel that without knowing what's under the hood I may break something else if I update Zen Cart to 1.5.1.

The stock problem can't wait until I am done, so I would rather update only Stock by Attributes right now. Is it safe? Or will I end up with a broken site?

The site in question is at http://southernwhimzy.com/.

[CoffeeOwl]

Forgot to add: the Stock by Attributes addon currently in use has a string in its files like this one:

version $Id: products_with_attributes_stock.php 389 2008-11-14 16:02:14Z hugo13 $

I can't figure out what version it is, but maybe someone else knows.

[Randolph Hoppe]

Attempting to install SBA 1.5.3 on my Z-C 1.5.1 install - at the end of a long upgrade from 1.3.8.a running SBA (probably) 4.7. After merging and uploading, I run the Full/Upgrade DB Install and receive an error.

Log reports:

PHP Fatal error: 1054:Unknown column 'sort' in 'products_with_attributes_stock' :: ALTER TABLE `products_with_attributes_stock`
ADD COLUMN `customid` VARCHAR(255) NULL DEFAULT NULL AFTER `sort`; in path/to/store/includes/classes/db/mysql/query_factory.php on line 120

Any thoughts or suggestions? I'm stumped.