Is there a easy way to change the prices on all store items at once?

[ApplianceJunk]

All the items in our store are the same price except for one item.

I was wondering if there was a easy way to change the prices on all of the store items at one time and then I could just go back and change the price on the one item that is different.

Hope that make sense...

Thanks,

[SMFHacks]

Yeah you can in the database using this sql command

Code: [Select]

Update smf_store_item SET price = '1.00'

Replace 1.00 withe price

[ApplianceJunk]

I have never used a sql command before.

Could you give me a step by step guide?

Thanks,

[ApplianceJunk]

Went into phpMyAdmin in cpanel and got to this screen.
Is this were I enter the sql command?

[SMFHacks]

Quick guide from SMF.org

you will need a program such as phpMyAdmin, which is used for MySQL database management. Most hosts provide this. If you are unsure of its location, please contact your host for guidance.

When you have successfully entered phpMyAdmin select the correct database from the left.

Then find the SQL tab and runt the query on your database.

[ApplianceJunk]

Done!

161 rows affected. ( Query took 0.0022 sec )

That is fricking awesome!

I should have asked before. I went though my store some time ago and manually changed each price from the item edit page, lol...

Thanks,

[SMFHacks]

Yeah SQL makes everything thing easy. Glad to help.