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.
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?
Can't delete product
I am having error "SKU already exists within catalog", however i cant find the product with this SKU.
How would i go about deleting the product with this SKU?
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?
Hi Arlan
you can append WHERE Sku = '< SKU >'
Then it should show at least one row.
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...