Orders from our Big Commerce Sandbox will not sync down to our 2021 R1 Acumatica sandbox Nor can we get orders in our Acumatica 2021 R1 Sandbox to sync up to our Big Commerce Sandbox. We are on Build 2 of 2021 R1. Is anyone else having these sync issues? Does upgrading to the current Build 9 fix these issues? We are stuck and our 90-day upgrade sandbox period is about to expire. Any suggestions are greatly appreciated.
Best answer by smarenichView original
Could you please provide a bit more details or screenshots on the issue. What do you mean under “Orders from our Big Commerce Sandbox will not sync down to our 2021 R1 Acumatica sandbox”?
BTW, have you summited the case number?
Thank you for your reply. I will explain and attach images:
First: No orders in Acumatica 2021 R1 will sync to Big Commerce. I do a Prepare and Process. No errors. No notices. Nothing. And no sales invoices in Acumatica sync to Big Commerce.
Second: No orders in Big Commerce will sync to Acumatica. Today I created three orders in Big Commerce and conducted a sync. As you will see from the images, with respect to these three orders, there are no errors and no notices. Nothing. And the three orders did no sync from Big Commerce to Acumatica.
Please see the three attached images regarding these three orders placed in Big Commerce today July 7.
My VAR has told me the case has been escalated to Acumatica. And that Acumatica believes a bug is causing the order non-sync issue. Can you see the escalated case in your system? I only have a few days left on my 90-day 2021 R1 sandbox. And I cannot test the Big Commerce connector.
1) Order Export issue - There are some orders cannot be exported with error ‘The field 'products.0.product_id' is invalid’.
The problem here is that the Stock Item in this order is not synchronized to BigCommerce. For instance SO0001478 has item 1001, which is not synchronized.
2) Some other order cannot be imported because Stock Items are marked as inactive in Acumatica.
For instance order 517 cannot be imported as item 6659M is not synced.
3) Some orders cannot be imported as they were removed on bigCommerce. Most probably it is due to change of a store from production to sandbox.
From my observations, the main problem with this sandbox account is that the existing version of Acumatica was connected to the different store and not all mandatory synchronizations and configurations are done.
I will ask Support Team to review with details, but I think the main problem there is misconfiguration.
Thank you for looking into this. We greatly appreciate your help. Please do ask the Support Team to review and help get this fixed.
I have an open case with my partner. My partner has been working on the issue for nearly 3 months and cannot solve it. I was hoping to get some insight by posting here.
My email is firstname.lastname@example.org