Stocks by attributes

[kuroi]

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?

[shannda]

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.

[kuroi]

I was running Stock Attribute v3.01 under zencart 1.3.0.2. I followed the instructions step by step

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

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

websitebob

p.s. great work on the mod!

[kuroi]

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.

[webm0nster]

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?

[websitebob]

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

[kylelondonuk]

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

[kuroi]

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?

[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