Basically I needed a custom part number that was separate from the product code. Not only did I need to add this on the product page in the admin, but I also wanted to see it on the order details page in the admin. This addon/mod does both of those.
A big thank you goes out to Tony Birnseth (TonyB). He is the one that made this actually work. He is also the one that made this more of an addon rather than just a mod.
This is a partial addon / partial mod. Unfortunately I don’t know how to do a hook on the product page or to do the SQL stuff, so that has to be done manually, sorry.
So here is how to make this work.
1.) In you phpmyadmin run this:
ALTER TABLE `cscart_products` ADD `part_no` INT AFTER `product_code` ;
```<br />
<br />
2.) Upload the included files<br />
<br />
3.) If you have already modified skins/basic/admin/views/products/update.tpl then:<br />
<br />
Add:<br />
<br />
```php
<div class="form-field"><br />
<label for="product_part_no">{$lang.part_no}:</label><br />
<input type="text" name="product_data[part_no]" id="product_part_no" size="100" value="{$product_data.part_no}" class="input-text-medium" style="width:300px" /><br />
</div>
```<br />
<br />
After:<br />
<br />
```php
<div class="form-field"><br />
<label for="product_product_code">{$lang.product_code}:</label><br />
<input type="text" name="product_data[product_code]" id="product_product_code" size="20" maxlength="32" value="{$product_data.product_code}" class="input-text-medium" /><br />
</div>
```<br />
<br />
That's it, pretty simple.<br />
<br />
I'm using this in version 2.2.1 Pro and haven't tested it on any other versions. I don't see why id wouldn't work, but I don't know for sure.<br />
<br />
Thank you,<br />
<br />
Brandon<p><a href="127.0.0.1/uploads/monthly_08_2011/post-9196-0-75457900-1313869611.ipb">Add Field To Order Page.zip</a></p>