{"data":{"id":"magento2-40497","source":"github-pr","sourceRef":"magento/magento2#40497","title":"Sales->Orders grid \"shipping address\" column is missing country","pr":{"number":40497,"url":"https://github.com/magento/magento2/pull/40497","author":"lbajsarowicz","mergedAt":"2026-03-25T18:18:58Z","mergeCommit":"a81085da8707663c73367895ac60f7c96d9244f7","headCommit":"64dd9426c7f93509a194dc069f2f098ac3239880","baseRef":"2.4-develop","diffSha256":"e611f1b259158981a4c11f2125f60953b438a33c427e873ae45629ac37c4e1d9"},"issues":[{"number":40403,"url":"https://github.com/magento/magento2/issues/40403","title":"Sales->Orders grid \"shipping address\" column is missing country","labels":["Area: Order","Component: Order grid","Issue: Confirmed","Priority: P2","Progress: PR Created","Progress: done","Reported on 2.4.7-P8","Reproduced on 2.4.x"],"kind":"human"}],"fixedIn":"2.4.9","containingTags":["2.4.9"],"reportedOn":"2.4.7-p8","codeMatch":{"2.4.6":"clean","2.4.6-p1":"clean","2.4.6-p2":"clean","2.4.6-p3":"clean","2.4.6-p4":"clean","2.4.6-p5":"clean","2.4.6-p6":"clean","2.4.6-p7":"clean","2.4.6-p8":"clean","2.4.6-p9":"clean","2.4.6-p10":"clean","2.4.6-p11":"clean","2.4.6-p12":"clean","2.4.6-p13":"clean","2.4.6-p14":"clean","2.4.6-p15":"clean","2.4.7":"clean","2.4.7-p1":"clean","2.4.7-p2":"clean","2.4.7-p3":"clean","2.4.7-p4":"clean","2.4.7-p5":"clean","2.4.7-p6":"clean","2.4.7-p7":"clean","2.4.7-p8":"clean","2.4.7-p9":"clean","2.4.7-p10":"clean","2.4.8":"clean","2.4.8-p1":"clean","2.4.8-p2":"clean","2.4.8-p3":"clean","2.4.8-p4":"clean","2.4.8-p5":"clean","2.4.9":"conflict"},"affectedVersions":["2.4.6","2.4.6-p1","2.4.6-p2","2.4.6-p3","2.4.6-p4","2.4.6-p5","2.4.6-p6","2.4.6-p7","2.4.6-p8","2.4.6-p9","2.4.6-p10","2.4.6-p11","2.4.6-p12","2.4.6-p13","2.4.6-p14","2.4.6-p15","2.4.7","2.4.7-p1","2.4.7-p2","2.4.7-p3","2.4.7-p4","2.4.7-p5","2.4.7-p6","2.4.7-p7","2.4.7-p8","2.4.7-p9","2.4.7-p10","2.4.8","2.4.8-p1","2.4.8-p2","2.4.8-p3","2.4.8-p4","2.4.8-p5"],"components":["magento/module-sales"],"files":[{"path":"app/code/Magento/Sales/etc/di.xml","change":"modified","package":"magento/module-sales"}],"stripped":{"tests":[],"docs":[],"outsideCode":[]},"linesChanged":8,"mergeBatched":false,"excluded":null,"sections":{"description":"Address includes only street and city","stepsToReproduce":"For orders delivered to other countries then the one the shop is in,\nthe column \"shipping address\" in the admin \"Salers->Orders\" grid doesn't show the country.\n\nThis makes it difficult to find orders from the last time that country was shipped to.\ne.g. to use the correct codes from the last pDDP customs declaration for Trump's tariffs.","expectedResult":"Address includes a country","actualResult":"Address includes only street and city","source":"issue"},"signatures":[],"labels":{"area":["Order"],"component":["Order grid"],"priority":"P2","severity":null,"reportedOn":["2.4.7-P8"]},"categories":["Order/Checkout"],"triage":{"model":"@cf/cloudflare/clef","requestHash":"a03390a4d3433a695d0d3bf74747d59dc39b27dd0b272f3589643eece820b308","isBugfix":0.967,"changeKind":{"choice":"bugfix","probabilities":{"bugfix":0.9003,"feature":0.0445,"refactor":0.0239,"tests_only":0.0099,"docs_only":0.0075,"dependency":0.0139},"confidence":0.7762},"scope":{"score":0.4186,"probabilities":{"0":0.6694,"1":0.2426,"2":0.088},"confidence":0.2721},"risk":{"score":0.2954,"probabilities":{"0":0.7613,"1":0.182,"2":0.0567},"confidence":0.4239},"area":{"choice":"admin","probabilities":{"catalog":0.0099,"checkout":0.0489,"customer":0.012,"admin":0.8442,"graphql_api":0.0064,"framework":0.057,"frontend":0.0088,"other":0.0128},"confidence":0.6786},"securityRelevant":0.0075,"reportedVersion":{"choice":"2.4.7-p8","probabilities":{"2.4.0":0.0025,"2.4.0-p1":0.0027,"2.4.1":0.0023,"2.4.1-p1":0.0025,"2.4.2":0.0023,"2.4.2-p1":0.0026,"2.4.2-p2":0.0026,"2.4.3":0.0025,"2.4.3-p1":0.003,"2.4.3-p2":0.003,"2.4.3-p3":0.003,"2.4.4":0.0026,"2.4.4-p1":0.0027,"2.4.4-p10":0.0038,"2.4.4-p11":0.0045,"2.4.4-p12":0.0039,"2.4.4-p13":0.0043,"2.4.4-p14":0.004,"2.4.4-p15":0.0035,"2.4.4-p16":0.0038,"2.4.4-p17":0.004,"2.4.4-p18":0.0037,"2.4.4-p2":0.0023,"2.4.4-p3":0.0025,"2.4.4-p4":0.0026,"2.4.4-p5":0.0028,"2.4.4-p6":0.0033,"2.4.4-p7":0.0037,"2.4.4-p8":0.0056,"2.4.4-p9":0.0025,"2.4.5":0.0027,"2.4.5-p1":0.0025,"2.4.5-p10":0.003,"2.4.5-p11":0.0031,"2.4.5-p12":0.004,"2.4.5-p13":0.0035,"2.4.5-p14":0.004,"2.4.5-p15":0.0034,"2.4.5-p16":0.0035,"2.4.5-p17":0.0034,"2.4.5-p2":0.0025,"2.4.5-p3":0.0027,"2.4.5-p4":0.0033,"2.4.5-p5":0.0031,"2.4.5-p6":0.0036,"2.4.5-p7":0.0043,"2.4.5-p8":0.0038,"2.4.5-p9":0.0027,"2.4.6":0.0057,"2.4.6-p1":0.0034,"2.4.6-p10":0.0051,"2.4.6-p11":0.0053,"2.4.6-p12":0.0064,"2.4.6-p13":0.0049,"2.4.6-p14":0.0048,"2.4.6-p15":0.0044,"2.4.6-p2":0.0028,"2.4.6-p3":0.0034,"2.4.6-p4":0.0044,"2.4.6-p5":0.0042,"2.4.6-p6":0.0056,"2.4.6-p7":0.0073,"2.4.6-p8":0.0058,"2.4.6-p9":0.0031,"2.4.7":0.0346,"2.4.7-p1":0.0028,"2.4.7-p10":0.004,"2.4.7-p2":0.0025,"2.4.7-p3":0.0039,"2.4.7-p4":0.0043,"2.4.7-p5":0.0044,"2.4.7-p6":0.0071,"2.4.7-p7":0.0124,"2.4.7-p8":0.6218,"2.4.7-p9":0.0163,"2.4.8":0.009,"2.4.8-p1":0.0077,"2.4.8-p2":0.0076,"2.4.8-p3":0.0082,"2.4.8-p4":0.0072,"2.4.8-p5":0.0065,"2.4.9":0.0055,"unspecified":0.0034},"confidence":0.3823},"backportWorthy":{"score":1.2455,"probabilities":{"0":0.2198,"1":0.3149,"2":0.4653},"confidence":0.046}},"curated":{"title":"Adds the country to the shipping and billing address columns of the order grid","description":"The Sales Orders grid shipping and billing address columns displayed only street, city, region and postcode, so the country was missing for orders shipped to different countries. The fix adds country_id to the ShippingAddressAggregator and BillingAddressAggregator.","categories":["Order/Checkout"],"author":"claude-code/opus-5.5","date":"2026-10-06","reviewedBy":null},"tests":null},"_documentation":"https://magento.watch/api","_description":"Upstream fix magento2-40497 details"}