Skip to content

Data Import (Prices & Stock)

The Jarltech connector imports the price list and the stock levels as master data into the merchantCENTRAL platform. This page describes the configuration and the process of the import.

Scope

The data import (prices/stock) is separate from the order processing and the item synchronization. It supplies the platform with prices and stock; the item synchronization maintains descriptions, minimum order quantities, and supplier linkages via the API.

Overview

Import Import Code Content
Price List (Catalog) JARLTECH-CATALOG Vendor item no., quantity, short/long description, list/net price, manufacturer no./name, weight
Stock JARLTECH-STOCK Item number, manufacturer item number, available quantity

The data is written into the central Hub table ALN MC Supplier Data (supplier code JARLTECH).

No new item creation

The import does not create new Business Central items. It links the imported records to existing items via the manufacturer item number. The creation of new items is handled – if desired – via the central item creation of the Hub.

Configuration: Jarltech Import Setup

Open the Jarltech Import Setup page (via the Supplier Card → Setup or via search). The page contains two sections — Price List (Catalog) and Stock Data (Stock) — each with the same fields:

Field Description
Active Enables this import for scheduled and manual import runs.
Source Type Retrieval method: OAuth2 Blob (default), Azure Blob (SAS token), or HTTP Direct.
Source URL URL of the source file, e.g. https://account.blob.core.windows.net/jarltech/jarltech-catalog.csv.
Authentication Authentication status. For Azure Blob, click to enter the Function Key; for OAuth2 Blob, reference to the central merchantCENTRAL setup.
Status Current state: Ready, Inactive, Not configured, last import time with record count, or Last import failed.

Action: Test Connection — checks the access to the configured source.

→ Complete setup of the data source: Set up Azure Blob Storage

Run Import

You start the import on the Jarltech Dashboard via the Execute Import action. All imports with the status Active are processed.

Automatic import

Via the central import pipeline of the Hub, the import can also be run on a schedule. See Automatic Processing.

Process in Detail

Price Import (JARLTECH-CATALOG)

  1. Download of the CSV file via the configured method (OAuth2 Blob / SAS / HTTP).
  2. Encoding to Windows-1252 (ANSI) for correct umlauts.
  3. Line-by-line parsing with progress dialog (header row is skipped).
  4. Field mapping into ALN MC Supplier Data (vendor item no., prices, manufacturer, weight, descriptions).
  5. Linking to BC items via the manufacturer item number.
  6. Status maintenance: newly imported/updated records are set to Active; items no longer included (outdated) are set to Draft.

Stock Import (JARLTECH-STOCK)

  1. Reset quantities: All Jarltech quantities are first set to 0.
  2. Download and parsing of the stock file.
  3. Update of the available quantity per item.

File Formats

Price List (JARLTECH-CATALOG)

  • Separator: ";" (fields enclosed in quotation marks)
  • Encoding: Windows-1252 (ANSI)
  • First line = header row (is skipped)

Relevant columns (excerpt): vendor item no., quantity, short description, long description, list price, net price, manufacturer item no., manufacturer name, weight.

Stock (JARLTECH-STOCK)

  • Separator: ; (without quotation marks)
  • Encoding: Windows-1252 (ANSI)
  • Format: Item number;Manufacturer item number;Stock quantity

Encoding

Provide the files as Windows-1252 (ANSI). With UTF-8, umlauts may be read incorrectly.

Result & Verification

  • After the import, the Status field in the Import Setup shows "Imported \<n> records on \<date>".
  • You find the imported data in the Supplier Data List (ALN MC Supplier Data).
  • On errors, the last error message is shown in the status; for details, see the activity log.