Retail

There is a scenario that I am looking to solve for. Customer puts in CAD shopify order/paid in CAD but I would like that order to get added into Acumatica as a USD order to avoid any currency exchange rounding issues between shopify payout and bank reconcilation.  Any suggestions?

Hello folks,Wanted to see if this was remotely possible.    But i have an import mapping setup that work in the following manner on the SALES ORDER entity in Commerce Connector: As you can see this will look for the “MISC” tag and if it exists it will map the customerID to my “ECOMGUEST” customer.  If FALSE, it maps to the C0000011 customer.  What I would LIKE to occur is that on the FALSE result of the IIF statement that it reverts to actually using the native connectors logic to either use the existing shopify customer or create a new one.  Possible?

We are using the  native Amazon Connector (BC201020), importing seller-fulfilled orders.I originally set up an item as a stock item and added its ASIN as an Alternate ID (Global type) on the Cross-Reference tab. We later decided the item should be a non-stock item instead. I created the non-stock item, removed the cross-reference row from the stock item (and saved), and added the same ASIN as a Global cross-reference on the non-stock item.When the Amazon Connector imports an order containing that ASIN, it errors out saying the cross-reference exists on two items — both the original stock item and the new non-stock item.**What I've checked:**- Reopened the stock item (IN202500) — the cross-reference row is not visible on the Cross-Reference tab.- The non-stock item (IN202000) shows exactly one row for the ASIN, Alternate Type = Global.- Only one UOM row exists per item; no duplicates within either item.**Questions:**1. Is there a place other than the item's Cross-Reference tab (e.g., a

We have a client who is live on BigCommerce and wants to import their existing stock item catalog into Acumatica first to get Stock items set up and the External ID links established, then switch the sync direction to Export with Acumatica as the master going forward. Has anyone done this before? What's the recommended way to manage this? can we map item class using a custom field from BC to Acumatica to match it to the correct item class using import mapping? And once you flip to Export, does the connector pick up the existing External ID links and update the BC products cleanly without creating duplicates? 

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 any way to have a discount calculate from a group level but apply the discount as a line discount instead of a document discount?The example is: we give a qty discount on a specific brand (which is an item class), 2+ = 10% discount / 4+ = 20% discount.I can make it give the proper discount using a  document discount, however, the problem this is more difficult for reports where we track profitability per item sku and also returns etc. As the line amount per unit doesn’t reflect the discount. I don’t think there is a way to do what I want but thought I would check. 

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?