Developer forum

Forum » Swift » Restore 'New' badge without changing publications days

Restore 'New' badge without changing publications days

Caro De Weze
Reply

Hi,

The 'New' badge no longer appears on the products because the publication date has passed. Can I adjust this date somewhere for my products in PIM? This is because the site is not yet live, but the products have been up for more than 180 days.

Kind regards,
Caro De Weze

Screenshot_2024-06-14_at_13.29.54.png

Replies

 
Nicolai Pedersen Dynamicweb Employee
Nicolai Pedersen
Reply

Hi Caro

Yes - you can update the EcomProducts table column ProductCreated - set it to a date you want.

I.e. set it to todays date: 

UPDATE EcomProducts SET ProductCreated = GETDATE()
 
Caro De Weze
Reply

Hi Nicolai,

Thanks for your reply. 

I have now adjusted the creation date of one product for testing with the following query:
UPDATE EcomProducts
SET ProductCreated = '2024-05-26'
WHERE ProductNumber = 'SUNE 0800';

And then tested with this:
SELECT ProductNumber, ProductCreated
FROM EcomProducts
WHERE ProductNumber = 'SUNE 0800';

In the result you can see that the date has been adjusted (and also in PIM):
But the badge doesn't appear. The settings of the badge in the product detail and overview are also correct:

I also cleared the cache.

Kind regards,
Caro De Weze

 

You must be logged in to post in the forum