Retail

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.shea@bigcommerce.com 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

Hi.Does anyone here knows:1. API to get template items attributes (color and size, with its options/values)2. API to get how the SKU was generated for product matrix Thank you.

We need to delete some ship-to locations that are attached to a specific customer but I keep getting told that I don’t have permission to delete them. What do I do?

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. 

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

There are only 2 choices to show available  for the web store.  My client would prefer that negative available is ignored and factored into the calculations. In the example below, they want to see 10.This is an example I set up and tested with the store setting for Availability Mode for Available and Available for Shipping.When set to Available the store shows a qty of 8 When set to Available for Shipping it shows 20  If I allocate the sales order for the 10 pieces it changes to either 8 or 10.  Generally, we do not set the sales orders to allocate because it ties up inventory you could use for orders with earlier ship dates.  Unfortunately, there is no way to allocate orders based on date.   

We are looking for a Customer Service Sales trainer for an E-commerce team. In case you have a referral,...

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

Is there a way to make the customer pop-up note appear every time you go into the customers order and/or when a shipment is created?  It appears when you first create the sales order but never again.

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? 

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 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.

When using the Change ID action on an inventory item, the SKU# does not get updated on the BigCommerce side. Is this a bug or just a product feature that doesn’t exist yet?

Hi everyone. I need to know where in the BigCommerce I can configure the customer specific prices to provide to acumatica API.Thanks.

Hello,Is there a way to export a specific price attached to a price code to Shopify so that the price of an item updates when the price attached to the price code is updated?Alternatively, is there a way to make the “RETAIL” price code populate the “default price” field as this would also solve the issue?  

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!

Our customers get uploaded automatically from our CMS. By error sometimes twice. Once in acumatica, how do I merge the customers, so I have only one customer in acumatica?

Is there a way to export record notes from an SO to BigCommerce?I’m currently working with a user who needs to make timestamped document notes on a Sales Order to update customers on their order statuses.Currently attempting to leverage Export Mapping on the Entities screen, however I am getting an error. Any thoughts/ideas? Thanks!

AcuGateway - Acumatica Card Terminal EMV Chip Support by IIG  Learn how AcuGateway by IIG is a credit card terminal integration supporting EMV Chip, Debit Pin Entry, and Signature Capture can streamline your processes and how your company can benefit from savings resulting from TranSafe integration. During this webinar we will be giving a full walk-through demonstration of this enhancement and its functionalities in:AcuPOSSales Order Payment Application Supporting:Credit Card TerminalEMV Chip ProcessingSignature CapturePIN Based Debit TransactionsLevel II and III Processing​ YouTube Overview and Demo: 

Shopify uses API versioning to manage changes and updates in their APIs without breaking existing apps or integrations. How Shopify API Versioning Works:Shopify releases a new API version every quarter (every 3 months). Each version is supported for 12 months. After 12 months, the version is deprecated and apps should upgrade to a newer version to continue working properly. Shopify API changes can be found here - https://shopify.dev/changelogTo support this process Acumatica team is delivering once a quarter version with support of latest Shopify API version for all Acumatica supported versionsAcumatica team strongly recommends updating/upgrading to the latest version to support the latest stable version of the Shopify API.Please check the following Shopify API versions supported by Acumatica: Shopify API version Acumatica versions Changes 2026-04 Supported till April 2027 2025R2 General Release Patch 9 and later 2025R2 Service Pack 1 Patch 6 and later 2026R1 General

Hi I have this issue in invoices when I tried release from hold and change the records, and I don’t know how to resolve this.The version of acumatica is  20.216.0024 R2please help me.Thnk u.