Skip to main content

OTTO Market

This page provides information about OTTO market, OTTO’s marketplace model.

1. OTTO Market

OTTO market is OTTO’s marketplace. You are shown as the seller of your products. However, communication with customers is managed by OTTO.

Connecting to this market allows for the following automatic processes to take place:

  • Order import once an hour

  • Stock synchronisation every 15 minutes
    Note: If stock for a variation drops to 0, this variation is deactivated automatically after 15 days. This is done to protect the product’s ranking on OTTO Market. If new stock is booked for such a variation, the variation is reactivated during the nightly item export.

  • Update of item data including price synchronisation once every night

  • Import of return announcements by customers once per hour

  • Update of category groups/catalogue templates twice a week

  • Update of the brands list every three hours

2. Setting up an account

Use the assistant Base settings - OTTO Market in the Setup » Assistants » Omni-Channel menu to quickly and conveniently set up OTTO Market in plentymarkets. Moreover, you set up the data transfer to OTTO Market. Keep the API access data at hand that you received from OTTO Market.

Carrying out settings in the assistant:

  1. Go to Setup » Assistants » Omni-Channel.

  2. Click on the assistant Base settings - OTTO Market.

  3. Follow the instructions on the screen. If you need additional information about one of the options, expand the info box shown below this instruction ().

  4. In the step Summary, check your settings to makes sure they are correct.
    Tip: Click on the arrow in the step Summary () to show the settings.

  5. If everything is as it should be, click on Finalise.
    → The settings are saved.

Options in the assistant
Setting Explanation

Step Settings

Select the client that should be used to sell your items.

From the drop-down list Client, select a client. This client is used to generate the item URL in the catalogue and OTTO Market orders are assigned to this client.

Would you like to activate your OTTO market user account?

Not activated = The settings are saved but the data exchange with OTTO Market is not started.
Activated = Data exchange with OTTO Market is started once the assistant is completed.
Recommendation: Check all settings before activating the user account.

Step API access data

Enter the API access data.

  • API user (mandatory input) = Enter the user name for the API interface that you received from OTTO Market.

  • Password (mandatory input) = Enter the password for the API interface that you received from OTTO Market.

Step Data exchange

Would you like to import OTTO market orders into plentymarkets?

Activate to automatically import orders once an hour.
Note: You need to activate this option to export item data and stock information.

Which data would you like to transfer to OTTO market?
(only shown if you activated Import orders)

Select the data to be exported.
Note: You need to automatically import orders to export item data and stock information.

  • Item data = Item data is synchronised once a day during the night.

  • Stock information = Stock is synchronised every 15 minutes.
    Note: If stock for a variation drops to 0, this variation is deactivated automatically after 15 days. This is done to protect the product’s ranking on OTTO Market. If new stock is booked for such a variation, the variation is reactivated during the nightly item export.

Would you like to import return announcements from OTTO market into plentymarkets?

Activate to import returns that customers create on OTTO Market once per hour. Each returned order item is shown as a separate return in the Orders tab of an order.

Select the order status for newly imported return announcements.
(only shown if you activated Import return announcements)

From the drop-down list, select the status to be assigned to return announcements during import.
Note: A return announcement does not guarantee that the customer actually sends the product back to you. As such, select a status that does not trigger any unwanted event procedures, such as event procedures for creating credit notes.

Would you like to replace the stock amount for variations with no stock limitation?

Activate Replace stock to enter a stock amount.

Stock amount
(only shown if you activated Limit stock)

Enter the stock amount. This stock amount is sent if the setting Limit of a variation is set to None or Do not administer stock for this variation and stock is less than or equal to 0.

Would you like to import purchase receipts as external invoices?

By default, purchase receipts are imported as normal order documents since 15/12/2020. Up to that date, the order documents provided by OTTO Market were imported with the document type External invoice even though the documents were not proper invoices. If you want to continue to import these documents with the document type External invoices due to dependencies to other exports, interfaces or software, activate the option Import purchase receipts as external invoices. Visit the plentymarkets forum  for more details.

Step Shipping service provider

Link plentymarkets shipping service provider DHL with:

For each plentymarkets shipping service provider, select an OTTO Market shipping service provider from the drop-down list.

Step Return shipping service provider

Link plentymarkets shipping service provider DHL with:

For each plentymarkets shipping service provider for returns, select the appropriate OTTO Market shipping service provider for returns from the drop-down list.

Select a shipping service provider to be used as a fallback option to the assigned return shipping service providers.

Select the shipping service provider that is to be used if return tracking numbers are added to the system via REST API. For example, return tracking numbers are added via REST API if you work with an external fulfilment company that is connected via this API. For return tracking numbers that are added via REST API, the assignments for OTTO Market shipping service provider for returns cannot be applied.
Note: No return shipping service providers are shown in the drop-down list? Then install at least one plugin for shipping service providers. You can download the plugins from the plentyMarketplace .

  • Use service provider from shipping profile (Default option) = The shipping service provider of the order’s shipping profile is also used as the shipping service provider for the return.

  • Alternative return shipping service provider = Select a shipping service provider from the drop-down list. This shipping service provider is used for all shipments to which the assignments above cannot be applied.

  • No alternative shipping service provider = No attempt is made to select an alternative shipping service provider for the return.
    Note: Every shipping confirmation that you send to OTTO Market must contain a tracking number to be used for a possible return. As such, if you select the option No alternative shipping service provider, the shipping confirmation may not be sent to OTTO Market.

3. Activating the order referrer

An order referrer tags an order with the sales channel on which the order was generated. You also need to activate the order referrer in order to link items, characteristics etc. with OTTO Market. Go to Setup » Orders » Order referrer to activate the order referrer.

