HAIRWEBSHOP Posted February 3, 2017 Share Posted February 3, 2017 Hello, Can someone please help me find a way to bulk edit pricing (add 5%) for products and all of its combinations of a manufacturer using SQL?Thank you in advance! Link to comment Share on other sites More sharing options...
joseantgv Posted February 3, 2017 Share Posted February 3, 2017 Hello, Can someone please help me find a way to bulk edit pricing (add 5%) for products and all of its combinations of a manufacturer using SQL? Thank you in advance! With this module https://addons.prestashop.com/en/promotions-gifts/7422-price-increment-reduction-by-group-category-and-more.html you don't need to edit database. Link to comment Share on other sites More sharing options...
HAIRWEBSHOP Posted February 7, 2017 Author Share Posted February 7, 2017 Thank you kinly for your reply, Joseantgv, My employer does not want to invest until we get more orders, so I need to find a free solution, hence a database query. Link to comment Share on other sites More sharing options...
musicmaster Posted February 7, 2017 Share Posted February 7, 2017 Did you try Prestools? It is a free solution. Link to comment Share on other sites More sharing options...
HAIRWEBSHOP Posted February 13, 2017 Author Share Posted February 13, 2017 Thank you, musicmaster, I've installed and configured Prestools, but I don't see how I would add 5% to all products of a manufacturer.Could you please help me? Thank you. Link to comment Share on other sites More sharing options...
musicmaster Posted February 13, 2017 Share Posted February 13, 2017 Searching for a manufacturer shouldn't be a problem. I noticed that increasing the wholesale price with a percentage was not yet possible so I have added that option in a new release. It assumes that you use the wholesale field of the product. If you have defined suppliers and set the wholesale price there it won't work. Link to comment Share on other sites More sharing options...
HAIRWEBSHOP Posted February 13, 2017 Author Share Posted February 13, 2017 Thank you kindly for your help, musicmaster. Does this also include product variations? Link to comment Share on other sites More sharing options...
musicmaster Posted February 13, 2017 Share Posted February 13, 2017 No, you need to do combinations per product with Combi-edit. There you have a mass edit option for all the variations. Link to comment Share on other sites More sharing options...
HAIRWEBSHOP Posted February 15, 2017 Author Share Posted February 15, 2017 Thank you, musicmaster! That's a lot of work because we have hundreds of products with combinations per manufacturer, but it beats editing each variation one by one. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now