How do I Manually Change The Publish Date Of Individual Products? (

shanekeller
New Member
4 0 0

Hello,

I imported my website from Squarespace to Shopify; therefore, it created the exact same publish date for everything that was imported.

I want to use Sort Collections > by Newest but that does not work because they all have the same publish date.

I cannot go in and duplicate/recreate hundreds of new products one-by-one to alter the publishing dates. That is not practical and would take days.

Q. What is the method for changing the publishing dates on individual products?

by default 2021-11-01 at 3.57.24 PM.png

Replies 2 (2)
Lilith
Shopify Staff
601 72 161

Hi, @shanekeller! Welcome to the platform and thanks for dropping by the Community Forums here to ask your question!

To edit more than one product's availability/future publish date you can do this through bulk editing. I've gone ahead and made a quick video from my testing store to show you how that works:

Alternatively, you can also use an app from the Shopify app store. Matrixify is known to be able to bulk update published dates for products as well.

I'd like to also bring up that there is an all products/collections page attributed to your store. You have control over what you wan to show up there as well. You can use this guide here to help you control your collection page there. It's a good idea if you have some closed collection items that you only want some people to see or if you have items you don't want to show up in the list of all products, etc. Keeps your site clean, avoids prying competitors from seeing what you have for exclusive items, and your business integrity stays intact at all times.

Lilith | Social Care @ Shopify 
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit the Shopify Help Center or the Shopify Blog

Renars
Shopify Partner
167 22 190

Hello @Lilith and @shanekeller 

Renars here from Matrixify app, thank you for mentioning us!

The collection sorting for migrated Products is a known issue in Shopify.
You sure can use the Matrixify app to bulk update your Product Published At dates.
However - there are a few issues with this in Shopify:

  1. Shopify API does not allow to set products Published At a date in the future. So while you can do that in admin, apps are not able to do so.
  2. The collections date sorting actually uses Products Created At date, not the Published At date. This is a known issue within Shopify as while the Published At date can be set, you cannot set Created At the date and it will always be when the item is actually created in your Shopify store.

That being said - there are still workarounds for this:

  1. You can look into changing the Collection sorting manually and just force specific order of the Products.
    Here we have a tutorial on how to bulk change product positions in collections.
  2. Another solution is to actually create them in the correct order.
    The date would still not be in the past, but you can force the app to create Products in the order as they are in your file.
    So as long as your file is sorted correctly, the items will be created in that order thus the collection sorting would also work.

    To do so, you would need to export all the Products from the store, ideally using the Matrixify app. Include exporting all Product details as you will need that to re-create the Products.

    Once you have the exported file, you need to change the order of products to the correct one. This is a tricky task to do as each product contains multiple rows, but if you are familiar with Excel, it should be doable. It is important that all rows from the same Product are next to each other and each product's top row is the first row for that Product.
    Set the `Command` columns value to `REPLACE` for all Products so that the app deletes the existing Product and creates a new one from the data in the file. When the file is ready, upload that into the app, and in the import options select the option `Import items in the order as they appear in file`.

    So when importing, the app will create items one by one, in the order as they are in the file. Thus the Product Created At dates will be at the time of the import, but in the correct order, as you need them.

I hope that this could work for you. If you have any questions or issues along the way - please reach out to our support directly.

Matrixify | Bulk Import Export Update | https://apps.shopify.com/excel-export-import | https://matrixify.app