Retail

Since the update to 24R1 we’re experiencing an issue with Template Items’ BigCommerce Qty Unavailable setting behaving as “Set as Pre-Order” instead of our BigCommerce Default setting (which is “Do Nothing”). This only affects template items. (Stock items behave as expected.)This results in these items being made available to customers on our website as pre-order despite us having no intention of allowing pre-orders. I’m just checking to see if anyone else is experiencing this issue and if it’s been raised at all yet.I’ve attached some screenshots for visualization.Default BigCommerce Inventory SettingsInventory Settings for Specific Template Item (to show no settings are overriden)How Template Items are actually behaving in BigCommerce when qty reaches 0How Template Items SHOULD behave in BigCommerce based on default settings (and historically worked prior to 24R1) 

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? 

The Custom Field in BigCommerce could be added using the Commerce Connector from the Entities form(BC202000). Imagine you would like to map a attribute or custom field or any field from Acumatica Stock Item form to a custom filed in BigCommerce product page and this custom field in BigCommerce is not yet created. Go to Entities form(BC202000), select Stock Item Entity.  Go to Export Mapping Tab Click plus (+) button In the Source Object, select the required Acumatica object. Eg: Attributes or Advanced  In the Source Field/Value, select the required Field.  In the Target Object, select the object as Product->Custom Fields. In the Target Value/Field, select <<Automapping>> as shown in the screenshot. Now when the stock item is exported next time, connector will automatically create the Custom Field in BigCommerce with the same name as in Acumatica. If the field already existing in BigCommerce then just the value of the field will be exported to existing field.    Limitatio

After an upgrade to 25R1, ShopifyxAcumatica connector is now failing to sync payments with this error that seems to be a permission access for the Shopify app.  

Hello,Does anyone know the setup in the Commerce module to allow for the tracking number to be sent back to BC from Acumatica? I am unsure if this setup is the correct setup, but I know we not currently having tracking IDs sent back to BC.  

Good day everyone,ShopifyxAcumatica connector only allows mapping of Company to only fields Name or Notes. Now, I am encountering issue with syncing using Attribute to the Notes field. It always provide an empty value.I mapped the attribute with Customer entity to a Shopify Customer tag - it worked, has value.I mapped another field in Company entity to a Shopify Company Notes - it worked, has value.But when I mapped the same attribute with Company entity to a Shopify Company Notes - it is empty. Does anyone encounter the same? I am using 23 R2 - Build 23.209.0023 

Hi everyone,I’m reviewing the documentation regarding the Multiple Base Currencies feature. It states that Retail Commerce is not supported when Multiple Base Currencies is enabled.I would like to clarify the practical impact of this restriction.If a company operates in multiple countries with different base currencies and requires the Multiple Base Currencies feature, does this mean Retail Commerce (Shopify, BigCommerce, etc.) cannot be used in that same tenant?In that case, would the recommended approach be separate tenants per country?I’m also trying to understand whether there is still value in enabling Multiple Base Currencies for a company that plans to use Retail Commerce, or whether the two features are fundamentally incompatible within a single tenant.Any insight on best practice architecture for multi-country companies using eCommerce would be greatly appreciated.

Is there a way to get the Acumatica credit terms to the Shopify locations? This seems to be missing from the entities screen. It looks like there is a substitution list slot for Credit Terms, but that seems to be specific for import.

Can somebody tell what is wrong here?We are trying to import prices. I am guessing that Currency rate is missing sth out?   

Please check this link to know about deprecation of Authorize.net in Acumatica ERP.  Authorize.net Support and Deprecation in Commerce moduleAuthorize.net will be supported in Commerce module until there is a fully working solution for Acumatica Payments with BigCommerce and Shopify. This means customers can import the credit card payments from Shopify and BigCommerce into Acumatica as credit card payments without any issues.Customers canImport Authorized transactions from BC/Shopify to Acumatica. Capture in Acumatica/BC/Shopify Void in Acumatica/BC/Shopify Refund in Acumatica/BC/ShopifyWe are in the final stages of approval of Acumatica Payment with BigCommerce and Shopify. As soon as a we have a working solution, then we will announce when Authorize.net will be deprecated in Commerce module. Please let us know in comments if you have any questions.Update on June 30th 2025We have decided to continue supporting Authorize.net in both the ERP and eCommerce systems for our Retail Commerc

