PDA

View Full Version : Deleted products


granthams
12-Sep-2006, 01:37 PM
Hi all,

Can anyone tell me what table and column holds the data that defines if a product is deleted or not?

Is it a simple 0 or -1 somewhere in the product table?

Kind regards

jxm28788
13-Sep-2006, 08:42 AM
There is a column called 'status' in the product table, it seems to be 'D' for Deleted and 'N' for...errr...Not deleted? :)

acompton
13-Sep-2006, 08:54 AM
'N' for...errr...Not deleted?
errr... New?

granthams
13-Sep-2006, 09:03 AM
Cheers guys.

I have just spoke to tech support and you are correct.

The same column is also in the 'catalog section' table for deleted sections too.

'N' for...errr...Not deleted?

N is for Normal apparently....

Many thanks