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

[Kevin205]

And if you already have 1000 of product size attributes in your existing site, how would you add all of them to products_with_attributes_stock table?

I hope the answer is not one by one through admin!

[Kevin205]

While reading the wiki I noticed the following:

I offer my customers a choice of gift wrapping / ring setting / picture frame / container / monogram style, but don't want to create product variants for every combination of products and gift wrapping ... How can I avoid this?

This is an important issue that is affecting a number of stores as the variety of situations mentioned in the question above indicates. A workable solution is discussed from posts 199 to 204 in an archived stock by attributes thread[2]. However, as this intrudes into critical Zen Code and tables there are no plans incorporate it into this mod, though it will be considered for inclusion when the function is incorporated into Zen Cart's core code.

As I have explained I am in the same situation and frozen. I read posts 199 to 204 but did not find the code change for it. Where can I get the code change for this? Would appreciate your help on this.

[potteryhouse]

And if you already have 1000 of product size attributes in your existing site, how would you add all of them to products_with_attributes_stock table?

I hope the answer is not one by one through admin!

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??

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.

[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

[buildingblocks]

Hi

I have installed Stock by Attributes - Version: 1.5.0 on a zen cart 1.5.0. The module documentation says:

You will also want to consider the settings in Configuration->Stock. The settings here will determine things such as whether or not a customer will be allowed to checkout when insufficient stock is on hand. As well as controlling the new feature that allows you display the amount of stock available on the shopping cart page if a customer tries to buy more
than the recorded stock.

I don't see anything in Configuration->Stock for controlling the new feature. What setting should be there?

Could some tell me please what setting I should be seeing in there?

thanks

[Pablo]

Hi

I have installed Stock by Attributes - Version: 1.5.0 on a zen cart 1.5.0. The module documentation says:

You will also want to consider the settings in Configuration->Stock. The settings here will determine things such as whether or not a customer will be allowed to checkout when insufficient stock is on hand. As well as controlling the new feature that allows you display the amount of stock available on the shopping cart page if a customer tries to buy more
than the recorded stock.

I don't see anything in Configuration->Stock for controlling the new feature. What setting should be there?

Could some tell me please what setting I should be seeing in there?

thanks

Check stock level > true
Subtract stock > true
Allow Checkout > false
Mark product out of stock > ***
Stock Re-order level > 5
Show available stock level in cart when less than order > true
Display Images in Admin > false
Show available stock level on product page with the attribute (option) >false or true
Products status in Catalog when out of stock should be set to > 0
Show Sold Out Image in place of Add to Cart > 0
etc, etc, etc...

[buildingblocks]

Check stock level > true
Subtract stock > true
Allow Checkout > false
Mark product out of stock > ***
Stock Re-order level > 5
Show available stock level in cart when less than order > true
Display Images in Admin > false
Show available stock level on product page with the attribute (option) >false or true
Products status in Catalog when out of stock should be set to > 0
Show Sold Out Image in place of Add to Cart > 0
etc, etc, etc...

Thank you. It was missing.

> Show available stock level in cart when less than order - true/false

For some reason the automatic sql installation didn't add it but I did find the sql in the legacy folder so I was able to activate it.

[buildingblocks]

Check stock level > true
Subtract stock > true
Allow Checkout > false
Mark product out of stock > ***
Stock Re-order level > 5
Show available stock level in cart when less than order > true
Display Images in Admin > false
Show available stock level on product page with the attribute (option) >false or true
Products status in Catalog when out of stock should be set to > 0
Show Sold Out Image in place of Add to Cart > 0
etc, etc, etc...

I also see in your list

"Show available stock level on product page with the attribute (option) >false or true "

The version module (1.5.0) I'm using does not include it. I see the file

stock_by_attr_install.php for module version 1.5.1.1 does have it. If I install the sql for, Show available stock level on product page, will it work for module version 1.5.0?

[potteryhouse]

I also see in your list

"Show available stock level on product page with the attribute (option) >false or true "

The version module (1.5.0) I'm using does not include it. I see the file

stock_by_attr_install.php for module version 1.5.1.1 does have it. If I install the sql for, Show available stock level on product page, will it work for module version 1.5.0?

The short answer is no.
The reason is, that was, a new option added to code in the latest version 1.5.1.

As a note I am working with another member, Kevin205, to make some significant improvements to this mod and add some level of user instructions to help with understanding what each of the option switches in the "Configuration/Stock" will provide, and maybe a recommended base setting.

This update will replace the previous version (1.5.0, 1.5.1, and 1.5.1.1) since most of the files have at least a small amount of code updates. It will add too and correct some of the behaviors this mod exhibits, some of which were lost over time as it was updated.

I am hoping to have a beta version posted for anyone wanting to test and provide us feedback in the near future. It will not be perfect, but I think everyone will like the updates. But it will only be compatible with Zen Cart 1.5.1 since the CORE file modifications are based on 1.5.1.

[buildingblocks]

The short answer is no.
The reason is, that was, a new option added to code in the latest version 1.5.1.

As a note I am working with another member, Kevin205, to make some significant improvements to this mod and add some level of user instructions to help with understanding what each of the option switches in the "Configuration/Stock" will provide, and maybe a recommended base setting.

This update will replace the previous version (1.5.0, 1.5.1, and 1.5.1.1) since most of the files have at least a small amount of code updates. It will add too and correct some of the behaviors this mod exhibits, some of which were lost over time as it was updated.

I am hoping to have a beta version posted for anyone wanting to test and provide us feedback in the near future. It will not be perfect, but I think everyone will like the updates. But it will only be compatible with Zen Cart 1.5.1 since the CORE file modifications are based on 1.5.1.

Thanks for responding. I'd be interested in testing the beta when it is available.