Hi Arlan,

I will recommend you to take a look directly in uCommerce product table through SQL Management Studio (or other tool). The table is called uCommerce_product. If the product is not in the table then try to take a look on the table design for that table and see what max length is for the field SKU (there is a chance your SKU is too long) but you have to check it through SQL manager.

Best regards Martin

Hi Martin

I connected to the table uCommerce_Product but i dont see the Sku records in there (I have over 130 products in uCommerce with 13 digit SKU numbers)
maybe you can point me what i need to do, how would i search for a SKU number  9781935806370 in database?

Thank you Martin
I was able to delete the product.
 

Here is what i did

ALTER TABLE [reedypressucommerce].[dbo].[uCommerce_Product] NOCHECK CONSTRAINT [FK_uCommerce_Product_ParentProduct]

DELETE FROM [reedypressucommerce].[dbo].[uCommerce_ProductProperty] WHERE ProductId='416'

DELETE FROM [reedypressucommerce].[dbo].[uCommerce_ProductDescription] WHERE ProductId='416'

DELETE FROM [reedypressucommerce].[dbo].[uCommerce_PriceGroupPrice] WHERE ProductId='416'

DELETE FROM [reedypressucommerce].[dbo].[uCommerce_CategoryProductRelation] WHERE ProductId='416'

DELETE FROM [reedypressucommerce].[dbo].[uCommerce_Product] WHERE ProductId='416'

SELECT TOP 1000 [ProductId]

      ,[ParentProductId]

      ,[Sku]

      ,[VariantSku]

      ,[Name]

      ,[DisplayOnSite]

      ,[ThumbnailImageMediaId]

      ,[PrimaryImageMediaId]

      ,[Weight]

      ,[ProductDefinitionId]

      ,[AllowOrdering]

      ,[ModifiedBy]

      ,[ModifiedOn]

      ,[CreatedOn]

      ,[CreatedBy]

      ,[Rating]

  FROM [reedypressucommerce].[dbo].[uCommerce_Product]

Instead of deleting sku i deleted the product id of that sku

is working on a reply...