Retail Edition QnA
Acumatica suggested we create a Big Commerce Sandbox to test configurations, changes, etc. We have created a Big Commerce Sandbox and linked it to an Acumatica Sandbox. Our VAR has set up the Big Commerce Connector, but cannot make the sync work. Nothing will sync. Our VAR has suggested we post here for help. When I test the connection, I get a green check mark indicating the connections are working. But I still cannot get the sync to work. Any suggestions are greatly appreciated.
We are struggling to set up Auto Sync. Since we went live in October 2020, we have been syncing manually due to sync issues. We have the sync issues solved now and want to set up Auto Sync. Can you help us set up Auto Sync?
While testing a customer integration with BigCommerce, we have some items on our BigCommerce site that are actually cross referenced to existing items in Acumatica. If we try to sync an order that uses that cross reference it doesn't recognize the item during the sync. On the following support case we were told this was reviewed with the commerce team and as of now there is no support for Cross References. (Case #169121)
If it does, how does Acumatica throttle its use of the API? Will it use all available resources in the Shopify's “Leaky Bucket” or is this adjustable?
We have built-in functionality, that sets items to ‘invalid’ status if that item have some parameters preventing it’s synchronization (i.e. sales order has wrong status in external or internal system, customer is a guest in store settings, etc.). Ideally, we would want to be able to execute those settings on all entities, even those that already synchronized. Unfortunately, currently this restrictions can only be executed on new items, that have not been synchronized to other system.The current design of the restrictions would cause a problems for an item status resolution if we would allow restricting of items existing in both systems. Since fetch procedure is initiated from internal or external system, for bidirectional entities the same item could go to ‘invalid’ or ‘pending’ status - based on the direction of the fetch procedure. If the item is modified externally, and in external system object has a status preventing sync process, it will go ‘invalid’ and will have an error messag
Gift Certificate/Gift Card: It is a non taxable non stock item which is associated with a unique code every time the customer buys it. This is maintained at the eCommerce site. User FlowCustomer buys the Gift Certificates in eCommerce site for $100.00 and also a Acer Laptop. eCommerce site assigns a unique code to each Gift Certificate. Eg: “16R-K2A-18X-5YL” Gift Certificates/Gift Cards are imported using a Generic Non Stock Item that is provided in the Commerce Connector Store Settings form under the Order Settings tab. Sales Order with the Gift Certificate as a item. Please see the below screenshots. Numbered referencing the above points. Gift Certificate/ Gift Card Payment: Once a Gift Certificate is bought by a customer, then the customer can use it to buy products on the eCommerce site as it is created like a Credit Card. The eCommerce site will validate the Gift Certificate unique code when the order is paid using the Gift Certificate. User FlowCustomer places the order usin
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 After sync, you will be able to see that this field is populated in BigCommerce:Hope it helps!
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, OrdersProductsType type, out string uom, GetInventoryCDByExternIDDelegate baseMethod) { //This method should ide
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.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.