How to not show a product as New?

[bkpie]

Anyone have an easy way if you add a product that it does not show as new?
Everytime I add a product it shows as new however sometimes in my case it is not new but will end up on the front with the other ones that are new.

Thanks in advance.

[met00]

new products are determined by the now() that is used to add them to the database. There is no way to edit this field from within osc, but you can use phpadmin or another tool to access the database and change the date after you have added the product to change the date the product was added to the store and that will remove it from the New Products listing (ie: backdate the products addition by a year).

the table is products
the field is products_date_added

[bkpie]

Met00

I did that and it shows a year earlier in the database but not on the site for some reason. ???

[met00]

Here is the query from /includes/modules/new_products.php

 $new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, p.products_price as products_price from " . TABLE_PRODUCTS . " p where products_status = '1' and month(p.products_date_added) = month(now()) order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);

Interesting, the code has a crap component, it doesn't check for the month and year, just the month. I would consider this a major defect in the code (or as some people refer to it... a bug). My suggestion is that someone fix the sql query as this is a major "bug" if you don't add any new products for that month it will pick up the last years new products added in that month.

[ezkawan]

i Also Have this problem. How to resolve this problem??

[michael_s]

read the stickies:
products_new.tpl.php

It is original osC code and hardly a major bug. Very simple to change, thus the sticky in the forums. It is on the list of things to do and will make it into the 2.0 full release (probably the next RC, but no promises)

[met00]

Interesting, but I disagree. If every time you turned on the right turn indicator in your car it indicated that you were going to make a left turn, that would be a minor defect?

Major defects are those that either (1) stop operation or (2) provide significant misinformation from correct operation. I believe listing products that are a year old as "new" classifies as (2) in much the same way as the turn indicator on your car telling other drivers misinformation would be a major defect.

Minor defects deal with stylesheet and look and feel issues that present information poorly. Think again of the car and a window that when closed doesn't seal properly and whistles at you. It doesn't affect the operation of the vehicle and doesn't misinform others.

If you look at the original Recover Carts I released. There were no "major defects". But, the entire project blew off all the standard OSC look and feel requirements for the admin. This was one big "minor defect". Thus over time people have tweaked the basic application adding a very few new features, but in fact have not done much to the basic application and have made no "fixes" to any major defects that I had introduced in the code. Almost all of the changes that were made had to do with fixing minor defects and making it work like a part of OSCs admin.

[michael_s]

It is considered a minor issue in that it in no way causes the cart to stop functioning and is a secondary or some would argue tertiary feature. We at oscmax define major bugs as those that cause the application to fail to function, fail to allow sales, or as critical security issues. Information issues of this nature or not considered major or critical and would be classified as a minor issue or a tweak.

Your example of the turn signal does not really apply since this is such a non-critical feature when compared to a turn signal. Nobody can be killed if a product is marked as new when it really isn't (or in e-commerce terms, your site will not stop functioning because you show a product that is not new as new). Also, this issue does not do the exact opposite of what is expected as your turn signal example, rather it simply does something extra (more like every twelfth blink of the turn signal it flashes both left and right at the same time).

While I agree that the function leaves something to be desired, it is hardly a major issue. In fact some have posited that this actually creates interest in products that would otherwise not be displayed, and like having it.
I can guarantee as soon as this 'issue' is 'fixed', I will get no less than 5 emails complaining about how I broke this 'feature' and they want it back.

[met00]

That's why at the same time it's "fixed" we should add a new module called "random products" that does what happens now, but with a bit more randomization.

a defect that does something that is serendipitous should be a feature on its own.