Introduction

This guide describes how to add a supplier to an existing IOM shop instance. It is addressed to IOM operators (e.g., an IOM administrator who has access to the whole system).

A questionnaire guides the target group to collect the necessary information in the run of the supplier configuration.

The guide does not cover any kind of supplier approval processes. So there is information on the following configuration tables in this document: 

• Supplier2ApprovalStateCodeDefDO

• Supplier2ApprovalStateCodeReasonDefDO

• Shop2Supplier2ApprovalTypeDefDO

Glossary

References

• Reference - IOM SOAP Web Services
• Concept - IOM Synchronization of Java-based Caches
• Overview - Intershop Order Management REST API
• Reference - IOM Database Documentation
• Reference - IOM ImpEx Interfaces

Prerequisite

To follow this guide, good experience with SQL is required. Also, an understanding of the retailing model between the shop and suppliers is helpful.

An essential parameter for the supplier configuration is the OMS internal ID of the OMS shop instance to which the new supplier should be connected. From now on this ID will be identified by <supplierid> and <shopid>.

Post Task

Questionnaire

Configuration

The following section describes how to add a new supplier to an existing shop instance.

Create a Supplier Instance

Basic Supplier Configuration

SupplierDO

The main entity of the supplier configuration is the database table SupplierDO. All other supplier-related configurations refer to this table.

For all available values, please see Overview - IOM Database Documentation.

-- create a supplier instance
INSERT INTO oms."SupplierDO"
(
	"id", "active", "contentSupplier", "countryCodeDefRef", "countryDefRef", 
	"cutOffTime", "deliveringSupplier", "legal", "modificationDate", 
	"name", "supplierName", "supportsReservation", "supportsResponse", 
	"singlePositionArticle", "internalSupplierName", "parentSupplierRef", 
	"cleanParentOnImport", "ignoreAdditionalPositions",
	"businessObjectProcessingDelay", "supplierTypeDefRef"
)
VALUES
(
	5000, TRUE, FALSE, 1, 29, 
	'14:30', TRUE, TRUE, now(), 
	'Flagship store - North', 'Store - North', FALSE, FALSE, 
	TRUE, 'warehouse_north', null, 
	TRUE, TRUE, 
	'15m', 2
);

SupplierContactDO

Shop2SupplierDO

The table Shop2SupplierDO defines the suppliers that are used by a shop. It defines the relation between a shop and a supplier. See  Guide - IOM Shop Onboarding | Supplier for detailed configuration.

Supplier-Related Configuration

The following section describes further configurations of a supplier, such as used tax type, charge types, and the location of the shop including currency.

Taxes

Taxes are essential to a business model.

Supplier2TaxTypeDefDO

Use the table to configure if the supplier insists on its own values for the taxes. If nothing is configured, the IOM-internal values are used. It is used by Order Placement - IOM to supplier.

SELECT "taxTypeDefRef" FROM oms."Shop2TaxTypeDefDO" WHERE "shopRef" = <shopId>

-- assign a tax type
INSERT INTO oms."Supplier2TaxTypeDefDO"
(
	"id", "supplierTaxTypeName", "taxTypeDefRef", "supplierRef"
)
VALUES
(
	nextval('oms."Supplier2TaxTypeDefDO_id_seq"'), 'FULL-TAX', 5, 5000
);

 TaxTypeDefDO

The table contains all tax types that are supported by the application by default. For all available values, please see Overview - IOM Database Documentation.

Country and Currency

In general, a supplier is located in a country that also determines the currency.

Supplier2CountryDefDO

Use the table to configure if the supplier insists on its own values for countries. It is used for order placement - OMS to supplier.

SELECT "countryDefRef" FROM oms."Shop2CountryDefDO" WHERE "shopRef" = <shopid>

