Why You Should Feed Your Data
By Carl Ringwall
E-commerce sites need to get their content deep linked on search engines and indexes- one of the quickest and cheapest ways to do that is to create a data feed of your product catalog and post it to shopping sites.
Creating files for shopping feeds like those for Shopzilla or Google Product Search is easy, once you master some basic techniques. The steps are as follows:
- Export Shopping Cart Data
- (Normally, you are exporting MySQL data using phpMyAdmin)
- Import Data into MS Access
- Create Queries to Format Data in Shopzilla/Google/ShoppingDotcom format
- Export Data From Query to Create product data feed file
This same technique can be used to create affiliate data feeds and any other type of web data export.
Start With Google Product Search
Google Product Search is fed from Google Base. To create a product feed for Google, you must first do an export of shopping cart or catalog data to create what Google terms a bulk upload. Follow Google's instructions, particularlly the field name conventions for products, carefully.
After you have downloaded the data from phpMyAdmin, you import the data into Access, then the key step is creating the format queries:
Most providers recommend using Excel to process feed data. We like to import catalog or merchant feed data into MS Access and use the powerful query functions to massage and manipulate the product data.
The process works like this:
1. Import your raw feed or data file into Access using the import feature
2. Create a query to reformat the data into the desired result:
a. Use the field alias feature to 'hard code' field data that may not exist in your original file ie:,
expiration_date: "YYYY-MM-DD"
b. Use the concatenation feature to reformat fields from existing data -
ie, your product_image filed contains "image.jpg":
image_url: "http://www.yourdomain/images/" & [product_image]
3. After your fields are created in the query, simply export a delimited file from your query and process. You can re-import your original feed data into your Access file, run the query and re-export very quickly whenever you need to refresh your data.
Format Query In Access
You use the field alias feature in Access to create the fields with the required field names, and use the concatenation functions to piece together the data in the required formats.
Start with the basic fields (use Google's naming convention explicitly):
title
description
brand
condition
link
price
product_type
image_link
model_number
payment_accepted
expiration_date (format: YYYY-MM-DD)
You can use any type of delimiter you wish for your file, we prefer pipe "|" for readability, but the Google default of tab delimited works fine as well. (If you change the default delimiter, you 'll need to specify the change in the bulk upload properties.)
You will need to re-upload your file regularly to Google, since bulk uploads typically expire in 30 days.
About the author
Become a E-commerce Data Wizard -Create Product Data Feeds Easily With Our DVD from http://www.FreeArticlesAndContent.com
|
|
Copy This Article
For FREE!!!
You can use this article and copy it on your own website
for free! All you have to do is make sure the article
is copied with no changes and includes the "About
The Author" text. Also please ensure that all url's
are hyperlinked according. Thank you. |
Link To This Article - And We'll
Link Back To Your Website!
You are more then welcome to link to this article! All
you have to do is copy this webpage address from the
address bar and create a link on your website. Please
use the title of this article for your link text. Please
get in contact once you have linked to this article
and we'll link back to you! Thank you. |
|
|
|
Other great articles from this category...
|
Related Sites
|
|
