Mapping WooCommerce products to Acumatica inventory items starts with the WooCommerce Product SKU and the Acumatica Inventory CD. During import, the connector searches Inventory CD using the WooCommerce Product SKU, retrieves the matching item when it exists, and either creates a new item or returns an error when it does not, depending on the Import Item setting.
The Biz-Tech Services WooCommerce Acumatica Connector also provides separate controls for field-level mapping, item attributes, synchronization direction, variants, and generated WooCommerce product IDs. This guide stays focused on product identity and field mapping. Connection setup, the broader configuration checklist, order import, complete data flow, and inventory quantity synchronization are covered in the related WooCommerce articles for those topics.
WooCommerce Product Mapping Prerequisites
The Biz-Tech Services Acumatica WooCommerce Connector becomes available after its customization package is published through Customization Projects (SM204505). The WooCommerce workspace then contains WooCommerce Store Preferences, WooCommerce Store, and the processing screens used for item synchronization.
On WooCommerce Store, the Item Settings tab controls whether an unmatched WooCommerce product can create an Acumatica item and which defaults apply. The Item Mappings tab controls which field values can be created or updated. The Inventory Mappings tab maps Acumatica Stock Item fields or Attribute values to WooCommerce product fields. Item Details is the workspace for loading items from each system and initiating synchronization.
Before mapping a product, confirm the intended direction. Sync from WooCommerce imports product data into Acumatica. Sync to WooCommerce exports Acumatica item data. This distinction matters because the documentation states that product mapping is supported during import from WooCommerce to Acumatica, while the connector does not support the same mapping function during Acumatica item export.
WooCommerce Product Mapping Step by Step
Use this sequence to set up and verify the product relationship.
1 Open WooCommerce Store and review Item Settings for the selected Store Code.
2 Decide whether Import Item should be selected. When selected, an unmatched WooCommerce product can create a new item in Acumatica according to the configured item settings.
3 Confirm that each WooCommerce product has the SKU that should match the Acumatica Inventory CD.
4 Set Import item type and UOM if the connector may create new Acumatica items.
5 If SKU values may be absent, review Use Numbering Sequence for SKU Generation and confirm that the required numbering sequence exists.
6 On Item Mappings, select the fields that can be created in WooCommerce, updated in WooCommerce, or updated in Acumatica. Keep SKU selected because the documentation identifies it as required for item creation.
7 On Inventory Mappings, use Get WooCommerce Properties, choose the Acumatica Target, and identify the Acumatica Property and WooCommerce Property for each field or attribute mapping.
8 On Item Details, use Load Acumatica items or Load WooCommerce Items to review the records available for synchronization.
9 Use Sync from WooCommerce for the documented WooCommerce-to-Acumatica mapping path, then confirm that the expected Acumatica item was retrieved or created.
10 Verify the generated WooCommerce product ID when an Acumatica item is created in WooCommerce, and confirm that the ID appears in WooCommerce Store and on the Stock Items WooCommerce Inventory tab.
How SKU Matches WooCommerce Products to Inventory CD
The documented product identity rule is direct. During WooCommerce item import, the connector searches for an Acumatica Inventory CD using the WooCommerce Product SKU. If the Inventory CD is found, the connector retrieves that existing item. This is the primary line-level match described in the source.
If no matching Inventory CD is found and Import Item is selected, the connector can create a new Acumatica item using the configured Import item type and UOM. Populate Items in Inventory Details can add the imported item to Inventory Details. Last Page Number for Getting Products records the last WooCommerce product page used for retrieval.
If Import Item is not selected, the connector prohibits item import and creation unless the corresponding item already exists in Acumatica. When the SKU does not resolve to an Inventory CD, the documented error is The item {0} does not exist in the system. The placeholder represents the item value used by the process.
When exporting an Acumatica inventory item to WooCommerce, the documentation states that the Inventory CD becomes the WooCommerce item SKU. This export rule is not the same as the configurable import mapping on Inventory Mappings.
Item Mappings and Synchronization Direction
The Item Mappings tab controls which item field values participate in item synchronization. Its first column contains field names. Create in Woo checkboxes allow selected field values to be exported and created in WooCommerce. The adjacent update control allows values already created in WooCommerce to be updated. Update in Acu allows selected field values to be updated during import from WooCommerce to Acumatica.
The Biz-Tech Services WooCommerce Acumatica Integration uses SKU as a required field for item creation, so the documentation says SKU is selected by default. Other fields should be enabled only in the direction the business expects. A field selected for creation in WooCommerce does not automatically mean it should overwrite Acumatica during import.
The source says that the same logic applies to variants without import logic, but it does not explain that phrase or provide a separate list of variant field rules. Treat the documented synchronization direction checkboxes as the available guidance and validate variant behavior with a controlled record before processing a larger item set.
Inventory Mappings for Fields Attributes and Metadata
Inventory Mappings provides field-level mapping for WooCommerce-to-Acumatica item synchronization. Get WooCommerce Properties loads WooCommerce product main fields, meta fields, or attributes into WooCommerce Property. Acumatica Target identifies whether the destination is a Stock Item field or an Attribute.
DAC Name identifies the Data Access Class. Acumatica Property contains the corresponding Acumatica field or Attribute name. Woo Product Level identifies whether the WooCommerce value is a Main Field, Attribute, or Metadata. WooCommerce Property identifies the source field loaded or updated by Get WooCommerce Properties.
Update in Acumatica permits the selected value to update Acumatica during item synchronization. Update in WooCommerce permits the selected value to update WooCommerce. These controls map properties and attributes; they do not replace the SKU-to-Inventory-CD identity rule described under Item Settings.
The source explicitly says this configurable mapping function is not supported during Acumatica item export. For export, Inventory CD is assigned as the WooCommerce SKU. That limitation should be included in any mapping design before users expect two-way identity translation.
Cross References Product Categories and Item Classes
The Cross-Reference tab does not document product aliases. It maps selected entities between WooCommerce and Acumatica, with examples that include payments, countries, and shipping methods. Get Shipping Methods loads WooCommerce values for mapping to Acumatica Ship Via. Only entities enabled under Cross-Reference Options appear in the Field list.
The documentation does not identify Inventory ID, Inventory CD, product SKU, or item alias as a Cross-Reference entity. It also does not describe alternate IDs, customer part numbers, manufacturer part numbers, or an alias priority. Do not use the shipping and payment cross-reference process as evidence that product aliases are supported.
Product Categories is also separate from Acumatica item classes. WooCommerce categories can be retrieved with Get WooCommerce categories, created or selected in Acumatica, and synchronized with Sync WooCommerce Categories. A preferred category selected on the Stock Item WooCommerce Categories tab is exported with the item.
The source does not document item-class mapping, item-class defaults, or class-based eligibility rules. Import item type is documented, but no Acumatica item class field is named in the product import setup. If an implementation requires item classes, that behavior needs separate confirmation rather than an assumption based on WooCommerce categories.
Variants Template Items and Matrix Items
Item Details can show product variants when variants are selected. The documentation also provides a separate Template Items process for sending Template Items and Matrix Items to WooCommerce.
A user opens Template Items and runs Sync Template Items to WooCommerce. After a successful export, WooCommerce generates a product ID that appears on the WooCommerce Product tab. The user then runs Sync Matrix Items to WooCommerce. The Matrix Items are created as Variations under the related Template Item product.
This process documents the parent product ID and its variations, but it does not provide a separate alias table for variant SKUs. The source also does not define how duplicate variant SKUs, missing parent relationships, or attribute conflicts are resolved. Validate the template and matrix relationship before using batch processing.
Unmapped Products and Validation Rules
The source documents an error path for a WooCommerce SKU that does not match an Acumatica Inventory CD when item creation is not allowed. It also says an error appears when an item has no SKU and the required numbering sequence is absent. The second error message is not provided.
The documentation does not define an unmapped-product queue, an Unmapped status, an alias review screen, a retry counter, or a product-specific error inquiry. Get Order Process Error Messages is explicitly described as containing errors from order retrieval, so it should not be presented as a documented item-mapping exception screen.
Other documented checks are contextual. Quantity synchronization requires the item to exist as a WooCommerce item in Acumatica, to be loaded and saved in Inventory Details, and to use selected warehouses on Warehouse Details. The Is WooCommerce Item checkbox is selected when an item came from WooCommerce and was generated by the connector. These checks help confirm item status but do not describe a general alias resolution process.
Where to Check Your Work
The Biz-Tech Services WooCommerce Acumatica Integrator provides several places to confirm product identity and field behavior after a mapping change.
1 On Item Settings, verify Import Item, Import item type, UOM, Populate Items in Inventory Details, and Use Numbering Sequence for SKU Generation.
2 Confirm that the WooCommerce Product SKU matches the intended Acumatica Inventory CD.
3 On Item Mappings, review Create in Woo, the WooCommerce update selection, and Update in Acu for each enabled field.
4 On Inventory Mappings, review Acumatica Target, DAC Name, Acumatica Property, Update in Acumatica, Update in WooCommerce, Woo Product Level, and WooCommerce Property.
5 On Item Details, use Load Acumatica items and Load WooCommerce Items to compare the records available in each system.
6 After Sync from WooCommerce, confirm that the connector retrieved the matching Inventory CD or created the intended item according to Import Item.
7 After Sync to WooCommerce, confirm the WooCommerce product ID in WooCommerce Store and on the Stock Items WooCommerce Inventory tab.
8 For Template Items, confirm the WooCommerce product ID before synchronizing Matrix Items and verify that the Matrix Items appear as Variations.
9 When no item is created, check for the missing-item error or confirm that the SKU numbering sequence exists if the product has no SKU.
WooCommerce Product Mapping Frequently Asked Questions
What field connects a WooCommerce product to an Acumatica item?
The documented import rule uses WooCommerce Product SKU to search Acumatica Inventory CD. A match retrieves the existing item.
What happens when the SKU does not match an Inventory CD?
If Import Item is selected, the connector can create a new item using the configured item settings. If Import Item is not selected, item creation is prohibited and the process displays The item {0} does not exist in the system.
Can the connector generate a SKU when WooCommerce has none?
Use Numbering Sequence for SKU Generation can generate a number when the SKU is missing, provided that the corresponding numbering sequence has been created. The source says an error appears when the sequence is absent but does not give the message text.
Does the Cross Reference tab map product aliases?
No product-alias behavior is documented there. The examples are payments, countries, and shipping methods, including WooCommerce values mapped to Acumatica Ship Via.
Can I map WooCommerce fields to Acumatica attributes?
Yes. The Biz-Tech Services Acumatica WooCommerce Integration uses Inventory Mappings to map WooCommerce main fields, attributes, or metadata to an Acumatica Stock Item field or Attribute, with update direction controlled by the selected checkboxes.
Does the connector map products during Acumatica item export?
The source says the configurable mapping function is not supported during Acumatica item export. The export process assigns Inventory CD as the WooCommerce item SKU.
Where is the WooCommerce product ID stored after export?
The generated ID appears in WooCommerce Store and on the Stock Items WooCommerce Inventory tab. A Template Item product ID appears on the WooCommerce Product tab.
Where can I review products that failed to map?
The documentation does not identify an unmapped-product queue or a product-specific error inquiry. Review Item Settings, the SKU and Inventory CD, the Item Details result, and the documented error shown when an item does not exist.
Work With Biz Tech Services WooCommerce Mapping
A reliable mapping design separates product identity from field synchronization. Product SKU matches Inventory CD during import, Item Mappings controls selected field directions, and Inventory Mappings connects WooCommerce properties to Acumatica fields or attributes. The documented gaps for aliases, item classes, and unmapped-product queues should be resolved through testing or separate approved requirements.
For help configuring and validating the Biz-Tech Services Acumatica WooCommerce Integrator, visit https://biz-techservices.com to learn more about Biz-Tech Services and schedule a personalized consultation.
