Condition

The default condition that you want to assign your products if the condition hasn't been specified on the product.

Condition column name

The name of the product column which stores the condition of the product (which should hold values of "new", "used", or "refurbished").
If you want all products to be given the default condition in the feed, then leave this blank.Otherwise, set it to the name of the product column to use.

Product Type

The default value that you want your product type to be if no value is specified on a product.

Product Type column name

The column name of your products table that holds your "product_type" value.
If you want to just use the default for all your products, then leave this blank.
If you want to specify the product type per product, then set this to the name of the products column that holds your product type value.

UPC Field Name

This is the name of the products column that you use to store the UPC (Universal Product Code) of your products.

For US:
Universal Product Code is a 12-digit number often below the bar code of the item. This is required for all products except for Books.

For UK:
When running in UK format, this is not used.

EAN Field Name

This is the name of the products column that you use to store the EAN (European Article Number) of your products.

For US:
When running in US format, this is not used.

For UK:
European Article Number is a 13-digit number often below the bar code of the item. This is required for all products except for Books.

MPN Field Name

This is the name of the products column that you use to store the MPN of your products.
Manufacturer's Part Number is a unique code determined by the manufacturer for that product.
Required for all product types except:
Apparel, Beauty, Furniture, Garden, Jewelry and Media.

Brand Field Name

This is the name of the products column that you use to store the Brand Name of your products. If you don't use/store Brand Name, then leave this value blank.

PLEASE NOTE: If you use "supplierid," then the supplier name will be found/shown for the product's supplierid. If the supplierid is blank or invalid on a product, then the brand will be left blank for that product.
Using supplierid won't stop invalid/blank supplierid products from being included in the feed.

ID Field Name

This is your product ID column. It's the products table's column that will go into the feed-file's "ID" column.
You would normally use "catalogid" or "ccode".

Expiration Date

The default "expiration_date" value.
This must be entered in the format: "YYYY-MM-DD"
eg: "2010-04-26"