SQL statement to add comment criterion to all products?

[bloggus]

Is there a way to add comment criterion to ALL products at the same time?

SQL that can be run?

Now it is basically impossible to add it to 1300++ products ...

[Bruno Leveque]

Hi,

If you don't link a criterion with any product, it will be available for all of them I guess?

If it's not the case, we need to change the behaviour

Regards,

[bloggus]

Hi,

If you don't link a criterion with any product, it will be available for all of them I guess?

Unfortunately it is not the case .... therefore I'm looking for some solution to link it to all products at once.

[bloggus]

Check it once more time ... and it don't work.

[bloggus]

There has to be a way. I can't be the onlyt person looking for a solution

Which tables are used to store the relation between product and criterion?

[Champ4!*]

Guys,

I had the same problem and I solved it with this SQL:

INSERT INTO ps_product_comment_criterion_product (id_product, id_product_comment_criterion) SELECT id_product, (3) FROM ps_product GROUP BY id_product;

I only have one criterion called "Score". This criterion has ID number 3 on my DB, so you need to change that ID and that it's all.

With that SQL I put criterion "Score" on all my products in a batch.

Regards.

PD: My PS version is 1.3.6, so be caureful with other versions.

[pow]

Great!

This as module would be handy

[Nancy Wilson]

You can use two ways to add comments in the SQL.

--Select * From Table

or

/* Any

Query */

I am getting the issue to install the SQL Server. What should I do to resolve this issue? I install Avast antivirus and also try on avast customer service for the help purpose but did not get any response.