Facebook  Twitter 

SMFHacks.com

+- +-

SMFHacks.com

+- User Information

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+- Forum Stats

Members
Total Members: 11801
Latest: Dimon_1955
New This Month: 7
New This Week: 2
New Today: 1
Stats
Total Posts: 41510
Total Topics: 7264
Most Online Today: 47
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 33
Total: 33

Author Topic: Is there a easy way to change the prices on all store items at once?  (Read 3715 times)

0 Members and 1 Guest are viewing this topic.

Offline ApplianceJunk

  • Sr. Member
  • ****
  • Posts: 432
    • View Profile
    • ApplianceJunk.com
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,

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15709
    • View Profile
Re: Is there a easy way to change the prices on all store items at once?
« Reply #1 on: January 21, 2013, 07:20:42 pm »
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
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline ApplianceJunk

  • Sr. Member
  • ****
  • Posts: 432
    • View Profile
    • ApplianceJunk.com
Re: Is there a easy way to change the prices on all store items at once?
« Reply #2 on: January 21, 2013, 07:23:29 pm »
I have never used a sql command before.

Could you give me a step by step guide?

Thanks,

Offline ApplianceJunk

  • Sr. Member
  • ****
  • Posts: 432
    • View Profile
    • ApplianceJunk.com
Re: Is there a easy way to change the prices on all store items at once?
« Reply #3 on: January 21, 2013, 07:31:05 pm »
Went into phpMyAdmin in cpanel and got to this screen.
Is this were I enter the sql command?
« Last Edit: January 21, 2013, 07:32:51 pm by ApplianceJunk »

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15709
    • View Profile
Re: Is there a easy way to change the prices on all store items at once?
« Reply #4 on: January 21, 2013, 07:31:11 pm »
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.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline ApplianceJunk

  • Sr. Member
  • ****
  • Posts: 432
    • View Profile
    • ApplianceJunk.com
Re: Is there a easy way to change the prices on all store items at once?
« Reply #5 on: January 21, 2013, 07:36:49 pm »
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,

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15709
    • View Profile
Re: Is there a easy way to change the prices on all store items at once?
« Reply #6 on: January 21, 2013, 07:39:29 pm »
Yeah SQL makes everything thing easy. Glad to help.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

 

Related Topics

  Subject / Started by Replies Last post
1 Replies
6448 Views
Last post January 26, 2007, 09:45:02 am
by SMFHacks
2 Replies
2762 Views
Last post September 14, 2011, 01:42:43 pm
by frustrated
2 Replies
2576 Views
Last post May 21, 2012, 08:54:11 am
by ApplianceJunk
5 Replies
4540 Views
Last post January 15, 2015, 08:11:43 pm
by SMFHacks
2 Replies
93 Views
Last post July 28, 2021, 04:35:38 pm
by Saftek

+- Recent Topics

prettyurls - TroubleShooting.wiki by SF
October 26, 2021, 04:39:52 pm

Stats Page by mickjav
October 19, 2021, 01:10:42 pm

Question (Gallery Pro) by mickjav
October 17, 2021, 11:59:10 am

Image View by SMFHacks
October 14, 2021, 11:55:21 am

From SMF Gallery Lite to SMF Gallery Pro by SMFHacks
October 11, 2021, 08:00:29 am

Picture Orientation by mickjav
October 09, 2021, 01:25:54 pm

4. Global Headers and Footers by mickjav
October 07, 2021, 12:22:09 am

S3 System For SMF Attachments by shuban
October 06, 2021, 07:58:50 am

Download Page images by mickjav
October 04, 2021, 01:28:07 pm

Agree To Licence by mickjav
October 03, 2021, 10:00:27 am

Powered by EzPortal