Retail

When creating a new Customer in Acumatica and pushing the entity over to an eCommerce website there is currently no way to directly define the password from within Acumatica by default. If a one time use password is desired it must be configured manually by an administrative or clerical user within the eCommerce platform ( Shopify / BigCommerce / etc ). The only alternative for the first login is to direct the customer (who’s new account has no password) to go through the password reset process which is cumbersome and takes multiple steps. It would be a far better user experience for the customer to instead be given a one time use “throw-away” password in Acumatica that is known in advance and then force to the user to reset after correctly authenticating for the first time similar to the process that exists within Acumatica. The only requirement here would be for Acumatica to add the password fields from the eCommerce API to the field mapping since the API on the eCommerce side alread

Hi,I’m looking for a shipping carrier integration with Acumatica and was wondering what the best options are of shipstation, shipengine and easypost? Thanks,Mitchell

Hi There,Is it possible to make it so you can edit fields directly on the generic inquiry screen?For example, I created Attributes for amazon prices and asins, and it would be convenient to be able to edit them on one screen / on the fly for all the products instead of having to go into each item or doing a data import. Would like to create something like the sales prices screen where you can edit all the prices in one spot.  Thanks in advance for the help. 

In Acumatica ERP 2021 R1 Update 16, the records that have got the status “Invalid” in Sync History  (BC301000)  form after the first synchronization attempt are not available for the immediate Re-Sync.Fig.#1. The checkboxes on the lef are not clickable for the record with the status “Invalid” on 2021 R1 Update 16.The user will have to:Delete the Invalid record; Remove the issue which has led to mark the record as Invalid; Run again the Prepare process; Then, Process or Re-Sync the record in question.This behavior recognised as cumbersome and ineffective.That is why it has been corrected in version 2021 R1 Update 17, which is scheduled for the release on 3 of December, 2021.Starting from this version the unnamed checkboxes  in the table of the Sync History (BC301000) form for the invalid records become clickable and thus accessible for the Re-Sync.Now, if the user tries to sync the Invalid records the system re-validates to make sure that the record is valid is sync. If all is good then

Clients are having hard time automating the synchronization processes between e-stores and ERP. Such as syncing entities like Orders, Payments, Refunds and so on.So, we decided to prepare and provide the pre-configured Automation Schedules which Customer can activate and use at his/her convenience starting from 2021R2 version.You will be able to find them at the Automation Schedules form (SM205020).They come in two portions:One is for preparing data:Prepare Sales Order; Prepare Shipment; Prepare Refund; Prepare Product Availability; Prepare Stock, Non-Stock, Template Items.With the following default Schedules: Entity Schedule Frequency Sales Order Every 10 min. Shipment Every 30 min. Refund Every 20 minutes. Product Availability Every 1 hour. Stock Item Every 24 hours. Non-Stock Item Every 24 hours. Template Item Every 24 hours.  You can also find them at Prepare Data

The Real-Time Import and Export Features on the Entities screen (BC202000) will be disabled for Customers, Customer Location, Sales Category and Customer Price Classes in version 2022R1 of Acumatica ERP.The reason behind this decision is performance issues of the SAAS system. The use of the Real-Time sync with the large amount of customers accounts requires a lot of system resources, which may affect the Connector performance.But fear not!First, for the customers which already use the Real-Time synchronization, we have prepared the customization project which enables this feature back. You may find the customization package file attached to this article, it will work with 2022R1 version.And secondly, we have more effective feature as an alternative solution. It’s the Default Automation Schedules. They are more stable and more effective feature than the Real-Time Sync.

We have set up automatic credit hold in Acumatica.  Can this credit hold be synced to Big Commerce, so if a customer on credit hold tries to place an order on Big Commerce, the customer is told in Big Commerce the customer is on credit hold and prohibited from placing a Big Commerce order? 

Hello, I am seeing two errors when I sync entities between Acumaitca and BigCommerce, and was wondering if anyone had any ideas. The errors are:Input string was not in a correct format. → Only on stock items. The last operation is Failed to Save Externally, and they are not synced to BC.Could not find a part of the path 'c:\windows\system32\inetsrv\[username]\users\[BC customer ID #]\companies'. → Only on customers. The last operation is Inserted Externally, and they are synced to BC. I can’t see the difference between the records that are synced and those that are not. I appreciate any help I’m able to get!   

