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

   

2. Open a workbook that syncs products with your Shopify store

3. Navigate to the worksheet containing your products

   

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

   

5. Select the radio button named Core Field

6. 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 Products with Mixtable

1. Navigate to the Products worksheet in your Mixtable workbook.
2. Modify the Published Field. Setting it to true will publish 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

Unpublishing Products with Mixtable

Unpublishing products is just as important as publishing them, especially when it comes to managing inventory or targeting specific customer segments. Here’s how to unpublish products using Mixtable:

1. Navigate to the Products worksheet in your Mixtable workbook.
2. Modify the Published Field. 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

Using Bulk Find And Replace to change cell values in bulk

By using Mixtable you can take advantage of our Bulk Find and Replace feature. To use this feature follow the outlined steps:

1. Open the Bulk updates menu
2. Select the Find and replace option
3. From the first dropdown menu select the Published column
4. In the find field type the value you will be replacing
5. In the replace field type the value you want to replace with
6. Click Update spreadsheet

Using the select and drag function