Instructions for revising quantity and price for active listings across multiple sites using a CSV file by SKU or eBay ID

Description

Use this file to revise (only Quantity and Price can be revised) active listings by specifying either SKU or the eBay Item ID. Multiple active listings (across different eBay sites) can be revised by specifying a SKU. Exchange rates to be applied across different sites are specified in a separate CSV file. The CSV file that specifies the exchange rates to apply must have the following columns:

List of valid column names in exchange rates CSV file

Column name Required? Remarks
Site ID or 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
ExchangeRate or Exchange Rate Yes Exchange rate as a multiple of base price. For example, if you would like to specify your base price in US dollars, then, for site US, exchange rate would be 1 and for Site UK, the exchange rate say would be 1.1 (which signfies that Euro is 1.1 times US dollar on the date of processing)

Processing logic

SKU specified? eBay Site specified? eBay Site is ANY? Action taken
Yes Yes Yes All active listings (across multiple eBay sites) with the specified SKU will be revised
Yes Yes No Only that active listing that is on the specified site will be revised
Yes No Not applicable If a single active listing is found, it will be revised. However, if more than one active listing is found, an error message is generated.
No Not applicable Not applicable If an active listing with the specified eBay ID is found, it will be revised.

Instructions:

List of valid column names

Column name Required? Remarks
SKU No Either SKU or eBay ID must be specified. If both are specified, eBay ID takes precedence and SKU is ignored.
eBay ID or eBayID No Either SKU or eBay ID must be specified. If both are specified, eBay ID takes precedence and SKU is ignored.
Site ID or SiteID No If specified, must be a valid eBay site ID or can also be ANY
Available Quantity or AvailableQuantity No At least one of Available Quantity or Base Price must be specified
Base Price or BasePrice No At least one of Available Quantity or Base Price must be specified. If specified, actual price is computed by multiplying this base price by the specified exchange rate for the listing site.(Exchange rates across sites are specified in a separate CSV file)