You can publish and unpublish your Shopify Products in bulk with Excelify app by following these simple steps.
- Export Products you wish to publish or unpublish.
- In the exported file delete all columns except:
- Published Scope
- Set Published values.
- Save the file and import via Excelify.
- Enjoy your updated Products.
1. Export Products you wish to publish or unpublish
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.
2. Delete unnecessary columns from the exported file
Now we can download our file and delete all unnecessary columns. We only need following columns to update Published status for our products:
- Published Scope
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.
|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.|
“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.