VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 Add-ons for VP-ASP
 Froogle
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

candude
VP-ASP New User

Canada
77 Posts

Posted - April 06 2004 :  07:59:33  Show Profile  Visit candude's Homepage  Reply with Quote
Here is a froogle script I wrote not so long time ago..

Just upload it to ya site, run, save it as a txt file and feed it to Froogle.. Enjoy..

SCRIPT IS FREEWARE AND COMES AS IS...
---------------
<html><body><pre>
product_url name description price image_url category
<%
strconn = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=c:\YOURDBLOCATIONHERE\shopping450.mdb"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.open strconn
Set oRs = Server.CreateObject ("ADODB.RecordSet")
Set oRs2 = Server.CreateObject ("ADODB.RecordSet")
oRs.open "select catalogid, cname, cdescription, cprice, keywords, cimageurl from products where cstock > 0", objConn,3
while not oRs.eof

description = replace(oRs("cdescription"), chr(10), "")
description = replace(description, chr(13), "")
description = replace(description, chr(34), "ft.")

oRs2.open "select intcategoryid from prodcategories where intcatalogid = "&oRs("catalogid"), objConn, 3

'Enter your category name here (ie. Books, Music & Video > Video)
category = "Books, Music & Video > Video"


oRs2.close

response.write "http://www.YOURSITE.com/shopquery.asp?catalogid="&oRs("catalogid")&" "&oRs("keywords")&" pattern "&oRs("cname")&" "&description&" "&oRs("cprice")&" http://www.YOURSITE.com/"&oRs("cimageurl")&" "&category&chr(13)&chr(10)

oRs.movenext
wend
oRs.close
objConn.close
%>
</pre></body></html>

MiniMe
Starting Member

24 Posts

Posted - April 14 2004 :  00:14:30  Show Profile  Reply with Quote
Thanks for sharing!

Just a quick question. I'm by no means an advanced programmer so forgive me if this is a dumb question:

My site is hosted with a hosting company so I don't know the absolute path of the site. Where you have:
DBQ=c:\YOURDBLOCATIONHERE\shopping450.mdb

Can I use the Server.MapPath method?

Thanks again!

Go to Top of Page

candude
VP-ASP New User

Canada
77 Posts

Posted - April 16 2004 :  06:28:00  Show Profile  Visit candude's Homepage  Reply with Quote
Mini,

Why do not you use the same DB config string that you have in the shop$config.asp file???

Just open your file and copy location string from "xdblocation". Unless of course you have it on SQL Server....

Good luck!

I either want less corruption or more chance to participate in it.
Go to Top of Page

revrat
Starting Member

47 Posts

Posted - April 24 2004 :  16:43:03  Show Profile  Reply with Quote
works great but it does not produce a delimited file for me. Have I done something wrong?

Go to Top of Page

devshb
Senior Member

United Kingdom
1898 Posts

Posted - April 24 2004 :  17:56:51  Show Profile  Visit devshb's Homepage  Reply with Quote
if you want a full-blown froogle-feed generator (for vpasp v4.5 and v5; both versions included), try:

http://bigyellowzone.com/shopdisplayproducts.asp?product=froogle

billions of options on it, and easy to run/install; just upload the files to your site, add the new screen to your admin menu, and then press a button to generate the files.

options include things like upc, using different category options, different values for offerid's allowed, instock flags, etc etc etc.

the options are done in 2 ways; there's a config file where you can change your default options. and the feed-generator admin screen itself has all the options available in its form as text fields, poplists etc. also gives you the count of products in your database grouped by stockflag, hideflag etc so you can compare that against how many products end up in your feed file (feed-file record count also shown on the results page, along with the link to the feed file that's been generated).

database connection isn't specified in the config options; it just uses your standard vpasp connection string that's already setup in your admin pages.

Also strips-out/translates relevant characters that the froogle people don't accept, and organises your category field with the froogle-style "a>b" structure.

Simon Barnaby
Freelance Developer
Java-E UK
[email protected]

Edited by - devshb on April 24 2004 18:24:52

Edited by - devshb on August 20 2004 13:34:55
Go to Top of Page

revrat
Starting Member

47 Posts

Posted - April 25 2004 :  11:34:20  Show Profile  Reply with Quote
Thanks

I actually figured out my problem and made some other changes but I might check out that script. I like the Invoice script I got last month from Sambru.

Go to Top of Page

JBE
Starting Member

1 Posts

Posted - April 26 2004 :  20:24:08  Show Profile  Visit JBE's Homepage  Reply with Quote
We went for the full version. Works great and very easy to use. It dramatically increased our Froogle presence. We were especially pleased with the tech support.

Go to Top of Page

devshb
Senior Member

United Kingdom
1898 Posts

Posted - May 21 2004 :  16:46:32  Show Profile  Visit devshb's Homepage  Reply with Quote
You can now try our Froogle-Feed online on our demo site without any need to purchase or register etc; this'll give you an idea of the options that you can use and how it works.....

We've got 4 versions available:

1. vpasp5/access:
demo through:
http://demos.bigyellowbox.co.uk/vpaspgen/byz002_01/shopa_generatefrooglefiles.asp

2. vpasp5/sqlserver:
demo through:
http://demos.bigyellowbox.co.uk/vpaspgen/byz009_01/shopa_generatefrooglefiles.asp

3. vpasp4.5/access:
demo through:
http://demos.bigyellowbox.co.uk/vpaspgen/byz010_01/shopa_generatefrooglefiles.asp

4. vpasp4.5/sqlserver:
demo through:
http://demos.bigyellowbox.co.uk/vpaspgen/byz011_01/shopa_generatefrooglefiles.asp


Our new site that's selling addons has just this minute gone live, so you can view our stuff on:

http://bigyellowzone.com/

there's a forum on there too for hints/tips/help etc, so feel free to post away!

If you like that, you also might like our panel-splitter for vpasp which also has demo versions available:

http://bigyellowzone.com/shopexd.asp?id=26

or our packingslip:

http://bigyellowzone.com/shopexd.asp?id=18

All these addons are updated/enhanced versions of the samburu ones (samburu and bigyellowzone are owned by the same people) - we'll be re-pointing the samburu links asap to point to the new site, so if you want the latest version with all the extra bits, go to:

http://bigyellowzone.com/

We'll be sending out updates to people who've already purchased the relevant software from samburu, so all you samburu customers out there can expect to be getting an email soon regarding free updates and notification of the move of the addons over to bigyellowzone.com

Simon Barnaby
Freelance Developer
Java-E UK
[email protected]

Edited by - devshb on August 16 2004 18:20:30
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000