Retail

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

Running into an issue where a shopify order is stuck in the sync due to the following error:  Contact.DisplayName: 'Contact' cannot be empty. Contact.LastName: 'Last Name' cannot be empty. Inserting 'Contact' record raised at least one error. Please review the errors. Checked the shopify order and there exists contact names for billing and shipping.  What else could be causing this?

Does anyone else struggle with filtering the SYNC HISTORY screen when you have 10’s of thousands of records?  I consistently get an error that the request times out.   Even on specific tabs like failed/processed etc. 

BigCommerce:eCommerce Admin can choose how the customers should checkout in BigCommerce as shown in the below screenshot. If the customer decide to checkout as guest a customer account will not be created in BigCommerce. So in Acumatica the Sales Order will be imported with Generic Guest Customer provided in the Store Settings as shown below. If a customer decide to checkout with account details, then a customer account will be created in BigCommerce. And in Acumatica while importing this Sales Order, Commerce connector will create a new customer if the email address doesn't exist already and then link this customer to the sales order.  Customers are allowed to checkout as guest but BigCommerce will create a customer account as soon as the order is placed and in Acumatica while importing this Sales Order, Commerce connector will create a new customer if the email address doesn't exist already and then link this customer to the sales order.  Customers cannot checkout as guest in BigComm

Hi there,i hope you can help.We’re imorting the objects customer, customer location and order from Shopify. The import of the objects customer and customer location was successfully and i can see the data in the ERP, but i do get this error message for some orders: The record cannot be synchronized because it does not exist in the ERP and external system.I do not understand what’s the issue of those orders. The items and IDs of the products exist in the ERP and other orders with the same products were succesfully imported.I see in the synch overview that the external ID exists and it forwards me to the correct order in shopify.Any ideas how i can proceed in getting those orders imported?

 In the Shopify Stores(BC201010) and BigCommerce Stores(BC201000) form, the user can choose the option to show the discounts in Acumatica Sales Order as a Line Discount or Document Discount when orders are imported from External System. It cannot be both.  When Show Discount In: Document Discount The order Level and item level discount from external system will be shown in the Discount Details tab in the document level in Acumatica Sales Order. This is the order created in BigCommerce.  This is the Sales Order in Acumatica  Also, When the Document Discount is selected the Discount Amount revenue will be recorded against the Discount Accounts as shown below. When Show Discount In: Line Discount The order Level and item level discount from external system will be shown in the line item in  Acumatica Sales Order. When Line Discount is selected, by default, the discount amounts are not recorded against the discount amount  But if Post Line Discount Separately is selected in the Order Type

We have some of our Sales Reps set up as Employees in Acumatica, each with limited access. Currently, they can only see the Sales Orders they personally entered, which makes it difficult for them to track orders for their customers that were entered by Customer Service on their behalf.Ideally, we’d like Sales Reps to be able to view all Sales Orders for their assigned customers--regardless of who entered them--but still keep their access limited so they can’t see other reps’ accounts.For those of you managing Sales Rep access:How are you controlling what Sales Orders your reps can see? Are you using Restriction Groups, Roles/Access Rights, or custom GI filters tied to Salesperson or Customer data? Do you rely on the Owner field, Salesperson ID, or something else entirely?Would appreciate any insight or examples of how you’ve structured this in you environment.

We currently import 2-3k orders per day from Shopify.  They import at a rate of about 360/hour or 10 seconds per order.  This usually keeps up, but with order updates and sales we can fall behind.  What rates are you seeing on your system?  Ideas are welcome, but trying to start with what are realistic expectations and what is possible.   

Goal: To send an email out once a shipment is confirmed to the customer. The email should have a list of packages, each package with its tracking number. I also want to show what item(s) are in each packageI spent quite a bit of time researching this and couldn’t come up with a solution. It seems that a nested <foreach> won’t actually loop through, only the top item in the package is being printed, if there is more than one item in a package is never shows up in the email. I also found a lot of references saying don’t use the view=”” in the foreach, but the email failed anytime I took out the view. The code below gets close, it will list the package #, tracking #, and first item in the package. Unfortunetly, it still shows <foreach view="PackageDetailSplit"> in the email, which tells me the view name isn’t correct, but that is what shows up on element properties <foreach view="Packages">Package # Tracking #((Packages.LineNbr)) - ((Packages.TrackNum

In the commerce connector how can I import shopify orders but have them all use the default guest checkout customer nbr?So instead of the customer getting created on import using their first and last name a specific customer account is used instead for all imported shopify web orders.

When the order in shopify store has discount it sync successfully but after a minute or two it will add additional discount line that causes this error. We dont have any custom mapping we just using the native connector.   Company - Export onlySales Order is Import onlyThis is b2b and ACUMATICA 2024 R1

