How to update pricings for all products in jigoshop

March 24, 2012   /   by Marco  / Categories :  Technology

REMEMBER to backup your database before making any changes!!!

In order to change the prices for all products in your store, you will need to get into your database (mysql) and run an SQL statement. Here’s an example to change the prices for ALL PRODUCTS to 90% of the original price:

update wp_postmeta set meta_value = meta_value * 0.9 WHERE meta_key = ‘regular_price’

DO YOU LIKE WHAT YOU'VE READ?
Join our subscription list and receive our content right in your mailbox. If you like to receive some Great deals our Freebies then subscribe now!

Our Sponsors

  • Follow us:

OTHER ARTICLES YOU MAY LIKE


USE FUSEBASE TO AUTOMATE TEAMWORK AND COLLABORATION

USE FUSEBASE TO AUTOMATE TEAMWORK AND COLLABORATION

If your business is growing, your team is juggling too many moving parts, and your client communication is spread across email threads, chat apps, documents, task boards, and endless follow ups, there is a good chance the real problem is not effort but fragmentation. Most businesses do not lose time because people are lazy. They […]

read more
USING REAP FOR VIDEO CLIPS

USING REAP FOR VIDEO CLIPS

Short form video is now one of the most effective ways to reach new audiences, grow brand awareness, and turn long form content into a steady stream of social media assets. For creators, marketers, consultants, educators, and business owners, the challenge is rarely a lack of content. The real problem is time. Editing long videos […]

read more

Like our Page