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
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?
Using the native Shopify Connector with Acumatica, we're looking to automate order fulfillment status updates. Specifically, when an order is finalized in Acumatica, we want it to automatically update the fulfillment status in the connected Shopify store. Is this functionality available within the native connector's configuration settings? If so, could you please guide me through the setup process?
We are applying Shipping Discount in Shopify, however, the shipping discount amount sync to Acumatica as an unpaid balance. Does anyone know how to map the shipping discount to a field in Acumatica so that the shipping discount amount will be waived? Thanks...
Hello, Does anyone know the setup in the Commerce module to allow for the tracking number to be sent back to BC from Acumatica? I am unsure if this setup is the correct setup, but I know we not currently having tracking IDs sent back to BC.
In the Shopify Stores(BC201010) and BigCommerce Stores(BC201000) form, the user can choose the option to show the discounts in Acumatica Sales Order as a Line Discount or Document Discount when orders are imported from External System. It cannot be both. When Show Discount In: Document Discount The order Level and item level discount from external system will be shown in the Discount Details tab in the document level in Acumatica Sales Order. This is the order created in BigCommerce. This is the Sales Order in Acumatica Also, When the Document Discount is selected the Discount Amount revenue will be recorded against the Discount Accounts as shown below. When Show Discount In: Line Discount The order Level and item level discount from external system will be shown in the line item in Acumatica Sales Order. When Line Discount is selected, by default, the discount amounts are not recorded against the discount amount But if Post Line Discount Separately is selected in the Order Type then t
Our customer is using the Amazon Integration Each order creates a Payment on Acumatica Amazon sends a deposit to the customers bank that consists of multiple payments less fees For this customer this deposit can consist of more than 1000 payments What are best practices to enter these deposits? Does anyone have automation for this?
43 likes
27 likes
21 likes
15 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.
