[Solved] SQL Query to mass update product weight

[syntaxed]

Hi. I am trying to set up shipping cost per item based on weight and I'm still new with SQL.

 

1. How can I update all the weight of each item in my store to 1 using SQL query?

2. How can I set the default weight of new item as 1?

 

I tried the following query but it gives the error below. Currently running the 1.5.4.1 prestashop

 

update 'ps_product' set weight=1

 

The error:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''ps_product' set weight=1' at line 1

Edited August 14, 2013 by syntaxed (see edit history)

[PascalVG]

He doesn't like your type of quotes around ps_product. Use ` instead of '

 

Try copy this:

UPDATE `ps_product` SET weight= 1

 

My $0.02,

pascal

[syntaxed]

He doesn't like your type of quotes around ps_product. Use ` instead of '

 

Try copy this:

UPDATE `ps_product` SET weight= 1

 

My $0.02,

pascal

 

Thanks! that works great. I'm sorry, but I have another silly question. How do I even type that type of quote on my keyboard?

[vekia]

i suppose that instead ` you can use simple apostrophe '

[syntaxed]

seriously, I don't know how you guys get that different type of quotes. I only manage to get just ' so far. I'll look more into this. Thanks

[PascalVG]

Om my keyboard it's top row, all the way left, together with ~

[syntaxed]

Om my keyboard it's top row, all the way left, together with ~

 

ah! now I see it. blimey. Thanks!

[thewordsmith]

private function _postProcess(){
        // Saving new configurations
        if(Configuration::updateValue('PS_SHIPPING_METHOD', Tools::getValue('PS_SHIPPING_METHOD')))

          

 

}

 

Some thing like that.

Edited January 25, 2014 by thewordsmith (see edit history)