Hi everyone,
I am importing orders from WooCommerce to ODOO. ODOO ist matching taxes correctly and WooCommerce is set up to use One-Stop-Shop for Europe.
BACKGROUND:
One-Stop-Shop means that you have the same price for a product in European countries and, depending on which country the product is shipped to, a different tax rate is applied. In the end, this means you end up with different margins per country because the various tax rates get deducted from the same price in each country.
To create this set up, ODOO is told that the imported prices include taxes, but my problem is that ODOO applies taxes to the shipping correctly and misses it for the line item.
Can somebody help me with this?
THIS IS WHAT IS IMPORTED:
{"id": 9130, "parent_id": 0, "status": "processing", "currency": "EUR", "version": "7.0.0", "prices_include_tax": true, "date_created": "2022-10-21T12:18:02", "date_modified": "2022-10-21T12:18:56", "discount_total": "0.00", "discount_tax": "0.00", "shipping_total": "14.13", "shipping_tax": "2.83", "cart_tax": "0.17", "total": "17.96", "total_tax": "2.99", "customer_id": 2, "order_key": "wc_order_HeoCH61kxS2Pm", "billing": {"first_name": "Timo", "last_name": "Frankreich", "company": "", "address_1": "Bulgarienstr. 10", "address_2": "", "city": "Esslingen", "state": "", "postcode": "73230", "country": "FR", "email": "sales@customradioshop.de", "phone": "", "title": "", "title_formatted": ""}, "shipping": {"first_name": "Timo", "last_name": "Frankreich", "company": "", "address_1": "Bulgarienstr. 10", "address_2": "", "city": "Esslingen", "state": "", "postcode": "73230", "country": "FR", "phone": "", "title": "", "title_formatted": ""}, "payment_method": "woocommerce_payments", "payment_method_title": "Visa Kredit-Karte", "transaction_id": "pi_3LvIJ52EC3iAc2xO15WfVlf2", "customer_ip_address": "2a02:8070:c686:a600:f439:f24f:b906:42c9", "customer_user_agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/106.0.0.0 Safari/537.36", "created_via": "store-api", "customer_note": "", "date_completed": null, "date_paid": "2022-10-21T12:18:55", "cart_hash": "3725d61e5503174b98dc16540f797fbb", "number": "9130", "meta_data": [{"id": 574509, "key": "_relevanssi_noindex_reason", "value": "Rank MathWooCommerce"}, {"id": 574540, "key": "_shipping_hash", "value": "9d4568c009d203ab10e33ea9953a0264"}, {"id": 574541, "key": "_coupons_hash", "value": "d751713988987e9331980363e24189ce"}, {"id": 574542, "key": "_fees_hash", "value": "d751713988987e9331980363e24189ce"}, {"id": 574543, "key": "_taxes_hash", "value": "eb1b06a18e9fa23194e05e2b14613689"}, {"id": 574544, "key": "is_vat_exempt", "value": "no"}, {"id": 574545, "key": "_gzd_version", "value": "3.10.6"}, {"id": 574547, "key": "_new_order_email_sent", "value": "true"}, {"id": 574550, "key": "_intent_id", "value": "pi_3LvIJ52EC3iAc2xO15WfVlf2"}, {"id": 574551, "key": "_intention_status", "value": "succeeded"}, {"id": 574552, "key": "_stripe_customer_id", "value": "cus_Lu8eZe8TzBwYfi"}, {"id": 574553, "key": "_wcpay_intent_currency", "value": "eur"}, {"id": 574555, "key": "_charge_id", "value": "ch_3LvIJ52EC3iAc2xO19lDkuKc"}, {"id": 574556, "key": "_payment_method_id", "value": "pm_1LvIJU2EC3iAc2xO87nLgRD4"}], "line_items": [{"id": 625, "name": "Premium STEREO rear shelf speaker, CADILLAC, 1967-1974 (with factory MONO)", "product_id": 9069, "variation_id": 0, "quantity": 1, "tax_class": "", "subtotal": "0.83", "subtotal_tax": "0.17", "total": "0.83", "total_tax": "0.17", "taxes": [{"id": 369, "total": "0.166667", "subtotal": "0.166667"}], "meta_data": [{"id": 4756, "key": "_unit", "value": "", "display_key": "_unit", "display_value": ""}, {"id": 4757, "key": "_unit_base", "value": "", "display_key": "_unit_base", "display_value": ""}, {"id": 4758, "key": "_unit_product", "value": "", "display_key": "_unit_product", "display_value": ""}, {"id": 4759, "key": "_item_desc", "value": "", "display_key": "_item_desc", "display_value": ""}, {"id": 4760, "key": "_defect_description", "value": "", "display_key": "_defect_description", "display_value": ""}, {"id": 4761, "key": "_delivery_time", "value": "", "display_key": "_delivery_time", "display_value": ""}, {"id": 4762, "key": "_min_age", "value": "", "display_key": "_min_age", "display_value": ""}, {"id": 4763, "key": "_deposit_type", "value": "", "display_key": "_deposit_type", "display_value": ""}, {"id": 4764, "key": "_deposit_amount_per_unit", "value": "0", "display_key": "_deposit_amount_per_unit", "display_value": "0"}, {"id": 4765, "key": "_deposit_net_amount_per_unit", "value": "0", "display_key": "_deposit_net_amount_per_unit", "display_value": "0"}, {"id": 4766, "key": "_deposit_quantity", "value": "1", "display_key": "_deposit_quantity", "display_value": "1"}, {"id": 4767, "key": "_deposit_amount", "value": "0", "display_key": "_deposit_amount", "display_value": "0"}, {"id": 4768, "key": "_deposit_net_amount", "value": "0", "display_key": "_deposit_net_amount", "display_value": "0"}, {"id": 4769, "key": "_deposit_packaging_type", "value": "", "display_key": "_deposit_packaging_type", "display_value": ""}, {"id": 4807, "key": "_reduced_stock", "value": "1", "display_key": "_reduced_stock", "display_value": "1"}], "sku": "WCRS102001", "price": 0.833333, "image": {"id": "9065", "src": "https://customradioshop.de/wp-content/uploads/2022/09/Premium-Ersatzlautsprecher_CADILLAC_Alle_Modelle_nur_Hardtop_und_MONO_Baujahr_1967-1974_hinten_1344.jpg"}, "parent_name": null}], "tax_lines": [{"id": 629, "rate_code": "FR-20.0%-UST-SHP", "rate_id": 369, "label": "20.0%-USt-SHP", "compound": false, "tax_total": "0.17", "shipping_tax_total": "2.83", "rate_percent": 20, "meta_data": []}], "shipping_lines": [{"id": 630, "method_title": "DHL Paket International", "method_id": "flat_rate", "instance_id": "46", "total": "14.13", "total_tax": "2.83", "taxes": [{"id": 369, "total": "2.825", "subtotal": ""}], "meta_data": [{"id": 4804, "key": "Positionen", "value": "Premium STEREO rear shelf speaker, CADILLAC, 1967-1974 (with factory MONO) × 1", "display_key": "Positionen", "display_value": "Premium STEREO rear shelf speaker, CADILLAC, 1967-1974 (with factory MONO) × 1"}, {"id": 4805, "key": "_split_taxes", "value": {"": {"taxable_amount": "16.95", "tax_share": "1", "tax_rates": ["369"], "net_amount": "14.125", "includes_tax": "1"}}, "display_key": "_split_taxes", "display_value": {"": {"taxable_amount": "16.95", "tax_share": "1", "tax_rates": ["369"], "net_amount": "14.125", "includes_tax": "1"}}}, {"id": 4806, "key": "_tax_shares", "value": {"": {"total": "0.83333333", "key": "369", "share": "1"}}, "display_key": "_tax_shares", "display_value": {"": {"total": "0.83333333", "key": "369", "share": "1"}}}]}], "fee_lines": [], "coupon_lines": [], "refunds": [], "payment_url": "https://customradioshop.de/ersatzteile-fur-dein-radio/kasse/order-pay/9130/?pay_for_order=true&key=wc_order_HeoCH61kxS2Pm", "is_editable": false, "needs_payment": false, "needs_processing": true, "date_created_gmt": "2022-10-21T10:18:02", "date_modified_gmt": "2022-10-21T10:18:56", "date_completed_gmt": null, "date_paid_gmt": "2022-10-21T10:18:55", "shipments": [{"id": 27, "shipment_number": "27", "date_created": "2022-10-21T12:18:56", "date_created_gmt": "2022-10-21T10:18:56", "date_sent": null, "date_sent_gmt": null, "est_delivery_date": null, "est_delivery_date_gmt": null, "total": "1.00", "subtotal": "1.00", "additional_total": "16.96", "order_id": 9130, "order_number": "9130", "weight": "1.20", "content_weight": "1.20", "weight_unit": "kg", "packaging_id": 1, "packaging_weight": "0.14", "status": "processing", "tracking_id": "", "tracking_url": "", "shipping_provider": "dhl", "content_dimensions": {"length": "0.00", "width": "0.00", "height": "0.00"}, "dimensions": {"length": "25.00", "width": "17.50", "height": "10.00"}, "package_dimensions": {"length": "25.00", "width": "17.50", "height": "10.00"}, "dimension_unit": "cm", "address": {"first_name": "Timo", "last_name": "Frankreich", "company": "", "address_1": "Bulgarienstr. 10", "address_2": "", "city": "Esslingen", "state": "", "postcode": "73230", "country": "FR", "phone": "", "email": "sales@customradioshop.de"}, "sender_address": [], "is_customer_requested": false, "items": [{"id": 27, "name": "Premium STEREO rear shelf speaker, CADILLAC, 1967-1974 (with factory MONO)", "order_item_id": 625, "product_id": 9069, "sku": "WCRS102001", "quantity": 1, "total": "1.00", "subtotal": "1.00", "weight": "1.20", "dimensions": {"length": "0.00", "width": "0.00", "height": "0.00"}, "hs_code": "", "manufacture_country": "DE", "attributes": [""], "meta_data": []}], "meta_data": []}], "shipping_status": "not-shipped", "currency_symbol": "\u20ac", "parcel_delivery_opted_in": "", "direct_debit": {"holder": "", "iban": "", "bic": "", "mandate_id": ""}, "_links": {"self": [{"href": "https://customradioshop.de/wp-json/wc/v3/orders/9130"}], "collection": [{"href": "https://customradioshop.de/wp-json/wc/v3/orders"}], "customer": [{"href": "https://customradioshop.de/wp-json/wc/v3/customers/2"}]}}
