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

[Marcel Wiegers]

Hi!

Thanks, i figured out all the dates are on 2013-10-31, i duplicated the products one by one because of the options and so it happened that all the dates are on that day. I added new products as a test with the date of today and that didn't work because the date filed remains empty, but when i set the date to tomorrow the system configures it well (?).

The SQL query didn't work unfortunately, is it because of the 2013-10-31?

Despite of the troubles thanks for your help anyway!

[mc12345678]

Hi!

Thanks, i figured out all the dates are on 2013-10-31, i duplicated the products one by one because of the options and so it happened that all the dates are on that day. I added new products as a test with the date of today and that didn't work because the date filed remains empty, but when i set the date to tomorrow the system configures it well (?).

The SQL query didn't work unfortunately, is it because of the 2013-10-31?

Despite of the troubles thanks for your help anyway!

I am unfortunately at a loss of what to say. I think there is a miscommunication/misunderstanding. I have more questions than answers: why is there a date in the future? What field has the future date? What is it that you are trying to display that has not been displaying unless the date is in the future? A few comments back, said that

Tthe date of the product wasn't saved properly and remained empty, that's why the categories weren't filled.

Please clarify to help with a way to rapidly get your products online/proper instead of manually adjusting 600+ items.
The SQL was "designed" based off of the description of what was provided, if that was misunderstood by me, then that is why the SQL "didn't work".

If you are showing "upcoming products" then yes, the date of concern/to be filtered must be in the future, not today and not yesterday. If we are talking about products in the respective category/(ies), I would expect that the date of concern should be in the past, because it makes sense not to show a product until a certain date/time has been reached.

Hopefully though you have figured out how to keep your products up and visible. Concerned that you will have to routinely update the database from day to day to keep your product(s) visible. There is no reason to need this and is counterproductive to running a sales site such as with ZenCart.

[Marcel Wiegers]

Hi!

I hope this screenshot explains what i mean, because it is a little strange problem ;-)



When i put the date of today in that field, and i save the product, the field remains empty, when i put the day for tomorrow in it, everything goes well.
About the date i mentioned before, i don't know how that came in, perhaps a mistake of myself.

Fact is that over 600 products have the date 2013-10-31.

Yesterday i have added about 150 new products and it did go well when i putted the date on one day later (instead of 21 oct, 22 oct).

I hope i have explained everything clearly now.
And when there is no solution to automate the date to today, i will do it manually.

Did i mention i am very glad you try to help me out, really appreciate it!

[mc12345678]

Hi!

I hope this screenshot explains what i mean, because it is a little strange problem ;-)



When i put the date of today in that field, and i save the product, the field remains empty, when i put the day for tomorrow in it, everything goes well.
About the date i mentioned before, i don't know how that came in, perhaps a mistake of myself.

Fact is that over 600 products have the date 2013-10-31.

Yesterday i have added about 150 new products and it did go well when i putted the date on one day later (instead of 21 oct, 22 oct).

I hope i have explained everything clearly now.
And when there is no solution to automate the date to today, i will do it manually.

Did i mention i am very glad you try to help me out, really appreciate it!

Ohh, that date? I leave it blank unless I want the product to show up in the future. :)

I looked at the stock on our site to see what kinds of dates we had entered in, on one disabled product it had 0001-01-01, on another disable product it was blank, and on an active product it was also blank. All of our active products are on the site.

So, basically, your products that have a hallow's eve date (2013-10-31) won't show until that day. I'll look to see if what the query would have to be to change your 2013-10-31 products to a different date. Need to figure out what the field is called and then you could use what was provided before with the changes to be given.

No problem, we're all here to try to help and make our niche in the online market. :)

[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 ;-)

[Marcel Wiegers]

And the dates you can leave blank by the way, i tested it and it works fine!