First steps  Trading  All about IT Problem solving

Structure of the CSV file for stock upload

In this section you will find information on

  1. How must the CSV file be formatted?
  2. Inventory data or header line in an Excel file
  3. Save as CSV in UTF-8 formatting

How must the CSV file be formatted?

Below you will find instructions on how to create valid CSV files that can be read by the BEARING X-GUI
can read. Any deviation from the instructions will result in invalid files that cannot be read correctly and cause errors.

Header

The header row must be defined in the first cell (A1) in the first row/column of the CSV file.

Important - Formatting of the CSV file:

  • The header must contain the following 11 parameters:       buySell;OrderType;quantity;pricePerUnit;minimumPartialQuantity;itemNumber;brand;location;productionYear;
    origin;articleNumber;fixedPrice
  • Each parameter must be separated by a semicolon
  • Each parameter must be written to the file exactly as shown above. They must not be enclosed in inverted commas (" ").
  • The UTF-8 character set must be used (see below: "3. Saving the CSV file as UTF-8 in Microsoft Excel")

The header is read by the BX GUI as Row[0] and the values are separated with ';' (semicolon).



Example of the header:
buySell;OrderType;quantity;pricePerUnit;minimumPartialQuantity;itemNumber;brand;location;productionYear;origin;
articleNumber;fixedPrice

This is what it looks like in an Excel file. You can download the BEARING X CSV template here.

Inventory data of the CSV file

The order data must be added starting with the first column of the second line. Each
order must be written in a separate line. Some order values are mandatory,
others are optional (see the following list for more details). Each line (order) must consist of up to 11 values,
separated by semicolons. Optional parameters can be left blank, mandatory parameters must be
parameters must be specified.

Column A: S for sell / B for buy

Column B (optional): Order or Bidding Request - IMPORTANT! If you leave this field empty, it will automatically be set as an order.

  • Column B Sell: Bidding_Request for a hidden minimum price
  • Column B Buy: Bidding_Request for a hidden maximum price

Column C: Number of units to be sold or bought

Column D: Price per unit (IMPORTANT! Decimal numbers are separated by a comma)

Column E: Minimum purchase quantity

Column F: Article description (type)

Column G: Brand

Column H: Country of your location

Column I (optional): Production year of the article

Column J (optional): Country of manufacture of the item

Column K (optional): Internal article number of your own company

Column L (optional): if nothing is entered, specific company conditions apply (general company surcharge/discount).

Save as CSV in UTF-8 formatting

It is important that CSV files are saved in UTF-8 format. It could be that your Excel settings
saves the file in UTF-8 BOM format. Files in this format appear to be accepted by the BEARING X CSV-order upload, the orders will NOT be displayed in the BEARING X GUI.
Please make sure that the CSV file is saved in the correct UTF-8 format. Here we show you how to set the correct format.

Please follow the steps below:

  • Open your CSV file or Excel file with a Microsoft Excel.
  • Navigate to the menu item File and click on Save as. The window will appear as shown on the right
  • Click Browse to select a location to save the file.
  • The Save As window appears as shown on the right.
  • Then enter the name of the file.
  • Select the option Save as type CSV (Comma delimited) (*.csv).
  • Click on the Tools drop-down field and then on Web options. A new window for the web options appears.
  • On the Encoding tab, select the Unicode (UTF-8) option from the Save this document as drop-down list.
  • Finally, click OK and save the file.

Information on CSV upload

  • All orders are displayed in EUR.
  • Never list your entire stock of an item on BEARING X if you offer this item on other sales channels.
    on other sales channels. This way you avoid double sales.
  • The order of the columns can be changed as required.
  • The default value of the "OrderType" column is Order

Optional: Check the CSV formatting using Notepad ++

  1. Open the Notepad++ editor (the free version can be downloaded from the Internet).
  2. Open file: File (graph: File) /
  3. Select the file you want to open.
  4. You will see the current encoding in the bottom right-hand corner. Check whether it is UTF-8.
  5. If so, you can close the file and upload it to BEARING X.
  6. If not, you will need to convert it: Select Encoding (graph: Encoding).
  7. Select "Convert to UTF-8" (graph: Convert to UTF-8).
  8. Save and close the file. It can now be uploaded to BEARING X.

<- back to All about IT