Product Attribute Grid

oavs:

Hi,

undo the change to the attributes.php file fixed the problem.
I couln't be happier :-)

Many many thanks for your time

Cheers
Thanks for confirming that that solution works. Happy Zenning!

Uploaded version 1.3.2 for review. When made available can be downloaded from here: https://www.zen-cart.com/downloads.php?do=file&id=618

Version is more than just adding in the above changes. These are the significant changes identified in the readme:
- Correct visual display when any one or more option name has only one option value.
- If an internal id is blank, then when generating the object id for javascript assign a zero (0).
- Add code associated with SBA to continue compatibility.
- Remove some code from the includes/modules/YOUR_TEMPLATE/attributes.php to restore to original/SBA related.
- Added possible functionality to provide a contact us line/item.
- Added ability to hide price based on user's requiring to be logged in.
- Added ability to obscure the actual number of available product greater than
some chosen value.
- Incorporated possible use of displaying price at grid box instead of at option name's option value.
- Improved product processing to allow all ZC default attribute types to be used.
- For uploading files, it is possible to associate a single file for all "variants" or
to provide one file for each product variation (grid option).

Content is also downloadable from github at: https://github.com/mc12345678/attributes-grid

Version 1.3.2 of Product Attribute Grid is now available from downloads.

Do I need Version 1.3.2 of Product Attribute Grid after your fixes?

oavs:

Do I need Version 1.3.2 of Product Attribute Grid after your fixes?
Maybe not specifically, but I did try to rework some of the grid organization before releasing 1.3.2. I didn't like how some of the items were displayed when looking at the combinations of attributes and option values so I made a few changes to try to provide some consistent lineup.

avansant:

The attribute grid seems to be working fine, but in the admin I am getting the message "Warning: Absolute's Product Attribute Grid was detected, however the Product Option Type for Attribute Grid was not fully installed in the database. Temporarily configuring PRODUCTS_OPTIONS_TYPE_ATTRIBUTE_GRID = 23997" whenever we go to the "orders" area in the admin. I tried reinstalling it. The version I had didn't have a database option to install (no SQL file). I suspect it has something to do with this being an upgraded cart (from 1.3.8 to 1.5.1) and maybe the OLD installation left some DB table that shouldn't be there? But I can't find it. Can you help?

Saw this message as I was looking for action necessary to support a product option type added by Stock By Attributes and trying to understand the background for an option in Edit Orders. Based on that review I realized that this plugin has been modified to support operation as described in the edit orders plugin forum and by the above message, but the code did not quite line up. I have made modifications to this plugin to support its use in Edit Orders and am submitting it to the ZC community to further support its use.

Preliminary review of the changes can be found by review at github.

Product Attributes Grid v1.3.3 has been posted to the download area. This version is compatible with Edit Orders. It will convert the product option type within the database from what was generated before to what edit orders was expecting and for now does not delete the previous record to maintain compatibility during the transition.

ZC download location: https://www.zen-cart.com/downloads.php?do=file&id=618

mc12345678:

Product Attributes Grid v1.3.3 has been posted to the download area. This version is compatible with Edit Orders. It will convert the product option type within the database from what was generated before to what edit orders was expecting and for now does not delete the previous record to maintain compatibility during the transition.

ZC download location: https://www.zen-cart.com/downloads.php?do=file&id=618
Which version of Edit Orders?

lat9:

Which version of Edit Orders?

Was most recently tested on version 4.1.7; however, the protective code in Edit Orders has been there for a number of years and remains present. For other reasons I had compared 4.1.7 back to 4.1.3 and there had been no change to this area of the code so it likely is compatible with Edit Orders 4.1.3 (released 8 Jan 2014) and up. Prior to 4.1.3, other action (either by code edit or some form of javascript "insertion") would have been necessary to implement the modification of product that had an attribute option type other than the general default.

