Commerce Edition QnA
- 249 Topics
- 912 Replies
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
Context: Allowing preorders for BigCommerce products (stock items). We’re currently on 2020 R2 (updating to 2021 R2 in the next 90 days) and on the BC Enterprise storefront. BigCommerce Requirements: To properly allow the native ‘preorder’ functionality to work on BigCommerce, two settings need to be adjusted:‘Availability’ needs to change to ‘This product is coming soon but I want to take pre-orders’ ‘Inventory Tracking’ method needs to change to ‘Do not track inventory for this product’Acumatica Settings: At the individual stock item level, it is possible to adjust the ‘When QTY Unavailable’ setting within ‘Inventory Settings’ to ‘Set as Pre-Order’. Sounds great. Acumatica Behavior: This ‘Set as Pre-Order’ action only adjusts the BigCommerce ‘Availability’ setting to the required ‘This product is coming soon but I want to take pre-orders’. However, without the ‘Inventory Tracking’ setting getting updated in tandem, the action of allowing pre-order isn’t actually achieved. There are o
How-To: Handle product availability when the Warehouse-Location mapping is changed for already exported location
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
Hi All, Acumatica BigCommerce and Shopify connectors (as well as others connectors build on the Commerce frameworks) have ability to collect verbose diagnostic logs. By default, the logging functionality is switched off to keep performance up, but on the development instances it can be enabled. You have 2 ways - logs in files and request profiler. File LoggingLogging is based on the Serilog, so it has to be enabled vin the web.config file with the following appSettings instructions.<appSettings>.............. <add key="serilog:minimum-level" value="Verbose" /> <add key="serilog:using:File" value="Serilog.Sinks.File" /> <add key="serilog:write-to:File.path" value="[ACUMATICA SITE PATH]\Site\App_Data\main-.clef" /> <add key="serilog:write-to:File.rollingInterval" value="Day"/> <add key="serilog:write-to:File.formatter" value="Serilog.Formatting.Compact.CompactJsonFormatter, Serilog.Formatting.Compact" /> <add key="serilog:write-to:File.shared" value
We are investigating building connectors to Commerce marketplaces.I’d like partners/customers/partners to share with me how they’d rank the following marketplaces in order of priority (#1 highest) and comment on any others that I’m missing.Partners - If you can tell me how many prospects/customers are requesting the marketplaces that will be a bonus. Thank you.Marketplaces and AggregatorsAmazon.com Amazon Business Amazon Vendor Central eBay Walmart Google Shopping Target WayFair NewEgg Overstock Home Depot Channel Advisor Feedonomics SellerCloud
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.
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
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 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?
Login to the community
Social LoginLogin with your Acumatica account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.