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

[DivaVocals]

I've done a bit of searching, and cannot find an answer other than a short discussion from 2006.

I sell green coffee by the pound, and the offerings are priced by attributes with 1#, 2#, 5#, 10#, and 20$ quantities offered. The problem is that there is not a stock quantity associated with the attributes, and it does not appear that this mod addresses attribute quantities where all the attribute items are merely different quantities of the same stock item. Does something like that exist, or alternatively, is there a way to price by quantity with discrete amounts available (the weights match my shipping packaging).

Thanks for the help.

site is www.noquartercoffee.com

The short answer is no. This module does not offer a mixed used of attributes where some attributes do not have a stock value associated with them. For example if you offer tee shirts in various Size/Color combos (where each combo has an associated stock value) AND then provide your customer with an option to personalize the tee shirt Size/Color combo you've selected. When you setup the stock for this product using this module, you would have to create a product variant which includes the personalization attribute along with the color and size attributes for each variant you setup.

That said you do not HAVE to setup product variants for products where there is no associated stock value for the various attribute variants.. You could simply use the default Zen Cart stock field in the product configuration and not create a variant at all for it using this module.. It's very flexible in that way..

[kuroi]

I've done a bit of searching, and cannot find an answer other than a short discussion from 2006.

I sell green coffee by the pound, and the offerings are priced by attributes with 1#, 2#, 5#, 10#, and 20$ quantities offered. The problem is that there is not a stock quantity associated with the attributes, and it does not appear that this mod addresses attribute quantities where all the attribute items are merely different quantities of the same stock item. Does something like that exist, or alternatively, is there a way to price by quantity with discrete amounts available (the weights match my shipping packaging).

Two possible approaches:

Firstly, you could create a category for each product like this and then make each variant a product within that category and edit the category listings for these products to look a little more like a product page (this idea originally came from Ajeh - does anybody know more about attributes?)

Secondly, you could go the whole hog and create a new type of attribute that carries a quantity and allows a quantity box to be displayed to collect it on the product page. I did a partial implementation of this for a client about a year ago (partial since they didn't need all the functionality that would be needed for this to be extended into a mod). Took about 3 days of design, development and testing - so not an easy option.

So two options, but both require a intermediate levels of knowledge of PHP and MySQL and advanced Zen Cart knowledge.

[DivaVocals]

Two possible approaches:

Firstly, you could create a category for each product like this and then make each variant a product within that category and edit the category listings for these products to look a little more like a product page (this idea originally came from Ajeh - does anybody know more about attributes?)

Secondly, you could go the whole hog and create a new type of attribute that carries a quantity and allows a quantity box to be displayed to collect it on the product page. I did a partial implementation of this for a client about a year ago (partial since they didn't need all the functionality that would be needed for this to be extended into a mod). Took about 3 days of design, development and testing - so not an easy option.

So two options, but both require a intermediate levels of knowledge of PHP and MySQL and advanced Zen Cart knowledge.

Taking copious notes from the master.. Thanks for the tip..

[soxophoneplayer]

I am using this mod 4.7 with ZC 1.3.8a. Also using Product Attribute Grid Display Both were working well for few years. I apologize for cross posting but I'm not sure which mod is in play with my prob.

New problem arose - stock level is adjusted on products WITHOUT attributes when transacted, but stock levels are not adjusted when it is a stock with attributes.

I recently housecleaned my permissions at request of server....folders are 0755, files 0644, and config files 0444. Only other change in files was code mod of IH2 manager to set permissions of uploaded product photos.

Does this mod require a different permission setting somewhere in order to process the stock change?

[kuroi]

Does this mod require a different permission setting somewhere in order to process the stock change?

No, that sounds like a red herring to me. I'd check that your order.php class hasn't been over-written with a version that doesn't contain the stock by attributes code.

[soxophoneplayer]

No, that sounds like a red herring to me. I'd check that your order.php class hasn't been over-written with a version that doesn't contain the stock by attributes code.

Right you are, thank you. My includes/classes/order.php, revision from 2009-07-12, had a snippet of code missing that I found on the 2007 version. Once merged, the attribute quanties do successfully adjust after a transaction. I thought it had been functioning properly before - perhaps I just noticed it this time because of a low quantity.

[philip937]

For info, this add-on lists ALL products in one big list, so if you have thousands of products it takes ages to load and unmanageable.

So if interested I have added a very simple category listing function to show the category list first, then you click on a category to show products only in that category.
Attachment 7044

The out of memory problem still exists... I had to change our options and attributes to suit this add on to overcome this issue. Its when you have hundreds of attributes. It would be good to instead of adding unused attributes into the stock control, to ignore them for stock control instead. Then we probaby wont have this error.

Thanks

Hey infocom,

I had a look at your modified page and it works really well! nice touch with the images!,

However, for now I have reverted back to my file because I have a custom field in the database that I programmed to auto populate when adding quantities. Obviously I am now keen to try and transfer my code accross to your solution, however when I was looking at your code, straight away I was lost as there was two lots of query = 'insert into which on the original there was only one of these, and this is part of the code I modified... Wasnt sure what to do with it, or maybe to just repeat the same code twice? eitherway, I thought I had better try and get an understanding from you as to what the extra bit is doing??

my code modified the following:

$query = 'insert into `'.TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK.'` (`products_id`,`stock_attributes`,`quantity`) values ('.$products_id.',"'.$strAttributes.'",'.$quantity.') ON DUPLICATE KEY UPDATE `stock_attributes` = "'.$strAttributes.'", `quantity` = '.$quantity;
                    $db->Execute($query);
                } 

to

$query = 'insert into `'.TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK.'` (`products_id`,`stock_attributes`,`quantity`,`smiffy_id`) values ('.$products_id.',"'.$attributes.'",'.$quantity.',"'.$smiffy_id.'")';
        } 

hope I am making sense... look forward to hearing from you.

PS - the search at the top didnt seem to work for me?

[GeorgieBrown]

Hi there,

I cleary must have gone wrong somewhere along the line as I do not seem to be able to find where I enter the stock value against the attributes for a product.

As far as I am aware I have followed the installation instructions ok.

Any guidance much appreciated.

[philip937]

Hi there,

I cleary must have gone wrong somewhere along the line as I do not seem to be able to find where I enter the stock value against the attributes for a product.

As far as I am aware I have followed the installation instructions ok.

Any guidance much appreciated.

To add quantitys to attributes you need to go to Catalog / Products with Attributes Stock

Here you should see a list of all products that have attributes assigned to them. click add quantity for variant, select your attribute type a stock level and your done. Afterward you need to sync stock. This adds up all the stock levels of the attributes and sets the main stock level for example:

S = 10
M = 12
L =1

Total stock 23

Hope that helps,
Phil
##############################___
Online Fancy Dress

[GeorgieBrown]

Brilliant - thanks Phil!