359 replies to this topic

[dca]

Hello,

I just started installing this contribution.

On running the SQL file in phpmyadim I get the following error :
#1062 - Duplicate entry '80' for key 1

so am stick at Step 1 of the installation.

Any suggestions ?

dca

[gallerygirl]

Thank you - just installed with CRE Loaded and it works perfectly. It didn't require very much modification, either. Much appreciated!

[gallerygirl]

One issue: When I was submitting my feed to a couple directories, I realized that the description was "Your Store Name, change in catalog/includes/languages/ your language " How do I change this? I've poured over the catalog/includes/languages/english.php file and the rss.php file itself. I can't figure out where this infernal text is coming from, and it looks soooo bad.

[gallerygirl]

gallerygirl, on Feb 16 2008, 05:08 PM, said:

One issue: When I was submitting my feed to a couple directories, I realized that the description was "Your Store Name, change in catalog/includes/languages/ your language " How do I change this? I've poured over the catalog/includes/languages/english.php file and the rss.php file itself. I can't figure out where this infernal text is coming from, and it looks soooo bad.

Durrr... I just added a description define(DESCRIPTION,"About my store",TITLE) and that was perfect. I didn't realize it was that easy!

[olsonsp4c]

Hello,

What is it supposed to look like when you click the rss icon or information box link? I just get a page with a table on it and html of all my products... is this correct? thanks!

Scott

[GeorgeP]

OK, i installed it... but .. could someone explain to me what this thing is good for ? (yes, im a n00b, i know)

[homewetbar]

GeorgeP, on Mar 7 2008, 01:37 PM, said:

OK, i installed it... but .. could someone explain to me what this thing is good for ? (yes, im a n00b, i know)

Not a bad question, Google it, or here is a page that explains it: http://rss.softwaregarden.com/aboutrss.html It's much less complex than it sounds.

[alex121]

Hi,

I am having the same problem as DCA,

I am not very good with SQL so as i am trying to install this contribution i am also getting the following error:

#1062 - Duplicate entry '80' for key 1

so am stuck on Step 1 of the installation.

Any help would be appreciated

Thanks

[alex121]

Hi,

I think i have asnwered my own post.

I was reading the error code manual for SQL 5 and it occured to me that if i changed the configuration id
to the last id in the configuration table it would work

ie. the last id was 143 so i set it to 144

so far so good

just need to test it

Thanks anyway

[buysellleasetrade]

I have a quick question. I would like to be able to offer my visitors a link to separate RSS feeds with built in queries by categories in the RSS feed URL. My feed has over 60000 products so I would like to offer them a link for like this for instance:

www.mysite.com/rss.php?category=laptops

My question is what is the proper format to query a category in the url of RSS.php?

Please post a sample URL with the proper tags. Thanks.

Great contrib!

[buysellleasetrade]

buysellleasetrade, on Mar 20 2008, 07:26 PM, said:

I have a quick question. I would like to be able to offer my visitors a link to separate RSS feeds with built in queries by categories in the RSS feed URL. My feed has over 60000 products so I would like to offer them a link for like this for instance:

www.mysite.com/rss.php?category=laptops

My question is what is the proper format to query a category in the url of RSS.php?

Please post a sample URL with the proper tags. Thanks.

Great contrib!

I found out the problem I was having. It was all my fault for not putting the code into index.php and product_info.php. again great contrib thanks.

[buysellleasetrade]

I have a minor issue I would love to resolve. I have read about it and tested two remedies from this thread that did not work. What I am referring to is the OSCID showing up in the add to cart url link.

I tried this method to fix it first and it did not work:

######################
A quick bug Fix which I do not have time to package. With each product link, the oscId was added to the RSS feed..not very safe nor pretty:

To fix this change:
QUOTE
// RSS Links for Ultimate SEO (Gareth Houston 10 May 2005)
$link = tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $id, 'NONSSL', false);


with
QUOTE
// Correct RSS Links for Ultimate SEO without OscId (Phocea 20/06/2007)
$seo = ( defined('SEO_URLS') ? SEO_URLS : false );
$seo_rewrite_type = ( defined('SEO_URLS_TYPE') ? SEO_URLS_TYPE : false );
$link = tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $id, 'NONSSL', false, true);
if ($seo_rewrite_type == 'Rewrite') {
// We remove the oscid distributed by the user session used in this script
$link = substr($link, 0, strlen($link)-strlen(strstr($link,'?')));
} else {
$link = substr($link, 0, strlen($link)-strlen(strstr($link,'&osCsid')));
}

#######################

Then I used this method from this thread which did not error but this also did not remove the OSCID from the feed.

TIP #2 As mentioned somewhere earlier in forum somewhere oscommerce is adding the osCsid to the product URLs, bad news! To remove:

CODE
ADD
$link = substr($link, 0, strlen($link)-strlen(strstr($link,'&osCsid')));
UNDER
$link = tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $id, 'NONSSL', false);


########################

Any ideas? I know I have to remove the OSCID. Please help if you have any solutions. Thanks.

[homewetbar]

buysellleasetrade, on Mar 20 2008, 05:19 PM, said:

I have a minor issue I would love to resolve. I have read about it and tested two remedies from this thread that did not work. What I am referring to is the OSCID showing up in the add to cart url link.

I tried this method to fix it first and it did not work:

######################
A quick bug Fix which I do not have time to package. With each product link, the oscId was added to the RSS feed..not very safe nor pretty:

