Inserting SAP Product URL's into Google Base Feeds

8 replies
Mark Norton
Joined: Feb 13 2007
User offline. Last seen 1 year 23 weeks ago.
Hi All

I'm just setting our first feed with Shopping - a Base feed for our SAP store.

Maybe I'm missing something, but how do I get the SAP URL for each product into the feed? Do I export a list of them from the SAP admin console and insert them as an inventory field? I presume that would be the only way?

Also, the only Template I see for Google Base is:
Google Base UK version 1.0 January 2007 Default Template

Is there not a more up to date one than this?

Cheers
Mark
0
Your rating: None
ChannelAdvisor Employee
Anthony Alford's picture
Joined: Jun 15 2007
User offline. Last seen 4 days 5 hours ago.
Inserting SAP Product URL's into Google Base Feeds

Mark,

When you setup a Premium Store, you will automatically get a new inventory field to use in your ShoppingAdvisor business rules and templates. The field is named URL, but without spaces. In your case: DANGLEBERRYMUSICURL

You can use this field directly in your Google Base template. However, unless your store is live and you've updated the base url to your live domain name, you urls will begin with something like "sapxx.ChannelAdvisor.com" which I imagine you would not want to send to Google. In that case, you can create a business rule to fix that.

 
Mark Norton
Joined: Feb 13 2007
User offline. Last seen 1 year 23 weeks ago.
Inserting SAP Product URL's into Google Base Feeds

Hi Anthony

Many thanks for that, and should there be a more up-to-date Google Base Template than 2007?

Cheers
Mark

Jennifer Artabane
ChannelAdvisor Employee
Jennifer Artabane's picture
Joined: Jun 19 2008
User offline. Last seen 54 min 10 sec ago.
Inserting SAP Product URL's into Google Base Feeds

Mark,
We updated the Google template in January 2009 but did not change the name for those already using it. We discussed at the time how to better mark that the template was up to date - we will revisit that discussion and see if we can make it more clear.

(UPDATE):
My apologies, we updated the US Google template in Jan 2009. The UK version you are using is the most recent version in our system.

-Jennifer

Mark Norton
Joined: Feb 13 2007
User offline. Last seen 1 year 23 weeks ago.
Inserting SAP Product URL's into Google Base Feeds

Hi Jennifer

Many thanks for that, much appreciated!

Cheers
Mark

Mark Norton
Joined: Feb 13 2007
User offline. Last seen 1 year 23 weeks ago.
Inserting SAP Product URL's into Google Base Feeds

Hey People

I just have one more query.

I wish use the CONCATENATE function to add the words *FREE SHIP* to the beginning of my products title on the Google Base feed - to make it really obvious that the price includes shipping.

The bizarre thing is, the title I wish to add the text to is currently an Inventory attribute called ETAIL_PRODUCT_NAME which would give me the following function:

CONCATENATE ("*FREE SHIP*"," ",$ETAIL_PRODUCT_NAME)

however the result comes out as *FREE SHIP*

I then try using a different attribute (which has no underscores in the attribute name) and it works fine. Does Shopping have something against our friend the underscore?

Cheers
Mark

ChannelAdvisor Employee
Anthony Alford's picture
Joined: Jun 15 2007
User offline. Last seen 4 days 5 hours ago.
Inserting SAP Product URL's into Google Base Feeds

Short answer: yes. Your inventory attribute names get stripped of anything that's not a letter or number.

 
Mark Norton
Joined: Feb 13 2007
User offline. Last seen 1 year 23 weeks ago.
Inserting SAP Product URL's into Google Base Feeds

Thanks for the swift reply! I'll just rename them, they're nothing to do with etail any more anyway!

Cheers
Mark

ChannelAdvisor Employee
Anthony Alford's picture
Joined: Jun 15 2007
User offline. Last seen 4 days 5 hours ago.
Inserting SAP Product URL's into Google Base Feeds

You don't have to rename them; just keep in mind that to use them in ShoppingAdvisor rules you have to remove the underscores when you write the rule.