Product number (new, change and cancellation)

Description

Flow describing creation, change and cancellation of Product number in Extend Commerce backend.

Upon setup of new product number, the message sequence is first product number and then packaging. When product number is changed, packaging can be sent separately.

There is no response from Extend Commerce WMS and it is not possible to request information.

Triggering of message

Triggering is in case of an event in Extend Commerce Backend e.g. as below:

New product number: If creation of product - Warehouse connection (WMS) for a client.

Change product number: If connection of product - Warehouse connection (WMS) for a client is existing, then a change will take place regardless of changed fields.

Cancellation of product number: If connection of product - Warehouse connection (WMS) for a client is removed, then a cancellation message is sent to WMS

Demands

  • To change/cancel an product number the unique identity must be already existing.
  • To cancel an product number the physcal balance must be set to "0".
  • ProductGroup must be existing in WMS for each client. Only the shortnamne is used for each client.

 

Specification

XML Structure

LXIRProduct (1)

LXIRProduct\Envelope (1)

Attribute

Code

Mand.

Explanation

Extend Commerce Backend

WMS

FromPartner


Y

From system

X

X

FromPartnerUser


Y

From system/Client

X

X

ToPartner


Y

To system

X

X

ToPartnerUser


Y

To system/Client

X

X

DateTume


N

Date/Time when message was created (YY-MM-DD hh:mm)

X

X

ReferensNumber


Y

Message reference no

X

X

InterchangeTest


N

Indicating test message




LXIRProduct\Header (1-999)

LXIRProduct\Header\HeaderInfo (1)

Attribute

Code

Mand.

Explanation

Extend Commerce Backend

WMS

DocumentNumber


Y

Ordermessage reference no

X

X

DocumentName

Product

Y

Ordermessage name: Product

X

X


LXIRProduct\Header\Product (1)

LXIRProduct\Header\Product\ProductInfo (1)

Attribute

Code

Mand.

Explanation

Extend Commerce Backend

WMS

ProductId


Y

Product no

X

X

ProductName


Y

Product name

X

X

ProductGroup


N

Product group

X

X

OwnerNumber


Y

Client belonging, e.g NASE(WMI)

X


IntrastatCost


N

Custom value


X

ItemLoadType


N


X

X

ProductType


N*

Has to be set as 3 for ”Value added service”

X

X

UNNumber


N

UNNumber, Dangerous goods

X

X

EAN


N

EAN number

X

X

ThermoTransport


False
True

Y

Heat transportation
Product does not require thermo transport
Product requires thermo transport

X

X

ThermoDescription


N

Free textfield for thermo transport

X

X

ClassAdr


N

Classification, dangerous goods

X

X

LimitedQuantity


False
True

N

Limitedquantity, dangerous goods

X


MarinePollutant


False
True

N

Dangerous goods, marine transport

X

X

ClassAdrFreeQuantity


False
True

N

Limitedquantity, dangerous goods (classification)

X

X

ClassAdrDescription


N

Classification, fee textfield, Dangerous goods

X

X

IMDG


N

IMDG code, dangerous goods

X

X

ClassAdrPackageGroup




X

X

CountryOfOrigin


N

Country origin

X

X

CustomsCommodityCode


N

CustomsCommodity

X

X

CompanyGroupId


N

Shortname Goods owner / group

X

X

WarehouseInstruction


False

N

Instructions for the product to the warehouse

X

X

ClassAdrFlashpoint


N

Flashpoint in dgrees Celsius

X

X

ClassAdrTransportCategory


N

TransportCategory  ADR E0 E1 E2 E3 E4

X

X

VisibilityType


N

Values

AlwaysVisible

NonPublic

X

X


LxirProduct\Header\Product\ProductDescriptions(0-x)

Attribute

Code

Mand.

Explanation

Extend Commerce Backend

WMS

Function





Description 1

Description 2

Description 3

Description 4

HandleDate
HandleBatch

HandleSerial

HandleIdlabel

PickInPackageUnitOnly


Y




Y

Y

Y

N

Handle Date (Expire date)

Batchnumber handling

Serienumber handling

Id Label ()

PickInPackageUnitOnly (BasePackageQuantity)

