# Woocommerce Orders

<p class="doc-lead">Woocommerce Orders imports orders from your connected WooCommerce store and converts them to Sale Invoices. Use it to bridge online sales with ERP billing and inventory.</p>

<div class="doc-toc">
<p class="doc-toc-title">On this page</p>
<div class="doc-toc-section">
<div class="doc-toc-links">
<a href="#/sales/woocommerce-orders?id=overview">Overview</a>
<a href="#/sales/woocommerce-orders?id=fields">List Columns</a>
<a href="#/sales/woocommerce-orders?id=how-it-works">How It Works</a>
<a href="#/sales/woocommerce-orders?id=actions">Actions</a>
<a href="#/sales/woocommerce-orders?id=faq">FAQ</a>
<a href="#/sales/woocommerce-orders?id=related">Related</a>
</div>
</div>
</div>

<hr class="doc-section-divider">

<h2 id="overview">Overview &amp; List View</h2>

Go to <b>Sales → Woocommerce Orders</b> from the left menu.

WooCommerce connection credentials are configured under <b>Settings → Ecommerce → Woocommerce</b>. After connection, import orders for a date range and convert pending rows to sale invoices.

<b>Filters</b>

| **Filter** | **Description** |
|------------|-----------------|
| From Date | Start of the import date range. |
| To Date | End of the import date range. |

<b>List header actions</b>

| **Action** | **Description** |
|------------|-----------------|
| Import From Woocommerce | Fetches orders from WooCommerce for the selected date range. |

<b>List row actions</b>

| **Action** | **Description** |
|------------|-----------------|
| Convert To Sale Invoice | Creates a sale invoice from the imported order when not yet converted. |

<b>Woocommerce Orders</b>

<img src="sales/images/woocommerce-orders.webp" alt="Woocommerce Orders" loading="lazy">

<hr class="doc-section-divider">

<h2 id="fields">List Columns</h2>

| **Column** | **Description** |
|------------|-----------------|
| ID | System record number for the imported order. |
| Date | Order date from WooCommerce. |
| WooOrder No | WooCommerce order number. |
| WooStatus | Status from WooCommerce (e.g. processing, completed). |
| Customer | Billing name from the WooCommerce order. |
| City | Billing city. |
| Total | Order total amount. |
| Fetched On | When the order was imported into FreeSpace. |
| Action | <b>Convert To Sale Invoice</b> when not yet converted; <b>Done</b> when already converted. |

<hr class="doc-section-divider">

<h2 id="how-it-works">How It Works</h2>

<ol>
<li>Configure WooCommerce API on <a href="#/settings/woocommerce-settings">Woocommerce Settings</a> (store URL, keys, default customer, sale type, etc.).</li>
<li>On this screen, set <b>From</b> and <b>To</b> dates and click <b>Import From Woocommerce</b>. New orders in the range are fetched and listed.</li>
<li>For each pending row, click <b>Convert To Sale Invoice</b>. The system creates a Sale Invoice pre-filled with customer, items, and totals mapped from the WooCommerce order.</li>
<li>Converted rows show <b>Done</b>. The sale invoice posts through normal sale invoice approve/posting rules.</li>
</ol>

<p><b>Connected reports:</b> Converted invoices appear in <a href="#/sales/reports/sale-report">Sale Report</a>, <a href="#/sales/reports/sale-report-adv">Sale Report Advanced</a>, <a href="#/sales/reports/customer-statement">Customer Statement</a>, and inventory reports when stock is affected on invoice approval.</p>

<hr class="doc-section-divider">

<h2 id="actions">Actions</h2>

| **Action** | **Description** |
|------------|-----------------|
| Import From Woocommerce | Fetches orders for the selected From/To date range. |
| Convert To Sale Invoice | Creates a sale invoice from the selected imported order. |

<hr class="doc-section-divider">

<h2 id="faq">FAQ</h2>

<b>Why is Import disabled or failing?</b><br>
Verify WooCommerce settings, API credentials, and network access. Ensure the date range includes orders in WooCommerce.

<b>Can I re-import the same order?</b><br>
Converted orders are marked Done. Duplicate WooOrder numbers are typically skipped or updated per import logic — check the list after import.

<b>Does conversion post to accounts immediately?</b><br>
The invoice is created in draft or per your conversion defaults. Approve the sale invoice to post to accounts and inventory.

<b>Why does conversion fail with missing SKU?</b><br>
Every WooCommerce line SKU must match an active item in ERP. Create or map items before converting orders with unknown SKUs.

<b>Why does order total mismatch block conversion?</b><br>
ERP recomputes tax and rounding from your sale type and item prices. Align WooCommerce discounts/shipping or adjust lines after conversion if totals differ.

<b>What settings are required before import?</b><br>
Configure WooCommerce URL and API keys, plus default sale type, cash account, inventory center, and customer in <a href="#/settings/woocommerce-settings">Woocommerce Settings</a>.

<b>Can I convert the same WooCommerce order twice?</b><br>
No. Orders already converted to a sale invoice are marked Done and blocked from duplicate conversion.

<hr class="doc-section-divider">

<h2 id="related">Related Topics</h2>

<ul>
<li><a href="#/settings/woocommerce-settings">Woocommerce Settings</a></li>
<li><a href="#/sales/sale-invoice">Sale Invoice</a></li>
<li><a href="#/sales/customers">Customers</a></li>
<li><a href="#/sales/sale-types">Sale Types</a></li>
</ul>