In the short term, as described above, the simplest answer is that consumers pay higher overall costs for goods, which will be partially (but not entirely) offset by pushing down the price of those imported goods, with the extent of that offset determined by how elastic demand is.
The longer term presents more intriguing aspects. For some products, such as coffee or bananas, it’s not particularly easy or even possible to produce those products in the U.S. at all, so the primary impact of tariffs on those products will continue to be higher costs for those goods to U.S. consumers. For other, manufactured products like automobiles or smartphones, if the tariffs stay in place for a long period of time, that will almost certainly have an impact on businesses’ investment and location decisions.
The “best case” scenario, from the perspective of a government aiming to boost domestic production, would be that the higher cost of imported goods in certain industries would push businesses in said industries to relocate and invest within the U.S., to recapture some of the market from those higher-cost imports. However, there is no guarantee that this is necessarily the main impact of tariffs on domestic production. The “worst case” scenario would be, for industries that rely heavily on imported components and materials, it might make more sense to relocate outside the U.S. entirely, to avoid the cost of tariffs on those components and materials.
Either way, it’s important to recognize that in both cases, the relevant business decisions are being motivated by higher prices — even in the “best case” scenario outlined above, businesses are only being induced to locate and invest in the U.S. because the cost of buying their products from competitors in other countries has gone up. Therefore, any additional investment in the U.S. is being supported and paid for mostly by higher costs to consumers. This also goes to show that tariffs, to the extent that they are intended to induce businesses to invest more within the borders of the U.S., are most effective if they are tailored for that specific purpose and if they are paired with other policies that lower the cost of producing in the U.S. to begin with.