Happy Thanksgiving! Here is beta 1 of a basic Froogle/GoogleBase feed for BV Commerce 5.


INSTALL

---

1) Copy the two included files into the /bvadmin/catalog folder of your store

USE

---

1) Go to Froogle.Google.com and sign up for a Google Base Account
2) Register to bulk upload a "products" file that is "tab delimited text"
3) Pick a name for your file like "Froogle.txt" and use that when registering your bulk upload
4) Register to upload via FTP. You'll be asked by Google to select a username and password
5) Go to http://www.mystore.com/b...min/catalog/Froogle.aspx (replace www.mystore.com with your store's url)
6) Enter your username, password, and feed file name in the text fields.
7) Click the "Generate Feed Only" if you want to preview without sending to Google. You can also use the preview to manually copy and paste the feed into your own file to upload through the web site.
8) Click the "Generate Feed and Send" button to generate a feed and automatically send it to Google


NOTES

---

The most common GoogleBase fields are set automatically from matching BV Commerce fields. There are many other fields that aren't set by default. To enable these other fields you can:

1) Create or Edit a product Type in BV Commerce
2) Add text properties that exactly match one of the available field names below (i.e. "ISBN")
3) Assign your products to this product type and enter the appropriate information
4) When the feed is generated, it checks all the available product properties to see if their "property name" matches a Google Base field. If so, that value is used. Otherwise an empty string is sent.

Available Fields:

payment_accepted
payment_notes
shipping
expiration_date
actor
apparel_type
artist
author
brand
color
condition
model_number
format
isbn
memory
pickup
processor_speed
size
tax_percent
tax_region
upc
product_type

Edited by user Friday, June 3, 2016 12:53:27 PM(UTC)  | Reason: Not specified

I wanted to post this feedback. The Froogle Feed works great except that the last item always errors out due to "too few tabs". I deleted the last item twice and the error is repeated for the new last item. Thanks.



Dan

uploading via the tool.

Thanks Marcus.

Marcus,



Maybe you should remove this download or thread so people unaware of the changes do not think that this will work.



Dan

We have reviewed all of the new GoogleBase specifications and our free BV Commerce 5 plugin has all of the required attributes for valid GoogleBase feeds. There are additional, optional attributes available but they are based on the product type from Google so you will need to manually modify the code if you wish to send these optional fields.

[3]Where I can find the latest Froogle/Google Base files? I am trying to upload my products and getting bunch of errors. Please see attached image.[/3]

We've never been able to get the direct FTP feed tool to work. What we do is download to tab delimited, create the feed and upload. You need to remove all extra columns to the right of the last column WITH data. If it ends at product type delete all columns right of there. We do the same below the last row of data. When we didn't do it we had errors trying to upload our promo items without trouble. Otherwise we got all sorts of failures. Please let us know if this works for you too.

HPRos, your suggestions did the trick. My feed was successful after following your suggestions. Many thanks!

Didn't quite follow your comment about extracting the CSV from Access.


Just go to the admin, then Plug-ins / BV Froogle Feed, and then Generate Feed Only.



The text that appears in the text below is the "guts" of the CSV. Select all, copy to the clipboard, and then paste into a local text file.



Then fire up Excel (or Access if you know what you're doing), and open the txt file. Excel should recognize that it's a tab-delimited text file (which, actually isn't a CSV file.