Hi

I have a problem and hope some one can come up with a solution.

Client has many products. see below. How can the user select item size or grade what corresponds with the product code?

Not sure it is possible or if there is a plugin.

For example If I want to order 'Sanding Discs Gold 150 mm Velcro 15 Hole' as a product with variations as below.
Order item: 'Sanding Discs Gold 150 mm Velcro 15 Hole'
Option: P40
Size; 150 mm
and the matching item code is '3050.004' to be automatically selected.

Sanding Discs Gold 150 mm Velcro 15 Hole OPTION SIZE
3050.004 P 40 150 mm
3050.006 P 60 150 mm
3050.008 P 80 150 mm
3050.012 P 120 150 mm
3050.015 P 150 150 mm
3050.018 P 180 150 mm

OR in another example,
Order item: 'Universal Hardener'
Option: Fast
Size; 500 ml
and the matching item code is '407.0501' to be automatically selected.

Universal Hardener OPTION SIZE
407.0251 Fast 250 ml
407.0253 Standard 250 ml
407.0501 Fast 500 ml
407.0503 Standard 500 ml
407.1001 Fast 1 Litre
407.1002 Extra Fast 1 Litre
407.1003 Standard 1 Litre
407.2501 Fast 2.5 Litre
407.2502 Extra Fast 2.5 Litre
407.2503 Standard 2.5 Litre
407.2507 Extra slow 2.5 Litre
407.0201 Fast 200 ml

I mean in worst case I could list them as options as a whole as per single line but that is too busy. Another way is I could I thought like this.

Order item: 'Sanding Discs Gold 150 mm Velcro 15 Hole'
Drop Down Option:[ P 40 - 150 mm (3050.004) ]

and

Order item: 'Universal Hardener'
Drop Down Option:[ Fast - 250 mm (407.0251) ]

On top of that user must be able to select more than one option to order as per item. Such as

Order item: 'Sanding Discs Gold 150 mm Velcro 15 Hole'
Drop Down Option:[ P 40 - 150 mm (3050.004) ] X 2 order
Drop Down Option:[ P 180 - 180 mm (3050.018) ] X 6 order
etc etc.

OR

Order item: 'Universal Hardener'
Drop Down Option:[ Fast - 250 ml (407.0251) ] X 6 order
Drop Down Option:[ Extra Fast - 1 Lt (407.1002) ] X 2 order
Drop Down Option:[ Extra Fast - 2.5 Litre (407.2502) ] X 10 order

Any alternative ideas?

Couple of things can get a little closer to the goal...

There is Product Attribute Grid which will support selecting a quantity of product based on the cross of two attributes, though multiple attributes can be listed. Also can use Stock by Attributes as available from https://github.com/mc12345678/Stock_by_Attributes_Combined to soon be posted to the ZC forum once the instructions are updated from the existing version that is downloadable.

SBA allows storing the customid's to which you refer.

Wow may be this is exactly what I need.

Any zen core files changed that I need to be aware of?

I have downloaded the whole thing Stock_By_Attributes_Combined-master.zip but confused which folder to use. I have 1.5.5a so I assume it is the 1_5_5 folder but there are 'admin' and 'includes' folders under 'Stock_By_Attributes_Combined-master' as well.

Should I just use the -
Stock_By_Attributes_Combined-master
admin
includes

..folders?

oavs:

Wow may be this is exactly what I need.

Any zen core files changed that I need to be aware of?

I have downloaded the whole thing Stock_By_Attributes_Combined-master.zip but confused which folder to use. I have 1.5.5a so I assume it is the 1_5_5 folder but there are 'admin' and 'includes' folders under 'Stock_By_Attributes_Combined-master' as well.

Should I just use the -
Stock_By_Attributes_Combined-master
admin
includes

..folders?
Both sets of folders should be used, though designed to best be installed by first installing the base includes and admin folders. Then the files in the version applicable folder for one's version. The applicable version folder contains files that need some merging for that version. There aren't many files touched. Predominantly the files are exactly the same as a ZC 1.5.5a install with a few lines/areas modified to support the operation of SBA. Product attributes grid doesn't have any overwrites, though there is still a little "display" issues with the version available from the downloads area. Sorry. I was able to get it to work with more recent versions of ZC and pushed it before making it "pretty". Have made a few improvements since, but haven't uploaded it again yet. :/ (like it now is possible to handle file uploads as well...)

Product Attribute Grid doesn't show in admin. Do I need to install STOCK BY ATTRIBUTES to make it work?

I have FTP includes file and followed the instructions but no luck. Drop down does not show 'Grid'

oavs:

Product Attribute Grid doesn't show in admin. Do I need to install STOCK BY ATTRIBUTES to make it work?

I have FTP includes file and followed the instructions but no luck. Drop down does not show 'Grid'
No, SBA is not required for PAG to work.

A couple of reasons off the top of my head why it didn't add the Grid option, obvious is that the files were not all uploaded to the correct location, less obvious is that in upload that a file did not fully make it.
In uploading there is a template override file that is very similar to what is used for SBA (includes/modules/YOUR_TEMPLATE/attributes.php) on which the plugin was further developed to simplify the install process. YOUR_TEMPLATE should be renamed to the folder name of the template you are using.
The next thing about the "install" of this plugin is that it does require accessing from the store front a product that has attributes.
The next is that after the code was run, did not log out of and back into the admin under a different session.

And then, and possibly the issue, is that the "install" code runs a query that basically accepts the sql database to "know" that the data is "up-to-date" but in the process, it doesn't force that fact. The correction if this is the case is to locate the code referenced at this post and change rows that have this type entry from:

$result = $db->Execute($sql);

To:

$result = $db->Execute($sql, false, false, 0, true);

This will be incorporated when the plugin is again submitted for download. Also, other visual issues will be addressed as some features were only partially complete in modification.

I just looked through my github and saw that I had this issue captured there with the latest modification that I'd made. Can find it at: https://github.com/mc12345678/Attributes-Grid

Hi,

I have read 99% of the tread and this did the trick for me. Thanks for your kind support and looking forward to the "final" ..next version

INSERT INTO products_options_types (products_options_types_id, products_options_types_name)
VALUES (6, 'Grid');

INSERT INTO configuration (configuration_title, configuration_key, configuration_value,
configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)

  VALUES
  ( 'Selection list product option type (Grid)'

, 'PRODUCTS_OPTIONS_TYPE_GRID', 6,
'Numeric value of the grid product option type used for SBA',
6, 0, NULL, NOW(), NULL, NULL);

Provided a store has never had other option name types installed and/or only the default option types are present, then that set of sql would/should work. :)

The updated version referenced above incorporates the needed sql query resets to allow the install of the Grid product type as well.

Be sure to verify that your store still supports normal dropdowns as seen on the catalog side. Because of issues with older plugins and the way they installed some configuration options, there is/was the possibility of removing the configuration option for dropdowns and two other attribute types. This is corrected/addressed in a fresh install or a proper upgrade to ZC 1.5.5, but for anyone that comes across this in the future I wanted to somewhat close the loop. A successful install of this plugin ought to address that issue for older ZC versions even though the update script to and through ZC 1.5.5 will attempt to correct it if it was still an issue.

Thanks . It is working fine now.