11 Commits

Author SHA1 Message Date
6a541de9e6 feat: add locationCode to sales order lines
Uses wbc_location_code setting on all order lines including shipping.
Header-level location to be handled by BC extension post-processing.

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
2026-02-17 18:48:36 +01:00
5716ff7742 feat: add auto-release sales order option
PATCH salesOrders status to 'Released' after creation and line items.
Controlled by Auto-Release Order checkbox in Order Settings.

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
2026-02-17 16:12:11 +01:00
782681b30f feat: customer lookup by NIF with default customer fallback
- Search BC customers by taxRegistrationNumber (NIF/CIF from _nif meta)
- If NIF found in BC, use that customer; if not, create with NIF
- If no NIF on order, use configurable default customer number
- Add Default Customer Number setting in Order Settings tab

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
2026-02-17 16:06:42 +01:00
6bc70afaf1 fix: use English enum value 'Active' for Status filter
BC OData filter options are in English (Draft/Active/Inactive),
not the localized display values.

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
2026-02-17 13:48:04 +01:00
7cbbf3dec1 fix: use Asset_No instead of Product_No for ListaPrecios filter
Product_No doesn't exist on NAV.ListaPrecios, the correct field
is Asset_No (field 8).

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
2026-02-17 13:45:47 +01:00
d6987c110c fix: simplify ListaPrecios filter to price list code + active status
Remove Source_Type filter to allow flexible assignment types per
price list in BC.

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
2026-02-17 13:40:31 +01:00
7ce028b7b8 fix: correct ListaPrecios OData field names and enum values
Source_Type (not Assign_to_Type), Status='Activo' and
Source_Type='Todos los clientes' (Spanish enum values from BC).

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
2026-02-17 13:38:25 +01:00
2495b82e66 feat: integrate custom OData endpoints for stock and price sync
Replace broken itemLedgerEntries approach with custom ItemByLocation
OData V4 endpoint for location-specific stock. Add ListaPrecios
endpoint for price list sync (B2C regular, B2C_OF sale price) with
filters for active status and all-customers assignment.

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
2026-02-17 13:14:15 +01:00
2c36344932 feat: WooCommerce-first sync + location code filter
Reversed the product sync direction: instead of pulling all 60k+ items
from BC and matching against WooCommerce (600+ paginated API calls that
timeout), now iterates the ~100 WooCommerce products and queries BC for
each one by GTIN/item number (1-2 API calls per product).

Added Location Code setting (e.g. "ICP") to filter stock by BC location.
Uses Item Ledger Entries endpoint to sum per-location stock. Falls back
to total inventory if the endpoint is unavailable.

Also registered wbc_location_code in sync settings group and uninstall.

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
2026-02-17 10:26:02 +01:00
c06d6e4352 fix: client secret getting corrupted on save
Two bugs fixed:

1. sanitize_text_field() was stripping special characters from Azure AD
   client secrets (e.g. %XX sequences, angle brackets). Replaced with
   trim() to preserve the raw secret before encryption.

2. All settings tabs shared one option group (wbc_settings), so saving
   from any tab would trigger sanitize callbacks for ALL settings. This
   caused checkboxes on other tabs to reset to 'no' and could interfere
   with the client secret. Split into per-tab groups: wbc_connection,
   wbc_sync, wbc_orders.

Also clears OAuth token cache when client secret is changed.

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
2026-02-17 10:15:07 +01:00
b64397dcd3 feat: WooCommerce Business Central integration plugin
Native PHP plugin (no Composer) that syncs:
- Product stock and pricing from BC to WooCommerce (scheduled cron)
- Orders from WooCommerce to BC (on payment received)
- Auto-creates customers in BC from WooCommerce billing data

Product matching: WooCommerce SKU → BC Item Number, fallback to GTIN (EAN).
OAuth2 client credentials auth with encrypted secret storage.
Admin settings page with connection test, manual sync, and log viewer.

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
2026-02-17 09:59:53 +01:00