How to update Item price in ERP next

ERPNext Support
,
1

I am able to update standard_rate via update API but it is not changing price in item list

2

could you explain more ?

3

I am trying to update Item Price(doctype) of an item with ERP NEXT REST API. How can i do it with php curl

4

I want to update this field selling_price_list

5

I m still confused . the doctype is “item price” , the field is selling_price_list ?
I cant find it . the field is called just price_list in my app .

6

yes price_list how to update it

7

it works fine for me . you have just to insert a price_list that actually exists in the database . (because it’s linked to it)

8

http://[erp next url]/api/resource/Item/SAMPLE-1234

i want to update its price list

Should i just send data like this in PUT request

{

"data": {

     

    "price_list" : 23.0

    

}

}

9

@daniel26 no no . price_list is LINK type not integer or float. you can change it with other price_list that exist in your database . or just change the rate (it’s the actual price for the item)

10

Is it possible for u to explain how
you can change it with other price_list that exist in your database

and

or just change the rate (it’s the actual price for the item)
are u talking do this?
“data”: {

    "standard_rate" : 23.0



}
11

could you please share a screen of a get request with all fields like mine ? MMeaFn5

12

{

"data": {

    "name": "ITEM-PRICE-15609",

    "owner": "shafi@activefitnessstore.com",

    "creation": "2017-05-26 08:48:14.095024",

    "modified": "2017-07-09 13:40:04",

    "modified_by": "shafi@activefitnessstore.com",

    "idx": 0,

    "docstatus": 0,

    "item_code": "TRXFTK",

    "packing_unit": 0,

    "item_name": "Force Tactical Kit",

    "brand": "TRX",

    "item_description": "Force Tactical Kit",

    "price_list": "Standard Selling",

    "buying": 0,

    "selling": 1,

    "currency": "AED",

    "price_list_rate": 1500.0,

    "lead_time_days": 0,

    "doctype": "Item Price"

}

}

13

I told you about item Sample 1234 ? How can i get its Item List. what filters to use or there is another way?

14

@daniel26 ok for the price_list you can change it with other price_list that exists (open the list Price List with api and you will find 2 defaults : Standard Buying and Standard Selling ) you can switch to any of them and nothing else.
for the rate it’s called price_list_rate.you can change it to 23 and it will work fine

15

As you said: i opened Price List with this url :
http://[erp next url]/api/resource/Price%20List/Standard%20Selling

{
"data": {
    "name": "Standard Selling",
    "owner": "irfan@activefitnessstore.com",
    "creation": "2017-02-06 15:27:27.104412",
    "modified": "2022-01-22 10:13:36.575043",
    "modified_by": "irfan@activefitnessstore.com",
    "parent": null,
    "parentfield": null,
    "parenttype": null,
    "idx": 68251,
    "docstatus": 0,
    "enabled": 1,
    "price_list_name": "Standard Selling",
    "currency": "AED",
    "buying": 0,
    "selling": 1,
    "price_not_uom_dependent": 0,
    "doctype": "Price List",
    "countries": []
}

}

But How i will change the rate now in
http://[erp next url]/app/item-price/ITEM-PRICE-30326

This is the url where i want to change rate via API.

16

Should i do it like this?
http://[erp next url]/api/resource/Item%20Price?filters=[[‘item_code’,‘=’,‘SAMPLE-1234’]]