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
Can anyone explain to me why this error are starting to show? At first there is no problem with our syncing of company entity to shopify then this year 2025 I’m not really sure exact date this problem start occurring At least one GraphQL error has occurred. Error: Field 'locationCount' doesn't exist on type 'Company';Error: Field 'orderCount' doesn't exist on type 'Company';
Since upgrading to Acumatica 23R2 from 22R2 we are getting occasional sync errors saying:Object reference not set to an instance of an object.when syncing new orders from Bigcommerce to Acumatica. I’ve looked at the trace but I’m not really sure how to troubleshoot this error.The external orders also don’t look any different to ones that are syncing without problems.If anybody has any ideas that would be very helpful.Phil
Can anyone confirm if there is a limit of the number of returns created in a Shopify Plus order that the 2024R2 connector will let sync back to the same Acumatica order. Our testing seems to suggest you only get one?
Hello, We recently changed the Inventory Account on a Stock Item, but the change is not reflected when we run the inventory valuation report (it still shows the old account it had before).Any ideas on why this is happening?Thanks, Ruben.
As of Jan 1, 2025, SHOP will now act as a Marketplace that collects and remits tax on behalf of the vendor - seems similar to how Amazon works. How will this flow through the native Acumatica Shopify Connector to Acumatica and then through the Avalara Connector to AvaTax? How is the transaction identified as a SHOP transaction? Are there parameters that need to be set up so that the vendor does not double pay the tax?
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!
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
HI,I’m wondering how I can use the Acumatica Apis to retrieve the price for an item based on the inventoryID and the CustomerIDI’ve found the /entity/Default/20.200.001/SalesPricesInquiry API - I can use this to get the base price and the customer specific price.From what I understand in the Acumatica ERP there is a hierarchy for the price as follows Customer SpecificCustomer Price Classand then finally Base priceSo it appears that I could figure out the price for an item by making an inquiry for each of those steps and using the first one that returns a price?I feel that this is not a great solution though because this is getting into the details of the business logic of Acumatica. Is there a way to send the information for the Customer and Inventory ID to the API and just get the price?
By default, in Shopify, there is a boolean flag to mark if the item is taxable or not as shown below screenshot.This can be updated using the substitution list called SPCTAXCLASSES as shown below. All of the above is done by default. Nothing to do from user's perspective. For customers who are enrolled in the Shopify Plus plan, they could export the actual Tax Categories from Acumatica to Shopify products as there is a field called Tax Code in Shopify for plus customers. Please follow the below entities mapping to do that. Result: Stock Item in Acumatica. Product in Shopify after entities mapping export:
We are using sales orders to process sales. The sales come by Shopify, API (woo commerce) and manual. Creating sales orders works great!Where we struggle is returns/order changes. Our most common situation removing an item from the sales order that is not in-stock followed by partial credits. Currently:Step 1: We go into the sales order and remove the item that is not in-stock. Then we add a non-stock item to the order for exact same amount. Create the shipment, ship it and invoice the order. The reason we add a non-stock item is the order comes in with a payment. If we don’t close the order for the exact amount the payment remains open with balance. Step 2: Since it was paid order we credit the customers credit card on Woo Commerce or Shopify. Then we go into ACU create a return order using the non-stock item with amount of the item removed and any tax. Then we create a refund payment in ACU, attach the payment to the refund order, lastly invoice.Situation 2: As a customer
I am looking to connect with merchants who sell unique/one of a kind items online through eCommerce. We see this use case mostly in merchants dealing with used products or unique items, such as coins, antiques, or similar products. Typically, we see such merchants needing to individually price the products based on their characteristics as such as condition, quality, potency, etc.,If you fall into this category, please let me know. I’d like to discuss how you are currently processing these items using Acumatica.Are you utilizing any customizations? Additionally, I’d love to learn more about the nature of your business. Looking forward to connecting with you!
Hello,Has anyone experienced syncing historical orders from one e-commerce platform to another? For example, we previously used BigCommerce as our e-commerce platform connected to Acumatica, but we have since switched to Shopify.Now, we want to sync the historical orders from BigCommerce for our customers into Shopify. However, we found that the orders are filtered due to existing External Reference numbers. Clearing this field isn’t a viable solution since most of the orders are already completed. I can process the orders in the Sync History > Filtered tab, but I hope there is a more elegant approach.
Hello, anyone had an issue before when import a REFUND?The tax amount calculated by the external tax provider cannot be applied to the document. An error occurred during processing of the field Applied To Order value 18.41 Incorrect value. The value to be entered must be less than or equal to 18.40.Obviously, the amounts would be different, but the idea is clear I hope: payment (refund) in Shopify is larger than what Acumatica calculates using the Avalara integration.Acumatica used to have this issue with order import, but it was fixed once the Disable Automatic Tax Calculation configuration was added on the Order Types screen. However, the issue with Refunds seems to persists, regardless of the value of that box on the Order Types screen for RC type.
We have a strange situation happening with our Big Commerce Website. We cannot determine if it is set up / configeration issue or a design flaw in the Acumatica-Big Commerce Connector. Any help would be greatly appreciated. We are on 2024 R1.We have set up Acumatica / Big Commerce so that only SKUs that are in stock will show up on our Big Commerce Website. When a SKU drops to zero in stock, the SKU automatically stops showing up on our Big Commerce website as it should. This works perfectly well. The isssue is when a SKU is out of stock, and we make the SKU inactive in Acumatica. As soon as we make the SKU “inactive” in Acumatica, the SKU reappears on the Big Commerce website, and the configuation for that inactive SKU in Big Commerce is changed to show on the website even if zero of the SKU is in stock. The act of making a SKU "inactive" in Acumatica causes changes in Big Commerce so the SKU shows up on the website.Is this a configuration issue we can change / fix? Or is this a
Hello, We have our Shopify store setup to use Available for Shipping. The On Hand amount is 1,423 but it’s in a quality location and cannot be sold. The available for shipping amount is 0. However, in Shopify it’s showing the total amount on hand. Does anyone know what can be done to fix this? Thank you!
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
We handle the 10x10 frame and various colored covers separately in Acumatica. When a customer orders a tent, frame and cover is bundled manually and shipped together. (a) I have included all covers in the template item using color as a variable attribute. How can I add the frame to the matrix item?(b) If I want to use the 10x10 frame in a second template item, can this stock item be utilized across different template items?Thank you!
Template items is working just fine on first attempt. How to create color swatches for items with color variants synced to Shopify? Thank you!
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.
