Publish or unpublish Shopify products

The Mixtable spreadsheet provides an easy way to publish or unpublish your products from your Shopify store. You can do this individually or in bulk. The Published column on a Shopify Products determines the publication status of your products. Setting this field to true publishes the product, while setting it to false unpublishes it.

Add the Published column to the worksheet

Publishing products on Mixtable is a straightforward process that allows you to make your products available to customers across multiple markets. Here’s a step-by-step guide:

1. Open Mixtable and create a workbook to sync data with your Shopify store

2. Open a Products (no variants) worksheet, or add one if one does not exist yet in the workbook

3. To load new Shopify data, start by selecting an empty column — any column with a non-green header (green headers mean the column is already linked to Shopify data). Then, click the ⚡️ button in the column header to open the selection window to choose the data you want to pull in.

   

4. Select the radio button named Standard Data Field

5. From the dropdown menu select the Published option and click Save

   

Now that you have a column mapped to sync data between Mixtable and Shopify you can easily publish a product by entering value true in the cell to publish a product or the value false to unpublish a product. Keep in mind that when you publish a product from Mixtable it will be published to both the web and POS Shopify sales channel.

Publishing and Unpublish products with Mixtable

1. Navigate to the Products (no variants) worksheet in your Mixtable workbook.
2. Modify the Published Field. Setting it to true will publish the product shown on the row. Setting it to false will unpublish the product shown on the row. You can change cells in the Published column manually one-by-one, or you can set the values of cells in this column in bulk using copy+paste, dragging a cell’s value, or using our Bulk Find and Replace feature.
3. Sync the changes to Shopify by pressing the Sync sheet to Shopify button

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.