Retail

I’m currently testing exporting Customers from Acumatica to Shopify (as Companies for B2B) and had a couple of questions:Is there a way to have the Company ID in Shopify match the Customer ID from Acumatica? Ideally, I’d like to keep them aligned for easier tracking and reconciliation. I enabled “Import Company Contacts as Customers” along with bidirectional sync. This successfully creates customers in Acumatica when they’re assigned to company locations in Shopify.However, I’m running into an issue with phone numbers:Shopify always includes the country code (e.g., +1) Acumatica’s phone input mask doesn’t accept this format This results in an error during import: “Object reference not set to an instance of an object”Has anyone dealt with this before?

Hello!I’m trying to prevent Invoices from exporting as Shipments to fulfill non-stock items sold on Shopify. My client sells hundreds of non-stock items a day which we need to import into Acumatica for accounting purposes only. After these orders are imported into Acumatica, the SO is completed, and an invoice is created. The Connector tried to sync this Invoice to Shopify to complete the order, but we do not need it to do this. I have not been able to successfully setup a filter to prevent this from happening. This is also creating a huge clutter of failed sync records and “processed” shipment/Invoices in the clients sync history screen. Any ideas on how I can stop this from happening? Thanks! 

With the retirement of Authorize.net, we want to swap out Authorize.net as the payment processor in our BigCommerce platform and in its place use Acumatica Payments. Is there a guide somewhere for this? We already are using Acumatica Payments in Acumatica.  We now want to add it as the processor in BigCommerce. Patrick

When setting up integration between Acumatica and Amazon using native connector, it is required to create Encryption Certificate on the SM200530 screen. This certificate is used to encrypt customer data fetched from Amazon. I could not find clear instructions on how to do it, especially if you’re a MacOS or Linux user.1 Generate a private keyThis creates a 2048-bit RSA private key. Keep this file secure -- it's the foundation of your certificate.Open Terminal app on your Mac or Linux machine, navigate to a folder where you would like to save the certificate file. And run the following command:openssl genrsa -out key.pem 2048The output file key.pem is your private key. Never share this. 2 Create a certificate signing request (CSR)This command generates a CSR based on your private key. OpenSSL will prompt you for several fields that identify your certificate. You can press Enter to skip any optional field.openssl req -new -sha256 -key key.pem -out csr.csrYou will be asked to fill in the

We are trying to have multiple guest accounts. Our client wants each guest customer to have an individual account. According to 'Help,' we need to change the limit to 1 because the default is per 10,000 orders.What will be the problem if we do that? Also, while checking the Web.config file, we couldn’t find the MaxOrderPerGuestAccount parameter. How can we change it?Thank you for answering this question.

We have an item that we would like to change the Lot/Serial Class from NOTTRACKED to WHEN USED. I made sure there are no open documents but I am still not able to. According to this older post, it doesnt appear possible. We are on 25R2. I just wanted to make sure there isnt a trick I’m missing. I was really hoping I dont need to create a new item. we are currently just putting the serial in notes on the doc line. 

the issue I am seeing now but wasn't there before is. When you link a SO to create a PO. The create PO is taking the date listed under the ship to date vs the requested on date stated on the SO. Any one know how to fix that? here are screen shots: SO: Create PO: should state Jan 28th but it doesnt. 

Yes you can export tracking number from Acumatica to BigCommerce/Shopify. To do so you nee to put tracking numbers in the line with box under Packages Tab.Keep in mind following rules: When shipments that include multiple boxes with separate tracking numbers are exported from Acumatica ERP to BigCommerce or Shopify, the system checks if the following conditions are met: • Each item in the shipment is linked with a particular box. If an item is not assigned to any box, the system displays an error. • Each box in the shipment contains at least one item. If a box is not assigned at least one item, the system displays an error. During the synchronization of shipments with Shopify or BigCommerce, for each box in the shipment, a separate shipment with a separate tracking number is created in the online store. Boxes that don't have any items assigned or are missing a tracking number are not exported to the online store.

