Publish or Unpublish Shopify Products in bulk

Publish unpublish shopify products featured

You can publish and unpublish your Shopify Products in bulk with Excelify app by following these simple steps.

In Short

  1. Export Products you wish to publish or unpublish.
  2. In the exported file delete all columns except:
    • ID
    • Handle
    • Published
    • Published Scope
  3. Set Published values.
  4. Save the file and import via Excelify.
  5. Enjoy your updated Products.

1. Export your Products

Let’s start by exporting products that we wish to publish or unpublish. Open the Excelify app Export section and select checkbox “Products”. You do not need to include any other checkboxes. If you do not wish to export all your products you can apply a filter to export only the ones that you need to update. Export Shopify Products

2. Delete unnecessary columns

Now we can download our file and delete all unnecessary columns. We only need following columns to update Published status for our products:

  • ID
  • Handle
  • Published
  • Published Scope

Before:Delete exported product columns 1

After:Delete exported product columns 2

3. Set Published values

Shopify allows us to publish products on only two sales channels – Online Store and Point of Sale. So here is a small cheat-sheet of how to achieve all possible published states.

Published Published Scope Result
TRUE global Will publish the product to Online Store and PoS channels.
TRUE web Will publish the product to Online Store, but not and PoS channel.
FALSE global Will publish the product on PoS, but not on the Online Channel.
FALSE web Will not publish the product on any of the channels.

3 - update published columns

“Comment” column is in the screenshot only for tutorial purposes and is not needed in the import file.

4. Save the file and import via Excelify

Now we can save the file, go back to the Excelify app and import the file in the Import window. The app will analyze the file and count how many Products we are importing.

Press the Import button to start the import.

If you see any Failed items, then after the import has finished, you can download the Import Results file and look into the “Import Comment” column. It will tell why the particular Product has failed. Then you can fix that issue and re-import just those failed and fixed rows again.4 - import file

5. Enjoy your updated Products

5 - enjoy products

What to do next?