Skip to main content

Import product product.nv

Resource: product.nv

HTTP-method: POST

Note! If you are using Rackbeat inventory management in Netvisor, the API documentation can be found here: https://support.netvisor.fi/en/articles/766869-rackbeat-stoplight-api

For extended product management, a new product can be imported via the interface as described below, but updating products via the interface is not supported with extended product management.

Parameters used in the request (QueryString):

Parameter

Occurs

Description

Example

method

1

add or edit

add

id

0..1

If method is edit, the id of the product to be edited is required

123

useonlyexistingdimensions

0...1

Prevents automatic creation of new cost object headers and cost objects. Returns an error if the given cost object does not exist.

1 = prevention enabled

1

If method has not been set or the product to be updated is not found in the system, an INVALID_DATA error with further details is returned. The id for the product to be updated can be obtained by first requesting the product list.

Product information can be accurately represented using new weight fields (productnetweight, productgrossweigh and productweightunit). It is recommended not to use the old product weight field (unitweight) anymore. The field can still be used for backward compatibility, but in the user interface all existing product weight units will change to kilograms (kg) and be expressed in the net weight field.

Please note when importing and editing product information that it is possible to create several products in Netvisor with the same product code.

The data to import is sent with the request as an XML with the following structure (POST data):

Level

Element

Type

Occurs

Description

Example

Root

root

Aggr.

1

1

product

Aggr.

1

2

productbaseinformation

Aggr.

1

3

productcode

String, max 50 characters

0...1

Product code

CC

3

productgroup

String

1

Product group name, product is added to the group if the product group is found in the system. If it is not found, it will be created

Books

3

name

String, max 200 characters

1

Product name

Code Complete

3

description

String

0...1

Description

Second edition

3

unitprice

Numeric

1

Product unit price

42,5

Attr.

type

String

1

Indicates whether the given price is gross or net.

net

3

unit

String, max 50 characters

0...1

Product unit, if the given unit is not found in the system it will be created. If it is found, the existing one is used.

pc

3

unitweight

String

0...1

Product unit weight with two decimals. It is recommended not to use this weight field (unitweight) anymore, but to use new weight fields (productnetweight, productgrossweigh and productweightunit)

1,00

3

purchaseprice

Numeric

0...1

Purchase price

25

3

tariffheading

String

0...1

Tariff heading

Code complete

3

comissionpercentage

Numeric

0...1

Commission percentage

11

3

isactive

Numeric

1

Is the product active, 0 = inactive / 1 = active

1

3

issalesproduct

Numeric

1

Is the product a sales product, 0 = no / 1 = yes

0

3

inventoryenabled

Numeric

0...1

Is the product stored in stock, 0 = no / 1 = yes

1

3

inventorybatchlinkingmode

Numeric

0...1

Batch processing type. Allowed values:

No batch processing = 1

Manual batch selection = 2

Newest first by delivery date = 3

Oldest first by delivery date = 4 (FIFO)

Newest first by use-by date = 5

Oldest first by use-by date = 6

Newest first by manufacturing date = 7

Oldest first by manufacturing date = 8

4

3

countryoforigin

String

0...1

Country of origin

FI

Attr.

type

String

0...1

Always ISO-3166

ISO-3166

3

primaryeancode

String

0...1

Product primary EAN code

123456789012

Attr.

type

String

0...1

EAN code type. The interface checks the format of the EAN code according to the type.

any, ean8, ean13, code128.

ean13

3

secondaryeancode

String

0...1

Product secondary EAN code

12345689012

Attr

type

String

EAN code type. The interface checks the format of the EAN code according to the type.

any, ean8, ean13, code128.

ean13

3

inventoryalertlimit

Numeric

0...1

Alert limit

20,50

2

productbookkeepingdetails

Aggr.

0...1

3

defaultvatpercentage

Numeric

1

Vat rate, if the given tax rate is not found in the system an error is returned

24

3

defaultdomesticaccountnumber

Numeric

0...1

Domestic sales account

3000

3

defaulteuaccountnumber

Numeric

0...1

EU sales account

3360

3

defaultoutsideeuaccountnumber

Numeric

0...1

Sales account outside the community

3380

2

productadditionalinformation

Aggr.

0...1

3

productnetweight

Numeric

0...1

Net weight

11,2

3

productgrossweight

Numeric

0...1

Gross weight

12,6

3

productweightunit

String

0...1

Net and gross weight unit: g, kg or tn

kg

3

dimension

Aggr.

0...1

4

dimensionname

String

1

Cost object header name. Created if needed.

Project

4

dimensionitem

String

1

Cost object. Created if needed.

Project 1

4

dimensionitemcode

String

0...1

Cost object code

(when this is given, the dimensionitem element is ignored)

DIMC-001

4

dimensionitemname

String

0...1

Cost object name

(when this is given, the dimensionitem element is ignored)

Item Name 1

3

productpackageinformation

Aggr.

0...1

4

packagewidth

Numeric

1

Package width in centimeters

7,3

4

packageheight

Numeric

1

Package height in centimeters

15,0

4

packagelength

Numeric

1

Package length in centimeters

36,1

2

productcustomtags

Aggr.

0..1

3

productcustomtag

Aggr.

1...n

4

tagname

String

1

Additional information field name.

Date field

4

tagvalue

String

1

Additional information field value.

2022-01-01

Attr.

datatype

String

1

Additional information field type. date, text, decimal or enum

date

This article has been translated using an AI-based translation tool. The contents or wording of these instructions may differ from those in other instructions or in the software.

Did this answer your question?