nspinheiro Posted November 4, 2013 Share Posted November 4, 2013 Hi I have 3 groups of clients, all of them with diferent prices without any specific rule regarding the price diferences amongst them, each product has a specific rule, they are not even equal by categories or families Since they are over 10.000 products and i am preparing the automatic linkage between my he ERP and Prestashop , i need to know when creating a rule in prices for each client group it is created in the DB a specific field for the value and where it is. I will try to explain: Product X has the price of 35 euros for Client type A, and 33 Euros for Client type B and 38 euros for type of client C. Product Y has the price of 40 euros for Client type A, and 47 Euros for Client type B and 35 euros for type of client C. So, there is no direct % relation on the price that allows me to use an automatica discount on prices. In the backoffice i can, one by one, define the specific prices rules and have this corrected has i need, but i need to have this automatically update with the ERP. Also, if there is a way of doing it with the update of a CSV, it also would be interesting at least has backup. Thanks Link to comment Share on other sites More sharing options...
parsifal Posted November 5, 2013 Share Posted November 5, 2013 (edited) Hi. I haven't tested this for direct DB manipulation, but it seems like the specific prices (not price rules) for a single product are stored in the following DB tables: ps_specific_price ps_specific_price_priority Since you have already declared specific prices for some of your products, these tables should not be empty in your case. So, you can examine them to understand how each field is populated and why. About CSV importing of specific prices: many forum members have been asking about this (I would also like to have this feature) but unfortunately it is not supported at the moment... Edited November 5, 2013 by parsifal (see edit history) Link to comment Share on other sites More sharing options...
parsifal Posted November 5, 2013 Share Posted November 5, 2013 About CSV importing of specific prices: many forum members have been asking about this (I would also like to have this feature) but unfortunately it is not supported at the moment... Perhaps I spoke too soon... Link to comment Share on other sites More sharing options...
nspinheiro Posted November 5, 2013 Author Share Posted November 5, 2013 Perhaps I spoke too soon... I think it's not the same... The field names mentioned are most for promotions or specific prices for one product, not by client rules in B2B module. Link to comment Share on other sites More sharing options...
Recommended Posts