IDEAS home Printed from https://ideas.repec.org/p/osf/socarx/rxf9j_v1.html

Mapping food and drink products to environmental sustainability metrics using retail transaction data

Author

Listed:
  • Dineva, Mariana
  • Wilkins, Emma
  • Green, Mark Alan

    (University of Liverpool)

  • Gilthorpe, Mark S

    (University of Leeds)

  • Johnstone, Alexandra

    (University of Aberdeen)

  • Morris, Michelle

Abstract

With increasing concerns around food sustainability, estimating the environmental footprint of diets is critical. Supermarket transaction data are becoming prominent as a valuable source of objective dietary purchase data. We developed a method to map environmental sustainability metrics to foods and beverages sold by a major UK supermarket, using sales data from the Yorkshire and the Humber region (2022). Products were mapped to global Greenhouse Gas Emissions (GHGE) estimates for 45 commodities in four stages. Initially, products were grouped into categories and linked to commodities. Subsequent stages disaggregated high-complexity or high-sales categories into subcategories with similar ingredients, using retailer categorisations (Stage 2) and word searches within product descriptions (Stage 3), and finally refined categorisations to aid interpretability (Stage 4). The product with the highest sales in each subcategory was selected as an indicator product and mapped to commodities using data on ingredient proportions. Land Use and Water Use estimates were generated using the final mapping scheme. A look-up tool was produced linking categories to environmental sustainability metrics for use with other food product data. By Stage 4, 98·6% of >27,000 products were mapped to GHGE, using 200 category/subcategory-based GHGE estimates. Disaggregation revealed significant variation in GHGE estimates: up to a three-fold difference between Stage 1 and 4 estimates for the same category, and up to a 30-fold difference between subcategories within the same category. Disaggregation of complex categories is important for accurate estimation of sustainability indices. Our sales-guided approach balances accuracy and efficiency when dealing with large supermarket data and could support a wide range of research into sustainable diets.

