Marketplaces > Marketplaces T-Z > Wehkamp > CHANNEL SHEET: WEHKAMP CONSIGNMENT

CHANNEL SHEET: WEHKAMP CONSIGNMENT

TIP:
Use the integration guide to integrate new channels and refer to this Channel Sheet whenever the guide prompts you to.

This Channel Sheet contains all channel-specific information for Wehlamp.nl.

CHANNEL BASICS

The following channels are available for Wehlamp.nl:
 

CHANNEL

SIGN

ID

CURRENCY

wehkamp.nl Consignment (This is the main channel)

wknl

98

EUR

wehkamp.nl (order)

wfnl

99

EUR

wehkamp.nl (return)

wrnl

146

EUR

 

PRELIMINARY INFORMATION

•New to TB.One? Our webinars help you find your way around the software.

•The channel provides a test system (sandbox). While you're in the integration phase, use it to check how your content will look.

•Send your supplier/access data for the channel to your Solution Delivery Manager at Tradebyte.

•Provide your product data in Dutch.

•As the stock is completely controlled by Wehlamp.nl, no special stock configuration is required. The inventory currently available at Wehlamp.nl is imported into TB.One once a day. The provided stock data is stored in the warehouses "Wehkamp (ok)" and "Wehkamp (nok)" which indicate salable and non salable articles. You can view your stock either in the article detail view in the section "Stock" or in the article list in the mini-box that opens at mouse-over.

•At Wehlamp.nl you can create links between your products. These links will be shown in the shop (for example as an upselling option). Click here to learn how to create and configure links between products.

•Do not change IDs or article numbers after a product has gone live on Wehlamp.nl.

•Do not change the product/article structures after the initial export.

•Do not use brand names in the products' designations.

CHANNEL-SPECIFIC SETTINGS, FEATURES, AND PROCESSES

REFERENCE NUMBER

CHANNEL-SPECIFIC INSTRUCTIONS

B-01: Payments

Find your payment methods at "Basic data > Payment > Payment methods".

Payments are managed by Wehlamp.nl. When the channel is activated or, at the latest, when the first order comes in, a payment method with the channel name is created automatically. For the export to an ERP-system, you can freely select an export key.

D-01: Product designation

The length of the product designation is limited to 16 characters.

D-02: Special text

Wehlamp.nl does not use the field "Special text".

D-03: Description

The length of the product description is limited to 3000 characters.

D-04: Components

The following components are mandatory at Wehlamp.nl:

•Kleur/kleurNummer/KleurOmschrijving (colour with mapping on a values list, colour number with a separate colour number table, colour description where your colours are taken over)

•Maat/presentatieMaat/wehkampMaat/ wehkampPresenatieMaat (size whereas maat/presentatieMaat transfer your values if wanted and wehkampMaat/wehkampPresenatieMaat do have values lists with mapping)

•materiaalOmschrijving (material with values list)

Normally one component each for colour and size should be enough to fulfil the mapping.

D-05: Attributes

The following attributes are mandatory at Wehlamp.nl:

•Geslacht (gender)

E-01: Article numbers

Provide the following article numbers:

•Article number

•EAN

•Secondary article number

•Manufacturer's article number

E-02: Shipping information

You do not need to enter shipping information such as package dimensions or weight for Wehlamp.nl.

Since Wehlamp.nl handles the entire order fulfillment process, no shipping configuration is required.

E-03: Variant dimensions

The following requirements apply for variant dimensions:

•Size

•Color

F-01: Media

•Provide images in a commonly used format such as png or jpg.

•Number: min. 1 article image

•Size: no size requirement

•Resolution: no DPI requirement

G-01: Carrier

As the order processing is managed entirely by Wehlamp.nl, no further shipping configuration is necessary.

G-02: Delivery note

As the order processing is managed entirely by Wehlamp.nl, no further shipping configuration is necessary.

G-03: Invoice

As the order processing is managed entirely by Wehlamp.nl, no further shipping configuration is necessary.

