Modding Stock by Attribute to have SKUs / Model Number

[flowerchild5]

I know that alot of people have been trying to establish a SKU for Product variants. It seems to me that all that is needed is to add a another Column to database of "Stocks by Attributes". I did this and have been able to output the model #'s to the admin by editing the output code in the admin/products_with_attributes_stock.php file (haven't gotten to adding it to shopping cart and what not yet).

What I am having trouble with is making it so that I can add skus in the admin section like you are able to do with the attribute inventory. Would anybody happen to know the code to do this.

I think maybe this is what everybody may be looking for in order to have SKU's for Product attributes. Unfortunately my PHP skills are not up to par yet.

[flowerchild5]

For those of you wondering to output the attribute sku in Admin -> Products with attributes stock I first added another column to the table products_with_attributes_stock called attributes_sku

then to display this info I added or changed the following code in 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;
} 

This mod served my purposes so if any of you would like to take it any further, such as output this info to orders and or shopping cart or make the Attribute SKU editable via the admin please do so

[ryanb4614]

Is this working? Has it been tested?

[dkhoward]

Has there been any change or new information on these mods. I desperately need to be able to attach model numbers/SKU by attribute rather than to simple product description.

Help Please!