HII want to do the following with BC.One can setup various payment methods. Some offline, some online. I only have offline.when a customer have enough credit then I don’t want them to see credit card payment method in BC, only must have method, “on credit”when they don’t have enough credit, I want them to see Credit card payment method and not see “on credit” payment method.Any ideas?

We have customers and prospects with a requirement to assemble products based on a customers request, either through a ecommerce store or through direct input into Acumatica.  Some examples of these scenarios are below: Variety Packs Pick any 6 of our flavors or frangrences to make your own pack.  Using matrix items is not a viable solution given that these customers may have 300+ individual items. Made to Orders based on variables. Manufacturing is overkill and does not interface with ecommerce connector. Needs to be rules driven to avoid misconfigured items. Is this an indoor or outdoor applications? Do you want still images or video? What megapixel level? (doesn ot allow megapixel levels not compatible with video if selected) What country? Which cellular provider? (does not allow a provider which is not available in selected country) Issues: How to faciliate the order in the ecommerce store so that it passed to Acumatica correctly? How to faciliate the order for

Has anyone had an experience with a government agency utilizing the customer portal to place orders? We produce and sell medical equipment to the military and are looking to simplify the ordering process but with the government’s security level we aren’t sure if they will be able to use the customer portal. Any advice? Thanks!

Do we have the ability to offer different Shipping Methods in BigCommerce that will be mapped to existing Ship Vias in Acumatica? Would this configuration through the Entities work well?Where do we map the Shipping Method in BigCommerce to the Ship Via in Acumatica? 

Our implementation is such that all customers will be generated in Acumatica and pushed to BC prior to the customer logging into the BC storefront. Is it possible to push the CustomerID to BC into a customer user field? I looked into the articleHowever, it doesnt seem to allow CustomerID to be a source - nor does it seem to allow custom fields on the BC Customer object.We have some supplemental API inquiries that BC is going to do which require the CustomerID and it would be best if it were already there. Relying on the email address as a unique key when it isnt required to be unique in Acumatica doesnt seem like the right way to go.Any thoughts?

Hello, we think about adding information about card type such as visa, mastercard, AmEx etc for card payments and cards stored in the system and would like to make it as useful as possible.Please share your thoughts on how you could use this information. 

