With Excelify now you can also bulk update Shopify Product Status quickly and easily!
Product Status field allows for Shopify products to be saved as a draft and continue working on them until they are ready to be published on selected sales channels by setting their status to “Active”.
You can also archive products instead of deleting them to keep your product list organized but still keep all the product information available to you in Admin.
As per Shopify documentation – Product Status field is still in Beta and might not be available for Shopify Plus and other stores yet.
Steps to bulk update Shopify Product Status
- Export Shopify Products with Excelify.
- In the exported file, update the “Status” column.
- Import your edited file.
- Enjoy your updated Products!
1. Export Shopify Products with Excelify
On the Excelify app Home page, find the “Export” section and press the “New Export” button.
This will open a new export page where you can configure what data you wish to export.
Select export Format
At the top of the new export page, you can select the format you wish to export to.
We recommend choosing the “Excelify: Excel” format to export to the Excel file, which is most human-editable.
You can also work with the CSV file. To do this you need to select the “Excelify: CSV” format.
Select Product columns to Export
After selecting the format you can select what items to export.
Here you would need to select “Products“. Once Products have been selected, you can see that there are many groups of items that can be exported.
In this case, we only need to update the Status column, therefore we can also select to export specific columns.
Open the “Advanced” tab under Products and click on the “Add | Remove” button to select which columns to export.
To only bulk update Shopify Product status, you need to select the following columns:
If necessary you can also add other columns to your export, but note that the app will update any field in Shopify from the columns you have in the import file. So make sure that values in the additionally exported columns represent what you want to import. Or you can remove those extra columns completely from the file before importing.
Apply filters to your Export
In most cases, you would only need to update the Status for some products. In this case, you can use our “Filter” option to only export specific Products.
If you do need to export and update all products, then you do not need to apply any filters.
To apply filters click on the “Filter” button.
Then you can select various filters that you can apply to your export.
For example, if you need to export all Products that are tagged “X-Mas Products” or “Summer Products”, but only those that have “Draft” or “Active” status.
You can also apply and combine any other Product filters for your export.
Start the Export
Once you have constructed the export details, you can click on the “Export” button at the top or bottom of the page to start the actual export.
You will see that the export job will go into an “In Progress” status and the app will show the progress.
The export page or app does not need to stay open while the export is running, so if your export looks like it will take a while, then you can close the app, and the store owner’s email address should by default receive an email when the export job has finished. You can check the email notification settings on the Excelify app Settings page.
2. Download and edit the exported file
Once your export is finished you can click on the “Download Exported File” button to download your file.
In the file, you should see the columns that you selected to export and only the products that match your applied Filters.
Now you can edit the “Status” column in your exported file. The possible values for the Status column are:
Active: the product is ready to sell and is available to customers on the online store, sales channels, and apps.
Archived: the product is no longer being sold and isn’t available to customers on sales channels and apps.
Draft: the product isn’t ready to sell and is unavailable to customers on sales channels and apps.
In this example, let’s change all exported Active Products to “Archived” because you need to hide them from your store. And change Draft Products to “Active”.
Set values you need for each Product like in the following example:
3. Import your updated file
Once the Status column values in the Excel file are set as you need, you can save the file and head back into the Excelify app.
Upload the saved file in the Excelify app “Import” section.
The app will create a new “job” and start to analyze the uploaded file.
Once the file has been analyzed you will see the “Ready to Import” badge at the top of the page.
You can check that all item counts are correct and start the import by pressing the “Import” button at the top or bottom of the page.
As the import is running you will see the progress – how many items the app has updated and estimate when the job will finish.
Same as with export – you do not need to keep the app open and by default should receive an email notification when the job finishes.
4. Enjoy your updated Products!
Once the import is completed, you can go to your Shopify Admin and check your updated products!
Good to know!
- You can also bulk publish and unpublish your Shopify Products from the Online Store sales channel within the same import – by just adding the respective columns.
- See our Products sheet documentation to learn what each column means in our template.
- Check out other Product-related Excelify tutorials.
- The product Status field was introduced by Shopify in October 2020.
- Have any questions or issues? Let us know!