n8n-nodes-myobv2

Comprehensive n8n community node for MYOB Business API integration. This node provides full CRUD operations for Sales Orders, Customers, Items, and Invoices.

Features

Supported Resources & Operations

📦 Sales Orders

• Create: Create sales orders with multiple line items (supports Shopify integration)
• Get: Retrieve sales order by UID
• List: List all sales orders with filtering

👥 Customers

• Create: Create new customers
• Get: Retrieve customer by UID
• List: List all customers with filtering

📋 Items/Inventory

• Create: Create new inventory items
• Get: Retrieve items by UID or SKU
• List: List all inventory items with filtering
• Get Inventory Items: Retrieve inventory items with stock levels for specific location

🧾 Invoices

• Get: Retrieve invoice by UID
• List: List all invoices with filtering
• Create from Sales Order: Convert existing sales orders to invoices

Key Capabilities

✅ Multi-Resource Operations - One node handles all MYOB entities
✅ Shopify Integration - Direct support for Shopify webhook data
✅ SKU Auto-Lookup - Automatic conversion of SKUs to MYOB UIDs
✅ Flexible Line Items - UI forms or dynamic JSON arrays
✅ Advanced Filtering - OData query support for list operations
✅ Error Handling - Graceful fallbacks and detailed error messages
✅ OAuth2 Authentication - Secure cloud-based authentication

Installation

From n8n Community Nodes

1. Go to Settings → Community Nodes
2. Enter n8n-nodes-myobv2
3. Click Install

Manual Installation

npm install n8n-nodes-myobv2

Setup

1. MYOB Developer Account

1. Register at MYOB Developers
2. Create a new app to get your API Key and Secret
3. Set redirect URI to: http://localhost:5678/rest/oauth2-credential/callback

2. n8n Credentials

1. Create new MYOB OAuth2 API credentials in n8n
2. Enter your Client ID (API Key) and Client Secret (API Secret)
3. Add your Company File GUID (found in MYOB cloud URL)
4. Click Connect my account and authorize

Usage Examples

Sales Order Operations

Create Sales Order from Shopify

// Configure node:
Resource: Sales Order
Operation: Create
Input Method: JSON Array
Line Items Data: {{ $json.line_items }}
Customer UID: "12345678-1234-1234-1234-123456789012"
Default SKU: "DEFAULT-ITEM"

Get Sales Order

Resource: Sales Order
Operation: Get
Sales Order UID: "87654321-4321-4321-4321-210987654321"

List Recent Sales Orders

Resource: Sales Order
Operation: List
Filter: Date gt datetime'2024-01-01T00:00:00'
Limit: 50

Customer Operations

Create Customer

Resource: Customer
Operation: Create
Customer Name: "Acme Corp"
Email: "orders@acme.com"
Phone: "+1-555-0123"

Find Customer by Name

Resource: Customer
Operation: List
Filter: CompanyName eq 'Acme Corp'

Item Operations

Get Item by SKU

Resource: Item
Operation: Get
Item SKU: "WIDGET-001"

Create New Item

Resource: Item
Operation: Create
Item Name: "Premium Widget"
Item SKU/Number: "WIDGET-PREMIUM"
Base Selling Price: 99.95

List Active Items

Resource: Item
Operation: List
Filter: IsActive eq true and IsSold eq true
Limit: 100

Get Inventory Items with Stock Levels

Resource: Item
Operation: Get Inventory Items
Location UID: "12345678-1234-1234-1234-123456789012"
Limit: 100
Filter: IsActive eq true and IsInventoried eq true

Returns:

{
  "success": true,
  "message": "Retrieved 25 inventory items for location",
  "locationUid": "12345678-1234-1234-1234-123456789012",
  "totalItems": 25,
  "itemsWithStock": 18,
  "items": [
    {
      "uid": "item-uid-123",
      "sku": "WIDGET-001",
      "description": "Premium Widget - Blue",
      "name": "Premium Widget",
      "quantityOnHand": 45,
      "availableQuantity": 40,
      "committedQuantity": 5,
      "locationName": "Main Warehouse",
      "baseSellingPrice": 29.95
    }
  ]
}

Invoice Operations

Create Invoice from Sales Order

Resource: Invoice
Operation: Create from Sales Order
Sales Order UID: "12345678-1234-1234-1234-123456789012"

List Recent Invoices

Resource: Invoice
Operation: List
Filter: Date gt datetime'2024-01-01T00:00:00'

Advanced Features

Dynamic Line Items (Shopify Integration)

The node automatically handles Shopify webhook data:

