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
vBulletin® v3.8.4, Copyright ©2000-2012, Jelsoft Enterprises Ltd.