Stocks by attributes

[ckosloff]

Hi

I did all you said above but i did a test order of a product that only had 3 in stock, added 4 to basekt and checked out fine, shouldn't be able to do this.

The fact that you say i should get custom programming confuses me a little - this add on should deal with stock levels for attributes as i want it to, so, there is no question of custom programming.

Don't get it.

Has anyone reading this had the same problem, but eventually sorted it?

Actually I wasn't saying anything, just suggesting to play around with settings...
Are you sure that you have Configuration --> Stock --> Allow checkout set to false?
This is the setting that controls the checkout out of stock.
Hardly I find that the mod has anything to do with it, since it calculates totals for all the product variants, if those are exceeded it shouldn't be allowing checkout.
Sorry but unable to help you further, at risk to frustrate you even more I have to tell you that it does work for me.

[Redcinamn]

You must turn off the option too allow that ..

admin-->config-->stock-->allow checkout -->set to false


there is also where you can set your custom message at checkout under mark product out of stock such as "enter a lower number"

[MsHutch]

I am getting the following error after installing this module. Can anyone help me to correct it?

 
1146 Table 'bayvi6_zc1.products_attributes' doesn't exist
in:
[SELECT pot.products_options_types_name AS name FROM products_attributes pa INNER JOIN (products_options po INNER JOIN products_options_types pot ON po.products_options_type = pot.products_options_types_id) ON pa.options_id = po.products_options_id WHERE pa.products_attributes_id = 8094]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Thank you,

Colleen

[kuroi]

I am getting the following error after installing this module. Can anyone help me to correct it?

It's not clear from your post whether "this" module is "StockAttributes by danielcor" or my more recent "Stock by Attributes". However, the installation instructions for both have as their first step the application of a database patch, which your error message suggests you haven't done.

[MsHutch]

This is the stockattribute_by_danielcor_3.01.1. I have applied the database patch, and the zen_products_with_attributes_stock table has been created. The database prefix zen_ is what the problem seems to be. Any idea?

Thanks,

Colleen

[kuroi]

This is the stockattribute_by_danielcor_3.01.1. I have applied the database patch, and the zen_products_with_attributes_stock table has been created. The database prefix zen_ is what the problem seems to be. Any idea?

Your assessment is correct, but this is all a little odd. The original 3.01 version of stockattribute by danielcor erroneously included the zen_ prefix in the SQL patch; but the 3.01.1 version corrected that.

The easiest route forward for you though, would be to simply edit the table name directly to remove the zen_ prefix, e.g. via phpMyAdmin.

Also, what version of Zen Cart are you using? My stock by attributes came into being as a result of client pressure when it became clear that stockattributes by danielcor wasn't completely compatible with Zen Cart 1.3.5. The version that you are using is based on that earlier version and an inspection of the code suggest to me that most of the subsequent Zen Cart enhancements and security patches
are absent, and I would be surprised with this were fully-compatible with any version of Zen Cart outside the range 1.3.0-1.3.0.2 though I'd be happy to be proven wrong.

[MsHutch]

Thank you for taking the time to answer my question. I had a feeling that I would not be able to use this version with the most up to date version of Zen Cart(1.3.7). The way it is listed in the downloads section of this site led me to believe that it had been updated recently, Aug. 31, 2007. The only reason for using this module instead of yours is that I need to be able to stock by only one of the numerous attributes I have for many of my products. Is there a way to do that with your version?

Thank you again,

Colleen

[kuroi]

The way it is listed in the downloads section of this site led me to believe that it had been updated recently, Aug. 31, 2007. The only reason for using this module instead of yours is that I need to be able to stock by only one of the numerous attributes I have for many of my products. Is there a way to do that with your version?

It was updated in August of this year. Unfortunately, it was an update to an old set of code creating a fork.

It's a pity because the new features would have been great to add the more solid and up-to-date base that mine created. Sadly now you have to pick which best meets your needs. Sounds like for you that's Stockattributes rather than stock by attributes.

[MsHutch]

Thank you again. I guess I will have to figure out some other way of taking care of this.

[woodlandsprite]

Ms Hutch - thanks for posting about the update. I didn't know there was a new upgrade available.

Does anyone here know how to edit/update a sql table (I already have this mod installed and I wish to update it to the most recent version).

The sql file with the download executes a "create" order but I don't need to create the table - it already exists.

Thanks!