Solutions Marketplace

POWERBLOX

Flexible Item Import

Easily import vendor catalogues (excel) and keep your pricing and all item details up to date automatically

Importing data in Business Central can be done by using configuration packages. However, before upload you have to divide the data over the different Business Central tables and you have to prepare the excel-file with the correct fields. This implies a lot of extra work and has a high risk of human error. With Powerblox Flexible Item Import, you can define import templates that match the structure of your vendor catalogue. This Powerblox automatically checks and validates every new file before import.

Full Description

Create the import template
Link the fields in your Excel file to the right fields in Business Central. Find the right table and the correct fields and field numbers with an easy lookup functionality. You can add items to multiple tables and link fields to each other.

Import the Excel file
Each time your receive a new catalogue from your supplier, re-use your template. Do the mapping once and use the template many times without having extra manual work.

Get import result details
Powerblox Flexible Import automatically checks and validates the file before import. After the import, the number of imported records (inserted or updated) is shown.

USP

Key features

  • Create your template according to your vendor Excel data file
  • Automatic and quick validation of excel data before import
  • Optionally distinguish stock items from non-stock items.
  • Easy import of the Excel file

Keywords

Excel import

Vendor catalogue

Import template

Automated import

Validation

Specifications

Language(s)

Dutch

English

French

Countries

Czech Republic

Denmark

The Netherlands

The United Kingdom

Finland

France

Germany

Hungary

Iceland

Italy

Norway

Poland

Portugal

Spain

Sweden

Industry

All (Horizontal)

Product(s)

D365BC

D365BC SAAS

Retail price range €

! Based on average customer

From 10€

To 20€

Implementation time

! Based on average customer

1-8 hours

Complexity

Easy

(No training required)

You can buy this solution directly with your Companial account. If you don’t have the account register here. Or find out more information about how to order a solution through our marketplace here