OTTO Market (Setup via Channel Control Centre)
OTTO is a German online marketplace that is well-known for its large selection of fashion products. It also offers a more general product catalogue. When selling items on OTTO Market you are shown as the seller of your products, but communication with customers is managed by OTTO.
|
Channel Control Centre
This page explains the setup process for OTTO Market via the Channel Control Centre in the Sales Channels » Channel Control Centre menu. If your system features the Sales Channels » Accounts menu instead, then you can find instructions on how to set up OTTO Market via that menu here. |
1. Frequency of data exchange
After you have set up OTTO Market in PlentyONE, data is exchanged with the sales channel in the intervals described in Table 1.
| Data | Interval |
|---|---|
Item export |
once per night |
Price synchronisation |
once per night at the time of item export |
Stock synchronisation |
every 15 minutes |
Order import |
every 15 minutes |
Import of return announcements by customers |
once per hour |
Update of category groups/catalogue templates |
daily |
Update of the brands list |
every three hours |
Import of shipping profiles |
daily |
Synchronisation of the processing time |
once per hour |
Synchronisation of shipping profiles |
once per hour |
2. OTTO Market order management
This chapter describes how OTTO Market orders are processed.
2.1. Order import
-
OTTO Market orders are imported into PlentyONE with status [3] Waiting for payment.
-
Orders with the OTTO Market status ANNOUNCED are imported to PlentyONE without address details and with the status [1] Incomplete data. These are orders that can still be cancelled by the customer, or orders with the payment method cash in advance that have not been paid. As soon as the order changes to the status PROCESSABLE at OTTO Market, the address is added to the order and the order is moved to status [4] In preparation for shipping. Orders with the payment method cash in advance are moved to status [3] Waiting for payment.
|
Reserve stock for orders with the payment method cash in advance
Important: No stock is reserved for orders in status [1] Incomplete data by default. To make sure that stock is reserved for these orders, go to Setup » Orders » Settings. Go to the setting Status for order reservation (Reservation of stocks). For the option to, select the status [1] Incomplete data. In the drop-down list to the far right, select the option All orders. |
-
After an order was confirmed by OTTO Market, the order changes to status [5] Shipment process started.
-
A payment is created for the order in PlentyONE and the order is marked as paid.
If customers paid an OTTO Market order per bank transfer, it might take longer to confirm the order than for other payment methods. In PlentyONE, the payment method is always OTTO Payment. -
If customers do not pay for an order, the order will be cancelled by OTTO Market after some time. A cancellation will be sent to PlentyONE. In PlentyONE, the unpaid order automatically changes to the status [8] Cancelled.
Important: You cannot cancel orders in status [1] Incomplete data or [3] Waiting for payment.
2.2. Invoice import
-
Invoices for OTTO Market orders are generated by OTTO Market and automatically imported into PlentyONE after you sent a shipping confirmation to OTTO Market. As such, you cannot create invoices for OTTO Market orders in PlentyONE.
-
Shipping confirmations are sent with the event procedure Send shipping confirmation to OTTO.
-
The invoice documents can be accessed in the Receipts tab of the main order after the shipping confirmation was sent.
Note: As the documents are retrieved every hour, it may take some time until they are visible. -
By default, purchase receipts are imported as normal order documents. If you activate the assistant option Import purchase receipts as external invoices, the purchase receipts are imported with the document type External invoice instead.
Important: If the option Import purchase receipts as external invoices is not activated, the order number is not shown in the order overview and is also not exported as part of the financial accounting export. The invoice number is then only shown shown in the Receipts tab of the order. -
OTTO Market creates invoices when shipping of an item is confirmed. Therefore, invoices are also created for partial deliveries.
2.3. Credit note import
-
Credit notes and partial credit notes for OTTO Market orders are generated by OTTO Market and automatically imported into PlentyONE after you sent a returns confirmation to OTTO Market.
-
Once the return has been confirmed, the credit note documents are available in the Receipts tab of the order.
Note: As the documents are retrieved every hour, it may take some time until they are visible. -
This returns confirmation is sent with the event procedure Send return to OTTO.
-
When you notify OTTO of a return, the components of the individual order items of the refund/return are sent to OTTO. This means that OTTO will refund the complete sales price of any order item. You cannot notify OTTO Market of a partial refund for a particular order item. As such, even if you adjust the price of an order item, this does not affect the refund document that OTTO creates.
-
OTTO Market creates credit notes when the return of an item is confirmed. Therefore, credit notes are also generated for partial returns.
3. Setting up OTTO Market in PlentyONE
First, add OTTO Market as a sales channel and carry out the basic settings to set up the sales channel in PlentyONE. To do so, proceed as described below.
3.1. The Channel Control Centre
In the Channel Control Centre you can find an overview of the sales channels set up in your system.
Table 2 explains the different tiles visible in the Sales Channels » Channel Control Centre menu.
| Component | Explanation | ||||||
|---|---|---|---|---|---|---|---|
Name |
The name of the sales channel. |
||||||
more_vert More |
Click here to display more actions for a sales channel.
|
3.2. Adding the sales channel OTTO Market
Add OTTO Market as a sales channel in the Channel Control Centre.
Adding a sales channel:
-
Open the Sales Channels » Channel Control Centre menu.
-
Click on Add sales channel (add).
→ The menu Add sales channel opens. -
Click on Continue in the tile of OTTO Market.
-
Enter a name for the sales channel.
-
If asked to, select the Client (Shop) from the drop-down list.
-
Click on add Add OTTO Market.
→ The sales channel for OTTO Market is added.
3.3. Carrying out the settings for OTTO Market
Next, carry out the settings for OTTO Market.
Carrying out the settings for OTTO Market:
-
Go to Sales Channels » Channel Control Centre.
-
Click on the tile for OTTO Market.
→ The tab Settings opens. -
Carry out the settings. Pay attention to the explanations given in Table 3.
-
Save () the settings.
| Option | Explanation |
|---|---|
Settings |
|
Client |
Select the client you want to use to manage OTTO Market. |
Activate data exchange |
This toggle allows you to toggle the data exchange with OTTO Market on or off. |
Authorization |
|
Authorization |
Click on the button below, log in to the OTTO Partner Connect site and follow the instructions there in order to authorise your PlentyONE system to manage your OTTO Market data. After you have finished the authorisation process an OAuth token will automatically be sent to your system. This may take a few minutes. Once your system has received the token this section will automatically be updated. |
Data exchange |
|
Order import |
(De-)activates the import of orders into your system. |
Import return requests |
(De-)activates the import of return requests into your system. |
Update stock amounts for variations with no stock limitation |
While this option is enabled any variations with no stock limitation will have their stock count set to the specified value automatically. |
Import purchase receipts as external invoices |
By default, purchase receipts will be imported as normal order documents. When this option is enabled they will be imported as external invoices instead. |
Shipping service provider mapping |
|
Shipping service provider mapping |
Map your PlentyONE shipping service providers to OTTO Market shipping service providers. Your shipping service provider mappings are used for shipping notifications sent to OTTO Market. You can set up shipping service providers in your system in the Setup » Orders » Shipping menu. |
Fallback solution for return shipments |
|
Fallback solution for return shipments |
Select the shipping service provider that is to be used
If return tracking numbers are added to the system via REST API (for example, when you work with an external fulfilment company that is connected via this API), then your mappings in the Shipping service provider mapping section cannot be applied. You can choose a fallback solution for such cases here. |
3.4. Activating the order referrer
Go to Setup » Orders » Order referrer to activate the order referrer. This ensures that orders are assigned to the correct sales channel.
An order referrer tags an order with the sales channel on which the order was generated. Sales channels can be e.g. your online shop or markets on which you sell your items. Each sales channel has an individual order referrer. Some order referrers are available by default in your PlentyONE system. Further order referrers are added e.g. if you install a new plugin. For further information about the order referrer, see the page Order referrer of the PlentyONE manual.
Activating the order referrer for OTTO Market:
-
Go to Setup » Orders » Order referrer.
-
Click Search (search).
-
In the list, navigate to the option OTTO Market with ID 160.1.
-
On the right of the referrer’s line, click Edit (edit).
→ The window Edit referrer opens. -
Activate the option Visible in selection (toggle_on).
-
Click SAVE (save).
→ The referrer is active.
3.5. Defining a sales price
To sell variations on OTTO Market, you need a sales price in which the order referrer OTTO Market is activated. The price that you save for this sales price is the price that will be shown on OTTO Market.
Sales prices define the conditions under which a variation is sold at a specific price and on a specific sales channel. For example, you can sell your items at a lower price in your webshop than on Amazon. Or you can sell products cheaper to B2B customers than to B2C customers.
Two default sales prices are already configured in your PlentyONE system. However, you can also create new sales prices and edit them individually. In addition to default sales prices, you can also create RRPs, special offers, and set prices.
Defining a sales price for OTTO Market:
-
Go to Setup » Item » Sales prices » [Open sales price].
Tip: No sales prices? Then create a sales price first. -
Activate the referrer OTTO Market.
-
Save () the settings.
3.6. Permitting the payment method in a customer class
The payment method Otto Payment is automatically available in your PlentyONE system as soon as an active OTTO Market account exists. No separate configurations are needed for this. You just need to permit the payment method in one or more customer classes.
Customer classes allow you to divide your customer base according to specific criteria. Examples of use for customer classes are:
-
Create two separate customer classes for end customers (B2C) and business customers (B2B) respectively. Depending on the customer class, customers either see net prices or gross prices in your plentyShop.
-
Give discounts to specific customer classes.
For more information about customer classes, head over to the to the Managing contacts page.
Permitting the payment method in a customer class:
-
Go to Setup » CRM » Customer classes.
-
Open the customer class for which you want to permit the payment method.
-
For the setting Allowed payment methods, activate the option Otto Payment.
-
Save () the settings.
3.7. Setting the variation availability
You need to activate the variations you want to sell on OTTO Market and enable them for the relevant sales channel. This is done in the Item » Items » [Open variation] menu.
Making a variation available for OTTO Market:
-
Go to Item » Items » [Open variation].
Tip: To sell all variations of an item on OTTO Market, carry out the settings for the item’s main variation. If the inheritance function is active for the variations, then this activates the availability of all variations of the item. -
In the Availability and visibility section, enable the option Active (toggle_on).
-
Click the Sales channels tab.
-
In the Sales channels section, activate the sales channel OTTO Market in the Status column (toggle_on).
Tip: You can activate multiple sales channels at once. To do so, activate the checkboxes to the left of the desired sales channels. Then activate the toggle above the checkbox column (toggle_on). Click ACTIVATE to confirm the activation. -
Save (save) the settings.
→ The variation is available for OTTO Market.
Use the variation group function to edit multiple variations at once. You select the variations that you want to edit.
Making several variations available for OTTO Market using the variation group function:
-
Go to Item » Items.
-
Select () the variations to be edited.
-
In the toolbar, click on layers » layers Variation group function.
→ The Variation group function window opens. -
Select the action Sales channels from the drop-down list Actions.
→ The action is added to the lower part of the window. -
Select (check_box) the option OTTO Market from the drop-down list Sales channels.
→ The sales channel is added below the Sales channels drop-down list. -
Activate (toggle_on) the toggles to the left of the sales channels.
-
Click EXECUTE & CLOSE to apply the settings.
Batch processing allows you to edit several variations at once. You use filters to limit which variations are edited.
Making several variations available for OTTO Market using batch processing:
-
Navigate to the area Market availability.
-
Activate the checkbox to the left of the option OTTO Market.
-
Activate the checkbox to the right of the option OTTO Market.
-
Navigate to the area Availability.
-
Activate the checkbox to the left of the option Active.
-
Activate the checkbox to the right of the option Active.
-
Click on Apply to apply the settings to the variations.
If you delete the market availability for OTTO Market in the Item » Items » [Open item] » [Open variation] » Area: Sales channels section of a variation, the variation is deactivated on OTTO Market within 15 minutes. If you reactivate the availability of such a variation, the variation is only reactivated on OTTO Market during the nightly item export.
3.8. Setting the availability for images
The availability OTTO Market has to be saved for an image in the Item » Items » [Open item] » Item tab: Images menu so that item images are displayed on OTTO Market.
Note: The minimum dimensions for images uploaded to OTTO Market are 500 x 1000 pixels.
Setting the availability for images:
-
Go to Item » Item » [Open item] » Item tab: Images.
-
Activate the option OTTO Market in the Availability drop-down list.
-
Save () the settings.
→ The variation image is displayed on OTTO Market.
3.9. Check list: Requirements for exporting variations
To export a variation to OTTO Market, this variation has to meet the following requirements:
-
Go to Setup » Orders » Order referrer.
-
Is the option OTTO Market with ID 160.1 active?
-
If necessary, activate this order referrer.
-
Save () the settings.
-
Go to Item » Items » [Open item] » [Open variation].
-
In the Availability and visibility section, activate the option Active.
-
Save () the settings.
The variation must be available for the sales channel.
-
Go to Item » Items » [Open item] » [Open variation].
-
In the Sales channels section, click Add sales channels (add).
→ The window Add sales channels opens. -
In the drop-down list Sales channels, select the option OTTO Market.
-
Click Apply.
→ The sales channel is added. -
Save () the settings.
→ The variation is available for OTTO Market.
-
Go to Item » Items » [Open item] » [Open variation].
-
Expand the section Stock ().
→ The net stock per warehouse is shown in the Net stock column.
Check the sales price:
-
Go to Setup » Item » Sales prices.
-
For the filter Referrer, select OTTO Market.
-
Click Search ().
→ The sales price that is active for the referrer is shown. -
Check the settings of the sales price.
-
Make any necessary corrections.
Check the price:
-
Go to Item » Items » [Open item] » [Open variation].
→ The sales prices are shown in the Sales prices section. -
Check the following settings:
-
Is the sales price for the referrer linked?
-
Does the price for the referrer have the correct price?
-
-
Make any necessary corrections.
Check the following character limits:
-
Model name can contain a maximum of 70 characters.
-
Special features can contain a maximum of 70 characters.
-
Set info can contain a maximum of 70 characters.
-
Product description can contain a maximum of 2000 characters.
-
All URLs in the Media assets section can contain a maximum of 2083 characters.
Important: The character limits are checked by OTTO Market. Therefore you should check the log messages for the integration Plenty\\Modules\\Otto\\Item\\Commands\\MarketplaceStatusImportCommand in the Data » Log menu. If variation data is not shown on OTTO Market as expected, you will find an error message in this menu.
At the least the mandatory fields for the sales channel have to be mapped to PlentyONE data fields. These mandatory fields are different for different product categories. In the catalogue, mandatory fields are marked with an asterisk.
The catalogue that the variation is associated with must be activated.
-
Go to Data » Catalogues.
→ The catalogues are listed. -
Scroll to the OTTO Market catalogue.
-
In the column Active, activate the toggle ().
You have confirmed that the above settings are correct but the variation is still not exported? Then check the data log.
-
Go to Data » Log.
-
Use the following filters:
-
Otto itemexport
-
Plenty\Modules\Otto\Item\Services\ItemExportService
-
-
Click on Search ().
-
Check all entries for the levels warning and error.
-
Open the logs containing the message Variation invalid.
→ The the variation ID and the reason for the rejection or the missing characteristic are shown. -
Correct the variation data.
4. Exporting product data
Product data is exported to OTTO Market using catalogues. Catalogues are usually managed via the Data » Catalogues menu. However, you can create catalogues for OTTO Market via the Channel Control Centre as well.
Catalogues are used to export data from your PlentyONE system. There are two different catalogue formats:
-
Marketplace formats are used to export item data to markets.
-
Standard formats are used to export data from your PlentyONE system into a file.
Catalogues with marketplace formats allow you to tailor your item information exactly to the needs of the market. Because here, you assign a suitable PlentyONE data field to each of the data fields of the market. When your variation data is exported to the market, the market’s data fields are then filled with the correct PlentyONE data.
-
Is this your first time working with catalogues? Then read up on the basic concept of catalogues first.
Additionally, to simplify the creation of new catalogues, you can manage them via Channel maps. With Channel maps, you can create cross-category mappings for a sales channel and apply them to catalogues afterwards. All linked catalogues automatically inherit the mapping from the Channel map. This will save you a lot of time as you don’t need to carry out the mappings for each catalogue.
You can find more information on Channel maps in the Channel maps section.
|
Items cannot be deleted at OTTO Market
An item cannot be deleted at OTTO Market, neither by PlentyONE nor by OTTO. It is only possible to mark the item as not available at OTTO Market. Therefore, make extra sure that the correct data fields are mapped in the catalogue prior to transferring your items. |
4.1. Adding catalogue templates
OTTO Market offers an exceedingly large amount of product categories, which is why not all of them are offered as selectable options by default in the Create catalogue menu. Instead, you will first need to manually whitelist the catalogue templates for the product categories in which you want to sell your products before you can select them in the Create catalogue menu. You can whitelist catalogue templates for OTTO Market in the Category whitelist menu in the Channel Control Centre. In order to do so, proceed as follows:
Adding product categories:
-
Go to Sales Channels » Channel Control Centre » [Your OTTO Market sales channel] » Category whitelist.
-
Click on Add categories (add).
-
Select the categories in which you want to offer your products.
Tip: You can use the search bar to find the categories you need more easily. -
Save () the settings.
→ You can now create a catalogue for your selected categories in the Mapping menu.
4.2. Creating a product channel map
To export your items to OTTO Market, create a channel map in the Channel Control Centre. Then link product catalogues to the channel map and map the OTTO Market data fields to item data saved in PlentyONE in the channel map.
Once you have activated the data exchange, product catalogue, listings and variations, your product data is automatically exported to OTTO Market once a day.
First, create a channel map for mapping your product data. To do so, proceed as follows:
Creating a product channel map:
-
Open the menu Sales Channels » Channel Control Centre » [Name of your OTTO Market Sales Channel] » Mapping » Product mapping.
-
Click on Create Channel map (add).
-
Enter a name for the channel map.
-
In the drop-down list Marketplace, select the option OTTO Market.
-
In the drop-down list Catalogue type, select the option Product.
-
In the drop-down list Categories, select the product categories you want to sell on OTTO Market.
-
Click on CREATE CHANNEL MAP.
→ The channel map is created.
Sobald du eine Channel Map für OTTO Market erstellt hast, kannst du als nächstes Kataloge für die verschiedenen Produktkategorien erstellen, die du auf OTTO Market verkaufen willst, und diese Kataloge mit der Channel Map verknüpfen. Gehe hierzu wie folgt vor:
Linking a product catalogue to the channel map:
-
Open the menu Sales Channels » Channel Control Centre » [Name of your OTTO Market Sales Channel] » Mapping » Product mapping.
-
In the row of the channel map you want to edit, click on more_vert More and select Connect catalogues.
-
In the drop-down list Select catalogues, click on Create catalogue.
-
Enter a name for the catalogue.
-
In the drop-down list Marketplace, select the option OTTO Market.
-
In the drop-down list Export type, select the option Item.
-
Click on CREATE AND CONNECT TO CHANNEL MAP.
→ The catalogue is created and connected to the channel map.
4.3. Particularities for mapping data fields
Every market structures item data differently. As such, there are some particularities for each market when mapping data fields. Table 4 contains mapping information for important data fields for OTTO Market.
| Marketplace data field | PlentyONE data field | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
Model name |
The model name can contain up to 70 characters. |
||||||||||
Special features |
The special features can contain up to 70 characters. |
||||||||||
Set info |
Set info can contain up to 70 characters. |
||||||||||
Product description |
The product description can contain up to 2000 characters. |
||||||||||
Category group |
OTTO Market publishes current information in the category list “Kategorienliste”. Open the tab "Merkmalsliste" (characteristics list). Note: Via the link, the category list "Kategorienliste" can be downloaded as XLSB file. You can open XLSB files with Excel (version 2007 and newer) and LibreOffice Calc. |
||||||||||
Brand |
Certain brands have to be authorised by OTTO. Those brands must not be sold on OTTO Market if they have not been authorised by OTTO before. For further information on those brands, refer to the OTTO help desk. |
||||||||||
Category |
OTTO Market publishes current information in the category list “Kategorienliste”. Open the tab "Übersicht Categories" (categories overview). This document is only available in German. |
||||||||||
"My Otto" Identification Number |
The "My Otto" Identification Number (MOIN) is a unique product barcode assigned by OTTO Market. From 11/08/2021, OTTO market assigns a unique MOIN to every variation.
The workflow is the same in both cases:
|
||||||||||
Stock |
Note: Items may only be shipped from foreign warehouses after this has been agreed upon with OTTO. Furthermore, items may only be shipped to customers located in Germany, unless otherwise agreed upon with OTTO. There are several ways to export stock data:
Note: If you map no warehouse and no property to the marketplace data field Stock, the sum of the net stock of all sales warehouses is exported to OTTO Market. This is the same as mapping the PlentyONE data field Virtual warehouse. |
||||||||||
Sales price currency; |
OTTO Market can only process the currency EURO. For this reason, these marketplace data fields are filled with the value “EUR” automatically. |
||||||||||
Sales price amount; |
OTTO Market uses these marketplace data fields to calculate the unit price of variations. Important: To export the unit price to OTTO Market, content and unit information must be saved for the variation. To save this information, go to Item » Items » [Open variation] » Area: Content / Dimensions, enter a Quantity and select a Unit. We recommend the following mappings for unit price calculation:
|
||||||||||
Shipping profile |
Select an OTTO shipping profile from the drop-down list and map it to a PlentyONE shipping profile (Shipping profile » [Select shipping profile]). |
||||||||||
Processing time |
Select the processing time from the drop-down list. The processing time is the time from the order intake to the readiness for shipment. |
||||||||||
Media Assets |
|||||||||||
Image |
Recommendation: Map the PlentyONE data field Image » item/catalogs/variation/image.image-image.
This data field exports all images that are made available for the referrer OTTO Market. Note: The minimum dimensions for images uploaded to OTTO Market are 500 x 1000 pixels. |
||||||||||
Other media asset data fields |
Only URLs to files can be exported for media asset data fields. The only exception to this rule is the data field Images (see above). All URLs in the Media assets area can contain up to 2083 characters. Recommended mapping:
|
||||||||||
Length specifications |
Lengths specifications have to be indicated with a dot. Otherwise, the values will not be exported correctly. Example: 2.5 m |
||||||||||
4.3.1. Mapping attributes for electrical devices and WEEE take back
As of 1 January 2022, sellers are legally obliged to offer collection of an equivalent old device when customers buy a new electrical device.
For OTTO market, you can use the attributes Geräteart laut ElektroG (type of electrical device) and WEEE-Reg.-Nr. DE to indicate whether it is an electrical device or whether WEEE take back is possible. Match these attributes with PlentyONE data fields in the Category group related attributes section of the corresponding OTTO market catalogue.
Information about WEEE take back in the order
If the order contains an electrical device and customers request WEEE take back, an OrderItemProperty with the ID 92 is added to the relevant order item of the order and the text "[inkl. Altgerätemitnahme/incl. WEEE take back]" is added to the item name.