Store Name: Sole Priorities
App Name: SPISMS
I’ve noticed inconsistent results when attempting to retrieve certain variants by SKU. For most variants, everything matches up correctly and only one item is returned in the result set. At other times, it returns multiple variants in a result set even though only variant has the correct the SKU. In the most recent case, when searching for Jordan 3 Retro Georgetown (2021) by SKU using CT8532-401, it returns the
Jordan 3 Retro Cardinal Red first (CT8532-126) and Jordan 3 Retro Georgetown (2021) 2nd in the result set. The result set is below:
{"data":{"products":{"edges":[{"node":{"id":"gid:\/\/shopify\/Product\/6793288056886","title":"Jordan 3 Retro Cardinal Red","description":"New Unless Otherwise Stated (Message Us for Additional Photos Before Purchasing a Pre-Owned Shoe)","productType":"Shoes","status":"ACTIVE","createdAt":"2022-05-24T07:31:03Z","updatedAt":"2023-11-05T22:00:07Z","tags":["Jordan","Jordan 3s"],"totalInventory":4,"featuredImage":{"id":"gid:\/\/shopify\/ProductImage\/31519195201590","url":"https:\/\/cdn.shopify.com\/s\/files\/1\/0157\/9620\/7670\/products\/Air-Jordan-3-Retro-Cardinal-Red-Product_59b08e40-9978-42cf-84eb-65ad18140c97.jpg?v=1664902416"},"variants":{"edges":[{"node":{"id":"gid:\/\/shopify\/ProductVariant\/40355881386038","product":{"id":"gid:\/\/shopify\/Product\/6793288056886","tags":["Jordan","Jordan 3s"]},"displayName":"Jordan 3 Retro Cardinal Red - 7.5M","title":"7.5M","price":"280.00","sku":"CT8532-126","barcode":"195866052819","inventoryQuantity":0,"position":1,"availableForSale":false,"image":null,"inventoryItem":{"id":"gid:\/\/shopify\/InventoryItem\/42452317732918","sku":"CT8532-126","unitCost":null,"inventoryLevel":{"available":0,"location":{"id":"gid:\/\/shopify\/Location\/36858331190"}}},"createdAt":"2022-08-30T16:48:49Z","updatedAt":"2023-10-27T23:28:51Z"}},{"node":{"id":"gid:\/\/shopify\/ProductVariant\/40355882958902","product":{"id":"gid:\/\/shopify\/Product\/6793288056886","tags":["Jordan","Jordan 3s"]},"displayName":"Jordan 3 Retro Cardinal Red - 8M","title":"8M","price":"280.00","sku":"CT8532-126","barcode":"195866052826","inventoryQuantity":0,"position":2,"availableForSale":false,"image":null,"inventoryItem":{"id":"gid:\/\/shopify\/InventoryItem\/42452317929526","sku":"CT8532-126","unitCost":{"amount":"210.0"},"inventoryLevel":{"available":0,"location":{"id":"gid:\/\/shopify\/Location\/36858331190"}}},"createdAt":"2022-08-30T16:48:54Z","updatedAt":"2023-10-27T23:28:51Z"}},{"node":{"id":"gid:\/\/shopify\/ProductVariant\/40225611448374","product":{"id":"gid:\/\/shopify\/Product\/6793288056886","tags":["Jordan","Jordan 3s"]},"displayName":"Jordan 3 Retro Cardinal Red - 8.5M","title":"8.5M","price":"280.00","sku":"CT8532-126","barcode":"195866052833","inventoryQuantity":0,"position":3,"availableForSale":false,"image":null,"inventoryItem":{"id":"gid:\/\/shopify\/InventoryItem\/42321868554294","sku":"CT8532-126","unitCost":{"amount":"220.0"},"inventoryLevel":{"available":0,"location":{"id":"gid:\/\/shopify\/Location\/36858331190"}}},"createdAt":"2022-07-12T18:53:19Z","updatedAt":"2023-10-27T23:28:51Z"}},{"node":{"id":"gid:\/\/shopify\/ProductVariant\/40224341393462","product":{"id":"gid:\/\/shopify\/Product\/6793288056886","tags":["Jordan","Jordan 3s"]},"displayName":"Jordan 3 Retro Cardinal Red - 9M","title":"9M","price":"280.00","sku":"CT8532-126","barcode":"","inventoryQuantity":0,"position":4,"availableForSale":false,"image":null,"inventoryItem":{"id":"gid:\/\/shopify\/InventoryItem\/42320596500534","sku":"CT8532-126","unitCost":{"amount":"220.0"},"inventoryLevel":{"available":0,"location":{"id":"gid:\/\/shopify\/Location\/36858331190"}}},"createdAt":"2022-07-11T22:10:28Z","updatedAt":"2023-11-02T22:19:49Z"}},{"node":{"id":"gid:\/\/shopify\/ProductVariant\/47727443247409","product":{"id":"gid:\/\/shopify\/Product\/6793288056886","tags":["Jordan","Jordan 3s"]},"displayName":"Jordan 3 Retro Cardinal Red - 9M(Pre-Owned)","title":"9M(Pre-Owned)","price":"280.00","sku":"CT8532-126","barcode":"195866052864","inventoryQuantity":0,"position":5,"availableForSale":false,"image":null,"inventoryItem":{"id":"gid:\/\/shopify\/InventoryItem\/49776851124529","sku":"CT8532-126","unitCost":{"amount":"30.0"},"inventoryLevel":{"available":0,"location":{"id":"gid:\/\/shopify\/Location\/36858331190"}}},"createdAt":"2023-11-05T19:33:34Z","updatedAt":"2023-11-05T19:42:47Z"}},{"node":{"id":"gid:\/\/shopify\/ProductVariant\/40355882991670","product":{"id":"gid:\/\/shopify\/Product\/6793288056886","tags":["Jordan","Jordan 3s"]},"displayName":"Jordan 3 Retro Cardinal Red - 9.5M","title":"9.5M","price":"280.00","sku":"CT8532-126","barcode":"195866052857","inventoryQuantity":1,"position":6,"availableForSale":true,"image":null,"inventoryItem":{"id":"gid:\/\/shopify\/InventoryItem\/42452319338550","sku":"CT8532-126","unitCost":{"amount":"200.0"},"inventoryLevel":{"available":0,"location":{"id":"gid:\/\/shopify\/Location\/36858331190"}}},"createdAt":"2022-08-30T16:48:58Z","updatedAt":"2023-11-05T19:33:39Z"}},{"node":{"id":"gid:\/\/shopify\/ProductVariant\/40131952869430","product":{"id":"gid:\/\/shopify\/Product\/6793288056886","tags":["Jordan","Jordan 3s"]},"displayName":"Jordan 3 Retro Cardinal Red - 10M","title":"10M","price":"280.00","sku":"CT8532-126","barcode":"195866052864","inventoryQuantity":0,"position":7,"availableForSale":false,"image":null,"inventoryItem":{"id":"gid:\/\/shopify\/InventoryItem\/42228132479030","sku":"CT8532-126","unitCost":{"amount":"110.0"},"inventoryLevel":{"available":0,"location":{"id":"gid:\/\/shopify\/Location\/36858331190"}}},"createdAt":"2022-05-24T07:55:26Z","updatedAt":"2023-11-05T19:33:39Z"}},{"node":{"id":"gid:\/\/shopify\/ProductVariant\/40355883024438","product":{"id":"gid:\/\/shopify\/Product\/6793288056886","tags":["Jordan","Jordan 3s"]},"displayName":"Jordan 3 Retro Cardinal Red - 10.5M","title":"10.5M","price":"280.00","sku":"CT8532-126","barcode":"195866052871","inventoryQuantity":0,"position":8,"availableForSale":false,"image":null,"inventoryItem":{"id":"gid:\/\/shopify\/InventoryItem\/42452319371318","sku":"CT8532-126","unitCost":{"amount":"250.0"},"inventoryLevel":{"available":0,"location":{"id":"gid:\/\/shopify\/Location\/36858331190"}}},"createdAt":"2022-08-30T16:49:02Z","updatedAt":"2023-11-05T19:33:39Z"}},{"node":{"id":"gid:\/\/shopify\/ProductVariant\/40131952967734","product":{"id":"gid:\/\/shopify\/Product\/6793288056886","tags":["Jordan","Jordan 3s"]},"displayName":"Jordan 3 Retro Cardinal Red - 11M","title":"11M","price":"300.00","sku":"CT8532-126","barcode":"195866052888","inventoryQuantity":1,"position":9,"availableForSale":true,"image":null,"inventoryItem":{"id":"gid:\/\/shopify\/InventoryItem\/42228132577334","sku":"CT8532-126","unitCost":{"amount":"230.0"},"inventoryLevel":{"available":1,"location":{"id":"gid:\/\/shopify\/Location\/36858331190"}}},"createdAt":"2022-05-24T07:55:29Z","updatedAt":"2023-11-05T19:33:39Z"}},{"node":{"id":"gid:\/\/shopify\/ProductVariant\/40325884837942","product":{"id":"gid:\/\/shopify\/Product\/6793288056886","tags":["Jordan","Jordan 3s"]},"displayName":"Jordan 3 Retro Cardinal Red - 11.5M","title":"11.5M","price":"300.00","sku":"CT8532-126","barcode":"195866052895","inventoryQuantity":0,"position":10,"availableForSale":false,"image":null,"inventoryItem":{"id":"gid:\/\/shopify\/InventoryItem\/42422316793910","sku":"CT8532-126","unitCost":{"amount":"240.0"},"inventoryLevel":{"available":0,"location":{"id":"gid:\/\/shopify\/Location\/36858331190"}}},"createdAt":"2022-08-18T17:43:07Z","updatedAt":"2023-11-05T21:58:10Z"}},{"node":{"id":"gid:\/\/shopify\/ProductVariant\/44239369699633","product":{"id":"gid:\/\/shopify\/Product\/6793288056886","tags":["Jordan","Jordan 3s"]},"displayName":"Jordan 3 Retro Cardinal Red - 12M","title":"12M","price":"280.00","sku":"CT8532-126","barcode":"195866052901","inventoryQuantity":0,"position":11,"availableForSale":false,"image":null,"inventoryItem":{"id":"gid:\/\/shopify\/InventoryItem\/46287002501425","sku":"CT8532-126","unitCost":{"amount":"0.0"},"inventoryLevel":{"available":0,"location":{"id":"gid:\/\/shopify\/Location\/36858331190"}}},"createdAt":"2022-12-14T20:13:32Z","updatedAt":"2023-11-05T19:33:39Z"}},{"node":{"id":"gid:\/\/shopify\/ProductVariant\/44247237951793","product":{"id":"gid:\/\/shopify\/Product\/6793288056886","tags":["Jordan","Jordan 3s"]},"displayName":"Jordan 3 Retro Cardinal Red - 13M","title":"13M","price":"280.00","sku":"CT8532-126","barcode":"195866052925","inventoryQuantity":0,"position":12,"availableForSale":false,"image":null,"inventoryItem":{"id":"gid:\/\/shopify\/InventoryItem\/46294871245105","sku":"CT8532-126","unitCost":{"amount":"0.0"},"inventoryLevel":{"available":0,"location":{"id":"gid:\/\/shopify\/Location\/36858331190"}}},"createdAt":"2022-12-15T21:49:58Z","updatedAt":"2023-11-05T19:33:39Z"}},{"node":{"id":"gid:\/\/shopify\/ProductVariant\/44247238377777","product":{"id":"gid:\/\/shopify\/Product\/6793288056886","tags":["Jordan","Jordan 3s"]},"displayName":"Jordan 3 Retro Cardinal Red - 14M","title":"14M","price":"300.00","sku":"CT8532-126","barcode":"195866052932","inventoryQuantity":2,"position":13,"availableForSale":true,"image":null,"inventoryItem":{"id":"gid:\/\/shopify\/InventoryItem\/46294871671089","sku":"CT8532-126","unitCost":{"amount":"224.0"},"inventoryLevel":{"available":1,"location":{"id":"gid:\/\/shopify\/Location\/36858331190"}}},"createdAt":"2022-12-15T21:50:10Z","updatedAt":"2023-11-05T19:33:39Z"}},{"node":{"id":"gid:\/\/shopify\/ProductVariant\/44247239033137","product":{"id":"gid:\/\/shopify\/Product\/6793288056886","tags":["Jordan","Jordan 3s"]},"displayName":"Jordan 3 Retro Cardinal Red - 15M","title":"15M","price":"280.00","sku":"CT8532-126","barcode":"195866052949","inventoryQuantity":0,"position":14,"availableForSale":false,"image":null,"inventoryItem":{"id":"gid:\/\/shopify\/InventoryItem\/46294872326449","sku":"CT8532-126","unitCost":null,"inventoryLevel":{"available":0,"location":{"id":"gid:\/\/shopify\/Location\/36858331190"}}},"createdAt":"2022-12-15T21:50:22Z","updatedAt":"2023-11-05T19:33:39Z"}}]}}},{"node":{"id":"gid:\/\/shopify\/Product\/9124058431793","title":"Jordan 3 Retro Georgetown (2021)","description":"New Unless Otherwise Stated (Message Us for Additional Photos Before Purchasing a Pre-Owned Shoe)Release Date: 2021-03-20Color: Midnight Navy\/Cement Grey-WhiteSKU: CT8532-401","productType":"Shoes","status":"ACTIVE","createdAt":"2023-10-22T20:39:59Z","updatedAt":"2023-11-06T19:34:25Z","tags":["Jordan 3s"],"totalInventory":1,"featuredImage":{"id":"gid:\/\/shopify\/ProductImage\/43084489392433","url":"https:\/\/cdn.shopify.com\/s\/files\/1\/0157\/9620\/7670\/products\/Air-Jordan-3-Retro-Georgetown-2021-Product.webp?v=1698007199"},"variants":{"edges":[{"node":{"id":"gid:\/\/shopify\/ProductVariant\/47594385604913","product":{"id":"gid:\/\/shopify\/Product\/9124058431793","tags":["Jordan 3s"]},"displayName":"Jordan 3 Retro Georgetown (2021) - 4Y","title":"4Y","price":"0.00","sku":"CT8532-401","barcode":"","inventoryQuantity":0,"position":1,"availableForSale":false,"image":null,"inventoryItem":{"id":"gid:\/\/shopify\/InventoryItem\/49643686428977","sku":"CT8532-401","unitCost":{"amount":"0.0"},"inventoryLevel":{"available":0,"location":{"id":"gid:\/\/shopify\/Location\/36858331190"}}},"createdAt":"2023-10-22T20:39:59Z","updatedAt":"2023-10-27T23:32:08Z"}},{"node":{"id":"gid:\/\/shopify\/ProductVariant\/47594385637681","product":{"id":"gid:\/\/shopify\/Product\/9124058431793","tags":["Jordan 3s"]},"displayName":"Jordan 3 Retro Georgetown (2021) - 4.5Y","title":"4.5Y","price":"0.00","sku":"CT8532-401","barcode":"","inventoryQuantity":0,"position":2,"availableForSale":false,"image":null,"inventoryItem":{"id":"gid:\/\/shopify\/InventoryItem\/49643686461745","sku":"CT8532-401","unitCost":{"amount":"0.0"},"inventoryLevel":{"available":0,"location":{"id":"gid:\/\/shopify\/Location\/36858331190"}}},"createdAt":"2023-10-22T20:39:59Z","updatedAt":"2023-10-27T23:32:08Z"}},{"node":{"id":"gid:\/\/shopify\/ProductVariant\/47594385670449","product":{"id":"gid:\/\/shopify\/Product\/9124058431793","tags":["Jordan 3s"]},"displayName":"Jordan 3 Retro Georgetown (2021) - 5Y","title":"5Y","price":"0.00","sku":"CT8532-401","barcode":"","inventoryQuantity":0,"position":3,"availableForSale":false,"image":null,"inventoryItem":{"id":"gid:\/\/shopify\/InventoryItem\/49643686494513","sku":"CT8532-401","unitCost":{"amount":"0.0"},"inventoryLevel":{"available":0,"location":{"id":"gid:\/\/shopify\/Location\/36858331190"}}},"createdAt":"2023-10-22T20:39:59Z","updatedAt":"2023-10-27T23:32:08Z"}},{"node":{"id":"gid:\/\/shopify\/ProductVariant\/47594385703217","product":{"id":"gid:\/\/shopify\/Product\/9124058431793","tags":["Jordan 3s"]},"displayName":"Jordan 3 Retro Georgetown (2021) - 5.5Y","title":"5.5Y","price":"0.00","sku":"CT8532-401","barcode":"","inventoryQuantity":0,"position":4,"availableForSale":false,"image":null,"inventoryItem":{"id":"gid:\/\/shopify\/InventoryItem\/49643686527281","sku":"CT8532-401","unitCost":{"amount":"0.0"},"inventoryLevel":{"available":0,"location":{"id":"gid:\/\/shopify\/Location\/36858331190"}}},"createdAt":"2023-10-22T20:39:59Z","updatedAt":"2023-10-27T23:32:08Z"}},{"node":{"id":"gid:\/\/shopify\/ProductVariant\/47594385735985","product":{"id":"gid:\/\/shopify\/Product\/9124058431793","tags":["Jordan 3s"]},"displayName":"Jordan 3 Retro Georgetown (2021) - 6Y","title":"6Y","price":"0.00","sku":"CT8532-401","barcode":"","inventoryQuantity":0,"position":5,"availableForSale":false,"image":null,"inventoryItem":{"id":"gid:\/\/shopify\/InventoryItem\/49643686560049","sku":"CT8532-401","unitCost":{"amount":"0.0"},"inventoryLevel":{"available":0,"location":{"id":"gid:\/\/shopify\/Location\/36858331190"}}},"createdAt":"2023-10-22T20:39:59Z","updatedAt":"2023-10-27T23:32:08Z"}},{"node":{"id":"gid:\/\/shopify\/ProductVariant\/47594385768753","product":{"id":"gid:\/\/shopify\/Product\/9124058431793","tags":["Jordan 3s"]},"displayName":"Jordan 3 Retro Georgetown (2021) - 6.5Y","title":"6.5Y","price":"0.00","sku":"CT8532-401","barcode":"","inventoryQuantity":0,"position":6,"availableForSale":false,"image":null,"inventoryItem":{"id":"gid:\/\/shopify\/InventoryItem\/49643686592817","sku":"CT8532-401","unitCost":{"amount":"0.0"},"inventoryLevel":{"available":0,"location":{"id":"gid:\/\/shopify\/Location\/36858331190"}}},"createdAt":"2023-10-22T20:39:59Z","updatedAt":"2023-10-27T23:32:08Z"}},{"node":{"id":"gid:\/\/shopify\/ProductVariant\/47594385801521","product":{"id":"gid:\/\/shopify\/Product\/9124058431793","tags":["Jordan 3s"]},"displayName":"Jordan 3 Retro Georgetown (2021) - 7Y","title":"7Y","price":"0.00","sku":"CT8532-401","barcode":"","inventoryQuantity":0,"position":7,"availableForSale":false,"image":null,"inventoryItem":{"id":"gid:\/\/shopify\/InventoryItem\/49643686625585","sku":"CT8532-401","unitCost":{"amount":"0.0"},"inventoryLevel":{"available":0,"location":{"id":"gid:\/\/shopify\/Location\/36858331190"}}},"createdAt":"2023-10-22T20:39:59Z","updatedAt":"2023-10-27T23:32:08Z"}},{"node":{"id":"gid:\/\/shopify\/ProductVariant\/47594385834289","product":{"id":"gid:\/\/shopify\/Product\/9124058431793","tags":["Jordan 3s"]},"displayName":"Jordan 3 Retro Georgetown (2021) - 7.5M","title":"7.5M","price":"0.00","sku":"CT8532-401","barcode":"","inventoryQuantity":0,"position":8,"availableForSale":false,"image":null,"inventoryItem":{"id":"gid:\/\/shopify\/InventoryItem\/49643686658353","sku":"CT8532-401","unitCost":{"amount":"0.0"},"inventoryLevel":{"available":0,"location":{"id":"gid:\/\/shopify\/Location\/36858331190"}}},"createdAt":"2023-10-22T20:39:59Z","updatedAt":"2023-10-27T23:32:08Z"}},{"node":{"id":"gid:\/\/shopify\/ProductVariant\/47594385867057","product":{"id":"gid:\/\/shopify\/Product\/9124058431793","tags":["Jordan 3s"]},"displayName":"Jordan 3 Retro Georgetown (2021) - 8M","title":"8M","price":"0.00","sku":"CT8532-401","barcode":"","inventoryQuantity":0,"position":9,"availableForSale":false,"image":null,"inventoryItem":{"id":"gid:\/\/shopify\/InventoryItem\/49643686691121","sku":"CT8532-401","unitCost":{"amount":"0.0"},"inventoryLevel":{"available":0,"location":{"id":"gid:\/\/shopify\/Location\/36858331190"}}},"createdAt":"2023-10-22T20:39:59Z","updatedAt":"2023-10-27T23:32:08Z"}},{"node":{"id":"gid:\/\/shopify\/ProductVariant\/47594385899825","product":{"id":"gid:\/\/shopify\/Product\/9124058431793","tags":["Jordan 3s"]},"displayName":"Jordan 3 Retro Georgetown (2021) - 8.5M","title":"8.5M","price":"0.00","sku":"CT8532-401","barcode":"","inventoryQuantity":0,"position":10,"availableForSale":false,"image":null,"inventoryItem":{"id":"gid:\/\/shopify\/InventoryItem\/49643686723889","sku":"CT8532-401","unitCost":{"amount":"0.0"},"inventoryLevel":{"available":0,"location":{"id":"gid:\/\/shopify\/Location\/36858331190"}}},"createdAt":"2023-10-22T20:39:59Z","updatedAt":"2023-10-27T23:32:08Z"}},{"node":{"id":"gid:\/\/shopify\/ProductVariant\/47594385932593","product":{"id":"gid:\/\/shopify\/Product\/9124058431793","tags":["Jordan 3s"]},"displayName":"Jordan 3 Retro Georgetown (2021) - 9M","title":"9M","price":"0.00","sku":"CT8532-401","barcode":"","inventoryQuantity":0,"position":11,"availableForSale":false,"image":null,"inventoryItem":{"id":"gid:\/\/shopify\/InventoryItem\/49643686756657","sku":"CT8532-401","unitCost":{"amount":"0.0"},"inventoryLevel":{"available":0,"location":{"id":"gid:\/\/shopify\/Location\/36858331190"}}},"createdAt":"2023-10-22T20:39:59Z","updatedAt":"2023-11-02T22:20:32Z"}},{"node":{"id":"gid:\/\/shopify\/ProductVariant\/47594385965361","product":{"id":"gid:\/\/shopify\/Product\/9124058431793","tags":["Jordan 3s"]},"displayName":"Jordan 3 Retro Georgetown (2021) - 9.5M","title":"9.5M","price":"0.00","sku":"CT8532-401","barcode":"","inventoryQuantity":0,"position":13,"availableForSale":false,"image":null,"inventoryItem":{"id":"gid:\/\/shopify\/InventoryItem\/49643686789425","sku":"CT8532-401","unitCost":{"amount":"0.0"},"inventoryLevel":{"available":0,"location":{"id":"gid:\/\/shopify\/Location\/36858331190"}}},"createdAt":"2023-10-22T20:39:59Z","updatedAt":"2023-11-05T19:50:27Z"}},{"node":{"id":"gid:\/\/shopify\/ProductVariant\/47594385998129","product":{"id":"gid:\/\/shopify\/Product\/9124058431793","tags":["Jordan 3s"]},"displayName":"Jordan 3 Retro Georgetown (2021) - 10M","title":"10M","price":"0.00","sku":"CT8532-401","barcode":"","inventoryQuantity":0,"position":14,"availableForSale":false,"image":null,"inventoryItem":{"id":"gid:\/\/shopify\/InventoryItem\/49643686822193","sku":"CT8532-401","unitCost":{"amount":"0.0"},"inventoryLevel":{"available":0,"location":{"id":"gid:\/\/shopify\/Location\/36858331190"}}},"createdAt":"2023-10-22T20:39:59Z","updatedAt":"2023-11-05T19:50:27Z"}},{"node":{"id":"gid:\/\/shopify\/ProductVariant\/47594386030897","product":{"id":"gid:\/\/shopify\/Product\/9124058431793","tags":["Jordan 3s"]},"displayName":"Jordan 3 Retro Georgetown (2021) - 10.5M","title":"10.5M","price":"0.00","sku":"CT8532-401","barcode":"","inventoryQuantity":0,"position":15,"availableForSale":false,"image":null,"inventoryItem":{"id":"gid:\/\/shopify\/InventoryItem\/49643686854961","sku":"CT8532-401","unitCost":{"amount":"0.0"},"inventoryLevel":{"available":0,"location":{"id":"gid:\/\/shopify\/Location\/36858331190"}}},"createdAt":"2023-10-22T20:39:59Z","updatedAt":"2023-11-05T19:50:27Z"}},{"node":{"id":"gid:\/\/shopify\/ProductVariant\/47594386063665","product":{"id":"gid:\/\/shopify\/Product\/9124058431793","tags":["Jordan 3s"]},"displayName":"Jordan 3 Retro Georgetown (2021) - 11M","title":"11M","price":"0.00","sku":"CT8532-401","barcode":"","inventoryQuantity":0,"position":16,"availableForSale":false,"image":null,"inventoryItem":{"id":"gid:\/\/shopify\/InventoryItem\/49643686887729","sku":"CT8532-401","unitCost":{"amount":"0.0"},"inventoryLevel":{"available":0,"location":{"id":"gid:\/\/shopify\/Location\/36858331190"}}},"createdAt":"2023-10-22T20:39:59Z","updatedAt":"2023-11-05T19:50:27Z"}},{"node":{"id":"gid:\/\/shopify\/ProductVariant\/47594386096433","product":{"id":"gid:\/\/shopify\/Product\/9124058431793","tags":["Jordan 3s"]},"displayName":"Jordan 3 Retro Georgetown (2021) - 11.5M","title":"11.5M","price":"0.00","sku":"CT8532-401","barcode":"","inventoryQuantity":0,"position":17,"availableForSale":false,"image":null,"inventoryItem":{"id":"gid:\/\/shopify\/InventoryItem\/49643686920497","sku":"CT8532-401","unitCost":{"amount":"0.0"},"inventoryLevel":{"available":0,"location":{"id":"gid:\/\/shopify\/Location\/36858331190"}}},"createdAt":"2023-10-22T20:39:59Z","updatedAt":"2023-11-05T19:50:27Z"}},{"node":{"id":"gid:\/\/shopify\/ProductVariant\/47594386129201","product":{"id":"gid:\/\/shopify\/Product\/9124058431793","tags":["Jordan 3s"]},"displayName":"Jordan 3 Retro Georgetown (2021) - 12M","title":"12M","price":"380.00","sku":"CT8532-401","barcode":"194954683713","inventoryQuantity":0,"position":18,"availableForSale":false,"image":null,"inventoryItem":{"id":"gid:\/\/shopify\/InventoryItem\/49643686953265","sku":"CT8532-401","unitCost":{"amount":"280.0"},"inventoryLevel":{"available":0,"location":{"id":"gid:\/\/shopify\/Location\/36858331190"}}},"createdAt":"2023-10-22T20:39:59Z","updatedAt":"2023-11-05T19:50:27Z"}},{"node":{"id":"gid:\/\/shopify\/ProductVariant\/47594386161969","product":{"id":"gid:\/\/shopify\/Product\/9124058431793","tags":["Jordan 3s"]},"displayName":"Jordan 3 Retro Georgetown (2021) - 12.5M","title":"12.5M","price":"0.00","sku":"CT8532-401","barcode":"","inventoryQuantity":0,"position":19,"availableForSale":false,"image":null,"inventoryItem":{"id":"gid:\/\/shopify\/InventoryItem\/49643686986033","sku":"CT8532-401","unitCost":{"amount":"0.0"},"inventoryLevel":{"available":0,"location":{"id":"gid:\/\/shopify\/Location\/36858331190"}}},"createdAt":"2023-10-22T20:39:59Z","updatedAt":"2023-11-05T19:50:27Z"}},{"node":{"id":"gid:\/\/shopify\/ProductVariant\/47594386194737","product":{"id":"gid:\/\/shopify\/Product\/9124058431793","tags":["Jordan 3s"]},"displayName":"Jordan 3 Retro Georgetown (2021) - 13M","title":"13M","price":"0.00","sku":"CT8532-401","barcode":"","inventoryQuantity":0,"position":20,"availableForSale":false,"image":null,"inventoryItem":{"id":"gid:\/\/shopify\/InventoryItem\/49643687018801","sku":"CT8532-401","unitCost":{"amount":"0.0"},"inventoryLevel":null},"createdAt":"2023-10-22T20:39:59Z","updatedAt":"2023-11-05T19:50:27Z"}},{"node":{"id":"gid:\/\/shopify\/ProductVariant\/47594386227505","product":{"id":"gid:\/\/shopify\/Product\/9124058431793","tags":["Jordan 3s"]},"displayName":"Jordan 3 Retro Georgetown (2021) - 13.5M","title":"13.5M","price":"0.00","sku":"CT8532-401","barcode":"","inventoryQuantity":0,"position":21,"availableForSale":false,"image":null,"inventoryItem":{"id":"gid:\/\/shopify\/InventoryItem\/49643687051569","sku":"CT8532-401","unitCost":{"amount":"0.0"},"inventoryLevel":{"available":0,"location":{"id":"gid:\/\/shopify\/Location\/36858331190"}}},"createdAt":"2023-10-22T20:39:59Z","updatedAt":"2023-11-05T19:50:27Z"}},{"node":{"id":"gid:\/\/shopify\/ProductVariant\/47594386260273","product":{"id":"gid:\/\/shopify\/Product\/9124058431793","tags":["Jordan 3s"]},"displayName":"Jordan 3 Retro Georgetown (2021) - 14M","title":"14M","price":"450.00","sku":"CT8532-401","barcode":"194954683744","inventoryQuantity":1,"position":22,"availableForSale":true,"image":null,"inventoryItem":{"id":"gid:\/\/shopify\/InventoryItem\/49643687084337","sku":"CT8532-401","unitCost":{"amount":"300.0"},"inventoryLevel":{"available":1,"location":{"id":"gid:\/\/shopify\/Location\/36858331190"}}},"createdAt":"2023-10-22T20:39:59Z","updatedAt":"2023-11-06T19:30:40Z"}},{"node":{"id":"gid:\/\/shopify\/ProductVariant\/47594386293041","product":{"id":"gid:\/\/shopify\/Product\/9124058431793","tags":["Jordan 3s"]},"displayName":"Jordan 3 Retro Georgetown (2021) - 15M","title":"15M","price":"0.00","sku":"CT8532-401","barcode":"","inventoryQuantity":0,"position":23,"availableForSale":false,"image":null,"inventoryItem":{"id":"gid:\/\/shopify\/InventoryItem\/49643687117105","sku":"CT8532-401","unitCost":{"amount":"0.0"},"inventoryLevel":null},"createdAt":"2023-10-22T20:39:59Z","updatedAt":"2023-11-05T19:50:27Z"}}]}}}]}},"extensions":{"cost":{"requestedQueryCost":854,"actualQueryCost":224,"throttleStatus":{"maximumAvailable":1000,"currentlyAvailable":776,"restoreRate":50}}}}
Here is the query being used:
$query = <<<'JSON'
query($sku:String,$location:ID!)
{
products(first: 6, query: $sku) {
edges {
node {
id
title
description
productType
status
createdAt
updatedAt
tags
totalInventory
featuredImage{
id
url
}
variants(first:23){
edges{
node{
id
product{
id
tags
}
displayName
title
price
sku
barcode
inventoryQuantity
position
availableForSale
image{
id
url
}
inventoryItem{
id
sku
unitCost{
amount
}
inventoryLevel(locationId:$location){
available
location{
id
}
}
}
createdAt
updatedAt
}
}
}
}
}
}
}
JSON
;
$postData = array();
$postData['query'] = $query;
$postData['variables'] = array ('sku'=>$sku.'*','location'=>$location);
I tried doing an absolute search instead of relative by removing the wildcard for SKU, but the results are the same. Can you look into why the Cardinal 3 is being returned 1st even though the SKU doesn’t match?