Add New Fields To Products Table

[Guest]

I am looking for a simple way ( if it exists) to add a couple of fields to the product table, ie: SKU, UPC. Everything I have found in add ons looks as though they require some modification of php files. I am not a programmer as such and find this a bit overwhelming. Is there an add-on or mod that will handle all the necessary changes for me. Thanks...

[Guest]

@@mwhulsey

 

You can easily add a new cell in the products table, but in order to use that new cell, you have to add it to the PHP files. So, if you wanted to add a SKU field in the categories.php file,(after creating the table cell) you would need to create the field and add it to the database queries / posts to use the field.

 

There is no automated 'mod' to do this. If you are going to use osCommerce, an intermediate level of PHP experience is required.

 

 

 

Chris

[♥14steve14]

There are addons available with instructions on how to do this. http://addons.oscommerce.com/info/126/v,22

 

I used something similar to add manufacturers part numbers to admin/categories.php to allow easy re ordering.

 

As Chris has mentioned, certain skills are required. Starting with an already written addon, so you only need to read, copy and paste is a good starting point.