sql request / or api - Looking for Specific price based on several conditions

[cafeine404]

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

 

Edited September 27, 2022 by cafeine404 (see edit history)