Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Add SRP price to all products


shabayek

Recommended Posts

Hi,

 

I want to add a new price field for all my products, SRP (Suggested Retail Price) so that it shows this way,

 

Product's SRP=

Our Price=

You save =

%=

 

(apart from the Specials sections, which I'll be using as well for further discounts)

 

I think I must add a new field to the database, and alter the admin/catalog ...

 

Can some1 help me with the details, never before changed a structure of MySql DB.

 

Thanx

Link to comment
Share on other sites

If you use phpmyadmin, you can select "add a field", and then enter the datatype, default value, and whether or not it accepts null vaules.

 

You won't mess anything up by attempting to add a colum.

-------------------------------------------------------------------------------------------------------------------------

NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit.

If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...