Product id 1****0 already exits in the catalog area

[deepak_venga]

Hi Folks,

I am getting an error message "Product id 1***0 already exists in the catalog area" COM_PCAT_O418 but in reality the product id does not exist in the catalog area.

I found certain interesting observation on debugging the issue.

1. The table comm_pcat_itm( item table for the product catalog area) has got an entry of the product due to this the error message is populating on trying to add the product.

2. The product id is not showing in the catalog area as table comm_pcat_itv (active and  inactive version table for product) does not contain the entry wth respect to the comm_pcat_itm.

3. In ideal scenario both comm_pcat_itv and comm_pcat_itm has got link to tell the product is active or inactive.

Please feel free to comment and post your thoughts.

Thanks in advance!!

[former_member193379 · Accepted solution]

Hi Deepak,

It is better to delete this item through FM (COM_PCT_ITEM_DELETE_D).

Thanks,

Hamendra

[deepak_venga · Accepted solution]

Hi Hamendra,

I welcome your comment and I agree with your point for deleting the item entry using the FM COM_PCAT_ITM_DELETE_O as the item version is not updated.

Many Many Thanks!!!

[deepak_venga]

This message was moderated.