Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Mass change price


lucky644

Recommended Posts

Posted

I'm wondering if it would be possible to change ALL the prices of ALL the products in a category to the same price. Also would like to do the same thing with taxes....

 

Any way to do this?

Posted
I'm wondering if it would be possible to change ALL the prices of ALL the products in a category to the same price. Also would like to do the same thing with taxes....

 

Any way to do this?

 

that depends ... on your mysql version! If you have 4.1+, you can do it via phpmyadmin and sql statements

 

if not, one possibility would be to create a php page looping and changing the prices.

 

if this all seems to code based, try the quick updates contrib, but use an older version as the new ones have all kind if columns you will not need. The one I use is v2.6

:-)

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

Archived

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

×
×
  • Create New...