[PAID] Google Merchant Static Feed

Modules, Add-ons and custom code that's more than just a quick hack or Mod.
Martin
Site Admin
Site Admin
Posts: 1854
Joined: Wed Jun 17, 2009 6:30 pm
Location: South Yorkshire UK
Contact:

Re: [PAID] Google Merchant Static Feed

Post by Martin »

Finally got to this, this evening and oh fluppin' heck what a mess of rules & regs this is.

Net result is that some of the "clever" functionality built in to the feed is going to have to be loosened in favour of end-users being more aware of the rules and ensuring that they apply the correct information to their listings or risk getting stung.

Changelog:
  • Additional_image_link has been added with urls to any extra images (to a max of 10) being included for that product
  • Custom items that do not have any identifier information can be expressly included in the feed by adding a product custom field of "MPN" with the value "CUSTOM".
    Note: It is imperative that the value is in capitals with no spaces, etc...
  • Taxonomies for all languages/countries have been replaced (Not updated) so see below.
  • New Add-on setting to determine if you want to use LIVE shipping modules (ie: those not marked as flat_rate)

Taxonomy replacement...
I fought this for months, trying to find a way to update existing taxonomies but it resulted in a year long delay, a lot of grey hair and considerable cussing of the stupidity of Google for writing their taxonomy in such a hamfisted, stupid way.

I finally decided that with this update to just toss the idea and instead replace all taxonomies with the latest versions produced in May this year.

This means the following:
  1. You'll need to wipe all your existing taxonomies from the database along with all associations you've applied to your categories
    See below
  2. You'll then have to
    • Re-apply the Product Comparison add-ons to load the the new versions
    • Re-associate all your categories with the new category
It's by no means ideal but frankly it was that or just abandon the whole thing completely...

Live Shipping quotes on/off Changes
ISC has a system where shipping modules can be flagged as _flatrate or not. Flat rate modules are basically those where your store admin will have setup basic values for shipping based on cost, weight, etc... Others such as FedEx use an API which gets a live shipping quote from the fedex servers.

Previously the use of live quote shipping services was causing a massive headache for some users with the feed frequently timing out and a lot of load being placed on the various API services. Fedex in the UK appear to have blocked such heavy quote loads so it's actually a good idea to use this new option to stop this from being a problem.

Course of Action:
If you're using flatrate shipping modules and nothing else you needn't do anything. You can confirm by opening your shipping module code file (eg: /modules/shipping/[service]/module.[service].php) and looking for a line with $this->_flatrate. If it's not there the module would not be queried if you chose the option NOT to use live shipping rates.

Note: Some shipping modules are not indicated as flatrate when they really are (eg: RoyalMail) so you can add this line in as follows if you wish to use it as such.

Open the module.[mod_name].php file

Find:

Code: Select all

parent::__construct();
After, Add:

Code: Select all

			// Provide Google Product feed quotes
			$this->_flatrate = true;

Assuming you disable live shipping quote information you will want to look at either ensuring a flat rate module is providing shipping quotes or setting up your Google merchant Tax & Delivery options (ref: https://support.google.com/merchants/an ... 2?hl=en-GB)
This reference ( https://support.google.com/checkout/sel ... 9?hl=en-GB ) is the best I've found so far that explains how to actually do things... Google docs are just flippin' awful!!

NOTE: I will NOT provide support for Google Merchant account settings.. It's up to you to read, research and learn.



I'm updating the code but it's taking longer than expected due to the code needed to wipe the old associations and taxonomy out of the system without fubar'ing everything... That, and some delimiter issues with Googles taxonomy.

It's in hand though... Should be available by end of Monday.
Martin
Site Admin
Site Admin
Posts: 1854
Joined: Wed Jun 17, 2009 6:30 pm
Location: South Yorkshire UK
Contact:

Re: [PAID] Google Merchant Static Feed

Post by Martin »

Found a few bugs in the code that were causing some problems with images...

These have been fixed and included in release 1.5.6.

Existing customers for the Google feed should be able to login and download the 1.5.3 and 1.5.6 releases from http://www.snailsolutions.co.uk as before. I've set the limit to allow downloads from up to 18 months after placing the order so that should cover everyone who was within their contract and waiting for the taxonomy update.

The 1.5.6 update will need a password to extract is so you will need to contact me anyway, just so I can be sure you understand a few key requirements and that this now brings my support for the module to a close.
glasses123
Posts: 1
Joined: Fri Nov 22, 2013 8:58 pm

Re: [PAID] Google Merchant Static Feed

Post by glasses123 »

Hi

Had major issues recently with my shopping feed firstly had to alter the watermarks on 12,000 images and now when I upload its being disapproved for not having google product category, my website developer organised this plug in for me and is uncontactable and wondered if you could help? thanks
Martin
Site Admin
Site Admin
Posts: 1854
Joined: Wed Jun 17, 2009 6:30 pm
Location: South Yorkshire UK
Contact:

Re: [PAID] Google Merchant Static Feed

Post by Martin »

glasses123 wrote:Had major issues recently with my shopping feed firstly had to alter the watermarks on 12,000 images and now when I upload its being disapproved for not having google product category, my website developer organised this plug in for me and is uncontactable and wondered if you could help? thanks
Been away from the forum for a while to stay focused on primary business and family so only just seen this.

Short version is that your shopping cart is either out of date or your developer didn't do their job properly in telling you how to set the thing up. To be of more help, I'd need to know which version you have, or to be honest, have access to your sites FTP and/or store AdminCP so I could check how things had been setup (or not).

PM me with your developers details and any other information about your site and I'll see what I can do.
Angers
Posts: 1
Joined: Thu Jul 20, 2017 10:34 am

Re: [PAID] Google Merchant Static Feed

Post by Angers »

glasses123 wrote:Hi

Had major issues recently with my shopping feed firstly had to alter the watermarks on 12,000 and now when I upload its being disapproved for not having google product category, my website developer organised this plug in for me and is uncontactable and wondered if you could help? thanks
I know how you feel about the watermarks. Same thing for me.
Post Reply