OTTO Partner Connect reports: product export, controlling and more

What areas does OTTO Partner Connect have?

OTTO Partner Connect (OPC) is the seller portal of the OTTO marketplace. According to OTTO, it includes:

• Products: create products and maintain stock
• Orders: orders, shipped products and returns
• Finance: payment history with pending and past payouts
• Analyses: sales figures and other key metrics to run your business
• Services: book extra services and advertising
• Customer requests: reply to shoppers' questions

The built-in partner helpdesk has articles and video tutorials on each function. Menu labels can change – when in doubt, check there where a report currently lives.

The product export: your catalogue as a file

In the Products area you can create and download an export of your product data. A third-party guide describes the path like this: under Products → Exports, create a new export, pick the product data template, choose product status and language, and download the finished file.

For each offer the export contains identifiers such as product reference, SKU and EAN, the MOIN, plus the marketplace status and a link to otto.de. OTTO assigns the MOIN (My OTTO Integration Number) after a product is created; it is a unique identifier used only on OTTO.

What is the product export useful for?

• Check status: which products are online and which aren't? An offer that isn't online can't rank.
• Match identifiers: SKU, EAN and MOIN in one file make matching with your ERP easy.
• Find product pages: the link or the MOIN takes you straight to the offer on otto.de.
• Basis for analysis: the export is the foundation for combining revenue, rankings and keywords per product.

Controlling and revenue: which products sell?

In the Analyses area, OTTO provides sales figures and other key metrics. For per-product analysis a revenue report helps, such as the controlling report as a CSV with columns like product title, product reference, SKU, EAN and revenue. It shows at a glance which products bring in most of your revenue.

Those are the products to watch first for rankings and ads: if a best-seller drops in search, it costs revenue immediately. If a product without sales drops, it's less urgent.

Finance and advertising reports

Under Finance you see your payment history with pending and past payouts, according to OTTO. How payouts and billing work in detail is explained in Payouts and billing on the OTTO marketplace.

For Sponsored Product Ads, OTTO provides metrics such as impressions, clicks, spend, CPC, ROAS and attributed revenue, also through the OTTO Market API with reports by campaign, product and keyword for up to 90 days. How to calculate ACoS from them is covered in OTTO Sponsored Product Ads: budget, bids and ACoS.

Importing reports into MarktRank

Not every seller wants to give a tool API access. That's why you can simply upload the product export and the revenue report from Partner Connect to MarktRank as a CSV or Excel file:

1. Choose the file: MarktRank recognises known columns such as EAN, SKU, MOIN, product reference, otto.de link and revenue; you can check and change the mapping before importing.
2. Link products: rows are matched to existing products by otto.de ID, MOIN, EAN or SKU; new products are created and their otto.de page is looked up.
3. Sort by revenue: if the file contains revenue, MarktRank sorts your product list by it – best-sellers first.

The file is only read, never stored. If you'd rather use the API, the steps are in OTTO Partner Connect API: connecting products.

A simple monthly routine

1. Download the product export and check that all key products are online.
2. Download the revenue report and identify your top products.
3. Check rankings and ad position for those products.
4. Deal with red flags first – falling revenue together with a falling position.

Frequently asked questions