Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Changing the product id in the database


richtea

Recommended Posts

The product_id is an internal primary key, and not something the customer needs to be aware of, so you shouldn't be showing it anywhere really.

Plus, as an autoincrement field, it needs to be integer. Changing it to varchar will cause all sorts of problems unless you fully understand the ramifications.

Why do you want to do this, anyway? Why not just add another column and use that?

Link to comment
Share on other sites

Does anybody know if there is any way the database settings can be changed so that the product id can include numbers & letters instead of just numbers?

 

the column model was added to the table for this purpose ... what are you using that for? If already "occupied", I agree add a new column ...

:-)

Monika

 

addicted to writing code ... can't get enough of databases either, LOL!

 

my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum

 

Interactive Media Award July 2007 ~ category E-Commerce

my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...