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 - Basic (without Variants) worksheet, or add one if one does not exist yet in the workbook

3. Select a column that is not mapped to any data and right-click on the column to open the Shopify Sync Settings menu

   

4. Select the radio button named Core 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 - Basic (without 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