TrackHound

DocsDiese Seite auf Deutsch

Otto Connect

Product pages: Otto Connect for Shopify, Otto Connect for Shopware

Otto Connect for Shopify and Otto Connect for Shopware share one engine. This guide follows the app's own pages in the order you will use them: Settings, Mapping, Dry run, Sync, Needs attention, Receipts, Price reduction.

Install

Install the app from the Shopify App Store. It asks for products, inventory, locations, orders, fulfillments and customers: products and inventory to publish your assortment, orders and customers to create OTTO orders in your shop, fulfillments to report shipments back.

After installation the Overview shows a five-step checklist: Connect OTTO, Choose a shipping profile, Create a mapping, Run a dry run, Switch to live. Each step links to the page where you do it.

Otto Connect overview in Shopify admin: connection, key figures, automatic tasks and the getting-started checklist
Otto Connect overview in Shopify admin: connection, key figures, automatic tasks and the getting-started checklist

Connect OTTO

You need an active OTTO Market seller account. In the app open Settings, choose the environment (Sandbox for testing, Live for real orders) and click Connect with OTTO. You are taken to OTTO Partner Connect, log in there and approve Otto Connect; OTTO sends you back to the Settings page, which then shows the connection. No API credentials to copy.

If you prefer your own API client instead: in OTTO Partner Connect open Settings → API access and create one (OTTO shows the client secret only once), then open Use your own API credentials in the app's Settings, paste client ID and client secret, and save. The secret is stored encrypted and never shown again; leave the field empty on later saves to keep it. Then use Test connection: the app reads OTTO's brand and category lists to prove the credentials work.

Fill the ship-from location (city, postal code, three-letter country code such as DEU) in the same page; OTTO requires it in every shipment confirmation.

Shipping profile

OTTO only sells an item once it is assigned to an OTTO shipping profile. The profile sets the delivery type, the shipping days, the order cut-off and the processing and transport time.

In Settings, pick one of your OTTO shipping profiles or create a new one in the app: delivery type (Paket or one of the Spedition variants), shipping days, order cut-off in half-hour steps (CET), processing days and transport days, together at most 72 days. Optionally set a processing time of 1 to 99 days that applies to all items.

The app assigns every transferred item to that profile automatically. If you change the profile, all items are reassigned. Until a profile is chosen, Needs attention shows an entry; in Shopify the Overview checklist has the step Choose a shipping profile.

Mapping

OTTO needs an EAN, a known brand, an OTTO category with its mandatory attributes and product-safety data on every product. The Mapping page turns your Shopify data into that structure.

General: where the brand comes from (a product field such as vendor, a fixed value, or a metafield), the default VAT rate, and the default OTTO category for products no rule matches.

Category rules: one rule per Shopify product type, for example product type Jacke → OTTO category Outdoorjacke. Each rule lists attributes as rows: the OTTO attribute, the source kind, the source value and a Required tick. With OTTO connected, the attribute names come from OTTO's catalogue and one click adds every attribute OTTO expects for the category, required ones pre-ticked.

OTTO category fields are search fields: OTTO has about 14,500 categories, so type part of a name (umlauts can be written as ae, oe, ue) and pick one of the suggestions. A name OTTO does not know is marked in red.

Manufacturer: name and address of the manufacturer for the EU General Product Safety Regulation. It is required for every product and is sent with every variant.

Advanced: edit as JSON exposes the full schema, including transforms and fields the form does not show. Saving there replaces the whole mapping.

Source kind: ValueMeaning
Variant option: FarbeThe variant's value of the option named Farbe
Metafield: custom.materialA product or variant metafield by namespace.key
Product field: titleA product or variant field: title, vendor, productType, handle, sku, barcode, price
Fixed value: GanzjährigThe same fixed text for every variant
Template: {{title}} {{option.Farbe}}Text built from fields and options
Tag prefix: material:The rest of a tag that starts with the prefix, e.g. material:Wolle → Wolle
The Mapping page: brand source, VAT default and a category rule with its attribute rows
The Mapping page: brand source, VAT default and a category rule with its attribute rows

Dry run

The dry run reads your products, applies the mapping and checks the result against OTTO's rules and the live category catalogue, without sending anything. It reports one row per problem with the SKU, the field, an explanation and the next step.

Filter with a Shopify search such as tag:otto to check a subset. Fix the data in Shopify, run again, and push once the result shows no problems.

CodeWhat to do
MAPPING_SKU_MISSINGThe variant has no SKU in Shopify. Give every variant a SKU; OTTO needs it as the stable key.
MAPPING_CATEGORY_UNMATCHEDNo category rule matches the product type and no default category is set. Add a rule or a default category in Mapping.
MAPPING_BRAND_UNRESOLVEDThe brand source is empty for this product. Fill the vendor field (or the source you chose) with a brand OTTO knows.
MAPPING_ATTRIBUTE_MISSINGA required attribute (marked with *) has no value. Fill the option, metafield or field the rule points to.
MAPPING_ATTRIBUTE_INVALIDA value could not be converted (for example text where OTTO expects a number). Correct the value in Shopify.
SKU_INVALID / PRODUCT_REFERENCE_INVALIDSKU or product reference is too long or contains control characters. At most 50 printable characters, no leading or trailing spaces.
SKU_DUPLICATE / EAN_DUPLICATETwo variants share a SKU or an EAN. Each must be unique across your whole assortment.
EAN_INVALIDThe barcode is not a valid GTIN (length or check digit). Enter the EAN exactly as printed on the product.
EAN_INTERNAL_RANGEThe EAN starts with 2, which is a shop-internal range. OTTO only accepts officially assigned EANs.
IMAGE_MISSING / IMAGE_TOO_SMALL / IMAGE_TOO_LARGE / IMAGE_URL_INVALIDOTTO needs at least one JPG or PNG per product, at least 500 × 1000 px and at most 4500 px wide, reachable over https. Attach a suitable image in Shopify.
PRICE_INVALID / CURRENCY_UNSUPPORTEDThe price must be greater than 0 and in EUR. Set the store currency to EUR.
COMPLIANCE_MISSINGThe manufacturer address for product safety (GPSR) is missing. Fill the manufacturer block in Mapping.
BRAND_UNKNOWN / CATEGORY_UNKNOWNOTTO does not know this brand or category name. Use the names from the OTTO catalogue; the mapping page lists the categories.
ATTRIBUTE_REQUIRED / ATTRIBUTE_VALUE_NOT_ALLOWEDThe OTTO category demands an attribute, or only accepts certain values (for example sizes XS to XL). Map the attribute and use an allowed value.
IMMUTABLE_FIELD_CHANGEDProduct reference or EAN of an SKU already at OTTO changed. OTTO never accepts that: keep the old value or create a new SKU.
The Dry run page with the stored result: 75 of 76 variants ready and the two problems with their next step
The Dry run page with the stored result: 75 of 76 variants ready and the two problems with their next step

