Hi, I’ve updated the sell-ahead value from a purchase order but available and sell_ahead values are not updated when a query inventory for one of the skus is there anything extra that needs to be done? thanks
Hey @apopelka,
Thanks for reaching out!
Could you please provide some examples of this? With request_ids or timestamps preferably!
Please let me know if you have any questions or concerns.
Best,
RayanP
HI @sh-agent thanks for the quick reply, here are the two queries I’m running:
"request_id": "657875a070cddc95760363b9",
"request_id": "65788f9b513307dbb10e2e67",
query getPO($po_number: String) {
purchase_order(po_number: $po_number) {
request_id
data {
id
po_number
line_items {
edges {
node {
id
sku
vendor_sku
sell_ahead
}
}
}
}
}
}
query getAvailable($sku: String){
warehouse_products(sku: $sku) {
data(first: 1) {
edges {
node {
warehouse_identifier
warehouse_id
available
sell_ahead
}
}
}
}
}
and these are the responses:
{
"data": {
"warehouse_products": {
"data": {
"edges": [
{
"node": {
"sku": "",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "0",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "1",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "10",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "111",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "188888888888",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "19",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "2",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "21",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "22",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "290999999999999999999999",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "3",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "3.92469E+13",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "3.92778E+13",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "3.93178E+13",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "3.93814E+13",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "3.93823E+13",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "3.93873E+13",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "3.94284E+13",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "3.9429E+13",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "3.94446E+13",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "3.94754E+13",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "3.95249E+13",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "3.95472E+13",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "3.95E+13",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "388888888888",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "390999999999999999999999",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "39428417257534",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "39428418306110",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "39428418469950",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "4",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "488888888888",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "490999999999999999999999",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "5",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "590999999999999999999999",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "6",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "6.06E+11",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "6.42381E+11",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "6.42E+11",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "690999999999999999999999",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "7",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "790999999999999999999999",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "8",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "890999999999999999999999",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "90999999999999999999999",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "A000JEWLBOX001",
"warehouse_id": "V2FyZWhvdXNlOjYxODc3",
"warehouse_identifier": "FSD"
}
},
{
"node": {
"sku": "A000JEWLBOX001",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "A000TYCARD0001",
"warehouse_id": "V2FyZWhvdXNlOjYxODc3",
"warehouse_identifier": "FSD"
}
},
{
"node": {
"sku": "A000TYCARD0001",
"warehouse_id": "V2FyZWhvdXNlOjczNTE=",
"warehouse_identifier": "Primary"
}
},
{
"node": {
"sku": "A000TYCARD0002",
"warehouse_id": "V2FyZWhvdXNlOjYxODc3",
"warehouse_identifier": "FSD"
}
}
]
}
}
},
"extensions": {
"throttling": {
"estimated_complexity": 51,
"cost": 51,
"cost_detail": {
"warehouse_products": {
"items_count": 50,
"cost": 1,
"total_cost": 51,
"fields": {}
}
},
"user_quota": {
"credits_remaining": 1949,
"max_available": 2002,
"increment_rate": 30
}
}
}
}
{
"data": {
"warehouse_products": {
"data": {
"edges": [
{
"node": {
"warehouse_identifier": "FSD",
"warehouse_id": "V2FyZWhvdXNlOjYxODc3",
"available": 0,
"sell_ahead": 0,
"sku": "C969SUBAOS1202"
}
}
]
}
}
},
"extensions": {
"throttling": {
"estimated_complexity": 17,
"cost": 17,
"cost_detail": {
"warehouse_products": {
"items_count": 1,
"cost": 1,
"total_cost": 17,
"fields": {
"WarehouseProduct.sell_ahead": {
"count": 1,
"value": 15,
"total_cost": 15
}
}
}
},
"user_quota": {
"credits_remaining": 1985,
"max_available": 2002,
"increment_rate": 30
}
}
}
}
Hey @apopelka,
Thanks for hanging in there!
I see what you mean. This behavior is not expected, so I will escalate this issue to our Engineering Team for further investigation.
Do note that the Sell Ahead value is ignored when a PO is closed, but the PO in question seems to be in a custom status but is not closed.
Please let me know if you have any questions or concerns.
Best,
RayanP
thanks @sh-agent , we tried different things but no luck and this is a feature we used before without any issues.
1 Like