G-04: Proposed return code

As the order processing is managed entirely by Wehlamp.nl, no further shipping configuration is necessary.

G-05: Delivery documents in package

As the order processing is managed entirely by Wehlamp.nl, no further shipping configuration is necessary.

G-06: Refund deduction

As the order processing is managed entirely by Wehlamp.nl, no further shipping configuration is necessary.

G-07: Return causes

As returns are managed entirely by Wehlamp.nl, it is not necessary to provide return information in your basic data.

X-01: Size grid

Wehlamp.nl does not use size grids.

X-02: Base prices

No base prices are required at Wehlamp.nl.

X-03: Categories

For a complete list of all categories, go to "Channels > Wehkamp.nl > Categories".
Channels change their categories from time to time. Any major changes will be announced in TB.One. Outdated categories are highlighted with a red icon. Move all affected products to valid categories.

ATTENTION:

▪In contrast to other channels, Wehlamp.nl creates categories and values lists only after the transfer of your master data via a PANDA file (during integration). The PANDA export can take place without the activation of products and without channel-specific data maintenance. In the PANDA file, you simply compile a representative cross-section of your range. Always delete any articles/products that you do not wish to list on Wehlamp.nl, and remove all information about other channels (if applicable). Before your GoLive with Wehlamp.nl, your data is always manually prepared in accordance with the requirements of the channel.

X-04: Value mapping

Map values at the global level for Wehlamp.nl.

X-05: Pending orders

Wehlamp.nl does not transmit pending orders.

X-06: Partial deliveries

As returns are managed entirely by Wehlamp.nl, it is not necessary to provide return information in your basic data.

X-07: Commission group

Wehlamp.nl does not use commission groups.

X-08: Service logos

Wehlamp.nl will not display service logos you transfer in the shop.

X-09: Error and status messages

Wehlamp.nl does not provide error and status messages.

X-10: Templates

At Wehlamp.nl you cannot use templates.

X-11: Text configurator

The text configurator cannot be used for Wehlamp.nl.

X-12: Product text profile

Product text profiles cannot be used for Wehlamp.nl.

X-13: Title profile

You can use title profiles to configure the product titles shown in the channel's shop. For more information on title profiles, click here.

X-14: Cross prices

You can indicate cross prices for Wehlamp.nl by filling in the field MSRP.

SPECIAL REQUIREMENTS

Order processing for Wehkamp.nl Consigment:

 
There is no real order processing for Wehlamp.nl, as the channel's business model is similar to a shop-in shop solution. At Wehlamp.nl you send inventory to the channel in advance. The channel is then responsible for the entire sales process. Once a day, the current stock for each article will be reported to you via TB.One.

The channel will report sales and returns to you in the same way, on a daily basis. You can view them in the Wehlamp.nl order list. They are imported into TB.One as completed orders, so you need to set the order list's filter "Channel" to "Wehlamp.nl" and the filter "Status" to "All" or "Completed". These files may also be transferred to your system in the TB.Message format.

Announce that you would like to send goods to the channel by providing a so-called "Advanced Shipping Note". If you would like to have goods returned to you from the channel's warehouse, create a returns order for the channel.

How to create a advanced shipping note

If you would like to stock articles at Wehlamp.nl, a notification (Advanced Shipping Note = ASN) has to be sent to the channel first. To create that advanced shipping note you have to provide an order in the TB.Order XML format on your Tradebyte FTP.

ASNs are only exported to the channel if all included articles are already known in the channel's system, i.e. if they were successfully sent to the channel as part of a product data catalogue. If this is not the case, the message "ASN wasn't exported to the channel because no reference to yyyyyyy was found for article xxxxxxxx" will be displayed in the order and the entire ASN will not be exported to the channel.

It is important that you send the order as "pending" (approved=0). You also need to provide a specific channel name for that order: (<CHANNEL_SIGN>wfnl</CHANNEL_SIGN>).
 

Example XML:

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