Issue identified that began in version 1.3.2 of this module. If Stock By Attributes was not installed (files at least) then, this plugin would not properly process grid items added to the cart. I have uploaded version 1.3.4 to the plugins area which will be available here upon review/approval. If the files of SBA were installed, even if no features were activated, then the add-to-cart would operate properly.

The summary writeup was:

• Changes made to support SBA back in version 1.3.2 prevented proper operation if Stock By Attributes was not installed. This has been corrected in this version.
• Modified the included attributes.php file to incorporate changes made to Stock By Attributes and Attribute Image Swap.

If desire to see/obtain the code changes in advance, the plugin is also available from GitHub at: https://github.com/mc12345678/Attributes-Grid

Thanks to oavs for identifying this issue.

Just to clarify, is "Attributes-Grid-master" replacing "Attribute Grid 1.3.3" ?

mc12345678:

Issue identified that began in version 1.3.2 of this module. If Stock By Attributes was not installed (files at least) then, this plugin would not properly process grid items added to the cart. I have uploaded version 1.3.4 to the plugins area which will be available here upon review/approval. If the files of SBA were installed, even if no features were activated, then the add-to-cart would operate properly.

The summary writeup was:

If desire to see/obtain the code changes in advance, the plugin is also available from GitHub at: https://github.com/mc12345678/Attributes-Grid

Thanks to oavs for identifying this issue.
Version 1.3.4 of this plugin is available for download here.

oavs:

Just to clarify, is "Attributes-Grid-master" replacing "Attribute Grid 1.3.3" ?
The version downloaded from github would have been the same as 1.3.4 which would have replaced 1.3.3. Now that 1.3.4 is available, github files might receive updates/changes in advance of a newer release.

Weel I have installed "Attributes-Grid-master" over the existing from at github.and worked beautifully. I am soo happy and thank you for following this up mc12345678.

:-)

oavs:

Weel I have installed "Attributes-Grid-master" over the existing from at github.and worked beautifully. I am soo happy and thank you for following this up mc12345678.

:-)
Just goes to show that regardless the issue, if it is not reported or made known it may be a while before someone else finds it. Some that find it will work their way through, some will report the issue, and others will move on to something else.

Personally, thank you for taking the time to point out the issue and try the tests requested.

Hi Guys,

First of all I apologise if Iam being silly about this but I cannot figure this out and have been back and forth for some time.
I have a wedding sweet package offer with a flat rate price and I want to allow customers to choose from a list of attributes the types of sweets they wish to include, just to give choice. So I am offering a choice of ten say, but the max they can pick is five, now they can have five of the one attribute if they want, whatever. So if the customer picks qty of five on a combination of five different attributes, i.e. one of each, then it should add to cart. But it adjusts and adds the product five times? I have tried every combination but nothing works. Perhaps I am not understanding how this mod works? can anybody shed light?

jagall:

Hi Guys,

First of all I apologise if Iam being silly about this but I cannot figure this out and have been back and forth for some time.
I have a wedding sweet package offer with a flat rate price and I want to allow customers to choose from a list of attributes the types of sweets they wish to include, just to give choice. So I am offering a choice of ten say, but the max they can pick is five, now they can have five of the one attribute if they want, whatever. So if the customer picks qty of five on a combination of five different attributes, i.e. one of each, then it should add to cart. But it adjusts and adds the product five times? I have tried every combination but nothing works. Perhaps I am not understanding how this mod works? can anybody shed light?
Can you provide a more direct "connection" about the problem product? I've spent way too long trying to figure out which product is giving trouble.

The goal is this:
Either a product has one option name with multiple option values, all of which can be added in some "array" or quantity or there are two option names that are "combined" so that can enter a number where they overlap to be able to add that combination of product to the cart.

To limit the number of variants of a product, will need to set the max number of product to be able to restrict the total number.

thanks for reply here is a link to the product page might make it more clear probably in my case I have too many options but that's the type of combination I require. I would even like if I could get checkboxes to work where customers can tick up to five of the 10 options offered and leave it that they are limited to one item per choice that be fine too.
thanks again

