Retail

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

Not sure what this one is about… I tried clearing sync data for this Entity and Preparing + Processing again but the same Error occurs. 

This is a unique encounter in our system. On the bigcommerce side (where the orders are created) the customer purchased 14 different products upon syncing on Acumatica only the 13 products are in the SO because of that the total is different. Note: All products in the list are already synced and active.Error Message: The status of the SC014658 order does not allow modifications. Please synchronize records manually. What do you think is the problem?

We have an entity that is not using Acumatica. When we sell product to this entity we sell it at our cost (Unit Price). Currently when we create a new Sales Order for this entity we have to manually update the Unit Price for every line on the sales order. These sales orders usually has a large number of lines, which adds significant time to the process.Also we are using Average Costing so the Unit Cost can change when a new PO is received. This means adding special pricing for this entity in the Sales Price form is not realistic.Is there a way based on the Sales Order Customer to pull the Unit Cost into the Unit Price field?Thank you!

We are having an issue with the online sales orders. In our specific case, our Main warehouse is “01” and our Online warehouse is “10”. In Acumatica, all inventory items have “01” as the Default Warehouse. In the BC Connector we are syncing data only from warehouse “10” (Warehouse Mode: Specific – “10”). .  All incoming BC orders are defaulting to the Default Warehouse and not the Specific Warehouse in the connector.  We must manually change the warehouse from “01” to “10” on all online orders. High demand products are oversold because Acumatica is not “subtracting” inventory from the correct warehouse.We need to somehow “force” all incoming BC orders to pull inventory from warehouse “10”.Anybody knows how could this been done with configuration? 

In our Shopify connector we get this error code on the customer entity that reads “Error on phone: Phone number already been taken.” Or it will read “Error on phone: Enter a valid phone number.” It prevents the customer record from syncing to Shopify, and will also prevent a new sales order for a given customer to sync into Acumatica. It seems like the system is doing some sort of validation on the phone number field on the customer, this is the field on the general tab under the additional account info section.  

Is there any way to sync the current effective Sales Price for a product over to Shopify instead of the Default Price?

We are attempting to sync Template/Matrix items from Acumatica to BigCommerce.   This is the error message we are seeing on the Sync processing“At least two values of the attribute XYZ have the same description. Specify a unique description for each attribute value, and process the record again”I am assuming this is an impact because of the Attribute option description :.But is the connector triggering off of Descriptions at the Attribute level even though the Matrix Combination itself is unique: Any assistance on thoughts here would be extremely helpful.  

