Automatically send data feed to Froogle

[Papanco]

19 hours ago, Jack_mcs said:

@PapancoIn the googlefeeder.php file, change the OPTIONS_ENABLED_GOOGLE_UTM setting  to 0 or 1, depending on if you are using that google option.. Then find this line

define('OPTIONS_GOOGLE_UTM', '?utm_source=GoogleBase1&utm_medium=BaseFeed1&utm_campaign=products'); //see http://www.google.com/support/googleanalytics/bin/answer.py?hl=en&answer=55578

and replace it with this

if (OPTIONS_ENABLED_GOOGLE_UTM == 0) {
   define('OPTIONS_GOOGLE_UTM', '?store={my_store_code}'); 
} else {
   define('OPTIONS_GOOGLE_UTM', '?store={my_store_code}&utm_source=GoogleBase1&utm_medium=BaseFeed1&utm_campaign=products'); //see http://www.google.com/support/googleanalytics/bin/answer.py?hl=en&answer=55578
}

As before, be sure to change the "my_store_cde" with yours.

@Jack_mcs thanks for the support: I did a test but with UTM == 0 the store code is not inserted in the URL. If I enable UTM on 1, the UTM URL is correctly entered but the store code is not inserted in the URL. what else can i try?

[Jack_mcs]

@PapancoAs mentioned, this is untested so I must be missing something. I will actually test it here and post once I have it working. I will try to get to it this week.

[Jack_mcs]

A new version has been uploaded with these changes:

• Added a localfeed option.
• Corrected code for php warnings.

[Psytanium]

Hello,

The csv file i get doesn't have a header, i mean the columns titles in the first row, for example : Title, Link, Brand, etc.... is it possible to add it ?

Thanks

[Jack_mcs]

@PsytaniumI can't reproduce that and no one else has mentioned it. You don't mention your php version though if that was the problem, there would be other problems. So I don't know what that might be. Maybe if you are trying to use one of the options. Try selecting Complete from the dropdown menu. If that works then you will need to let me know what option it is failing on.

[Psytanium]

Just now, Jack_mcs said:

@PsytaniumI can't reproduce that and no one else has mentioned it. You don't mention your php version though if that was the problem, there would be other problems. So I don't know what that might be. Maybe if you are trying to use one of the options. Try selecting Complete from the dropdown menu. If that works then you will need to let me know what option it is failing on.

When i run googlefeeder.php, 2 files are placed in feed directory, the txt file have headers, while the csv file don't.

Sorry for the poor explanation, OCS2.3.4

I'm trying to include the txt file in Facebook feed.

[Jack_mcs]

53 minutes ago, Psytanium said:

the txt file have headers, while the csv file don't.

The csv file is not meant to be used. It is included to give a quick look at the view in admin because most computers are not setup to load .txt files as a spreadsheet. This is what it says on the page when the script is ran:

Quote

It is still in development and not meant for anything other than viewing.

 

[PupStar]

@Jack_mcs

Hi Jack,

I hope you are well.

I am running the feeder on Phoenix Version 1.0.8.12 and it works great.

I have however found that the image is pulled from the first image in the gallery and not the actual main image.

I have checked the feed file on 1 particular product and it shows the correct image name but the image being uploaded to google is different

Just wondering if you have come across this and could offer any resolve?

Thanks

Edited May 27, 2022 by PupStar

[Jack_mcs]

@PupStarNo, I haven't noticed that before. the code loads in the images from the images table but just cycles through them to add them. So if the main image doesn't match the first image, which is possible, then it would probably be wrong. You could try turning of the Products Images option (right column). That will prevent the images table from being checked. I don't recall if the main image is used instead but if it is then you that should work.

[PupStar]

27 minutes ago, Jack_mcs said:

@PupStarNo, I haven't noticed that before. the code loads in the images from the images table but just cycles through them to add them. So if the main image doesn't match the first image, which is possible, then it would probably be wrong. You could try turning of the Products Images option (right column). That will prevent the images table from being checked. I don't recall if the main image is used instead but if it is then you that should work.

@Jack_mcs I have tried to set

define('OPTIONS_USE_IMAGE_TABLE', '0'); //set to 1 to use the products_images table, which is only available in 2.3 shops

to 0 and 1 with no change in result.

I have noticed that if the product has only 1 image then it does pick the main image correctly.

[Jack_mcs]

That's not the change I mentioned. There are options in the right column.

[PupStar]

14 hours ago, Jack_mcs said:

That's not the change I mentioned. There are options in the right column.

@Jack_mcs ok right column, what am I missing

 

[Jack_mcs]

1 hour ago, PupStar said:

ok right column, what am I missing

LOL. You aren't missing anything. I'm referring to a different addon.  I'm terribly sorry for the confusion.

Starting over with the actual problem, you said

23 hours ago, PupStar said:

I have checked the feed file on 1 particular product and it shows the correct image name but the image being uploaded to google is different

I don't understand what you mean by this. Images are not uploaded to google. The feed is sent to them and, I think, you are saying the feed has the correct link. Is that not the case?

[PupStar]

20 hours ago, Jack_mcs said:

LOL. You aren't missing anything. I'm referring to a different addon.  I'm terribly sorry for the confusion.

Starting over with the actual problem, you said

I don't understand what you mean by this. Images are not uploaded to google. The feed is sent to them and, I think, you are saying the feed has the correct link. Is that not the case?

Hi @Jack_mcs

I don't understand what has happened either. I have deleted the feed and attempted to start again.

Now when I upload a test feed I get the following errors

Invalid or missing required attribute: price
The price column is in the feed and this particular product is 12.95 but google says all 49 products having the price missing

