Full Product Info Template

Need to update your Shopify products in bulk? The Mixtable Full Product Info template makes it simple. Have all the details for your products and their variants in a spreadsheet, make changes, and import them back to Shopify – all in an Excel-like format you’re already comfortable with. Whether you’re adjusting prices, updating descriptions, or managing inventory, this template transforms complex product management tasks into straightforward spreadsheet work. Key uses include:

• Bulk add products and variants: You are able to add/import in bulk your products, and their variant-level information (pricing, options, inventory, etc.)
• Bulk edit product and variant information: All your product and variant information is in one place and you can make edits to multiple fields, and for multiple products/variants quickly
• Data Validation: Check for missing information, fill in empty fields, and make changes in bulk.
• Bulk price changes: Change the price of your products/variants very quickly, in bulk, using our bulk tools or using Excel formulas. You can change the main price, or the international price that’s shown in any markets you have set up in Shopify.
• Inventory Management: Track and manage inventory in all warehouses and make adjustments where necessary.
• Metafields: Bulk edit metafield information and add extra data to help with product discovery and SEO.
• Prepare Sale Campaigns by setting prices in advance (with Mixtable you can use formulas to discount the price by certain percentage) and having the original price as compare-at price.

How do you load the Full Product Info template?

• After installing the Mixtable Spreadsheet Editor app, click the Create a Workbook button.
• Select the Full 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 Full Product Info template?

The Full Product Info template contains the following default columns:

• Handle
• Title
• Tags
• Vendor
• Option 1 Name
• Option 2 Name
• Option 3 Name
• Option 1
• Option 2
• Option 3
• SKU
• Price
• Product SEO Page Title
• Product SEO Meta Description
• Headquarters / Available
• Main Warehouse / Available

Manage Product data with spreadsheet functions

Operating in the Mixtable Spreadsheet Editor app allows you to use any spreadsheet function to analyze and manage your data, such as:

• sort ascending or descending,
• find-replacе,
• filter,
• use formulas, e.g., for price changes, etc.

Find out more about the Mixtable suite of products here.