Stocks by attributes

[kuroi]

Should I add the Dynamic Drop Down mod to it also?

Probably not.

If people want to use them together, they can install them together.

But adding more bells and whistles will only make this mod more complicated.

The versions that I issued were supported and tested to professional standards (even though they inherited a data structure that I didn't much like). I carried on supporting it even when I had no clients using it.

I stopped when people started issuing versions with extra features, that while nice, over-complicated it and sometimes didn't work properly.

Integrating more peripheral features lessens still further the chances that somebody else will be willing to pick this up and stay with it.

Don't get me wrong. This is to some extent how open source develops and although it hasn't worked as effectively as it can in this instance, there's nothing wrong with that.

But unless you're willing to stick with it and maintain it, I'd strongly recommend against making it more difficult for anybody else to do so.

[DivaVocals]

What he said.. Kuroi is absolutely right..

All so-called "enhancements" that have been added on to his originial SBA contribution is part and parcel why the versions after Kuroi's last release have been NOTHING but problematic.. (and why I have always recommended to NOT install any of them) At the risk of hurting feelings or offending someone, none of these author's have even bothered to support their so-called "improvements" to SBA.. I know they thought that they were helping the community by sharing their neat "enhancements" but if those enhancements are not sustainable, then how is that helping the community??

Don't get me wrong, the Dynamic Dropdowns has it's usefulness, but the module as it exists today is only half working. To bundle it in with SBA adds only one of two features I would personally like to see included in SBA (though arguably my clients have been able to surprisingly live without):
1. Sequenced attributes
2. Improved display of out of stock stock variants (as of today customers only see a variant is out of stock when they add it to their cart)

That said to add Dynamic Dropdowns without FULLY flushing out that module (AKA get it working CORRECTLY), and without proper support from the contributor (who bundles it in with SBA) will only lead to more unsupported versions of SBA.

So yes I agree with Kuroi.. However, I say that adding more unsupported enhancements to SBA is NOT a good long term thing for the whole of the community. I however, am all for SUPPORTED enhancements when the features are useful.. Frankly every "enhancement" made to SBA since Kuroi's last release has added up to not even a "nice to have", but a "think I need" kind of features which IMO do nothing to improve the shop owner's experience in any MEANINGFUL or noticeable way..

Probably not.

If people want to use them together, they can install them together.

But adding more bells and whistles will only make this mod more complicated.

The versions that I issued were supported and tested to professional standards (even though they inherited a data structure that I didn't much like). I carried on supporting it even when I had no clients using it.

I stopped when people started issuing versions with extra features, that while nice, over-complicated it and sometimes didn't work properly.

Integrating more peripheral features lessens still further the chances that somebody else will be willing to pick this up and stay with it.

Don't get me wrong. This is to some extent how open source develops and although it hasn't worked as effectively as it can in this instance, there's nothing wrong with that.

But unless you're willing to stick with it and maintain it, I'd strongly recommend against making it more difficult for anybody else to do so.

[Scrat]

Can any one tell me what order SBA adds the 'products_attributes_id' to the 'stock_attributes' in the ' products_with_attributes_stock ' table.
I have some with one attr. some with two, and others with three. I have written a python script to up date the stock from my Epos database using a custom stockcode in the 'products_with_attributes_stock' table. But it is not clear as how SBA uses the order, as the order does seem to differ.

[Scrat]

kuroi could you advise me as you seem to have a good understanding of this mod.
Further to my last message this is driving me mad, there doesn't seem to be a logic to how the attribute values are indexed in the 'stock_attributes' column.

If I enter via SBA in admin I get some attributes for the example of the Mysql table:

1125    1075    14024,14025    2    P/GAB/D/BL/350
1126    1075    14013,14025    1    P/GAB/D/BL/360
1127    1075    14014,14025    1    P/GAB/D/BL/370
1128    1075    14015,14025    3    P/GAB/D/BL/380
1129    1075    14016,14025    1    P/GAB/D/BL/390
1131    1075    15085,14025    3    P/GAB/BK/D/410
1132    1075    15086,14025    4    P/GAB/BK/D/420 

And some :

1166    1075    14025,15084    0  stockcode_to_add     
1167    1075    14025,16527    1   stockcode_to_add 

As you will see they are all for the same product, I have size and fitting(Ref 14025) as attr's, First Size then Fitting(Ref 14025). In the second example it has been reversed so it is Fitting(Ref 14025) and Size. I can not see why SBA does this, can you shed a light on it. I have added a custom field in this table for a stock_code which I add remotely for updating the stock levels.

Many thanks
Andrew