What an order contains

From WooCommerce to the sales order

WooCommerce	Odoo
Order number	Order name with prefix (WC-1046), Customer Reference, store number
Created date (GMT)	Order date
Currency	Pricelist in that currency (see Orders tab)
Customer ID, billing and shipping address	Customer, invoice address, delivery address (Customers)
Payment method and title	Payment method of the store
Date paid	Paid on the Online Store tab
Line items	Product lines
Coupons	Discount line(s) with the codes
Shipping lines	Shipping lines
Fee lines	Fee lines
Tax lines (rate ID, label, %)	Taxes on each line
Customer note	Chatter message and Customer Note
Total	Store Total
Refunds	Credit notes (Refunds from WooCommerce)

Product lines and discounts

Each line item becomes one line with:

• the product found by variation ID, product ID or SKU (How products are matched),
• the quantity,
• the unit price before discounts (line subtotal divided by quantity),
• the line's taxes (Taxes).

The difference between the line subtotal (before coupons) and total (after coupons) of all lines becomes discount lines, one per tax combination, so taxes stay correct. They are labelled Discount (CODE1, CODE2) with the coupon codes.

Shipping, discount and fee lines

Besides product lines, an imported order can have shipping, discount and fee lines. Each uses a product, so they land on the right accounts and reports.

Shipping

• Every shipping method WooCommerce uses gets a line in Online Stores > Configuration > Shipping Methods (name and Store Code) the first time it appears.
• Set an Odoo Product on a method to book its shipping lines on that product, for example one product per carrier. Empty: the store's Shipping Product (Shipping (online store), CB-SHIP).
• The line amount is the shipping price after shipping discounts, without tax, with the tax the store charged on shipping.
• Without any shipping product, the order waits with Set a shipping product on the store.

Discounts

Product lines are imported at their price before discounts. The discounts (discount codes, automatic discounts, coupons) become discount lines with the Discount Product (Discount (online store), CB-DISC), with a negative price:

• one discount line per combination of taxes, so each discount reduces the right tax (a store with 13% and 5% products gets two discount lines);
• labelled Discount, or Discount (CODE1, CODE2) with the codes used; the codes are also shown in Coupons on the order's Online Store tab.

tip

Separate discount lines keep the product prices clean in your sales reports, and show the total discount given per order.

Fees

Fee lines (sent by some platforms, for example a payment surcharge or gift wrap) use the Fee Product (Fee (online store), CB-FEE). Without a fee product, such an order waits with Set a fee product on the store.

Good to know

• The three products are created when the app is installed. You can rename them, change their accounts and taxes, or choose other products on the store.
• Change the products before the first import: existing orders keep their lines.

Total check

After import Odoo compares its total with the WooCommerce total. A difference of more than one cent sets Total Differs From Store on the order, logs a warning and counts on the dashboard. The usual cause is a tax mapped to the wrong Odoo tax. See Taxes.