We are working on moving our B2B shop to Shopify. My question for anyone using Shopify B2B, how are you handling Terms customers payments? Currently our B2B site is with Woocommerce, and Terms orders just come in unpaid, and we send an invoice. But with Shopify, customers can pay on the B2B site. Since Acumatica doesnt natively sync those payments at this time, are you disabling the ability for Terms customers to pay past orders in Shopify? Or are there customizations that can be built to handle the payments. Conversely, if a Customer pays an open Shopify invoice in Acumatica, can the open Shopify order be marked paid? (I do see some discussions in here regarding this, please let me know if you have had success with this)Thank you

We use the Shopify Connector for Acumatica and have run into a workflow question:If an item has already been synced with Shopify and we later decide to de-list it from Shopify (but keep it active in Acumatica), the usual step is to uncheck the "Export to external system" box.However, when we do this, the item in Shopify remains Active and continues to appear in the online sales channel. The only effect seems to be that no further changes are synced after that point—it does not change the Shopify product status (Active → Draft) or remove it from the online store.At the moment, it seems the only options are: Change the Acumatica item status to Inactive, or Manually change the item’s Ecommerce Visibility in Acumatica. Question:Is there a way to configure the Acumatica → Shopify integration so that when the "Export to external system" box is unchecked, Acumatica automatically sets the item to Draft or removes it from all sales channels in Shopify?Any insights, workarounds, or best practi

Hey folks - do we know if there is a way to create a mapping, without customization to default the Ship Via - or are we forever bound by the Shipping mapping on the Store Settings?i.e. when a new shipment method is created in shopify and we want to import an order the system errors out because the mapping to the ship via is not provided on the Store Settings. How can we default one ship via value?

Hi,Does Acumatica BigCommerce connector supports Channel Manager?Currently, our customer has two channels in BigCommerce Its my understanding that this feature gives BigCommerce administratros to have 2 storefronts with the same store. Does the Connector has the possibility to separate which products will be exported and used in specific frontstore?Or the products should be configurated in a new BigCommerce store to use a new store in Acumatica connector? Thanks!

Will a Shopify refund Void the Payment on the same day? Currently, the sales order is canceled, but the payment is not voided. Will the system automatically void the payment once the order is canceled in Shopify, or are there any specific steps that need to be followed?

