Retail

No, You can not use Manual Numbering Sequence for importing new Sales Order, Customers, Customer Locations. Commerce Connector would import multiple records per minute so it has to be use Automatic Numbering Sequence for the smooth synchronization process. So please make sure you select Auto Numbering for Customer, Customer Location in the Customer Settings tab and Sales Order type that you selected in Order Settings of Stores page in Commerce Connector for Shopify and BigCommerce is configured to use Auto Numbering. 

If you are using BigCommerce, you have probably been a little frustrated with what tools they give you for importing and exporting. Acumatica gives you a lot of options, but we found holes in what was possible (for now).  To get around these limitations, we found Skyvia.  It is a tool that allows you to connect to your BigCommerce store via API and then do importing and exporting.  I needed to update visibility on several thousand categories.  Acumatica didn’t have that field available, but I was able to export our whole category list and then import the changes pretty quickly.  Just passing this along in case others are searching for a solution.  I can also see us using it if we want to bulk update pages we have.