OpenCart Community

Generate Google XML Feeds for Google Merchant (formerly Google Base) - Google Shopping site.

Generate XML Sitemaps for All Major Search Engines

Use to list on Google Shopping US, UK AU DE FR NL IT ES

* Now Supports Product Variants *

* 1. Fully Compliant with Google Merchant Requirements as of 22nd September
* 2. List Single Products and Product Variants for all products including Clothing & Apparel
* 3. List up to 10 additional images per product
* 4. Display Special Prices if they exist in addition to the standard price.
* 5. Produce feeds for OpenCart Multi-Stores
* 6. List on Multiple Google Shopping Sites (provided you have the language and currency installed for those sites)
* 7. Set the Google Product Category for each Google Shopping Site globally, on a store category and on a per product basis.
* 8. Set the Condition for each product globally and on a per product basis.
* 9. Ability to overridge OpenCart Brand with a more specific brand on a per product basis.
* 10. Option to disable a product from appearing in the feed on a per product basis.
* 11. Split Feeds into multiple feeds if your store has a lot of products
* 12. Display Full Link to product including category and subcategory (optional)
* 13. Choose whether to upload prices including or excluding Tax / VAT on a per Google Site basis.
* 14. Added required attributes validation/checks in the feed settings which can be set by you.
* 15. Added Google Adwords attributes for connecting your products to your Google Adwords Ads
* 16. Big improvement on Sitemaps. Now you can submit to Multiple Search Engines and tweak the sitemap settings

Demo Feed:
Main Store: http://www.designs.org.uk/index.php?rou ... rrency=GBP

View the Source of the above links to see the full feed details

Demo Site (OC 1.5.1.2)
Site: http://1511-2.designs.org.uk/
Admin: http://1511-2.designs.org.uk/admin/

Video Tutorial: http://www.opencart-extensions.co.uk/vi ... _merchant/

* If you would like a commercial license to use this on multiple stores, please email me at info[at-sign]uksitebuilder.net *

see my signature for Link

Updated to add support for large stores with thousands of products or stores with low memory

You can now specify how many products to send in each feed.

Updated to work with older versions of OpenCart

Now works with OpenCart versions 1.4.9.x as well as 1.5.x

If you would like this feed for 1.4.8 or 1.4.7 please let me know

Big update today for this extension.

For OC 1.5.x users it now fully conforms to Google's upcoming September 22nd 2011 Product Feed Requirements for Single Items including Clothes and Apparel.

All options now editable in the Product Feeds section
Support for Multi Stores added

The update for 1.4.x users will be available in a couple of days.

How does it help for selling downloadable products and also against google sept.22 change?

Hi,

Download products should work the same way as normal products as far as I'm aware.

You will need to check Google's Product Policies for Download products, I jsut had a quick look but couldn't see that they weren't allowed.

The recent update will enable all single products to meet the upcoming Sept 22nd requirements (for OC 1.5.x currently)

Hopefully in the next few days I will have updated again for 1.4.x

Looking forward to purchasing this when you have the update finished for 1.4.9.4. as your feedback shows you have great customer service. Is there anything I'll need to keep in mind regarding my products? Many are handmade and thus don't have UPCs.

Kind Regards,
Joan
p.s. If you ever develop a Google Analytics module that supports eCommerce transactions let me know as I'm having problems with the one i purchased from someone else.

Hi Joan,

1.4.9.x version is a couple of days away at most now.

You need not worry too much regarding your handmade items.

If you already have a Google Account, you can fill out an exemption form at: http://www.google.com/support/merchants ... _exemption

A Google rep will visit your site and check you out

A few of my clients have done this and are now exempt due to their items being custom made.

I will have a look at Analytics when I have 5 minutes spare (gawd knows when that will be though lol).

1.4.9x Version has now been updated to enable all single products to meet the upcoming Sept 22nd Google requirements

Fantastic news - we'll be buying and installing this weekend hopefully

Kind Regards
Joan

Update added - Now works with OC 1.4.8 and OC 1.4.8b

Also edit the free included Google Sitemaps feed:

Removed URLs that lead to duplicate content

such as

http://www.yoursite.com/category/subcategory

which is the same as

http://www.yoursite.com/subcategory


OR

http://www.yoursite.com/category/subcategory/product1

which is the same as

http://www.yoursite.com/subcategory/product1

which is the same as

http://www.yoursite.com/product1


which is the same as

http://www.yoursite.com/manufacturer/product1

Tutorial Video has been released at http://www.opencart-extensions.co.uk/vi ... _merchant/

it's approx 25 minutes long, so grab a coffee

Updated today

Use to list on Google Shopping US, UK AU DE FR NL IT ES

* Now Supports Product Variants *