Activating the order referrer for OTTO Market:

  1. Go to Setup » Orders » Order referrer.

  2. Activate the option OTTO Market.

  3. Save () the settings.

4. Setting the variation availability

You need to activate the variations that you want to sell on OTTO Market. This is done in the Availability tab of a variation within the Item » Edit item » [Open item] » Tab: Variation ID menu.

Making a variation available for OTTO Market:

  1. Go to Item » Edit item » [Open item] » Tab: Variation ID » Tab: Settings.

  2. Open the variation that you want to sell on OTTO Market.
    Tip: To sell all variations of an item on OTTO Market, carry out the settings for the item’s main variation. This activates the availability of all variations of the item.

  3. In the Availability area, activate the option Active.

  4. Click on the Availability tab.

  5. In the Markets area, click in the selection field.
    → A list of all available markets is displayed.

  6. Activate the option OTTO Market.

  7. Click on Add ().
    → The market is added.

  8. Save () the settings.
    → The variation is available for OTTO Market.

The variation group function allows you to edit several variations at once. You select the variations that you want to edit.

Making several variations available for OTTO Market using the variation group function:

  1. Go to Item » Edit item.

  2. Set the filter Table type to Variations.

  3. Choose additional filters on the left if needed and click on Search ().

  4. Select () the variations to be edited from the overview on the right.

  5. Click on Variation group function.
    → The Variation group function window opens.

  6. Navigate to the area Market availability.

  7. Activate the checkbox to the left of the option OTTO Market.

  8. Activate the checkbox to the right of the option OTTO Market.

  9. Navigate to the area Availability.

  10. Activate the checkbox to the left of the option Active.

  11. Activate the checkbox to the right of the option Active.

  12. Click on Execute 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:

  1. Go to Item » Batch processing.

  2. Click on the tab Variations in the upper left corner.

  3. Use the filters on the left to specify which variations should be processed.

  4. Navigate to the area Market availability.

  5. Activate the checkbox to the left of the option OTTO Market.

  6. Activate the checkbox to the right of the option OTTO Market.

  7. Navigate to the area Availability.

  8. Activate the checkbox to the left of the option Active.

  9. Activate the checkbox to the right of the option Active.

  10. Click on Apply to apply the settings to the variations.

If you deactivate the market availability for OTTO Market of a variation in the Item » Edit item » [Open item] » Tab: Variation ID» Tab: Availability, 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.

5. Setting the availability for images

The availability OTTO Market has to be saved for an image in the Item » Edit item » [Open item] » Tab: Images menu so that item images are displayed on OTTO Market.

Setting the availability for images:

  1. Go to Item » Edit item » [Open item] » Tab: Images.

  2. Activate the option OTTO Market in the Availability drop-down list.

  3. Save () the settings.
    → The variation image is displayed on OTTO Market.

6. Defining a sales price

Sales prices define the conditions under which a variation is sold at a specific price and on a specific sales channel. That means that 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.

Defining a sales price for OTTO Market:

  1. Go to Setup » Item » Sales prices » [Open sales price].
    Tip: No sales prices? Then create a new sales price first.

  2. Open the Settings tab.

  3. Activate the referrer OTTO Market.

  4. Save () the settings.

7. Activating the payment method

Activate the payment method Otto Payment as described below.

Activating the payment method Otto Payment:

  1. Go to Setup » Orders » Payment » Methods.

  2. Activate the option Also show inactive.

  3. Open the folder International.

  4. Click on Otto Payment.
    → The Settings tab opens.

  5. Carry out the settings. Pay attention to the information given in [table-payment-method].

  6. Place a check mark next to the option Active.

  7. Save () the settings.

Table 1. Settings for the payment method
Setting Explanation

Language

The following options are saved for the language selected: Name, Info page, Info page (internal), Logo, and Upload logo. This enables you to enter values for these options in various languages. The values for a language are activated as soon as a buyer selects the language in the plentyShop.

Name

Enter the name that should be displayed in the plentyShop and on invoices etc.

Info page

Select a category page of the type content or enter the URL of a website to provide information about the payment method.

Info page (external)

If you selected the Info page (external) option under Info page, then enter the URL of the info page here.

Countries of delivery

Do not select a country of delivery.
You cannot use the payment method in your plentyShop. Therefore, this payment method is only activated in plentymarkets. It is not completely set up.

Logo

Select one of the following options for displaying the logo:

  • Show standard logo = The logo that is saved in plentymarkets for this payment method is displayed.

  • Do not show a logo = The logo that is saved in plentymarkets for this payment method is not displayed.

  • Show upload logo = The options Logo view and Upload logo are displayed.

Logo view

If Show upload logo was selected from the Logo drop-down list, then the logo that was uploaded is displayed here.

Upload logo

If Show upload logo was selected from the Logo drop-down list, then upload an external logo here.
Click on Upload files and select the logo that you want to upload for the payment method. Permitted data formats: GIF, PNG, and JPG.

Priority

Select the priority for displaying the payment method in the plentyShop.

Costs: Flat rate or percentage

If the payment method results in additional costs, enter the percentage value or flat rate value. The selection depends on the conditions of your contract.
Important: Do not enter a value into both fields.
For further information, refer to the Statistics page of the manual.
For an example of flat rate and percentage costs, refer to the Managing payment methods page.

Permitting the payment method in customer classes

Go to Setup » CRM » Classes to activate or deactivate permitted payment methods.
For further information, refer to the Permitting the payment method in a customer class chapter.

For further information, refer to the Managing payment methods page.

8. Setting up the item export

