Problems with Google base.

[Willisski]

Problems with Google base. Is anyone else having these problems?

Issue #1
When we create and upload an uncompressed Google base feed we get the errors:

FAILED
• Creating feed File.
• Generating feed for products from 0 to 513 out of 513 products.
• Feed file generated.
• An error occured while uploading: The application requires at least Medium trust and WebPermission credentials to perform FTP operations.
I though that this issue was fixed in 7.0.2

AbleCommerce 7.0.2 Change Log
Between AbleCommerce 7.0.1 and 7.0.2
• FTP upload for product feeds can now be used with Medium trust and WebPermission.

Issue #2
When I manually upload the file to google base I get

1 of 513 items inserted - Processed on Aug 12, 2009 2:11 pm PDT

Detected encoding: US-ASCII
Detected delimiter: Tab (\t)
Detected file format: Text

Feed Level Messages
Warning: Missing recommended attribute: weight
Item Errors - 512 items with errors
512
Missing required attribute: description

Item Warnings - 513 items with warnings
513
Invalid UPC value

If anyone could point me in the right direction
Greg

[jmestep]

Missing description- Able code uses the product summary field for the description in the feed, so you probably have blanks there
Invalid UPC code- Able puts the Sku field into the UPC code field and if your sku is not a UPC, Google will reject the product.
On the weight, there might be some products that don't have weights.

[combra]

Problems with Google base. Is anyone else having these problems?

Issue #1
When we create and upload an uncompressed Google base feed we get the errors:

FAILED
• Creating feed File.
• Generating feed for products from 0 to 513 out of 513 products.
• Feed file generated.
• An error occured while uploading: The application requires at least Medium trust and WebPermission credentials to perform FTP operations.
I though that this issue was fixed in 7.0.2

AbleCommerce 7.0.2 Change Log
Between AbleCommerce 7.0.1 and 7.0.2
• FTP upload for product feeds can now be used with Medium trust and WebPermission.

Issue #2
When I manually upload the file to google base I get

1 of 513 items inserted - Processed on Aug 12, 2009 2:11 pm PDT

Detected encoding: US-ASCII
Detected delimiter: Tab (\t)
Detected file format: Text

Feed Level Messages
Warning: Missing recommended attribute: weight
Item Errors - 512 items with errors
512
Missing required attribute: description

Item Warnings - 513 items with warnings
513
Invalid UPC value

If anyone could point me in the right direction
Greg

For issue #1, you need to add write permissions to the folder that the Google Feed is stored in (admin>marketing>feeds). Judy already answered issue #2. I just wanted to add Weight and UPC are just warnings, so I wouldn't worry about those as much for now. Description is what you will want to fix.

-Brandon

[Willisski]

Weird
Usually if you had a field named description you assume that it would be the description.

Thanks for the info

[jmestep]

Thanks, combra. I didn't know the weight and upc were just a warning. I spoke too soon.

[Willisski]

I'm still getting the error when uploading
"The application requires at least Medium trust and WebPermission credentials to perform FTP operations."
I have checked the permissions for the folders and they are correct read and write.
Any other suggestions?


Greg

[combra]

I'm still getting the error when uploading
"The application requires at least Medium trust and WebPermission credentials to perform FTP operations."
I have checked the permissions for the folders and they are correct read and write.
Any other suggestions?


Greg

Hi Greg,

With some hosts, you won't be able to ftp it directly from AC b/c of trust level limitations. For example, Go Daddy. So what you can do is hit 'create feed' and then you will have to manually upload that file into your google base or google checkout account. I think this will change with the next version of AC.

-Brandon

[Willisski]

After reviewing the base feed I was wondering if possible to swap the product description field for the product summary field in the feed?

We already have some 600 product with nothing in the Summary field.

Does anybody have any thoughs?

greg

[jmestep]

The code is buried in the dll where you can't change it. I've been working on a custom feed in my spare time, but don't have it done yet. I'm adding a section on the generate feed page where the merchant can select what he wants mapped to the Googlebase fields.