Suggested Citation

  • Dineva, Mariana & Wilkins, Emma & Green, Mark Alan & Gilthorpe, Mark S & Johnstone, Alexandra & Morris, Michelle, 2026. "Mapping food and drink products to environmental sustainability metrics using retail transaction data," SocArXiv rxf9j_v1, Center for Open Science.
    • Handle: RePEc:osf:socarx:rxf9j_v1
    DOI: 10.31219/osf.io/rxf9j_v1
    as

    Download full text from publisher

    File URL: https://osf.io/download/699c4c800dc675749ffef3c8/
    Download Restriction: no
    File URL: https://libkey.io/10.31219/osf.io/rxf9j_v1?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    References listed on IDEAS

    as
    1. Rosemary Green & James Milner & Alan Dangour & Andy Haines & Zaid Chalabi & Anil Markandya & Joseph Spadaro & Paul Wilkinson, 2015. "The potential to reduce greenhouse gas emissions in the UK through healthy and realistic dietary change," Climatic Change, Springer, vol. 129(1), pages 253-265, March.
    2. Rains, Tim & Longley, Paul, 2021. "The provenance of loyalty card data for urban and retail analytics," Journal of Retailing and Consumer Services, Elsevier, vol. 63(C).
    Full references (including those not matched with items on IDEAS)

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Menrad, K. & Emberger-Klein, A. & Schops, J., 2018. "Factors influencing consumers behavioral intention towards climate-friendly food consumption in Southern Germany," 2018 Conference, July 28-August 2, 2018, Vancouver, British Columbia 277108, International Association of Agricultural Economists.
    2. Patricia Eustachio Colombo & Emma Patterson & Liselotte Schäfer Elinder & Anna Karin Lindroos & Ulf Sonesson & Nicole Darmon & Alexandr Parlesak, 2019. "Optimizing School Food Supply: Integrating Environmental, Health, Economic, and Cultural Dimensions of Diet Sustainability with Linear Programming," IJERPH, MDPI, vol. 16(17), pages 1-18, August.
    3. Helen Harwatt & Joan Sabaté & Gidon Eshel & Sam Soret & William Ripple, 2017. "Substituting beans for beef as a contribution toward US climate change targets," Climatic Change, Springer, vol. 143(1), pages 261-270, July.
    4. Alexander Chaudhry & P. B. Seetharaman, 2025. "Geodemographic drivers of store-level demand and marketing mix sensitivities," Journal of Marketing Analytics, Palgrave Macmillan, vol. 13(3), pages 936-955, September.
    5. Christine Cleghorn & Nhung Nghiem & Cliona Ni Mhurchu, 2022. "Assessing the Health and Environmental Benefits of a New Zealand Diet Optimised for Health and Climate Protection," Sustainability, MDPI, vol. 14(21), pages 1-13, October.
    6. Zech, Konstantin M. & Schneider, Uwe A., 2019. "Technical biofuel production and GHG mitigation potentials through healthy diets in the EU," Agricultural Systems, Elsevier, vol. 168(C), pages 27-35.
    7. Long, Gavin & Nica-Avram, Georgiana & Harvey, John & Lukinova, Evgeniya & Mansilla, Roberto & Welham, Simon & Engelmann, Gregor & Dolan, Elizabeth & Makokoro, Kuzivakwashe & Thomas, Michelle & Powell,, 2025. "Machine learning on national shopping data reliably estimates childhood obesity prevalence and socio-economic deprivation," Food Policy, Elsevier, vol. 131(C).
    8. Anthony Fardet & Edmond Rock, 2020. "Ultra-Processed Foods and Food System Sustainability: What Are the Links?," Sustainability, MDPI, vol. 12(15), pages 1-26, August.
    9. Erica Doro & Vincent Réquillart, 2020. "Review of sustainable diets: are nutritional objectives and low-carbon-emission objectives compatible?," Review of Agricultural, Food and Environmental Studies, INRA Department of Economics, vol. 101(1), pages 117-146.
    10. Chalmers, N. & Revoredo-Giha, C., 2018. "Increasing fruit and vegetable consumption whilst incorporating consumer preferences," 2018 Conference, July 28-August 2, 2018, Vancouver, British Columbia 277060, International Association of Agricultural Economists.
    11. Sander Biesbroek & W. M. Monique Verschuren & Yvonne T. Schouw & Ivonne Sluijs & Jolanda M. A. Boer & Elisabeth H. M. Temme, 2018. "Identification of data-driven Dutch dietary patterns that benefit the environment and are healthy," Climatic Change, Springer, vol. 147(3), pages 571-583, April.
    12. Neil Chalmers & Stacia Stetkiewicz & Padhmanand Sudhakar & Hibbah Osei-Kwasi & Christian J Reynolds, 2019. "Impacts of Reducing UK Beef Consumption Using a Revised Sustainable Diets Framework," Sustainability, MDPI, vol. 11(23), pages 1-20, December.
    13. Castiglione, Concetta & Mazzocchi, Mario, 2019. "Ten years of five-a-day policy in the UK: Nutritional outcomes and environmental effects," Ecological Economics, Elsevier, vol. 157(C), pages 185-194.
    14. Ohanisian Alina & Levchenko Nataliia & Shyshkanova Ganna & Abuselidze George & Prykhodko Volodymyr & Banchuk-Petrosova Olena, 2022. "Organic farms are the fundamental basis for the sustainable foreign economic activities of agrarians in Ukraine," Environmental & Socio-economic Studies, Sciendo, vol. 10(2), pages 49-61, June.
    15. Requillart, V. & Irz, X. & Jensen, J. & Leroy, P. & Soler, L.-G., 2018. "Promoting Climate-Friendly Diets: What Should We Tell Consumers in Demark, Finland and France?," 2018 Conference, July 28-August 2, 2018, Vancouver, British Columbia 277057, International Association of Agricultural Economists.
    16. Carla R V Coelho & Franck Pernollet & Hayo M G van der Werf, 2016. "Environmental Life Cycle Assessment of Diets with Improved Omega-3 Fatty Acid Profiles," PLOS ONE, Public Library of Science, vol. 11(8), pages 1-11, August.
    17. Goiuri Alberdi & Mirene Begiristain-Zubillaga, 2021. "Identifying a Sustainable Food Procurement Strategy in Healthcare Systems: A Scoping Review," Sustainability, MDPI, vol. 13(4), pages 1-18, February.
    18. Doro, Erica & Réquillart, Vincent, 2018. "Sustainable diets: are nutritional objectives and low-carbon-emission objectives compatible?," TSE Working Papers 18-913, Toulouse School of Economics (TSE), revised 10 Jun 2026.
    19. Chalmers, Neil & Revoredo-Giha, Cesar, "undated". "Incorporating preferences into a healthy and sustainable diet," 92nd Annual Conference, April 16-18, 2018, Warwick University, Coventry, UK 273490, Agricultural Economics Society.
    20. Picard, Julien & Banerjee, Sanchayan, 2023. "Behavioural spillovers unpacked: estimating the side effects of social norm nudges," LSE Research Online Documents on Economics 120566, London School of Economics and Political Science, LSE Library.

    More about this item

    NEP fields

    This paper has been announced in the following NEP Reports:

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:osf:socarx:rxf9j_v1. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: OSF (email available below). General contact details of provider: https://arabixiv.org .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.