Forums / All Other Contributions/Addons / [OLD] Google Merchant module Version 1.12.0 by Numinix

[OLD] Google Merchant module Version 1.12.0 by Numinix

Locked

Started by pinkleopard on 20 Oct 2011, 1:25 AM · Views: 113,658

Results 241 to 260 of 567
This thread is locked. New replies are disabled.
28 Nov 2011, 12:59 AM
#241
rescoccc avatar

rescoccc

Totally Zenned

Join Date:
May 2010
Location:
WA State
Posts:
1,700
Plugin Contributions:
2

[OLD] Google Merchant module Version 1.12.0 by Numinix

Setting up a cron job is explained in the readme doc that comes with the mod.

The best way to learn is to try stuff. But, back it up first.

28 Nov 2011, 4:35 PM
#242
honeypot avatar

honeypot

New Zenner

Join Date:
Jan 2007
Posts:
55
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

Hi,
I am really stuck. Currently, my products have been banned by Google for not having barcodes.

I have installed Zen-Cart 1.38a.
GMCF version 1.12.5.
SBA 1.4.13
Numinex Product fields 1.2.0
Flexible attributes for the version of Zen-Cart 1.38a

All are installed correctly and all work independently of each other. I am able to put barcodes for those products which do not have attributes and that works fine. However, when I need to use the color attribute for certain products, they have independent barcodes.

I cannot seem to work out how to marry the color with the barcode and allow it to be found in the GMCF correctly. Nothing seems to work or if it does work it does not work correctly. I can check the GMCF source code so I know if it is working or not. To add barcodes to attibutes seems to be overly complicated with to many add-ons being needed to work together. :frusty:

29 Nov 2011, 1:30 AM
#243
honeypot avatar

honeypot

New Zenner

Join Date:
Jan 2007
Posts:
55
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

Hi,
I figured it out as below:

I changed the name of my original option name 'colour' to 'choose colour' so that it did not intefere with the GMCF.

Under the option name I added 2 more read-only options (color & EAN as they were what I needed)

I then assigned a couple of option values to them to test.

From the attribute controller I picked one product that already had a 'choose colour' attribute to test (say for example Red, Green & Blue)

I then added the option name 'color' with the option values that were exactly the same (i.e. Red, Green & Blue)

I then added the option name 'EAN' with option values of the barcodes of these specific colours.

I then went to the SBA menu products with attribute stocks and found the specific product that I made changes to the attributes.

I added quantities to the specific attribute that I wanted so for the 3 attributes I am using (choose colour, color, EAN) this would be Red, Red & EAN for Red and then Green, Green & EAN for Green, etc.

I then did a GMCF test and viewed the source file to make sure the color & EAN fields were there for the specific product (which they were).

The problem now is the customer can see the additional read-only fields on the product listing. So on the flexible attributes add-on style sheet I added the following:

#wAttrib-11 {display: none;}
#wAttrib-12 {display: none;}

The number 11 coressponds to the color option name id and the number 12 the EAN. So now the customer only sees the 'choose colour' option name with the values.

This is the only way I could have a google feed that would carry a colour attribute with a specific barcode.

I had to create two colour option names because in the 'choose colour' option name as I have a read only value of 'choose below' which inteferes with the GMCF so by changing the option name to 'choose colour' it does not intefere with the GMCF leaving the 'color' option name to do the GMCF work.

I think a simpler system should eventually manifest itself. Does anyone know how to simplify it? As I have to do this to 400+ products.:huh:

29 Nov 2011, 1:41 AM
#244
honeypot avatar

honeypot

New Zenner

Join Date:
Jan 2007
Posts:
55
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

Does Anyone know how to remove the attributes from the title tag as my title tags are becoming too long. 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.

29 Nov 2011, 10:27 AM
#245
beep avatar

beep

New Zenner

Join Date:
Nov 2008
Location:
London
Posts:
94
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

davewest:

Not to hard to do, I've set it up on my site due to running auctions. Been some time back so I'll have to pick out the code changes to explain it better, but basically...

Add a field to your product table for 'condition'.
Add some code to the product pages in admin to collect the info and store it.
Change the code in base to get the info from the product table instead of the default 'NEW'..

What's nice, once you go through this process you can use it in your product display too.

Hello.
Does anyone know the code to impliment this?
I too have a mixture of used, refurbished and new products and withoutthis option it appears like I am trying to hoodwink customer as all items are listed as either all new or all used.
Would love to use this option so if anyone know a way I'd be so greatful.
:dontgetit

