Jump to content

Help with an SQL query, please


Recommended Posts

Hello, I am pretty handy in many things and I can pretty much work with MySQL so I can find & fix many things manually. But right now I am in need of a query that is beyond my knowledge:

 

I have previously had Prestashop 1.5.0.6 and then updated to 1.6.0.5. The problem is that in 1.5 the wholesale price in Suppliers tab of a product did not copy the wholesale price for the product in the Price tab (or for combinations in Combinations tab). When I add new products in 1.6 it works great but I am missing many wholesale prices from previous version.

 

What the query needs to be to copy the price from the one in Suppliers tab to Price tab for a product without combinations and to the Combinations tab for products with combinations?

A really hope you understand my need, if not ask me anything. Thank you very much!

Link to comment
Share on other sites

×
×
  • Create New...