Thank you for joining the Overstock.com affiliate program. As an Overstock.com affiliate you have the unique opportunity to market and merchandise over 1 million products. Below you will find information regarding our FTP, XML, and .CSV data feeds for Overstock shopping. We sincerely hope that you will utilize the information provided to grow your sales significantly over the course of our partnership. Please take a moment to read through the documentation provided to gain a complete understanding of our product mix. Please take note of the following;

• Any place you see [SITE.CODE] it must be replaced by your unique Commission Junction PID in order for sales to track and link correctly.
• Information pertaining to our XML and CSV feeds can be obtained by clicking through the navigation bar on the left hand side of this page.

Using the Datafeeds - Please use the datafeeds in Commission Junction first and foremost. These are the most accurate and up to date feeds. Most everything can be found within CJ. If you must use the FTP feeds, special permission is needed to login. You must obtain these logins from the affiliate managers at Overstock.com.

Again, thank you for promoting Overstock.com and if you have any questions please do not hesitate to call or send an email. We are more than happy to help in any way we can.

---

What is a datafeed?

A datafeed is a text file that includes several pieces of information about our products, separated by commas. It's very similar to an Excel spreadsheet -- one row for each product, and several columns of information.

What do I do with the datafeed?

Some technically savvy affiliates might load the datafeed into a database and display product information dynamically. If your website uses a database to store link information, then the following information will be extremely helpful.

What kind of datafeeds are available?

Currently there are 2 main FTP feeds available to affiliate partners that are being updated daily.

home_garden_decor	Home_garden_decor.csv
Non_Media	Non_Media.csv

These datafeeds are available from the Overstock.com ftp site and updated by 3AM Mountain Time every day.

If you have any questions after reading this email, please feel free to contact the affiliate hotline at 866.211.0734.

Please contact an Overstock.com affiliate program manager in order to secure access to download these data feeds.

Get the SKU for the product:

1. The SKU can be found in the first field of the datafeed
2. Copy the numeric value
3. Append the SKU found in the first field of the datafeed to this URL:
   
   http://www.jdoqocy.com/click-[SITE CODE]-10661583?URL=http%3A%2F%2Fwww.overstock.com%2F%3Ffp%3Df%26PAGE%3DPRODUCT%26OSSKU%3D[SKU]
4. An example for our Serta 4-inch Memory Foam Mattress Topper with Contour Pillows (SKU 10854919) is:
   http://www.jdoqocy.com/click-1245-10661583?URL=http%3A%2F%2Fwww.overstock.com%2F%3Ffp%3Df%26PAGE%3DPRODUCT%26OSSKU%3D10854919

Non-Media Datafeed Information

The Non_media datafeed contains the information below for all the following departments:

Apparel & Accessories products from Apparel & Accessories

Bed, Bath & Linens products from Bed Bath & Linens

Computer & Home Office products from Computer & Home Office

Electronics & Computers products from Electronics

Gifts, Gadgets & Toys products from Gifts, Gadgets & Toys

Home & Garden Decor products from Home & Garden Decor

Housewares & Appliances products from Housewares & Appliances

Jewelry & Watches products from Jewelry & Watches

Luggage & Business products from Luggage & Business

O Health products from O Health

Sports Gear products from Sports Gear

WorldStock products from Worldstock (Handmade)

The Non_media datafeed is a csv (comma separated values) file containing the following information:

Field #	Field Heading	Field Contents
1	PRODUCT SKU	Overstock Full Product SKU#
2	PRODUCT NAME	Overstock Product Name
3	PRODUCT SHORT NAME	Product Short Name
4	BRAND NAME	Brand Name
5	MANUFACTURER	Original Manufacturer
6	MANUFACTURER PART NO.	Original Manufacturer Part No.
7	MODEL NO.	Model No.
8	PRODUCT DIMENSIONS	Product Dimensions
9	PRODUCT MATERIALS	Materials used to make product
10	PRODUCT ORIGIN	Where the product came from
11	DEPARTMENT	Overstock.com Department
12	CATEGORY	Overstock.com Category
13	SUB-CATEGORY	Overstock.com Sub-Category
14	PRODUCT PRICE	Overstock.com Price
15	MSRP
16	LONG DESCRIPTION	Overstock.com's Long Description
17	SHORT DESCRIPTION	Overstock.com's Short Description
18	PRODUCT QUALITY	New /Refurb
19	PRODUCT WARRANTY	Warranty offered by Overstock.com or 3rd Party
20	QTY on HAND	Overstock.com Stock
21	UPC	Original UPC
22	THUMBNAIL IMAGE	URL for Thumbnail Image
23	LARGE IMAGE	URL for Large Image
24	STORE NAME	Name of the Store
* "N/A" is default if no information is found
** "|" is used to separate multiple Artists