Stocks by attributes

[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

[colinr]

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.

ColinR

[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

				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

				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

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

ColinR

I added the following code to admin/products_with_attributes_stock.php

Changed

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

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

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

right after

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

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

I added

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

and to admin/includes/stock_attributes.css

I changed

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

to

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

and changed

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

to

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

[jdhiler]

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.

[jdhiler]

okay, think i got it.

thanks anyway.

[DivaVocals]

okay, think i got it.

thanks anyway.

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

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

Thanks for any guidance.

[kuroi]

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.

[flowerchild5]

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