Item data is exported to OTTO Market via catalogues. Use the assistant Create catalogues - OTTO Market to create a marketplace format for every OTTO category group. Is this your first time working with catalogues? Then read up on the principle of catalogues first. For further information about the plentymarkets data sources that can be linked, refer to the Mapping data fields chapter.

Items cannot be deleted at OTTO Market

An item cannot be deleted at OTTO Market, neither by plentymarkets 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.

8.1. Creating a catalogue in the assistant

Creating a catalogue in the assistant:

  1. Open the menu Setup » Assistants » Omni-Channel.

  2. Click on the assistant Create catalogues - OTTO Market.

  3. Follow the instructions on the screen. If you need additional information about one of the options, expand the info boxes below this instruction ().

  4. In the step Summary, check your settings to makes sure they are correct.
    Tip: Click on the arrow in the step Summary () to show the settings.

  5. If everything is as it should be, click on Finalise.
    → The catalogue is created.

  6. Map more fields in the Data » Catalogues menu.
    Note: You need a separate catalogue for each OTTO category group.

Step Name and category group
Setting Explanation

Enter a name for the catalogue.

Enter a name for the catalogue.

Select the OTTO category group that should be added to the catalogue.

Select an OTTO category group from the drop-down list.
Note: You need a separate catalogue for each OTTO category group.

Step Required fields

In this step of the assistant, you decide which variation data saved in plentymarkets you want to send to the market. To do so, you are going to map each mandatory field of the market with the data field in plentymarkets that contains the data that you want to export to the market. Each market specifies their own mandatory fields. Instead of mapping an existing data field, you can also create a new data field for some fields.


Parent SKU = From the drop-down list, select the data field in plentymarkets that contains the parent SKU.


SKU = From the drop-down list, select the data field in plentymarkets that contains the SKU.


Select data source = A data field that already exists in plentymarkets will be exported to OTTO Market. Select the data field from the drop-down list Data field.
Note: The mappings you create will not be checked in terms of logic. As such, check your mappings carefully before starting the export.


Create property = Creates a property and maps this property to the data field. This automatically created property will be saved in the Setup » Settings » Properties » Configuration menu.

The property is created with the following settings:

  • Section = Item

  • Property type = depending on the market’s requirements

  • Language = German

  • Name = Field of the OTTO category group

  • Group = OTTO Market


Creating a sales price = Creates a sales price and maps this sales price to the data field. You can check and edit this sales price in the Setup » Item » Sales prices menu.

The sales price is created with the following settings:

  • Subscription interval = None

  • Internal name = OTTO Market

  • External name = OTTO Market

  • Minimum quantity = 1

  • Live conversion = No

  • Currency = Euro

  • Display = Always display for new items

  • Client = ALL

  • Class = ALL

  • Country = Germany


Create barcode = Creates the barcode OTTO Market and maps this barcode with the data field. If a barcode with the name OTTO Market already exists in the system, that barcode is mapped instead. You can check and edit this barcode in the Setup » Item » Barcodes menu.

8.2. Mapping additional data fields in the catalogue (not in assistant)

You have already mapped important mandatory fields for the OTTO category group in the assistant. However, after you have completed the assistant, you need to map additional data fields to send more information regarding your products to OTTO Market.

Map at least the data fields Brand, Delivery type and Category with plentymarkets data fields.

Mapping additional data fields in the catalogue:

  1. Go to Data » Catalogues.

  2. Click on the catalogue.
    → The Mapping tab with the market data fields opens.
    → In the left-hand column, the market’s data fields are listed.
    Tip: Mandatory fields are flagged with an asterisk (*).

  3. To the right of the first marketplace data field, click on Add data field.
    → To the left, the plentymarkets data fields are listed in groups.

  4. Click on a group to expand the associated data fields.
    → The data fields are shown.

  5. Next to the data field you want to select, click on the plus.
    → The data field is added to the view.
    Tip: Do you want to export a fixed value for every variation for one of the market data fields? Click on the plus next to Own value.
    → The field for the own value is added to the view.

  6. Enter a value into the input field.

  7. Click on the X to close the editing mode.
    → The data field is mapped.

  8. Optional: Do you want to export two or more plentymarkets fields for a single marketplace data field?

    1. To the right of the data field you just mapped, click on Add data field ().

    2. Map an additional plentymarkets data field to the marketplace data field as described above.

    3. To the right of the column, click on Settings ().

    4. Select a separator from the drop-down list Separator or add a custom separator.

    5. Save the settings.
      → The additional data field is mapped. During the export, the content of the two plentymarkets data fields is combined and exported as one field.

  9. Optional: Click on Add fallback data field to select a data field that is exported in case another one is not available or empty. You can also add more than one fallback data field.
    Note: Even if you assign a fallback data field to a market data field, only one value is exported. The fields are checked in the order in which you mapped them. This means that if the first data field does not provide a value, the first fallback data field is exported etc.

  10. Repeat this mapping for all data fields of the market that you want to export.
    Note: All fields flagged with asterisks (*) are mandatory and must be mapped to a plentymarkets data field.

  11. Save () the settings.
    → The mappings are saved.

8.3. Example: Mapping the data field "Stock"

An example of how to map the data field Stock to item data saved in plentymarkets is provided below. Use the data field Stock to select from which warehouse stock is to be exported to OTTO Market.