Unsupported currency in attribute: price
The currency column is there set to GBP

Invalid format for sub-attributes: shipping
No idea what this error needs to resolve it
 

Quote

https://mysite.co.uk/product_info.php?products_id=10  Col Clear A, Colon Health Support Herbal Colonics Complex    COL-Clear is a well-known herbal colon cleanser and bowel support combination, based on a formula by master herbalist, Dr. John R. Christopher. It is available in 2 versions - this COL-Clear A and COL-Clear B.  Popular with colonic hydrotherapists, COL-Clear A contains a range of active herbal ingredients specifically selected to contribute to an increase in faecal bulk and normal bowel function.  The sugar beet fibre in this formula, in particular, contributes to an increase in faecal bulk in two ways: the insoluble components of the fibre increase faecal bulk by absorbing water in the large intestine, while the soluble components are fermented by bacteria in the large intestine leading to an increase in bacterial mass.  As such, this source of fibre may have a beneficial physiological effect for people who want to improve or maintain normal bowel function.  The ingredients help to cleanse the intestinal tract, soften the stool, stimulate the liver and improve peristalsis. This, in turn, helps to produce bowel movements and expel layers of old encrusted mucus and faecal matter that may have accumulated over time.  They also act to gently cleanse, stimulate and tone the bowel wall, supporting a move towards unassisted bowel movements.   # Approved EFSA health claims:  Sugar beet fibre contributes to an increase in faecal bulk.    12.95   https://mysite.co.uk/images/COL-Clear-A.png  10    in stock    Big Brand Name   New    GBP    05060200681015        052L-00    Cleanse & Detox    2.95

Mind totally blown trying to resolve this so any help would be appreciated.

 

 

 

 

[PupStar]

36 minutes ago, PupStar said:

Hi @Jack_mcs

I don't understand what has happened either. I have deleted the feed and attempted to start again.

Now when I upload a test feed I get the following errors

Invalid or missing required attribute: price
The price column is in the feed and this particular product is 12.95 but google says all 49 products having the price missing

Unsupported currency in attribute: price
The currency column is there set to GBP

Invalid format for sub-attributes: shipping
No idea what this error needs to resolve it
 

Mind totally blown trying to resolve this so any help would be appreciated.

 

 

 

 

@Jack_mcs

After a bit of googling I have managed to resolve all the errors.

Invalid or missing required attribute: price
The price column is in the feed and this particular product is 12.95 but google says all 49 products having the price missing - presuming this had something to do with the currency not being set correctly in the merchant center

Unsupported currency in attribute: price
The currency column is there set to GBP - This was resolved by setting the currency in the merchant center and nothing to do with the feed file

Invalid format for sub-attributes: shipping
No idea what this error needs to resolve it - Changed the setting to 0 in the feed file as the shipping amount is set in the merchant center.

 

[Jack_mcs]

The failures reported by google are not always exact or clear. Sometimes they are just in the general area of the problem. Regarding the price, make sure you have the currency setting in the feed set to GBP and that the price on the shop defaults to GBP.  If that doesn't help you can post in googles community forum. They are pretty good at providing answers for feed failures. 

[PupStar]

21 minutes ago, Jack_mcs said:

The failures reported by google are not always exact or clear. Sometimes they are just in the general area of the problem. Regarding the price, make sure you have the currency setting in the feed set to GBP and that the price on the shop defaults to GBP.  If that doesn't help you can post in googles community forum. They are pretty good at providing answers for feed failures. 

@Jack_mcs Thank you for your patience Jack.

[Mort-lemur]

Hi Jack,

Looks like Google are making changes to how files are transferred, I received the following today:

Quote

Starting on 2023-09-15, you'll no longer be able to share files with Merchant Center via FTP (File Transfer Protocol). Other upload methods like SFTP (Secure File Transfer Protocol) will still be available and unaffected by this change.

What changes would be needed to the Google feeder files so that they will still work (Site is running on 2.3.4)

Many Thanks

[Jack_mcs]

2 hours ago, Mort-lemur said:

What changes would be needed to the Google feeder files so that they will still work

It isn't a quick change. I will provide an update before that time.

[♥Smoky Barnable]

Might be best to switch to API now.

https://developers.google.com/shopping-content/guides/quickstart

[♥Smoky Barnable]

In the meantime, since Google will be deleting all FTP upload accounts this September, wouldn't it be possible to use scheduled fetches instead?

https://support.google.com/merchants/answer/1219255

Just setup a cron job that doesn't upload via FTP and have Google fetch the file from the feeds folder at the frequency of your choosing. Seems like it should work fine but maybe I'm missing something.

[Jack_mcs]

5 hours ago, Smoky Barnable said:

Google will be deleting all FTP upload accounts

I'm not aware of them doing this. Can you provide a link so I can take a look?

[♥Smoky Barnable]

20 hours ago, Jack_mcs said:

I'm not aware of them doing this. Can you provide a link so I can take a look?

https://support.google.com/merchants/answer/13033917

[Jack_mcs]

@Smoky Barnable I misread what you mentioned. Yes, they are stopping but sftp is still allowed. Re-reading your post I see my mistake.

[♥Smoky Barnable]

Currently working fine in the browser but the cron job results in "Failed to open stream: No such file or directory". The only way I can get the cron job working is by changing chdir('../'); to chdir('public_html/admin'); in googlefeeder.php. This breaks the script however and the product urls are not accurate. Tried changing directory in the cron command itself but no luck. cd /home/xxxx/public_html/admin/ && /usr/local/bin/php googlefeedercron.php