Retail

In this topic we will review how we can extend/workaround areas not supported by either Acumatica’s Shopify Connector or Fields not being passed by Shopify APIsIn the use case below. Customer wants to filter the orders that are “on hold” in Shopify. This status is currently not supported with the current connector but will be included in future releases once Acumatica switch to use the new “GraphQL”. For now the workaround was to use Shopify “Flow” to add a tag “ThisOrderIsOnHold” and filter on this tag in Acumatica. Following are the detailed steps1-Create a trigger in Shopify to add the tag “ThisOrderIsOnHold” when fulfillment status is “on hold” When user puts order on holdThis will result into adding the tag once the “Hold fulfillment” action happens 2-Create a filter in Acumatica to filter orders having this tag 3-Create another trigger to remove the tag from the Shopify Order once the hold status is released   This will cause the order to flow back to Acumatica-------------------

Hello,We have two retail stores that are setup as two separate Branches in Acumatica - say Branch1 and Branch2. On Shopify POS each retail store is a separate Sales Channel - say Channel 1 and Channel 2. I have been unable to find a way to map or tell Acumatica that Shopify POS Sales from Channel 1 belong to Branch1 and Channel2 to Branch2. All Shopify POS Sales fall under the same Acumatica Branch. Is there a workaround or a setting I am missing? Thank You

I want to show you a way how can you configure saving of a Credit Card Profile inside Acumatica even if the payment is done on the BigCommerce side.This functionality is possible only if both of the systems have integration with the same Credit Card Processing Center. In my case I will use example of Authorize.NET as this processing center is supported and by Acumatica and by BigCommerce. Step 1: We should configure Authorize.NET plugin at BigCommerce (under Store Setup → Payments) to store credit cards:Please note that it will be up to user to store or not the credit card information with you. Step 2: Now if user places the order, there will be an option to save card for the future usage on the payment settings:Please note that this option will appear, only if you have logged in user. For the guest user this option is not available Step 3:  Now we should configure Acumatica to support Credit Card profiles. First place will be at the processing center level:And the second place under t

Hi, all orders coming from Shopify POS generate this error: “Object reference not set to an instance of an object.” What do you think I should check?

We are reviewing switching from Big Commerce to Shopify.  We are stuggling with cost effectively customizing our Big Commerce store.  Is Shopify B2B a good solution that can be customized cost effectively? 

Hey all,Error Msg on Sync: At least one GraphQL error has occurred. Error: Input size greater than 250.;I ran into this error originally on build 23.206.0006, now running 23.209.xxxx due to the replies on this thread mentioning a fix was implemented on 23.207.0025.Still running into the same error even on the newest build. I tried deleting the price list on Shopify and running prepare + sync again to no avail. It imports about half of our list and then errors out. It doesn’t appear to be an issue with Companies / Company Locations for us, as mentioned in the other thread above, as there aren’t very many companies associated to this Price List. Well under 250 companies / locations and ~4000 items on the Sales Price List.Please let me know if any other information would be helpful.

With 2024 R2, we are adding ability for the users to import payment terms from the order in Shopify to the terms for the imported sales order.The rules for importing payment terms during the order import process, the connector shall: Check if there is a substitution list added to the Payment Terms checkbox in the Order Settings tab of the Shopify Stores (BC201010) form, and if found, match the payment term name from the substitution list to the credit term in ERP.  If no substitution list, check the actual Credit Terms(CS206500) name in Acumatica and if it finds a match the payment term name from Shopify, then use it. If still no match, use the default credit terms from the Customer record. To sync Payment terms from Shopify Order to Acumatica Sales Order using substitution list, the users can follow the steps outlined below: Find the payment term name that is in the Shopify orderIn the Shopify back office page, open an order with payment terms.   The user can then look at the order ti

Hello Linkies,I have been trying to record the taxes payable and claimable by created SO/AR Invoices & PO/AP Bills, but not able to show it up on the Prepare Tax Reports (TX501000) form nor on the Tax Summary/Details reports. Kindly let me know what I am missing here.  The Tax Periods are also open.Thanks in advance.

Hello team, is there a setting in Acumatica for Shopify POS sales orders so that the orders status is set to completed instead of open? At the moment, all Shopify POS orders are coming in as open and we have to close them manually.

Hello,One of our team accidentally processed a credit card payment on the wrong customer’s order profile. Is it possible for us to remove this payment from the incorrect sales order, and apply it to the correct sales order for the correct customer? Thank youPatrick

Hi there,We are a Canadian company;  We’re using Shopify for our POS and Online store.  We are planning to sell to the US;  Does anyone know what need to set up in term of necessary item’s so that the fields will sync between Acumatica and Shopify?  We have two item’s fields in mind ie. the Commodity Code and Country Code.  It looks like a customization is needed in order for the Connector to sync these fields.We would greatly appreciate any advise of what exactly needs to be done before we can sell to the US.  Thanks...

Hi Team,We configured Shopify store in Acumatica build version - 23.212.0024, while sync the Sales Order, we are facing issue “The Company entity is not active. Activate it in the store settings.” Shared the screenshot for referenceCan you please review and suggest the solution. Thank you in advance!

Hi Team,We setup an instance of 24R1 (build 24.104.0008) and trying to configure Shopify store.But after providing configuration details when we are clicking save button, we are getting an error like: “Index was outside the bounds of the array”. Please find below screenshot for reference.Can you please review and suggest the possible root cause and resolution for the same. Thank you in advance!