gb.JPG

[Willisski]

Thanks so much for responding. If you could keep me in the loop. I know that this is going to be a big problem for us.

thanks
Greg

[ToddJ]

Hi Greg,

With some hosts, you won't be able to ftp it directly from AC b/c of trust level limitations. For example, Go Daddy. So what you can do is hit 'create feed' and then you will have to manually upload that file into your google base or google checkout account. I think this will change with the next version of AC.

-Brandon

Greg,
Since GoDaddy does seem to prevent FTP'ing to an outside location, another potential workaround would be to schedule a feed upload within your GoogleBase account. This could save some time on your part.

- Log into Google Base
- Go to My Items > Data Feeds
- Select Schedule > Create for the feed file to be uploaded
- Define the day and time on which file should be uploaded.
- Verify that the Time Zone is correct.
- Enter the file URL (e.g. http://www.mystore.com/admin/marketing/ ... sefeed.txt)
- Select Schedule. The Data Feed page will display the scheduled day/time.

Todd

[sdlong02]

Thanks so much for responding. If you could keep me in the loop. I know that this is going to be a big problem for us.

thanks
Greg

If you're not using your Summaries and your Descriptions are not in HTML code, copy your Descriptions to your Summaries and hide the summaries on the product pages so they don't display on-site.

[tachia]

Hello and I was hoping that I could receive help with a similar issue.

I've tried to change the write permissions via the ftp account, but doesn't seem to stay. I will contact the hosting service about not being able to update the write/read permissions..

I'm getting the following errors, but the file seems to be correct. I've even tried to manually uploaded the .txt file and I still am not able to upload.

Feed status summary

0 of 582 items inserted - Processed on Sep 3, 2009 10:21 am EDT

Detected encoding: UTF-8
Detected delimiter: Tab (\t)
Detected file format: Text

Warning: Missing recommended attribute: weight
While items missing recommended attributes will process successfully, we recommend including relevant attributes if they are available.
Item Errors - 582 items with errors
582 Missing title
You must enter an item title. "Title" is a required attribute.

Examples:
Item Nr. Line Nr.
1 2
6 7
7 8
8 9
9 10
582 Missing required attribute: id
Please make sure you include all required attributes in your data feed.

Examples:
Item Nr. Line Nr.
1 2
6 7
7 8
8 9
9 10
582 Missing required attribute: description

Here is a link to the feed and it looks fine, but it still say the labels are missing:
http://senselingerie.com/Admin/Marketin ... enseli.txt

Also in the error log on ablecommerce, I got the following error:
The remote server returned an error: (553) File name not allowed.

[kastnerd]

How can I have SKU and UPC in able so that the UPC is correctly feed to google. More things are using UPC on the web to find lowest price now.

[jmestep]

I just did it for one merchant where we stored the UPC in a product template field and adapted the feed code to pull the values from that.

[kastnerd]

Google sent me a message I am missing weight, I looked at the feed and it dose not include weight, What other fields should we add to the feed?

[jmestep]

In your Googlebase account, it will tell you what fields are required. It's hard to find the link, but this page explains what is required and recommended.
http://www.google.com/support/merchants ... 0083&hl=en

[jmestep]

The W2M Googlebase feed is completed now, but I don't know the price. If you are interested, you can contact
Allan Soave, asoave@web2market.com
Here are the features. The compress and upload features are the same as the ones in Able's feed generator.
The merchant has more option as far as choosing what product fields they want in Googlebase fields.
Description:
Product Description
Product Summary
Name and Manufacturer
If those fields are empty for a product, the description will be Product name and Store name

Brand:
None
Manufacturer
Vendor

MPN
None
MPN
Sku

Product Type
None
Product Summary
Product Breadcrumbs
Or Product type entered into a text box, used for all products

UPC
None
Sku
MPN
Product template field called UPC

ISBN
None
Sku
Mpn
Product template field called ISBN

Merchant can configure the path to generate the feed to if they want to change from the default.
It can be customized with additional fields.

W2MGoogleBase.JPG