Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Add New Fields To Products Table


Recommended Posts

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

Link to comment
Share on other sites



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.





Link to comment
Share on other sites

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.


Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...