Hi there v3.9 is there a quick way to delete all products from the database? im using query express ive imported thousands wrongly so prefer not to do it from the back office as its a bit slow! thanks!
Hi there v3.9 when i delete all the products and then re import products the product url then becomes -2 as if the site still remembers the original product. as i dont want the "2" version of the url have i missed a step in the deletion process? i.e.
Hi there v3.9 when i delete all the products and then re import products the product url then becomes -2 as if the site still remembers the original product. as i dont want the "2" version of the url have i missed a step in the deletion process? !
Hi,
This is because slug still present in UrlRecord table. -1,-2 indicates same name multiple times.
If you don't want to display it, then just delete the UrlRecord for products.
To specifically delete one product slug:
Delete from UrlRecord where EntityId = [product id here]
To Delete all products slug:
Delete from UrlRecord where EntityName = 'Product'
Noted: delete products first and then remove slug, otherwise you may face same issue
Hope this helps!
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.