need to display recent added products
 

How do I go about listing ALL recent products that were added? I want to create them in a list like <a href="url to product">PRODUCT</a></br>

I am doing this on my welcome.tpl, and need to include another file to produce this, right? Someone, please help me!

Re: need to display recent added products
 

A lot depends on what is "recent", products added in the last month, last week, last day, last 10 minutes, :-)

Anyway, this question has been asked a million times (well, almost). There are several threads and mods that allow you to have a page that looks like a category page but only has "recent" products. Unfortunately, I haven't found one that works properly for 4.4.x versions of x-cart. X-cart really needs to make this a module.

There is a thread at http://forum.x-cart.com/showthread.php?t=57790 that discusses the latest incarnation of this, and there are probably 3rd party mods that do the same thing as well.

That said, what you are specifically asking about should be pretty simple. You need to search the database for all products with a "add_date" that is newer than "whatever is least recent" (called for in seconds) and output a list of urls to those products. The thread mentioned above should give you some clues on this.

Re: need to display recent added products
 

So, do I just need to make a custom SQL query inside index.php to allow for displaying newly added items? What would be the exact SQL code for this? Say, date added 1 year ago, and anything since then?


Is there a way to only show the last most recent 100 products, or so?


When will xcart add this feature to the software? Do you know of any specific 3rd party mods?

Re: need to display recent added products
 

Download the zip file in the thread at http://forum.x-cart.com/showthread.php?t=57790

It should get you started. Since all you want is a link to the new product just set up a list and include just the link to the product (probably linked to the name of the product). This should be in the products_tn.tpl file.