1. Contents
  2. Reference
  3. Channels and tasks
  4. WooCommerce
  5. Orders Download

Orders Download

The task fetches the orders from the WooCommerce shop into TRADElube, with their line items, the two addresses and the buyer. It is the one task of the channel you will run most often in day-to-day operation, and the only one creating customers along the way.

What gets transferred

For each order in the shop an order is created in TRADElube, and with it its line items and its addresses. The customer is created along with it if you set that up: the Selection section has the row Existing Customer for it, which looks the buyer up in the client by their email address. Where it finds none, TRADElube creates one. That is why there is no customers download task: customers are created together with the order that triggered them.

Four kinds of line item come along: the product items plus discounts, vouchers and shipping costs. Each of them has its own section in the plan, because in the shop they come from different lists.

The task's own configuration

The task's Configuration section carries a single field.

Field Meaning Note
Age of Orders to Sync How many days back the shop is searched Preset to 14

The field limits what is searched, not what is transferred. An older order still changing in the shop drops out of the window and no longer comes along. Fourteen days are ample for day-to-day operation. When connecting a shop for the first time and needing its order history, raise the value for the first execution and set it back afterwards. Too large a value costs time on every execution, because the shop delivers the same long list every time.

How the transfer plan is built

One plan with nine sections, which makes its tab bar longer than the screen is wide: the arrows at its ends scroll it along.

Transfer plan of the orders download task with the Product Items section open and the section bar scrolled along

Section What sits in it
Selection Which of the shop's orders are taken over, and how the buyer is found in the client
Common The order itself: release, order number, order time, Order Status, Payment Method, Shipping Method and the customer note
Customer The entries the customer is created from: name, company, email, phone and the VAT number
Billing Address The order's billing address, with email and phone number
Shipping Address The shipping address, without those two fields
Product Items Per ordered item: product number, name, quantity, gross price and tax rate
Discount Items The same for a discount granted
Voucher Items The same for a voucher redeemed, plus its code
Shipping Items The same for the shipping costs, with the shipping method as the description

Order status, payment method and shipping method come through the channel's mappings. What the shop delivers is a key such as processing or bacs. Which status and which payment method stands behind it in TRADElube is decided by the tabs Order Status, Payment Methods and Shipping Methods, see WooCommerce. Where a row is missing there, the field on the order stays empty.

TRADElube calculates the price and tax rate per item instead of taking them over. The interface says so as well: the sources are called Gross Price and Tax Rate, both with the addition Computed. The reason is that WooCommerce keeps a total and a tax amount per item and no unit price. From quantity, total and tax amount both are derived back.

The release is a decision and not a take-over. The row Release in the Common section carries a script out of the box that releases an order as soon as its status in the shop is one of the five ordinary states. What your business regards as released is decided here and not by the shop. How things continue is under Orders.

Special features and limits

Orders come in only. An order you create in TRADElube does not go into the shop, what goes back is the status alone, see Orders Status Upload.

Failed orders are left out by default. The script in the Condition row of the Selection section lets everything through except the status failed. That is a preset and not a limit: where you need those too, change the condition.

The buyer is recognized through the email address, and that is the only entry two orders are recognized as the same customer by. If somebody orders as a guest once with a different address, a second customer is created.

Further reading