Importing eBay Accept, Decline and Start Prices

Overview
For auction listings, it is possible to specify accept, decline and start pricing so that no intervention is required. It is possible to import these into Linnworks so that they are automatically added to the listing when the linked stock item is listed or when the price is revised. This guide covers the basics of importing this pricing and then using expressions to specify accept and decline to price as a percentage of the starting price

Basic Accept, Decline and Start Pricing Imports

Accept and decline pricing can be imported using an Inventory Import. Prepare a CSV file with the following columns:

SKU BIN Price Accept Price Reject Price
RibenaLPinPas 1.25 1.20 1.19
  • Set up an Inventory Import and proceed to the column mapping screen
  • Map BIN Price to Price by Channel
    • Enter the Source as EBAY
    • Enter the appropriate SubSource
    • Leave the drop-down menu blank
  • Map Accept Price to Price by Channel
    • Enter the Source as EBAY
    • Enter the appropriate SubSource
    • Select ACCEPT from the dropdown menu
  • Map Reject Price to Price by Channel
    • Enter the Source as EBAY
    • Enter the appropriate SubSource
    • Select DECLINE from the dropdown menu
  • Click  Run Now

Start price can also be mapped in the same way via import. Note this price is for auction listing only.

Map Start Price to Price by Channel 

  • Enter the Source as EBAY
  • Enter the appropriate SubSource
  • Select START from the dropdown menu

Importing Accept and Decline Pricing Based on BIN Price

If you want to set your accept price based on a percentage of the BIN Price, this can be done on the data import itself. The decline price can be specified as 1 of the smallest unit of currency less than the accept price. For instance, in the UK, if the accept Price is £5.80, the decline price can be set at £5.79.

In order to do this, prepare a CSV file with columns for SKU, BIN Price and a column specifying the percentage of the BIN price you would be willing to accept, for instance, 90.

  • Set up an Inventory Import and map the BIN price as above
  • Click  Expression twice to create Expression 1 and Expression 2
  • Map Expression 1 to Price by Channel and map the Source, SubSource and the dropdown menu to ACCEPT
  • Edit the expression by clicking
    • Enter the following expression: N2[v{BIN Price}*(v{Accept Percent}/100)]
    • The N2[...] rounds the final value to two decimal places
    • If the Accept Percentage in the CSV file is given as a decimal, for instance, 0.9, then remove (v{Accept Percent}/100) and replace with just v{Accept Percent}
  • Map Expression 2 to Price by Channel and map the Source, SubSource and the dropdown menu to DECLINE
  • Edit the expression by clicking
    • Enter the same expression as the ACCEPT expression with -0.01 appended to the end, which sets the decline price to 1 penny less
    • For instance: N2[v{BIN Price}*(v{Accept Percent}/100)]-0.01
  • Click  Run Now