1. Fully Compliant with Google Merchant Requirements as of 22nd September
2. List Singles Products and Product Variants for all products including Clothing & Apparel
3. List up to 10 additional images per product
4. Display Special Prices if they exist in addition to the standard price.
5. Produce feeds for OpenCart Multi-Stores
6. List on Multiple Google Shopping Sites (provided you have the language and currency installed for those sites)
7. Set the Google Product Category for each Google Shopping Site globally and on a per product basis.
8. Set the Condition for each product globally and on a per product basis.
9. Ability to override OpenCart Brand with a more specific brand on a per product basis
10. Option to disable a product from appearing in the feed on a per product basis
11. Split Feeds into multiple feeds if your store has a lot of products
12. Bonus Google Image Sitemaps module for use with Google Webmaster Tools

Demo Feed:
Main Store: http://www.designs.org.uk/index.php?rou ... rrency=GBP

View the Source of the above links to see the full feed details

Demo Site (OC 1.5.1.2)
Site: http://www.designs.org.uk/
Admin: http://www.designs.org.uk/admin/
Username: demo
Password: demo

Video Tutorial: http://www.opencart-extensions.co.uk/vi ... _merchant/

* If you would like a commercial license to use this on multiple stores, please email me at info[at-sign]uksitebuilder.net *

see my signature for Link

Updated today

* Re-Added Feed Splitting for OC 1.4.x users
* Added the option of specifying a Google Product Category to a store category to override the default Google Product Category.
* Added some Required attributes checks/validation to omit products that do not meet the required attributes set in the feed settings.
* Fixed a bug where creating new products had the setting to list on Google set as 'No' by default. Now set as 'Yes' by default.
* Fixed a bug where creating new products had the setting for Condition set as 'new' by default. Now uses the condition value from the product feed settings screen.

Got the update and it's working great.

Question though - the script to clear the category from individual products...does it delete the other fields like color and size ones I added? I've been manually going thru and adding that info for days now and don't want to have to start over.

If I set a google category for a parent, will the child automatically pick it up? Like if I set "Jewelry" to the google category, will my sub categories under Jewelry know to use the google category as well? Or do I have to edit each sub category too? Hoping to save myself a little time in getting all my categories set up.

labeshops wrote:Got the update and it's working great.

Excellent

labeshops wrote: Question though - the script to clear the category from individual products...does it delete the other fields like color and size ones I added? I've been manually going thru and adding that info for days now and don't want to have to start over.

No, it just removes the Google Product Category from individual products.

In the previous version it was either the default Google Product Category set-up in the feed settings which could be overridden on a per product basis

The problem with that was the default category was displayed when you viewed a product.

As soon as you saved the product, it fixed that Google Product Category to that product too.

This wasn't a real problem until this new update where you can now override the default Google Product Category set in the feed settings on a per store category basis and on a per product basis. However the per store category is overridden by the previously saved per product Google Product Categories.

Hence the fix file to clear the per product Google Product Categories to allow the per store category Google Product Categories to work.

I can't see that many people would have applied a per product Google Product Category, but when the fix file is run it produces a list of all products that have a Google Product Category assigned to them so that if need be, they can be reassigned again. Although most people will now opt to do it on a per store category basis.

labeshops wrote: If I set a google category for a parent, will the child automatically pick it up? Like if I set "Jewelry" to the google category, will my sub categories under Jewelry know to use the google category as well? Or do I have to edit each sub category too? Hoping to save myself a little time in getting all my categories set up.

Unfortunately, because products can be assigned to multiple categories, the feed grabs the first category it encounters that has an override and uses that Google Product Category.

Each category and it's subcategories will need to be edited.

I may look at this in the future, but at present it is far better than having to edit each product at least.


Hope this helps

Just wanted to publicly thank Simon for his tireless and patient help in installing this extension.
It was the first time I had installed an extension via VQMOD and it's fair to say that I found it a steep learning curve!
I would also add that it's a great extension and does exactly what it should, well worth the price.

Updated Extension

Now supports Google Adwords Attributes to allow for connecting products to Google Adwords Ads

Also a big update on the Free included Sitemaps giving more options for them such as frequency and priority options

You are now able to submit the sitemaps to all the major search engines, Google, Yahoo & Bing etc

uksitebuilder wrote:Updated Extension

Now supports Google Adwords Attributes to allow for connecting products to Google Adwords Ads

Also a big update on the Free included Sitemaps giving more options for them such as frequency and priority options

You are now able to submit the sitemaps to all the major search engines, Google, Yahoo & Bing etc

I can't work out how to download the latest update unfortunately! The download page doesn't seem to have a new version on there?

The latest version is 3.7.0

If you go in to your admin Extensions - Product Feeds

You should see UKSB Google Merchant 3.x.x

All the downloads on the extension page are 3.7.0