Stocks by attributes

[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

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

[jdhiler]

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

the only thing is did is reinstall the files, one by one instead of that sketchy way of dropping the entire folder on the install, which doesn't confirm exactly what gets copied where... at least not in Cyberduck.

[kuroi]

the only thing is did is reinstall the files, one by one instead of that sketchy way of dropping the entire folder on the install, which doesn't confirm exactly what gets copied where... at least not in Cyberduck.

This is a common problem. Some FTP tools appear not to overwrite by default. This usually happens when you have installed your Zen Cart after the date the mod was written. So your Zen Cart has installation date stamps, but the mod has older ones and the FTP client thinks the installed files are more current.

Hopefully they prompt you with an option to overwrite, but this doesn't appear to always happen, especially when the default is not to overwrite "newer" files. In that case, it's important to check the log file. Incomplete uploads are by far the most common reason for Stock by Attributes not working.

[DivaVocals]

the only thing is did is reinstall the files, one by one instead of that sketchy way of dropping the entire folder on the install, which doesn't confirm exactly what gets copied where... at least not in Cyberduck.

Ahhhh good old Cyberduck.. The only (free) FTP app for the Mac I could find that had a decent feature set and GUI.. But you are right it occasionally does not consistently overwrite files correctly.. I found myself switching to my PC to do all of my FTPing because of that..