write sql query to add tag for products

[zubator]

(Sorry for my english)

Hi all.

 

I have about 14000 products and I want to add tag from ps_tag table to 5000 products. How I can write sql query to add this tag for products?

[hemn]

1.  Log into your PrestaShop admin panel.

2.  Navigate to Catalog-> Tags and select Add new tag button from the top right corner:

3. You will see a form where you have to fill in the following data:

• Name: enter a word or a phrase you want to display on the fronted of the site as the tag title.
• Language: select the language to which you want the tag to be added.
• Products: select the products you want to associate with this tag and press Add button. In case you want to remove some products from the list, just highlight the unnecessary product and click on Remove button.

4. Once you enter the correct information, press Save button to save the tag and display it on the front end.

 

Thanks 4  Charlotte Bennett