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

[delia]

Just now found the error in the file products_with_attributes_stock.php on line 482.

echo '<div id="pwa-table"';

IS MISSING >

It should read echo '<div id="pwa-table">';

Finally a fix for that! It was such a tiny thing that we all missed it!

So now I have a new problem. I haven't followed all of this thread so can't be sure this hasn't been discussed but it is a very strange item indeed.

The cart has 2 products that has a choice of fabrics and colors. So there are three separate attributes with images. Each has a different option name but using a dropdown with these means that each places something into the cart. One choice, three attributes - 2 of which say please choose.

I switched to radio buttons with no default. Only one choice shows in the shopping cart.

Fast forward to Stock by Attributes. When you go to insert the attribute with stock, all three choices show up. If you change one to the color and the other 2 to please choose, the shopping cart then requires that to show in the cart - in other words - just like with the dropdowns.

The client hates that and I can't blame her - it's actually confusing to the buyer.

So the question is, has anyone run into this scenario before?

It's a first for me and I work with zen cart full time.

[b005t3drsx]

Okay yes I have read through all I can find but I can't find anything that will help with my situation. Currently I own a t-shirt company. All my products have attributes from the option name size. There are 5 sizes. The problem I have is that people are able to order sizes that are out of stock. It does give a warning during the checkout. I want the system to not show the size in the drop down if the quantity is less than 1. Does anyone know how I can accomplish this?

You can see my link to my test item. Currently small has 4 and all other sizes have 0 but still allows you to order the item. Please help.

http://www.wickedfitapparel.com/inde...u2fmiq82ls7ee0

[Pablo]

Copy the code update on post 1133 of this thread - page 114 by athena. Replace all the code in your header_php.php file for this module. After code update, attributes with a zero stock level will not show so they cannot be selected.

[b005t3drsx]

I did that and it still doesnt work. Does anyone know what php the drop down is controlled by. I want to write my own code that will check the products_with_attributes table and if the quantity is 0 then have it now show in the drop down.

[Bob La Londe]

Using the latest version of Zen Cart 1.3.9h.

I am getting ready to implement this mod, and I have scanned through the installation, but the first step kinda stumps me.

It kinda sounds like I need to mod/create/change the database before uploading the MOD to my cart. How do I do that? If there is a post that spells that out just point me there and I'll read it. I'm not asking anybody to spell out what's already been posted.

I would like to point out that "read this thread" is a little onerous. At 133 pages its a bit hard to find anything. I've read quite a bit of it, but...

Create a new database table and a new configuration switch by running the 'stock_attribute.sql' via Admin->Tools->Install SQL Patches. If you prefer to use another method to create this table, you will need to edit the file if you use a prefix such as "zen_" for your tables.

Its the first step listed, but sounds like something you have to do after you upload it.

[Pablo]

The mod contains two sql patch files - stock_attribute.sql and update_1_4_10.sql. These files set up tables in your database so the mod has a place to put the data.

BACKUP YOUR DATABASE - BACKUP YOUR DATABASE - BACKUP YOUR DATABASE.

Copy the contents of the stock_attribute.sql file and log into your admin section.
Go to TOOLS and look for INSTALL SQL PATCHES
Open and paste the code into it and press SEND
Same for the other file

[Bob La Londe]

Using the latest version of Zen Cart 1.3.9h.

I am getting ready to implement this mod, and I have scanned through the installation, but the first step kinda stumps me.

It kinda sounds like I need to mod/create/change the database before uploading the MOD to my cart. How do I do that? If there is a post that spells that out just point me there and I'll read it. I'm not asking anybody to spell out what's already been posted.

I would like to point out that "read this thread" is a little onerous. At 133 pages its a bit hard to find anything. I've read quite a bit of it, but...



Its the first step listed, but sounds like something you have to do after you upload it.

Ok, I uploaded it using File Zilla and then tried it. I got this.

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'stock_attribute.sql' at line 1
in:
[stock_attribute.sql;]
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.

[Bob La Londe]

The mod contains two sql patch files - stock_attribute.sql and update_1_4_10.sql. These files set up tables in your database so the mod has a place to put the data.

BACKUP YOUR DATABASE - BACKUP YOUR DATABASE - BACKUP YOUR DATABASE.

Copy the contents of the stock_attribute.sql file and log into your admin section.
Go to TOOLS and look for INSTALL SQL PATCHES
Open and paste the code into it and press SEND
Same for the other file

Thanks. Not at all what I expected.

[Bob La Londe]

Thanks. Not at all what I expected.

Ok, the stock attribute worked fine cut and paste, but the update gave me this error.

1062 Duplicate entry 'STOCK_SHOW_IMAGE' for key 2
in:
[INSERT INTO zen_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Display Images in Admin', 'STOCK_SHOW_IMAGE', 'false', 'Display image thumbnails on Products With Attributes Stock page? (warning, setting this to true can severly slow the loading of this page):', '9', '6', NULL, now(), NULL, "zen_cfg_select_option(array('true', 'false')," );]
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.

[Pablo]

That means you already had that entry in your database and MySql won't let you have duplicate entries exactly the same.
Since it was already there, you can just ignore the warning.