To find product ID, open your store under Stores. The product ID will be displayed under the product name.
To find the variant ID, open your store under Stores. Click on a specific product to open it. You’ll see the variant ID underneath the product name. You can copy it and paste it into your spreadsheet.