HotWax Commerce integrates with platforms like Shopify and NetSuite to manage orders, inventory, and customer data. Occasionally, synchronization issues may arise, causing data discrepancies and operational inefficiencies. This document outlines common scenarios for these issues, with detailed steps to identify, diagnose, and resolve them.
If orders do not have all valid order attributes, they remain in “created” status and cannot sync with NetSuite.
Log in to HotWax Commerce.
Navigate to the order view page and click ExternalID. This will redirect you to the Shopify admin page.
On the Shopify order page, check the right side in the Tag section. Verify if the order has the necessary Metafield.
Log in to HotWax Commerce.
Go to the order view page
Check if the order has the Metafield in the order attribute section.
Manually add the Metafield to the OMS.
Go to the order view page in OMS.
Locate the order attribute section.
Add the missing Metafield.
Identify the cause of the missing Metafield.
Check Shopify settings to ensure Metafields are correctly applied to orders.
Verify if there are any issues with the order that prevents Metafield.
Additional Resources: Refer to the order Attribute is Missing Troubleshooting document.
Note: Ensure the correct spelling when manually adding the Metafield in the OMS.
To successfully create a sales order in NetSuite, having the customer information pre-existing within NetSuite's database is a prerequisite. If the order contains a new customer who is not present in NetSuite, the system won't allow the order to be pushed.
Log in to HotWax Commerce.
Navigate to the order view page.
Click on the customer name in the "Bill to" section.
You will be redirected to the customer page.
Check the identification section for the NetSuite Customer ID.
Check the customer feed for the order.
Navigate to the SFTP customer feed in NetSuite.
Verify if the order is present in the feed.
If the order is present in the feed, there may be an internal issue with NetSuite.
Contact NetSuite support for assistance.
If the customer's name or email ID contains special characters, it does not sync with NetSuite. Therefore, we need to remove the special characters. Once the name or email is updated, the next order feed will sync with the order in NetSuite.
Log in to HotWax Commerce.
Navigate to the order view page.
In the "Bill to" section, verify the customer's name contains any special characters.
Click on the customer name. Verify if the customer's email includes any special characters.
Notify the client to adjust the customer name.
Provide instructions to the client on how to update the name.
The updated name will be included in the next customer feed.
If an order doesn't have a payment preference, it cannot be synced with NetSuite. We need to check if the payment preference for that order is missing in HotWax but present in Shopify, or if the payment preference is missing in both Shopify and HotWax.
Log in to HotWax Commerce.
Navigate to the order view page
In the “Payment Terms and Preferences” section, verify if preferences are set. Confirm if the payment information is available in Shopify by checking the Order JSON data imported in OMS. you can verify this on the Shopify order MDM
Log in to HotWax Commerce.
Navigate to the order view page and click "ExternalID." This will redirect you to the Shopify admin page.
Append /transactions.json to the order URL.
Check if the Transaction is null.
Check the order in Shopify.
Append /transactions.json to the order URL.
Verify if the transaction data is present or identify any issues.
Check if the payment method is not set in Hotwax.
After the client makes the necessary changes, run the Import Order Update from Shopify job to sync the data.
Alternatively, you can manually add the payment preferences by clicking on the + “Payment Terms and Preferences” section.
If the Payment Details are Not Set in both Hotwax and Shopify.
Inform the client about the issue with the payment preferences.
After the client makes the necessary changes, run the Import Order Update from Shopify job to sync the data.