Commerce Edition QnA
- 343 Topics
- 1,366 Replies
Hello Acumatica Community! Check out the latest joint case studies with BigCommerce & Acumatica:https://www.bigcommerce.com/case-study/van-cafe/ (119% growth in revenue) https://www.bigcommerce.com/case-study/ink-custom-tees/ (186% growth in revenue) Cheers!Colleen Sheacolleen.firstname.lastname@example.org Manager, Strategic Partnerships
Shopify is hosting a webinar with Acumatica, Shopify and our customer Clive Coffee.I can’t wait for our community to see this!Registration links are below and please be sure to share with your network. Really appreciate everyone’s support and interest in what our team is building. It’s literally changing the lives of these business owners!Josh How Clive Coffee met demand after a year of record-breaking growthWhen: May 5, 2022 at 11:00 am PT | 2:00 pm ETLearn how the combination of Shopify Plus and Acumatica:Increased revenue by $90K through back-in-stock notifications Reduced daily order processing times from 5 hours to 1 hour Launched 30+ new products from purchase order to fulfillment with automationRegister now
Hello,We are in the midst of implementing the Commerce Connector from Acumatica(build 21.208.0032) to an existing BigCommerce store. We are implementing in phases, with the first phase being stock and non-stock items, and inventory levels. We have a custom built integration that imports orders from BigCommerce. Most of our products need to be Matrix items with only 1 variant. I have followed the steps outlined here:With the exception of importing the items as we already have the items created in Acumatica. When trying to update a stock item to be tied to a template item, I get the following error:I have been able to use that attribute to create new matrix items following our part number format. I would greatly appreciate any help in resolving this error. Let me know if any further info is needed.Thanks!
AcuPOS (April 2022) has just released new builds along with updated User Guides and Release Notes. They can be found on the Acumatica AcuPOS Community PageRelease Versions:21R1 Build 104 R45 21R2 Build 207 R04 22R1 Build 100 R01Improvements:POS Orders forming PS sales orders with wrong taxEnhancements:Smart Scanning Receipts for Returns Receipt Format - Short & Regular Item Buttons Load from Stock Item Screen
I am trying to mass import Item Sales Categories for a commerce deployment. I was able to write an import utility to import the first tier but cannot import any child sub categories.I set the folder path using this syntax: Company/Level1/Level2/Level3 etc I then set the Category Description with using the final segmentIt seems that if the path category does not exist, then it will simply import the path string as the category name.What is the proper approach and syntax to get this to work?
Has anyone configured the BigCommerce connector to work with an existing BigCommerce store? Our client has a well established store and wants to connect to their new Acumatica install. We started testing the syncs in a sandbox to see how it would work and have run into errors. With the stock item sync, we can only export from Acumatica to BC, but the items already exist in BC. When we try to sync anyways, the error says the item already exists. Is there a way to somehow map the two together to resolve the sync issue? Any other gotchas we need to look for in configuring the connector for an existing store? Thanks for your help!
Upgraded to 2021R2 and running through full resync of relevant entities - Sales Category → Stock Item → Non Stock Item → Template Item. Got to Product Availability, and encountered a new error I’ve not previously seen: Error: Specified argument was out of the range of valid values.Parameter name: IdentifyNoteIDSteps: Ran a ‘Full’ Prepare request for Product Availability Entity (previous automation schedules inactive since just prior to cutover to new release). Attempt to Process records. Encountered error above. The records do not appear to fail (ie, do not move to a failed or aborted status in Sync History), but just remain in the ready to process queue. I’ve approached this from both the prepare/process screens and from the sync history screen, and keep encountering the same error. Acumatica Trace from this screen:Right now I don’t have a means to reconcile product availability since our cutover 72 hours ago, which is problematic.
Dimension Creation in AcuPOS:AcuPOS requires the DimensionCreation customization package to be published(only once for the instance) and then the AcuPOS build to be published to the Acumatica ERP instance. The DimensionCreation customization package creates "WORKSTATION - POS Workstation" segmented key record in the Segmented Keys(CS202000). It is required to create a "WORKSTATION - POS Workstation" segmented key before the AcuPOS publishing. This operation can be done either manually or by the DimensionCreation customization package. In the case of creating a new tenant occurs a situation when in the new-created tenant the workstation segmented key is not created but the User Profile has a Workstation ID field to be selected. PROBLEM:For this reason if you try to create a new tenant while the AcuPOS packages are still published you will receive the following error: Unable to cast object of type 'IGFS.DAC.IGFSUsersExt' to type 'PX.Objects.FS.FSxUser'. at memberwiseCloneExtensions(U
This is the Example ERROR: Export of the Stock Item record cannot be completed. The Stock Item with the same field or fields (<<item description>>) already exists.The first item has been exported to BigCommerce but others with the same description field didn’t. How can I export all items even if they have the same description field?
HiI want to use my own Substitution Lists in my Commerce setup when exporting the Item entity.The formula function SubstitutionList and SubstitutionAll is available but during Process of data it fails with error SubstitutionList function unknown.Is this a bug?
Is there a solution to sending package tracking numbers to customers as a link to USPS or even Google?If I click the link in the email below, it currently will send me to google with the Acumatica field nameThis is the html code I used to create the link...<a href="https://www.google.com/search?q=((Packages.TrackNumber))" style="text-decoration:none;display:inline-block;color:#ffffff;background-color:#034e7d;border-radius:4px;width:auto;border-top:1px solid #034e7d;border-right:1px solid #034e7d;border-bottom:1px solid #034e7d;border-left:1px solid #034e7d;padding-top:5px;padding-bottom:5px;font-family:Arial, Helvetica Neue, Helvetica, sans-serif;text-align:center;mso-border-alt:none;word-break:keep-all;" target="_blank">
A client with an existing Shopify store connected to their legacy ERP uses variants but they do not wish to utilized Matrix items in Acumatica. Instead the just want to have each variant as a individual SKU in Shopify. The Shopify help says to delete the variants and the default. They want to continue to sell the SKU’s in their store. For example SKU 1234 has ‘’, A , and B as variants and they want to have them as1234, 1234A, and 1234B as individual SKUs
We are having problems with exporting template items that have never been synchronised before. e.g. The item on Acumatica is called C-A892:MD with a : between the Template ID (C-A892) and the SKU code (MD). When it gets created in BigCommerce it is created as C-A892-MD which doesn’t match and gives an error on the export sync ( "The synchronization could not be completed because variant items do not match the 7386 product in BigCommerce.")Is there any way to get around this other than manually going into BigCommerce after the sync fails and changing it before resyncing?Thanks for any advice, even if it’s just that we have to manually do it and there is no way around it.Phil
Is there a way to see BigCommerce “Awaiting Fulfillment” orders IN Acumatica Sales Orders without another customization? We can’t be the only customer who has the BigCommerce Plugin integration into the eCommerce edition of Acumatica? Why we can’t see the Awaiting Fulfillment orders in Acumatica baffles me.
Hello! We’re attempting to troubleshoot a new store connection and seem to have everything in place on the Shopify side – when we try to sync the orders we get the following error:Inserting 'Sales Order' record raised at least one error. Please review the errors. CuryOpenTaxTotal: Tax is not up-to-date. CuryUnbilledTaxTotal: Tax is not up-to-date. ShipVia: 'Ship Via' cannot be empty.Shipping address and methods are present in the order JSON along with Tax lines which appear to all be accurate. Any input on where the misconfiguration could be would be greatly appreciated!
Login to the community
Social LoginLogin with your Acumatica account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.