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 InformationThe 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 cust
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 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
Is anyone having success exporting sales orders and/or invoices to Shopify? We can export Acumatica sales orders to Shopify, but the problem is that it creates a new Shopify order for processing. Our goal is to give customers visibility to their Acumatica sales orders and invoices in their Shopify account.
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?
Hello everyone,In the documentation, there is mentioned External ID for Customer Locations, and I assume it will also be populated when we synced a Customer location originally from Acumatica, in a bidrectional sync. But I can’t see such External Id on the Customer Location screen. We want to find a common ID between Shopify and Acumatica for Customer location, and this location is for Customer Organization (B2B) synced as Shopify Company.Do you have idea how to achieve that, if the External ID in location screen is not yet available?We are in 24R1.
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 Templ
SummaryWe recently updated to 2023 R2.After the update I am getting an access rights error whenever I attempt to use the Customers table/object in a Generic Inquiry.I have admin access rights and there was no issue before the update. DetailsThe exact text of the error is: 'This field will not be displayed for the current user because the user has insufficient access rights or the required feature is disabled' If I do use the fields they will end up blank when I view the GI. This warning does show up in GIs that were made before the update, but the data is not missing when viewing those GIs.Self-Service ResourcesKnown Issues - Cannot find related issue Knowledgebase - Cannot find any related entries/articles Release Notes - Don't see anything related Forums - The following is the only similar issue that I can find and it does not have a solution: https://community.acumatica.com/reports-and-generic-inquires-115/backorder-inquiry-in-2023r2-20699 Troubleshooting Access Rights by Roles
Is there way we can flow the Phone number from ACM to Customer/Company in shopify via custom mapping? Thank you in advance
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
Has anyone encountered a Shopify order with the SHOP_CASH payment method yet?We received a handful of orders on one of our Shopify Stores where customers have redeemed Shop Cash (Shopify’s points system) to pay for a portion of their order. In the Shopify documentation it states that you cannot opt out of accepting Shop Cash without disabling the Shop App for the store. The Process Data action for the order fails with the following error, indicating that the new Store Payment Method needs to be mapped in the store settings - which is straightforward enough:“The payment could not be imported because the combination of the SHOP_CASH store payment method and the store order payment method is not mapped to an ERP payment method for the USD currency or the mapping is inactive in the store settings.”The big question is, what type of ERP payment method should this be configured to? Can it just be mapped to the same payment method as the primary SHOPIFY_PAYMENTS method, is it a new Payment
Our customer is using the Amazon IntegrationEach order creates a Payment on AcumaticaAmazon sends a deposit to the customers bank that consists of multiple payments less feesFor this customer this deposit can consist of more than 1000 paymentsWhat are best practices to enter these deposits?Does anyone have automation for this?
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!Thanks
Hi I am settling up a connection to BigCommerce and have template items which are syncing with BigCommerce using the connector. I have attached images to my attributes used in the configuration of my matrix item and would like these to sync with the Variant Options in BigCommerce. Does anyone know if this is possible please? Thanks Matt
Using the Amazon integration. Does anyone have a way to automate the batching of deposits from Amazon Payments?
My company is a seed company and often times we wish to discount a specific lot of seed that may have a lower germination rate, but we don’t want to discount ALL of that seed’s inventory. Is there a way to discount just a specific lot of product? Thanks!
Hello, our clients who utilize Shopify as order aggregator for Facebook, Instagram, etc. report that the following error happens often:The following tax IDs received from the external system are too long and cannot be saved: METROPOLITAN ATLANTA RAPID TRANSIT AUTHORITY Local Sales and Use Tax. Map these tax IDs to tax IDs of up to 60 characters in the SPCTAXCODES substitution list on the Substitution Lists (SM206026) form.Manually fixing these issues is time consuming and our clients fear to expand their marketing on the 3rd party platforms, because many orders will fail importing into Acumatica.Question:If we programmatically change the length of the TaxID field to 100 characters, will the error go away? Or do we also need to change some business logic in the code?Thank you!
Has anyone had success with filtering the BigCommerce Shipment export based on specific line item details from the sales order? The business case is as follows:Customer places an online BigCommerce order for a kit.In Acumatica there is an import scenario that expands the kit onto the sales order and updates a user defined field with the parent kit inventory id. The exploded line items have a non-zero quantity and the price is $0. When the shipment is synchronized back to BC, the sync returns an error because the kit components were not on the original sales order. We would hope to skip over those items and only update the items that were originally on the order. Any thoughts on how to handle this scenario?Thanks in advance!
BigCommerce:eCommerce Admin can choose how the customers should checkout in BigCommerce as shown in the below screenshot. If the customer decide to checkout as guest a customer account will not be created in BigCommerce. So in Acumatica the Sales Order will be imported with Generic Guest Customer provided in the Store Settings as shown below. If a customer decide to checkout with account details, then a customer account will be created in BigCommerce. And in Acumatica while importing this Sales Order, Commerce connector will create a new customer if the email address doesn't exist already and then link this customer to the sales order. Customers are allowed to checkout as guest but BigCommerce will create a customer account as soon as the order is placed and in Acumatica while importing this Sales Order, Commerce connector will create a new customer if the email address doesn't exist already and then link this customer to the sales order. Customers cannot checkout as guest in BigComm
Hello everyone,We are encountering an issue with the Shopify connector for Acumatica24R1 regarding the synchronization of Business Customers (B2B). Both Company and Customer entities are active and both in bi-direction. Here’s the scenario:A business customer categorized as an organization is set up in Acumatica, with several contacts and locations. When this business customer was synced to Shopify, a Company was created using the same name as the business customer in Acumatica. All contacts were synced in Shopify as Customers associated with the newly created Company. The locations were also synced successfully, which looks good. During the next sync (in the aforementioned bi-directional direction), several new records were synced under the Customer entity. Upon reviewing the synced customer records, we discovered that the connector had created new Acumatica Customers, categorized as Individuals—one for each contact of the existing Business Customer (Company). This resulted in the dup
Is there a solution to sending package tracking numbers to customers as a link to USPS or even Google?If I click the link in the email below, it currently will send me to google with the Acumatica field nameThis is the html code I used to create the link...<a href="https://www.google.com/search?q=((Packages.TrackNumber))" style="text-decoration:none;display:inline-block;color:#ffffff;background-color:#034e7d;border-radius:4px;width:auto;border-top:1px solid #034e7d;border-right:1px solid #034e7d;border-bottom:1px solid #034e7d;border-left:1px solid #034e7d;padding-top:5px;padding-bottom:5px;font-family:Arial, Helvetica Neue, Helvetica, sans-serif;text-align:center;mso-border-alt:none;word-break:keep-all;" target="_blank">
