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


WHICH TOOLS TO USE WHEN CREATING ONLINE COURSES?

WHICH TOOLS TO USE WHEN CREATING ONLINE COURSES?

Online education has quickly become a widespread tool for any student around the world. It’s convenient, affordable, and allows for greater access to education for those who don’t have the opportunity to attend the courses at a physical location. Online courses are also a great way to supplement traditional education, allowing students to experience more […]

read more
BEST TOOL TO BACKUP MY WEBSITE

BEST TOOL TO BACKUP MY WEBSITE

If you’re an entrepreneur, business owner or simply someone who manages a website, you need to make sure your website is constantly backed up. I use to just write bash scripts on my VPS server to backup the website to an external NAS drive and sometimes the backup process would fail or the storage space […]

read more

Subscribe

Receive the latest news and awesome deals via email

Like our Page

site auditing tools