Travel outside the country for a brief period should not jeopardize the sponsorship application. I co-sponsored my inlaws in 2017 and they landed. Before covid, we used to make frequent grocery/gas day trips to the US sometimes twice a month and also occasional road trips / international flight travels. I understand living in Canada is boring, so we often travel to see the outside world.
Going on a day trip to a US border town to get supplies isn’t even technically treated as a day outside of Canada when counting days towards RO. Spending a few hours to get gas and groceries is not treated the same as a vacation outside Canada. This is part of daily life in many border regions and may even be the shortest way to get groceries, gas, etc. in some communities. Working in a border city in the US will also be looked at differently than a vacation abroad.