-- assign a country
INSERT INTO oms."Supplier2CountryDefDO"
(
	"id", "countryDefRef", "supplierCountryName", "supplierCurrencyName", "supplierRef"
)
VALUES
(
	nextval('oms."Supplier2CountryDefDO_id_seq"'), 9, 'BELGIUM', 'EURO', 5000
);

CountryDefDO

The table contains all countries, including their assigned currencies and localization codes that are supported by the application by default. For all available values, please see Overview - IOM Database Documentation.

Payment

Payment is the process of money transfer from one party to another, e.g., customer to merchant.

Supplier2PaymentDefDO

Use the table to configure if the supplier insists on its own values for payment methods. Otherwise the property PaymentDefDO.name is used. The configuration is used by Order Placement - IOM to supplier (XML element "Sales" > attribute "method").

-- assign a payment
INSERT INTO oms."Supplier2PaymentDefDO"
(
	"id", "paymentDefRef", "supplierPaymentName", "supplierRef"
)
VALUES
(
	nextval('oms."Supplier2PaymentDefDO_id_seq"'), 10, 'PP', 5000
);

PaymentDefDO

The table contains all payment methods that are supported by the application by default. For all available values, see Overview - IOM Database Documentation.

Carrier and Delivery

A carrier is a company that transports products or services.

The delivery, therefore, defines forms (i.e., standard) and options (i.e., night shipping) the transport has to fulfill.

Supplier2CarrierDO

Use the table to configure if the supplier insists on its own values for the carrier. Otherwise the property CarrierDO.name is to be used. Please see Guide - IOM Shop Onboarding | Carrier for CarrierDO.

The configuration is used by SOAP ShopService method storeDispatch. See Dispatch transmission.

-- assign a carrier
INSERT INTO oms."Supplier2CarrierDO"
(
	"id", "supplierCarrierName", "carrierRef", "supplierRef"
)
VALUES
(
	nextval('oms."Supplier2CarrierDO_id_seq"'), 'DHL', 11, 5000
);

Supplier2DeliveryFormDefDO

This configuration contains the name of a delivery form, as used by the supplier, with reference to the IOM-internal delivery form. There is no usage by the IOM itself, but it can be useful for customization.

-- assign a delivery form
INSERT INTO oms."Supplier2DeliveryFormDefDO"
(
	"id", "deliveryFormDefRef", "supplierDeliveryFormName", "supplierRef"
)
VALUES
(
	nextval('oms."Supplier2DeliveryFormDefDO_id_seq"'), 20, 'FF', 5000
);

DeliveryFormDefDO

The table contains all delivery forms that are supported by the application by default. For all available values, please see Overview - IOM Database Documentation.

Supplier2DeliveryOptionDefDO

This configuration contains the names of delivery options, as used by the supplier, with reference to the IOM-internal delivery options. It is used by Order Placement - IOM to supplier (XML attribute name at element OrderPos > DeliveryOption).

-- assign a delivery option
INSERT INTO oms."Supplier2DeliveryOptionDefDO"
(
	"id", "deliveryOptionDefRef", "supplierDeliveryOptionName", "supplierRef"
)
VALUES
(
	nextval('oms."Supplier2DeliveryOptionDefDO_id_seq"'), 8, 'OVERNIGHT', 5000
);

DeliveryOptionDefDO

The table contains all delivery options that are supported by the application by default. For all available values, see Overview - IOM Database Documentation.

Supplier2DeliveryTypeDefDO

DeliveryTypeDefDO

The table contains all delivery types that are supported by the application by default. For all available values, see Overview - IOM Database Documentation.

Supplier Responses

After the IOM is sending a delivery request to a supplier, the supplier responds with a message. This message contains whether the supplier agrees (or partially agrees, or disagrees completely) to deliver the requested products including its conditions (i.e., prices).

Supplier2ResponseTypeDefDO

Supplier2ResponseStateCodeDefDO

The table is relevant if the supplier supports order responses and if the supplier insists on its own values for response state codes. Otherwise, the property name from table ResponseStateCodeDefDO is to be used.

