Retail

Is it possible to map a specific tag to a custom field? I can see that you can import tags (in general) to something in Acumatica, but we really just want to set a command where “if a tag contains a ‘#’ then import to a specific custom field”The number we want to bring in is our Amazon sales #Our Amazon sales flow into shopify and then Acumatica. It works great except for lack of order number. Thanks for any help! 

This article will be focused on the specifics synchronization used in the Acumatica Commerce Edition for Shopify and BigCommerce connectors.First, lets define the synchronization process - Synchronization of any entity in Acumatica Commerce edition happens in 2 steps: Preparation and Processing.Preparation is a process when Acumatica gets information that any entity requires a synchronization (ex, new order has been created or product has been updated). When information is received, connector needs to create a record in the Sync History screen, logging that the record has been received and pending sync. Processing is a process when Acumatica loads one single record and synchronizes it from one system to the other. As part of the processing, connector will perform some addition steps: getting record from both systems, fields mapping from source to the destination system, user defined mapping processing, error validations, duplica

Acumatica Commerce Edition Overview Tuesday, May 25, 2021  10:00 AM Pacific Daylight Time  45 minutesRegister Here.Acumatica is a company on a mission! We are a leading innovator in cloud ERP with customers located around the world. Acumatica ERP delivers adaptable cloud and mobile technology with a unique all-inclusive user licensing model, enabling a complete, real time view of your business anytime, anywhere.Hear a company overview followed by a product demo highlighting Acumatica Commerce Edition.Find out why more mid-sized companies are choosing Acumatica as their ERP solution. 

Has anyone seen issues with prices going to $0 and no longer syncing in build 116 of the Big Commerce connector?  After reverting back to 115 we were able to get prices to sync again.Thanks,Kurt Bauer

Acumatica Commerce Edition Overview Tuesday, April 27, 2021  10:00 AM Pacific Daylight Time  45 minutesRegister HereAcumatica is a company on a mission! We are a leading innovator in cloud ERP with customers located around the world. Acumatica ERP delivers adaptable cloud and mobile technology with a unique all-inclusive user licensing model, enabling a complete, real time view of your business anytime, anywhere.Hear a company overview followed by a product demo highlighting Acumatica Commerce Edition.Find out why more mid-sized companies are choosing Acumatica as their ERP solution. 

Hi Team,We have a requirement where we want so sync some BigCommerce order details to Acumatica Sales Order User Defined Fields at the time or order import.Can someone suggest the possible way to achieve this.   Thank you in advance !

How do you get the product barcodes to show on sales order screen? There is an alternativeID column on this screen, but there appears to be no way to influence what alternative ID (if any) goes into this column? 

Acumatica Commerce Edition Overview WebinarMarch 25, 2021 10:00 am - 10:30 am PSTJoin us for a 30-minute webinar where you will hear an overview of Acumatica Commerce Edition. In addition, you will see a short demo and learn how to create online success with a streamlined back-office system powered by robust ERP software. Discover how you can start increasing the success of your eCommerce business today!REGISTER NOW

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

 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.  

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.