Check List to Prepare Big Commerce Sandbox to test Acumatica Upgrade

Is this for upgrading Acumatica versions? If yes, I will be doing this soon and need to get one going as well…. So lets build one! I will be upgrading to Acumatica 2022R2.

• Are you a BigCommerce B2B Edition? Get the latest customization package for B2B to publish in Acumatica
• First things first, Test BigCommerce Store Connection (BC201000)
• Test ALL used entity syncs. For me:
  • Customer Price Class
  • Customer
  • Customer Location (this one causes me the most issues)
  • Sales Category
  • Stock Item (which include Base Sales Price & Product Image)
  • Price list
  • Product Availability
  • Sales Order
  • Payment
  • Shipment
• Exporting Sales Orders? Test this
• Test Schedules to make sure they’re firing.
• New User created in website, and in Acumatica. Make sure they move both directions correctly.
  • If using B2B, create both a b2b company & a standard on sandbox website to test they come in fine.

That’s all I can think of for now, please add to it if you think of anything!

We are struggling with the preliminary step of getting the Big Commerce Sandbox ready to connect to the Acumatica Sandbox.  We have been told you have to essentially rebuild your new Big Commerce Sandbox with your ship vias, your customer classes, your discounts, etc from your active Big Commerce website.

We did not do these things and when we went to sync the Acumatica Sandbox and the Big Commerce Sandbox we get hundreds and hundreds of errors.  It is so time consuming to re-create your Big Commerce website in the Big Commerce Sandbox, we did not do any testing.  

Are other Big Commerce users having this same test issue? 

Sorry, I misunderstood the question. I recently did this as well, i essentially rebuilt the whole BC dataset from Acumatica syncs.

In Acumatica, I disabled any automation scheduled syncs and real-time syncs. Then cleared all Sync Entities (in Entities, 3 dot menu on every entity, Delete - makes you confirm).

In BigCommerce I deleted all B2B Companies, Customers, Customer Groups, Products, Orders & Price Lists.

This did take ages to resync data back into our BigCommerce Sandbox, but it was worth it as our sandbox dataset was nearing 2 years old and we started experiencing errors in production we couldn’t reproduce in Sandbox.