Hello,
We are currently working on syncing products from NetSuite to Magento 2 using the NetSuite Connector.
We have set up the product mappings as shown in the screenshot (including websites, visibility, etc.) and the connection test is successful.
We are facing two issues:
1. Products are not flowing automatically into the connector
Even though our mappings seem complete, no products are being auto-synced into the connector. We had to manually run “Retrieve” to load a few test products.
We would like to understand:
- What needs to be done to enable automatic product syncing from NetSuite into the connector?
- Is there a flag, saved search, or specific item status required to include products in the sync queue?
📝 Additional context:
We created a custom list named customlist_ns_connector_list with the following options:
- Add/Update Item (1)
- Remove Item (2)
- Ignore Item (3)
- Post Children as Stand-Alone (4)
We also created a custom item field (custitem_ns_connector) that references this list. For our test products, we set the value to "Add/Update Item".
We are not sure if this field impacts:
- Whether the product is fetched automatically into the connector
- Or whether it controls the ability to push products to Magento 2
Would appreciate clarification on how this field is used by the connector.
2. Website Mapping Error when posting to Magento2
When we try to post a product manually, we get the following error related to website mapping:
"Mapping errors: Website has been mapped but isn't in a valid format. The format expected is a tuple like (Website ID, true/false).”
In our current mapping, we are using this default value for websites:
(1, true)
This follows the required tuple format, but the error still appears.
Could you please clarify:
- What is the correct way to map the Magento2
websites field? - Should we map multiple values? Or is there something missing in the format?
Any guidance would be greatly appreciated, especially around best practices to manage product sync initiation (manual vs auto) and resolving the website mapping issue.
Thank you!