{
  "line_items": [
    {
      "sku": "WIDGET-001",
      "quantity": 2,
      "price": "29.95",
      "title": "Premium Widget",
      "variant_title": "Blue",
      "discount_allocations": [
        {"amount": "5.99"}
      ]
    }
  ]
}

Features:

• Automatic SKU lookup and UID resolution
• Discount calculation from Shopify data
• Fallback to default SKU for missing items
• Product title and variant consolidation

OData Filtering

Use OData query syntax for powerful filtering:

// Date ranges
Date gt datetime'2024-01-01T00:00:00'

// Text matching
CompanyName eq 'Acme Corp'

// Boolean filters  
IsActive eq true and IsSold eq true

// Numeric comparisons
BaseSellingPrice gt 50.00

// Multiple conditions
IsActive eq true and Date gt datetime'2024-01-01T00:00:00'

Error Handling

The node provides detailed error messages and graceful fallbacks:

• SKU not found → Falls back to default SKU
• Network errors → Detailed error context
• Validation errors → Clear field-specific messages
• API rate limits → Automatic retry suggestions

Field Reference

Sales Order Create Fields

Field	Type	Required	Description
Customer UID	String	Yes	MYOB customer GUID
Tax Inclusive	Boolean	No	Whether prices include tax
Purchase Order Number	String	No	Reference number
Journal Memo	String	No	Internal memo
Comment	String	No	Order comment
Shipping Address Lines 1-5	String	No	Multi-line shipping address
Shipping SKU	String	No	Shipping item SKU
Shipping Price	Number	No	Shipping cost
Input Method	Options	Yes	UI Form or JSON Array
Line Items Data	JSON	Conditional	Raw line items (JSON method)
Default SKU	String	Conditional	Fallback SKU (JSON method)

Customer Create Fields

Field	Type	Required	Description
Customer Name	String	Yes	Company/person name
Customer Number	String	No	Custom customer code
Email	String	No	Contact email
Phone	String	No	Contact phone

Item Create Fields

Field	Type	Required	Description
Item Name	String	Yes	Product name
Item SKU/Number	String	Yes	Unique identifier
Item Description	String	No	Product description
Base Selling Price	Number	No	Default price

Get Inventory Items Fields

Field	Type	Required	Description
Location UID	String	Yes	MYOB location GUID to get quantities for
Limit	Number	No	Max records (default: 100)
Filter	String	No	OData filter expression

List Operation Fields

Field	Type	Required	Description
Limit	Number	No	Max records (default: 100)
Filter	String	No	OData filter expression

Common Workflows

E-commerce → MYOB Integration

1. Shopify Webhook → MYOB Sales Order Create
2. Order Processing → MYOB Invoice Create from Sales Order
3. Customer Sync → MYOB Customer Create/Update

Inventory Management

1. CSV Import → MYOB Item Create
2. Stock Updates → MYOB Item Get/Update
3. Price Changes → MYOB Item List & Update

Reporting & Analytics

1. MYOB Sales Order List → Data Processing → Dashboard
2. MYOB Customer List → CRM Sync
3. MYOB Invoice List → Accounting Reports

Troubleshooting

Authentication Issues

Problem: invalid_client error
Solution: Verify Client ID and Client Secret match your MYOB app exactly

Problem: OAuth callback error
Solution: Ensure redirect URI is http://localhost:5678/rest/oauth2-credential/callback

SKU Lookup Failures

Problem: "SKU not found" errors
Solution: Set a valid Default SKU for fallback

Problem: Items created with wrong details
Solution: Verify SKU format matches MYOB exactly (case-sensitive)

API Rate Limits

Problem: 429 Too Many Requests
Solution: Add delays between requests or batch operations

Data Validation Errors

Problem: "Required field missing"
Solution: Check MYOB field requirements for your specific operation

API Coverage

MYOB Endpoints Used

• /Sale/Order/Item - Sales orders
• /Contact/Customer - Customers
• /Inventory/Item - Items/inventory
• /Sale/Invoice/Item - Invoices

Supported MYOB Features

✅ Item sales orders
✅ Customer management
✅ Inventory items
✅ Invoice creation
✅ OData filtering
✅ Pagination
✅ Error handling

Roadmap

🔄 Purchase orders
🔄 Payments
🔄 Tax codes
🔄 Accounts
🔄 Reports
🔄 Time billing

Version History

1.0.0

• Initial release with multi-resource support
• Sales Orders, Customers, Items, Invoices
• Shopify integration
• OData filtering
• Comprehensive error handling

Support

• GitHub: Issues & Feature Requests
• n8n Community: Community Forum
• Documentation: MYOB API Docs

License

MIT License - see LICENSE file for details.

Contributing

Contributions welcome! Please read our contributing guidelines and submit pull requests.