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

Hi!

I am having a strange problem.
Alle the categories are activated and also my products, but i read the sentence There are no products to list in this category.
The only thing shown is new products for this month.

And you have to manually click the new button on the main page to see the newly added products, is that a normal procedure? I want to show the newly added products directly on the main page.

URL: http://www.car-stickers.nl/zen

Quote:

---

Originally Posted by Marcel Wiegers

Hi!

I am having a strange problem.
Alle the categories are activated and also my products, but i read the sentence There are no products to list in this category.
The only thing shown is new products for this month.

And you have to manually click the new button on the main page to see the newly added products, is that a normal procedure? I want to show the newly added products directly on the main page.

URL: http://www.car-stickers.nl/zen

---

Generally speaking, a default template would show the new products without manual action by the user. It would appear, however, that your template does not do that and requires the user to click the new "link" to display the new products.

My advice is to possibly write to the cretor of your template and see if they can help you, to modify the code yourself, seek other zenners willing to provide the code locatioons to modify the template, or to seek someone willing to do this for a fee.

Things that would help other zenners to identify what to change would be to identify your template and perhaps a location to download it from. If you paid for your template, I would definitely recommend contacting the author.

Thank you for your response, my template is Responsive Sheffield Blue, i will post the message over there and if i have the solution post it over here so other people can use it also.

Tthe date of the product wasn't saved properly and remained empty, that's why the categories weren't filled. I figured out another way to add a date and it works. Now 600 products to go... ;-)

The new products on the main page can be shown by editing th css file for the template.

Quote:

---

Originally Posted by Marcel Wiegers

Tthe date of the product wasn't saved properly and remained empty, that's why the categories weren't filled. I figured out another way to add a date and it works. Now 600 products to go... ;-)

The new products on the main page can be shown by editing th css file for the template.

---

Well, at least the source of the problem identified here was identified. Of course need to resolve why that happened. In the mean time you could either run a SQL query to update all products (if all are/were affected) or to update only those that don't have a date.

I was also thinking you could use something like easy populate, but I'm guessing you really need to get back to business quickly.

Thank you for your reply, I want to place the site live ASAP, but the only thing is I am not used to work with SQL query. All the products have the wrong date unfortunately...

Quote:

---

Originally Posted by Marcel Wiegers

Thank you for your reply, I want to place the site live ASAP, but the only thing is I am not used to work with SQL query. All the products have the wrong date unfortunately...

---

From within the ZenCart admin panel, if you go to Tools->Install SQL patches and enter the following query, all of your products that currently do not have a product_added_date will be updated to have the product_added_date of "now".

UPDATE `products` SET
`products_date_added` = NOW( )
WHERE `products_date_added` = '' ;

After that, you need to figure out why your 600+ products were added without dates so it does not happen again.

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!

Quote:

---

Originally Posted by 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!

---

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

Quote:

---

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.

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!

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