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

[Kevin205]

Good morning to you. Thanks for the reply.
[QUOTE=potteryhouse;1215179]Good morning (at least it is here....)
I had provided as part of the mod update an 'Optional.sql' file, this file finds all the products that have attributes in your database and creates entries into the new stock by attribute table. This worked great for me, but I have only one variable (size) for products. Did you happen to try this sql file on a TEST version of your database??

[/CODE]

I did not run 'Optional.sql as I didn't realize what it does.

[QUOTE=potteryhouse;1215179]
If that is too simplistic of an approach for your data set, I would need a sample (if your willing to provide) of your database (the sample will need to be 'sanitized' to remove any customer related information, orders, etc.) all I think I would need from your database is the following tables to try an create a custom sql file (as this is done on my spare time as a hobby I can not say how long it will take)

products
products_attributes
products_attributes_download
products_description
products_options
products_options_types
products_options_values_to_products_options
products_with_attributes_stock

It may be best to use private messages for this if you decide to send anything.

I gathered all the above tables to forward to you. I sent you a pm.

FYI: Following pictures displays what I see,
- when I add inventory to the size from the mod.

with the following settings


- when I removed the second attribute id from the stock_attributes