Otto

Add a channel catalogue

Add a channel catalogue in your Lengow account.

Match Categories

Match your categories using "Categories Matching".

Complete Attributes Matching

Match 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 match 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.

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, currently FULL or REDUCED

• 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 
  
  

2. Delivery method and costs

Shipping costs and delivery methods are defined by the channel. Contact it to obtain the table of costs.

2.1. Delivery methods

Select delivery methods in your channel back office.

2.2. Shipping costs

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.
  
  

3. Variation values

OTTO accepts variation settings. 
To manage your variations in Lengow:

• In the "productReference" attribute, enter the parent ID of your products, which must be identical for all products within a variation, and this identifier should never be modified.
• 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).
• Products with variations must have information that allows differentiation between the products (e.g. color, size, etc.).

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.

Regarding the identifiers you have to complete:

• Otto API login
  
• Otto API password

These credentials will be emailed to you by Otto after your onboarding with them.

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 Integration Reports

Read product and offer diffusion reports to check that your products are properly configured, either at product creation level (products feed) or updates (offers feed). These reports list only items which were rejected by the channel. For each product in error, the channel specifies the reason for the rejection.

Product and offer integration reports are available and downloadable from Lengow: "Channel" tab > select "name of the channel" > click on "Activity"

Main errors and how to solve them

• 700001 - MOIN_ALREADY_KNOWN

This error means that a similar product is already offered on Otto by another partner. You need to check that the product returned via the provided link perfectly matches your product:
If it's not the same product, you have to open a ticket request with Otto so that an analysis can be performed on their end.
If it's the same product, validate the offer in your Otto backoffice - this cannot be done automatically through Lengow. You then need to set the MOIN identifier of the product in Lengow, in the "moin" attribute.

• mediaAssets.location: URL is not valid

This error occurs when you are sending a "mediaAssets.type" value but the corresponding "mediaAssets.location" (containing your image URL) is empty.
To avoid this, you can add a rule on the "mediaAssets.type" field, to empty it when the "mediaAssets.location" field is not set.

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
• partnerintegration@otto.market
• support@otto.market (Otto Customer Support)

Channel's news

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