Hey all,Currently using Acumatica Shopify App via the Shopify App Store. I’m guessing this error has to do with the permission configured there but we can’t manage those as far as I can see. My best guess for a workaround is to create a Custom App for Acumatica connector and assign the permissions there. Anyone else run into this?  

Hey Folks,Couldn’t find much on this, so wanted to see if anyone had any thoughts:In template item creation, under the “matrix item” tab, it is picking up the “last cost” and it seems to push this to Shopify as the product cost even though the item has a ‘current’ cost defined under the Stock Item: These particular items have a “Current Cost” but not a “Last Cost”:  Do we happen to know why the Shopify Connector uses the Last Cost and not Current?  Are we supposed to be updating the cost to “last cost” routinely?Cheers,k2

Hello @simonliang91 @KarthikGajendran et al. I was looking through the mappings and wanted to see if we have any updates to the following:https://help.acumatica.com/(W(11))/Help?ScreenId=ShowWiki&pageid=5ecd0d16-a869-4ccb-bf09-7ffb05f25a4e& For Shopify integrations I have the need to map:Country Of Origin - I don’t see this as a field value that is mappable in the entity screen and it is not mapped out of the box.  Last Cost vs. Current Cost - i know there are couple threads out there (one that I started) but it seems the customization focuses on Matrix Items.  It would be nice if we had the option to choose which one, as I have an example where the valuation is FIFO and it is not pulling last cost.  It is pulling the current cost (from Standard Cost) so this is effectively 0 in our scenario.  Pricing - a general question - does the mapping consider sales pricing at all?  either promotional or worksheet based (non b2b)?Cheers,k2

We are looking for a checklist of items to prepare our Big Commerce sandbox for testing when we upgrade Acumatica.  Any help would be greatly appreciated. 

I’ve had this issue for exactly a month now. Items randomly fall into this error status of “The record cannot be synced because it does not exist in the external system”. All of these also have the characteristic of being a Status = Deleted. The item itself isn’t deleted but the Sync History record is. See this video which shows that when I try to update the status and sync the item, it automatically falls back into the status of Deleted: We’ve been manually updating our inventory in Shopify, among other manual updates due to bugs. It’s very labor intensive and we’re going into our busy season. We migrated to Acumatica due to the integration with Shopify, but it’s not working out so great. Please help!    

HiFor an example if we purchase the same product (say a book with price tagged) in two different times with two selling prices.Product 1 | Purchased 5 books on January 01 | Tagged Selling Pirce 100Product 1 | Purchased 10 books on April 01 | Tagged Selling Pirce 120When entering a Sales Order how can we the select price of the book (either 100 or 120)?If we are using FIFO to issue the goods, is there a way to allocate the stock automatically when selling 8 books in the above example.Selling 8 books , 5 @100 and 3 @120 

Our salespersons manage customers at the customer account level. However, in Acumatica salespersons are assigned to customers at the customer location level.One area where this is becoming an issue for us is ecommerce, specifically Shopify. All of our customers are assigned to a salesperson to manage their accounts, including ecommerce customers. However, if a salesperson is assigned at an ecommerce customer’s default location, and then the customer creates a new location in their Shopify account, that new location syncs over to Acumatica without a salesperson assigned. This means the salesperson assigned to the customer’s account is not credited and does not receive commission on that order (when they should).Does anyone know if it is possible to set a default salesperson to the customer account so that this salesperson is automatically assigned to any future locations created under that customer account?

Hey folks, doing some testing in Sandbox and encountered this error when using the Commerce Connector to prepare data (Refund Entity):  Anyone encounter this before?  It didn’t seem to prevent items from being prepared, although I”m not sure it capture all of them.  I was having intermittent internet connectivity issues as well, I’m wondering if that’s what caused this error….Cheers,k2

We are interested in being able to offer BOPIS to our customers but the connector for BigCommerce does not offer mapping for locations/warehouses. The connector for Shopify does.

When you have a Shopify store, and you use integrated carriers, Shopify will update an order when the package is out for delivery and then when it’s delivered. In Shopify it will look this:So, apparently, by this time, the order is shipped and completed in Acumatica.  But these order delivery updates trigger the Shopify Connector to try to update the order in Acumatica, which returns an error: The status of the {{order number}} order does not allow modifications. Please synchronize records manually.Is there an elegant way to work around this?Thank you, friends!

Version 2023 R2: 23.208.0026Created an Order in Shopify with a Manual Discount Successfully synced the Discounted Order from Shopify into Acumatica Successfully completed the Order/Payment process for the discounted order in AcumaticaNow the next step is the errorIssue a refund in Shopify of the Discounted Order Process the refund Discounted Order into Acumatica Error: The Discounted Refund Order is pulling the full price $ and not the Discounted PriceThe Refund Entity is pulling the full price of the item and not the DiscWhy is the Full Price syncing into Acumatica and NOT the Discounted Price? In the build below under the Retail-Commerce section it mentions that this has been fixed but I’m still running into this errorUpdate 16 Build 23.116.0019 release notes (2024-03-15):Update 16 Release NotesRetail-Commerce AC-294136: A Shopify sales order with line item discounts had been imported with its payment to Acumatica ERP, then was completed in Acumatica ERP and set as Fulfilled in the S

I believe I heard at the last Summit that Shopify is now able to offer multiple units of measure as an option.  If so, other than adding the unit of measure conversion on the Stock Items screen is there any other setup that would need to be done in Acumatica?Thanks