Kerm Posted August 16, 2011 Share Posted August 16, 2011 Hello i found some bug or just dunno how need delete product.. When i try delete in my shop some product, his atributes and combinations not delete with him and it's sux. When i try next time import this product i see his duplicates add on site also...like i add 1 product but see 1:1 from 2 to 10 dublicates...and this bc products atributes and combinations not delate when i delete product. Link to comment Share on other sites More sharing options...
tomerg3 Posted August 16, 2011 Share Posted August 16, 2011 What version of PS are you using? Did you make any modifications? Did you upgrade from an earlier version? Link to comment Share on other sites More sharing options...
Kerm Posted August 16, 2011 Author Share Posted August 16, 2011 Clean 1.4.4 Add products only from import. I try delete by hands or when import use check box "delete products before import" but it's only clean ps_products table, not ps_attributes... When I enter to ps_attributes I see some table: Check box | field | type | Collaction | attributes | null | default | extra | action In field row I see: "Id_attributes" and when I press in action "Browse distinct values" i see my attributes table: Check box | id_attributes | id_attribute_group | color And list under like: 45747 | 373733 | black Btw: base is innodb Link to comment Share on other sites More sharing options...
tomerg3 Posted August 16, 2011 Share Posted August 16, 2011 ps_attributes is not related to any products, which is why it is not deleted. There are other tables which hold the attribute information that is connected to products, and those should be deleted (at least the info for the product you delete). Link to comment Share on other sites More sharing options...
Kerm Posted August 16, 2011 Author Share Posted August 16, 2011 Mb but if I clean all products and category from admin panel and try again import products I see products duplications..and some of them have combinations...but hello!! I don't import my combinations yet...so I think that when I delete my products from admin panel, combinations not delete and it's all... That's is problem. Link to comment Share on other sites More sharing options...
tomerg3 Posted August 16, 2011 Share Posted August 16, 2011 Can you try to save one of the products (in the product editor) and see if you get any errors. If you manually add a product and assign combination to it, do they get deleted when you delete the product? Link to comment Share on other sites More sharing options...
Kerm Posted August 16, 2011 Author Share Posted August 16, 2011 I try tomorrow. Link to comment Share on other sites More sharing options...
Kerm Posted August 19, 2011 Author Share Posted August 19, 2011 I try and same problem. Also I found some more bad things: 1)I import combinations with 1 image url in each combination, and images add to product, after I import new combinations but without images and use option “delete old combinations before import” i see combinations images from old import not delete.. 2)Also if I delete old combinations from Catalog -> Attributes and Groups combination images not delete too. On 100% if delete products or category with products, their combinations not delete if add all by import them. If self made product and combinations in admin panel I see same thing. And how i said if after delete combinations too they not delete. Link to comment Share on other sites More sharing options...
Recommended Posts