To fix this change:
QUOTE
// RSS Links for Ultimate SEO (Gareth Houston 10 May 2005)
$link = tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $id, 'NONSSL', false);
with
QUOTE
// Correct RSS Links for Ultimate SEO without OscId (Phocea 20/06/2007)
$seo = ( defined('SEO_URLS') ? SEO_URLS : false );
$seo_rewrite_type = ( defined('SEO_URLS_TYPE') ? SEO_URLS_TYPE : false );
$link = tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $id, 'NONSSL', false, true);
if ($seo_rewrite_type == 'Rewrite') {
// We remove the oscid distributed by the user session used in this script
$link = substr($link, 0, strlen($link)-strlen(strstr($link,'?')));
} else {
$link = substr($link, 0, strlen($link)-strlen(strstr($link,'&osCsid')));
}

#######################

Then I used this method from this thread which did not error but this also did not remove the OSCID from the feed.

TIP #2 As mentioned somewhere earlier in forum somewhere oscommerce is adding the osCsid to the product URLs, bad news! To remove:

CODE
ADD
$link = substr($link, 0, strlen($link)-strlen(strstr($link,'&osCsid')));
UNDER
$link = tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $id, 'NONSSL', false);
########################

Any ideas? I know I have to remove the OSCID. Please help if you have any solutions. Thanks.

Once you fix the oscid thing it will not fix it on any old products you had previously since your reader already pulled that data so you may have fixed it and not realized you did. You'll have to create some new products to see if you fixed it or not.

[buysellleasetrade]

homewetbar, on Mar 21 2008, 12:41 AM, said:

Once you fix the oscid thing it will not fix it on any old products you had previously since your reader already pulled that data so you may have fixed it and not realized you did. You'll have to create some new products to see if you fixed it or not.

Thanks for the fast reply. So to clarify, for new readers or visitors who use my RSS feed they will not see the OSCID anymore nor will the bots and spiders?

*BTW awesome script.

[homewetbar]

buysellleasetrade, on Mar 21 2008, 08:00 AM, said:

Thanks for the fast reply. So to clarify, for new readers or visitors who use my RSS feed they will not see the OSCID anymore nor will the bots and spiders?

*BTW awesome script.

Thanks but I am not the author... however I'm sure they appreciate your kind words.

If you have it fixed yes. But you'll still have to test that to make sure you fixed the problem after you add new products as I said before.

Edited by homewetbar, 21 March 2008, 18:07.

[buysellleasetrade]

In the admin section of my OScommerce installation under Configuration:>Maximum Values:>RSS Articles how many articles/products should I choose to display in my feed? What happens if I have thousands of articles/products? In my case I do so it has been timing out. I have over 70K products what is a good number to set my feed at? Or is there a way to parse it by category or query to that it does not time out? Any ideas?

[juanpalomo]

Wonderful contrib, it really works! But I have 2 issues: First, how can I enable the prices to show in the rss feed?. The second one is how to get per-category feeds. Can someone give me a hint about this?

[homewetbar]

buysellleasetrade, on Mar 31 2008, 06:12 PM, said:

In the admin section of my OScommerce installation under Configuration:>Maximum Values:>RSS Articles how many articles/products should I choose to display in my feed? What happens if I have thousands of articles/products? In my case I do so it has been timing out. I have over 70K products what is a good number to set my feed at? Or is there a way to parse it by category or query to that it does not time out? Any ideas?

Leave it at the default. Or 100 max I would say. It is a new product feed not an entire site feed...

[buysellleasetrade]

homewetbar, on Apr 1 2008, 04:31 PM, said:

Leave it at the default. Or 100 max I would say. It is a new product feed not an entire site feed...

Is there a way that a query can be applied by a user from a RSS reader to parse it like this for instance?

yoursite.com/rss.php?displays


?

[juanpalomo]

juanpalomo, on Apr 1 2008, 03:04 AM, said:

Wonderful contrib, it really works! But I have 2 issues: First, how can I enable the prices to show in the rss feed?. The second one is how to get per-category feeds. Can someone give me a hint about this?

Again, I must insist with my question, specially with the "price" issue. Is there a way to show the price, with the corresponding default currency, in the feed? I wonder why nobody has an answer and, specially, why in all the examples I see of the feed I can never see the prices, although we are all dealing here with shops

And this absence is even stranger since I can see in the code following lines,

  if($ecommerce!='') {
    echo '  <media:thumbnail url="' . $image_url . '">' . $image_url . '</media:thumbnail>' . "\n";
    echo '  <ecommerce:SKU>' . $id . '</ecommerce:SKU>' . "\n";
    echo '  <ecommerce:listPrice currency="' . DEFAULT_CURRENCY . '">' . $price . '</ecommerce:listPrice>' . "\n";
    if ($offer) {
      echo '  <ecommerce:offerPrice currency="' . DEFAULT_CURRENCY . '">' . $offer . '</ecommerce:offerPrice>' . "\n";
    }
    echo '  <ecommerce:manufacturer>' . $manufacturer . '</ecommerce:manufacturer>' . "\n";
  }
  echo '</item>' . "\n";
}

crearly referred to prices... Furthermore, what does really means the title of the contribution: "RSS feed with eCommerce, v1.22.2"? OsCommerce is an eCommerce system, and all the contributions and addons are somehow "with eCommerce"... Or is this special "eCommerce" some feature that I must first activate, in order to make the script work? I have read all possible information abot the installation of the contribution and still can find no answer... Can somebody help? That's really confusing

Thanks!