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

Quote:

---

Originally Posted by Marcel Wiegers

Hi!

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

http://img19.imageshack.us/img19/9923/abr9.png

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. :)

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

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

Quote:

---

Originally Posted by 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 ;-)

---

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.

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

Quote:

---

Originally Posted by 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 ;-)

---

Congrats! Happy selling! And tot ziens!

Thnx :-)