WooCommerce Setup
WooCommerce Setup allows the connection of the Business Central ERP system with the WooCommerce online store, automatically synchronizing data about products, categories, stocks, and orders. The goal of the setup is to enable seamless data flow between these two systems, reducing the need for manual input and minimizing the risk of errors.
Before starting the WooCommerce integration setup, you need to have:
- An active Business Central environment
- WordPress with WooCommerce installed
- API keys generated in WooCommerce
- Administrator access to both systems
API Keys in WooCommerce
API keys (Consumer Key and Consumer Secret) allow secure communication between Business Central and WooCommerce, authenticating requests and enabling data synchronization. They are used to access information about products, orders, and stocks, ensuring automatic updates between the two systems.
Generating API Keys in WooCommerce
- In the WordPress admin panel, go to WooCommerce → Settings → Advanced → REST API.
- Click Add Key, enter a name, choose the user for whom you want to generate the key, select Read/Write permissions, and click Generate API Key.
-
Save the generated Consumer Key and Consumer Secret.
1. Connecting Business Central and WooCommerce
- Enter the API credentials (Consumer Key & Customer Secret) that enable secure communication between Business Central and WooCommerce.
- Base URL defines the WooCommerce store where synchronization will occur.
Example URL: https://YourDomain
This configuration enables the connection of the two systems, eliminates the need for manual data entry in both platforms, and reduces the possibility of errors.
2. WordPress Authentication
To create an Application Password, follow these steps:
- Go to WordPress Admin → Users → Your Profile
- Scroll down to the "Application Passwords" section
- Enter a name for the new Application Password
-
Click "Add New Application Password"
Enter your WordPress administrator username and password to access and update data in the WooCommerce Setup.
This step ensures controlled access to data and synchronization without the need for manual input.
3. Managing Woo ID and Additional Options
- Allow Update Woo ID – When enabled, this option allows you to manually update this field on item/attribute/category tabs.
This option ensures consistent data mapping between the two systems, preventing synchronization errors.
4. Automatic Data Synchronization
- Auto Sync Item – Allows automatic product updates between ERP and WooCommerce.
- Auto Sync Item Category – Allows automatic synchronization of product categories between ERP and WooCommerce.
- Auto Sync Item Attribute – Allows automatic synchronization of additional product attributes such as manufacturer, color, dimensions.
- Auto Sync Item Attribute Value – Allows automatic synchronization of attribute values between ERP and WooCommerce.
This ensures that all product and stock data is always up-to-date in the WooCommerce store without the need for manual input.
When this option is enabled, any changes made to Items, Categories, and Attributes will automatically be reflected on the WooCommerce side.
WooCommerce Integration in Business Central
WooCommerce Integration enables the automatic synchronization of items from Business Central with the WooCommerce store, making it easier to manage products, prices, and inventory.
Key Fields:
- WooCommerce ID – Unique item ID in WooCommerce.
- Publish Item to WooCommerce – Triggers item publishing to the WooCommerce site.
- Woo Item Type – Product type (Simple, Variable, Grouped, External).
- Prices Synced on Woo – Automatic price synchronization.
This section is essential for businesses that want to manage their WooCommerce store directly from Business Central.
By enabling this integration:
- Items are automatically published or updated on WooCommerce.
- Product data remains synchronized between the ERP system and the online store.
- Stock quantities, prices, and other attributes are always up to date without the need for manual entry in both systems.