Randaal Posted August 10, 2014 Share Posted August 10, 2014 When I need to completely delete a few orders (my store went crazy so I created a few orders during reparation) which tables should I delete it from? I suppose that ps_orders isn't enough, right? Link to comment Share on other sites More sharing options...
vekia Posted August 10, 2014 Share Posted August 10, 2014 yes it's not enough. ps_cart ps_cart_product ps_order_return ps_order_slip ps_order_history ps_order_detai ps_orders Link to comment Share on other sites More sharing options...
Randaal Posted August 10, 2014 Author Share Posted August 10, 2014 thank you Vekia, that's what i needed :-) Link to comment Share on other sites More sharing options...
El Patron Posted August 10, 2014 Share Posted August 10, 2014 TIP: it is best to simply cancel the orders, and leave them alone, deleting can lead to errors you never imagined later. (ghost products, etc). Link to comment Share on other sites More sharing options...
vekia Posted August 10, 2014 Share Posted August 10, 2014 this is why i mentioned cart tables ;-) Link to comment Share on other sites More sharing options...
El Patron Posted August 10, 2014 Share Posted August 10, 2014 this is why i mentioned cart tables ;-) yes, I understood the post, I just add additional as doing this has caused issues for some. ghost orders ... and another issue for some, what if they have OEM module that has it's own information about orders, and they don't get cleaned up. it's just a slippery slope when we change db/files outside of ps, and canceling orders is safe Link to comment Share on other sites More sharing options...
Recommended Posts