jagall:

thanks for reply here is a link to the product page might make it more clear probably in my case I have too many options but that's the type of combination I require. I would even like if I could get checkboxes to work where customers can tick up to five of the 10 options offered and leave it that they are limited to one item per choice that be fine too.
thanks again
Ok, so yes the setup of the "product" and it's associated attribute(s) does not match the described goal/expectation.

As is right now, the product is setup as a maximum 10 with the min qty/unit qty set to yes, the product's base price is €50 with one attribute having an additional €1 one time fee, all of the choices (option values) fall under one option name.

Expectation appears to be that guest picks any mix/match of 5 items (5 of one or any whole number quantity of the ten choices such that no more than a quantity of 5 have been chosen). Upon selection of the 5 items the total price paid is to be €50.

Now it also appears that Stock By Attributes or a variation of it is in use, so this throws in yet another level of "complexity" because now talking about stock in addition to price.

Let me step back one. Because the product is base priced at an amount (other than 0), the price of purchasing each attribute is the price of the entire product, which is why when adding "attribute" quantities it is like adding the entire product and therefore the total cost when selecting 5 (or as is now 10) of the sub-products that the cost is 5 or 10 times what is displayed as the "package" and doesn't seem right.

"Normally" what is done in cases like this is to provide 5 option names, in each option name is your list of 10 option values. This way, each option value could be selected in each of the 5 option names, but this has a tendency to not offer quantity tracking for each option value because a selection of sub-product 1 in option name 1 is not the same as sub-product 1 in option name 5...

So what am I possibly suggesting? Well, 1 this plugin is not specifically designed to give what is being sought; however, it might be possible for it to help/make work...
Problem is that when using a maximum value instead of a unit value if someone wants to purchase 2 of these supposed packages, they have to shop a second time or code has to be written to make it work/balance.

So, here's the thing, each option value really adds only only €10, but the product's price (based on price by attribute) is to end up being €50 with both a minimum and maximum of 5 "product" to be selected (entered on the product info page) and a min qty/unit qty enforced of true. Then each option value is entered with a price of €50, but in the price factor, a number representing the portion of the total quantity should be entered ie. 1/5th of the total or 0.20 (will take 5 such option values all in the cart to get the total price), then the offset for the price factor should be 1. This will result in the products base price being €50, but each selection being €10, a minimum of 5 attributes to be selected, and a maximum of 5 to be selected so that can not purchase in a single order the same offer twice. Now, if wanted to allow purchase of the offer multiple times, instead of a maximum of 5, would select a maximum of 0 and change the unit quantity to 5 which would "force" quantities to be in groups of 5 prior to checkout. a message should be displayed in the cart related to this.

So, to explain what this module actually does? It allows selection of of up to a combination of 2 option names in quantities rather than having to add each selection independently.

Ie. Ever popular example(s): have t-shirts in Small, Medium, and Large that have Colors, Red, Blue, and Green.

Instead of selecting a quantity of 1, a size of Small, and a color of Blue. Can go to the single "cell" that represents Small and Blue and then enter a quantity of 1... And, at the same time can enter a quantity for Medium and Green, at which point add to cart will add whatever quantities of product that have those attribute combinations populated. For a single option name such as a t-shirt offered only with this one color and print on it but multiple sizes: well, could select 1 small and 1 large for example and add-to-cart one time with these 2 product (variants) selected.

mc12345678 thank you so so much for the very detailed response much appreciated. I have been wrecking my head tho trying to understand still how it works, then I realise that in my attributes controller page, I am missing a few elements, namely: Price Factor and Price Offset. Using ZC 1.5.5 went back installed attributes again but still same the settings are different. I have installed a third party theme and looking into this now to see if this changed something but it is compatible with 1.5.5 or does this version have a more streamlined attribute section??? stumped!