Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 4255
Latest: andreios
New This Month: 3
New This Week: 1
New Today: 0
Stats
Total Posts: 43259
Total Topics: 7518
Most Online Today: 297
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 256
Total: 256

Author Topic: Is there a easy way to change the prices on all store items at once?  (Read 5149 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: 16436
    • 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: 16436
    • 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: 16436
    • 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
7225 Views
Last post January 26, 2007, 09:45:02 am
by SMFHacks
2 Replies
4374 Views
Last post September 14, 2011, 01:42:43 pm
by frustrated
2 Replies
3502 Views
Last post May 21, 2012, 08:54:11 am
by ApplianceJunk
5 Replies
6362 Views
Last post January 15, 2015, 08:11:43 pm
by SMFHacks
2 Replies
1261 Views
Last post July 28, 2021, 04:35:38 pm
by Saftek

+- Recent Topics

No thumbnails on new uploads by SMFHacks
March 27, 2024, 02:10:41 pm

Display the Contact Page for guests by SMFHacks
March 27, 2024, 10:55:43 am

is it possible to add support for odysee.com by fvlog19
March 21, 2024, 08:47:51 am

Request for admin notification by davejo
March 10, 2024, 01:31:59 am

I need help with torrent upload by Ineedsmfhelp
March 09, 2024, 10:01:13 pm

an idea for new mod (( content type with different display )) by SMFHacks
February 27, 2024, 01:36:27 pm

[Mod] RSS Feed Poster by SMFHacks
February 27, 2024, 11:57:18 am

find duplicate pictures by fvlog19
February 14, 2024, 02:22:40 pm

Error uploading video. by SMFHacks
February 08, 2024, 02:04:16 pm

Gallery icon as last added image by fvlog19
February 01, 2024, 01:04:56 pm

Powered by EzPortal