Publish or unpublish Shopify products in bulk

In Shopify, making a product visible to shoppers means publishing it to a sales channel. The two main built-in Shopify sales channels are:

• Online Store: your public-facing Shopify website
• Point of Sale (POS): your in-person retail location

Mixtable lets you control which channels your products appear on, individually or in bulk, using a simple spreadsheet. You can also manage other channels like Facebook, Instagram, Google, international markets, or B2B catalogs the same way.

What you’ll need

• Your Shopify store connected to Mixtable
• Products must have Active status in Shopify to be published to any channel. If you need to update product status in bulk, see Bulk update Shopify product status

Add a sales channel column to your worksheet

Each sales channel gets its own column in the worksheet. The column shows true (published) or false (not published) for every product.

This works on both Products (no variants) and Products (with variants) worksheets.

1. Open a spreadsheet connected to your Shopify store and go to a Products (no variants) or Products (with variants) worksheet
2. To load more Shopify data, click ＋ Shopify data in the header row of an empty column, such as the one right after your last column. You can also choose Column > Add Shopify data… from the menu bar. The field picker opens and asks What should column E show?, with your column's letter in place of E. It lists everything the worksheet can show from Shopify, grouped into sections the way your Shopify admin groups them. Type in the search box at the top, or click a section on the left, to find the field you want.
3. Click Status & channels in the list of sections on the left. Your store’s channels are listed under Sales channels, with market and B2B catalogs in groups of their own. If one is missing, click Refresh in the section’s heading to load your latest channels from Shopify
4. Click the channel you want, for example Online Store. On a Products (with variants) worksheet, leave Product (all variants) selected under Whose publishing? (This variant controls individual variants)
5. Click Save Column
6. Repeat the steps above to add a column for Point of Sale (or any other channel you want to manage)

The column will populate with true or false for each product, showing whether it is currently published on that channel.

Publish or unpublish products

1. Find the sales channel column for the channel you want to update
2. Set the value to:
   • true to publish the product to that channel (it will become visible to shoppers)
   • false to unpublish the product from that channel (it will be hidden)
3. You can change one product at a time, or update many products at once using copy/paste, dragging a cell’s value down, or Bulk Edit > Find and Replace
4. Click Preview at the top right of the spreadsheet to review your changes, then click Sync

Mixtable will update the product’s availability on that channel right away in Shopify.

Troubleshooting

• A product won’t publish: Check that the product’s status is Active. Draft products cannot be published to any sales channel