Basic Product Info Template

The Mixtable Basic Product Info template streamlines your Shopify product management by allowing you to export, modify, and reimport essential product details through an intuitive spreadsheet interface. This powerful tool helps you efficiently manage your product catalog by making bulk updates to critical information in a familiar format. Here are a few use cases:

• Bulk Edit Products: Quickly update existing product details, including titles, descriptions, tags, vendor values, and more.
• Bulk Add Products: Use the product worksheet to efficiently import new products into your Shopify store.
• Data Validation: Check for missing required fields, see if product URLs are SEO-friendly, and review SEO title and description lengths and content.
• Improvements: Generate SEO-friendly product URL handles from product titles, add SEO titles and descriptions if missing, and optimize existing SEO content.
• Tag Analysis: analyze tag usage across products and identify popular vs. unused tags

How do you load the Basic Product Info template?

• After installing the Mixtable Spreadsheet Editor app, click the Create a Workbook button.

• Select the Basic Product Info pre-built template from the list that appears in the dialog.

• Now, you can bulk edit the fields for your Shopify products.

What data is included in the Basic Product Info template?

The Basic Product Info template contains the following default columns:

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

You're ready!

Mixtable is an online spreadsheet designed to sync data with Shopify. It looks, feels, and behaves like Excel (including formulas), but runs in your browser. With Mixtable you can:

• Bulk add products to collections, edit metafields, add or remove tags;
• Change product prices, including international prices, and review price history;
• Manage customers with a spreadsheet CRM for Shopify;
• Use Excel features like sort ascending or descending, find-replace, filter, and more.

Best of all, you can sync changes back to Shopify with a single click. Find out more about the Mixtable suite of products here.