Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 2 of 2

Thread: Bulk delete

  1. 10-05-2009, 01:28 PM #1
    jamotion is offline Senior Member
    Join Date
    Jul 2007
    Posts
    215

    Default Bulk delete

    I have about 1000+ products in my db that needs to be deleted because its no longer available.
    1) What is the best way of deleting the products? by sql?
    2) Is there a way of bulk deleting images associated with the products?
  2. 10-05-2009, 03:00 PM #2
    DanV's Avatar
    DanV is offline Ursus arctos horribilis
    Join Date
    Apr 2006
    Posts
    1,568

    Default

    SQL would be the fastest way, yes, but make sure you also clean up the variants table, kit tables, etc. There is no easy way to bulk delete the images (except via FTP if you know all the product IDs) without writing some custom code to look for orphaned images.