How to update pricings for all products in jigoshopMarch 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’
Limit to 5 sponsors.
OTHER ARTICLES YOU MAY LIKE
Remember the good old days when you could just go to a website and see what all your email addresses were? Those days are gone, unfortunately. One of the biggest problems for businesses and individuals is spam. Spammers send out millions of emails a day, hoping to catch people who are not expecting to receive […]read more
You may have seen the Weather and News widget appear on your Windows 10 taskbar after a recent update and today, I’m going to show you how to hide the Weather and News Widget. The Windows 10 taskbar is the central component of the Windows operating system that shows all the open programs and their […]read more