Retail

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.   

Hello,Does anyone able to manage sales categories in Acumatica and sync it to Shopify as product Collection?Thank you

Has anyone configured the BigCommerce connector to work with an existing BigCommerce store? Our client has a well established store and wants to connect to their new Acumatica install. We started testing the syncs in a sandbox to see how it would work and have run into errors. With the stock item sync, we can only export from Acumatica to BC, but the items already exist in BC. When we try to sync anyways, the error says the item already exists. Is there a way to somehow map the two together to resolve the sync issue? Any other gotchas we need to look for in configuring the connector for an existing store? Thanks for your help!

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

Is there a way we can sync the actual HTML code to the shopify product description?  

We are using the native shopify connecter with bidirectional sync for sales orders - and i found that if i cancel orders is shopify, it cancels the order in acumatica properly.but if i cancel the order in Acumatica, the moves to “Cancelled” in shopify - but the payment does not get “Voided”, it just remains authorized and i have no way to manually cancel it in shopify. i reached out to shopify plus support and they said it needs to be done by the API.Anyone have any insight into this?  

Hi everyone,I'm currently working on an SPS Commerce integration project with Acumatica and was wondering if there is any public documentation that explains the overall integration process and setup.If anyone has implementation guides, knowledge base articles, training materials, or can point me to the appropriate documentation, I would greatly appreciate it.

Hello Everyone,We have one of our client working with 24R2 (24.212.0010) Shopify Connector and observed a discrepancy during Refund sync due to that the behavior is not consistent across RC orders created manually and synced through connector and this is specific for a serialized product associated with Lot/Serial number. Can you please review the scenario and help us with root cause identification and possible fix.Acumatica RC Order Reflection for a Serialized Product:• Created receipt with serial nbr 101. • Created order and selected serial. • Created & confirmed Shipment and released Invoice.• Created RC, selected this Invoice, Line Details pop-up updated with that serial. • Create Receipt, Confirm Shipment, and Released Invoice.Acumatica Connector RC Order Reflection for a Serialized Product is Not same as of Manual RC creation:• Created receipt with serial nbr 102.  • Created order in Shopify and synced to Acumatica. • Created shipment but on confirm Shipment got error for ser

Looking for ways to import from acumatica the template id media url and the matrix item medial url.  The idea is that if one of the matrix items is not available to sell in shopify then Acumatica will mark that variant as not sellable and shopify does not show that specific image of that matrix item in the shopify listing page.   Any suggestions? Thanks!

Hi Everyone,I am working with Acumatica 2024R1 (Build 24.100.0139). I have one BigC order placed like below, initially order synced from BigC to Acumatica.Now, I updated line item qty from 1 to 2 in Acumatica and trying to sync this order from Acumatica to BigC but getting error like: “Error: v2/orders does not support product option modifiers with product_option_type = Configurable_Entry_File;Status: BadRequest”Can you suggested possible root cause and fix.

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

 IssueI am unable to find a field in the ecommerce Sales Order export mapping that indicates that an order has been paid via check on a related invoice. BackgroundWe work with government agencies across the nation, allowing them to pay via Purchase Orders, where we invoice them at Net 30 terms.We have set up a manual payment method on Shopify called 'Purchase Orders.' This method is configured in our e-commerce store settings in Acumatica but is not active. If we activate this manual payment method, orders will be marked as 'Paid' on Shopify, which can mislead some customers into thinking they owe nothing. This also adds a prepayment to the order, causing Acumatica to show all invoices as paid, resulting in no invoices being sent to customers. Consequently, we do not receive payment.To pay these orders, most customers send in a check, which we then apply to invoices in Acumatica. This payment information is not exported to Shopify, so even after the order is paid, it still shows as 'Pa

Is there a an inquiry similar to Inventory Planner that has ‘Open to Buy” calculations in Acumatica? Something similar to this view:  

Shopify store uses a custom app that relies on the exchangeV2 field from Shopify Order API. This field was deprecated in April 2025 and is being phased out following Shopify's standard API versioning cycle. You need to migrate to the Returns API before April 1, 2027. The app(s) impacted are: Acumatica ERP

We are setting up the native connector with Shopify B2B.In Acumatica, we have customers set up with multiple Locations — for example, a company with several office branches, each with its own address.How do we configure the connector so that when a B2B order is placed from a specific company location in Shopify:- The Ship-To address on the Sales Order becomes the address of that location (the office that placed the order)- The Bill-To address remains the address of the parent company

Is there a way to map a value to the Location Billing address in Shopify? I noticed Acumatica Locations don’t have billing info.Alternatively, if I use a Parent/Child customer model in Acumatica (instead of multiple locations) is it possible to map the child customer to a Location in Shopify? 

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: