[OLD] Google Merchant module Version 1.12.0 by Numinix

[honeypot]

I need to remove the attributes from the title tag as my title tags are becoming too long (over 70 characters). For example if you add an EAN attribute to a product the it also adds the EAN to the end of your title which is not needed.

I think I have found the line that does this, it is line 320 as below:

$variants_title .= ' ' . $google_base->google_base_xml_sanitizer($options->fields['products_options_values_name']);

If I delete the line then it removes the attributes from the title and just keeps the title on its own. However, how would I be able to adjust this line so instead of listing all the attributes it just lists the color attribute only. Any help?

[dwkettle]

I just upgraded to 1.12.4 and when I create the file there are no records:
Google Merchant Center File Complete In 0.010194 Seconds 0 of 0 Records
I can't seem to find anyone else that has had this problem. I have double checked for all of the uploaded files.
Any advice?

Same problem. Uninstalled. Reinstalled. Still nothing. Is one of the parameters set wrong therefore making the feed unable to pull information from my database?

[datasmog]

I have just installed 1.12.4 and it all seems to work fine.
However Google has recently changed the feed limit on newly registered product feeds to a maximum of 500 items. This is for feeds registered after 22/11.
I have been submitting feeds under the same xml file name for a number of years.
But this new module is inserting _en at the end of the file name, and in order to upload it from within the module I had to register a new data feed.
Resulting in the 500 item restriction.
Is there any way to stop the module from inserting _en into the feed name?
I just want frooglefeed_products.xml, not frooglefeed_products_en.xml

[thefather]

I have just installed 1.12.4 and it all seems to work fine.
However Google has recently changed the feed limit on newly registered product feeds to a maximum of 500 items. This is for feeds registered after 22/11.
I have been submitting feeds under the same xml file name for a number of years.
But this new module is inserting _en at the end of the file name, and in order to upload it from within the module I had to register a new data feed.
Resulting in the 500 item restriction.
Is there any way to stop the module from inserting _en into the feed name?
I just want frooglefeed_products.xml, not frooglefeed_products_en.xml

On line 72 of googlefroogle.php change that line to:

    $outfile = DIR_FS_CATALOG . GOOGLE_PRODUCTS_DIRECTORY . GOOGLE_PRODUCTS_OUTPUT_FILENAME . "_" . $type ; 

[thefather]

I think I have found away of removing the read-only attribute intefering with the GMCF. Around line 288 in googlefroogle.php you need to delete

$attributes = $db->Execute("SELECT products_attributes_id FROM " . TABLE_PRODUCTS_ATTRIBUTES . " WHERE attributes_display_only = 1 AND products_id = " . $products->fields['products_id'] . " ORDER BY products_attributes_id ASC;");

By removing this it does not seem to intefere with the rest of the feed and now I do not need to have two colour attributes I can use the one for the customer as the same for my product feed.

I have tried removing this to solve my problem I am having but have had no luck. I even tried changing this part WHERE attributes_display_only = 1 to WHERE attributes_display_only = 0 but nothing changes in my feed.

Currently my feed picks up the size attribute but only adds 1 size when in fact there are quite a few sizes for each product.
So therefore if I search google for my product with out the size that is inserted in the feed I cannot find it but if I search google for my product with the size that is listed in the feed I can find it just fine.

I have thousands of products all with lots and lots of attributes. There has to be an easier way to get the feed to pick up all the sizes, colors, etc that are defined in the database.

Any clues?

[honeypot]

I have tried removing this to solve my problem I am having but have had no luck. I even tried changing this part WHERE attributes_display_only = 1 to WHERE attributes_display_only = 0 but nothing changes in my feed.

Currently my feed picks up the size attribute but only adds 1 size when in fact there are quite a few sizes for each product.
So therefore if I search google for my product with out the size that is inserted in the feed I cannot find it but if I search google for my product with the size that is listed in the feed I can find it just fine.

I have thousands of products all with lots and lots of attributes. There has to be an easier way to get the feed to pick up all the sizes, colors, etc that are defined in the database.

Any clues?

Have you tried installing the stock by attributes download. Once you install that you can assign quantities to different combinations of attributes and each combination is picked up by the GMCF and will then be searchable for google product search.

If you have a read only attribute it messes things up because even though you have different colours or sizes or any other attribute under the GMCF it keeps coming up as the read only attribute. So that is when you need to delete the line above that I mentioned. That will stop the read only attribute from intefering with the other attributes in the feed.

[honeypot]

Can anyone help with my issue?

[honeypot]

Same problem. Uninstalled. Reinstalled. Still nothing. Is one of the parameters set wrong therefore making the feed unable to pull information from my database?

Have you tried with debug set to true? What does it say?

[datasmog]

On line 72 of googlefroogle.php change that line to:

    $outfile = DIR_FS_CATALOG . GOOGLE_PRODUCTS_DIRECTORY . GOOGLE_PRODUCTS_OUTPUT_FILENAME . "_" . $type ; 

Perfect, thank you.

[dwkettle]

Have you tried with debug set to true? What does it say?

I've set it to debug, but how do I get the results?

Also, I've unistalled and reinstalled. When i run unistall.sql, does that remove all the sql patches?
I ask because even if I run uninstall.sql, I am unable to install.sql without it telling me it is a duplicate entry. In configuration, many of the settings are not showing up anymore.