Jump to content

  2. → Viewing Profile: thewrath1

Corporate Sponsors


Latest News: (loading..)

thewrath1

Member Since 26 Mar 2005
Offline Last Active Oct 05 2011, 16:53
-----

Posts I've Made

In Topic: Automatically send data feed to Froogle

05 October 2011, 16:53

Thanks Jack.

Also. just for others that may be curious, the fix I just uploaded works fine with my UK OSC Store, with the new availability requirement fixing all issues Google required.
All products have been "Green Ticked" by Google and are displaying fine now. (10,000+).

Cheers all.

In Topic: Automatically send data feed to Froogle

05 October 2011, 11:16

Temporary Google Fix for Googlefeeder is in the contributions section here;
http://addons.oscommerce.com/info/4513

In Topic: Automatically send data feed to Froogle

05 October 2011, 11:04

Jack,

I have uploaded a stop-gap altered version in the contribution, for people suffering Google's new spec for availability.

I hope you don't mind, and look forward to your next proper release in a month or so. [img]http://forums.oscommerce.com//public/style_emoticons/default/happy.png[/img]

Hopefully, this will temporarily help others till then and also cut you some slack at the same time.

Regards thewrath1 [img]http://forums.oscommerce.com//public/style_emoticons/default/thumbsup.gif[/img]

In Topic: Automatically send data feed to Froogle

22 May 2011, 13:20

UK Store Feeds who need the VAT to be Correct in Google Feeds -



FIND

/*************** BEGIN MASTER SETTINGS ******************/

REPLACE WITH

/*************** BEGIN MASTER SETTINGS ******************/
$taxRate = 20.0; //default = 0 (e.g. for 20.0% tax use "$taxRate = 20.0;")
$taxCalc = ($taxRate/100) + 1; //Do not edit

FIND

FORMAT( IFNULL(specials.specials_new_products_price, products.products_price), 2) AS price,

REPLACE WITH

FORMAT( IFNULL(specials.specials_new_products_price, products.products_price) * " . $taxCalc . ",2) AS price,

MAKE SURE THIS IS SET TO 0 and not 1
define('OPTIONS_ENABLED_INCLUDE_TAX', 0);

Done. Simples. ;-)

In Topic: Automatically send data feed to Froogle

22 May 2011, 12:35

If you need BRAND and MANUFACTURER for a UK Store Feed... heres the simple workaround to make Jacs file work.
For UK Store Owners.

in googlefeeder.php


//FIND
define('OPTIONS_ENABLED_BRAND', 0);

//CHANGE TO
define('OPTIONS_ENABLED_BRAND', 1);

//FIND
$extraFields .= ' products.products_brand as brand, ';

//CHANGE TO
$extraFields .= ' manufacturers.manufacturers_name AS brand, ';


You will end up with a feed with

Brand (Manufacturer Name)
Manufacturer (Manufacturer Name (Same))
MPN (Manufacturer Part Number)

2 of the 3 New Requirements that Google now require for a UK Feed. Simples.

  1. osCommerce Support Forum
  2. → Viewing Profile: thewrath1
  3. Forum Rules