Skip to main content
Solved

2021 R1: Orders will not sync to / from Big Commerce


dougmcbride79
Semi-Pro I
Forum|alt.badge.img

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 smarenich

@dougmcbride79 I think the best way to go forward with this problem is to setup a call with you, partner and us. Could you please ask partner to organize the call and invite me there?

My email is sm@acumatica.com

View original
Did this topic help you find an answer to your question?

9 replies

smarenich
Acumatica Moderator
Forum|alt.badge.img+3
  • Acumatica Commerce Edition Team Lead
  • 227 replies
  • July 7, 2021

Hi Doug,

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”?

  • Is there any error displayed in the UI?
  • Is it failing on the prepare or process?
  • Are you doing real-time or scheduled sync?
  • Do you have a screenshot?

BTW, have you summited the case number?


dougmcbride79
Semi-Pro I
Forum|alt.badge.img
  • Author
  • Semi-Pro I
  • 194 replies
  • July 7, 2021

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.


smarenich
Acumatica Moderator
Forum|alt.badge.img+3
  • Acumatica Commerce Edition Team Lead
  • 227 replies
  • July 7, 2021

@dougmcbride79  please create a case and provide access to your Acumatica instance there. We need to review your settings.


dougmcbride79
Semi-Pro I
Forum|alt.badge.img
  • Author
  • Semi-Pro I
  • 194 replies
  • July 11, 2021

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.  


smarenich
Acumatica Moderator
Forum|alt.badge.img+3
  • Acumatica Commerce Edition Team Lead
  • 227 replies
  • July 12, 2021

@dougmcbride79  I did a brief review,

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.


dougmcbride79
Semi-Pro I
Forum|alt.badge.img
  • Author
  • Semi-Pro I
  • 194 replies
  • July 12, 2021

Thank you for looking into this.  We greatly appreciate your help.  Please do ask the Support Team to review and help get this fixed. 


smarenich
Acumatica Moderator
Forum|alt.badge.img+3
  • Acumatica Commerce Edition Team Lead
  • 227 replies
  • July 12, 2021

@dougmcbride79 I think the right think to escalate this to your partner. For us it will be hard to understand what needs to be deleted and what should be activated without deep knowledge of your business.


dougmcbride79
Semi-Pro I
Forum|alt.badge.img
  • Author
  • Semi-Pro I
  • 194 replies
  • July 12, 2021

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. 


smarenich
Acumatica Moderator
Forum|alt.badge.img+3
  • Acumatica Commerce Edition Team Lead
  • 227 replies
  • Answer
  • July 12, 2021

@dougmcbride79 I think the best way to go forward with this problem is to setup a call with you, partner and us. Could you please ask partner to organize the call and invite me there?

My email is sm@acumatica.com


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings