BC Export Setup

This guide walks you through setting up Business Central export functionality.

Step 1: Create Database Table

First, ensure the API connections table exists in your WordPress database:

CREATE TABLE IF NOT EXISTS `wp_gsm_api_connections` (
    `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    `name` varchar(100) NOT NULL,
    `type` varchar(10) NOT NULL DEFAULT 'soap',
    `environment` varchar(10) NOT NULL DEFAULT 'live',
    `url` varchar(255) NOT NULL,
    `username` varchar(100) NOT NULL,
    `password` text DEFAULT NULL,
    `is_active` tinyint(1) NOT NULL DEFAULT 0,
    `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    KEY `type` (`type`),
    KEY `is_active` (`is_active`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

Step 2: Configure SOAP Connection

Navigate to WordPress Admin → GSM Middleware → API Connections

Production SOAP Connection

Click "Add Connection" and enter:

Field	Value
Name	BC Production SOAP
Type	SOAP
Environment	Live
URL	https://bcprodweb.gsmorg.com:8047/web/WS
Username	[email protected]
Password	Your BC password
Set as Active	✓ Checked

Click "Save Connection" then "Test" to verify.

Test SOAP Connection

Create another connection for testing:

Field	Value
Name	BC Sandbox SOAP
Type	SOAP
Environment	Test
URL	https://sbbcweb.gsmorg.com:8047/Dev/WS
Username	[email protected]
Password	Your BC password
Set as Active	☐ Unchecked

Step 3: Configure OData Connection

The OData connection is used for inventory checks during Order Sync.

Production OData Connection

Field	Value
Name	BC Production OData
Type	OData
Environment	Live
URL	https://bcprodweb.gsmorg.com:8048
Username	[email protected]
Password	Your BC password
Set as Active	✓ Checked

Step 4: Test Manually

Go to GSM Middleware → Control Panel

1. Find the "Business Central Export" widget
2. Check "Pending Insert" shows a count > 0
3. Click "Run Insert Now"
4. Verify success message appears
5. Wait 2-5 minutes
6. Click "Run Verify Now"
7. Check sales order numbers were retrieved

Next Steps

• Install Cron Jobs - Automate the process
• Test the Export - Verify everything works
• Monitor Operations - Track export status