How to update product price and stock using my sql or csv import

[awahab]

Hi,

 

I am a new in Prestashop can any buddy knows how to update the product price and stock through using the query or cvs import or any other method to update these product info.

 

 

[RogueWaveLimited]

I think you can create a CSV with UPC and quantity and import that.

 

Same for price - create a CSV with UPC and price and import.

 

Try it with ONE product first to make sure it works.  I'm not positive that UPC as the key will work but I'm pretty sure that product ID and probably NAME as well would work.

[new_12]

my update query not working..

 

 

  $edit_id = $_POST['invoice_id'];

  $update = 'UPDATE database_name SET "Product_Name" = '.$_POST["prdt_nme"].'

    WHERE `vc_id`= '.$edit_id.'';

 Db::getInstance()->execute($update);

[awahab]

Hi,

 

Please provide the accurate solution to update the inventory and price of the product.

 

Hi, #RogueWaveLimited where can i import these data from BO please define me in detail.....