Hello Everyone,I worked on a Shopify Connector Customization in 24R1 (Build 24.121.0004) to update sales order line custom field on order sync.The same customization I upgraded to 25R2 (Build 25.200.0248) But in this version it is not working and the sale order line custom field is not updating during order sync.Sharing the sample code below for review, can you please help with resolution.DAC:public sealed class KNSPAMISOLineExt : PXCacheExtension<SOLine>{    public static bool IsActive() { return true; }       #region TestQty    [PXDBDecimal()]    [PXUIField(DisplayName = "TestQty")]    public decimal? TestQty { get; set; }    public abstract class testQty : PX.Data.BQL.BqlDecimal.Field<testQty> { }    #endregion}ASPX:<RowTemplate> <px:PXNumberEdit ID="edTestQty" runat="server" DataField="TestQty" CommitChanges="true" ></px:PXNumberEdit></RowTemplate><Columns> <px:PXGridColumn DataField="TestQty" Width="70" CommitChanges="True" /></Co

Hello Everyone,I am working with Build 2025R2 Version 25.200.0248 Shopify Connector.I have customized Stock Item sync processor and overridden SaveBucketExport() method (copy pasted base code only) but during product sync, getting error as: Missing type map configuration or unsupported mapping.Mapping types:ProductDataGQL -> ProductSetInputPX.Commerce.Shopify.API.GraphQL.ProductDataGQL -> PX.Commerce.Shopify.API.GraphQL.ProductSetInput. Sharing sample code below, can you please review and suggest possible root cause and fix.public class TestStockItemSync : PXGraphExtension<SPStockItemProcessor>{    public static bool IsActive() { return true; }    #region Mapper    private IMapper mapper;    protected IMapper Mapper => mapper ?? (mapper = CreateMapper());    protected virtual bool UseAutoMapper => true;    private IMapper CreateMapper()    {        if (!UseAutoMapper)        {            throw new ApplicationException("The processor " + GetType().FullName + " must ove

Hey folks, I was curious with all the GRAPHQL changes, if the Item ID matching still works the same. I know that if a “SKU” from shopify is found in either inventory id or the alternate id it will associate it, but what about on the OUTBOUND sync of shipment?  I’m getting an error. Example I have sku 123456 in Shopify, it finds that as an alternate id, but the ACU Inventory ID is WIDGET01.   So the order in ACU now has WIDGET01 and when I try to sync the shipment it basically says the WIDGET01 exists in acu and on the order, but it is not in shopify. Any thoughts?

Is there a way to have a certain payment type always post as a prepayment instead of a payment? For context:We create sales orders and send them to customers so they can pay for their items before they are delivered. The payments made through the integrated payment processor all post as "Payments" which creates a negative AR and really throws the AR Aging reports and overall AR out of whack. Especially since it can be a month or more before an animal is delivered and the SO is converted to an invoice, thus balancing out the AR. Manually generated payments can be posted as "Prepayments" and thereby coded to Customer Deposits instead of AR on receipt and don't cause that issue. Ideally, we'd have specific payment types automatically generate as "Prepayments" instead of "Payments" so that they post to our Customer Deposits account until the item is delivered and the transaction completed. Does anyone know if that is possible?

Hi After many chat with Shopify support and after reviewing the data and considering that all variants are unique in Acumatica. it appears that the error "At least one option value is duplicated" likely stems from a subtlety in how the data is transmitted or interpreted by the Shopify connector integrated into your Acumatica ERP version 2025r1. So , I’am looking for more information ( into the Acumatica log )  Review the data sent via the connector: If possible, obtain a snippet or log of the payload sent to Shopify for product W24J0059 so our technical team can analyze exactly which option combinations are received. Our last sync history was this morning 12/16/2025 11:06am on Entity : Template Item and ERP ID W24j0059  Thanks for your Help _jean

Hello  I am trying to sync related products against template items between Acumatica and BigCommerce.  I am able to do this with non template items and it works as expected. For template items I have tried adding a related item to one of the SKU’s in the template item but it does not sync through. Is there a way to associate related products to template items please? Thanks  Matt

Hello,I noticed recently that if the inventory is negative, the connector ‘adjusted’ the inventory in Shopify to 0.   Since both systems normally handle negatives, does anyone know why this would occur?  it's 25R1

Hello  Is it possible to populate the Description (Image alt text) field in BigCommerce when uploading images from Acumatica using the Acumatica connector.  Thanks  Matt

We are a retail business using Acumatica in UK and currently have the Stripe integration switched on and working to accept payments in Acumatica, to do this we can manually type the card details into Acumatica & then the payment detail is sent to Stripe via the OOTB integration to authorise / take payment. We would like to be able to use card terminals within our showrooms so customers can insert their card into the terminal to pay but are struggling to work out what we need to do / what integration is required to allow the payment detail to get to the card terminal, the card terminal sorts the payment and then updates Acumatica when the payment has went through. Is anyone else using Stripe card readers with Acumatica and if so what extra steps / integration are you using to get it working?

In this article I will show you how to configure Acumatica to automatically accrue Gift Certificate amount. Step 1: We need to create a new GL Account that will hold sold Gift Certificates value. Step 2: We need to create a corresponding Cash Account that will be used for the payment by gift Certificates. Step 3: We need to create a Payment Method that will accept payments by Gift Certificates Step 4: Now we need to create a Non-Stock Item that will represent a Gift Certificate item in the Sales Order. Please note that we should use Customer Gift Certificate GL Account as Sales Account in the Non-Stock Item settings. Step 5: We need to configure BigCommerce or Shopify to handle Gift Certificates payments and associate a Gift Certificate Non-Stock Item: Step 6: Place an order with Gift Certificate at BigCommerce/Shopify. In this example I’ll buy 100$ certificate:And proceed with checkout. Step 7: You will receive a Gift Certificate at your email address. Step 8: Synchronize the Sales Or