Attributes only appearing on some products

Hi,

I have gone through everything I can think off and searched all the forums but no one seems to have had this problem.

My attributes are only appearing on certain products. There does not seem to be any pattern to it. Price increase, number of attributes etc, it just seems totally random.

I haven't changed anything that i'm aware of, but even if I had, i would have thought it would effect all products, not just some.

The products that the drop-downs aren't showing on, seem to be picking up something in the background as prices are showing as 'starting at'.

Would anyone be able to look at the source file, see if anything that i'm not spotting.

Thank you

This is a link to one of the problem products: http://www.therummagehole.co.uk/~therumma/index.php?main_page=product_info&cPath=42_64&products_id=559

However, this product is working fine: http://www.therummagehole.co.uk/~therumma/index.php?main_page=product_info&cPath=3_4&products_id=1

Where is the check stock script coming from?

Are all of your products 'priced by attribute' or are they mixed?

What other modules do you have installed that would meddle with the tpl_product_info_display.php?

Are all of your products 'priced by attribute' or are they mixed?

What other modules do you have installed that would meddle with the tpl_product_info_display.php?[/QUOTE]

They are mixed, some have attributes and some don't. I have 'stock by attributes' installed (by POTTERYHOUSE), and saveforlater_1.4 but don't think this uses that file.

Was working fine after both of these modules were added.

therummagehole:

Are all of your products 'priced by attribute' or are they mixed?

What other modules do you have installed that would meddle with the tpl_product_info_display.php?

They are mixed, some have attributes and some don't. I have 'stock by attributes' installed (by POTTERYHOUSE), and saveforlater_1.4 but don't think this uses that file.

Was working fine after both of these modules were added.[/QUOTE]

SBA typically touches the templated attributes.php module file. How many option values were expected in how many option names for some of the items that are not showing attributes? Some versions of SBA have some not yet resolved issues depending on how the attributes are used on the product. Also, when saying that it worked before, you are 100% sure that after installation and before posting this thread that the products currently having an issue were looked at and the attribute options were available for selection? If so, what HAS changed between then and now? Option Name type, number of option values, etc...

mc12345678:

They are mixed, some have attributes and some don't. I have 'stock by attributes' installed (by POTTERYHOUSE), and saveforlater_1.4 but don't think this uses that file.

Was working fine after both of these modules were added.

SBA typically touches the templated attributes.php module file. How many option values were expected in how many option names for some of the items that are not showing attributes? Some versions of SBA have some not yet resolved issues depending on how the attributes are used on the product. Also, when saying that it worked before, you are 100% sure that after installation and before posting this thread that the products currently having an issue were looked at and the attribute options were available for selection? If so, what HAS changed between then and now? Option Name type, number of option values, etc...[/QUOTE]

I generally only have 1 attribute option, but some items have 2. It appears that all the ones with 2 aren't working, but there are a few with only 1 that also aren't working. I am 99% sure that this was working until recently. The only thing I have changed that i'm of is I took 'weight' off from showing on the product listing and product info pages.

There are also at least 1 item where the attribute dropdown is on the far left hand side, whereas all the other (the ones working) are in line with the price.

therummagehole:

SBA typically touches the templated attributes.php module file. How many option values were expected in how many option names for some of the items that are not showing attributes? Some versions of SBA have some not yet resolved issues depending on how the attributes are used on the product. Also, when saying that it worked before, you are 100% sure that after installation and before posting this thread that the products currently having an issue were looked at and the attribute options were available for selection? If so, what HAS changed between then and now? Option Name type, number of option values, etc...

I generally only have 1 attribute option, but some items have 2. It appears that all the ones with 2 aren't working, but there are a few with only 1 that also aren't working. I am 99% sure that this was working until recently. The only thing I have changed that i'm of is I took 'weight' off from showing on the product listing and product info pages.

There are also at least 1 item where the attribute dropdown is on the far left hand side, whereas all the other (the ones working) are in line with the price.

To confirm, when you say one attribute option versus 2. It is important to know in regards to the version of SBA installed some of the details to be worked out.

So I asked about number of option Names: color, size, height these are typical option names.
Option values go inside of option names: so please choose a color, blue, green, red are four option values applicable to the option name color.
There is at least one version of SBA that does not play well with certain arrangemments of these choices, that the number of option names must be one, etc...as well, after you modified the number of attributes, did you go back and verify you plussed up stock on the "new item" (typically SBA treats each item differently if there are a different number of option names. Makes sense, but not always considered when playing around.)

