Welcome, GuestSign In
Yahoo! Store Manage My Services
pad
Merchant Resources > Store Guide > Store Reference Manual > Retrieve Orders > Exporting Orders > Microsoft Access
pad
Merchant Resources
Updates
  System Status
  Merchant Newsletter
Learn More
  Getting Started Guide
  Guides and Resources
  Store Help
 
Related Services
 Designer Directory
  Yahoo! Shopping
Partners
  UPS
  GotMarketing
  Commission Junction
  Paymentech
  Marketing Partners
 
Exporting Orders to Microsoft Access

Several tables are provided as follows:

     Orders (name, address, card #, ...)
     Items ordered (product code, quantity, ...) 
     Options (color, size, ...) 
     Products in the site with pricing (product code, 
     description, price, ...) 
     Credit cards allowed 
     Shipping methods 
You can download all tables as a TAR (Tape ARchive) file. On Unix systems, use the tar command to unpack the archive. On Windows, several utilities such as WinZip are available. Or, you can download individual files.

The schema for each table is given in the first line of the file. Click on the picture above to see the relationships between tables.

We will add new columns to these tables as required to support new features. New keys will always be added to the end; the order of existing keys will never change. Your system should silently ignore any columns it does not recognize.