Is there a way to map Tracking URL field on the PACKAGES tab of a Shipment to Shopify Tracking URL field?I see this field in the mapping: However, in the ERP Object / ERP Field / Value, I don’t see anything representing this field: 

Hello Friends,I have a few questions for those who are Amazon Sellers and use Acumatica, of course. I would like to know if someone has experienced what I am going through currently and if you wouldn’t mind sharing with me how you handle it?A few notes about us so you have a better understanding, we get hundreds of orders everyday, we do not have Amazon payments connected to Acumatica so we manually process payments for every order in bulk. I also believe the person who was before me did things incorrectly and she trained me and so I feel like I am making our books not have accurate information because of that.First question, I was wondering if you could tell me how you make sure that all the orders that Amazon says you have are in Acumatica? Currently I download an All Orders report for the time frame I want, and then I have a report in Acumatica that pulls all the sales order for the same time frame (I might do a few days overlap in case of delayed transactions). I then do a Vlookup

Starting January 1, 2026, Shopify will prevent the creation of legacy custom apps. Instead the dev dashboard will have to be used.The credentials and authentication process appears to be different for new apps developed using the Shopify dev dashboard.Do we foresee any breaking changes for the Shopify connector after January 2026 if new legacy custom apps cannot be created?Are there any documents relating to setting up the Shopify connector with newer apps developed through the Shopify dev dashboard? Specifically interested in whether the new “clientId” and “secret” associated with newer Shopify apps relate directly to the “API Access Token” and “API Secret Key” that were used in legacy custom apps? ie should those newer credentials just work in place of the older credentials? They don’t appear to.

Starting January 1, 2026, Shopify has updated the way custom apps are created and managed, moving away from the legacy “custom app” model to a more secure and standardized approach through the Shopify Dev Dashboard. This change aligns with Shopify’s broader focus on improving app security, access control, and developer experience. We need to support custom app for partners that test on local instances and can not connect to our public app.With the new flow, custom apps are now created directly within the Shopify Admin using the Dev Dashboard, providing better visibility into app permissions, API credentials, and lifecycle management. This document outlines the updated process, highlights key differences from the previous approach, and guides you step-by-step through creating and configuring a custom app using the new system.****The custom apps that have already been created will continue to function as intended.  Prerequisites:Admin Access to working Shopify store. Notepad to be able t

Hello,After updating to 2025R2, Shopify orders that contain customer info are aborted with this error message. Orders without a customer get processed without issue. I have uninstalled and reinstalled the Acumatica App in Shopify a couple of times and still getting this error. We have two Shopify stores, one on Shopify Grow and another on Advanced. Both have the same issues. Complete Error Message: At least one GraphQL error has occurred. Error: Access denied for companyContactProfiles field. Required access: `read_customers` access scope or `read_companies` access scope. Also: The API client must be installed on a Shopify Plus store.

Hi,due to the changes in the US regarding duties (800$ de-minimis), we have to collect duties from our customers in Shopify. This works very well, but if i’m correct, there is no solution/field in Accumatica to collect duties in sales orders.So now i’m struggeling how to import those values which i do have in my sales order in shopify to my sales orders in accumatica. Does anybody else have the same issue and already a solution for it?

I am currently working on setting up the Shopify integration with Acumatica (2025 R1 Commerce / Shopify Connector).I am facing an issue with the Shopify configuration steps mentioned in the documentation. The documentation refers to steps that no longer match the current Shopify UI (e.g., private apps vs custom apps).Specifically:I am unable to find the exact Shopify settings referenced in the documentation The steps for creating API credentials seem outdated There is no clear step-by-step guide for Shopify Dev (Custom App) setup aligned with Acumatica 2025 R1Could someone please provide:Updated step-by-step instructions for Shopify (Custom App / Admin API setup) Required API scopes for Acumatica integration Any updated documentation or internal guide for 2025 R1 Commerce (Shopify connector)Any screenshots or clarification would be greatly appreciated.

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 are considering changing from Shopify POS to Clover.Is anyone using Clover for POS, and if so is there a preference for which 3rd party connector is used?Thank you

