Otto_logo.png

Contact the marketplace to know if you are eligible to sell your products on their website.

To display your products on this marketplace, check that your products catalogue contains the data normally required.

Note: you don't have these values in your products catalogue? Contact the Lengow Support Team to find an alternative.

Only sellers with German headquarters + VAT number are allowed to use this marketplace. More info here.

EAN Matching

No EAN Matching

Otto doesn't allow EAN Matching, meaning that it's not possible from Lengow to link your offers to product pages already existing on this channel.

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.

Energieeffizienzklasse: this field is expecting a unit scale (a value from A to G)

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
Discount prices
  • 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.

1. Delivery methods

Select delivery methods in your channel back office.

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. (See Otto for details of this delivery method)
  • delivery.deliveryTime

The delivery time in days, with allowed values from 1 to 999.

3. Variation values

Otto accepts variation settings. But it is not possible to set variations from the Lengow platform.

  • Otto asks that your variations be set directly from the Otto back office.
If your catalogue has variation products, exclude your parent type of products. See next step for more info.

4. July 2021 VAT legislation

You have to set your VAT ID during the onboarding in your KYC process and in our OTTO backend. No action is required in Lengow for this topic.

Manage your Exclusions

Follow the usual instructions for exclusions for this channel:

Are there product variations in your catalogue? Check whether the parent products should be excluded or not in the step dedicated to variations.

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

Two distinct feeds are sent to the channel through API:
  • Product Feed

This feed enables the integration and creation of products. It also contains your prices. It is sent to the channel every hour.

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

 to check that your products are properly configured, either at product creation level (product feed) or updates (offer 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 every hour.

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

    > 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"  

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,}

Contact Channel

Channel's news

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

August 31st, 2022 - Category update
  • To sum up

As of 31st August 2022, Otto is updating its categories and will delete around 400 categories. They will be replaced by new categories under a new name and a new category ID. 

  • What you have to do in Lengow

The new categories are already available in Lengow. We recommend to make sure that the category matching of your Otto channel is complete in Lengow. 

April 25th, 2022 - Attribute Migration
  • To sum up

Product uploads to Otto fail for some feeds, because the attribute names sent to Otto are wrong for some categories (not valid for JSON uploads to Otto).

A migration script is launched on Monday April 25th to correct the concerned attributes.
(Ex: the attribute 3D-Brillen.productDescription.attributes.UN-Test 38.3 Lithiu" will become "3D-Brillen.productDescription.attributes.UN-Test 38\.3 Lithi")

  • What you have to do in Lengow

This change is completely transparent, it is however recommended to check your attribute matching.

September 2021 - Categories deletion
  • To sum up

Otto is evolving its categories taxonomy. Therefore updates have to be carried on in your Lengow account.
As of 4th of October 2021, make sure to check your settings in your Lengow account for your Otto feed(s).

  • What you have to do in Lengow

In your Otto feed in Lengow, check Categories Matching and Attributes Matching step, especially to make sure products attributes from specified categories are matched accurately.

Have a look to this list of categories to know if you catalogue is impacted.

  • Original message

Deletion of certain product categories as of 04.10.2021

Over the past few months, we have frequently informed partners about deletions of duplicate/incomprehensible product categories. [...] The deletion will now take place on 04.10.21. The partner must therefore adjust the product category here accordingly if they use one of these 371 product categories. Please find attached an Excel of the affected product categories.  

Otto

Otto_logo.png

Contact the marketplace to know if you are eligible to sell your products on their website.

To display your products on this marketplace, check that your products catalogue contains the data normally required.

Note: you don't have these values in your products catalogue? Contact the Lengow Support Team to find an alternative.

Only sellers with German headquarters + VAT number are allowed to use this marketplace. More info here.

EAN Matching

No EAN Matching

Otto doesn't allow EAN Matching, meaning that it's not possible from Lengow to link your offers to product pages already existing on this channel.

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.

Energieeffizienzklasse: this field is expecting a unit scale (a value from A to G)

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
Discount prices
  • 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.

1. Delivery methods

Select delivery methods in your channel back office.

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. (See Otto for details of this delivery method)
  • delivery.deliveryTime

The delivery time in days, with allowed values from 1 to 999.

3. Variation values

Otto accepts variation settings. But it is not possible to set variations from the Lengow platform.

  • Otto asks that your variations be set directly from the Otto back office.
If your catalogue has variation products, exclude your parent type of products. See next step for more info.

4. July 2021 VAT legislation

You have to set your VAT ID during the onboarding in your KYC process and in our OTTO backend. No action is required in Lengow for this topic.

Manage your Exclusions

Follow the usual instructions for exclusions for this channel:

Are there product variations in your catalogue? Check whether the parent products should be excluded or not in the step dedicated to variations.

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

Two distinct feeds are sent to the channel through API:
  • Product Feed

This feed enables the integration and creation of products. It also contains your prices. It is sent to the channel every hour.

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

 to check that your products are properly configured, either at product creation level (product feed) or updates (offer 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 every hour.

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

    > 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"  

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,}

Contact Channel

Channel's news

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

August 31st, 2022 - Category update
  • To sum up

As of 31st August 2022, Otto is updating its categories and will delete around 400 categories. They will be replaced by new categories under a new name and a new category ID. 

  • What you have to do in Lengow

The new categories are already available in Lengow. We recommend to make sure that the category matching of your Otto channel is complete in Lengow. 

April 25th, 2022 - Attribute Migration
  • To sum up

Product uploads to Otto fail for some feeds, because the attribute names sent to Otto are wrong for some categories (not valid for JSON uploads to Otto).

A migration script is launched on Monday April 25th to correct the concerned attributes.
(Ex: the attribute 3D-Brillen.productDescription.attributes.UN-Test 38.3 Lithiu" will become "3D-Brillen.productDescription.attributes.UN-Test 38\.3 Lithi")

  • What you have to do in Lengow

This change is completely transparent, it is however recommended to check your attribute matching.

September 2021 - Categories deletion
  • To sum up

Otto is evolving its categories taxonomy. Therefore updates have to be carried on in your Lengow account.
As of 4th of October 2021, make sure to check your settings in your Lengow account for your Otto feed(s).

  • What you have to do in Lengow

In your Otto feed in Lengow, check Categories Matching and Attributes Matching step, especially to make sure products attributes from specified categories are matched accurately.

Have a look to this list of categories to know if you catalogue is impacted.

  • Original message

Deletion of certain product categories as of 04.10.2021

Over the past few months, we have frequently informed partners about deletions of duplicate/incomprehensible product categories. [...] The deletion will now take place on 04.10.21. The partner must therefore adjust the product category here accordingly if they use one of these 371 product categories. Please find attached an Excel of the affected product categories.  

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request