359 replies to this topic

[mkelly1]

Ralph2, on Apr 10 2007, 08:03 AM, said:

You're welcome. I'm glad it works

Question - When I go in to edit a product the check box is showing on the buttom. It's text is

"TEXT_PRODUCTS_RSS" with a checkbox at the end.

I unchecked all the products I DID NOT want to show up on the RSS feed and they are still showing up. I double checked to make sure they weren't still checked and they aren't. I'm doing the english version. Any idea's?

Michael

[Ralph2]

mkelly1, on Apr 11 2007, 11:31 PM, said:

Question - When I go in to edit a product the check box is showing on the buttom. It's text is

"TEXT_PRODUCTS_RSS" with a checkbox at the end.

I unchecked all the products I DID NOT want to show up on the RSS feed and they are still showing up. I double checked to make sure they weren't still checked and they aren't. I'm doing the english version. Any idea's?

Michael

Sure, just open catalog/admin/includes/languages/english/categories.php and find:

define('TEXT_PRODUCTS_WEIGHT', 'Products Weight:');

Add under it:

define('TEXT_PRODUCTS_RSS', 'Add this product to the RSS feed:');

Regarding the unchecked products, verify whether an unchecked / checked checkbox stays unchecked / checked after you've updated / saved the settings of a product. If the checkbox "remembers" its last setting, then your DB and the catalog\admin\categories.php file are working correctly.

In that case you might want to try to replace the following (in rss.php):

$sql = 'SELECT p.products_id, products_model, products_image, products_date_added FROM products p, products_to_categories pc WHERE p.products_id = pc.products_id AND pc.categories_id = \'' . $category . '\' AND products_status=1 ORDER BY RAND() DESC LIMIT ' . MAX_RSS_ARTICLES;
} else {
  $sql = 'SELECT products_id, products_model, products_image, products_date_added FROM products WHERE products_status=1 ORDER BY RAND() DESC LIMIT ' . MAX_RSS_ARTICLES;
}

With:

$sql = 'SELECT p.products_id, products_model, products_image, products_date_added FROM products p, products_to_categories pc WHERE p.products_id = pc.products_id AND pc.categories_id = \'' . $category . '\' AND products_status=1 AND products_to_rss=1 ORDER BY RAND() DESC LIMIT ' . MAX_RSS_ARTICLES;
} else {
  $sql = 'SELECT products_id, products_model, products_image, products_date_added FROM products WHERE products_status=1 AND products_to_rss=1 ORDER BY RAND() DESC LIMIT ' . MAX_RSS_ARTICLES;

Success!

[zarren]

Hey guys

I've just added this mod to my product price and stock quick update mod if anybody is intrested?

[shelby72]

I get the following error when trying to run rss feed 1.0:

XML Parsing Error: no element found
Location: http://zbookz.com/catalog/rss.php?language=en
Line Number 13, Column 24:Couldn't execute query.

What does the above mean and how do I fix it? Is it really necessary to install the adminsetting.sql if you have no articles on your website?

Shelby

[Sheepish]

Hi

I've added this but when I try to view the rss.php file I get "Internet Explorer cannot display this feed" and am told there's errors in the feed. When I check the feed at feedvalidator.org I'm told "line 3, column 0: XML parsing error: <unknown>:3:0: xml declaration not at start of external entity [help]" and there are two blank lines at the start of the rss feed - seems that's the problem. Any suggestions on how I get rid of the blank lines? The first line according to feedvalidator is "<?xml version="1.0" encoding="UTF-8" ?> "

Thanks

M

[cockroach]

Hi Guys,

I just noticed that this contrib breaks when used with CSS Buttons Everywhere

Both the buttons in the feed are affected:

<img src="http://fakeurl.com/shop/<div class="cssButton Add to Cart </div>" border="0">

Unfortunately I haven't got the skill to fix this myself, so I just though I'd let you know.

Cheers.

[theantiquestore]

I havent been doing much in php over the last couple of months so I am a bit rusty. I installed this contrib to one of my sites and when I click on the link I've placed in the info box I get this error:

Quote

XML Parsing Error: xml declaration not at start of external entity
Location: https://www.mysite.com/catalog/rss.php?language=en
Line Number 2, Column 1:<?xml version="1.0" encoding="UTF-8" ?>
^

What exactly did I do wrong?

Thanks in advance for your help!

[theantiquestore]

Ok, figured it out, guess I asked too soon! I had some extra spaces after the ?> in my english.php

Now, I am seeing nothing at all when I click the link in explorer. I'll figure it out I'm sure...

Thanks!

Edited by theantiquestore, 27 April 2007, 18:37.

[roconweb]

Is there a reason why the "Add to Cart" button wouldn't work. When I click it, it goes to my shopping cart, but doesn't add the product to the cart - it comes up empty! Any suggestions?

[Bisente]

Hi Ralph and everyone else,

I've just released a modification to the RSS Feed plugin that adds Ecommerce tags to the output.

By default it generates the same output as the original plugin, you have to pass the "?ecommerce=1" parameter to get the new behaviour. I've also reworked (optimized) the SQL on the plugin, now there's only one query to get all the needed data (please test).

The plugin can be downloaded from the usual place.

More info on my site. Sample (live) feed here.

Regards,

[mircea.t]

Hello


This feed can parse html tags? I'm asking you because i try to add oscommerce feed into another site (who accept html tags from rss, i have several other feeds enabled) but all i can see it's html code.

This is my feed: http://www.mallromania.ro/rss.php
This is how it's look into my other site: http://www.socio.ro/anunturi-calculatoare-...gb-t1069.0.html

Thanks

[awarner20]

Hi everybody,

I've just installed this contribution and have run into what I "think" is just a small error on my part. When I am in the Admin area, the words "BOX_HEADING" are in front of everything.

Here's a screenshot...
[img]http://derbydogma.com/images/links/rss_shot.jpg[/img]

Could someone clue me in on where I might have made a mistake? I am guessing it's on the catalog/admin/categories.php?

Any guidance would be greatly appreciated:)