<ORDER_LIST>
<ORDER>

 <ORDER_DATA>

         <ORDER_DATE>2013-09-30</ORDER_DATE>

         <CHANNEL_SIGN>wfnl</CHANNEL_SIGN>

         <CHANNEL_ID>12345</CHANNEL_ID>

         <CHANNEL_NO>12345</CHANNEL_NO>

         <APPROVED>0</APPROVED>

         <ITEM_COUNT>1</ITEM_COUNT>

         <TOTAL_ITEM_AMOUNT>99.99</TOTAL_ITEM_AMOUNT>

 </ORDER_DATA>

 <SHIP_TO>

         <CHANNEL_NO>112233</CHANNEL_NO>

         <NAME>Wehkamp.nl</NAME>

         <STREET_NO>Edisonstraat 5</STREET_NO>

         <ZIP>7701 BT</ZIP>

         <CITY>Dedemsvaat</CITY>

         <COUNTRY>NL</COUNTRY>

 </SHIP_TO>

 <ITEMS>

         <ITEM>

                 <CHANNEL_ID>1</CHANNEL_ID>

                 <SKU>11111-22222</SKU>

                 <EAN>123456789012</EAN>

                 <QUANTITY>10</QUANTITY>

                 <BILLING_TEXT>your article name</BILLING_TEXT>

                 <ITEM_PRICE>00.01</ITEM_PRICE>

                 <SERVICES>

                         <SERVICE>

                                 <CODE>pakketId</CODE>

                                 <DESC>12345</DESC>

                                 <PRICE>0</PRICE>

                         </SERVICE>

                         <SERVICE>

                         <CODE>transportMiddel</CODE>

                                 <DESC>box</DESC>

                                 <PRICE>0</PRICE>

                         </SERVICE>

                 </SERVICES>

         </ITEM>

 </ITEMS>

</ORDER>
</ORDER_LIST>

 

 

 

 

 
<!--Unique per shipment->

<!--Unique per shipment->

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

<!--Shipcode->

 

 

 

 

 

<!--pallet, container or box->

 

Your order file should list all articles you are planning to send to the channel. Store the file in the FTP in-directory. Once TB.One has processed the file, you will see a new entry in the order list of <%KANAL%> (order) (status filter on "pending"). Then pack the goods and ship them to Wehlamp.nl. One ASN file should correspond to one physical shipment. The node <CHANNEL_NO> should contain a unique order number that Wehlamp.nl uses to match the shipment and the ASN. This number must be numeric and must not exceed 7 digits.

The ASN must contain a <SERVICES> node for each article, in which the ship code and shipping type of the shipment must be transferred.

Receive stock informarion

Once Wehlamp.nl has received your goods, they will book the stock and send a corresponding stock information file. TB.One imports these files once a day at 10:00 pm. The stock is imported into two external warehouses: "wehkamp (ok)" and "wehkamp (nok)". The current stock can be checked at several places in TB.One.

1.Menu "Articles > Article list": Hover your mouse over the displayed stock number. A mini-box will open, informing you which stock is taken into account for which channel.

2.Product detail view: The tab "Article data" includes three sub tabs, one of which is "Stock data".

3.Article detail view: A section listing all warehouses with current stock numbers can be found in each article's detail view.

Stock in the "wehkamp (nok)" warehouse is probably no longer salable. Please contact the channel to reach an agreement on how to proceed with such articles.

Receive sales & returns

Once your stock has been registered at Wehlamp.nl and your articles are listed in the web shop, the channel will sell them and receive returns. The Sales & Returns Reports are sent to TB.One daily and are listed as regular orders in the order list for the channel Wehlamp.nl. The orders are imported as completed orders, because the goods were already shipped/returned and there is no further processing required. As, by the default setting, the order list is filtered for open orders, you will have to set the filter "Status" to "All" or to "Complete".

 

