Automatically send data feed to Froogle

[edoscript 1]

Couple of changes that may be useful if you plan to use the .csv file for the Google Merchant Center (GMC).

 

GMC is using  date format Y-m-d, so I changed the line 
 

define('OPTIONS_DATE_FORMAT', 'm-d-Y');         //change how the date is formatted

to

define('OPTIONS_DATE_FORMAT', 'Y-m-d');         //change how the date is formatted

 

Since GMC requires the price field to have the curency specified (i.e. '19.99 USD'), near line 465 I replaced 

$row->price . "\t" .

with

$row->price . ' ' . OPTIONS_CURRENCY . "\t" .

 

Near line 627

$csvStr = str_replace("\t", '", "', '"' . $output);
$csvStr = str_replace("\n", "\"\n\"", $csvStr);
$csvStr = substr($csvStr,0,-1);
$csvStr = str_replace("\t", '", "', '"' . $output . '"');

I escaped the last line

#$csvStr = str_replace("\t", '", "', '"' . $output . '"');

 

And finally I replaced the below three lines

$fp = fopen( $csvFileLocn , "a" );
$fout = fwrite( $fp , $csvStr );
fclose( $fp );

with 

file_put_contents($csvFileLocn, $csvStr);

 

I think that was it.

Hope this will help someone.

[Jack_mcs 741]

Thanks for posting those changes. But as mentioned on the map creation page, the csv file is for testing only. You can use it if your fixes make it a working file but I suggest downloading It and try opening it locally to make sure it works.

[edoscript 1]

10 minutes ago, Jack_mcs said:

Thanks for posting those changes. But as mentioned on the map creation page, the csv file is for testing only. You can use it if your fixes make it a working file but I suggest downloading It and try opening it locally to make sure it works.

You are absolutely right, it say for testing only. However, since I needed it I worked on it and tested. The data is successfully uploaded to GMC. So I thought someone else may benefit from it too. 

 Otherwise, thanks for the module. It works fine for me.

[Adam_Maynard 0]

My feed shows all items expiring due to mismatched domain link, any input on how to fix this?

[bitit.it 0]

i try to install google feeder in lat phenix version but , i have this error

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /archivio/html/osnew/admin/googlefeeder.php on line 311

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /archivio/html/osnew/admin/googlefeeder.php on line 410

Feed contains 0 products.

 

can you help me?

Enrico

[Jack_mcs 741]

@Adam_MaynardSee my email.

@bitit.itThe code tries to figure out which php version is being used. I looks like it thinks you are using a version that used MySQL. Try changing this line in the googlefeeder.php file

$myfetch_mysql = ($use_mysqli ? mysqli_fetch_object : mysql_fetch_object);

to

$myfetch_mysql = mysqli_fetch_object;

 

[bitit.it 0]

at the moment i have a test version with php 5.6.4  but i want put production with php7.1 minimum .

In this way seem work in both version.

Thank you

Enrico

 

 

[bitit.it 0]

can i suggest a little change :

define('FEEDNAME', $language.'-your-outfile.txtt');       //from your googlebase account

instead of

define('FEEDNAME', '-your-outfile.txt');       //from your googlebase account

because if i want make two different campaign with two different language in this way i  can create different feed for any language.

following i want try to create a new interface , changing the link for create the feed in a form  where is possible select any active language.

and change in

define('FEEDNAME', $getLanguage.'-your-outfile.txtt');       //from your googlebase account

 

Enrico

 

[bitit.it 0]

for the moment the best should be

define('FEEDNAME', $language.'-your-outfile.txtt');  // where $language is default language

define('DEFAULT_LANGUAGE_ID', $languages_id);   //Default id Language

define('OPTIONS_FEED_LANGUAGE', $defaultcodelanguage); //

do you know  real name of this variable?

alternatively i have create a query on top of the file that give me this variables

Enrico

 

 

[bitit.it 0]

very simple change feed  language ,   changing the order of language

$query_lang_bitit=tep_db_query('SELECT * FROM languages ORDER BY sort_order');

$result_lang_bitit= mysqli_fetch_array($query_lang_bitit);

$language_id_bitit= $result_lang_bitit['languages_id'];
$language_code_bitit= $result_lang_bitit['code'];
$language_bitit= $result_lang_bitit['name'];

 

define('FEEDNAME', $language_bitit.'-your-outfile.txtt');  // 

define('DEFAULT_LANGUAGE_ID', $language_id_bitit);   //

define('OPTIONS_FEED_LANGUAGE', $language_code_bitit); //

 

[Jack_mcs 741]

Thank you for posting the code. It may be useful to others.

[bitit.it 0]

Hello.. another problem . google shopping want https pages for starting the advertise ; i have do some edit about :

around line 134

- $imageURL = 'http://' . DOMAIN_NAME . '/images/';

 + $imageURL = 'https://' . DOMAIN_NAME . '/images/';

around line 139

 - $productURL = 'http://' . DOMAIN_NAME . '/product_info.php?products_id=';

+  $productURL = 'https://' . DOMAIN_NAME . '/product_info.php?products_id=';

around line 149

-   $productURL = "http://" . DOMAIN_NAME . "/product_info.php?currency=" . CURRENCY_TYPE . "&products_id=";  //where

+   $productURL = "https://" . DOMAIN_NAME . "/product_info.php?currency=" . CURRENCY_TYPE . "&products_id=";  //where

the image address have  correctly https, but  the product url keep to be http

have you some idea?

Enrico

[Jack_mcs 741]

If you have the SEO_ENABLED setting set to true, then you may need to change the tep_href_link to tep_catalog_href_link. If not, the only thing I can think of is that your shop is not set up to work fully with ssl. Be sure there is redirect code in the roots .htaccess file to redirect to https.

[bitit.it 0]

yes , excuse me;

  i believe is a bug of phenix1010 version ;   for work , must setup the configure file  in the following way

  define('HTTP_SERVER', 'https://eshop.olivierasantangelo.it');
  define('HTTPS_SERVER', 'https://eshop.olivierasantangelo.it');

both define with https://

thank you again

Enrico