Commerce Edition QnA
- 232 Topics
- 812 Replies
Updated 11/1/22 The following information answers many of the common questions about Acumatica’s Amazon Connector and our Managed Availability Program.At the bottom we provide a link to sign up for managed availability. This does not commit you to anything. Only let’s us know you’re interested and we’ll grant you access to additional information.General InformationThe Acumatica Amazon Connector works with 22R1 and 22R2 The solution focuses on order management and recording Amazon Fees It supports FBA and MFN (FBM) merchants Feel free to post questions or comments to this article and we’ll do our best to answer quickly and incorporate your questions into the content.What is Managed Availability?This is a program Acumatica utilizes when releasing a new and rather large/important new feature. It’s very similar to a beta program or a pre-release program. Our goal is for our team to work closely with the Acumatica Partner and Merchant on the project. We go through discovery together, determ
Dummy AttributeDescription: The Matrix Inventory feature in 2020R1 and 2020R2 requires the Template Item to have 2 attributes (ie color, size) to create Matrix Items. In some cases eCommerce merchants only require 1 attribute (ie size). This customization package will allow you to create a Dummy Attribute to fill the second, unneeded, Attribute but not display that Dummy Attribute on the eCommerce site.Works with: 20R1, 20R2Packages:Both packages are available on Github as Open Source solutions. To download the .zip from Github, click “Code” > “Download as ZIP”.Dummy Attribute - 2020R1 - Link Dummy Attribute - 2020R2 - LinkMisc: This functionality was added to 21R1 Matrix Item Import Scenario & Convert Stock Items to Matrix ItemsDescription: This package support 2 different features which are related.Feature 1 - The Matrix Inventory feature in 2020R1 and 2020R2 does not supported an “out of the box” Import Scenario. The following package includes everything required to import Pr
Hi All,As of this week Shopify has deprecated private apps that we used by Acumatica Shopify Connector.Here is the link to the announcement - https://community.shopify.com/c/shopify-apis-and-sdks/private-app-depreciation-and-using-custom-apps-instead/td-p/1465831 Acumatica Shopify connector in version 2020r2 and 2021r1 still uses private appsAcumatica Shopify connector in version 2021r2 and 2022r1 support hybrid mode: private, public, and custom apps are supported.Acumatica Shopify connector in version 2022r2+ supports only the public and custom apps. Privates app are deprecated and you have to follow the release notes to fully move from private app to custom or public. What does it mean to us: For users of 2020r2 and 2021r1 versionsExisting customers who uses an existing private will not be affected. Old private app will be still supported. New customers who want to use the Acumatica Shopify connector with NEW credentials (create a new private app), will not be able to do so. Since ne
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
BigCommerce Integration VideosThis short video shares the most basic example of the integration between BigCommerce and Acumatica.Thorough introduction to the Commerce Edition for our VARs – 20 minutesThis is a thorough introduction of the 2020r1 Commerce Edition specifically for our VARs. I show a demonstration managing product data, Products with Variants, customer specific pricing, placing orders and processing shipments. Additionally I go into more detail about the connector, how it works, how data flow is managed and answer a few questions about pricing, etc. Quick demonstration of the Commerce Edition – 10 minutesThis is a brief demonstration of the Commerce Edition showing the product information flowing from the ERP to BigCommerce, the customer viewing and purchasing a product, the checkout process, the sales order creation from BigCommerce and the shipping status information flowing back to BigCommerce. Technical Deep Dive – 18 minutes Technical Deep Dive into the Connection
Hi Team,We are working with 20.221.0021 build and we have a requirement to use a default Ship Via on importing order from BigCommerce to Acumatica instead of using the Shipping Option Mapping grid. Can you please confirm if is it possible through Entities Mapping screen or the best possible way to do it.And if there is a way we can stop populating the Shipping Option Mapping grid. Thank you!
How to prevent Acumatica ERP Sales Orders and Invoices from recalculating the taxes imported from external systems such as BigCommerce, Shopify, Amazon etc.,
In 2023R1, a new checkbox called “Disable Automatic Tax Calculation” is introduced in the Order Types(SO201000) form. When this checkbox is selected, the system will refrain from recalculating the taxes for the Sales Orders and Invoices. The Commerce connector will import the Taxes from external systems such as BigCommerce, Shopify, Amazon etc., if the “Tax Synchronization” checkbox is selected in the Stores form. If the “Tax Synchronization” checkbox is selected in the Stores form and if the selected Order Type in Order Type for Import selector has “Disable Automatic Tax Calculation” unchecked then a warning is shown to the user as “ The Disable Automatic Tax Calculation check box is cleared for the EO order type on the Order Types (SO201000) form. Taxes in sales orders imported from the BigCommerce store will be recalculated on invoice creation.” Once these taxes are imported, then it stays as the same even if the Sales Order or Invoice is modified. This “Disable Automatic Tax Ca
Price list syncs are taking a very long time, over 20 hours. Not to mention it usually errors out and needs to be manually restarted in this time period.I have tested this with a lot of price changes, and minimal price changes, and the time to sync did not change.Is there a better way to automate this process, and to only update the items which prices have changed (either + or - amount)?BigCommerce did recommend using Price List Importer/Exporter | BigCommerce. I have tested this on Sandbox, and this is a very fast way to update multiple price lists for multiple items at once (I did about 6,000 items in < 10 seconds). While this is an adequate solution, I don't see any way to automate this.
We have non-physical items that are sold on our Shopify store (software downloads). These are set up with the “This is a physical product” box unchecked in Shopify: However, this means that customers will not be prompted to enter a shipping address. Because of this, it seems we are getting a sync error: “Taxes cannot be calculated via the external tax provider because the address is missing”.We can go into the Shopify order and manually add the billing address as the shipping address and resync the order which works, but is there a way for us to still sync the order even without a shipping address?
The Order in External System might not have Ship To Address because all the items within the order are non stock items or digital items. Digital items do not require to be delivered physically and hence there is no ship to address. When such orders are imported into Acumatica, you might error related to Taxes or about missing the Ship to Address. Follow the below steps to successfully import the order. Make sure the non-stock item has the right Tax Category. If you are using Automatic tax engine like Avalara for tax calculation, then make sure the non-stock item has the non taxable tax category. Eg: ON030000 The complete list of Avalara tax categories can be found in this link https://taxcode.avatax.avalara.com/ If it is manual tax setup, then make sure the taxes are configured to not calculate taxes for this non-stock item. Make sure the Ship Via used for the order is a not a common carrier. If the Ship Via is not a common carrier(“Will Call” option check in the Sales Order), t
In this article I will show you how to configure Acumatica to automatically accrue Gift Certificate amount. Step 1: We need to create a new GL Account that will hold sold Gift Certificates value. Step 2: We need to create a corresponding Cash Account that will be used for the payment by gift Certificates. Step 3: We need to create a Payment Method that will accept payments by Gift Certificates Step 4: Now we need to create a Non-Stock Item that will represent a Gift Certificate item in the Sales Order. Please note that we should use Customer Gift Certificate GL Account as Sales Account in the Non-Stock Item settings. Step 5: We need to configure BigCommerce or Shopify to handle Gift Certificates payments and associate a Gift Certificate Non-Stock Item: Step 6: Place an order with Gift Certificate at BigCommerce/Shopify. In this example I’ll buy 100$ certificate:And proceed with checkout. Step 7: You will receive a Gift Certificate at your email address. Step 8: Synchronize the Sales Or
Wondering if anybody has used the GiftShip app with Shopify and if so is there a way to map the gift message you can leave through to the sales order on Acumatica to print on documents? Wasn’t sure if the Shopify Connector within Acumatica would recognise any of the new fields.
Understanding eCommerce Merchant's Payment Scenarios and Challenges and how they are solved with Acumatica
I frequently receive inquires about the details of how payments are handled between eCommerce platforms and Acumatica. Below are details about this topic. Common eCommerce Merchant ProfilesWe see 2 primary types of Merchants who are selling via eCommerce and managing their back office via Acumatica.B2C/D2C Merchants Often, individual orders are small. B2C/D2C merchants rarely sell items which cost more than $2k Most Consumer purchases are done with a CC Sometimes merchants allow buyers to place an order, pickup/pay in store B2B Merchants Orders are typically larger Common to see orders which total at $5k - $30k Some buyers want to use CC for payment, or it's a requirement of the seller Many buyers will prefer to pay by check via NET30/NET45 Terms Rule of Thumb - best to not try to guess at how merchants will want to handle payments. Every merchant is different, and it's not an area where they are flexible. Goal is to make the technology as flexible/extendable as possible to acc
Starting from 2022R116 the users can import the Shopify Orders with the entities like Tips using the following scenario:Create in ERP non-stock item withe exactly the same product description as it appears in the Shopify order: Then try import the order with tips. It will look like: This logic should work for any entity which has no SKU and productID on the Shopify side and which the user wants to import to the ERP.In this case the system will search the ERP Items by the product description.
Hi Team,We have some business scenarios where we are syncing the orders from BigCommerce, processing that in Acumatica, and Order gets completed and the order status in Acumatica is marked as ‘Completed’.Now on BigCommerce, the order gets modified and we have to resync the order to get those updates reflected in Acumatica, but during this scenario the connector is not picking up this particular order as this is already marked as completed withing Acumatica.Can you please suggest the best possible way to achieve this, to re-sync the orders even though those marked completed in Acumatica, through manual or Real Time or through a scheduler sync. The particular build where we are trying to achieve this is 21.119.0030. Thank you in Advance!
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 email@example.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
How to split the Customer Account name in Acumatica and sync to the Shopify First and last name field.
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
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.