How to put same price in all products

[Reco-X]

Is there an easy and quick way to put all products the same price??

[musicmaster]

Either use a script like 

http://www.prestashop.com/forums/topic/185401-free-script-product-mass-edit-category-multi-edit-order-edit/

 

Or write your own mysql command.

[Carolina Custom Designs]

I agree with musicmaster.

 

If you are comfortable enough with sql you could run a simple query like

 

UPDATE `ps_product`
SET
    `price` = '200'

 

Keep in mind you will need to make appropriate adjustments based upon your prefix (ps_) and new price (200).

 

Marty Shue

[musicmaster]

Don't forget also to do 

 

UPDATE `ps_product_shop`
SET
    `price` = '200'

[Reco-X]

Thanks it works for me, i have a question:

What is the relation about these 2 tables?? product_shop and product?

[musicmaster]

There used to be only a product table. But in version 1.5 Prestashop went multi-shop and introduced the product_shop table. As far as I know the product table has no more any real function and is only there for the case some 1.4 modules might look for it.

[Reco-X]

I have a problem i try to run this query:

Update ps_product_shop as proshop 
inner join ps_product as pro
set proshop.PRICE = 40, pro.PRICE = 40
where pro.REFERENCE like "%b%"

But i have this error:

debug : #1317 - Query execution was interrupted

Do you know why is it??

[Reco-X]

It was my fault, the correct query is this:

 

Update ps_product_shop as proshop 
inner join ps_product as pro on pro.id_product = proshop.id_product
set proshop.PRICE = 40, pro.PRICE = 40
where pro.REFERENCE like "%b%"