Mapping the data field "Stock":

  1. Go to Data » Catalogues.

  2. Click on the catalogue.
    → The catalogue opens.

  3. Navigate to the OTTO Market data field Stock.

  4. Click on Add data field.

  5. In the list that opens to the left, click on the folder Stock.
    → All warehouses saved in plentymarkets are displayed in the drop-down list.

  6. Click on the plus symbol for the warehouse from which you want to export the stock to OTTO Market.
    Optional: To transfer stock from multiple warehouses to OTTO Market, click on Add fallback data field () and add another warehouse.
    → The total stock of all selected warehouses is exported.
    Note: If you do not map the data field Stock to a warehouse, then the sum of the net stock of all distribution warehouses (data field Virtual warehouse) will be exported to OTTO Market.

  7. Save () the settings.

9. Linking data fields created in the assistant with variations

If you selected the options Create sales price, Create barcode and/or Create property in the assistant, these prices, barcodes and/or properties are created automatically. You need to link these newly created sources with the variations that you want to export to the market. This is described on the Item pages of the manual:

  • Learn how to link sales prices to variations in the Linking sales prices chapter.

  • Learn how to link barcodes to variations in the Linking barcodes chapter.

  • Learn how to link properties to variations in the Linking properties and saving a value chapter.
    Tip: Properties created in the assistant are automatically added to the property group OTTO Market of the Setup » Settings » Properties » Groups menu. Open this group to see what new properties need to be mapped.

10. Linking variations with OTTO category groups

After you created a marketplace format for OTTO Market with the OTTO Market Creating catalogues assistant or manually, the property OTTO category group is created in your plentymarkets system. A new selection value is added to the OTTO category group property for each OTTO category group selected in the Name and category group step of the assistant. In order for your variations to be exported in the appropriate catalogue, they have to be linked to the OTTO category group property in the Properties tab of a variation.

Linking a variation with an OTTO category group:

  1. Go to Item » Edit item » [Open item].

  2. Click on the Variations tab.

  3. Open the variation that should be linked.

  4. Open the Properties tab.

  5. In the Variation properties area, select the property OTTO category group from the Properties drop-down list and click on Add ().
    → The property is added.

  6. Select the desired category group from the Value drop-down list for the OTTO category group property.
    Note: The export to OTTO Market contains the name of the catalogue, not the name of the marketplace format.
    → The variation will be exported in this catalogue.
    Example: If you select the value Betten (Beds), then the variation will be exported in the catalogue for the OTTO category group Betten.

  7. Save () the settings.

11. Activating the catalogue export to OTTO Market

You have set up OTTO Market and created a catalogue for exporting your item data? Then start the export of your item data.

Activating the catalogue export to OTTO Market:

  1. Go to Data » Catalogues.
    → The catalogues are listed.

  2. Scroll to the OTTO Market catalogue.

  3. In the Active/Inactive column, move the toggle button to the right ().
    → The catalogue is active.
    → The catalogue data is exported to OTTO Market once a day during the night{if-active}.

12. Check list: Requirements for exporting variations

To export a variation to OTTO Market, this variation has to meet the following requirements:

Have you activated the variation?
  1. Go to Item » Edit item » [Open item] » Tab: Variation ID » Tab: Settings.

  2. Open the variation that you want to sell on OTTO Market.

  3. In the Availability area, activate the option Active.

  4. Save () the settings.

Is the market availability active?

The variation must be available for the market.

  1. Go to Item » Edit item » [Open item] » Tab: Variation ID » Tab: Settings.

  2. Open the variation that you want to sell on OTTO Market.

  3. Click on the Availability tab.

  4. In the Markets area, click in the selection field.
    → A list of all available markets is displayed.

  5. Activate the option OTTO Market.

  6. Save () the settings.

Is the variation linked to the property OTTO category group?
  1. Go to Item » Edit item » [Open item] » Tab: Variation ID » Tab: Settings.

  2. Open the variation that you want to sell on OTTO Market.

  3. Open the Properties tab.

  4. In the Variation properties area, select the property OTTO category group from the Properties drop-down list and click on Add ().
    → The property is added.

  5. Select the desired category group from the Value drop-down list for the OTTO category group property.
    → The variation will be exported in this catalogue.

  6. Save () the settings.

Does the variation have positive net stock?
  1. Go to Item » Edit item » [Open item] » Tab: Variation ID » Tab: Settings.

  2. Open the variation that you want to sell on OTTO Market.

  3. Click on the Stock tab.
    → The net stock of each warehouse is listed in the Net column.

Is the catalogue active?

The catalogue that the variation is associated with must be activated.

  1. Go to Data » Catalogues.
    → The catalogues are listed.

  2. Scroll to the OTTO Market catalogue.

  3. In the Active/Inactive column, move the toggle button () to the right.

Did you map all necessary data fields?

As a minimum, plentymarkets data fields must be mapped to all mandatory fields of the market. These mandatory fields are different for different market categories. In the catalogue, mandatory fields are marked with an asterisk.

Couldn’t find any errors?

You have confirmed that the above settings are correct but the variation is still not exported? Then check the data log.

  1. Go to Data » Log.

  2. From the drop-down list Integration, select the option OTTO itemexport and select Plenty\\Modules\\Otto\\Item\\Services\\ItemExportService.

  3. Click on Search ().

  4. Check all entries for the levels warning and error.

  5. Open the logs containing the message Variation invalid.
    → The the variation ID and the reason for the rejection or the missing characteristic are shown.

  6. Correct the variation data.

13. Setting up event procedures

Set up event procedures to automatically inform OTTO Market about order status changes. The following event procedures can be set up for OTTO Market:

  • Versandinformation an OTTO melden (Send shipping confirmation to OTTO)

  • Auftragsstornierung an OTTO melden (Send order cancellation to OTTO)

  • Retoure an OTTO melden (Send return to OTTO)

  • Ablehnung der Retoure an OTTO melden (Send rejection of return to OTTO)

How to set up the event procedures in plentymarkets is described in the following chapters.

