Retail Edition QnA
Recently active
Updated 10/27/23 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 Information The Acumatica Amazon Connector works with 23R1 and beyond The solution primarily focuses on back-office efficiencies and accounting Pushing inventory levels to Amazon Pulling in Amazon (FBA and FBM) orders Push shipping notifications/tracking info to Amazon (FBM) Pull in Amazon Payments and Fees Statement reconciliation via Bank Feeds Personal Identifiable Information Protection (PII) More info below It supports FBA and MFN/FBM merchants Merchants use it to sell on Amazon.com and Business.Amazon.com Current merchants are selling in the US, Canada and Mexico New regions can be enabled Requires engagement with the customer
Hi Everyone, We are collecting feedback from our customers about any challenges and pain points they face while using Acumatica via the survey linked below. We would appreciate your feedback. It could be related to the commerce connectors or related to any other area of the ERP (CRM, Shipping, Financials, etc) Examples: Processing Returns and Refunds are hard, Importing the orders through the connector is hard, Taxes issues etc., We’d also like to understand which external apps you’re using to supplement features within Acumatica. This could be due to Acumatica not offering the same functionality or the Acumatica functionality is not user friendly. Please use this survey as an opportunity to share with us what you’d like to see improved. If you are open to it, we will schedule a call with each of you to collect more feedback, better understand your position and (hopefully) work to provide a solution. Survey Form: https://forms.office.com/r/wJJUFqReEm Thank you
Dummy Attribute Description: 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, 20R2 Packages: 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 - Link Misc: This functionality was added to 21R1 Matrix Item Import Scenario & Convert Stock Items to Matrix Items Description: 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 P
Hello Everyone, Acumatica is currently evaluating a native integration with Amazon Vendor Central, and we are seeking insights from customers who are already trading on the platform. If you are currently working with Amazon Vendor Central, we would love to hear from you! Your insights will be help in shaping this integration to better align with your business needs. Please feel free to comment on this post or reach out to me directly via email at karthik.gajendran@acumatica.com. Looking forward to connecting with you soon! Thank you
Hello - we recently implemented the Ecommerce edition to our existing distribution edition to connect with our Shopify store. We do not have any 3rd party integrations for calculating tax in Acumatica as most of our business runs B2B, so we manually set up Tax ID’s and zones and apply them whenever necessary. One area that we do have to charge taxes in via web sales. For most states, we are only dealing with a single flat rate per state. However, there are a few states, like California, where you are charging State + County + Local in some cases. Shopify handles this as 3 distinct API calls, as opposed to a single calculation of tax and a pass to Acumatica. I’ve tried to do some mapping to change all the incoming tax rate names from Shopify to match up with my associated rates in Acumatica, but with this being 3 calls in the example above, it seems like Acumatica wants to add 3 rows with the same Tax ID name, which it obviously can’t do/will error. I know you can build out more robust
Please check this link to know about deprecation of Authorize.net in Acumatica ERP. Authorize.net Support and Deprecation in Commerce module Authorize.net will be supported in Commerce module until there is a fully working solution for Acumatica Payments with BigCommerce and Shopify. This means customers can import the credit card payments from Shopify and BigCommerce into Acumatica as credit card payments without any issues. Customers can Import Authorized transactions from BC/Shopify to Acumatica. Capture in Acumatica/BC/Shopify Void in Acumatica/BC/Shopify Refund in Acumatica/BC/Shopify We are in the final stages of approval of Acumatica Payment with BigCommerce and Shopify. As soon as a we have a working solution, then we will announce when Authorize.net will be deprecated in Commerce module. Please let us know in comments if you have any questions.
Hoping someone else has a solution to an issue we’re having with customer tax exemption records and new locations We recently noticed that when a customer is setup with a Tax Exemption Number and Entity Usage Type those values are saved to their default customer location - However, when new customer locations are created, the values from the default location are not copied over to the new location We are using Avalara for a our tax provider and we have a BigCommerce store connected to both Avalara and Acuamtica - BigCommerce maintains a single Customer Tax Code (analogous to Entity Usage Type) at the customer record and all customer orders, regardless of address or location, are processed using this tax code and exemption. Acuamtica keeps this record at the location level and calculates only off the customer location values Because of the above, when a customer changes any of their shipping information online, the system creates a new location in Acumatica but the system then looses th
We are currently testing the new B2B features of 23R2. In Shopify, using the “Payment Due Later” checkbox and setting Payment Terms doesn’t seem to matter when the order is pulled into Acumatica. The order will sync with Payment attached as a Check & the Financial terms set to Prepayment- see below. Is this the expected behavior? $0.00 paid by customer, Terms set to Net 30: Order in Acumatica with terms shown as Prepayment: Order in Acumatica with full Payment applied:
Does anyone have any experience connecting one Shopify Store to multiple different tenants in one Acumatica instance? Just checking to see if anyone has experience, Acumatica told me it was possible but working with someone who is experiencing some issues. Thanks for any input.
Hello, We’ve noticed when processing offline Shopify orders with cash that the log in Shopify shows the amount of cash paid and then the change given to the customer. When this order syncs into Acumatica, the payment total is the amount of cash the customer gave and doesn’t account for the change, leaving a balance on the payment. Is this a known bug, and is there a fix or workaround for this?
I just learned that shopify for some reason does not support multi select dropdown out of the box. I’m interested in using the commerce connector to map Text, Combo and Multi Select Combo product attributes to Shopify metafields. I was recommended https://apps.shopify.com/metafields-editor-2. The Metafield Guru supposedly supports multi-select metafields. Does anyone recommendations/experience for syncing single and multi select stock item attributes in acumatica with shopify using the commerce connector?
In the commerce connector how can I import shopify orders but have them all use the default guest checkout customer nbr? So instead of the customer getting created on import using their first and last name a specific customer account is used instead for all imported shopify web orders.
In continuation with the below article, the current article explains how the same can be done in 23R1 and the difference between 22R2 and 23R1. Like in 22R2, in 23R1 there are out of box import scenarios for Template Item(Import Template Items), Matrix Item (Import Matrix Items). The Edit Template ID checkbox in the Item Class form which enabled the Template Item ID field in the Stock/Non-stock form is removed. The Is a Kit checkbox is enabled in the Matrix Item which allows the Matrix Item to be created as a Product Kit. Check All the above is done out of the box. Now to make the Template ID field editable in the Matrix item screen, the user has to publish the attached customization(“ImportMatrixItems2023R100.zip”) to this article. This customization package must be used only with 2023R1 and above. There is a customization package for users who do not have commerce module as well. Check the attachment: “ERPImportMatrixItems2023R1002.zip” For 22R2, check If the selected Template ID in
Does anybody know if the Availability Adjustment field works? Is there any additional setup other than changing this field? I’m still testing, but upon initial update it didn’t work. See screenshots. I set it to -5 expected that if I have 40 quantity available, the commerce site will display 35 because of the -5 adjustment I have as the availability adjustment. It’s still showing 40 qty.
We just switched our main web site to Shopify last week and we’re running into some very annoying issues with the Acumatica Shopify connector. Customer account details on the General tab are repeatedly being overwritten when the Bidirectional customer entity is bringing customer data back from Shopify. We’re on 23R1 and while we plan to upgrade soon, we cannot upgrade right this moment. The primary issue we’re seeing is that customer information on the general tab is being overwritten by whatever the default address is in Shopify. This seems to usually be the address of the most recent Sales Order’s address (I don’t know if it is the billing or shipping address). Not only does this change the address but it completely rewrites the account name. I have salespeople telling me their biggest accounts are just “gone” from Acumatica because they use the Display Name to find their orders and customers. These customers are still there but unless the person memorized the account number, they ha
Hi All, I just want to ask regarding how to restrict the visibility of all sales order records and only show my sales order records? Please refer to the screenshot below. Regards, Nadia
I’m just starting to use the Prepmt. Invoices to collect customer prepayments from the Sales Order. It all works perfectly until the moment I prepare the nomal Invoice and try to release it. The invoice status goes to “Open” but I get this error message: "Sequence contains no elements". The prepmt invoices remain unapplied. Is it a bug or am I missing something in the setup.
Hi everyone! I wanted to share some thoughts about the challenges we’ve faced with syncing Template-Matrix items as Product-with-Variants in Shopify. As many of you know, we’ve run into a couple of limitations: Shopify can only support 3 options. There’s a cap of 100 variants per product. The first limitation has already been addressed in a previous discussion here . However, our Template item has 4 options and nearly 4,000 variants, which has been quite a challenge. We’ve tried breaking down the Template items into new ones with 3 options, but we’re still hitting the second limitation with some Template items exceeding 100 variants. The really exciting news is that Shopify has recently announced their new GraphQL product APIs, which now support up to 2,000 variants ! 🎉 This is a game changer for us and anyone facing similar issues. I’m curious to know: when can we expect to see this new capability available in the Acumatica-Shopify connector? Any insights would be greatly appreciated
Hello, Has anyone had issues with the Shopify Connector after Change_ID of a Stock Item in Acumatica? Even if the ERP_Id and the External_Id matches, the POS orders from Shopify generate an error that the item is not found in the ERP.
Has anyone tried using a custom field as an additional filter in the Sales Order entity of the Shopify connector? A post from two years ago mentioned that this functionality would be supported beginning with version 21R2. We are currently on version 24R2.
Although it is recommended to use a new order type for Shopify POS, we have opted to use an existing order type. But we still want a way to identify POS order from web orders by mapping them into specific customer. Is that possible?
Hey everyone! Our web team has had a handful of sales orders fail to upload to Acumatica with the error of : Aggregate Validation: PX.Objects.SO.SOOrderSite+lineCntr I’m not sure how to dive into if this is a customization issue. I have an VA that we can ask but was hoping to see if maybe this was an known issue in the community first :) Thanks!
Can someone help me figure out why this SO is showing multiple lines for the same item? Usually when this happens it’s because ACU is needing to pull from a different location or use multiple lot numbers but as far as I can tell the line details are all the same :)
We’re getting ready to switch our ecommerce site to Shopify and I am in the process of trying to export our open non-web orders to the site so customers can see their order status. We’re on 23R1 for now (planning on upgrading after this migration). We’ve setup a new order type for orders being imported from Shopify (WB). I have also configured an existing order type (SB) that we want to export. The sales order entity is configured for a bi-directional sync direction. After running some tests on a handful of our open SB orders, they’re being exported as expected and at first glance everything is working great. However, after these SB orders get created in Shopify, the connector sees that they have been modified externally and the next time I process one of them a bunch of fields get updated in the ERP that we do not want to change. This list is not exhaustive but here are some changes I am seeing happen after the re-import: Both the Order date and the Cancel By date get changed from the
Our company brings in sales orders via our homemade website. Quiet often we have to change the order quantity on a sales order. When we do that and press save we get an error that says “Applied Amount Cannot Exceed the Unbilled Balance”. We have been able to plug numbers into the payments screen until we are able to save but I don’t think we are doing it the appropriate what. What is the correct steps for changing the quantity ordered for an SO?
31 likes
21 likes
16 likes
14 likes
13 likes
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
