Basic Product Info Template

The Basic Product Info template in Mixtable gives you a simple spreadsheet of your Shopify products, with one row per product and no variants. It’s a quick way to clean up the basics across your catalog: you edit titles, descriptions, tags, and SEO text in the cells, then sync the changes back to Shopify.

Here’s what you can use it for:

• Bulk editing products: update titles, descriptions, tags, vendors, and status for many products at once
• Adding new products: add rows for new products and sync them to your store
• Checking your SEO: find products with missing SEO titles or meta descriptions, or ones that are too long, and fix them in place
• Cleaning up tags: see which tags you use most, and fix typos or near-duplicates

How to load the Basic Product Info template

After installing the Mixtable Spreadsheet Editor app, create a spreadsheet from the template:

Open your Mixtable dashboard and click Create spreadsheet at the top of the page. If you haven't created a spreadsheet yet, click Browse all templates below the dashboard's suggestions instead. In the Create spreadsheet window, find Basic Product Info under Products, or type its name in the search box, and click it. Mixtable creates the spreadsheet and fills it with data from your Shopify store.

What data is included in the Basic Product Info template

The template creates a Products (no variants) worksheet with these columns:

• Product Title
• Description
• Handle
• Status
• Vendor
• Tags
• Product Images
• SEO Page Title
• SEO Meta Description

Need prices, SKUs, or stock levels? Those belong to variants, so use the Full Product Info template instead, which has one row per variant.

Add more product data

You can add a column for other product details too, such as the product type, metafields, or sales channels.

To load more Shopify data, click ＋ Shopify data in the header row of an empty column, such as the one right after your last column. You can also choose Column > Add Shopify data… from the menu bar. The field picker opens and asks What should column E show?, with your column's letter in place of E. It lists everything the worksheet can show from Shopify, grouped into sections the way your Shopify admin groups them. Type in the search box at the top, or click a section on the left, to find the field you want.

Click the field you want, such as Product type in the Organization section, a metafield in Custom data, or a sales channel in Status & channels, then click Save Column.

Send your changes to Shopify

When you are ready, look at the sync control at the top right of the spreadsheet, next to Share. It shows how many edits are waiting, for example Sync 12 changes. Click Sync to open the Preview changes window and review them, then click Sync in the window. Mixtable sends the updated product data to Shopify. It may take a few seconds for the changes to appear in your store.