Retail

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

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

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 here

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?

We’ve entered our count and are now reviewing it via the Physical Inventory Review and a GI from the same info. I’m curious as to why we’re not seeing any values in the “Estimated Ext. Variance Cost” field? I can imagine that the “Final” value will populate once it’s completed, but how we get that Estimated Variance in order to review before completing it?   

Hi There, Is there a way to bulk update the external ID that connects Acumatica items and Shopify items? I see that there is an option to enter the external ID in the Sync History, but I cannot find this field at the product level.

We want to start using the Parent-Child Account feature in Acumatica.  Can someone tell is if we use Acumatica Parent-Child accounts, will multiple Big Commerce accounts be created (we hope multiple Big Commerce accounts are created)?

I’m ultimately trying to add each of our 70,000 items to each of a couple hundred fictious locations for purposes of a semi annual full count of our retail store. I know that we can add items one by one (article), but of course that would take ages. So, I’m trying to create an import scenario to accomplish the same thing. Here’s what I have so far:  When Importing the excel doc, I get an error that says “the scan action cannot be found”. Does anyone know what this means? Is it not going to let it be updated by import?  

Good day,We would like to upgrade to Acumatica 2023 R2 but are being delayed waiting on True Commerce upgraded package.Has anyone else experienced the delay or maybe you have the package?It is interesting that the package is not available for 2023R2 since it has been released a few months ago.Thank you. 

I’m trying to do a very simple Attribute Import. I created a Data Provider with an Excel doc that has 2 columns:Inventory ID INSZINPLNTINSZINPLNT is the Attribute ID. I am trying to test import just 1 Item (Inventory ID = FIHYW2). I want the Attribute Value to = ‘2’   2 does exist as an Attribute Value and the Attribute has a Control Type = Combo. I confirmed that I added this attribute to the Item Class for this item. Below is what the Import Scenario looks like. I’ve read all the community articles and help articles on this topic and believe I set it up consistently.  When I try to Import the Import Scenario, I get the following er

I'm trying to figure out the best way to sync third-party fulfillment products from a Shopify store into my Acumatica. My initial thought was to use a logic statement based on the Shopify line item vendor, and then push it into Acumatica as a generic non-stock item for that specific line on the Sales Order.However, I hit a snag because the ERP field for inventory ID isn't visible on the Entities for sales orders. I've attached a screenshot below for reference. Does anyone have any ideas or suggestions on how to make this work?  

When I got into the template item for a product we sell and try to delete one of the matrix items that we no longer offer I am getting an error. “Referenced in multiple tables”. The trace points to a number of locations including old sales orders and GL accounts entries. Is there a way to keep the references in the tables but remove from the matrix? (we use matrix to push to a number of ecommerce solutions our current work around works with some and not all) 

Looking for instructions on how to map the export from Acumatica to Shopify. I want to export the URL of the order in Acumatica to Shopify. This will help users quickly open the order in Acumatica. I can map the actual order number via the standard available fields. However, that’s a static field with out the URL. I’m looking for info on how to map the URL at the beginning.

Are there plans to sync the carrier over to Shopify when fulfillment occurs from a drop-ship PO?The situation we’re running into is when we sync the tracking number to Shopify, Shopify is choosing the carrier. I’m not 100% sure of their logic, but sometimes it chooses the incorrect carrier. When our customer looks up the tracking in Shopify (usually via the Shop Pay app), they are confused. Ideally, we’d be given the fields in Acumatica to sync the carrier, tracking number, and url (if necessary) so it doesn’t confuse our customers.Thanks in advance!