Hi there, we have a customization where we have overridden the GetBucketForImport method in BCSalesOrderProcessor.cs graph. After overridden we are facing issue at await keyword.Please refer the below screenshots and code.Overridden code: public delegate Task<EntityStatus> GetBucketForImportDelegate(BCSalesOrderBucket bucket, BCSyncStatus syncstatus, CancellationToken cancellationToken); [PXOverride] public async Task<EntityStatus> GetBucketForImport(BCSalesOrderBucket bucket, BCSyncStatus syncstatus, CancellationToken cancellationToken, GetBucketForImportDelegate baseMethod) { OrderData data = await orderDataProvider.GetByID(syncstatus.ExternID); if (data == null) return EntityStatus.None; await Task.Yield(); data.OrderProducts = new List<OrdersProductData>(); await foreach (var item in orderProductsRestDataProvider.GetAll(syncstatus.ExternID, cancellationToken)) { d

I have two different prices for my sales through Acumatica and Shopify at the moment. To change the price of products in Shopify I manually changed it in the Shopify website. The problem occurs when I sync a stock item in  Acumatica the price automatically changes in the Shopify store. Is there a method I could use to ensure that when I change the price in Acumatica it doesn’t affect my prices in the Shopify store.Thank you in advance for your valuable insights and assistance.

We have a unique use case with RC Refunds imported from Shopify. We have setup a customization to require the sales person fields in Sales Order documents, this policy cannot be changed. It is creating an issue with Shopify Refunds because there is no import mapping available for the Refund entity. We get an error because the default sales person field cannot be empty. Same issue with Sales Orders, but we used import mapping with Shopify Sales Orders to default the salesperson to “WEB” for all imported Shopify orders. The only way for us to update a Shopify sales order as returned/refunded is to Return/Refund in Shopify and import to Acumatica, from what I understand. Therefore we need a customization until import mapping is available for the Refund entity. I figured if we have a unique return order type (copy of the RC type) for Shopify returns then we could add a script to the Sales Order entry screen to automatically update the Default Salesperson field to “WEB” if the order type is

I have a client who has a need for items that are refurbished to be priced differently in Big Commerce and Acumatica.Ideally, the item would be a pencil and if the pencil was sharpened, it would have the same SKU but be priced lower based on a location in a warehouse. Does anyone have an idea on how to achieve this?I’m pretty sure it’s a limitation with Big Commerce but couldn’t hurt to ask with so many smarter than me here! 😁

Hi!Recently, BigCommerce announced their new BOPIS functionality out of the box and I’m wondering if entities to connect to this feature is in the Acumatica roadmap. Does anyone know something about it? Greetings everyone!

If so, what credit card readers are you using at the POS counters?We had ordered Ingenico Lane 3000 devices and they connect fine to eBiz, but after talking to eBiz support, they are not supported for the Acumatica POS (aka Heuristic).  Support told us they only support 1Retail.  Credit Card capture (aka EMV) seems like it should be easily cross-functional, but apparently not.  Can anyone recommend a EMV device that works well with Acumatica POS?

We’ve recently had a lot of Digital Agencies reaching out to us and asking questions about our solution, our eCommerce connectors and requesting more resources to learn the solution. From my perspective, this is terrific! I think Digital Agencies will love what we’ve built, because we’ve considered their ability to learn, deploy and even modify our connector technology to meet the needs of complex customers. I’m a big fan of Digital Agencies and Digital Native Brands who have engineers (or simply “tech people”) on staff who like to roll up their sleeves and learn new tech. I decided I should assemble a list of resources and share here. Few things to know:Anyone can spin up Acumatica locally. We are a SaaS application, however we also offer versions of Acumatica that you can spin up locally or on a webserver (AWS or Digital Ocean, for instance).  We offer a “trial” version of Acumatica This solution can be downloaded publicly and loaded on your local machine or on a webserver. It will

Hello!I wanted to get some help with some code in the commerce connector. My client has a Shopify store with a connection to Amazon. All Amazon orders display a Tag of ‘Amazon’ in the Shopify Order Tags along with a few other tags that are autogenerated. I’m trying to import ‘Amazon’ to one of the Acumatica SO fields anytime ‘Amazon’ appears as a tag and leave the field blank if it does not. Here’s what I have some far, which worked once, but does not seem to work everytime.=IIf(InStr([OrderData.Tags], 'Amazon') >0, 'Amazon', ' ')Thanks in advance!

Hey all, New commerce sync error for us related to “Shopify.API.REST.OrderCancelReason”. Looks like it errors out when staff provides some generic reason for cancellation in Shopify.   Error converting value "staff" to type 'System.Nullable`1[PX.Commerce.Shopify.API.REST.OrderCancelReason]'. Path 'order.cancel_reason', line 1, position 193.. Json data content:{"order":{"id":-,"admin_graphql_api_id":"gid:\/\/shopify\/Order\/-","app_id":-,"browser_ip":"-","buyer_accepts_marketing":false,"cancel_reason":"staff","cancelled_at":"2024-02-01T15:49:32-05:00","cart_token":null,"checkout_id":-,"checkout_token":"-","client_details" ... 

We are setting up a business event to send an email to customers.  Can someone help us understand what the “Link to Account” does?  See below.  Does it record that we sent this email in the CRM Activities? Or something else? How are Link to Account and Link to Entity differ? We are on Acumatica 202 R2.   

Have you cleared your Sync history by mistake or on purpose, but found out you really needed some of it?   Or maybe you imported way too much history and want to start over, but many Customer have already been synced.  If you clear it, Acumatica will create a duplicate Customer later on.  If changes try to sync with an existing Sales Order for example it will give the error that the Customer ID cannot be changed. It is trying to use the new Customer it just synced.  To rebuild the sync history using the correct Customer:Create a Generic Inquiry that grabs the External ID from the Customer Record and the NoteID of the Customer table in Acumatica.  Example XML is attached.   Then create a Data Provider using this GI.  Next create an Import Scenario for the Sync History Screen to create the Sync History.   In this example, Need to Sync is set to false because the information is already in both systems.  You can set it to True if needed, for example if you are trying to create your initial

I’m trying to build an import scenario to be able to re-sync only certain items to Shopify. Rather than doing a full preparation and sync. I’m having trouble with the mapping. Has anyone done this? 

Hey folks,Working on the B2B integration of Acumatica and Shopify. While uploading Sales Prices (Price Lists), getting this error:At least one GraphQL error has occurred. Error: Input size greater than 250.Any ideas how to overcome this? I have a suspicion, that the issue is that I have customers / companies uploaded already, and the quantity of those companies who use this specific price list is larger than 250.I uploaded a dozen other price lists without an issue, but they are used by less than 250 customers each.@KarthikGajendran , @smarenich , @josh.fischer , any thoughts?

Hi All,The Commerce Retail team prepared a technical guide about import of Refunds supported by the Acumatica BigCommerce connector in version 2023r2. This guide covers the most common refunds scenarios for BC orders with cash or credit card payments with Authorize.Net processing center. We believe that this document will help to improve users’ knowledge of the refund import process and what results they can expect.If there are any other frequent scenarios of refunds applicable for BC orders, please let us know. Thanks

Who out there has configured sales tax to run from within Acumatica for nearly every state?Due to our extreme ecommerce order volume, tax integrations are becoming very expensive.However, we only need to calculate 500-750 total transactions per year across 5 tenants and 40 states, the rest are already calculated or exempt. We’re going to the Summit next week and will meet with Vendors other than Avalara and Vertex. I’ve seen TaxJar mentioned. This one seems to be built but not fully approved by Acumatica: Connect Sales Tax Solutions with ERP and eCommerce Platforms | Wolters KluwerI’m looking at getting at maybe getting subscription for rates from Real-time sales & use tax rates | Thomson Reuters ONESOURCE | Thomson Reuters which is where Wolters Kluwer’s integration gets its rates from I believe.  I’d create an import scenario to update the rates if we went this route.

I’m curious how other people have configured Acumatica with Shopify when they have a 3PL directly importing orders from Shopify.  What tips do you have or issues you ran into to watch out for?  Who is routing through Shopify then to the 3PL vs running the process in parallel.  Do have any integrations or processes with the 3PL to update orders in Acumatica other than the Native Shopify Integration?  We have tried both methods, we had to switch after an upgrade cause the cancelling issue, but now that is fixed with the recent patch and 2023R2, we will be going back waiting for Shopify to show fulfilled before creating the shipment in Acumatica.  Hoping for some tips so it runs smoother this time around.  

when I setting up a connection to the BigCommerce store in Acumatica ERP the following error has occurred.Error: Test connection failed: Content: {"status":403,"title":"You don't have a required scope to access the endpoint","type":"https://developer.bigcommerce.com/api-docs/getting-started/api-status-codes","errors":{}}Status: Forbidden.