Author Login | Popular Articles | RSS Feeds | Sitemap

Home | Uncategorized


Why You Should Feed Your Data

By:

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.

Article Source: http://www.articlesnatch.com

About the Author:
Become a E-commerce Data Wizard -Create Product Data Feeds Easily With Our DVD

| Print | Ezine Ready | |

Please Rate this Article

Recent UnCategorized Articles

  • Free Solar Panels - Nothing Is Free By: Ben Levanger - Thats right, nothing is ever free, Just like on the internet people offering free material are just trying to get your email so they can market to you.
  • Golf Training Aids To Improve Your Golf Game By: MIKE SELVON - It was not all that long ago that you couldn't find much in the way of golf training aids to help you improve your game.
  • The Dos And Donts Of Poker Bonuses By: imteaz ahmed - DO look around the internet in order to find the best poker bonus possible before you make a final decision.
  • 3 Abdominal Workout Exercises without Equipment By: Richard Black - When you watch enough late night television, you are bound to see some information on workout equipment. And if you are a human being, you likely also want your abs to be better than they are.
    Tags:
  • How Do Pressure Cookers Work By: MIKE SELVON - Pressure cookers were created to speed up the process of making food. They work, because at higher pressures, it takes a higher temperature to boil.
    Tags:
  • Home Made Wind Mills - Are They Possible - By: Ben Levanger - Home made wind mills can save you a large amount of money. I know from personal experience that you can achieve power independence if you work at it.
    Tags:
  • Top 10 Ways To Lose That Body Fat Fast! By: Debbie Allen - Anyone that is overweight understands the feeling of stress when it comes to shopping or preparing for a special event or vacation. When shopping it seems that all the clothes are made to look best on a small figure.
    Tags:
  • How To Build A Wind Turbine - Step By Step - By: Ben Levanger - Now this is a complicated questions, building something by reading this text will be difficult, but I will do my best to answer the question.
    Tags:
  • Finding Good Landscape Deals At Contractor Supply Stores By: Al Haneson - Sometimes buying your gardening supplies requires a little thinking outside of the box; the "Big Box" that is. You have to stop thinking in terms of convenience and think on the side of your budget and quality.
    Tags:
  • Tips To Help You Locate The Best Airline Tickets Deals By: MIKE SELVON - Recently, the US economy has been shaken, primarily due to rising gasoline prices. As a result, people are trying to find ways to economize and save money wherever possible.
    Tags:

Still can't find what you are looking for? Search for it!


Submit Your link to the Open Link Directory Project

Copyright 2005-2008 MJE Sales, LLC. All Rights Reserved.
Proud member of the ArticleCkr Search Network Search Network!
ArticleSnatch.com is free for both publishers and authors to use and is supported entirely from advertising revenue.
Use of our service is protected by our Privacy Policy and Terms of Service.