Sequence of event procedures

Note that event procedures for OTTO market must be triggered in a specific sequence. First, the event procedure Generate return label must be triggered and afterwards the event procedure Send shipping confirmation to OTTO. If no return label was created, the shipping confirmation cannot be sent to OTTO Market.

13.1. Generating return labels

When OTTO Market orders are imported into your plentymarkets system, return labels must be generated for those orders before the shipping confirmation is sent to OTTO Market. An event procedure for creating a return label automatically creates a tracking number for a return (retTrackingNumber) which is saved for the order. This is to ensure that a tracking number exists if customers wish to return an item.

To ensure that the tracking number is sent to OTTO Market along with the order confirmation, you have to create a return label. Return labels can be created with the shipping service provider plugins DHL Retoure Online, GLS Shipping, and Hermes.

Note: At the moment, return labels can be created with DHL, Hermes, and GLS Shipping.

Install plugins

In order to generate return labels, the plugins DHL Retoure Online, Hermes, or GLS Shipping must be installed, activated and set up in your plentymarkets system, depending on which shipping service provider you want to use. You can download the plugins in the plentyMarketplace .

How to set up an event procedure to create a DHL return label is described below.

In order to create a return label with GLS Shipping, select the procedure Plugins > GLSShipping: Register return label instead. For further information, refer to the GLS Shipping plugin user guide.

With Hermes, return labels cannot be created via event procedures. Before the shipping label for OTTO Market is created, the return label for Hermes must be created via the shipping centre or via a procedure in a process. For further information, refer to the Hermes plugin user guide.

Setting up an event procedure
  1. Go to Setup » Orders » Events.

  2. Click on Add event procedure ().
    → The Create new event procedure window opens.

  3. Enter a distinct name for the event procedure.

  4. Select the event according to Table 2.

  5. Save () the settings.

  6. Carry out the settings according to Table 2.

  7. Place a check mark next to the option Active ().

  8. Save () the settings.
    Note: The data is not transferred in real time when the event procedure is triggered. Instead, the data is registered in a queue. As such, transferring the data can take up to several minutes if a large number of jobs need to processed. On the plus side, this means that several retries will be performed if the target server is throttled or not responding.

Table 2. Event procedure to create a DHL return label
Setting Option Selection

Event

New order

Filter 1

Order > Order type

Order

Filter 2

Order > Referrer

OTTO Market

Procedure

Plugins > Generate DHL Retoure Online label

13.2. Sending shipping confirmations to OTTO

Set up an event procedure to inform OTTO Market that an item has been shipped.

Save sender address

Shipping confirmations will only be sent to OTTO Market if the seller’s sender address was saved. You can save the address in the settings of a warehouse under Setup » Stock » Warehouse » [Select warehouse] » Settings. You have to save the address for the warehouse that is used in the respective order.

Setting up an event procedure
  1. Go to Setup » Orders » Events.

  2. Click on Add event procedure ().
    → The Create new event procedure window opens.

  3. Enter a distinct name for the event procedure.

  4. Select the event according to Table 3.

  5. Save () the settings.

  6. Carry out the settings according to Table 3.

  7. Place a check mark next to the option Active ().

  8. Save () the settings.
    Note: The data is not transferred in real time when the event procedure is triggered. Instead, the data is registered in a queue. As such, transferring the data can take up to several minutes if a large number of jobs need to processed. On the plus side, this means that several retries will be performed if the target server is throttled or not responding.

Table 3. Event procedure to send a shipping confirmation to OTTO Market
Setting Option Selection

Event

Status change

Select an event, for example [7] Shipped.

Filter 1

Order > Order type

Order

Filter 2

Order > Referrer

OTTO Market

Procedure

Plugins > Versandinformation an OTTO melden (Send shipping confirmation to OTTO)

13.3. Sending order cancellations to OTTO

Set up an event procedure to inform OTTO Market about the cancellation of an order. It might be required to cancel orders because of different reasons. For example, if the customer cancels an order, select Status [8.1] Cancelled by customer.

Setting up an event procedure
  1. Go to Setup » Orders » Events.

  2. Click on Add event procedure ().
    → The Create new event procedure window opens.

  3. Enter a distinct name for the event procedure.

  4. Select the event according to Table 4.

  5. Save () the settings.

  6. Carry out the settings according to Table 4.

  7. Place a check mark next to the option Active ().

  8. Save () the settings.
    Note: The data is not transferred in real time when the event procedure is triggered. Instead, the data is registered in a queue. As such, transferring the data can take up to several minutes if a large number of jobs need to processed. On the plus side, this means that several retries will be performed if the target server is throttled or not responding.

Table 4. Event procedure to send an order cancellation to OTTO Market
Setting Option Selection

Event

Order change: Status change

Select an event, for example [8.1] Cancelled by customer.
Note: Orders that are cancelled by OTTO Market are imported to plentymarkets with the status [8] Cancelled. As such, select a different status to make sure that you do not notify OTTO Market of a cancellation they triggered.

Filter 1

Order > Order type

Order

Filter 2

Order > Referrer

OTTO Market

Procedure

Plugins > Auftragsstornierung an OTTO melden (Send order cancellation to OTTO)

13.4. Sending returns to OTTO

In order that OTTO Market accepts the return, you have to create an order of the type Credit note. Set up an event procedure for that.

