The product category field in Shopify is becoming increasingly important for organizing your products, as well as for tax and analytics purposes. The Mixtable Excel-like spreadsheet simplifies how you can add a product category to your Shopify products, individually or in bulk.
Here’s how to add a Product Category column to your Shopify products using Mixtable:
Set up a Workbook and Worksheet: First, set up a workbook and create a worksheet that syncs the products whose categories you’ll be editing.
Locate an Unmapped Column: Right-click on the column header of a column that is not yet mapped to sync to a field. These columns have a grey background, while columns set up for data syncing have a light green background.
Access Shopify Sync Settings: After right-clicking, a context menu will appear. Select the “Shopify Sync Settings” option.
Choose the Product Category option: In the window that opens, select the “Product Category” radio button option. A dropdown will appear, prompting you to select the specific product category field you’d like to sync. You have three options here:
Populate Existing Categories: The column will now populate with any existing product category data for your Shopify products.
To add a product category to a Shopify product using Mixtable, follow these steps:
Locate the Product Row. Find the row that displays the product in question
Identify the Category Cell. Locate the cell in that row corresponding to the “Product Category” column you previously created.
Manually set the category value, or use the ‘Change’ button
To remove a product category from a Shopify product simply find the cell showing the existing category for the product, and clear it. You can clear the cell by selecting it and using the Backspace/Delete button on your keyboard. When the cell is cleared, start a Mixtable-to-Shopify sync and the product category will be removed from Shopify.
To change an existing Shopify product category to something else follow the same process as when adding a product category. Find the cell showing the category you’d like to change, and either change the value manually or click the Change button.