Hello Everyone,I have a requirement mentioned as below:I have to create a new graph. Implement a button on this graph. On this button click have to Get/Update specific Product data with some additional details.I am trying to use core connector Product Data Get/Update resources for my new Graph, similar to SPStockItemProcessor graph but is not working. Please find below details that I have tried as a part of customization:Created graph - Please find attached ‘Test Graph Code’ document for reference. Created aspx page and defined button - Please find attached ‘aspx Code’ document for reference.Getting object reference error and on debug find out productDataProvider object getting null.public PXAction<KNSPPLMetaFieldsFilter> CreateStockItem;        [PXButton()]        [PXUIField(DisplayName = "Get Product Details")]        protected virtual IEnumerable createStockItem(PXAdapter adapter)        {            ProductData data = productDataProvider.GetByID("6618593099970"); // productDa

Hello. Our customer wants to use the “verify & store” method when capturing the credit card orders in BigCommerce, which means they don’t charge the credit card until they are ready to ship the order. This could be a week later, or a month later if they need to order the stock.Does the 2021R1 BigCommerce connector support this scenario, and if yes, how to set it up?How can we “tell” BigCommerce to charge the credit card and take payment when we are ready to pick and pack the order in Acumatica?We have talked to BigCommerce, they say their API does support such delayed payment processing.Thanks!

In our BC implementation, we want to allow customers to shop by brand. Brand ID is a native field in BC. Is it possible to have an attribute in Acumatica that identifies the brand of a product which can then be sent over to BC? Here’s how we tried to have it set up but the sync does not seem to be working.  

Hello Everyone,I have one scenario where I want to put Sales Order on Hold at the time of order import from BigCommerce to Acumatica based on some conditions.I have implemented some logic in 19R2 build and that is working as expected there, as after checking required conditions, I used to set impl.Hold = true.ValueField(); please find below code sample for reference.public delegate void MapBucketImportDelegate(BCSalesOrderBucket bucket, IMappedEntity existing);        [PXOverride]        public void MapBucketImport(BCSalesOrderBucket bucket, IMappedEntity existing, MapBucketImportDelegate baseMethod)        {            baseMethod(bucket, existing);            MappedOrder obj = bucket.Order;            OrderData data = obj.Extern;            SalesOrder impl = obj.Local;                        impl.Hold = true.ValueField(); // This implementation working fine in 19R2        } Now, coming to 21R1 we do not have Hold checkbox on Sales Order screen and instead we have Hold button to put th

Hi All, By default, Acumatica commerce edition require Auto-Numbering for Customers and Customer Locations. This is done due to a number of reasons:During the export customers from Acumatica, we don’t have a Shopify ID, so if customer is created in Acumatica it will have a different name. Acumatica can be connected to multiple stores and there is no guarantee that customer ID is unique accords multiple stores and connectors. Naming convention in Acumatica may be different from Shopify customer.In any case, Acumatica Commerce Edition will follow Auto-Numbering of customer and locations.However this can be changed with the simple customization.  Please do the following: Step 1: Extend the Segmented Key for BIZACCT and CUSTOMER to 13 or 14 characters. Customers ID in Shopify are very long. Step 2: Publish the attached customization . The customization package does 2 things: Disabling mandatory auto-numbering on customer record Assigning Acuamtica CustomerID to the Shopify ID. Step 3: Test

Hello,     Can anyone familiar with Acumatica and Shopify connector help confirm whether the below need is mission impossible at present.    We are using customer price class to set item price for different customers/customer classes. And since we are planning to use shopify to receive customer’s orders. Can these prices be sync up to shopify and displayed to customers?

This action causes a problem where the related products disappear. In the BigCommerce product pages there is a checkbox which displays as "Automatically show related products in storefront".If the box is checked the window collapses and no longer displays the related products that were imported.Before CheckingIn the Store View the related products display below the main item.After CheckingOnce the box is checked, the Related Products window is minimized, and the related items are not visible anymore.Note that the page must be saved for changes to take effect.The Store view displays exactly as it did before.ProblemIn the case that the user wishes to uncheck the box, he/she must go back into the product page and uncheck it. However, this causes the related products to disappear.If the user saves the current state of the product when exiting, the related products disappear in the Store View as well.If the user does not save, the related products continue to display in the Store View as th

Hello Acumatica Commerce Connector users, There are many features released in every version of Commerce Connector. The product is growing bigger each day. That being said we would love to hear from you about features you like and about the areas where we need to invest more time to improve. We would greatly appreciate if you take few minutes to provide us this feedback. The feedback page has two sectionsShort answer questions - Require less than 2 mins to answer.  Long answer questions - Requires around 10 to 15 mins to complete. You could be generous and answer them or request for a meeting with product team who would be happy to schedule a call and discuss more.  Feedback Link: https://forms.office.com/r/XNzEnLm7d6If you have any questions about the feedback or ifthe link is not accessible, please feel free to contact Karthik Gajendran (karthik.gajendran@acumatica.com).

Some stock items do not sync over to BigCommerce, most of them do but for every 50-100 items that do sync over there is 4-5 items that do not. Most of the items, if I change the price, category, description it will re-sync itself and usually the ones that don’t I can force the re-sync and it will work. But occasionally a stock item won’t sync no matter what I change or how many times I resync everything, even if I force the re-sync it won’t pick up the changes on that specific stock item. I have set stock items the synced successfully and stock items that will not sync, side by side and both of them have the same settings. does anybody know what could be causing this issue? Thank You….

Orders from our Big Commerce Sandbox will not sync down to our 2021 R1 Acumatica sandbox  Nor can we get orders in our Acumatica 2021 R1 Sandbox to sync up to our Big Commerce Sandbox.  We are on Build 2 of 2021 R1.  Is anyone else having these sync issues?  Does upgrading to the current Build 9 fix these issues?  We are stuck and our 90-day upgrade sandbox period is about to expire.  Any suggestions are greatly appreciated. 

Hello, Could you please help me with the following issue?When trying to import sales order and credit card payment from Shopify to Acumatica, I get the following error:  “Inserting 'Sales Order Adjust' record raised at least one error. Please review the errors.PrepaymentInvoiceRefNbr: 'PPI Nbr.' cannot be empty.”I follow the instructions from the training: V210 COMMERCE EDITION (SHOPIFY CONNECTOR) 2021 R1Have any of you already solved this problem or have an idea what it could be due to?Thank you in advance for any advice!