OTTO

Add a channel catalogue

Add a channel catalogue in your Lengow account.

We recommend defining a Segment within your product catalogue to only configure and send the products you want to publish on this channel.

Map Categories

Map your categories using "Categories mapping".

Complete Attributes mapping

Map your products catalogue fields with the fields requested by the channel, based on fields definitions. If necessary, enter hard values, use functions and/or adapt the values by creating rules. For fields with valid values, select the suggested value or map with your products catalogue values.
If a value is missing in the drop-down menu, please contact your channel account manager and ask for the creation of the concerned value.

Some fields are mandatory and must be completed for your products to be created or updated. Other fields are optional but the channel recommends you fill them in to improve your products visibility.

If values are missing, you can request new values via a ticket in the Partner Helpdesk in the category Produktdaten. OTTO offers many values for bounded lists. Please make sure that the value is not available (accent, space, etc.) before opening a ticket.

1. Set up your special offers/sales

Otto requests currency and VAT information for every standard price you send.

Complete the following mandatory attributes in Lengow for standard prices:

• pricing.standardPrice.amount: standard price, use decimal point to express cents. Ex: 10.50
• pricing.standardPrice.currency: The currency of your price expressed as a shortcut according to ISO 4217. Ex: EUR 
• pricing.vat: The value added tax that is included in the sales price.
  FULL for standard tax rate (19%)
  REDUCED for reduced tax rate (7%)
  FREE for zero tax rate (0%)

• pricing.sale.salePrice.amount: Discount price, use decimal point to express cents. Ex: 5.50
• pricing.sale.salePrice.currency: The currency of your price expressed as a shortcut according to ISO 4217. Ex: EUR
• pricing.sale.startDate: The start date for the discount offer. Ex: 2019-10-19T10:00:15.000+0100
• pricing.sale.endDate: The end date for the discount offer. Ex: 2019-10-19T10:00:15.000+0100 

Make sure to disable the discount rules as soon as your discount action has ended. Errors can occur if these attributes are not disabled, thus your offer data will not be updated anymore.

2. Delivery method and costs

Select delivery methods in your OTTO back office.

Note: OTTO advises not to link shipping profiles with SKUs in OTTO's portal. 

The following Otto delivery attributes must be completed in Lengow: 

• delivery.type
  The different possible values are:
  • PARCEL: package with return label (a return tracking number is mandatory for this type of delivery)
  • FORWARDER_PREFERREDLOCATION: relais_colis (contact Otto for specific elements)
  • FORWARDER_CURBSIDE: Pick-up service, order retrievement in the shop or from the car (contact Otto for details on this delivery method).
  • FORWARDER_HEAVYDUTY: Transport by heavy trucks.

• delivery.deliveryTime
  The delivery time in days, with allowed values from 1 to 999.
• Weekend calculation
  Saturday is included whereas Sunday which is excluded.
  
  

3. Variation values

OTTO accepts variation settings and bases it on the product reference. Thus, variations will have the same Product reference but different SKUs for each variation. 
To manage your variations in Lengow:

• The "productReference" attribute must be filled with a reference common to all variations (ex: PULL-TEDDY). For simple product, if you don’t have such a reference, it can be the SKU/ID/EAN of the product. This identifier cannot be modified.
• The "sku"/"ean" code must be filled as the unique reference for each product. 
• Products within the same variation must have the same category.
• The "productDescription.bulletPoints" attributes are used to create the bullet points, so the values can be different between variations (the same goes for the description).
• The "modellname" attribute must contain the name of the collection, without any information regarding color or size.
• Products with variations must have information that allows differentiation between the products (e.g. color, size, etc.).
• The "variationThemes" attribute allows products to be differentiated based on the attributes filled. Examples for “Kleid”: Unterbrustumfang; Schnittform Länge; Farbe; Ausgabegröße; Material; Körbchengröße; Materialart; Anzahl Teile.

4. Specific settings

"Energieeffizienzklasse"

The Energieeffizienzklasse attribute is expecting a unit scale (a value from A to G).

• "sku"

