PS1.6 How to set a default combination for many existing products at once (bulk change)?

[ShopMaster888]

Problem:

The webmaster did not set a default combination for every product.
After upgrade from 1.4 to 1.6, the products that do not have a default combination are displaying with price 0.

The shop has over 7000 products, almost all with combinatons. It seems that about 1000 products do not have a default combination set. Changing these products manually will take days.

Question:

Does anyone know of a solution to automate this proces: to set a default combination at products that do not have one set yet?

 

Thanks for any input

[innovacy]

I would go for one of these approaches:

 

• Use the import feature to set the combinations properly (not tested, might work with exporting the data first and changing the columns quickly in excel, but might also not)
• Check what is required in the database and do it with a sql query (I would post more details, but I myself need to check first, I don't have this in my head)

 

Both methods should be very quick.

[ShopMaster888]

Hi Innovacy, thanks for your input.

I think a sql query would be a good solution.

but I am a bit rusty on SQl statements

 

Does someone have an idea for a SQL Statement that does this:

 

1. Search products where all default combinations are Null

2. For these products set first combination as default

 

That should solve my problem I guess.