Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

#1 06-01-2015 08:33:50

tguswell
Member
From: Plymouth, Devon
Registered: 07-31-2010
Posts: 128
Website

Adding/deleting items in New Products page/section

Is there a easy way of clearing the items that are on the New Products page? Over a period of time I've become lazy and have added new items to this area but have forgotten to remove the older ones.

Thanks

Terry

Offline

 

#2 06-01-2015 08:40:32

tguswell
Member
From: Plymouth, Devon
Registered: 07-31-2010
Posts: 128
Website

Re: Adding/deleting items in New Products page/section

What I've done is export the products as a csv file, edited it within Excel, and the imported it back into Europacrt again.

Terry

Offline

 

#3 06-01-2015 08:44:56

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19951
Website

Re: Adding/deleting items in New Products page/section

You can do this in Raw DB Admin.  Execute this to wipe out the new products list:

UPDATE ecom_prod SET newdisp=0

Then go into the products and set the display in new products flag for the ones you want to display.


Nick Hendler

Offline

 

#4 06-01-2015 08:46:52

tguswell
Member
From: Plymouth, Devon
Registered: 07-31-2010
Posts: 128
Website

Re: Adding/deleting items in New Products page/section

Seeing other posts, I guess the easy answer is to execute this SQL in Raw DB Admin. 

UPDATE ecom_prod SET newdisp=0

This I'm assuming will remove all items marked as new.

Terry

Offline

 

#5 06-02-2015 07:17:01

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19951
Website

Re: Adding/deleting items in New Products page/section

Right!


Nick Hendler

Offline

 

Board footer