MYSQL Price increase

  • Posts: 81
  • Thank you received: 6
11 years 11 months ago #78655

What mysql query would you guys use to increase price of products by 35% and via which column???????


NEARLY THERE!!!!!

Please Log in or Create an account to join the conversation.

  • Posts: 26152
  • Thank you received: 4027
  • MODERATOR
11 years 11 months ago #78662

Hi,

You have to update the table #__hikashop_price and the column price_value.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
The following user(s) said Thank You: foxy3433

Please Log in or Create an account to join the conversation.

  • Posts: 81
  • Thank you received: 6
11 years 11 months ago #78663

What query would you use to change this throughout i can't seem to find the correct query been searching the net for days

Please Log in or Create an account to join the conversation.

  • Posts: 81
  • Thank you received: 6
11 years 11 months ago #78665

So i have so far:

CREATE EVENT e_update ON SCHEDULE EVERY 298 SECOND DO
UPDATE #__hikashop_price SET Col = Col + 4;


But what query increases the value correctly i don't want to mess up the store or would i do this better via PHP, i need to increase by 35% exactly.. Can anyone HELP this is my last help request before launch

Last edit: 11 years 11 months ago by foxy3433.

Please Log in or Create an account to join the conversation.

  • Posts: 26152
  • Thank you received: 4027
  • MODERATOR
11 years 11 months ago #78666

Hi,

I don't understand why you create an event.

UPDATE #__hikashop_price SET price_value = price_value * 1.35;
By replacing "#_" by your database prefix, like "jos_hikashop_price".

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 81
  • Thank you received: 6
11 years 11 months ago #78667

ooooo man you guys are the best... i'll try that now, the reason i thought i needed an even was to counteract the csv file cron update!!!!! thought it may revert my prices back to original price

Last edit: 11 years 11 months ago by foxy3433.

Please Log in or Create an account to join the conversation.

Time to create page: 0.066 seconds
Powered by Kunena Forum