Retail

I am pretty sure you can’t, but thought I’d see if anyone else had looked into this. 

We do not want items sold out or not available for sale to show up on our Big Commerce Website.  Here is our problem: When the last item in stock of a particular SKU is on an Acumatica sales order (but not invoiced) it still shows on the Big Commerce website as available for sale.  How can we configure our Acumatica connector so when the last item of a SKU is on a sales order the item will not show up as available for sale on the Big Commerce website?  We are on Acumatica 2020 R1. 

When will the customization package be available for the Point of Sale module for 2021 R2?

We have recently had an issue where Base and Sales UOM for certain products do not match. In addition, our prices are set up for the Sales UOM. BigCommerce doesn’t distinguish between different UOM (you can only set a global UOM). As a result, when you sell a product in feet, but it’s Base UOM is inches, a sales order will have lines with inches. In order to force Acumatica to use Sales UOM (instead of Base UOM), we simply un-map UOM on the entities screen like this:When this is done, Acumatica’s default functionality kicks in, which uses Sales UOM on the Sales Orders screen (vs. Base UOM).If you need to add more granularity to how UOMs are selected for e-Commerce order, check out this article: 

Hello community,Is there a way to map Ship Via code from Acumatica to Shipping Method in BigCommerce when doing sales orders / shipment export? I’m specifically talking about uploading net new orders from Acumatica to BigCommerce.The mapping on the BigCommerce Stores > ORDER SETTINGS tab seem to work only one way.Thank you,Yuriy Karpenko

Hi  I have non-stock template item kits set up which are picked and packed at point of order. This works great when I process the order in Acumatica. When the non-stock item is pushed to BigCommerce it is allocated as a Digital item and not a Physical and therefore does not have the associated shipping process and can be ordered without the need to input an address or select shipping options. If I manually change the item in BigCommerce to Physical, the resync from Acumatica overwrites this.  The non-stock items have Require Shipment flagged on them. Is there a way to have non-stock items sync as Physical? Many thanks  Matt

Hi everyone,Has anyone integrated Acumatica with OCI PunchOut to a market-place? Is there any guide or technical documentation about this topic? Let me know !Thanks 

Scenario: There are three locations(Seattle, California, Dallas) created in Shopify and there are three warehouses in Acumatica such as Retail, Wholesale and Dummy. Initially during the ERP implementation phase the warehouse location mapping is done as in the below screenshot.  The Item quantity for RETAIL → Seattle is 11 and Wholesale → California is 199.At some point, after the implementation phase, the user changed the warehouse location mapping as the below.  Now in Shopify the product availability would as the below. Seattle → 11Dallas → 199California → 199Note: The Commerce Connector will not make the existing California location quantity to 0 as it is not sure if it is has to make it to 0 or leave it with the existing value. Because, the user might manage the inventory for this California location manually.So if the user wants to make the quantity of the California to 0, then the user has to map a 0 inventory Acumatica warehouse Dummy to the Shopify California location and proce

Hello Everyone,I have an instance with Build 20.212.0038 and have configured Authorize.Net as processing center and payment method and using to map with BigCommerce Authorize.Net payment method.But as soon as I am selecting Processing Center ID the Release Payments checkbox getting disabled and then the synced payment records are not getting released automatically.Can someone please suggest on how we can configure the settings to Release, synced payments automatically.  

 2021R2 Update 3 and beyond - Connect Acumatica to Shopify via the Marketplace App As of 2021R2 Update 3, when connecting Acumatica and Shopify, you must use the new Shopify Marketplace App located here - https://apps.shopify.com/acumatica-cloud-erp DocumentationOur documentation team is adding updates related to this new process to our documentation. Upgrading CustomersWe are currently adding tools to the Shopify App which will make it easier to migrate customers from the old Private App to the new Marketplace App. This update will happen inside the Shopify App, not within Acumatica. The ProcessUsing the app is relatively easy. Log into your Shopify Store Go to the Marketplace App page - https://apps.shopify.com/acumatica-cloud-erp Click “Add App” Follow the instructionsWe want your feedbackTell us what your experience using this app is like. If you think it’s easier, please let us know. If you run into any challenges or feel that the process could be easier please share your thoughts

I'm working to upgrade from 2019R1 to 2021R2.Credit card processing is quite different in 21R2 than I'm familiar with. I need some direction for how to process Sales Orders with Credit Cards using the REST API in 21R2.I'm currently using the REST API to insert Sales Orders with a credit card payment (authorized only, not captured) using the SalesOrder endpoint. As part of the API call to the SalesOrder endpoint, I only have to provide the PaymentMethod and external PreAuthorizationNbr. This corresponds to a tab in the SO called "Payment Settings". It works great, but no longer exists in 21R2. I understand that I now need to use the Sales Order -> Payments tab, but it's not clear to me how to associate the external pre-authorization with the Payment and Application using the REST API.Can anyone point me to documentation or examples or using the REST API to insert Sales Orders with pre-authorized (or even captured) credit card transactions.Should I use the REST API to build a Payment

We have released the latest AcuPOS powered by IIG for 2021R1 and 2021R1 IIGPOS User Guide.The latest AcuPOS by IIG build is 105 and User Guide works with the latest Acumatica ERP 2021 R1 build 116. This information can be found Community >Product Downloads > Add-ons and Integrations > Acumatica Point of Sale (POS) powered by IIG

Is it possible to add two vendors to a stock item using the import scenario?

Hi, How do I add a barcode to a stock item using the import scenario?

In our system, the item class creates attributes, how can I populate the attributes fields through an import scenario?

Hello Everyone, Is there a dashboard that will show the conversion ratio of quotes to Sales Orders? If not, what is the possible workaround? Thank you! Kind regards,mrivera67

Hello, I heard that Acumatica have plans to implement native features, which allow to connect Acumatica with Amazon marketplace. Do anyone have some more information about this?I heard also that, there are something like “Acumatica Retail Commerce Edition” and on 2021 R2 it will be connected with Amazon marketplace. The main questions for me is that it’s only for Amazon Marketplace (fulfillment by Amazon) or Amazon Sellers Center  (fulfillment by Merchant). Thanks fro all replies

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!