Stocks by attributes

That is fantastic mauryg! thX so much for going the extra mile and then some. It is truly appreciated and will save a lot of setup time.

Also, i want to thank everyone again for being so nice to someone who is new to the neighborhood. It didn't take long for me to feel at home. :D

P.S. Since i've gotten such great help, i thought i'd push my luck and ask again about hiding out of stock attributes. Any help would still be great. :wink: There seems to be some good starting suggestions here but i've still had no luck nor have i via searching the forums.

Hi,

Sorry if this has been posted, I've been searching the thread but don't see an answer.

I have one product with 2 attributes. When i try to add stock i get 2 drop down boxes, 1 for each attribute. You must select a value from each drop down box and enter the quantity.

My problem is that my attributes are not related, the product is made up fo 2 articles, eg a football strip, you buy one outfit and it is made up of a shirt and shorts. I have different quantities and different sizes, so i need to enter the quantities independantly.

Anyone had the same problem, any ideas.

Cheers
Andy

mauryg:

Once that is done you may find that "Stock with Attributes" will treat each of the sizes as a separate product and maintain the inventory for you.Stock by Attribute doesn't differentiate between attribute combinations created individually through the Admin, or in bulk through Easy Populate. It's happy to work with either. Though it would still be necessary to add the stock on combination at a time.

gandalf:

I have one product with 2 attributes. When i try to add stock i get 2 drop down boxes, 1 for each attribute. You must select a value from each drop down box and enter the quantity.

My problem is that my attributes are not related, the product is made up fo 2 articles, eg a football strip, you buy one outfit and it is made up of a shirt and shorts. I have different quantities and different sizes, so i need to enter the quantities independantly.Actually your attributes aren't really attributes in the way in which Zen cart understands the term. They are two physically separate products combined to create a product bundle.

Zen Cart can't handle this at present. Indeed, to do so would require a very different data structure to that currently used. The complexity is that the sale of a particular product bundle (e.g. red shirt + blue shorts)can affect the stock of other product bundles (e.g. white shirt + blue shorts and yellow shirt + blue shorts). Handling this inter-dependancy between product bundles is not part of core code, nor to my knowledge planned to be added.

The best that I can suggest is treating your products as separate products (red shirt, white shirt, yellow shirt and blue shorts) and then linking each shirt to appropriate colored shorts, and visa-versa, via the cross-sell module. Otherwise it would require a ton of custom development.

Thanks Kuroi,

Understand, will check out your suggestion.

Thanks
andy

shannda:

I have recently upgraded my clients site to 1.3.7.1 and the Stock by Attributes module is no longer working correctly. Customers are placing orders for items where the stock is zero. I've installed the most current version of the module 4.5. The host is running PHP5. Does anyone know if the module is compatible with PHP5?

The store is obviously live and my client is very understandable but its something I would love to get resolved for her.

Thanks in advance for any info or suggestions you can offer.I no longer have the wherewithall to test it and run it with anything else.

Can you tell us more about how you performed the upgrade? And what version you upgraded from?

Thanks for you reply. I was running Stock Attribute v3.01 under zencart 1.3.0.2. I followed the instructions step by step and since having the problem I've gone over several times. Basically at a loss, normally I can figure this stuff out but with this one I'm stumped.

shannda:

I was running Stock Attribute v3.01 under zencart 1.3.0.2. I followed the instructions step by stepThe version 4.5 package doesn't include any instructions for upgrading from version 3. Which instructions did you follow? In particular, did you run any SQL?

I have the same issue problem as shannda and am interested in the solution.

In my case, the shopping cart recognizes when the order will exceed the OVERALL available inventory level for a particular product and it properly displays the "mark product out of stock" message in the cart. However, when there is insufficient inventory for an INDIVIDUAL attribute (i.e. Small size), the cart does not display "mark product out of stock" (re: Admin>Config>Stock). What happens is the order becomes a purchase without sufficient inventory and the customer is not alerted that they are purchasing a "back order."

Suggestions greatly appreciated!

I am running a fresh install of v1.3.7.1 with a fresh install of the mod v4.5.

websitebob

p.s. great work on the mod!

websitebob:

I have the same issue problem as shannda and am interested in the solution.

In my case, the shopping cart recognizes when the order will exceed the OVERALL available inventory level for a particular product and it properly displays the "mark product out of stock" message in the cart. However, when there is insufficient inventory for an INDIVIDUAL attribute (i.e. Small size), the cart does not display "mark product out of stock" (re: Admin>Config>Stock). What happens is the order becomes a purchase without sufficient inventory and the customer is not alerted that they are purchasing a "back order."

