google product category is missing

I cannot get it work

i get
in the xml file

This product probably don't have the custom field "google_product_category".

sorry !

Yes you're right. This means i have to pass over each product now and i insert this ???

I gave for default value in the custom field configuration the value
isn't it possibel to put out the default value given in the field or do you recommend to do it by database ??

You execute this query:

just replace the #_ by your tables prefix, whateveryouwant by the value of the custom field and catID by the ID of the category.
This query will then update every product for the category specified

Thanks worked great !!

At this point i like to repeat my compliments for your support and remind you if you are planning to upgrade just do it. Great product and great team.

Glad to see you're satisfied , I hope you'll enjoy the coming features!

Sorry to bring up an old thread, however this thread is the closest I've come to getting google_product_category to work.

Google has since updated what they require. Many of my products have different categories. Google has also made it so that there are ">" greater than signs IN the TEXT of the variable.

So when I attempt to use the provided code edited for our situation:

UPDATE #xxxx_hikashop_product as p LEFT JOIN #xxxx_hikashop_product_category as pc
ON p.product_id=pc.product_id
SET google_product_category='Vehicles & Parts > Vehicle Parts & Accessories > Motorcycle Accessories'
WHERE category_id="35"

I am provided this error:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON p.product_id=pc.product_id SET google_product_category='Vehicles & Parts > V' at line 2

Basically this says that the ">" is being treated as a command instead of just text.

I have tried to use "& gt ;" and "& #62 ;" in place of the ">" (yes, I added a space before the ; so my post would show instead of creating a >), but I was provided the same error as above.

What am I doing wrong here? Is there a special character that is used so special characters like this can be used in the SET command?

Thanks! I'm so close I can taste the google_product_category...

did you try the massaction feature?

I attempted to use mass actions for this but all it does it create a "massaction" that never gets applied.

I selected create new under massactions.
I selected the radial button next to "Product" under "Data."
Under "Filters" I added a "Product columns" Filter with 2 rules:
product_published = 1
AND
category_id = 35
Under "Actions" I selected "Update the values"
google_product_category = "STRING" Vehicles & Parts > Vehicle Parts & Accessories > Motorcycle Accessories
I click on Process and it says that "This process will execute."
It then says that it's "Saved" but nothing happens to the database or the products.

Maybe I'm not understanding Massactions feature but it is very hard to use in comparison to just running a SQL command.

What am I missing?

So after many attempts to process it, I found that I had to click the X next to the "Trigger" and then click "process"
It all seems good now!
Thanks!