otto market return credit note
Figure 1. Event procedure to create an order of the type Credit note
Setting up an event procedure
  1. Go to Setup » Orders » Events.

  2. Click on Add event procedure ().
    → The Create new event procedure window opens.

  3. Enter a distinct name for the event procedure.

  4. Select the event according to Table 5.

  5. Save () the settings.

  6. Carry out the settings according to Table 5.

  7. Place a check mark next to the option Active ().

  8. Save () the settings.
    Note: The data is not transferred in real time when the event procedure is triggered. Instead, the data is registered in a queue. As such, transferring the data can take up to several minutes if a large number of jobs need to processed. On the plus side, this means that several retries will be performed if the target server is throttled or not responding.

Table 5. Event procedure to create an order of the type Credit note
Setting Option Selection

Event

Select an event, for example Order change: Status change.
Note: Select a status that suits your workflow. Select the status [9.11] Send return to OTTO, for example.

Filter 1

Order > Order type

Return

Filter 2

Order > Referrer

OTTO Market

Procedure

Order > Create credit note (order)

Set up another event procedure to inform OTTO Market about a return.

otto market accept return
Figure 2. Event procedure to send returns to OTTO Market
Setting up an event procedure
  1. Go to Setup » Orders » Events.

  2. Click on Add event procedure ().
    → The Create new event procedure window opens.

  3. Enter a distinct name for the event procedure.

  4. Select the event according to Table 6.

  5. Save () the settings.

  6. Carry out the settings according to Table 6.

  7. Place a check mark next to the option Active ().

  8. Save () the settings.
    Note: The data is not transferred in real time when the event procedure is triggered. Instead, the data is registered in a queue. As such, transferring the data can take up to several minutes if a large number of jobs need to processed. On the plus side, this means that several retries will be performed if the target server is throttled or not responding.

Table 6. Event procedure to send returns to OTTO Market
Setting Option Selection

Event

Select an event, for example Order generation: New credit note.

Filter 1

Order > Order type

Credit note

Filter 2

Order > Referrer

OTTO Market

Procedure

Plugins > Retoure an OTTO melden (Send return to OTTO)

Notes:

  • The procedure Send return to OTTO triggers a credit note and the buyer receives a refund. The credit note document created by OTTO is automatically attached to the order of the type Credit note.

  • OTTO will refund the complete sales price of an order item. You cannot notify OTTO Market of a partial refund for an order item. As such, even if you adjust the price of an order item, this does not affect the refund document that OTTO creates.

13.5. Sending return rejections to OTTO

Set up an event procedure to inform OTTO Market about the rejection of a return.

Setting up an event procedure
  1. Go to Setup » Orders » Events.

  2. Click on Add event procedure ().
    → The Create new event procedure window opens.

  3. Enter a distinct name for the event procedure.

  4. Select the event according to Table 7.

  5. Save () the settings.

  6. Carry out the settings according to Table 7.

  7. Place a check mark next to the option Active ().

  8. Save () the settings.
    Note: The data is not transferred in real time when the event procedure is triggered. Instead, the data is registered in a queue. As such, transferring the data can take up to several minutes if a large number of jobs need to processed. On the plus side, this means that several retries will be performed if the target server is throttled or not responding.

Table 7. Event procedure to send the rejection of a return to OTTO market
Setting Option Selection

Event

Select an event, for example Order change: Status change.
Note: Select a status that suits your workflow. For example, you can create the status [9.12] Reject OTTO return.

Filter 1

Order > Order type

Return

Filter 2

Order > Referrer

OTTO Market

Procedure

Plugins > Ablehnung der Retoure an OTTO melden (Send rejection of return to OTTO)

14. OTTO Market order management

This chapter informs you how orders are processed at OTTO Market.

14.1. Order import

OTTO Market orders are imported into plentymarkets with status [3] Waiting for payment. 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 plentymarkets 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 plentymarkets, 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 plentymarkets. In plentymarkets, the unpaid order automatically changes to status [8] Cancelled.

14.2. Invoice import

Invoices for OTTO Market orders are generated by OTTO Market and automatically imported into plentymarkets after you sent a shipping confirmation to OTTO Market. 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. This means that you cannot create invoices for OTTO Market in plentymarkets.

OTTO Market creates invoices as soon as an item was shipped. Therefore, invoices are also created for partial deliveries.

14.3. Credit note import

Credit notes and partial credit notes for OTTO Market orders are generated by OTTO Market and automatically imported into plentymarkets 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. 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.

Because OTTO Markets creates credit notes when the return of an item is confirmed, credit notes are also generated for partial returns.

15. Viewing the log

The Data » Log menu contains a history of processes that run via the OTTO Market interface. For OTTO Market, the following filters are recommended:

  • Identifier » Otto Market

Integrations and identifiers are only shown in the drop-down lists after the process has run at least once.
Filtering and checking log entries
  1. Go to Data » Log.

  2. In the column to the left, select appropriate filters from the drop-down lists.

  3. Optional: Select filters for dates and/or times to only show entries from a specific period.
    Tip: For further information about the filters, refer to the Data log page of the manual.

  4. Click on Search ().
    → The results are shown.

  5. Check all entries for the levels warning and error.
    Tip: Click on the entry to see details.

16. FAQ

This chapter contains answers to frequently asked questions. As of: 21/12/2020)

16.1. FAQ: General questions and answers

Which product title is shown at OTTO Market?

The product title which is displayed on OTTO Market is composed of the following OTTO Market fields that can be mapped in the catalogue: Brand + Model + Specific characteristics \+ all fields that have the information Namenbildend indicated in parentheses.

Where do I enter the shipping costs in the OTTO partner portal?

The shipping costs for your OTTO Market items need to be configured in the OTTO partner portal. You can enter two kinds of shipping there:

  • Packages
    For free shipping, enter the value 0.00.

  • Shipping company
    For shipments to be carried out by a shipping company, enter a surcharge. This surcharge is then added to the default shipping costs.

