Retail

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!

We have drop ship products on our Shopify site - if purchased, the order will sync to Acumatica, a drop ship PO will be created, and then a drop ship receipt once the vendor has confirmed the order has shipped.Is there a way natively to mark these orders as fulfilled in Shopify? This happens automatically for orders with product we stock and can ship from our own warehouse; a shipment is created and confirmed and the order is marked as fulfilled in Shopify. However, because the drop ship process uses a receipt instead of a shipment document, and there is no place to enter tracking # information in a receipt, we cannot see a way to mark the order as fulfilled in Shopify.We are currently on 21R1, in the process of upgrading to 23R1; perhaps this has changed in the latest release?

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

Is there a way to prevent SO lines with identical inventory IDs from being combined when creating a PO from them?

In the move from 23R1 to 23R2, it switched from mapping the Cross Reference Alternate Type of Barcode to Alternate Type of GTIN/EAN/UPC/ISBN. See below in the respective documentation for each version: 2023R1 documentation 2023R2 documentation We spent the last few weeks with our VAR testing this “bug” in our 23R2 sandbox and finally figured out that it was actually changed. When we launched on Acumatica in October, we came up with the procedure to add additional barcodes from our vendors into the cross reference as GTIN/UPC/ISBN so we can reference it when we receive the product. But, Shopify only take ONE barcode. So, we’ve built all of our inventory management/labeling procedures around the fact that it would be taking the Alternate Type of Barcode. Now that that’s flipped, we’d need to throw those procedures out the window, do some massive Import Scenario updates to the ~3 cross references on our 80,000 items and retrain our organization.  Can someone let me know WHY this change wa

We have Shopify with the BOPIS option in two locations, and we want the inventory to be deducted from the location where the product will be picked up and not from the Default warehouse when an online order is placed. Please can help us to find where can we make this setting in Acumatica? 

BigCommerce Integration VideosThis short video shares the most basic example of the integration between BigCommerce and Acumatica.Thorough introduction to the Commerce Edition for our VARs – 20 minutesThis is a thorough introduction of the 2020r1 Commerce Edition specifically for our VARs. I show a demonstration managing product data, Products with Variants, customer specific pricing, placing orders and processing shipments. Additionally I go into more detail about the connector, how it works, how data flow is managed and answer a few questions about pricing, etc. Quick demonstration of the Commerce Edition – 10 minutesThis is a brief demonstration of the Commerce Edition showing the product information flowing from the ERP to BigCommerce, the customer viewing and purchasing a product, the checkout process, the sales order creation from BigCommerce and the shipping status information flowing back to BigCommerce. Technical Deep Dive – 18 minutes  Technical Deep Dive into the Connection

Shopify Payments syncing has been working great. However, we had our first backorder on a Shopify Payments order. The authorization from Shopify within Acumatica was captured for the amount of the order minus the backordered items/freight. We received the goods in to ship, but the authorization no longer had a balance even though we did not capture the full amount. Well in Shopify, you can still capture the balance. So we did. However, that second payment is not syncing to Acumatica so we cannot apply that payment to the shopify order/invoice. What are the plans to address this? Back ordering is common in our industry and we want to allow that for web orders. We can try to create a manual payment to mark the order/invoice as paid in Acumatica. But, that is not a real solution. Thoughts?

Have been getting the above error whenever I try to sync the prices to be exported to Customer Groups from Acumatica to BigCommerce.

We have just come across this issue having been using Acumatica with Bigcommerce for a couple of years.  We have a promotion for an item XYZ which means a discount is applied when ordering 12 or over. We have also added a promotion for that same item when bought with another item ABC where it will be discounted by 2%. In BigCommerce this results in 11 items at the reduced price from the dozens discount with 1 item at a further reduced price from the ‘buy with item ABC’ discount.  This is fine and as expected. Our BigCommerce store in Acumatica is set up to show discounts at the document level.The problem is that when the item syncs to Acumatica it results in multiple lines for item XYZ. One for the first 11 and another for a single item.  These show the same price (the reduced dozens discount price) for both lines as the discount is being shown at the document level.I would expect as the discount is being applied at the document level these would be combined.  This is causing extra wor

We currently have the Shopify Connector setup and want to start using the Shopify POS.  I don’t see the Shopify and Shopify POS Connector option or Custom Connectors option in our production environment, just the Shopify Connector option. We have the Distribution Edition and added Shopify.  We don’t have the Commerce Edition, I’m wondering if that is why, or is it just a completely different license and it’ll be added after we get a difference license that includes the POS Connector?  

We’re trying to set up the Outlook Extension for Accounts Payable bills. Has anyone run into this issue where it doesn’t work for shared folders? I guess the extension needs to be engineered to accommodate shared folders. Is there another extension out there that accommodates that?