Have your say in Community Polls: What was/is your greatest motivation to start your own business?
Our Partner & Developer boards on the community are moving to a brand new home: the .dev community forums! While you can still access past discussions here, for all your future app and storefront building questions, head over to the new forums.

GraphQL query priceLists is not returning all price lists

GraphQL query priceLists is not returning all price lists

davidhoang
Shopify Partner
20 0 9

Hi,

This query is supposed to return all priceLists according to Shopify documentation . However it's returning only 4 price lists. The second query

 

 

query {
    priceLists(first: 10) {
      pageInfo {
        hasNextPage
      }         
      edges {
        cursor
        node {
          id
          name
          currency
          contextRule {
            countries
          }
          parent {
            adjustment {
              type
              value
            }
          }
        }
      }
    }
}

 

 

 Response

 

 

{
    "data": {
        "priceLists": {
            "pageInfo": {
                "hasNextPage": false
            },
            "edges": [
                {
                    "cursor": "eyJsYXN0X2lkIjoxMzY0NjAwNDQwNywibGFzdF92YWx1ZSI6MTM2NDYwMDQ0MDd9",
                    "node": {
                        "id": "gid://shopify/PriceList/13646004407",
                        "name": "pricing_by_country.v1.de",
                        "currency": "EUR",
                        "contextRule": {
                            "countries": [
                                "DE"
                            ]
                        },
                        "parent": {
                            "adjustment": {
                                "type": "PERCENTAGE_INCREASE",
                                "value": 5.0
                            }
                        }
                    }
                },
                {
                    "cursor": "eyJsYXN0X2lkIjoxMzY0NjAzNzE3NSwibGFzdF92YWx1ZSI6MTM2NDYwMzcxNzV9",
                    "node": {
                        "id": "gid://shopify/PriceList/13646037175",
                        "name": "pricing_by_country.v1.no",
                        "currency": "NOK",
                        "contextRule": {
                            "countries": [
                                "NO"
                            ]
                        },
                        "parent": {
                            "adjustment": {
                                "type": "PERCENTAGE_DECREASE",
                                "value": 0.0
                            }
                        }
                    }
                },
                {
                    "cursor": "eyJsYXN0X2lkIjoxMzY0NjA2OTk0MywibGFzdF92YWx1ZSI6MTM2NDYwNjk5NDN9",
                    "node": {
                        "id": "gid://shopify/PriceList/13646069943",
                        "name": "pricing_by_country.v1.se",
                        "currency": "SEK",
                        "contextRule": {
                            "countries": [
                                "SE"
                            ]
                        },
                        "parent": {
                            "adjustment": {
                                "type": "PERCENTAGE_DECREASE",
                                "value": 0.0
                            }
                        }
                    }
                },
                {
                    "cursor": "eyJsYXN0X2lkIjoxNDU2Mjk4NDExOSwibGFzdF92YWx1ZSI6MTQ1NjI5ODQxMTl9",
                    "node": {
                        "id": "gid://shopify/PriceList/14562984119",
                        "name": "International",
                        "currency": "DKK",
                        "contextRule": {
                            "countries": [
                                "BG",
                                "CH",
                                "CZ",
                                "HU",
                                "IS",
                                "LI",
                                "RO",
                                "BA",
                                "GE",
                                "GG",
                                "GI",
                                "HR",
                                "IM",
                                "JE",
                                "RS",
                                "TR",
                                "UA"
                            ]
                        },
                        "parent": {
                            "adjustment": {
                                "type": "PERCENTAGE_DECREASE",
                                "value": 0.0
                            }
                        }
                    }
                }
            ]
        }
    },
    "extensions": {
        "cost": {
            "requestedQueryCost": 42,
            "actualQueryCost": 18,
            "throttleStatus": {
                "maximumAvailable": 2000.0,
                "currentlyAvailable": 1978,
                "restoreRate": 100.0
            }
        }
    }
}

 

 

The next query return a single price list that is not part of previous query

 

 

 

query {
    priceList(id: "gid://shopify/PriceList/14045020343") {
        id
        name
        currency
      contextRule {
        countries
      }
      parent {
        adjustment {
          type
          value
        }
      }
    }

}

 

 

Response

 

 

{
    "data": {
        "priceList": {
            "id": "gid://shopify/PriceList/14045020343",
            "name": "pricing_by_country.v1.fr",
            "currency": "EUR",
            "contextRule": {
                "countries": [
                    "FR"
                ]
            },
            "parent": {
                "adjustment": {
                    "type": "PERCENTAGE_DECREASE",
                    "value": 0.0
                }
            }
        }
    },
    "extensions": {
        "cost": {
            "requestedQueryCost": 4,
            "actualQueryCost": 4,
            "throttleStatus": {
                "maximumAvailable": 2000.0,
                "currentlyAvailable": 1996,
                "restoreRate": 100.0
            }
        }
    }
}

 

 

 

The France price list ID was selected by the customer and stored in our database. Obviously it was part of the list query's response some time ago (so the customer could select it) but then the list query stopped returning it.

Question is why the list query not returning the France price list? How do I get all the price lists of the store?

 

Reply 1 (1)

csam
Shopify Staff (Retired)
267 40 51

Hi @davidhoang 

 

We're going to need a little more info for this issue, as well as access to the shop on which you're seeing this behaviour. If you have an authenticated account on the shop, could you please fill out the Report an Issue form found under the Partners Support section? Any additional information you can provide around this issue would be very helpful, such as when the full list stopped being returned.

 

Thanks!

To learn more visit the Shopify Help Center or the Community Blog.