29 Nov 2011, 4:30 PM
#246
lindsey80 avatar

lindsey80

New Zenner

Join Date:
Apr 2010
Location:
Essex, UK
Posts:
77
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

Hi

Is there an easier way to view & edit the feed does anyone know. I've opened it in excel, but it won't let me save any changes?

Thanks

30 Nov 2011, 12:45 AM
#247
honeypot avatar

honeypot

New Zenner

Join Date:
Jan 2007
Posts:
55
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

beep:

Hello.
Does anyone know the code to impliment this?
I too have a mixture of used, refurbished and new products and withoutthis option it appears like I am trying to hoodwink customer as all items are listed as either all new or all used.
Would love to use this option so if anyone know a way I'd be so greatful.
:dontgetit
Hi, I think if you install Numinex Product fields there is an entry for in the product field for condition. So for each product you can say if the product is new or used. You will need to turn off the default condition on your GMCF configuration menu.

30 Nov 2011, 12:52 AM
#248
honeypot avatar

honeypot

New Zenner

Join Date:
Jan 2007
Posts:
55
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

lindsey80:

Hi

Is there an easier way to view & edit the feed does anyone know. I've opened it in excel, but it won't let me save any changes?

Thanks
Hi, Is it something specific you want to view or edit as the main reason for the add-on I guess is to make things all automated. In theory you could make changes to the actual feed file after you have processed it. I think by default you should be able to find it at feed/google. However, if you process the feed again it would replace the changes you have made.

30 Nov 2011, 12:55 PM
#249
honeypot avatar

honeypot

New Zenner

Join Date:
Jan 2007
Posts:
55
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

Hi, I need help for the following:

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 need to remove the read only attributes being included as this is messing up my GMCF

I know the answer to these questions lies somewhere in googlefroogle.php but I do not know where. Anyone can help?

30 Nov 2011, 3:08 PM
#250
honeypot avatar

honeypot

New Zenner

Join Date:
Jan 2007
Posts:
55
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

honeypot:

Hi, I need help for the following:

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 need to remove the read only attributes being included as this is messing up my GMCF

I know the answer to these questions lies somewhere in googlefroogle.php but I do not know where. Anyone can help?

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.

so now if I can only get help for the following:
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.

30 Nov 2011, 4:29 PM
#251
honeypot avatar

honeypot

New Zenner

Join Date:
Jan 2007
Posts:
55
Plugin Contributions:
0

Re: [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?

30 Nov 2011, 8:00 PM
#252
dwkettle avatar

dwkettle

New Zenner

Join Date:
Apr 2011
Location:
Saginaw, MI
Posts:
13
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

helpme:

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?

Dan Kettler
http://spartanpools.com
"Not Penny's Boat!"

1 Dec 2011, 4:16 PM
#253
datasmog avatar

datasmog

New Zenner

Join Date:
Mar 2010
Posts:
2
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

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

1 Dec 2011, 7:41 PM
#254
thefather avatar

thefather

New Zenner

Join Date:
Nov 2010
Posts:
21
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

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

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

    $outfile = DIR_FS_CATALOG . GOOGLE_PRODUCTS_DIRECTORY . GOOGLE_PRODUCTS_OUTPUT_FILENAME . "_" . $type ;
1 Dec 2011, 7:50 PM
#255
thefather avatar

thefather

New Zenner

Join Date:
Nov 2010
Posts:
21
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

honeypot:

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?

2 Dec 2011, 12:54 AM
#256
honeypot avatar

honeypot

New Zenner

Join Date:
Jan 2007
Posts:
55
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

thefather:

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.

2 Dec 2011, 12:56 AM
#257
honeypot avatar

honeypot

New Zenner

Join Date:
Jan 2007
Posts:
55
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

Can anyone help with my issue?

2 Dec 2011, 12:59 AM
#258
honeypot avatar

honeypot

New Zenner

Join Date:
Jan 2007
Posts:
55
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

dwkettle:

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?

2 Dec 2011, 8:52 AM
#259
datasmog avatar

datasmog

New Zenner

Join Date:
Mar 2010
Posts:
2
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

thefather:

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.
2 Dec 2011, 3:08 PM
#260
dwkettle avatar

dwkettle

New Zenner

Join Date:
Apr 2011
Location:
Saginaw, MI
Posts:
13
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

honeypot:

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.

Dan Kettler
http://spartanpools.com
"Not Penny's Boat!"