Sync

Orders and returns are fetched automatically because OTTO has no webhooks: new orders every 2 minutes, returns every 10 minutes, receipts every 30 minutes. Products, stock and prices are pushed when they change in Shopify (via Shopify's webhooks) or when you press a button on the Sync page. Every product push also assigns the items to your OTTO shipping profile.

Every run only sends what changed since the last successful run, so repeated runs are cheap and safe. The Log at the bottom lists each run with its result.

Safe mode pauses an inventory sync that would set an unusually large share of your OTTO stock to 0, typically after a faulty import in Shopify. The thresholds are in Settings; if the zeros are correct, tick "Allow setting many items to 0 in this run" and run again.

TaskTrigger
Product pushProduct created or updated in Shopify; Push products to OTTO
Price syncProduct updated; Sync prices
Inventory syncProduct updated; Sync inventory (safe mode applies)
Order importEvery 2 minutes; Fetch orders
Return importEvery 10 minutes
Receipt importEvery 30 minutes
Shipping profile assignmentWith every product push; changing the profile reassigns all items
The Sync page: run-now buttons, task filter and the log of the latest order, return, stock and price runs
The Sync page: run-now buttons, task filter and the log of the latest order, return, stock and price runs

Orders

An OTTO order appears in Shopify as a paid order from the channel Otto Connect. The customer's delivery address is the one OTTO transmitted; the e-mail is OTTO's relay address for that customer, so replies stay inside OTTO's system.

Line items carry the OTTO position item id and the EAN as properties, prices are gross with the VAT rate per line, and the order is tagged OTTO and otto:<order number>. A note states the OTTO order number and payment method.

OTTO issues the customer invoice itself. Do not send your own invoice for OTTO orders; the app imports OTTO's receipts (see Receipts).

Testing in the sandbox: Create test orders on the Overview asks OTTO to create its test orders for your products. They are imported with the next order fetch, within a few minutes. The button only exists in the sandbox.

A Shopify order created from an OTTO Market order: OTTO position ids, EAN, DHL tracking and 19 % VAT
A Shopify order created from an OTTO Market order: OTTO position ids, EAN, DHL tracking and 19 % VAT

Receipts

OTTO issues invoices and credit notes to your customers on your behalf. The app imports them every 30 minutes.

In Shopify, receipt numbers and amounts are stored on the Shopify order in the metafield otto_connect.receipts, and the Receipts page lists the receipts of the last 90 days with PDF download.

In Shopware, OTTO's PDF is attached to the Shopware order as a document: an invoice for purchases, a credit note for refunds.

Shipments

Fulfil the order in Shopify as usual and enter the tracking number and carrier. The app confirms the shipment to OTTO within seconds; OTTO then marks the positions as sent and triggers the customer notification.

The carrier is taken from the name you pick in Shopify; the carrier rows in Settings map your own names (compared ignoring case) to OTTO's carriers. If no name matches, the app recognises the carrier from the tracking number format.

Tracking number formatCarrier
1Z + 16 charactersUPS
00, JD or JJD + 18 or more digits, or 20 digits, or 12 digitsDHL
H + 19 digitsHermes
14 digitsDPD
11 digitsGLS

Returns and cancellations

If OTTO cancels positions (for example the customer withdraws before shipment), the app cancels the same line items in Shopify; a partial cancellation is noted on the order and tagged otto:teilstorno. If you cancel an OTTO order in Shopify before shipping, the app cancels the positions at OTTO.

Returns that OTTO announces are imported as return events in your shop. OTTO refunds the customer itself; your task is to accept or reject the return once the parcel arrives.

Price reduction

To refund part of the price of a shipped item that was not returned, for example for a small defect, open the Price reduction page and load the OTTO order by its number. The page shows what was invoiced, what was refunded so far and the maximum left. Enter the amount and confirm; OTTO pays it out and issues a partial credit note.

A price reduction is a deliberate manual action. Refunds you make in Shopify or Shopware are not forwarded to OTTO, so the customer is not refunded twice. Before shipment you cancel instead; returned items are refunded through the return.

Needs attention

Every failure that needs a decision from you lands here once, with the SKU, an explanation and a next step: Fix the data, Retry later, Reconnect OTTO or Contact support. After fixing the cause press Retry; entries close automatically when the next run of that SKU succeeds, or mark them as done.

The Overview shows the count and the health of each task (last run, last success) so you see at a glance when something has stalled.

The Needs attention page listing each problem with an explanation, the next step, Retry and Mark as done
The Needs attention page listing each problem with an explanation, the next step, Retry and Mark as done