How to delete multiple combinations that I don't need

[archproject]

Hi all,

I have a few combinations generated from the Product combination generator ... and I want to delete some of it efficiently without clicking the X button 36 times (need 36 combinations deleted)

Please help

[AnnaEw]

I need this item too! Is there a way to place a tick box to select each combination I need to delete and then delete them all in 1 step? Help please!

[need4speed]

Yeah it whould be a time saver!

[Aldeag]

I need this item too! Is there a way to place a tick box to select each combination I need to delete and then delete them all in 1 step? Help please!

It´s a must!

[Carolina Custom Designs]

This feature is pretty much already available to you

 

All you need to do is go to the product; click on Combinations then select 'Product combinations generator'. Once you are there simply select all the combinations you want to delete from the right column attribute box and then just click 'Delete'. It is that simple. It will delete all the combinations you have highligted at once. To select multiple attributes just hold down Ctrl or to select all within a section hold the Shift key.

 

Hope that helps!

 

Marty Shue

[mrbinarydigit]

It is not correctly beacause in this way I delete all combinations with the attribute. Example

Attribute A: grey, green, noir

Attribute B: s, m, l, xl

If I delete m attribute, the t-shirt m is cancelled but I have for example 4 t-shirt green m, but only t-shirt noir M is not present.

In this case the generator do not make it.

For esample this combination does not possible with generator:

T-Shirt grey s

T-Shirt grey l

T-Shirt grey xl

T-Shirt noir s

T-Shirt noir xl

T-Shirt green m

In case I have 30 attributes it is a problem because set it manually is very hard. There is a solution?

Thanks and pardon my english.

[stfrons]

Currently testing Prestashop and Magento, and even though the generator in itself is good, I am truly baffeled over not being able to delete more than one combination at a time. The tick boxes are everywhere else, why not here as well? Deal breaker for me, but this must be fixable?

[senor.munoz]

Will be a great feature something like this. I've got the same problem (but in spanish )

 

 

Thank you!

[SeadT]

Yes, this would be very useful. Isn't there a module that would add some check-boxes on the side?

[TTYouri]

Any news on this?

 

The lack of bulk updating, or at the very least bulk deleting is hugely time-consuming and user-unfriendly.

[SeadT]

I recommend Mass Combination Editor by Presto-Changeo.

It is $75 but definitely worth it.

[Aloud]

Bump

 

I took over a Prestashop website and discovered a huge amount of combinations.

 

I created a module to give me this, PM me for further info

 

[design4VIP]

Bump

 

I took over a Prestashop website and discovered a huge amount of combinations.

 

I created a module to give me this, PM me for further info

 

 

some short desription - tutorial about it? where I must combine? which controler/classes? You use helper or "hard code"?

 

it's solutions to 1.5 or 1.6? ~1.6.0.14 or 1.6.1?

[trevorgilligan]

similar to @carolinacustomdesigns if you go in to generate combos , ctrl + a will highlight them all, click delete. then click a simple attribute such as "color = red" and click add. so you only have 1 attribute. click default value as 1. this should delete everything leaving only 1 combo. if this doesnt work, another way is to go into the php my admin mysql database, find the table attributes (if there is one.) search for the id of the product in here and delete all. this might work but i cant guarantee. its what i was going to do if the step by @carolinacustomdesigns didnt work, but it did

[musicmaster]

Triple Edit offers the possibility to mass delete selected combinations.

Edited August 29, 2015 by musicmaster (see edit history)

[YasinTürk]

where modules? download link?

[vucumbra]

Bump

 

I took over a Prestashop website and discovered a huge amount of combinations.

 

I created a module to give me this, PM me for further info

 

 

share your module please

[IgnacioPer]

You can delete combinations directly from the database. I always use MariaDB, but you could also do it with phpmyadmin. TRY IT AT YOUR OWN RISK and always make a backup of the database: touching the db can shot down your website. Replace the * with your database prefix.

At first you need a query to retrieve the id_product_attribute of each combination. An easy way to do this is by running the following query:

  SELECT id_product_attribute, reference INTO OUTFILE 'comb_id_references.csv' FIELDS TERMINATED BY ';' ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM *_product_attribute;

You'll get a file named 'comb_id_references.csv' that tells you the id of each combination reference. You choose the ids of the combs you're going to delete, and then run the following MYSQL queries (you have to run the queries for each combination you want to delete):

  DELETE FROM *_product_attribute WHERE id_product_attribute=[your id_product_attribute];

  DELETE FROM *_product_attribute_shop WHERE id_product_attribute=[your id_product_attribute];

  DELETE FROM *_product_attribute_combination WHERE id_product_attribute=[your id_product_attribute];

  DELETE FROM *_stock_available WHERE id_product_attribute=[your id_product_attribute];