[Skip to main content](#vessel-content) # google product category is missing ## - **[Cattelan](/forum/user/20691-cattelan "View Cattelan's Profile")** - [![Cattelan's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/quiet.jpg)](/forum/user/20691-cattelan "View Cattelan's Profile") - [ Offline](/forum/user/20691-cattelan) Less More - Posts: 155 - Thank you received: 4 - - 13 years 5 months ago [\#108929](#108929) by [Cattelan](/forum/user/20691-cattelan "View Cattelan's Profile") Replied by *[Cattelan](/forum/user/20691-cattelan "View Cattelan's Profile")* on topic *[google product category is missing](/forum/3-bug-report/83566-google-product-category-is-missing?start=20#108929 "Hallo. I uploaded manually the googlemerchantfile downloaded from the plugin. Google replyed that the google product category is missing on all products. Where can i apply the category ?? Thanks for reply")* I cannot get it work i get Code: <g:google_product_category> google_product_category </g:google_product_category> in the xml file - [ ![Schermata_del_2013-06-12_171236.png](/forum/attachment/10614) ](/forum/attachment/10614 "...-12_171236.png") [ ](/forum/attachment/10614?download=1 "...-12_171236.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84MzU2Ni1nb29nbGUtcHJvZHVjdC1jYXRlZ29yeS1pcy1taXNzaW5nP3N0YXJ0PTIwJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")** - [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile") - [ Offline](/forum/user/1824-eliot) Less More - Posts: 2334 - Thank you received: 403 - - 13 years 5 months ago [\#108931](#108931) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[google product category is missing](/forum/3-bug-report/83566-google-product-category-is-missing?start=20#108931 "Hallo. I uploaded manually the googlemerchantfile downloaded from the plugin. Google replyed that the google product category is missing on all products. Where can i apply the category ?? Thanks for reply")* This product probably don't have the custom field "google_product_category". Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84MzU2Ni1nb29nbGUtcHJvZHVjdC1jYXRlZ29yeS1pcy1taXNzaW5nP3N0YXJ0PTIwJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Cattelan](/forum/user/20691-cattelan "View Cattelan's Profile")** - [![Cattelan's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/quiet.jpg)](/forum/user/20691-cattelan "View Cattelan's Profile") - [ Offline](/forum/user/20691-cattelan) Less More - Posts: 155 - Thank you received: 4 - - 13 years 5 months ago - 13 years 5 months ago [\#108935](#108935) by [Cattelan](/forum/user/20691-cattelan "View Cattelan's Profile") Replied by *[Cattelan](/forum/user/20691-cattelan "View Cattelan's Profile")* on topic *[google product category is missing](/forum/3-bug-report/83566-google-product-category-is-missing?start=20#108935 "Hallo. I uploaded manually the googlemerchantfile downloaded from the plugin. Google replyed that the google product category is missing on all products. Where can i apply the category ?? Thanks for reply")* 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 Code: Abbigliamento e accessori &gt; Gioielli &gt; isn't it possibel to put out the default value given in the field or do you recommend to do it by database ?? Last edit: 13 years 5 months ago by [Cattelan](/forum/user/20691-cattelan "View Cattelan's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84MzU2Ni1nb29nbGUtcHJvZHVjdC1jYXRlZ29yeS1pcy1taXNzaW5nP3N0YXJ0PTIwJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")** - [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile") - [ Offline](/forum/user/1824-eliot) Less More - Posts: 2334 - Thank you received: 403 - - 13 years 5 months ago [\#108945](#108945) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[google product category is missing](/forum/3-bug-report/83566-google-product-category-is-missing?start=20#108945 "Hallo. I uploaded manually the googlemerchantfile downloaded from the plugin. Google replyed that the google product category is missing on all products. Where can i apply the category ?? Thanks for reply")* You execute this query: Code: UPDATE #_hikashop_product as p LEFT JOIN #_hikashop_product_category as pc ON p.product_id=pc.product_id SET google_product_category="whateveryouwant" WHERE category_id="catID" 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 The following user(s) said Thank You: [Cattelan](/forum/user/20691-cattelan "View Cattelan's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84MzU2Ni1nb29nbGUtcHJvZHVjdC1jYXRlZ29yeS1pcy1taXNzaW5nP3N0YXJ0PTIwJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Cattelan](/forum/user/20691-cattelan "View Cattelan's Profile")** - [![Cattelan's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/quiet.jpg)](/forum/user/20691-cattelan "View Cattelan's Profile") - [ Offline](/forum/user/20691-cattelan) Less More - Posts: 155 - Thank you received: 4 - - 13 years 5 months ago - 13 years 5 months ago [\#108961](#108961) by [Cattelan](/forum/user/20691-cattelan "View Cattelan's Profile") Replied by *[Cattelan](/forum/user/20691-cattelan "View Cattelan's Profile")* on topic *[google product category is missing](/forum/3-bug-report/83566-google-product-category-is-missing?start=20#108961 "Hallo. I uploaded manually the googlemerchantfile downloaded from the plugin. Google replyed that the google product category is missing on all products. Where can i apply the category ?? Thanks for reply")* 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. Last edit: 13 years 5 months ago by [Cattelan](/forum/user/20691-cattelan "View Cattelan's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84MzU2Ni1nb29nbGUtcHJvZHVjdC1jYXRlZ29yeS1pcy1taXNzaW5nP3N0YXJ0PTIwJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")** - [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile") - [ Offline](/forum/user/1824-eliot) Less More - Posts: 2334 - Thank you received: 403 - - 13 years 5 months ago [\#109026](#109026) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[google product category is missing](/forum/3-bug-report/83566-google-product-category-is-missing?start=20#109026 "Hallo. I uploaded manually the googlemerchantfile downloaded from the plugin. Google replyed that the google product category is missing on all products. Where can i apply the category ?? Thanks for reply")* Glad to see you're satisfied ![:)](/media/kunena/emoticons/3.png ":)"), I hope you'll enjoy the coming features! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84MzU2Ni1nb29nbGUtcHJvZHVjdC1jYXRlZ29yeS1pcy1taXNzaW5nP3N0YXJ0PTIwJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[daurwid](/forum/user/6533-daurwid "View daurwid's Profile")** - [![daurwid's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6533-daurwid "View daurwid's Profile") - [ Offline](/forum/user/6533-daurwid) Less More - Posts: 44 - Thank you received: 1 - - 13 years 1 month ago - 13 years 1 month ago [\#125912](#125912) by [daurwid](/forum/user/6533-daurwid "View daurwid's Profile") Replied by *[daurwid](/forum/user/6533-daurwid "View daurwid's Profile")* on topic *[google product category is missing](/forum/3-bug-report/83566-google-product-category-is-missing?start=20#125912 "Hallo. I uploaded manually the googlemerchantfile downloaded from the plugin. Google replyed that the google product category is missing on all products. Where can i apply the category ?? Thanks for reply")* 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... Last edit: 13 years 1 month ago by [daurwid](/forum/user/6533-daurwid "View daurwid's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84MzU2Ni1nb29nbGUtcHJvZHVjdC1jYXRlZ29yeS1pcy1taXNzaW5nP3N0YXJ0PTIwJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Cattelan](/forum/user/20691-cattelan "View Cattelan's Profile")** - [![Cattelan's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/quiet.jpg)](/forum/user/20691-cattelan "View Cattelan's Profile") - [ Offline](/forum/user/20691-cattelan) Less More - Posts: 155 - Thank you received: 4 - - 13 years 1 month ago [\#125922](#125922) by [Cattelan](/forum/user/20691-cattelan "View Cattelan's Profile") Replied by *[Cattelan](/forum/user/20691-cattelan "View Cattelan's Profile")* on topic *[google product category is missing](/forum/3-bug-report/83566-google-product-category-is-missing?start=20#125922 "Hallo. I uploaded manually the googlemerchantfile downloaded from the plugin. Google replyed that the google product category is missing on all products. Where can i apply the category ?? Thanks for reply")* did you try the massaction feature? The following user(s) said Thank You: [Jerome](/forum/user/80-jerome "View Jerome's Profile"), [daurwid](/forum/user/6533-daurwid "View daurwid's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84MzU2Ni1nb29nbGUtcHJvZHVjdC1jYXRlZ29yeS1pcy1taXNzaW5nP3N0YXJ0PTIwJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[daurwid](/forum/user/6533-daurwid "View daurwid's Profile")** - [![daurwid's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6533-daurwid "View daurwid's Profile") - [ Offline](/forum/user/6533-daurwid) Less More - Posts: 44 - Thank you received: 1 - - 13 years 1 month ago [\#125934](#125934) by [daurwid](/forum/user/6533-daurwid "View daurwid's Profile") Replied by *[daurwid](/forum/user/6533-daurwid "View daurwid's Profile")* on topic *[google product category is missing](/forum/3-bug-report/83566-google-product-category-is-missing?start=20#125934 "Hallo. I uploaded manually the googlemerchantfile downloaded from the plugin. Google replyed that the google product category is missing on all products. Where can i apply the category ?? Thanks for reply")* 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? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84MzU2Ni1nb29nbGUtcHJvZHVjdC1jYXRlZ29yeS1pcy1taXNzaW5nP3N0YXJ0PTIwJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[daurwid](/forum/user/6533-daurwid "View daurwid's Profile")** - [![daurwid's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6533-daurwid "View daurwid's Profile") - [ Offline](/forum/user/6533-daurwid) Less More - Posts: 44 - Thank you received: 1 - - 13 years 1 month ago [\#125943](#125943) by [daurwid](/forum/user/6533-daurwid "View daurwid's Profile") Replied by *[daurwid](/forum/user/6533-daurwid "View daurwid's Profile")* on topic *[google product category is missing](/forum/3-bug-report/83566-google-product-category-is-missing?start=20#125943 "Hallo. I uploaded manually the googlemerchantfile downloaded from the plugin. Google replyed that the google product category is missing on all products. Where can i apply the category ?? Thanks for reply")* 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! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84MzU2Ni1nb29nbGUtcHJvZHVjdC1jYXRlZ29yeS1pcy1taXNzaW5nP3N0YXJ0PTIwJnRtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.081 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)