There are no products to list in this category. But there are!

[Marcel Wiegers]

Allright that explains a lot! Thank you for your explanation and i understand now that you can leave it blank in the future, looking forward to see if you can make a query, or else we do it old fashioned by hand ;-)

[mc12345678]

Allright that explains a lot! Thank you for your explanation and i understand now that you can leave it blank in the future, looking forward to see if you can make a query, or else we do it old fashioned by hand ;-)

Here goes: I recommend backing up your database before using this query, I believe I have it properly written, but haven't tested it myself.

UPDATE `products` SET `products_date_available` = NULL WHERE `products_date_available` > NOW( ) ;

The above query will unset all of the products that have an available date in the future. So if you have/had specific products you didn't want available now, either deactivate them, or you can modify the WHERE clause to target just those that have a specific date.

Again, if you don't already have it, I recommend getting something like Easy Populate so that you can modify several items at once with a single update. It will be a journey of it's own to understand how to use it, but with 750+ items in your store, it would speed things up for you and may make future efforts easier.

I have come to understand Easy Populate 4 which is still considered in beta testing, but I haven't tried them all yet, so don't have a specific recommendation.

[Marcel Wiegers]

IT WORKED!!! Thank you very much!!!
I will take a look at easy populate, but first i want to have the website online asap ;-)

[mc12345678]

IT WORKED!!! Thank you very much!!!
I will take a look at easy populate, but first i want to have the website online asap ;-)

Congrats! Happy selling! And tot ziens!