Save information about how individual items are to be shipped in the item settings.

16.2. FAQ: Item data export

Why are my items not exported to OTTO Market?

One or more of your variations were not exported? First, work through the checklist: Requirements for exporting variations.

If your variations meet all requirements and all catalogue mappings are correct, you can consult the log to find out why variations are not exported. You can find out why some of your items are not exported to OTTO Market and therefore are not available on the online market by looking at the following logs.

Searching the logs:

  1. Go to Data » Log.

  2. From the drop-down list Integration, select the log Plenty\\Modules\\Otto\\Item\\Services\\ItemExportService.
    → All item exports to date are shown.

  3. In the drop-down list Level, enter first warning and then error and check the results for each.

  4. Open the logs containing the message Variation invalid.
    → In the log, you will receive the variation ID and the reason for the rejection or the missing characteristic.

  5. We have listed possible error messages and solutions below this description.

  6. If you cannot find the variation in any of these logs, also use the following filter:

    1. Integration: Plenty\\Modules\\Otto\\Item\\Templates\\Mutators\\DefaultSkuMutator

    2. Identifier: OTTO Market

I want to export the unit price of my variations to OTTO. How can I do that?

Requirements: To export the unit price to OTTO, you need to save information regarding the quantity and the unit of that quantity for each variation. Open the variation and save this information in the tab Settings, area Dimensions:

For the option Content, you enter a Content value and select a Content unit.

In the catalogue, the following OTTO Market data fields are necessary to export the unit price:

  • Sales price amount

  • Unit price amount

  • Unit price unit

  • Sales price unit

OTTO calculates the unit price of variations based on this information. The table below provides more details on these data fields.

OTTO Market data field Mapping in plentymarkets Explanation

Sales price amount

  • Folder Variation, option Content value

The sales price amount is equivalent to the actual quantity or amount of the variation. As such, you need to specify the content of the variation that is saved in the variation’s dimensions.

Unit price amount

  • Property with the values that are allowed by OTTO.

The unit price amount is used to calculate the unit price. OTTO allows the values 1, 100 or 1000. Map this field to a property with values of 1, 100 or 1000.
Tip: If all variations for this catalogue have a unit price amount of 1, you do not need to map the field Unit price amount. If the field is not mapped, the value 1 is exported by default.

Unit price unit

  • Folder Variation, option Content unit
    Enter the ISO code of the unit into the field.
    Go to Setup » Item » Units to find the ISO codes in the column ISO.
    Example: For Unit, OTTO expects the value"C62".

or

  • Property with the values that are allowed by OTTO (ISO codes)

The unit price unit relates to the content unit saved in the variation’s dimensions.

Sales price unit

  • Folder Variation, option Content unit
    Enter the ISO code of the unit into the field.
    Go to Setup » Item » Units to find the ISO codes in the column ISO.
    Example: For Unit, OTTO expects the value"C62".

or

  • Property with the values that are allowed by OTTO (ISO codes)

The sales price unit relates to the content value of the variation that is saved in the variation’s dimensions.

16.2.1. Item export: Error messages in the log

We have listed possible error messages in relation to the item export below.

missing requirements: delivery.deliveryTime

Check the delivery time mapped in the catalogue in the field Delivery time in days and the variation. In most cases, you can map the availability of your variation:

You can find a translation of the individual availability levels in the Setup » Item » Availability menu.

missing requirements: delivery.type

This error indicates that the shipping method is not linked. The shipping method can be defined via two different data fields:

  • via a shipping profile

  • via property

Make sure that the data field saved in the catalogue is linked to the item. For the shipping profile, activate the shipping profile in the item’s Global tab. For the property, activate the property for the desired variation.

missing requirements: ean
  • Check that the variation has a EAN.

  • Check that the barcode mapped in the EAN field of the catalogue matches the barcode type saved for the variation.

  • Go to Setup » Item » Barcode and check that the barcode type is activated for the market OTTO Market.

missing requirements: mediaAssets.IMAGE or mediaAssets

Both these error messages usually have the same cause. This error indicates that either you did not select a data field as the source in the catalogue or that none of your item images is linked to the referrer OTTO Market. To do so, open an item’s Images tab and activate the referrer OTTO market as described in the Setting the availability for images chapter.

missing requirements: pricing.standardPrice.amount or pricing.standardPrice.currency

Both these error messages usually have the same cause. Check that the catalogue field Sales price has been mapped to the sales price of the variation. In addition, go to Setup » Item » Sales prices and make sure that the sales price you mapped in the catalogue has been activated for the referrer*OTTO Market*.

missing requirements: productDescription.brand

This error indicates that the variation’s brand that should be exported has not been mapped in the catalogue. Make sure that a source is saved for the brand in the catalogue and that the data field is linked to the item.

The brand can be linked to the variation in two different ways:

  • By mapping the Manufacturer that is saved in the Global tab of an item Tip: If you want to map the manufacturer, the catalogue mapping should be Add data field » Manufacturer » [Select manufacturer].

  • By creating a property

Important: Select the OTTO brand from the drop-down list. Do not enter the brand yourself.

Tip: If the brand you need is not available for selection in the OTTO brands field (left side), you can register the brand with OTTO Market. Go to the OTTO Market help desk to find out more. Brands that you or other sellers register are only available in plentymarkets after the next brand update. As such, it can take up to two hours until a newly created brand can be selected in the catalogue.

missing requirements: productDescription.category

This error indicates that the category mapping in the catalogue is missing. In the catalogue, check whether at least one category of the desired variation is linked to an OTTO Market category.

  • In the catalogue, check which data field is mapped to the marketplace data field Category. We recommend that you map either already existing categories (Tab: Categories) of your variations or properties (Tab: Properties).