We have a situation where a B2B shopify order gets sync’ed into Acumatica from Shopify.  The order is on terms (IE - Net 30) so no payment records comes with the shopify record.   Shopify order is fulfilled inside Acumatica and Invoice is generated for sales order.  Some time later, customer pays the invoice and invoice is closed in Acumatica but the original order in shopify remains open instead of closed.   Is there a way to close that B2B (Terms) order in shopify when payment is completed in Acumatica?

We are using the Shopify Connector, and have the Shopify Warehouses mapped to Acumatica Warehouses. Whether I select a Location for the mapping or leave it blank, it seems to ignore anything <UNASSIGNED> regardless of Allocated or not. This is not ideal because it reports a higher inventory number than is actually available to be sold, resulting in over-selling, upset customers, etc.  Am I missing something?

We have an instance where an inventory item with a $0 cost was sold then returned. Unfortunately, on the return, the cost defaulted to the most recent sale price and the item was brought back in with a cost. This caused negative COGS and increased inventory value when it shouldn’t have. This item has since been re-sold so I can’t just use the “Issue” and “Receive” processes to remove it from inventory and bring it back at the correct cost.Is there any way to correct the cost on this item?Item costing is specific to the item. I tried using the “Adjustments” but it insists on changing the quantity as well as value.

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

Hello everyone,Customer-based discount codes work for the customer, and a discount percentage rate remains in place even if the order volume changes: The problem is manual discounts -> if you change the percentage, it is linked to the amount and not to the discount rate -> if you add or remove items with manual discounts in Sales Orders, the discount rate also changes, even though it should remain the same: The discount rate should be fixed and not flexible and dependent on the amount.The customer works a lot with manual and flexible discounts, but wants to prevent the discount percentage rate from changing when the order is adjusted. We have not found a solution here for how to set spontaneous discounts. Do you have a solution?Example:SO and the product costs are 12,00 per unit. I add an manual Discount of 10%: I change the Unit Price from 12,00 to 20,00. Now the Discount % changes automatically and thats what i dont want (same effect applies when items are added or removed and

Hi all,Does anyone know of a way to create a “timed” promotion for inventory items that we could customize by customer price lists and/or region?Thanks!Joseph

Hello Acumatica Community! We’ve run into a not good experience, issue with the latest Shopify connector for Acumatica (25R1). I’m hoping to get some insights from others who might be experiencing the same or confirm if this is an isolated problem on our end.What we observedBackground: We rely on metafields in Shopify and map another metafield from a Stock Item attribute via the connector.Normal behavior (pre-25R1): If a value existed in Shopify for one metafield, and another metafield was mapped from a Stock Item attribute, the “unmapped” metafield retained its value while the “mapped” metafield was updated as expected. Current issue (25R1): The connector now tries to update each metafield. And if there’s no mapped attribute for a metafield, connector clears it. This results in unintended data loss across the board, not just the mapped fields. Has anyone else experienced metafield data being cleared or reset by the 25R1 Shopify connector?

Exciting News: BigCommerce Integration Coming to Acumatica 2025 R1 and Newer!Acumatica is thrilled to announce that the BigCommerce integration will soon be available for Acumatica versions 2025 R1 and newer launching in early 2026!This new integration allows Acumatica customers to seamlessly connect their BigCommerce storefront with Acumatica’s ERP platform. This means more automation, faster order processing, and real-time inventory and customer data sync between your ecommerce operations and your back-office workflows.What does this mean for you?Effortless order, inventory, and customer data flow between BigCommerce and Acumatica Fewer manual entry errors and time spent on double data input The ability to scale your online business with the latest and greatest from both platforms Remove the need for additional gateway fees and integrationsA note on paymentsAcumatica Payments is still the recommended option for the most streamlined, end-to-end payment experience. However, for custome