Simple Question about MSRP Contribution

[kdawg62]

Instructions tell me to add this...

 

1. Add a new field to the products table to hold the MSRP value.

 

ALTER TABLE `products` ADD `products_msrp` DECIMAL( 15, 4 ) NOT NULL AFTER `products_image` ;

 

 

 

 

I was able to add the rest of the code just fine. I do now know where the products table is located, or which file it refers to. Just need someone to point me in the right direction.

 

Thanks

 

Kyle

[lrparr]

Instructions tell me to add this...

 

1. Add a new field to the products table to hold the MSRP value.

 

ALTER TABLE `products` ADD `products_msrp` DECIMAL( 15, 4 ) NOT NULL AFTER `products_image` ;

I was able to add the rest of the code just fine. I do now know where the products table is located, or which file it refers to. Just need someone to point me in the right direction.

 

Thanks

 

Kyle

 

The table is in your oscommerce database. The easiest way to edit is using a tool like phpmyadmin, which is usually available in the admin of your hosting company, and run the SQL statement above. Hope that helps.

[bygzee]

HELP!! AFTER INSTALLING THIS, ALL MY WEEKS OF WORK GOT RUINED. cAN SOMEONE PLEASE TELL ME HOW TO REVERSE THE NEW FIELD THAT I ADDED TO THE PRODUCTS TABLE. I DELETED ALL THE FILES THAT CAME WITH THIS CONTRIBUTION. HOWEVER, I STILL SEE THE WORDS 'OUR PRICE' AND PERCENT DISCOUNT. HOW DO I REVERSE THE FIELD THAT I ADDED TO THE SQL???

1. Add a new field to the products table to hold the MSRP value.

 

ALTER TABLE `products` ADD `products_msrp` DECIMAL( 15, 4 ) NOT NULL AFTER `products_image` ;

I was able to add the rest of the code just fine. I do now know where the products table is located, or which file it refers to. Just need someone to point me in the right direction.

 

Thanks

 

Kyle