The "sku" is the unique identifier of your product. OTTO requests that the SKU is a static value, as it cannot be changed after successful import into their systems. 

Manage your Exclusions

Follow the usual instructions for exclusions for this channel:

Preview your data

Check the data you are about to send to the channel at the "Preview" step.

Configure your Options

Configure options before sending your products catalogue to the channel.

Follow these steps to establish the connection to OTTO:

1. Click on "Connect to Otto" to be redirected to OTTO's connecting page.
   
   
2. Log into your OTTO account.
    You must have an admin account on OTTO to complete the operation.
3. Grant access to Lengow API.
   
   
4. Authorize Lengow to access their Partner ID.
   Please note that you will have to log in again on Otto for this step, as the base URL is different from the previous step.
   
   

   

5. In Lengow, enter the address used to ship (zipcode, city and country code).
   
   

Launch the channel catalogue

• Product Feed:
  This feed enables the integration and creation of products.  It also contains your prices.
  It is sent to the channel every 4 hours.

• Offer Feed:
  This feed enables the update of your stock quantities.
  It is sent to the channel every hour.

Read channel reports

Read product and offer Channel reports to check that your products are properly configured. These reports list only items which were rejected by OTTO. For each product in error, the channel specifies the reason for the rejection.

Product and offer channel reports are available and downloadable from Lengow: "Channel" tab > select your OTTO channel > click on "Activity"

To help you correct these errors, read our OTTO error resolution section.

 Please note that the product anomalies found in Otto in the "Produktanalyzen" tab (updated each night by Otto) or directly in the "Produktübersicht" menu are not retrieved in Lengow.

Edit a product file

Check our usual guidelines to edit your data.

• Edit "product data"
• Edit "offer data" : Data is automatically updated as soon as the offer feed is sent out (the frequency is indicated at the "Launch the channel catalogue" step).

Unpublish/Delete an offer

To stop advertising an offer on the channel, read our recommendations.

Manage your orders

You can manage your orders in the Lengow platform.

1. Order retrieval

Lengow retrieves orders placed on the channel website 15 minutes.

2. Order statuses

Orders go through various statuses in Lengow while being processed.

For Otto here are the Lengow statuses you can find on your orders:  

✅  "waiting_shipment" is Lengow status for:   

• "CONFIRMED"
• "PROCESSABLE"

Possible actions at this status: 

- ship. It requires the carrier and tracking number to be specified. (Note that for DHL, a 20-digit tracking number is required, i.e. with the leading zeros.)

    > If the client chose "parcel" as delivery mode, fill in both return_carrier and return_tracking_number.

     > If the client chose "forwarder..." as delivery mode,  return_carrier and return_tracking_number are optional.

In all cases, you can also specify the sender's address information ("from_address_city", "from_address_country_code" and "from_address_postal_code") and the product line (line).

- cancel. You may specify the product line to cancel.

✅ "shipped" is Lengow status for:    

• "SENT"

✅  "canceled" is Lengow status for:  

• "CANCELLED_BY_CUSTOMER"
• "CANCELLED_BY_MARKETPLACE"
• "CANCELLED_BY_PARTNER"

✅  "refunded" is Lengow status for:     

• "RETURNED"

✅  "waiting_acceptance" is Lengow status for:  

• "ANNOUNCED"  

3. Recovering old electronic equipment from the end buyer

As a seller if you have to recover the old electronic equipment from the end buyer, the info will be made available either:

• In Lengow > At the order level > via CSV export of Orders
• In Lengow plugin > in the "extra" field

• Via Lengow API > in the weee_pickup tag (within "order_line_meta"), with the true or false info:
  Example :
  "order_line_meta": {​"weee_pickup": true,}

4. Otto Receipt

For each order, Otto provides a purchase receipt (also called an invoice). This document is made available to you via the Lengow API, as well as in the Lengow platform, in the order details (see screenshot).

Contact 

• contact@otto.market 
• FAQ
• For technical help, create a ticket in OTTO's Partner Helpdesk: https://account.otto.market/s/helpdesk
• Otto Customer Support: support@otto.market

Channel's news

Find here the latest changes/communications from the channel and what you have to do in Lengow: