Add Specific Prices from Database

[JVSP]

Hi!!

I am trying to add specific prices directly from the database because I need to change prices for specific references and I can't find any module that does. From what I think I should first take the ids of the products based on the references from ps_products and then apply the discounts to those references from ps_specific_price but I get a mess on how it could be done ...

If someone helps me I would greatly appreciate it!

Edited December 30, 2019 by JVSP (see edit history)

[Juan Rios1]

It's a little unclear. 

Are you trying to apply a discount to certain products?

[luishuaymana]

If you can from the bd, you just have to create a script and add the reference or product id.

[PCQUATRO]

11 hours ago, JVSP said:

I am trying to add specific prices directly from the database because I need to change prices for specific references and I can't find any module that does. From what I think I should first take the ids of the products based on the references from ps_products and then apply the discounts to those references from ps_specific_price but I get a mess on how it could be done

You can apply discounts to products or categories!

Or if you have the references you can use the import native feature of PS to import/update just the prices of the products with the references you want. Just download the products csv example and use only the reference and the price for the product...

Best Regards