[awarner20]

awarner20, on May 24 2007, 11:59 AM, said:

Hi everybody,

I've just installed this contribution and have run into what I "think" is just a small error on my part. When I am in the Admin area, the words "BOX_HEADING" are in front of everything.

Here's a screenshot...
[img]http://derbydogma.com/images/links/rss_shot.jpg[/img]

Could someone clue me in on where I might have made a mistake? I am guessing it's on the catalog/admin/categories.php?

Any guidance would be greatly appreciated:)

Would anyone here be kind enough to share why this might be happening? I would really like to use this contribution:)

[phi148]

awarner20, on May 25 2007, 07:59 AM, said:

Would anyone here be kind enough to share why this might be happening? I would really like to use this contribution:)

All of the "BOX_HEADING_*" stuff is defined in the /admin/includes/languages/english.php file.

Make sure that is all still there, and you didn't wipe that file out.

[phi148]

Hope this is not too off topic, but does anyone know where to submit these RSS files to?

Any really good places to submit ecommerce RSS feeds?

Thanks!

[enigma1]

phi148, on May 27 2007, 12:26 PM, said:

Hope this is not too off topic, but does anyone know where to submit these RSS files to?

Any really good places to submit ecommerce RSS feeds?

Thanks!

You don't submit the feeds, you place them on your server and you publish a url for each feed. See how oscommerce does it
http://www.oscommerce.com/community/contributions

[awarner20]

phi148, on May 27 2007, 01:24 PM, said:

All of the "BOX_HEADING_*" stuff is defined in the /admin/includes/languages/english.php file.

Make sure that is all still there, and you didn't wipe that file out.

Thanks phi148,

It looks like some code in that file is missing from as compared to a backup I have from last month. I have the most recent backup on another computer, so I should be able to get it fixed within the next few days.

Thanks for directing me on where to look:)

[awarner20]

The problem still exists for me. After having a chance to investigate, it looks like I had added some code to catalog/admin/includes/languages/english.php when it was supposed to be added to catalog/includes/languages/english.php in step 3. of the install instructions.

STEP 3
-------------
Open catalog/includes/languages/yourlanguagehere.php (e.g. english.php) file:


###Add before / above the last ?> tag:

	define('BOX_INFORMATION_RSS', 'Catalog Feed');


###Find:

	define('IMAGE_BUTTON_IN_CART', 'Add to Cart');


###Add under it:

	define('IMAGE_BUTTON_MORE_INFO', 'More information');

I thought maybe this was causing the issue, but I have corrected this and the problem in the above screenshots still exists. I am continuing to try and go through the instructions again. If anyone has any further thoughts on what area of code and possibly what file is screwed up, I would be most appreciative:)

[awarner20]

Problem solved, I feel so stupid:)

I had inadvertantly overwritten the admin/includes/languages/english.php with this same file in the other includes directory...catalog/includes/languages/english.php.

Luckily, I had a backup of this file, and everything seems to be ok now:)

Thanks for your attention to this thread.

[phi148]

awarner20, on May 29 2007, 09:23 AM, said:

Problem solved, I feel so stupid:)

I had inadvertantly overwritten the admin/includes/languages/english.php with this same file in the other includes directory...catalog/includes/languages/english.php.

Luckily, I had a backup of this file, and everything seems to be ok now:)

Thanks for your attention to this thread.

And the importance of backups shines through again! Good job.. and glad I was able to help.