Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

MSRP Contrib, sql?


giellacustoms

Recommended Posts

it says in the contrib http://addons.oscommerce.com/info/3574 to 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` ;

 

To be honest i have never made my own sql file too load to MySQL, I have only loaded .sql files that have been pre-made. Can someone point me in the right direction or make an .sql file for this so that I can see how to do it. Or you could paste it here and I will make it. THANKS

Link to comment
Share on other sites

Log into your site cpanel, click on phpMyAdmin, if your database doesnt come up automatically, select it, click on any item in the dBase, say address_book

then click on SQL, past the query provided into the box, removing whats there by default, click on GO, you should get confirmation that everything was processed

 

OK.

Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Link to comment
Share on other sites

Log into your site cpanel, click on phpMyAdmin, if your database doesnt come up automatically, select it, click on any item in the dBase, say address_book

then click on SQL, past the query provided into the box, removing whats there by default, click on GO, you should get confirmation that everything was processed

 

OK.

 

but i dont know how to make the text file in order to load it

Link to comment
Share on other sites

Change the word past to paste, then you do,n't need a text file.

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...