The optional columns are not mandatory and can be left empty. However, they can provide useful information that makes the ordering process on both sides smoother.

Catalog

The catalog column can be used if offers are submitted in separate batches.

Name

The title of the product can be provided in the Name column.

Product classification

The Product classification column is mandatory for new products, however if you create an offer for a product that is already known on bol, the Product classification is not mandatory and can be left empty.

List price

Here you can enter the recommended retail price (RRP[FA24.1] or CAP). Please note that this is a recommendation and that bol will set the price for customers.

Note: All prices should only include a decimal point and 2 digits after the point; 10.00 for example.

Published price to dealer

Here you enter the Published Price to Dealer, this only applies to products within the music category.

Note: All prices should only include a decimal point and 2 digits after the point; 10.00 for example.

Release date

Specify the release date in the following format: YYYYMMDD, for example: 2027013

On backorder

Specify with a Y or N whether the product is on backorder.

 

Quantity on backorder

Here you can indicate how many items you have on backorder

Replenishment date

Specify the replenishment date of when you expect to have stock again in the following format: YYYYMMDD, for example; 20270131.

NPP Pallet

Here you can enter the purchase price per product that you will invoice to bol when we order a full pallet.

Important Note: Please indicate the price per product, not the total price for the full pallet. For example; if a product costs 12.50 euro, and there are 100 products on the pallet, please state 12.50 here and not 1250 euro.

Note: All prices should only include a decimal point and 2 digits after the point; 10.00 for example.

Quantity Pallet

Here you can indicate how many consumer units are on one pallet.

Other NPP and Quantity columns

For the other NPP and Quantity columns, the same applies as described above for NPP Pallet and Quantity Pallet.

  • Packing unit
  • NPP carton
  • Quantity Carton
  • NPP layer
  • Quantity layer
  • NPP truck
  • Quantity truck

Special columns

There are two columns that are only used in certain cases, your contact person will let you know how to fill these columns if you as supplier need to use the columns. These columns are:

  • Fulfillment supplier
  • Fulfillment ID