Stocks by attributes

I installed this mod and it's great... but there is one big problem... speed.

We have hundreds of combinations, because of the attribute variants and the process of adding a value hitting the refresh button and the page loading again is too tedious.

With that said, is there a way I can use easyPopulate (or something else) to make a flat-file to upload all my products? I know easyPopulate does this but I don't know if it works with this Stock By Attributes mod?

mattys:

I am having exactly the same problem - i have seen many posts like this that haven't been answered, I'd imagine it's prob something that's quite easy to fix - anyone care to advise?

I am also having the same problem here in that my customers can actully go through checkout and purchase goods that aren't in stock.
An example is I currently have a costume set up for 3 sizes but it has sold out of one yet it is still letting customers but the sold out size! It adjusts the total o stock left but not the figure in attributes.
This has been asked several times why is no one answering?

BlushFashions:

This has been asked several times why is no one answering?

People are likely not answering because the answer has been provided before. Unfortunately I haven't the time to search the thread for the exact message number or page within the thread. You may want to set your shop to not allow checkout for items that are out of stock. This is a setting that you control in the admin under Configuration & Stock.

This is so frustrating

this may have been answered, but it sure is hard as heck to find, and, considering there are so many of us that it isn't working for, couldn't someone just help out for a sec?

the system has been sitting redundant for an age now

this is meant to be the main thread for the software, if we can't find the answer here, and if you find it hard to find yourself, need i say more...

please, please, please help

mattys et al,
there's nothing you can do within Zen Cart except control settings in Configuration --> Stock.
If that doesn't work, then you need custom programming.
If no user has posted an answer it is either because they are unable (my case, as of yet), or too busy.
So what is the only option left? To hire somebody.
I hate to say this because I don't practice what I preach out of financial trouble at present, but if you have some reserves and really need it bad...

Hi ckosloff

I think you may not have grasped the nettle here.

The system almost works, it must just be a setting we are overlooking (perhaps because we are stupid) that would literally just take someone a very short period of time to advise us about.

It's not a matter of getting custom programming, or anything like that, just a couple minutes of someone's time. I know we are all busy and this is a tall order, that's why it is taking so much time for someone to answer, but this is why we have to keep asking.

I can't understand why it has gone this far and someone just doesn't help, you all seem to find the time to post reasosns why we can can't be helped - i don't quite get it, perhaps I am not quite grasping the nettle here!

hi **ckosloff**

Just to refresh you, this is what the problem is.

We have installed Stock By Attributes - this will hopefully, when working, allow us to add stock to attibutes, so, instead of stock being added to the whole product, you can add stock to attributes. Say, for arguements sake, you had a t-shirt for sale with 3 colours, red, green, blue, you could add stock for each colour, e.g. 3 in stock for red, 3 in stock for blue, 3 in stock for blue.

When the system works, if you sell all 3 red t-shirts, it should then flag the red t-shirt as sold out, or not allow users to order any more (until stock updated).

However, what is happening for us is that this is not happening, customers can still order the red t-shirt. The stock by attributes part isn't working and the whole number of stcok is taken into consideration, e.g. 9 t-shirts and not individual attributes stock.

mattys:

hi **ckosloff**

Just to refresh you, this is what the problem is.

We have installed Stock By Attributes - this will hopefully, when working, allow us to add stock to attibutes, so, instead of stock being added to the whole product, you can add stock to attributes. Say, for arguements sake, you had a t-shirt for sale with 3 colours, red, green, blue, you could add stock for each colour, e.g. 3 in stock for red, 3 in stock for blue, 3 in stock for blue.

When the system works, if you sell all 3 red t-shirts, it should then flag the red t-shirt as sold out, or not allow users to order any more (until stock updated).

However, what is happening for us is that this is not happening, customers can still order the red t-shirt. The stock by attributes part isn't working and the whole number of stcok is taken into consideration, e.g. 9 t-shirts and not individual attributes stock.
Yo,
I understood the problem.
Just look at the settings in Configuration --> Stock, there's nowhere else to go.
They are more or less self-explanatory, so try setting the first 3 to true, for example.
Do you have a test site set on your computer?
That's were you should test settings.
The fourth setting, Mark product out of stock, you can write some text there to instruct the customer.
The remaining 3 settings that control stock I leave to you.
In fact, my only recommendation is to set up a test site and play around with these settings until you are satisfied.
I'm sorry that my answer about hiring somebody aggravated you, just wanted to let you know that Ajeh answered a similar post to me, stating that if settings in Configuration --> Stock aren't enough, you need custom programming.
Forget about the mod, it just makes Stock by attributes possible, allowing out of stock checkout is controlled by the Admin, precisely in Configuration --> Stock.
Hope this helps.

thanks ckosloff

not aggrivated, just a little frustrated

i have test site online, will give it a go...

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?

mattys:

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.

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"

:smile:

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

MsHutch:

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.

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

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

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

MsHutch:

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.

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

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!