missing requirements: sku

In the catalogue, check the mappings for the data fields Parent-SKU and SKU. Make sure that you have mapped at least two data fields to each of these fields, i.e. one field and one fallback field. You can find a recommendation for a possible mapping here.

missing requirements: stock

The variation does not have positive net stock in the warehouse that is mapped in the catalogue. If no warehouse is mapped in the catalogue, the sum of all sales warehouses is exported.

missing requirements: sku-validation-error, validation error found or Duplicate entry. Combination of the fields variationId, marketId and accountId must be unique.

This error is also indicated as SKU 1234 not generated or 0:sku in the log.

How SKUs should be generated is defined in the catalogue. There is a distinction between the Parent SKU and the Variation SKU. The source selected here should be a data record which exists only once. As such, it is not possible to use the same SKU for different items.

For example, you could use the Item ID and the Variation ID. Both IDs are generated when the item is created and as such only ever exist once.

However, it might happen that the item export is carried out with errors because of missing information in the catalogue. The SKU is created anyway and can now be found in the Availability tab of a variation. During the next export, your system will try again to create an SKU from the sources selected in the catalogue. However, as this SKU already exists, the following error occurs:

  • Duplicate entry. Combination of the fields variationId, marketId and accountId must be unique

  • SKU 1234 not generated

As such, you need to add a fallback data field to the catalogue. The solution looks like this:

Add data field
Figure 3. Add data field
Add data field

When adding another data field, it is mandatory to use the Add fallback data field button () on the right-hand side of the catalogue. Do not use the option Add data field () because in this case, your SKUs would be created twice and the error cannot be resolved.

This adds a second data field. During the next export, the first data field will be retrieved first. Because the SKU is already included in this source, the second data field will be ignored. If the first data field does not contain an SKU, then a new SKU will be generated using the second data field.

16.3. FAQ: Order processing

In some cases, errors can occur during order processing. Possible causes and frequent errors are described here.

How can I assign a return package to the correct order in my plentymarkets system?

An example of a DHL return label is provided below. The label contains all necessary data.

DHL return label
Figure 4. DHL return label
How do I find OTTO Market orders in my plentymarkets system?

The PositionID (example: 715e9369-01e3-4d09-ae91-8688dfa139b2) and the SalesOrderID (example: 4245eac7-4647-4f76-8c48-261afb19aa96) are frequently mentioned in the plentymarkets forum. However, these IDs are not relevant for you as seller. You cannot see these IDs. They serve to identify an order and the order positions in the plentymarkets database.

Orders with the order referrer OTTO Market receive the usual order ID from your plentymarkets system. However, to identify the order, an external order number is saved for the order. With this number, the order can be clearly assigned.

Screenshots illustrating how OTTO Market orders are created in plentymarkets and in the Mein Konto (My account) area at OTTO Market are provided below.

OTTO market order number
Figure 5. "Mein Konto” (My account) area at OTTO Market

The order number is saved as external order number at the order in plentymarkets.

Find a screenshot of the menu for searching the order with the external order number below:

Search external order number
Figure 6. Searching for the external order number

The external order number can be found in the Settings tab of an order (Ext. order number):

externe Auftragsnummer in plentymarkets
Figure 7. Searching for the external order number

If customers have further questions concerning an order, you can find an order by searching for the external order number.

Of course, you can also use the Referrer filter to filter OTTO Market orders.

One of the shipping confirmations was not sent to OTTO Market. What can I do?

If no shipping confirmation was sent to OTTO Market, you can check the log for possible causes.

Searching the log:

  1. Go to Data » Log.

  2. From the drop-down list Identifier, select the option OTTO Market.

  3. From the drop-down list Integration, select the log Plenty\\Modules\\Otto\\Order\\Services\\OrderShippingService.

  4. Optional: Filter ty the order ID to limit the results:

    • Reference type orderId

    • Reference value your order ID

  5. In the drop-down list Level, enter first warning and then error and check the results for each.

  6. Open the logs containing the message Variation invalid.
    → In the log, you will receive the variation ID and the reason for the rejection or the missing characteristic.

  7. We have listed possible error messages and solutions below this description.

16.3.1. Order processing: Error messages in the log

We have listed possible error messages in relation to the order processing below.

The return package nor shipping package contain a valid return tracking number.

This error usually occurs if the order has a tracking number but no return tracking number (return label). Go to Orders » Shipping centre to check this. Return labels are shown in the Return labels tab of the order. If no label exists, a label must be created and a new shipping confirmation must be sent.

To send a new shipping confirmation, the event procedure with the procedure Send shipping confirmation to OTTO must be triggered again. Depending on the event, you might need to undo the event before triggering the event action again.

Code: 200009 - ATTRIBUTE_CHANGE_DENIED or title: Der Wert dieses Feldes kann nicht geändert werden. (title: The value of this field cannot be changed.)

These errors indicate that you changed an OTTO item attribute. However, OTTO does not accept the change and it is not possible the change the attribute for this item. The indicated attribute can relate to a variation attribute or a title attribute. Other OTTO attributes are important here, too.

Items cannot be deleted at OTTO Market

An item cannot be deleted at OTTO Market, neither by plentymarkets nor by OTTO. It is only possible to mark the item as not available at OTTO Market. Therefore, you should always make sure that the correct data fields are mapped in the catalogue prior to transferring your items.

Carrier ID (X) not mapped in OTTO market config.

Check whether shipping service providers were linked to OTTO Market. This is done in the Shipping service provider step of the OTTO Market Basic settings assistant in the Setup » Assistants » Omni-Channel menu.

To top