Retail

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. 

When an order comes in with both products and gift cards how are you all handling them in the ERP?We have been marking the gift cards as complete before creating shipment (since Shopify sends the digital GC and our shipping department has nothing to scan or send if we don’t), but we are seeing that in doing this the gift card is not being added to the invoice and therefore is not being paid in the ERP.  Also, Acumatica is then only capturing the invoiced amount sans the gift card payment.How should we be doing this so that the correct money is being collected and the ERP is showing the GC sales? 

Anybody familiar with where these numbers are coming from? This is an error on the shipment export. These number is not the inventory CD, Inventory ID, or lot number of the items on the shipment. Some shipments are processing OK, but some are throwing this error. Any ideas?Thanks! 

I will occasionally get this error in the sync history preventing an order from importing into Acumatica. The inventory ID is not missing from the item on Shopify, and exists in Acumatica. See below for the highlighted error. Has anyone else experienced this and know the root cause of the error?  

We are using 22R1 and I am working through setting up Tax Zones and Taxes for GST and HST in Canada. I’m following the https://openuni.acumatica.com/courses/fin/f335-financials-advanced-value-added-taxes/ and this glances over setting up tax zones so that they are specific for a sate of several states.  The example uses canada as a whole, but never specifies how to select the country to match it to the zone.When I try to set up a Zone for say, Ontario, I expected to see the method described in the help whereby I could could select the state(s) associated with the zone, but all I see is a filter on Zip Code: Am I missing a step somewhere or a checkbox that would allow me to specify the country and/or province? Thanks! Patrick 

Receiving an error when test syncing one of our Customer Prices Lists. The error says “Phone is invalid” but no further details.  My immediate assumption is that a customer/company account in Shopify does not have a phone number or the phone number is invalid. However, it does not tell which record is causing the issue.Any ideas of input on how to narrow down the source of the error?

Hi all! We are currently on 2023R1 and plan to upgrade to 2023R2 very soon.We have a group of products - safety glasses - that have pricing set by the pair of glasses, but we sell them in box quantity of 12. In the individual stock items and the template items when applicable, the conversion is set with EA as the base unit, BOX as the sales and purchase unit. The EA to BOX conversion is defined. When we export these glasses to the website, the price and product availability are showing up as the Base Unit instead of the Sales Unit, which is not what we want. We would like the export to shopify to use the Sales Unit.I’m providing a few screenshots here to illustrate the relevant details:Stock Item Page - Base/Sales/Purchase Units are defined hereLinked Template Item page - Base/Sales/Purchase Units are defined exactly the same way hereStock Item Price (price differs by lens color so price is defined here, for base UOM)Vendor purchase unit is set to BOXVendor purchase unit is set to BOXW

I am wondering if there is any update regarding the B2B features mentioned in this press release:https://www.acumatica.com/corporate-newsroom/press-releases/acumatica-broadens-strategic-relationship-with-shopify-to-enhance-experiences-for-b2b-buyers/It would be advantageous to maintain customer pricing in Acumatica and see that reflected for wholesales customers on Shopify.  Any thoughts on best practices with the current connector? 

Hi TeamWe have a requirement where we want to update Acumatica Customer level attributes value (based on some configuration) while customer sync from BigCommerce to Acumatica.Can you please suggest what is the best possible way to achieve it.  Thank you in Advance!

How do I clear out a backordered sales order for a line item we are not going to ship?