Hi,I think I saw something in the Australian MYOB version of Acumatica that kind of does this but I can’t for the life of me see anywhere in the NA version Acumatica version to be able to say that an item has a shelf life of 90 days lets say for example. Is there anything in the system to do that so that expiry date on a lot does not need to be set manually? Andrew

Is it possible to export the commodity Code to the shopify store?It is the shopify plus store. What is the correct external object and external field for that information? 

Hello,  I’ve got Acumatica installed on my laptop.  But I would like to have the retail commerce edition to play with.  Is this possible?  Thank you,Josh

hi! anyone in the community use Miva for ecommerce? we have a prospect that loves it and was curious if anyone else has integrated with it or uses it with acumatica? thanks!

I created a GI that pulls a specific set of sales orders that are ‘Ready to Process’ that I want to regularly clean up by marking ‘Set as Processed’ since these records will never get processed automatically again.Is it possible to use an import scenario and this GI to mark these prepared Shopify sales orders in the sync history as processed? 

Hello everyone,Has anyone attempted mapping Cycle Description (or a similar field) instead of an ID in Shopify metafields? How do you approach syncing it? 

Hello,Has anyone created an API link inside Acumatica to take credit card information on a sales order or invoice and pass that credit card back to process through shopify payments? Thanks!NS

I have a question for any Entity mapping expert out there: I’m running into an unusual asymmetry between how the import and export entity mappings are for Sales Orders. We have an Acumatica line-level custom field - AltQuantity for short - which we want to link to the BigCommerce Quantity value of each respective item on a sales order. The Import mapping works as expected, even though the custom field isn’t available from the drop down in the ERP Field column.Import mappingI expected the Export mapping to be able to be set up as the mirror of the Import mapping.expected Export mapping Now, I know I’m getting off the expected path here because I had to type in the Objects and Fields manually without spaces instead of being able to select from a drop down. Surprisingly, it works - well - half works. The system recognizes OrderData.OrderProducts.Quantity just fine and I can map to it normally (ex ‘Sales Order -> Details -> Open Qty’). However, my issue/lack of knowledge is around th

We use non-stock items to create bundle items such as a lamp and shade. We are tracking inventory of these items by running a report to generate quantities and importing those quantities into an attribute. I would like to use this attribute to update the inventory level of the non-stock item in BigCommerce and I have mapped it to do so in the entity settings.However the numbers do not update in BigCommerce and remain as zero. I was wondering if anyone has any insight on why this might be the case or if they have another solution they are using that works. I could just map the attribute into a custom field, but I would rather that these stock and non-stock items are handled in the same way to prevent confusion. Mapping of attribute to inventory level on Entity screen I can see in event logging that Acumatica is sending the request to update the inventory level to the number stored in that attribute, but it remains 0 in BigCommerce.\"inventory_level\":40Stock quantity remains 0 in BigCom

We have had this issue with 23R1 and it is still happening now that we have upgraded to 24R2. We have some products where we introduce new versions of them with new SKUs while keeping the product name the same.To do this, we have to delete the old product from BigC before we are able to sync the new product since BigC does not allow multiple products to have the same name.When we do this, we sometime run into an issue where if we include the deleted product as a related item on that new product, then it causes a syncing error that is unrecoverable. Essentially, Acumatica just keeps trying to sync the product, gets the same error from BigCommerce API that the product doesn’t exist, and keeps trying to sync without updating anything or giving an error message to the user.Has anyone else run into this issue?

Hello, We are running Acumatica 2025 and Shopify Advanced with the  standard Acumatica<>Shopify connector and are experiencing a lot of issues. We have two(2) retail stores, one e-commerce site and an industrial sales division. Our ERP is Acumatica and our online store and POS run on Shopify.We have been unable to get real-time sync of orders. Everything goes through a schedule - orders, item availability, payments, etc. When we do flash sales/promos, we oversell product. We have been unable to to implement BOPIS. The Shopify statuses (Ready for Pick Up and Marked as Picked Up) is not transferred to Acumatica. We have automatizations that close the orders in Shopify automatically. For POS orders, we are ONLY able to do exchanges or returns for original form of payment. Gift Cards or product exchanges are not updated because of a order does not allow modification errors. If a customer buys in store A but returns or exchanges products in Store B, this second transaction is posted t

We are syncing companies to shopify B2B site(2024r2). We are using export only and not bidirectional data for contacts and companies. The first sync is fine and acts as expected. If we change information on the contact or location permissions the data transfers to shopify but the ACM sync log gives the error ‘Company contact has already been assigned a role in that company location.’ I have tried forcing a resync by deleting the sync records, but it throws the same error after deleting.