Order Sync & Conditional Mappings

(WooCommerce → NetSuite)

Orders sync on creation, update, or deletion, automatically or manually.

Configure under NetSuite Integration → Order Settings.

General settings

Setting	What it does
Enable Order Sync	Master on/off.
Sync Order As	Sales Order or Cash Sale.
Sync Orders Status	The WooCommerce status that triggers sync (defaults to Processing if empty).
Create Woo Orders Deposit	Also create a Customer Deposit.
Auto Create Invoice	Create an invoice for the sales order at a chosen status.
Order Delete on NetSuite on WC Delete	Remove the order in NetSuite when deleted in WooCommerce.
Enable Coupon Sync	Sync coupons (requires NS Promo Custom Form ID and Discount ID).
Display Tracking Number	Show NetSuite tracking numbers on the customer dashboard.

Order line-item settings

Setting	What it does
Add Shipping As a Line Item	Sends shipping cost as a line item using this NetSuite item’s internal ID.
Item Location	Send location with line items (default or custom).
Send Price Level on Items	Send a price level with line items.
Send Line-Item Unit Rate	Send WooCommerce per-unit rate as the NetSuite Line Rate
Apply Tax Code to Items	Sync a selected tax code with order lines.

Conditional Mapping — three operations

The same three operations as customers (Operation 1 condition-based, Operation 2 fixed value, Operation 3 WC field), using Order Field as the WC Field Source. Useful for mapping NetSuite default and custom fields like SalesRep, Location, Class, custom body fields (custbody…), and record references.

Shipping Method mapping (uses Operation 1)

• WC Field Source: Order Field
• Condition: e.g. WHERE shipping_method IS “UPS Ground”
• Attribute Type: Default NetSuite field
• NS Field: e.g. shipMethod
• NS Field Value: the internal ID of the NetSuite ship method (find internal IDs under the relevant NetSuite list, e.g. Setup → Company → Subsidiaries for subsidiaries).

Payment Method mapping (uses Operation 1)

• WC Field Source: Order Field
• Condition: e.g. WHERE payment_method IS “cod”
• Attribute Type: Default NetSuite field
• NS Field: the target field
• NS Field Value: the selected record’s internal ID from NetSuite.

Duplicate protection: each WooCommerce order is tagged with its NetSuite internal ID, so the same order is never created twice.

---

Refund Sync (Two-Way)

Enable under Order Settings → Refund Settings:

• NetSuite to Woo — pulls refunded orders (Return Authorizations) from NetSuite into WooCommerce.
• Woo to NetSuite — a WooCommerce refund creates a matching Return Authorization in NetSuite.

Processing a return in NetSuite (reference)

1. Transactions → Sales → Enter Sales Orders (list) and open the order.
2. Click Fulfill.
3. Change the item status from Picked to Shipped and set the product location.
4. Verify inventory location via the Created From link and the Model No reference.
5. Confirm location availability on the Inventory Item page.
6. Save the status/location changes.
7. Back on the sales order, click Authorize Return.
8. Select the item location and Save.
9. On the Return Authorization page, click Receive.
10. Choose whether to restock the item.
11. Click Refund to complete.

For Woo → NetSuite, complete the fulfillment steps (1–7) in NetSuite, then process the refund inside the WooCommerce order.

---

Order Tracking & Fulfillment

Configure under Order Settings → Fulfilment Settings.

Setting	What it does
Enable Fulfilment Sync	Sync fulfilled NetSuite orders back to WooCommerce.
Auto Complete Order on Fulillment	Mark fulfilled/billed orders as Completed in WooCommerce.
Email Customer Tracking	Email the customer the tracking number (sent once per order).
Order Field with Order Meta Key Field	Store the tracking number, shipping courier, and pickup/ship date in chosen meta keys (so they can populate customer notifications and other plugins).

The order sync setting is used to sync the order from WooCommerce to NetSuite. Orders are synced when created, updated or deleted. Orders can be synced manually or automatically. Along with default settings, there is a feature for Conditional Mapping as well. With Conditional Mapping, you can map all NetSuite Order’s default and custom fields like SalesRep, Location, Class or any other custom field.