Retail

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

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

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 transac

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.  

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

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

I got a couple issues with the Shopify Connector, specifically the customer location sync.At random it will create more than one location for the customer in Acumatica.  It will activate one and deactivate the other.  Since upgrading to 2025R2 we have every day one or two orders where it will fail to import due to "property set method not found". What we found is that it means that the location is not active. When you go to it in Acumatica, you cannot activate it either. You need to create an additional location, make that the default, then you can go back to the other location and activate it.  In addition I found today that when I look at audit history for any customer, it will show me a bunch of location changes for different customers, different random locations. I don't know what these mean and why they're showing up on another customer that's not even connected to our Shopify store.  

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.

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%:

Is there a good way to accomplish this special situation?   Send shopify transfer order details to Acumatica as 1 step transfers. Thanks,Nirav S.

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