Instructions for creating inventory items using a CSV file

Instructions:

List of valid column names

Column name Required? Remarks
Title Yes Maximum 80 characters
Sub Title
SubTitle
No Maximum 55 characters
Description Template ID
DescriptionTemplateID
No Numeric unique ID of the description template.

To find the numeric ID assigned to a Description Template, please use the main menu option:

Tools -> Options -> Description Templates

Then, SELECT the Description Template of your choice. WL will display the ID assigned.

Description No If a value is entered for this column, that value is used and the value entered, if any, for Description File Name is ignored
Description File Name
DescriptionFileName
No If Specified, the entire contents of the file is used as the Description, provided Description column is empty.

Example value:

C:\eBayDescriptions\description01.html

Condition Description
ConditionDescription
No If the item is not brand new, then, specify its condition in your own words
Lot Size
LotSize
No If entered, must be a number 1 or more
Average Unit Cost
AverageUnitCost
No This field is used by Wonder Lister for Profit & Loss calculations. Not sent to eBay.

Only numeric amount without the currency symbol must be specified.

Example value:

123.89

MeasurementSystem
Measurement System
MeasurementUnit
Measurement Unit
Yes Valid values are:
  • Metric - Dimensions should be expressed in centimeters, weight major in Kg and weight minor in gms
  • English - Dimensions should be expressed in inches, weight major in pounds and weight minor in ounces
Package Length
PackageLength
No Package length as per the Measurement System
Package Width
PackageWidth
No Package width as per the Measurement System
Package Height
PackageHeight
Package Depth
PackageDepth
No Package height as per the Measurement System
Weight Major
WeightMajor
No Weight major as per the Measurement System
Weight Minor
WeightMinor
No Weight minor as per the Measurement System
Track Inventory By SKU
TrackInventoryBySKU
No Valid values for this column are:

  • true (or 1)
  • false (or 0)

If true (or 1), then, SKU column must be specified and must be unique across all active listings for the specified eBay site and seller account.

UPC No UPC Code
ISBN No For ten digits ISBN ONLY
ISBN_13 No For thirteen digits ISBN ONLY
EAN No European article number
Brand
C:Brand
No Brand
MPN
C:MPN
No Manufacturer's part number
SKU
Custom Label
CustomLabel
No Stock keeping unit
Storage Location Bin
StorageLocationBin
No Location of this item in your warehouse
Picture 1 No Path to First picture.

Paths can be specified as local on your computer or as http paths.

Format for specifying local path (UNC format) on your computer:

\\<COMPUTER_NAME>\<SHARE_NAME>\<path_to_image_file>

Example value:

\\DELL_SERVER\SharedImages\image01.jpg

OR

as non UNC path. Example value:

D:\eBayImages\image01.jpg

General note about each picture: If an intermediate picture is not specified, then, all subsequent pictures are re-numbered upwards to fill-in the gap. For example, say, if you leave out the fifth picture but enter sixth and seventh, then, in reality, sixth and seventh will actually be fifth and sixth pictures.

Picture 2 No Second picture.
Picture 3 No Third picture.
Picture 4 No Fourth picture.
Picture 5 No Fifth picture.
Picture 6 No Sixth picture.
Picture 7 No Seventh picture.
Picture 8 No Eighth picture.
Picture 9 No Ninth picture.
Picture 10 No Tenth picture.
Picture 11 No Eleventh picture.
Picture 12 No Twelveth picture.
Available Quantity Yes Quantity to list.
Listing Type
Format
Yes Valid values are:
  • FixedPriceItem
  • Auction
Duration Yes Valid values are:
  • A valid numeric number (in days)
  • GTC

Available values for number of days is dependent on the eBay site you are listing on.

Primary Category ID
PrimaryCategoryID
Category
Yes Numeric ID of the Primary category.

The number you enter MUST be a valid eBay category. The category MUST also be a leaf level category, that is, the category cannot have any sub-categories under it.

Secondary Category ID
SecondaryCategoryID
Category2
No Numeric ID of the Secondary category.

The number you enter MUST be a valid eBay category. The category MUST also be a leaf level category, that is, the category cannot have any sub-categories under it.

Store Category ID
StoreCategoryID
StoreCategory
No Numeric ID of the first Store category
Store Category ID2
StoreCategoryID2
StoreCategory2
No Numeric ID of the second Store category
Consignor Name
ConsignorName
No Name of the consignor. If entered, must also specify Consignor Policy Name column. The name must already be an existing consignor's name. You can create consignor's using WL main menu option:

Tools -> Options -> Consignors

Consignor Policy Name
ConsignorPolicyName
No Name of the consignor policy. If entered, must also specify Consignor Name column.The policy name must already be an existing consignor policy's name. You can create consignor policies using WL main menu option:

Tools -> Options -> Consignor Policies

Currency No 3 letter Currency code. If not specified, default site currency is used.
Price
StartPrice
Yes For Fixed Price listing, this is the fixed price.

For an Auction listing, this is the starting price.

Must be specified without the currency symbol.

Example value:

19.99

BIN Price
Buy It Now Price
BuyItNowPrice
No Auction Buy It Now (BIN) price.

Must be specified without the currency symbol.

Example value:

19.99

Reserve Price
ReservePrice
No Auction reserve price.

Must be specified without the currency symbol.

Example value:

19.99

VAT%
VAT %
VATPercent
VAT Percent
No VAT Percentage.

if specified without the % symbol.

Example value:

9.99

Do Not Use Tax Table
DoNotUseTaxTable
No Valid values are:
  • true (or 1)
  • false (or 0)
Private Listing
PrivateListing
Private Auction
PrivateAuction
No Valid values are:
  • true (or 1)
  • false (or 0)
eBay User ID
eBayUserID
Yes eBay User ID of the seller creating this listing
Site ID
SiteID
Yes

Valid eBay Site IDs are:

  • US
  • Canada
  • UK
  • Australia
  • Austria
  • Belgium_French
  • France
  • Germany
  • Italy
  • Belgium_Dutch
  • Netherlands
  • Spain
  • Switzerland
  • Taiwan
  • eBayMotors
  • HongKong
  • Singapore
  • India
  • China
  • Ireland
  • Malaysia
  • Philippines
  • Poland
  • Sweden
  • CanadaFrench
Payment Profile Name
PaymentProfileName
Yes Must be the name of an existing Payment profile for the specified eBay site and eBay User ID
Shipping Profile Name
ShippingProfileName
Yes Must be the name of an existing Shipping profile for the specified eBay site and eBay User ID
Return Profile Name
ReturnProfileName
ReturnPolicy Profile Name
ReturnPolicyProfileName
Yes Must be the name of an existing Return policy profile for the specified eBay site and eBay User ID
Domestic Shipping Service1 Cost No Shipping cost for first domestic shipping service specified in the shipping profile. Is applicable only for FLAT domestic shipping.
Domestic Shipping Service1 Additional Cost No Additional Shipping cost for first domestic shipping service specified in the shipping profile. Is applicable only for FLAT domestic shipping.
Domestic Shipping Service1 Surcharge No Surcharge for first domestic shipping service specified in the shipping profile. Is applicable only for FLAT domestic shipping and if surcharge is applicable for the shipping service specified in the profile.
Domestic Shipping Service2 Cost No Shipping cost for second domestic shipping service specified in the shipping profile. Is applicable only for FLAT domestic shipping.
Domestic Shipping Service2 Additional Cost No Additional Shipping cost for second domestic shipping service specified in the shipping profile. Is applicable only for FLAT domestic shipping.
Domestic Shipping Service2 Surcharge No Surcharge for second domestic shipping service specified in the shipping profile. Is applicable only for FLAT domestic shipping and if surcharge is applicable for the shipping service specified in the profile.
Domestic Shipping Service3 Cost No Shipping cost for third domestic shipping service specified in the shipping profile. Is applicable only for FLAT domestic shipping.
Domestic Shipping Service3 Additional Cost No Additional Shipping cost for third domestic shipping service specified in the shipping profile. Is applicable only for FLAT domestic shipping.
Domestic Shipping Service3 Surcharge No Surcharge for third domestic shipping service specified in the shipping profile. Is applicable only for FLAT domestic shipping and if surcharge is applicable for the shipping service specified in the profile.
Domestic Shipping Service4 Cost No Shipping cost for fourth domestic shipping service specified in the shipping profile. Is applicable only for FLAT domestic shipping.
Domestic Shipping Service4 Additional Cost No Additional Shipping cost for fourth domestic shipping service specified in the shipping profile. Is applicable only for FLAT domestic shipping.
Domestic Shipping Service4 Surcharge No Surcharge for fourth domestic shipping service specified in the shipping profile. Is applicable only for FLAT domestic shipping and if surcharge is applicable for the shipping service specified in the profile.
International Shipping Service1 Cost No Shipping cost for first International shipping service specified in the shipping profile. Is applicable only for FLAT International shipping.
International Shipping Service1 Additional Cost No Additional Shipping cost for first International shipping service specified in the shipping profile. Is applicable only for FLAT International shipping.
International Shipping Service1 Surcharge No Surcharge for first International shipping service specified in the shipping profile. Is applicable only for FLAT International shipping and if surcharge is applicable for the shipping service specified in the profile.
International Shipping Service2 Cost No Shipping cost for second International shipping service specified in the shipping profile. Is applicable only for FLAT International shipping.
International Shipping Service2 Additional Cost No Additional Shipping cost for second International shipping service specified in the shipping profile. Is applicable only for FLAT International shipping.
International Shipping Service2 Surcharge No Surcharge for second International shipping service specified in the shipping profile. Is applicable only for FLAT International shipping and if surcharge is applicable for the shipping service specified in the profile.
International Shipping Service3 Cost No Shipping cost for third International shipping service specified in the shipping profile. Is applicable only for FLAT International shipping.
International Shipping Service3 Additional Cost No Additional Shipping cost for third International shipping service specified in the shipping profile. Is applicable only for FLAT International shipping.
International Shipping Service3 Surcharge No Surcharge for third International shipping service specified in the shipping profile. Is applicable only for FLAT International shipping and if surcharge is applicable for the shipping service specified in the profile.
International Shipping Service4 Cost No Shipping cost for fourth International shipping service specified in the shipping profile. Is applicable only for FLAT International shipping.
International Shipping Service4 Additional Cost No Additional Shipping cost for fourth International shipping service specified in the shipping profile. Is applicable only for FLAT International shipping.
International Shipping Service4 Surcharge No Surcharge for fourth International shipping service specified in the shipping profile. Is applicable only for FLAT International shipping and if surcharge is applicable for the shipping service specified in the profile.
International Shipping Service5 Cost No Shipping cost for first International shipping service specified in the shipping profile. Is applicable only for FLAT International shipping.
International Shipping Service5 Additional Cost No Additional Shipping cost for first International shipping service specified in the shipping profile. Is applicable only for FLAT International shipping.
International Shipping Service5 Surcharge No Surcharge for first International shipping service specified in the shipping profile. Is applicable only for FLAT International shipping.
Enable Best Offer
EnableBestOffer
Best Offer Enabled
BestOfferEnabled
No Valid values are:
  • true (or 1)
  • false (or 0)
Best Offer Auto Accept Amount
BestOfferAutoAcceptAmount
Best Offer Auto Accept Price
BestOfferAutoAcceptPrice
No Meaningful only when value of column EnableBestOffer is true (or 1)

Must be specified without the currency symbol.

Example value:

19.99

Best Offer Auto Decline Amount
BestOfferAutoDeclineAmount
Minimum Best Offer Price
MinimumBestOfferPrice
No Meaningful only when the value of column EnableBestOffer is true (or 1)

Must be specified without the currency symbol.

Example value:

19.99

Condition No Many categories require that Condition must be specified. The value depends on the Primary category. For example, condition value could be:
  • New
  • Used
Storage Location ID
StorageLocationID
No Numeric ID of an existing location from where the item will be shipped from.

To see the list of numeric ID assigned to a specific location, please use the main menu option:

Tools -> Options -> Storage Locations

Country No Ignored if StorageLocationID is specified.
Country in which the item is located. If specified and used, then, Location should also be specified.
Location No Ignored if StorageLocationID is specified.
Location within the Country in which the item is located. If specified and used, then, Country should also be specified.
PostalCode
Postal Code
No Ignored if StorageLocationID is specified.
Postal Code of Location within the Country in which the item is located. If specified and used, then, Country and Location should also be specified.
Visitor Counter
VisitorCounter
No Valid values for Visitor Counter are:
  • None
  • Basic Style
  • Retro Style
  • Hidden
Item Specifics
ItemSpecifics
No Single COLUMN containing ALL item specifics.

Use this column OR you can use INDIVIDUAL columns for EACH Item Specific Name (see next column for details).

Item Specifics must follow this format:

Name1=Value11|Value12|Value13 ... Value1n;;Name2=Value21|Value22|Value23 ... Value2n;; ... Namen=Valuen1|Valuen2|Valuen3 ... Valuenn;;

Where

Name1, Name2 etc are the Item Specific Names

Value11, Value12, Value13 etc are the Values for Name1

Value21, Value22, Value23 etc are the Values for Name2

... and so on

If Name is an eBay specific name, then, the Values must follow eBay specified rules for that name (Whether it accepts 1 value or more)

If Name is custom (non-eBay), then, only a single value must be specified

Multiple values for a name must be separated by |

Name and its values must be separated by = without any spaces in between the name and its values

Each SET of (Name, Values) must be separated by two semi-colons (;;)

For example,

Brand=GE;;Connector Type=RJ-11|RJ-12;;Finish=Metallic

IS:<ItemSpecificName>

Substitute <ItemSpecificName> with the actual Item specific name.

For example:

IS:Type

where Type is the actual Item Specific name in this case.

You can have as many columns as you want, each MUST start with IS:

No Each INDIVIDUAL column representing ONE Item Specific ONLY.

Use this format to specify value(s) for an Item Specifics as an INDIVIDUAL column:

Multiple values must be specified as: Value11|Value12|Value13 ... Value1n

Where

Value11, Value12, Value13 etc are the Values for the item specific

If Name is an eBay specific name, then, the Values must follow eBay specified rules for that name (Whether it accepts 1 value or more)

If Name is custom (non-eBay), then, only a single value must be specified

Multiple values for a name must be separated by |

For example,

RJ-11|RJ-12

Folder Name
FolderName
No Name of the folder in which to put the listing. If the folder does not exist, it will be created.
Force End Listing Before Auto Renewal No Valid values are:
  • true (or 1)
  • false (or 0)
The listing will be automatically ended if all of the following conditions are met at the time the listing is evaluated for ending:
  • The listing must be a Fixed Price Listing
  • Must be a GTC listing
  • Has no sale
ASIN No Amazon Standard Identification Number. 10 character, alpha numeric.
Mfg No Manufacturer
Amazon Title No Title to be used for Amazon
Amazon Description No Description to be used for Amazon
Amazon Bullet1 No Bullet1 to be used for Amazon
Amazon Bullet2 No Bullet2 to be used for Amazon
Amazon Bullet3 No Bullet3 to be used for Amazon
Amazon Bullet4 No Bullet4 to be used for Amazon
Amazon Bullet5 No Bullet5 to be used for Amazon
Amazon Platinum1 No Platinum1 to be used for Amazon
Amazon Platinum2 No Platinum2 to be used for Amazon
Amazon Platinum3 No Platinum3 to be used for Amazon
Amazon Platinum4 No Platinum4 to be used for Amazon
Amazon Platinum5 No Platinum5 to be used for Amazon
Amazon Keyword1 No Keyword1 to be used for Amazon
Amazon Keyword2 No Keyword2 to be used for Amazon
Amazon Keyword3 No Keyword3 to be used for Amazon
Amazon Keyword4 No Keyword4 to be used for Amazon
Amazon Keyword5 No Keyword5 to be used for Amazon
Amazon Generic Keywords No Generic Keywords to be used for Amazon
ThemeName No Name of the eBay theme to apply. The Listing Editor displays the list of available themes after you have selected a category.
DesignName No Name of the eBay design within the theme to apply. The Listing Editor displays the list of available designs after you have selected a category and a theme.
KTypes No Instead of entering all the Fitments as XML (please see below), you can also enter a comma separated or tab separated or blank separated list of KType numbers. Please note that not all eBay sites support KTypes.
Fitments No This column is an XML formatted string:

Example:

				<ItemCompatibilityList>
					<Compatibility>
						<NameValueList>
							<Name>Year</Name>
							<Value><![CDATA[1973]]></Value>
						</NameValueList>
						<NameValueList>
							<Name>Make</Name>
							<Value><![CDATA[Yamaha]]></Value>
						</NameValueList>
						<NameValueList>
							<Name>Model</Name>
							<Value><![CDATA[RD250]]></Value>
						</NameValueList>
						<NameValueList>
							<Name>Submodel</Name>
							<Value><![CDATA[Street Series 250]]></Value>
						</NameValueList>
						<REMARKS: ...one NameValueList node per name>
						<CompatibilityNotes><![CDATA[]]></CompatibilityNotes>
					</Compatibility>

					<REMARKS: ...more Compatibility nodes here>
				</ItemCompatibilityList>
				

Variations No This column is an XML formatted string:

Example:

				<Variations>
					<VariationNames>
						<Name>Color</Name>
						<Name>Memory (in GB)</Name>
					</VariationNames>
					<Variation>
						<VariationSpecifics>
							<Name>Color</Name>
							<Value>Red</Value>
							<Picture>F:\sampleimages\EX01.jpg</Picture>
						</VariationSpecifics>
						<VariationSpecifics>
							<Name>Memory (in GB)</Name>
							<Value>64</Value>
						</VariationSpecifics>
						<SKU>SKU-Red64</SKU>
						<StartPrice>400</StartPrice>
						<Quantity>6</Quantity>
						<UPC></UPC>
					</Variation>
					<Variation>
						<VariationSpecifics>
							<Name>Color</Name>
							<Value>Blue</Value>
							<Picture>F:\sampleimages\EX02.jpg</Picture>
							<Picture>F:\sampleimages\EX03.jpg</Picture>
							<Picture>F:\sampleimages\EX04.jpg</Picture>
							<Picture>F:\sampleimages\EX05.jpg</Picture>
						</VariationSpecifics>
						<VariationSpecifics>
								<Name>Memory (in GB)</Name>
								<Value>64</Value>
						</VariationSpecifics>
						<SKU>SKU-Blue64</SKU>
						<StartPrice>420</StartPrice>
						<Quantity>4</Quantity>
						<UPC></UPC>
					</Variation>
				</Variations>				
			

CF:<CustomFieldName> No CustomFieldName is the name of the custom field. If there is no existing custom field by the name specified, a new custom field with the specified name will be created.

For example:

CF:Surface finish specifies a custom field with the name as Surface finish. All blank spaces following the CF: and before the first character of the name are atripped. Similarly, all blank spaces following the name are stripped. Essentially, the custom field name cannot have blank spaces at the beginning or end of the name.