Retail

To assure compatibility with the enhance security provided by TLS 1.2 (which is now mandated by Microsoft and other system vendors), all FusionPOS registers must be updated prior to January 1, 2023.Failure to upgrade may result in the register processing transactions as desired. Please reach out to support@fusionrms.com to schedule your upgrade.Regrettably, with the FusionPOS register upgrade, Authorize.net will no longer be supported for integrated credit card processing. For FusionPOS users who are now using Authorize.net we are happy to offer other alternatives for integrated credit card processing. https://fusionrms.com/credit-card-processing.

Hi everyone.We encountered this issue. In the Bigcommerce, If a Customer uses a Credit Card during the checkout process, we have to Override their "Default Payment" method on the sales order.  It needs to be overwritten with "AUTH NET." I just conducted a test transaction. The Customer in question has a default payment method of "ACH." But, during the checkout process I used a Credit Card. When the order synced to Acumatica, the Sales Order pulled the default payment method of "ACH." This issue gets even worse when a Customer has a Default Payment Method of "CREDITCARD" in our system. In that scenario a Customer could pay with a credit card during Checkout and then Acumatica will run their card again when the order is invoiced. Double charging the Customer.

Is it possible to allocate product to ship from a specific warehouse location based on the customer’s location? For example: ItemA is available in both California Warehouse and New York Warehouse Customer is located in Colorado and orders ItemA Acumatica automatically allocates inventory to ship from California Warehouse

We have a requirement from the client that during the customer sync from Acumatica to Shopify, Connector has to split the first and last name of the customers from the Account name with reference to the first space starting from left. For e,g. Let's say if a customer name is “Mike Thomas Gorden”  Connector while syncing the name to Shopify first and last name field, the connector should check for the first space from the left and split the name into two parts as first and last name and send it to Shopify.Based on the above example Connector should sync the first name: Mike and the last name: Thomas Gorden to Shopify. To fulfill the customer requirement we have defined the following mappings at the connector Customer entity levelValidation has been successfully passed but while syncing the customer from Acumatica to Shopify we have found the below issue.While syncing the customers to Shopify, the connector has thrown an error “of an undefined FIND()” function. hence we could not achieve

Is it possible to automatically add a non-stock item when a specific sales order type is selected/created? For example, we would like to be able to have a non-stock item automatically added to orders from a specific channel to make sure promotional materials specific to that channel are included in the shipment.

A client with an existing Shopify store connected to their legacy ERP uses variants but they do not wish to utilized Matrix items in Acumatica.  Instead the just want to have each variant as a individual SKU in Shopify.  The Shopify help says to delete the variants and the default.  They want to continue to sell the SKU’s in their store. For example SKU 1234 has ‘’, A , and B as variants and they want to have them as1234, 1234A, and 1234B as individual SKUs

Hi,We are using the BigCommerce connector with acumatica 2021 R2, but have noticed that payments do not sync from BigCommerce if the order type in BigCommerce is “Manual Order”. These are orders that are taken manually by staff using the backend of BigCommerce. They use exactly the same payment method. In fact, I have compared the GET results of the “payment” endpoint for a normal website order, and a manual order, and the payment REST response looks identical from BigCommerce. So is the acumatica connector programmed to NOT sync these payments? If I try to manually sync the payment (Sync History->Add New->specify the external order ID) then it says “the payment record cannot be syncronized because it does not exist in the external system) Hoping someone has some insight, as I can’t find any information in the documentation as to why these payments can’t be found by acumatica. ThanksGeoff 

We need some help with the following issue:  We have items in Acumatica that we have sold the last one, and made inactive in Acumatica.  We have set up our Acumatica-Big Commerce Connector to make such inactive items not appear on our Big Commerce Website.  The items still show up on our Big Commerce website.  We are confused why the items are still showing up on our Big Commerce site.

Where can I see our Acumatica “usage”.  My understanding is our Acumatica license cost is based on usage.  So, I want to monitor our usage so I can compare  our usage to what our license allows or what we are paying for.  Thank you for any help you may give us. 

We would like to have a sales order type such that when selected to start a new sales order the ship-to address and ship-via for pickup will always be the same address/SHIPVIA and override the customer’s and/or customer class ship-to address/SHIPVIA.  Is this possible?

HelloAbout the different “Tax Type” available in the “Taxes” settings in Acumatica:I would like to know if all types need to be integrated/supported for the retail-ecommerce (ex: VAT, Sales, etc) or if only the type “Sales” can be used? If the tax type “VAT” is selected for a Tax ID, is there any impact on the retail-ecommerce for the related options that can be checked (ex: Reverse VAT, Internal VAT, etc)? Do we need to integrate all of them? Is there any document for retail-ecommerce about the different tax type integration with retail-ecommerce?Thank you, 

Hi All,During the implementation of different commerce connectors, you may face some issue or errors. In case you want to troubleshoot what is happening wrong, you may find Logs of the commerce integration very useful and beneficial.To do so, you should first enable logs in the Request Profiler:When logs are fully enabled, you can perform the sync you want to troubleshoot. Finally, you can go back to the request profiler and find out logs.In case you want to review requests and have many of them, I recommend you to apply filtering by user, screen id (BC3010000), or operation (sync).However, the most beneficial type of logs is - Event Log. This tab will provide you a comprehensive information about what exactly happening under the hood. To filter our only commerce requests, you can apply filtering by the -  Message contains ‘[COMMERCE]’ and Message contains ‘API’.For example, here you can see operations performed as part of the customer synchronization. Especially, I would like to highl