The item that I linked to in my original post that is not working should be showing 2 option names, Size and Colour. Size has 3 values: 2 seater, 3 seater and 3 seater sofabed (with price increase on the last 2). Colour has 4 options: red, black, brown, ivory (with no price increases).

The stock by attributes is showing all variations as being stock.

Previously I had problems with SBA and one of the database tables. There is a bug in the code that left a comma in the field data that was referencing the various option names/values. There is no error and it's seemingly random. No changes one day, the next your missing attributes.

I regularly had to scan the database table and manually correct the field data. Funding was cut on the project so no static solution was developed.

which table would I need to look in?

therummagehole:

The item that I linked to in my original post that is not working should be showing 2 option names, Size and Colour. Size has 3 values: 2 seater, 3 seater and 3 seater sofabed (with price increase on the last 2). Colour has 4 options: red, black, brown, ivory (with no price increases).

The stock by attributes is showing all variations as being stock.

twitchtoo:

Previously I had problems with SBA and one of the database tables. There is a bug in the code that left a comma in the field data that was referencing the various option names/values. There is no error and it's seemingly random. No changes one day, the next your missing attributes.

I regularly had to scan the database table and manually correct the field data. Funding was cut on the project so no static solution was developed.

I'd like to warn about too general of a discussion on SBA. ZC at last check recognized I think 4 or 5 versions of SBA and basically have stopped accepting any new submissions that aren't versions off of those. Some have been able to handle conditions/situations as described, some have minor bugs when changing quantities if the attributes were not entered in a specific sequence, etc...the version I use doesn't include the java script display of products in stock, because I removed it and there were limitations that didn't go well with the store.

So, it would seem that the version installed (and suggest finding out) doesn't play well at least in part with multiple option names. I seem to recall reading that one of them worked with 3 or more option names, but not with two. You could test this by creating a single option name that has a single value (therefore would have 3 option names, but only 2 would require adjustment by the customer.) It's a shot in the dark/test, but it may also revive the attributes

Situation/logic was described, that it split the option names into three categories, first name, last name, and all names in between. But for some reason the logic wasn't worked out properly to handle a case where last was the same as middle, first was the same as middle, or middle just didn't exist...at any rate, it seemed to cause the quantity to be reported as out-of-stock, and if not mistaken when an attributed item is out of stock, then the attribute selection(s) disappear which means basically can't buy the product as there is nothing in stock..

therummagehole:

which table would I need to look in?

More than likely I think it is called products_with_attributes_stock but it could be named something else depending on the version installed.

therummagehole:

which table would I need to look in?

From my notes I found this:

Table - products_with_attributes_stock

Column - **stock_attributes

**The field data may have reversed the numbers, a stranded comma or a spaceOr there's some other bug...:/

twitchtoo:

From my notes I found this:

Table - products_with_attributes_stock

Column - **stock_attributes

**The field data may have reversed the numbers, a stranded comma or a spaceOr there's some other bug...:/

That is along the same lines as I have found. At one point a thread indicated that to best prevent that type of mix up in attributes listed, was to add each option name and option value in some particular order that I can't seem to remember. If/when I run across that issue, I manually change/update the sql data to match the sequence of a newly added product. It seems to only go astray when modifying existing data entries, otherwise if I erase all of the old SBA data for the product then add the data back in I can get it to work that way also. Just depends on what I'm working with as to which route I go at the time. Obviously would be ideal to just fix the program, but that hasn't made it to the top of my priority list yet.

Looked at the table and all seems fine, although i'm not that confident with php tables yet.

Not sure where to proceed from here.

I've tried deleting all attributes from an item, adding it back on, then adding the stock again but still not working.

Really don't fancy the idea as listing each attribute as an individual product.

therummagehole:

Looked at the table and all seems fine, although i'm not that confident with php tables yet.

Not sure where to proceed from here.

I've tried deleting all attributes from an item, adding it back on, then adding the stock again but still not working.

Really don't fancy the idea as listing each attribute as an individual product.

Wondering if. A quick fix would be to only use one attribute and split the products up that have two or more... I can't say that I plan on looking into it much further at the moment, but others may. What version of SBA was installed?

Another thing you may try, in the case of the product that had two attribute numbers, if you swap them around, does that have an effect? Also as suggested did you try adding a third option name with one option value. Say just something like thank you for picking one of our items or something...

Tried adding a 3rd option as suggested but no joy. Also tried swapping the numbers around and had no effect.

Think i'll do as you suggested with only using 1 attribute.