Automatically send data feed to Froogle

[Jack_mcs]

Are you using the latest version here?

[♥Smoky Barnable]

On 4/28/2023 at 2:02 PM, Jack_mcs said:

Are you using the latest version here?

I have the cron working now. The problem was the chdir('../') in googlefeeder.php which moves up one directory wasn't functioning as intended in the shell environment. I replaced with chdir('public_html') in my cron file. Since I use SEO urls the tep_href_link was using the function in the admin directory, which is why the urls were not correct.

[PupStar]

Hi Jack,

I know that FTP upload has gone but when I upload a feed manually I get the error 'Delimiter detection failed'

I am wondering if something else has changed on the merchant center as well.

Have you come across this at all?

[Jack_mcs]

2 hours ago, PupStar said:

I know that FTP upload has gone

Not until the fall.

 

2 hours ago, PupStar said:

'Delimiter detection failed'

It means the number of column headers don't match the number of entries in the row(s). You can look at the example they give for an error to see if it is just particular rows or if it is the whole feed.  That can happen if you have edited the file to use special fields or attributes that are not present. It can be difficult to troubleshoot because google doesn't provide too many details about where the problem is.

[PupStar]

19 minutes ago, Jack_mcs said:

Not until the fall.

 

It means the number of column headers don't match the number of entries in the row(s). You can look at the example they give for an error to see if it is just particular rows or if it is the whole feed.  That can happen if you have edited the file to use special fields or attributes that are not present. It can be difficult to troubleshoot because google doesn't provide too many details about where the problem is.

I think google are playing silly beggers again as I uploaded a test feed this morning with the exact same file that was the problem and now processed to live and all products have been accepted (a few minor exceptions that I need to work on)

[PupStar]

1 hour ago, PupStar said:

I think google are playing silly beggers again as I uploaded a test feed this morning with the exact same file that was the problem and now processed to live and all products have been accepted (a few minor exceptions that I need to work on)

Ok so working on a different store using the same feeder and now get the errors in the attached screenshot.

I cannot see anywhere to set a region id and I do not know why this error 'Unsupported currency in attribute: price' happens as the currency column contains GBP for all products.

 

[Jack_mcs]

1 hour ago, PupStar said:

I cannot see anywhere to set a region id and I do not know why this error

That refers to shipping. If you have the shipping option enabled in the feed, the code uses the OPTIONS_SHIPPING_STRING setting. You have to edit that to match your location. If you don't have the shipping option enabled, you need to set up the shipping options in your account. See this page for more details.

 

1 hour ago, PupStar said:

'Unsupported currency in attribute: price' happens as the currency column contains GBP for all products.

That could be due to the same reason as above since the shipping option has the US in it or you don't have the setting enabled in the account. It can also be to how the currency is formatted in the feed. See here.

[PupStar]

1 hour ago, Jack_mcs said:

That refers to shipping. If you have the shipping option enabled in the feed, the code uses the OPTIONS_SHIPPING_STRING setting. You have to edit that to match your location. If you don't have the shipping option enabled, you need to set up the shipping options in your account. See this page for more details.

 

That could be due to the same reason as above since the shipping option has the US in it or you don't have the setting enabled in the account. It can also be to how the currency is formatted in the feed. See here.

I tried it with shipping on and off with no change in errors

[Jack_mcs]

19 hours ago, PupStar said:

I tried it with shipping on and off with no change in errors

Just to be clear, it is the OPTIONS_ENABLED_SHIPPING setting that needs to be turned off. And, in that case, you have to set the shipping options in your merchant account.

[PupStar]

4 hours ago, Jack_mcs said:

Just to be clear, it is the OPTIONS_ENABLED_SHIPPING setting that needs to be turned off. And, in that case, you have to set the shipping options in your merchant account.

Thanks Jack, I have all products uploaded now and pending initial review

[Mort-lemur]

@Jack_mcs Hi Jack,

Just had the following reminder from google:

Quote

As a reminder, from 15 Sept 2023, the sharing of files with Merchant Center via FTP (File Transfer Protocol) will no longer be supported. Other upload methods like SFTP (Secure File Transfer Protocol) will still be available and unaffected by this change.

Is there any update to googlefeeder on the horizon?

Many Thanks

[Jack_mcs]

On 9/18/2023 at 12:22 PM, Mort-lemur said:

Is there any update to googlefeeder on the horizon?

The way I first coded it worked for my client but it turned out to not work reliably in general because it required some non-standard php extensions to be enabled. So I started with a more general approach and haven't had time to get back to it. I will post here when I have a solution.