Stocks by attributes

Hi all,

I'm running Zen Cart 1.3.8a with the Product attributes with Stock, latest version. It seemed to be working.

However now, when I set a quantity for a single variant. It marks all of the variants as out of stock.

You guys experienced this before.

Thanks in advance.

Rich

Quote:

---

Originally Posted by flowerchild5

I added an additional column in the database for product attribute product codes. I called it attribute_skus. I have not yet figured out how to make this editable in admin, but it is pretty easy to add the model #'s in PHPmyAdmin. I was able to get the model #'s to display in the same table in admin though so that I am able to verify I added them to the correct variant. If you would like this code I can provide it.

---

Yes please! That would be a big help. :smile:

ColinR

Quote:

---

Originally Posted by rhlee

Hi all,

I'm running Zen Cart 1.3.8a with the Product attributes with Stock, latest version. It seemed to be working.

However now, when I set a quantity for a single variant. It marks all of the variants as out of stock.

You guys experienced this before.

Thanks in advance.

Rich

---

I found the bugger.

products_with_attributes_stock.php line 234

Code:

---

                                for ($i = 0;$i < sizeof($arrNew);$i++) {
                                        $strAttributes = implode(",", $arrNew[$i]);
                                        $query = 'insert into `'.TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK.'` (`products_id`,`stock_attributes`,`quantity`) values ('.$products_id.',"'.$strAttributes.'",'.$quantity.') ON DUPLICATE KEY UPDATE `stock_attributes` = "'.$strAttributes.'", `quantity` = '.$quantity;
                                        $db->Execute($query);
                                }

---

should be

Code:

---

                                for ($i = 0;$i < sizeof($arrNew);$i++) {
                                        sort($arrNew[$i])
                                        $strAttributes = implode(",", $arrNew[$i]);
                                        $query = 'insert into `'.TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK.'` (`products_id`,`stock_attributes`,`quantity`) values ('.$products_id.',"'.$strAttributes.'",'.$quantity.') ON DUPLICATE KEY UPDATE `stock_attributes` = "'.$strAttributes.'", `quantity` = '.$quantity;
                                        $db->Execute($query);
                                }

---

Otherwise the attributes will display in the wrong order on the field

Quote:

---

Originally Posted by flowerchild5

I added an additional column in the database for product attribute product codes. I called it attribute_skus. I have not yet figured out how to make this editable in admin, but it is pretty easy to add the model #'s in PHPmyAdmin. I was able to get the model #'s to display in the same table in admin though so that I am able to verify I added them to the correct variant. If you would like this code I can provide it.

---

Quote:

---

Originally Posted by colinr

Yes please! That would be a big help. :smile:

ColinR

---

I added the following code to admin/products_with_attributes_stock.php

Changed

PHP Code:

---

echo '<th class="stockAttributesHeadingStockId">'.PWA_STOCK_ID.'</th><th class="stockAttributesHeadingVariant">'.PWA_VARIANT.'</th><th class="stockAttributesHeadingQuantity">'.PWA_QUANTITY_IN_STOCK.'</th><th class="stockAttributesHeadingEdit">'.PWA_EDIT.'</th><th class="stockAttributesHeadingDelete">'.PWA_DELETE.'</th>'; 


---

To

PHP Code:

---

echo '<th class="stockAttributesHeadingStockId">'.PWA_STOCK_ID.'</th><th class="stockAttributesHeadingVariant">'.PWA_VARIANT.'</th><th class="stockAttributesHeadingSku">'.PWA_ATTRIBUTES_SKU.'</th><th class="stockAttributesHeadingQuantity">'.PWA_QUANTITY_IN_STOCK.'</th><th class="stockAttributesHeadingEdit">'.PWA_EDIT.'</th><th class="stockAttributesHeadingDelete">'.PWA_DELETE.'</th>'; 


---

and added

PHP Code:

---

echo '<td class="stockAttributesCellSku">'."\n";
            echo $attribute_products->fields['attributes_sku'];
            echo '</td>'."\n"; 


---

right after

PHP Code:

---

sort($attributes_output);
            echo implode("\n",$attributes_output); 


---

and to admin/includes/languages/english/products_with_attributes_stock.php

I added

PHP Code:

---

define('PWA_ATTRIBUTES_SKU', 'Attributes SKU'); 


---

and to admin/includes/stock_attributes.css

I changed

PHP Code:

---

.stockAttributesHeadingStockId,
.stockAttributesHeadingVariant,
.stockAttributesHeadingQuantity,
.stockAttributesHeadingEdit,
.stockAttributesHeadingDelete {
    border-bottom: 1px solid #ccc;
    width:18%;
} 


---

to

PHP Code:

---

.stockAttributesHeadingSku,
.stockAttributesHeadingStockId,
.stockAttributesHeadingVariant,
.stockAttributesHeadingQuantity,
.stockAttributesHeadingEdit,
.stockAttributesHeadingDelete {
    border-bottom: 1px solid #ccc;
    width:18%;
} 


---

and changed

PHP Code:

---

.stockAttributesCellStockId,
.stockAttributesCellVariant,
.stockAttributesCellQuantity,
.stockAttributesCellEdit,
.stockAttributesCellDelete {
    border-bottom: 1px dotted #ccc;
} 


---

to

PHP Code:

---

.stockAttributesCellSku,
.stockAttributesCellStockId,
.stockAttributesCellVariant,
.stockAttributesCellQuantity,
.stockAttributesCellEdit,
.stockAttributesCellDelete {
    border-bottom: 1px dotted #ccc;
} 


---

total noob question:

just installed stock with attributes mod 4.7.ajax over zencart 1.3.8a using barebones template that's i've customized a little.

when choosing Catalog > Products with Attributes Stock i get a blank page, except for this:

"No input file specified."

i'm sure it's something easy and obvious, but i'm missing it. duh.

thanks for your help.

okay, think i got it.

thanks anyway.

Quote:

---

Originally Posted by jdhiler

okay, think i got it.

thanks anyway.

---

Wanna share what you did.. it might help others who may be reading this thread..

I have just tried to install the stock by attributes mod. I ran the stock_attribute.sql through Admin-Tools-Install SQL Patches. However, I do not have the "Products with Attributes Stock" option under Admin-Catalog. I logged into my web host Cpanel and see the zen_products_with_attributes_stock table was created. Am I missing a step?

Thanks for any guidance.

Quote:

---

Originally Posted by edeades

I have just tried to install the stock by attributes mod. I ran the stock_attribute.sql through Admin-Tools-Install SQL Patches. However, I do not have the "Products with Attributes Stock" option under Admin-Catalog. I logged into my web host Cpanel and see the zen_products_with_attributes_stock table was created. Am I missing a step?

---

It sounds as though you didn't copy the files to your site, or put them in the wrong place.

Quote:

---

Originally Posted by kuroi

It sounds as though you didn't copy the files to your site, or put them in the wrong place.

---

check to make sure you did not rename your admin folder and did not adjust your upload files accordingly. I made this mistake :oops: