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:
|
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:
|
UseeBayCatalog | No | Valid values for this column are:
|
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 |
Picture1 Picture 1 Picture Loc1 |
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. |
Picture2 Picture 2 Picture Loc2 |
No | Second picture. |
Picture3 Picture 3 Picture Loc3 |
No | Third picture. |
Picture4 Picture 4 Picture Loc4 |
No | Fourth picture. |
Picture5 Picture 5 Picture Loc5 |
No | Fifth picture. |
Picture6 Picture 6 Picture Loc6 |
No | Sixth picture. |
Picture7 Picture 7 Picture Loc7 |
No | Seventh picture. |
Picture8 Picture 8 Picture Loc8 |
No | Eighth picture. |
Picture9 Picture 9 Picture Loc9 |
No | Ninth picture. |
Picture10 Picture 10 Picture Loc10 |
No | Tenth picture. |
Picture11 Picture 11 Picture Loc11 |
No | Eleventh picture. |
Picture12 Picture 12 Picture Loc12 |
No | Twelveth picture. |
ConsignorID Consignor ID |
No | Unique ID assigned to the consignor. If entered, must also specify Consignor Policy Name column. The ID must
already be of an existing consignor. If specified and valid, then, Consignor Name column is ignored. You can create consignors using WL main menu option: Tools -> Options -> Consignors |
Consignor Name ConsignorName |
No | Name of the consignor. Will be ignored if a valid ConsignorID is also specified. If entered, must also specify Consignor Policy Name column. The name must
already be an existing consignor. You can create consignors 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 |
Available Quantity AvailableQuantity Quantity |
Yes | Quantity to list. |
Listing Type Format |
Yes |
Valid values are:
|
Duration | Yes |
Valid values are:
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 |
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 |
Use Tax Table UseTaxTable |
No |
Valid values are:
|
Do Not Use Tax Table DoNotUseTaxTable |
No |
Valid values are:
|
Private Listing PrivateListing Private Auction PrivateAuction |
No |
Valid values are:
|
eBay User ID eBayUserID |
Yes | eBay User ID of the seller creating this listing |
Site ID SiteID |
Yes |
Valid eBay Site IDs are:
|
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:
|
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:
|
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:
|
Gallery Type GalleryType |
No | Valid values for Gallery Types are:
|
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 Names FolderNames |
No | Comma separated list of folder names of each of the folder in which to put the listing. If any of the folder names does not exist, it will be created. if specified, Folder Name> column is ignored. |
Folder Name FolderName |
No | Name of the folder in which to put the listing. If the folder does not exist, it will be created. If Folder Names column is also specified, then, this column is ignored. |
Force End Listing Before Auto Renewal | No |
Valid values are:
|
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 |
ScheduleTime | No | Date and time at which to schedule this listing. Wonder Lister scheduling is used. The date and time should be in local date/time format like 04/04/2016 09:15:00. Typically, date/time format style YYYY-MM-DD HH:MM:SS works on most systems. Suggested approach is to try on one or two listings first. |
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. |
ManufacturerId Manufacturer Id |
No | Id of the Manufacturer. This is an integer value greater than zero. |
HazmatId Hazmat Id |
No | Id of the Hazmat. This is an integer value greater than zero. |
ProductSafetyId Product Safety Id |
No | Id of the Product Safety. This is an integer value greater than zero. |
EnergyEfficiencyLabelId Energy Efficiency Label Id |
No | Id of the Energy Efficiency Label. This is an integer value greater than zero. |
RepairScore Repair Score |
No | Repair Score. This is an decimal value greater than or equal to zero. The value specified will be rounded off to a single decimal digit. |
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> <OriginalPrice>400</OriginalPrice> <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> <OriginalPrice>400</OriginalPrice> <Quantity>4</Quantity> <UPC></UPC> </Variation> </Variations> |
Invalid Fields | No | When a column name is not one of the column names explained above, it is ignored. |