We need access to adjust our WholeSale Price list in Veeqo through the API.
is there undocumented access to adjusting Price Lists through calls to and end point in API?
We seem to be able to identify a Price List end point but its undocumented.
We need access to adjust our WholeSale Price list in Veeqo through the API.
is there undocumented access to adjusting Price Lists through calls to and end point in API?
We seem to be able to identify a Price List end point but its undocumented.
Hey @mablower let me see what I can find out on this and come back to you ASAP
Hey @mablower There is an undocumented endpointfor price lists, however it is GET only and it just returns ID, Name, ‘default’ and ‘curency_code’. I’m not seeing any ability to POST or PUT to this endpoint currently.
I ll check in with one of my colleagues who is currently on Leave to see if this can be made possible but in meantime could you let me know how often you would need to update these lists as you can do via csv import in UI if it is an infrequent requirement
Developer working for me on this, seems to have found away to mange this.
He demonstrated applying changes through integration zoho inventory that Post or Put the through api.
I’ll look at this and share solution he found.
This appear to the the solution, we’re still testing and quality checking.
Zoho Deluge Code:
void update_price_in_veeqo(string variant_sku, string veeqo_product_id, string Retail_Price, string Wholesale_Price)
{
Wholesale_Price = Wholesale_Price.toDecimal();
Retail_Price = Retail_Price.toDecimal();
// variant_sku = “12500”;
// Retail_Price = 69.95;
// Wholesale_Price = “57.35”;
// veeqo_product_id = “56970962”;
apiKey = “Vqt/REDACTED”;
headersMap = Map();
headersMap.put(“accept”,“application/json”);
headersMap.put(“x-api-key”,apiKey);
// ----------------------- Get Product Price List Sellables ---------------------------
get_veqoo_price_list_sellables = invokeurl
[
url :“https://api.veeqo.com/products/” + veeqo_product_id + “/price_list_sellables”
type :GET
headers:headersMap
];
// ----------------------Update Veeqoo Price List Selables-------------------------------
if(get_veqoo_price_list_sellables.size() > 0)
{
price_list_id = get_veqoo_price_list_sellables.getJSON(“id”);
update_map = Map();
update_map.put(“price”,Wholesale_Price);
update_veeqo_price_list = invokeurl
[
url :“https://api.veeqo.com/price_list_sellables/” + price_list_id
type :PUT
parameters:update_map.toString()
headers:headersMap
];
// -------------------------------Update Veeqo Retail Price----------------------------
sellable_id = get_veqoo_price_list_sellables.getJSON(“sellable_id”);
update_retail = {“product”:{“product_variants_attributes”:{{“id”:sellable_id,“sku_code”:variant_sku,“price”:Retail_Price}}}};
update_veeqo_product_retail_price = invokeurl
[
url :“https://api.veeqo.com/products/” + veeqo_product_id
type :PATCH
parameters:update_retail.toString()
headers:headersMap
];
info update_veeqo_product_retail_price;
}
}
Lines 26 through 32 of the provided code seems to work for updaing our Wholesale price list with change needed.
Is this unsupported but works ? shutter, lol.
Hey @mablower - just checked and yep that does actually look like a great solution to this.
Hats off to your developer on this one!