Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

The Feedmachine Solution


lech

Recommended Posts

I am afraid at the moment Feedmachine does not produce xml feeds. I might add this functionality in a future version, but to be honest I think that xml is inefficient for product feeds and all product search engines should except tab-delimited/csv feeds.

 

What product search engine are you trying to create a feed for and does it only accept xml feeds?

Link to comment
Share on other sites

Hi,

 

Great Contrib! I have used the first one for a couple of years and now I have just upgraded to this one.

 

During the install I experienced problems with the end of the SQL file:

 

`url_parameters` varchar(256) NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `config_filename` (`config_filename`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

 

It wouldn't accept this so I had to change it to varchar(255) and remove

ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

 

Is this ok? or does it have bad consequences.

 

As I said it is creating my fm-feeds file ok.

 

The other problem is FTP settings when viewing feedmachine_admin.php

 

I haven't used FTP before with google, rather uploading manually. google says uploads.google.com but they don't specify a path. Also when I update, FTP always stays OFF. Is this normal? even after scrolling it to ON, when I update it goes back to OFF.

 

Any help welcome.

 

Regards,

Rob

Link to comment
Share on other sites

Hi,

 

Great Contrib! I have used the first one for a couple of years and now I have just upgraded to this one.

 

During the install I experienced problems with the end of the SQL file:

 

`url_parameters` varchar(256) NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `config_filename` (`config_filename`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

 

It wouldn't accept this so I had to change it to varchar(255) and remove

ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

 

Is this ok? or does it have bad consequences.

 

As I said it is creating my fm-feeds file ok.

 

The other problem is FTP settings when viewing feedmachine_admin.php

 

I haven't used FTP before with google, rather uploading manually. google says uploads.google.com but they don't specify a path. Also when I update, FTP always stays OFF. Is this normal? even after scrolling it to ON, when I update it goes back to OFF.

 

Any help welcome.

 

Regards,

Rob

I just wanted to add that I am getting an encoding error in description field. I don't know why so I have linked the text file. I reduced it to 4 items, so the file won't be too big too look at. Text File

Link to comment
Share on other sites

In the windows which opens I am getting this error:

 

Warning: Invalid argument supplied for foreach() in /home/verzekerd/www/admin/feedmachine.php on line 458

 

Hi,

 

Please make sure you are using the latest version and that you have updated all files.

 

Do all feeds have a language selected in Feedmachine Admin?

Link to comment
Share on other sites

Great to hear from a user of the original Feedmachine! I hope you will find the new system even better.

 

The changes you made to the sql are fine.

 

The FTP On/Off problem is a small bug that I will sort out in the next version - thanks for pointing it out. The problem is that the drop-down is not displaying the correct status, though you are turning ftp on and off when updating.

 

Hi,

 

Great Contrib! I have used the first one for a couple of years and now I have just upgraded to this one.

 

During the install I experienced problems with the end of the SQL file:

 

`url_parameters` varchar(256) NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `config_filename` (`config_filename`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

 

It wouldn't accept this so I had to change it to varchar(255) and remove

ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

 

Is this ok? or does it have bad consequences.

 

As I said it is creating my fm-feeds file ok.

 

The other problem is FTP settings when viewing feedmachine_admin.php

 

I haven't used FTP before with google, rather uploading manually. google says uploads.google.com but they don't specify a path. Also when I update, FTP always stays OFF. Is this normal? even after scrolling it to ON, when I update it goes back to OFF.

 

Any help welcome.

 

Regards,

Rob

Link to comment
Share on other sites

Hi,

 

Please make sure you are using the latest version and that you have updated all files.

 

Do all feeds have a language selected in Feedmachine Admin?

 

We have uploaded the latest version. Do we must/have to do the SQL?

Link to comment
Share on other sites

No.

 

Do all feeds have a language selected in Feedmachine Admin?

 

yes, they have

 

 

catalog path: /home/verzekerd/www/

 

languages array built

currencies array built

taxes array built

countries array built

categories array built

 

number of products: 220

number of cycles: 1

 

feed configurations checked... output begun.

 

cycle: 1

 

products array built

products attributes array built

feed generation in process...

 

 

Warning: Invalid argument supplied for foreach() in /home/verzekerd/www/admin/feedmachine.php on line 458

 

 

done.

Edited by misa
Link to comment
Share on other sites

Hi,

 

Are your feeds empty?

 

please add

 

print_r($cur_feed);
foreach( $products as $key => $value ) {
 echo $key . "\n";
}

 

directly below line 457 and let me know what you get.

 

yes, they have

 

 

catalog path: /home/verzekerd/www/

 

languages array built

currencies array built

taxes array built

countries array built

categories array built

 

number of products: 220

number of cycles: 1

 

feed configurations checked... output begun.

 

cycle: 1

 

products array built

products attributes array built

feed generation in process...

 

 

Warning: Invalid argument supplied for foreach() in /home/verzekerd/www/admin/feedmachine.php on line 458

 

 

done.

Link to comment
Share on other sites

I am getting thid in the popup window:

 

catalog path: /home/verzekerd/www/

 

languages array built

currencies array built

taxes array built

countries array built

categories array built

 

number of products: 220

number of cycles: 1

 

feed configurations checked... output begun.

 

cycle: 1

 

products array built

products attributes array built

feed generation in process...

Array

(

[name] => Google Product Search Simple Configuration

[authors] => Lech

[filename] => google-product-search.txt

[schema_version] => 2.0

[fields] => Array

(

[id] => Array

(

[output] => products_id

[type] => DB

)

 

[title] => Array

(

[output] => products_name

[type] => DB

[options] => Array

(

[0] => STRIP_HTML

[1] => HTML_ENTITIES

[2] => STRIP_CRLF

)

 

)

 

[price] => Array

(

[output] => FINAL_PRICE

[type] => KEYWORD

)

 

[brand] => Array

(

[output] => manufacturers_name

[type] => DB

[options] => Array

(

[0] => STRIP_HTML

[1] => HTML_ENTITIES

[2] => STRIP_CRLF

)

 

)

 

[mpn] => Array

(

[output] => products_model

[type] => DB

)

 

[product_type] => Array

(

[output] => CATEGORY_TREE

[type] => KEYWORD

[options] => Array

(

[0] => STRIP_HTML

[1] => STRIP_CRLF

)

 

)

 

[link] => Array

(

[output] => PRODUCTS_URL

[type] => KEYWORD

)

 

[image_link] => Array

(

[output] => IMAGE_URL

[type] => KEYWORD

)

 

[condition] => Array

(

[output] => new

[type] => VALUE

)

 

[description] => Array

(

[output] => products_description

[type] => DB

[options] => Array

(

[0] => STRIP_HTML

[1] => HTML_ENTITIES

[2] => STRIP_CRLF

)

 

)

 

)

 

[add_field_names] => 1

[seperator] =>

[text_qualifier] =>

[category_tree_seperator] =>

[newline] =>

 

[encoding] => utf8

[currency_decimal_override] =>

[currency_thousands_override] =>

[include_record_function] =>

[id] => 1

[config_filename] => google-simple.php

[ftp_status] => 0

[ftp_server] =>

[ftp_path] =>

[ftp_username] =>

[ftp_password] =>

[ftp_upload_period] => 0

[language_code] => 4

[currency_code] => EUR

[countries_iso_2] => NL

[url_parameters] =>

[currency_decimal] => ,

[currency_thousands] =>

)

4

 

 

Warning: Invalid argument supplied for foreach() in /home/verzekerd/www/admin/feedmachine.php on line 462

 

Array

(

[name] => Pricerunner UK

[filename] => pricerunner.csv

[authors] => Lech

[schema_version] => 2.0

[fields] => Array

(

[Category] => Array

(

[output] => CATEGORY

[type] => KEYWORD

[options] => Array

(

[0] => STRIP_HTML

[1] => STRIP_CRLF

)

 

)

 

[Manufacturer] => Array

(

[output] => manufacturers_name

[type] => DB

[options] => Array

(

[0] => STRIP_HTML

[1] => HTML_ENTITIES

[2] => STRIP_CRLF

)

 

)

 

[Product ID] => Array

(

[output] => products_id

[type] => DB

)

 

[Product Name] => Array

(

[output] => products_name

[type] => DB

[options] => Array

(

[0] => STRIP_HTML

[1] => HTML_ENTITIES

[2] => STRIP_CRLF

)

 

)

 

[Price] => Array

(

[output] => FINAL_PRICE

[type] => KEYWORD

)

 

[Product URL] => Array

(

[output] => PRODUCTS_URL

[type] => KEYWORD

)

 

[image URL] => Array

(

[output] => IMAGE_URL

[type] => KEYWORD

)

 

[shipping] => Array

(

[output] => 0

[type] => VALUE

)

 

[stock Level] => Array

(

[output] => In Stock

[type] => VALUE

)

 

[Retailer message] => Array

(

[output] =>

[type] => VALUE

)

 

[Description] => Array

(

[output] => products_description

[type] => DB

[options] => Array

(

[0] => STRIP_HTML

[1] => HTML_ENTITIES

[2] => STRIP_CRLF

)

 

)

 

)

 

[currency_decimal_override] =>

[currency_thousands_override] =>

[add_field_names] => 1

[category_tree_seperator] =>

[seperator] => ,

[text_qualifier] => "

[newline] =>

 

[encoding] => utf8

[include_record_function] =>

[id] => 2

[config_filename] => pricerunner-uk.php

[ftp_status] => 0

[ftp_server] =>

[ftp_path] =>

[ftp_username] =>

[ftp_password] =>

[ftp_upload_period] => 0

[language_code] => du

[currency_code] => EUR

[countries_iso_2] => NL

[url_parameters] =>

[language_id] => 4

[currency_decimal] => ,

[currency_thousands] =>

)

4

 

done.

 

 

-----------------------

Feedmachine Report

-----------------------

 

start time: 2009-12-01 17:47:28 CET

end time: 2009-12-01 17:47:29 CET

runtime: 0.30362010002136

 

 

GLOBAL UPDATE TRIGGERS

----------------------

this was a force update

 

NOTICES

-------

this was a manual update

this run was triggered via HTTP

 

 

F E E D S

 

Google Product Search Simple Configuration

------------

update status: feed updated as part of a force update

upload trigger status: feed upload not triggered because feed upload is disabled

upload status: feed was not uploaded(0)

 

Pricerunner UK

------------

update status: feed updated as part of a force update

upload trigger status: feed upload not triggered because feed upload is disabled

upload status: feed was not uploaded(0)

Link to comment
Share on other sites

I think you've entered language_code in the google feed config manually. If so you need to delete the 'language_code' line from the configuration.

 

I am getting thid in the popup window:

 

catalog path: /home/verzekerd/www/

 

languages array built

currencies array built

taxes array built

countries array built

categories array built

 

number of products: 220

number of cycles: 1

 

feed configurations checked... output begun.

 

cycle: 1

 

products array built

products attributes array built

feed generation in process...

Array

(

[name] => Google Product Search Simple Configuration

[authors] => Lech

[filename] => google-product-search.txt

[schema_version] => 2.0

[fields] => Array

(

[id] => Array

(

[output] => products_id

[type] => DB

)

 

[title] => Array

(

[output] => products_name

[type] => DB

[options] => Array

(

[0] => STRIP_HTML

[1] => HTML_ENTITIES

[2] => STRIP_CRLF

)

 

)

 

[price] => Array

(

[output] => FINAL_PRICE

[type] => KEYWORD

)

 

[brand] => Array

(

[output] => manufacturers_name

[type] => DB

[options] => Array

(

[0] => STRIP_HTML

[1] => HTML_ENTITIES

[2] => STRIP_CRLF

)

 

)

 

[mpn] => Array

(

[output] => products_model

[type] => DB

)

 

[product_type] => Array

(

[output] => CATEGORY_TREE

[type] => KEYWORD

[options] => Array

(

[0] => STRIP_HTML

[1] => STRIP_CRLF

)

 

)

 

[link] => Array

(

[output] => PRODUCTS_URL

[type] => KEYWORD

)

 

[image_link] => Array

(

[output] => IMAGE_URL

[type] => KEYWORD

)

 

[condition] => Array

(

[output] => new

[type] => VALUE

)

 

[description] => Array

(

[output] => products_description

[type] => DB

[options] => Array

(

[0] => STRIP_HTML

[1] => HTML_ENTITIES

[2] => STRIP_CRLF

)

 

)

 

)

 

[add_field_names] => 1

[seperator] =>

[text_qualifier] =>

[category_tree_seperator] =>

[newline] =>

 

[encoding] => utf8

[currency_decimal_override] =>

[currency_thousands_override] =>

[include_record_function] =>

[id] => 1

[config_filename] => google-simple.php

[ftp_status] => 0

[ftp_server] =>

[ftp_path] =>

[ftp_username] =>

[ftp_password] =>

[ftp_upload_period] => 0

[language_code] => 4

[currency_code] => EUR

[countries_iso_2] => NL

[url_parameters] =>

[currency_decimal] => ,

[currency_thousands] =>

)

4

 

 

Warning: Invalid argument supplied for foreach() in /home/verzekerd/www/admin/feedmachine.php on line 462

 

Array

(

[name] => Pricerunner UK

[filename] => pricerunner.csv

[authors] => Lech

[schema_version] => 2.0

[fields] => Array

(

[Category] => Array

(

[output] => CATEGORY

[type] => KEYWORD

[options] => Array

(

[0] => STRIP_HTML

[1] => STRIP_CRLF

)

 

)

 

[Manufacturer] => Array

(

[output] => manufacturers_name

[type] => DB

[options] => Array

(

[0] => STRIP_HTML

[1] => HTML_ENTITIES

[2] => STRIP_CRLF

)

 

)

 

[Product ID] => Array

(

[output] => products_id

[type] => DB

)

 

[Product Name] => Array

(

[output] => products_name

[type] => DB

[options] => Array

(

[0] => STRIP_HTML

[1] => HTML_ENTITIES

[2] => STRIP_CRLF

)

 

)

 

[Price] => Array

(

[output] => FINAL_PRICE

[type] => KEYWORD

)

 

[Product URL] => Array

(

[output] => PRODUCTS_URL

[type] => KEYWORD

)

 

[image URL] => Array

(

[output] => IMAGE_URL

[type] => KEYWORD

)

 

[shipping] => Array

(

[output] => 0

[type] => VALUE

)

 

[stock Level] => Array

(

[output] => In Stock

[type] => VALUE

)

 

[Retailer message] => Array

(

[output] =>

[type] => VALUE

)

 

[Description] => Array

(

[output] => products_description

[type] => DB

[options] => Array

(

[0] => STRIP_HTML

[1] => HTML_ENTITIES

[2] => STRIP_CRLF

)

 

)

 

)

 

[currency_decimal_override] =>

[currency_thousands_override] =>

[add_field_names] => 1

[category_tree_seperator] =>

[seperator] => ,

[text_qualifier] => "

[newline] =>

 

[encoding] => utf8

[include_record_function] =>

[id] => 2

[config_filename] => pricerunner-uk.php

[ftp_status] => 0

[ftp_server] =>

[ftp_path] =>

[ftp_username] =>

[ftp_password] =>

[ftp_upload_period] => 0

[language_code] => du

[currency_code] => EUR

[countries_iso_2] => NL

[url_parameters] =>

[language_id] => 4

[currency_decimal] => ,

[currency_thousands] =>

)

4

 

done.

 

 

-----------------------

Feedmachine Report

-----------------------

 

start time: 2009-12-01 17:47:28 CET

end time: 2009-12-01 17:47:29 CET

runtime: 0.30362010002136

 

 

GLOBAL UPDATE TRIGGERS

----------------------

this was a force update

 

NOTICES

-------

this was a manual update

this run was triggered via HTTP

 

 

F E E D S

 

Google Product Search Simple Configuration

------------

update status: feed updated as part of a force update

upload trigger status: feed upload not triggered because feed upload is disabled

upload status: feed was not uploaded(0)

 

Pricerunner UK

------------

update status: feed updated as part of a force update

upload trigger status: feed upload not triggered because feed upload is disabled

upload status: feed was not uploaded(0)

Link to comment
Share on other sites

Ok..........thanks and fixed.

 

This contribution wil help me a lot..........thanks

 

Another question, will this work also on Creloaded?

Edited by misa
Link to comment
Share on other sites

Yes

 

am getting this error then:

 

cycle: 1

 

products array built

1054 - Unknown column 'po.language_id' in 'on clause'

 

SELECT *

FROM products_attributes pa LEFT JOIN products_options po ON pa.options_id = po.products_options_id

LEFT JOIN products_options_values pov ON pa.options_values_id = pov.products_options_values_id AND po.language_id = pov.language_id

WHERE pa.products_id BETWEEN 11 AND 375

 

TEP_DB_ERRORR

Link to comment
Share on other sites

I've tried installing your earlier script and was unable to get it to work for whatever reason, so I've tried installing it again and when trying to run from command line it gets a segmentation fault after building the countries array. I find this very strange and it may be the exact problem that I had last time I tried using this contribution.

 

Our store has over 1000 products and there is nothing really special about the database that would cause the php session to crash out.

 

Any suggestions?

 

PHP Warning: gethostbyaddr(): Address is not a valid IPv4 or IPv6 address in *snip*/whos_online.php on line 45

PHP Warning: session_destroy(): Trying to destroy uninitialized session in *snip*/sessions.php on line 164

catalog path: *snip*

languages array built

currencies array built

taxes array built

countries array built

Segmentation fault

Link to comment
Share on other sites

After doing a good bit of pondering, I figured it had to be crashing out because of all of the products we have. So, I installed a default OSC store and installed the feedmachine solution, it successfully generated 27 products. So, this brings me to my next question, how can we get this to work with larger stores?

 

Thanks, Frank

Link to comment
Share on other sites

Hello,

 

I've just installed this on oscommerce 2.2 and i'm getting this error message when I try and generate an upload feed:

 

 

Server Requirement Error: register_globals is disabled in your PHP configuration. This can be enabled in your php.ini configuration file or in the .htaccess file in your catalog directory.

 

 

However, when i enable register_globals the entire site falls over with a http:500 server error.

 

Please could you advise on how to get around this?

 

Thanks,

Kamal

Link to comment
Share on other sites

Hi,

 

I am trying to get this working on a heavily modified version of oscommerce. Seems to all be ok but the feed is going to an https:// URL and we do not currently have an SSL certificate enabled on the site.

 

Web Location of your feeds

https://www.balloondelivery2u.co.uk/fm-feeds/

 

Can you let me know where I can change this configuration.

 

Thanks

Link to comment
Share on other sites

Hi,

 

I am trying to get this working on a heavily modified version of oscommerce. Seems to all be ok but the feed is going to an https:// URL and we do not currently have an SSL certificate enabled on the site.

 

Web Location of your feeds

https://www.balloondelivery2u.co.uk/fm-feeds/

 

Can you let me know where I can change this configuration.

 

Thanks

 

Just remove the s from the https... no longer secure.

Link to comment
Share on other sites

Hi,

 

We are currently using the Feedmachine to upload our products to Google Shopping. All is working well apart from one thing, we are using Salemaker to promote a 10% discount Christmas sale at the moment, and the Feedmachine does not find the correct, lowered price. I have had a go at fixing this myself, but must admit I'm not the best coder in the world! Do you know of a way that I could make this work for us please?

 

Many thanks in advance,

Bill

Link to comment
Share on other sites

Hi,

 

Thanks! Removing the S worked perfectly and the products are now live on google which is great but.... (always a but!) none of the pictures are uploading, not sure why, we have got a modified version if OSCommerce which has extra images but the feed is displaying a link to images that doesn't work so for example http://www.balloondelivery2u.co.uk/images/f350942921ee21ef5589bee91c4357f7.jpg The actual image can be seen here http://www.balloondelivery2u.co.uk/images/products/original/product-id-144.jpg

 

Any ideas how I can fix this?

 

Thanks

Link to comment
Share on other sites

Hey guys, I will reply shortly.

 

Sweetness! I'm hoping you have a solution for large stores =)

 

Hi,

 

Thanks! Removing the S worked perfectly and the products are now live on google which is great but.... (always a but!) none of the pictures are uploading, not sure why, we have got a modified version if OSCommerce which has extra images but the feed is displaying a link to images that doesn't work so for example http://www.balloondelivery2u.co.uk/images/f350942921ee21ef5589bee91c4357f7.jpg The actual image can be seen here http://www.balloondelivery2u.co.uk/images/products/original/product-id-144.jpg

 

Any ideas how I can fix this?

 

Thanks

 

Glad I could help with the https thing, lech or someone with some experience with this script will have to chime in on your issue.

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...