Instructions for revising items by ItemID using a CSV file

• If the item is a non-variation item:

  if SKU value is _delete_, then, the SKU is removed from the item. Otherwise, the item's SKU is updated with the specified value.

• If the item is a variation item:

  If SKU is specified, then the specified SKU must be a variation SKU. In this case, the variation is updated.

To remove sub title, set it's value to _delete_

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

Tools -> Options -> Description Templates

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

To remove Description Template used in the item, set the value to 0

To remove existing description, set the value to _delete_

To remove existing description, set the value to _delete_

Example value:

To remove existing condition description, set it's value to _delete_

Only numeric amount without the currency symbol must be specified.

If specified, must be 0 or greater

Example value:

123.89

• 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

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

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

To remove existing UPC, set the value to _delete_

To remove existing ISBN, set the value to _delete_

To remove existing thirteen digit ISBN, set the value to _delete_

To remove existing EAN, set the value to _delete_

To remove existing Brand, set the value to _delete_

To remove existing MPN, set the value to _delete_

To remove existing Storage Location Bin, set the value to _delete_

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:

Specify value ONLY for those positions that you wish to edit/delete. For example, to edit second picture, specify a new location for Picture 2.

To delete a specific picture, specfiy _delete_ as the picture path for that specific position. For example, to delete sixth picture, specify _delete_ as the value for Picture 6.

Tools -> Options -> Consignors

To remove an existing consignor, set the value to _delete_

Tools -> Options -> Consignor Policies

To remove an existing consignor policy, set the value to _delete_

For Variations item, this is the currently available quantity for the specified SKU. In this case, SKU also must be specified

• FixedPriceItem
• Auction

• A valid numeric number (in days)
• GTC

Available values for number of days is dependent on the eBay site and the category used.

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.

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.

To remove existing secondary category, set the value to _delete_

To remove an existing store category, set the value to 0

To remove an existing second store category, set the value to 0

For Fixed Price item, this is the fixed price.

For an Auction item, this is the starting price.

Must be specified without the currency symbol.

Example value:

19.99 For Variations item:

This is the price for the variation corresponding to the specified SKU. In this case, SKU also must be specified.

Must be specified without the currency symbol.

Example value:

19.99

Must be specified without the currency symbol.

Example value:

19.99

if specified without the % symbol.

Example value:

9.99

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

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

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

Must be specified without the currency symbol.

Example value:

19.99

Must be specified without the currency symbol.

Example value:

19.99

• New
• Used

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

Tools -> Options -> Storage Locations

• None
• Basic Style
• Retro Style
• Hidden

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 (;;)

To remove all existing values for a given name, set the value for that name as _delete_

For example,

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

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:

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

To remove all existing values for a given name, set the value for that name as _delete_

For example,

_delete_

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.