Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Automatically send data feed to Froogle


gottaloveit

Recommended Posts

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.

The water in a vessel is sparkling; the water in the sea is dark. The small truth has words which are clear; the great truth has great silence.

- Rabindranath Tagore

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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.

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

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)

Link to comment
Share on other sites

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.

 

merchant_center_screenshot.png

Link to comment
Share on other sites

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.

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • 4 months later...

@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

Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members.

Link to comment
Share on other sites

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.

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...