You can reclaim the goods stored at the channel at any time. To do that, submit an order in the TB.Order XML format on your Tradebyte FTP. This order hast to be set to pending (approved=0). The channel defined for returns requests in TB.One is Wehlamp.nl (return) (<CHANNEL_SIGN>wrnl</CHANNEL_SIGN>). If you reclaim a colour variant, all sizes must be included. You will find an example XML:

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

<ORDER_LIST>
<ORDER>

 <ORDER_DATA>

         <ORDER_DATE>2015-09-30</ORDER_DATE>

         <CHANNEL_SIGN>wrnl</CHANNEL_SIGN>

         <CHANNEL_ID>12345</CHANNEL_ID>

         <CHANNEL_NO>12345</CHANNEL_NO>

         <APPROVED>0</APPROVED>

         <ITEM_COUNT>4</ITEM_COUNT>

         <TOTAL_ITEM_AMOUNT>99.99</TOTAL_ITEM_AMOUNT>

 </ORDER_DATA>

 <SHIP_TO>

         <CHANNEL_NO>112233</CHANNEL_NO>

         <NAME>Wehkamp.nl</NAME>

         <STREET_NO>Edisonstraat 5</STREET_NO>

         <ZIP>7701 BT</ZIP>

         <CITY>Dedemsvaat</CITY>

         <COUNTRY>NL</COUNTRY>

 </SHIP_TO>

 <ITEMS>

         <ITEM>

                 <CHANNEL_ID>1</CHANNEL_ID>

                 <SKU>11111-22222</SKU>

                 <EAN>123456789012</EAN>

                 <QUANTITY>10</QUANTITY>

                 <BILLING_TEXT>TShirtJoeRedS</BILLING_TEXT>

                 <ITEM_PRICE>00.01</ITEM_PRICE>

         </ITEM>

         <ITEM>

                 <CHANNEL_ID>1</CHANNEL_ID>

                 <SKU>11111-22223</SKU>

                 <EAN>123456789013</EAN>

                 <QUANTITY>10</QUANTITY>

                 <BILLING_TEXT>TShirtJoeRedM</BILLING_TEXT>

                 <ITEM_PRICE>00.01</ITEM_PRICE>

         </ITEM>

         <ITEM>

                 <CHANNEL_ID>1</CHANNEL_ID>

                 <SKU>11111-22224</SKU>

                 <EAN>123456789014</EAN>

                 <QUANTITY>10</QUANTITY>

                 <BILLING_TEXT>TShirtJoeRedL</BILLING_TEXT>

                 <ITEM_PRICE>00.01</ITEM_PRICE>

         </ITEM>

         <ITEM>

                 <CHANNEL_ID>1</CHANNEL_ID>

                 <SKU>11111-22225</SKU>

                 <EAN>123456789015</EAN>

                 <QUANTITY>10</QUANTITY>

                 <BILLING_TEXT>TShirtJoeRedXL</BILLING_TEXT>

                 <ITEM_PRICE>00.01</ITEM_PRICE>

         </ITEM>

 </ITEMS>

</ORDER>

</ORDER_LIST>

 

 

 

 

 

<!--Unique per shipment-->

<!--Unique per shipment-->

 

Your order file should list all articles that you want Wehlamp.nl to return to you. Save your file in the FTP directory "in". Once TB.One has processed the file you will see a new order in the order list of Wehlamp.nl (return). The node <CHANNEL_NO> should contain a unique order number that is used to identify the shipment. It should be numeric and shouldn't contain more than 7 digits. To confirm shipment, the channel will send a dispatch advice to TB.One. As soon as you receive the goods, register the shipment as a return (order tab "Returns"). TB.One will transfer the returns message to the channel and thereby acknowledge reception of the goods.

 

DATA EXCHANGE TIMES

DATA

TIME/FREQUENCY

Catalogue (Delta)

daily, 07:00 a.m.

Stock import (Delta)

daily, 10:00 p.m.

Media

after catalogue

Sales & Returns report (orders)

daily, 01:00 a.m.

Channel article number

daily, 11:00 p.m.