Retail

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!  

It might be extremely useful to get automated notification when some synchronization process has been aborted after a pre-defined amount of attempts. We have created several default business events that will automatically send the email notifications:Aborted Order. Aborted Refund. Aborted Shipment. Aborted Payment.These events will be available at version 2021R2.All of them are not active by default.To activate them open Business Events form (SM302050) and select one of these events (for ex., Aborted Order) and check the Active checkbox: That’s it! Next time when the synchronization of the entity (Sale Order in our example) will turn status to Aborted the automatic notification will be sent to the Store Admin email address which is set in the respective Stores forms BC201000, BC201010:  The notification could be found in All Emails (CO409070): When you click the respective link on the All Emails form, you may see how the email notification itself looks like: 

Acumatica Commerce Edition Overview July 15, 202110:00 am - 10:30 am PSTRegister now.Join 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 

Shipping seems to me to be an overlooked area of Acumatica, and I’m not sure why others have not come across this issue.In summary: We are getting inaccurate shop for rates prices when switching a package in the shipmentThis is our box setup, I will demonstrate using a USPS flat rate boxBOX017 = Small Flat Rate Box We add the package (box017) in the shipment and attach a weight of 2 lbswhen I shop for rates I get a return price of $7.79. The actual price for a small flat rate USPS box is $7.90In order to get the correct price to show up, I have to close the window and re-open the shipment.  If for whatever reason I want to change the box (ex. the large flat rate Box014) and the weight to 3 pounds, the shop for rates screen is frozen to the previous dimensions when I edit the package. Once again, I need to save the document, close the shipment, and re-open to get the correct pricing. Seems like this glitch makes us prone to inaccurate price quotes.