1/0 = (true/false)
Receiving stop number of days(enbart  HandleDate)
Pick stop number of days(enbart HandleDate)

“”

X




X

X

X

X


X




X

X

X

X


LXIRProduct\Header\Product\ProductAdditions (1)

Attribut

Code

Mand.

Explanation

Extend Commerce Backend

WMS

OperationCode


1
2
3

Y

Operation

1 = Setup new product
2 = Change of product
3 = cancellation of product

X

X


LXIRProduct\Header\Package (0-1)

LXIRProduct\Header\Package\PackageInfo(1)

Attribute

Code

Mand.

Explanation

Extend Commerce Backend

WMS

ProductId


Y

ProductId

X

X

PackageId


Y

PackageId

ST = Unit

X

X

BasePackageId

ST

N

BasepackageId

X

X

BasePackageQuantity


N

Packagesize, e.g. amount of bottles in a carton

X

X

Weight


Y

Wight in Gram

X

X

Length


N

Length in cm

X

X

Width


N

With in cm

X

X

Height


N

Hight in cm

X

X

PackageName


Y

Packagename e.g Bottle

X

X

MeasurePackageId


N

MessurePackageId

X

X

MeasurePackageQuantity


N

MeasurePackageQuantity

X

X







LXIRProduct\Header\Product\PackageAdditions (1)

Attribut

Code

Mand.

Explanation

Extend Commerce  Backend

WMS

OperationCode


1
2
3

Y

Operation

1 = setup new packaging for product
2 = change of packaging for product
3 = cancellation of packaging for product

X

X

Note for BasePackageId

Need to have the same basepackage in Extend Commerce Backend and WMS.

Note for WEIGHT, LENGTH, WIDTH and HEIGHT

The only units available in WMS is cm and gram without decimal separation.

BasePackageQuantity

Minimum pickable device. e.g. the number of bottles in a carton.

If an item is stocked both in one piece and in multiple packaging, this is handled as two separate item numbers.

Cancellation

In case of cancellation of an item, only the Product item is sent. The package element will then be automatically canceled


Example

LXIRProduct

<?xml version=”1.0” encoding=”utf-8” ?>

- <LXIRProduct>

  <Envelope FromPartner=”XOE” FromPartnerUser=”KERAKOLL” ToPartner=”EWS” ToPartnerUser=”KERAKOLL” DateTime=”2008-02-06 14:08” ReferensNumber=”1” />

- <Header>

  <HeaderInfo DocumentNumber=”0011” DocumentName=”Product” />

- <Product>

  <ProductInfo ProductId=”005144” ProductName=”HINK 20 L VIT” ProductGroup=”Tillbehör och verkty” OwnerNumber=”KERAKOLL” IntrastatCost=”11.5000” ItemLoadType=”” ProductType=”” UNNumber=”” EAN=”” ThermoTransport=”False” ThermoDescription=”” ClassAdr=”” LimitedQuantity=”False” MarinePollutant=”False” ClassAdrFreeQuantity=”False” ClassAdrDescription=”” IMDG=”” ClassAdrPackageGroup=”” CountryOfOrigin=”SE” CustomsCommodityCode=”” CompanyGroupId=”GRP01” WarehouseInstruction=”Måste packas i kartong” ClassAdrFlashpoint=”” ClassAdrTransportCategory=””

 />

 <ProductDescriptions Function=”HandleDate” Description1=”0” Description2=”0” Description3=”0” Description4=”” />

  <ProductDescriptions Function=”HandleBatch” Description1=”0” Description2=”0” Description3=”0” Description4=”” />

  <ProductDescriptions Function=”HandleSerial” Description1=”0” Description2=”0” Description3=”0” Description4=”” />

  <ProductDescriptions Function=”HandleIdLabel” Description1=”0” Description2=”0” Description3=”0” Description4=”” />

  <ProductAdditions OperationCode=”2” />

  </Product>

- <Package>

  <PackageInfo ProductId=”005144” PackageId=”ST” BasePackageId=”ST” BasePackageQuantity=”1” Weight=”0” Length=”0” Width=”0” Height=”0” PackageName=”ST” />

  <PackageAdditions OperationCode=”2” />

  </Package>

  </Header>

  </LXIRProduct>