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
 Product feeds
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Steve2507
VP-ASP Expert

590 Posts

Posted - March 03 2007 :  11:57:57  Show Profile  Reply with Quote
Hi,

I purchased the Google, Yahho and Shopping.com feed generators earlier this week. However when I run them the description fields in the txt file are all blank.

How do I get the descriptions to show?

Thanks

Steve

devshb
Senior Member

United Kingdom
1898 Posts

Posted - March 04 2007 :  03:39:02  Show Profile  Visit devshb's Homepage  Reply with Quote
If that's our feed generators, then it's probably just that you're storing the description values in a different column than normal.

All our feed generators have a config file where you can specify how you want it to get the descriptions/names etc.

For the googlebase feed, it's the file "shopa_generategooglebasefiles_namedesc.asp"

if you edit that file in notepad you might change, for example, the line:

tvc_prd_feed_description(i)=tvc_prd_cdesc(i)

to:

tvc_prd_feed_description(i)=tvc_prd_extendeddesc(i)

(the comments at the top of that file explain the various values available and what to do)

for the yahoo feed, the same thing applies, but the file to change is shopa_generateyahoofiles_namedesc.asp

for the shopping.com feed, again the same thing applies, but the file to change is shopa_generateshoppingfiles_namedesc.asp



Simon Barnaby
Developer
[email protected]
www.BigYellowZone.com
Web Design, Online Marketing and VPASP addons
Go to Top of Page

Steve2507
VP-ASP Expert

590 Posts

Posted - March 04 2007 :  04:49:25  Show Profile  Reply with Quote
Hi Simon,

It is your feed generator, I put the message here because I thought you probably wouldn't look at your emails until after the weekend and their may be other people who had the same problem.

I hope you don't feel that I am having a go by posting queries here, as I have found your service excellent.

Our description field is called 'cdescription' so that is probably the cause. I'm just changing it now so I will test it later and tell you how it went.

Sorry to be a hastle, but I'm still developing my asp knowledge.

Steve

Go to Top of Page

Steve2507
VP-ASP Expert

590 Posts

Posted - March 04 2007 :  04:55:36  Show Profile  Reply with Quote
Hi,

Tried to run it after changing

tvc_prd_feed_description(i)=tvc_prd_cdesc(i)

to:

tvc_prd_feed_description(i)=tvc_prd_cdescription(i)

but now I get the following error:


Microsoft VBScript runtime error '800a000d'
Type mismatch: 'tvc_prd_cdescription'
/shopa_generategooglebasefiles_namedesc.asp, line 30

Any ideas?

Steve
Go to Top of Page

devshb
Senior Member

United Kingdom
1898 Posts

Posted - March 04 2007 :  06:05:31  Show Profile  Visit devshb's Homepage  Reply with Quote
slightly different; you need to use:

tvc_prd_feed_description(i)=tvc_prd_extendeddesc(i)

(for the extended description, ie for products.extendeddesc)

or:

tvc_prd_feed_description(i)=tvc_prd_cdesc(i)

(for the short description, ie for products.cdescription)

the variable "tvc_prd_cdesc(i)" is actually pointing to the "products.cdescription" column (sorry about the confusion on that point; that's a lazily-named variable on our part)

if you're already using the correct setting in that file and the corresponding data isn't blank but you still get blank output for it in the feeds, then we'll need to have a detailed look; it might be related to the 8k sqlserver bug if you're on sqlserver. I hope it's not that bug, but it might be if you've lengthened/added columns:
http://www.bigyellowzone.com/blog/?cat=11


Simon Barnaby
Developer
[email protected]
www.BigYellowZone.com
Web Design, Online Marketing and VPASP addons

Edited by - devshb on March 04 2007 06:11:50
Go to Top of Page

Steve2507
VP-ASP Expert

590 Posts

Posted - March 04 2007 :  07:04:16  Show Profile  Reply with Quote
Hi Simon,

Thanks for the reply.

The correct settings are being used then. None of the other data is blank.

There are some descriptions that are blank, could this mess it up, or should the generator just leave these blank?

Thanks

Steve
Go to Top of Page

devshb
Senior Member

United Kingdom
1898 Posts

Posted - March 04 2007 :  08:27:34  Show Profile  Visit devshb's Homepage  Reply with Quote
having some blank descriptions should be fine (ie it shouldn't mess up the display/output of the descriptions of those that aren't blank)

looks like it needs debugging/checking; if you enter a support ticket, we'll have a look:
http://www.bigyellowzone.com/support
(then "ask a question")


Simon Barnaby
Developer
[email protected]
www.BigYellowZone.com
Web Design, Online Marketing and VPASP addons
Go to Top of Page

Steve2507
VP-ASP Expert

590 Posts

Posted - March 04 2007 :  09:29:43  Show Profile  Reply with Quote
Hi Simon,

No problem, I did that earlier.

Steve
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000