StockByAttributes with my stock id MOD 1.0.0

[rhuseby]

I have corrected one issue since uploading this mod. Explaination and fix are posted here:
http://www.zen-cart.com/forum/showpo...postcount=1408

Submitted ver. 1.0.1 that includes this fix...

[Boggled]

Just finished installing this on 1.3.9h cart. Fresh install cart, but with several other mods.

Added an item with 8 sizes and 8 color attributes.

I tried to add a qty of 20 Gloss Black model #F1-A (left sizes set on ALL).
When I clicked submit I got the following error:

1054 Unknown column 'F1-A' in 'field list'
in:
[insert into `products_with_attributes_stock` (`products_id`,`stock_attributes`,`quantity`,`my_stock_id`) values (1,"10,18,19,7",20,F1-A) ON DUPLICATE KEY UPDATE `stock_attributes` = "10,18,19,7", `quantity` = 20]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Any idea what I might have done wrong or what might be causing this?

[rooster_cogbern]

Just finished installing this on 1.3.9h cart. Fresh install cart, but with several other mods.

Added an item with 8 sizes and 8 color attributes.

I tried to add a qty of 20 Gloss Black model #F1-A (left sizes set on ALL).
When I clicked submit I got the following error:



Any idea what I might have done wrong or what might be causing this?

Boggled,

Did you run the SQL scripts that added the "my_stock_id" column in the 'products_with_attributes_stock' table?

[Boggled]

Hi,

Yes, I ran the SQL file that came with the mod named stock_attribute_my_stock_id.sql.
I even did it a second time, thinking maybe I had missed doing that. (It's been a long day! lol )

Thanks! :)

[rhuseby]

Just finished installing this on 1.3.9h cart. Fresh install cart, but with several other mods.

Added an item with 8 sizes and 8 color attributes.

I tried to add a qty of 20 Gloss Black model #F1-A (left sizes set on ALL).
When I clicked submit I got the following error:



Any idea what I might have done wrong or what might be causing this?

So all sizes use the same part number? I set the field my_stock_id to not allow duplicates. You could use MYSQL admin to set the field to allow duplicates, but I would suggest having a unique part number for every variant...

[rhuseby]

rhuseby,

After much tinkering and hacking, I think I got SBA working for 1.5.0.. well, I can modify stock attributes.. still working to show the MyStockID.. but a little more hacking I should get it. Wasn't too hard, just looked at the code adds for the 6 main files and added it to my 1.5.0 files. Also needed to add the page in admin_pages in MySQL.

That being said, curious if you would know an easy way to turn-off the stock attributes for some of the attributes. If I leave it blank, it won't accept the change.

Thanks,

Rooster

Did you get it working on v1.5.0?

[Boggled]

So all sizes use the same part number? I set the field my_stock_id to not allow duplicates. You could use MYSQL admin to set the field to allow duplicates, but I would suggest having a unique part number for every variant...

On this particular item all sizes use the same part number, but other products don't.

I tried doing just XS Gloss Black F1-A-XS and now I get this error:

1054 Unknown column 'F1' in 'field list'
in:
[insert into `products_with_attributes_stock` (`products_id`,`stock_attributes`,`quantity`,`my_stock_id`) values (1,"7,10,18,19",5,F1-A-XS)]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I could live with adding a size identifier on each combination, but are they ALL going to show up in the dropdown boxes?

[rhuseby]

On this particular item all sizes use the same part number, but other products don't.

I tried doing just XS Gloss Black F1-A-XS and now I get this error:




I could live with adding a size identifier on each combination, but are they ALL going to show up in the dropdown boxes?

I may need to change the code, try quoting the part number:
"F1-A-XS"

[rooster_cogbern]

Did you get it working on v1.5.0?

Yes - wasn't too difficult. I manually went through your mod and added the code to my original php files. (after making backups of course) Basically inserting the code around the v.1.5.0.. and testing as I went.

As you mentioned earlier, hacking is much easier than coming up with it on your own.

BTW, still looking to add the Include/Exclude flag for Stock Quantity. Had asked the Software Guy, but he passed. Might take it to the original SBA thread(s) and ask if anyone has a mock up/ and or willing to send me a PM to folks that might be interested.

[Boggled]

I may need to change the code, try quoting the part number:
"F1-A-XS"

That worked. :)