Suggestions greatly appreciated!

I am running a fresh install of v1.3.7.1 with a fresh install of the mod v4.5.I have heaps of test environments with the mod installed and have never been able to replicate this problem. If somebody has a non-live but publicly accessible Zen Cart with this problem and is prepared to let me poke about behind the scenes (i.e. give me FTP access) I'm rather curious to understand what is going on here too.

I installed this mod and did not realize that every product with attributes would suddenly be set to zero. We have shirts that are produced when ordered so the mod will not work for me as you have mentioned before in this thread in term of infinite stock items. How does one go about safely removing this mod?

Thanks Kuroi

I'd give you FTP access, except I'm working on a standalone (MAMP). I can email you a zip of the site (about 4MB) with a SQL dump if you'd like to test that. Just PM your preferred email.

Thanks and regards

websitebob

Hi.

I have installed danielcor's Stock Attribute 3.01.1 module and am getting the following error when i click DEFINE VARIANT in the Admin under Catalog > Products by Attributes Stock:

1146 Table 'realdnahair_co_uk_-_001.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 = 553]

Any idea what this means or what could be done?

Thanks, Kyle Duncan

kylelondonuk:

I have installed danielcor's Stock Attribute 3.01.1 module and am getting the following error when i click DEFINE VARIANT in the Admin under Catalog > Products by Attributes Stock:

1146 Table 'realdnahair_co_uk_-_001.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 = 553]

Any idea what this means or what could be done?It means that the table "product_attributes" doesn't exist in your database.

How did you install the database patch?

I uploaded the SQL file from the download via zen admin install sql patches. it successfully created the zen_products_with_attributes_stock module.

but the table zen_products_attributes does exist... i've been using products that have attributes for a while now without problems.

is one of the php files with this module just missing the code that adds the zen_ prefix or something?

just a thought, i have super orders 2.0 installed, could this cause a problem since i know it also updated order php files?

Thanks, Kyle

kylelondonuk:

I uploaded the SQL file from the download via zen admin install sql patches. it successfully created the zen_products_with_attributes_stock module.

but the table zen_products_attributes does exist... i've been using products that have attributes for a while now without problems.

is one of the php files with this module just missing the code that adds the zen_ prefix or something?

just a thought, i have super orders 2.0 installed, could this cause a problem since i know it also updated order php files?

Thanks, Kyle

sorry i meant that the SQL file i uploaded in Zen Admin successfully created the
zen_products_with_attributes_stock TABLE, and added all the necessary values to the zen_configuration table. so it must be an error in one of the php files that came with the module i guess?

thanks

The SQL that comes with 3.01.1 doesn't use the prefix zen_. That was a bad approach taken in Danielcor's original 3.01 version. So I wonder whether you have downloaded the older version, which has a few minor bugs.

Eitehr way, you should be able to correct this by editing the "zen_" out of the table name in your database.

However, unless you are using Zen Cart 1.3.0, 1.3.0.1 or 1.3.0.2, I wouldn't recommend the Danielcor mod. Stock by Attributes is very sensitive to the version of Zen Cart with which it is paired.

kuroi:

I have heaps of test environments with the mod installed and have never been able to replicate this problem. If somebody has a non-live but publicly accessible Zen Cart with this problem and is prepared to let me poke about behind the scenes (i.e. give me FTP access) I'm rather curious to understand what is going on here too.

Thanks to Kuroi for the prompt assistance.

I sent him a zip of my test site and he quickly found that I did not overwrite 3 of the files. Admittedly, I tried to go slowly through the mod installation. But, it gets tricky because several of the admin and includes files carry the same name in both folders.

My advice to anyone else out there.... always back up before you drag new files in from a mod and overwrite the existing files. Its easy to lose your place and its tricky to undo. Better yet, work with it first on a standalone server, if you can.

This mod rocks.

Kudos to Kuroi!
websitebob

i've been reading through this section for over an 2 hours now and i'm trying to figure out this one problem i have, hopefully there is an answer out there.

1. for Products marked with *** are out of stock warning in the shopping cart. instead of having the *** next to the item name i'd like to have the available stock quantity listed.

i seen this somewhere earlier i just don't know where it is.

woodlandsprite:

wahoo! I have it fixed. The trick is to go to the 1.2.7 thread and apply the appropriate changes to the following file:

includes/modules/your template/attributes.php

I'm sorry that I'm slow in getting this, but I see the thread that you are referring to, but I don't understand what I'm supposed to change in the attributes.php file to make the quantity show in the attribute. Thanks for any information that you can provide!