Retail

Acumatica does not a have Pre-Order date field on the Stock Item, but  if Pre-Order is part of your business processes you can easily solve it suing an Attributes at the Item.But how to transfer it to the BigCommerce store? Here is the guide how can use use Commerce Entities mapping feature to map an Acumatica Attribute to BigCommerce API field:The Pre-Order Release Date should have following formula:=Year(CDate([StockItem -> Attributes.Product Purchase Date]))+'-'+Month(CDate([StockItem -> Attributes.Product Purchase Date]))+'-'+Day(CDate([StockItem -> Attributes.Product Purchase Date]))+'T00:00:00+00:00’ Also do not forget to define proper status on the e-Commerce Tab

Acumatica Commerce Connector has two steps to identify what Inventory Item should be added to the Sales Order during the import from the Shopping Cart:Search by ProductID from previously synchronized products. Search by InventoryID in Acumatica by SKU.In case proper Inventory Item is found, it will be added to the Sales Order Line. However, in case nothing is found, connector will throw an error.This process can be controlled with the customization://BCSalesOrderProcessor is the main class that performs sales order synchronization.public class BCSalesOrderProcessorExt : PXGraphExtension<BCSalesOrderProcessor>{ public delegate String GetInventoryCDByExternIDDelegate(String productID, String variantID, String sku, OrdersProductsType type, out string uom); [PXOverride] public String GetInventoryCDByExternID(String productID, String variantID, String sku, OrdersProductsT

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.