Hi Everyone, We are planning of creating custom field in our Bigcommerce and Acumatica as a Job tag for each sales order line of the Blanket sales order. Is it possible to use it in creating child orders based on that custom field? Thank you.

We have been using the “Fetch” and then “Sync” method in “Commerce / Processes”.  Using this approach we were finding that hundred of items would show as “Pending” even after we Fetched and Synced.  We were told to change our procedure and first “Fetch” in Processes, and then sync using the “Sync Status” process ( and not the “Sync” in the Processes area).  Is this method the prefered way sync?  Should we stop using the “Sync” button in the “Commerce / Processes” area?  

The current Acumatica Shopify Connector doesn’t process the shipping information during Sales Order Import. But in some cases, Shopify Order will be fulfilled by other 3rd party service, and you want to import the shipping information into Acumatica Order if the order has been fulfilled. This request can be resolved by using customization project:namespace PX.Commerce.Shopify{ public class SPSalesOrderProcessor_Extension : PXGraphExtension<SPSalesOrderProcessor> { public delegate void SaveBucketImportDelegate(SPSalesOrderBucket bucket, IMappedEntity existing, String operation); [PXOverride] public virtual void SaveBucketImport(SPSalesOrderBucket bucket, IMappedEntity existing, String operation, SaveBucketImportDelegate baseMethod) { //Local is the API Object from Acumatica SalesOrder localOrder = bucket.Order.Local; //Extern is the API Object from Shopify OrderData externOrder = bucket.Order.Extern; //You can check FulfillmentStatus and Fulfillments object to ensure

I have been asked to enable updates from Acumatica to BC when Sales Prices are updated using Sales Price Worksheets. We have several customer price classes in Acumatica (RET, WHL, 1STWHL, GUEST and Base). Any changes to prices for items made that day are updated every evening with a price class worksheet for each of these Price Classes.We want these updates to propagate to the sales price  in BC automatically.In BC we have Price Lists for:WHLRETGUEST (inactive currently)and Customer Groups for : 1STWHL, WHL, RET, GUEST Is this something that is built into the BigCommerce Connector?  I am a bit confused.  I opened the Entities screen and see a Price List option.Do I simply make this active and then do a manual sync? I also see in the Push Notifications that there is BC-PUSH-Prices.  If I open BC-PUSH-Prices and check the conditions it seems to be linked to AR-SalesPrice which is what I believe the Sales Price Worksheets update and in the conditions looking for Entity Type PR but if I ch

Hi Everyone, I need a modifier (dropdown type) in some of the Items in the Bigcommerce that should came from Acumatica. I only know how to create a template item and building variants through attributes. But what I need is a modifier that will not create a new SKU/variant when I select the options.Is this possible?I made an example: the one under the category attribute should be the modifier But it didn’t sync in the BigCommerce 

The sync fails on a useless message.Index (zero based) must be greater than or equal to zero and less than the size of the argument list.

Hi All. Anyone here who can help me get the right price in the Bigcommerce B2B  from Sales Price in acumatica without syncing the customer price class in the entity setting? Thank you.

Hello Customers and Partners, The Acumatica Retail Commerce team is focused on improving COMMERCE CONNECTOR ERROR messages with recommendations for what to do in each case. We are looking for your feedback on what are the most frequent or challenging errors where we may clarify and provide direction on how best to address.  Please complete this poll with sections for each commerce connector Acumatica Retail-Commerce Team - ERROR Poll Poll includes written and screenshot option for each commerce platform below BigCommerce Shopify  Magento Alternatively, if only a few errors, please comment on this thread and I’ll capture. Thank you in advance for your time. Stacie Jurczak, Program Manager, Retail -Commerce, Acumatica

We are on 2021 R2 with the Big Commerce connector.  Can we configure Acumatica to limit which warehouse the customers can shop from when the customer is shopping in our connected Big Commerce website?

Hi,  Is it possible to create a customization that would allow users to have a better calendar experience for scheduling appointments, somewhat like Google Calendar.

I am getting the following error with an order syncing from Big Commerce to Acumatica.  Any ideas on how I can fix this and get the order to sync?  Updating the 'SOOrder' record failed because data in some field is too long. String or binary data would be truncated.The statement has been terminated.

My BigCommerce sandbox demo site got messed up and I created a new one.  I was able to test the connection satisfactorily, however when I try to do a FULL Prepare and Process for items, sales categories, etc. it doesn’t show any items to export to the new BC site.  I am assuming that there is sync data that needs to be cleared out on all the records. Is there a SQL script to reinitialize the data used by the entities so that they will publish to the new BC site?  Or can this be done within Acumatica? Best, David Eichner, CPA

Here’s an easy one!  There are a couple tables I’ve found in the sample database that I cannot find in the Code Repository.  I’m wondering if they are legacy tables that are no longer used.For example, EPEquipmentTimeSheetDetail and EPTimeSheetDetail.  The only place I find them when searching the entire solution is in a file “Settings except Attachmments.esc”    <Exclude  table="EPTimeSheetDetail" />    <Exclude  table="EPEquipmentTimeSheetDetail" /> Are these “dead” files?