It is used by Response Transmission.

-- assign a response state code
INSERT INTO oms."Supplier2ResponseStateCodeDefDO"
(
	"id", "responseStateCodeDefRef", "supplierResponseStateCodeName", "supplierRef"
)
VALUES
(
	nextval('oms."Supplier2ResponseStateCodeDefDO_id_seq"'), 1, 'OK', 5000
);

ResponseStateCodeDefDO

The table contains all response state codes that are supported by the application by default. For all available values, see Overview - IOM Database Documentation.

Returns

If a customer returns products that were delivered to the customer before, the products will arrive in a package at a supplier. The supplier will note this to the IOM using a return message.

The process of:

• requesting returns
• approving requests
• sending products
• receiving products
• and noting an arrival of returned products

requires several configurations of the supplier. Business processes are not mentioned here.

Supplier2ReturnTypeDefDO

The table contains the return types that should be supported by a supplier. It is used by the configuration table SupplierReturnAddressDO, the SOAP ReverseService method returnSlipRequestOMS, and returnSlipRequest. Also see Reference - IOM SOAP Web Services.

Using the column rmaNo will return this static RMA number in web services.

Using the columns rmaCode*, interval, startDate, minEndDate, and ejbLookup, supplier-specific RMA numbers can be generated.

For more information and all available return types, see Overview - IOM Database Documentation.

-- assign a return type
INSERT INTO oms."Supplier2ReturnTypeDefDO"
(
	"id", "returnTypeDefRef", "supplierReturnTypeName", "supplierRef", 
	"rmaNo", -- static rma number
	"preselected", "modificationDate",
	"rmaCodeCounter", "rmaCodeStart", "rmaCodeEnd", "interval", "startDate", "minEndDate", "ejbLookup" -- rma number generation
)
VALUES
(
	nextval('oms."Supplier2ReturnTypeDefDO_id_seq"'), 4, 'RET', 5000, 
	null,
	TRUE, now(),
	null, null, null, null, null, null, null
);

ReturnTypeDefDO

The table contains all return types that are supported by the application by default. For all available values, see Overview - IOM Database Documentation.

Supplier2ReturnReasonDefDO

The table contains the return reasons supported by the supplier and can be used if the supplier does not use the default internal return reasons. Also see Return Transmission.

If not configured, all IOM-internal return reasons are possible and displayed in a selection grouped by the return type at the OMT.

-- assign a return reason
INSERT INTO oms."Supplier2ReturnReasonDefDO"
(
	"id", "returnReasonDefRef", "supplierReturnReasonName", "supplierRef", "preselected"
)
VALUES
(
	nextval('oms."Supplier2ReturnReasonDefDO_id_seq"'), 307, 'WRONG_ITEM', 5000, FALSE
);

ReturnReasonDefDO

The table contains all return reasons that are supported by the application by default. For all available values, see Overview - IOM Database Documentation.

SupplierReturnAddressDO

The address specifies the location where a return shipment will be received.

It is used by the SOAP ReverseService method returnSlipRequest, return label creation, and shop customer mails. See Reference - IOM SOAP Web Services, Overview - IOM Customer E-Mails, and also  Overview - IOM Database Documentation.

-- assign a return address
INSERT INTO oms."SupplierReturnAddressDO"
(
	"id",
	"addressLine1", "addressLine2", "addressLine3", "addressLine4", "addressLine5",
	"supplier2ReturnTypeDefRef", "shop2SupplierRef"
)
VALUES
(
	nextval('oms."SupplierReturnAddressDO_id_seq"'),
	'Sports In Motion Warehouse', 'c/o Intershop Communications AG', 'Intershop Tower', '07740 Jena', 'Germany',
	10001, 15000
);

Supplier2ReductionUnitDefDO

If the supplier insists on his own identifiers for reduction units, configure this table. Additionally, set the property sendOrderCoupon