Hello Everybody
Im looking for an help in sql, or maybe the api service (because i can call it in make interface as an example).
I got this system on several website :
1 product will have 1 different specific price looking the customer group AND the quantity
=> not a rule, a fixed price on each product looking group AND quantity
i can read the database, i know i can have a specific id too but is there a way to get this info on sql maybe or else ?
Im looking to work on a plan where i can push price from a list to the website
si someone could help me at least with some sql info about the how to get / update this ? ty a lot
(im reading too that but im little lost : https://devdocs.prestashop-project.org/1.7/webservice/tutorials/advanced-use/specific-price/)
(im on mainly prestashop 1.7 / some on 1.7.8)
Or could you help me for the sql request idea like : (i dont code sql im able to read it)
select REF product (or id) where customer group is X (id group), from quantity is Y, to show price in (ps_specific_price) ?
and could it be doable to have a request to update the specific price on the same idea
my goal is to have something like if result of 1 resquest is different than a price i got in an excel for example, then update it
or even create it