Retail

I've set up a connection between my Shopify and Acumatica systems. When a customer placed an order and made a payment, it resulted in the creation of an order (SO.30.10.00) and a prepayment (AR.30.20.00).However, today, the customer decided to cancel the order. Now, when I check the 'Sync History,' I've encountered an error message stating, 'The applied amount cannot exceed the unbilled balance.' What might I have done incorrectly? Why is Acumatica preventing me from syncing this transaction?P/S   Acumatica version = 2023 R1Build 23.111.0019 

Hello,I’m launching on Acumatica and trying to sync Template Items with an existing Shopify store with the same products in it already. I’m hoping to sync them up with each other. However, I’m receiving this error each time (below). Please let me know if anyone has encountered this or knows what the remedy is. Thanks!  Product options could not be created in Shopify. There are 1 variant types in the MISIML template item, but Shopify supports only up to 3 product options.

Context: Allowing preorders for BigCommerce products (stock items). We’re currently on 2020 R2 (updating to 2021 R2 in the next 90 days) and on the BC Enterprise storefront. BigCommerce Requirements: To properly allow the native ‘preorder’ functionality to work on BigCommerce, two settings need to be adjusted:‘Availability’ needs to change to ‘This product is coming soon but I want to take pre-orders’ ‘Inventory Tracking’ method needs to change to ‘Do not track inventory for this product’Acumatica Settings: At the individual stock item level, it is possible to adjust the ‘When QTY Unavailable’ setting within ‘Inventory Settings’ to ‘Set as Pre-Order’. Sounds great. Acumatica Behavior: This ‘Set as Pre-Order’ action only adjusts the BigCommerce ‘Availability’ setting to the required ‘This product is coming soon but I want to take pre-orders’. However, without the ‘Inventory Tracking’ setting getting updated in tandem, the action of allowing pre-order isn’t actually achieved. There are o

Anyone know how to prevent note synching between Shopify <> Acumatica? I assumed it was possible through the Sales Order entity > Import Mapping, but that doesn’t seem to be working.I’ve tried both of these options to no avail: We use the Notes field in Acumatica extensively and we have instances where the order resyncs with Shopify and the Notes are overridden, so we are trying to prevent that from happening.

Does anyone know if the ProGlove Mark 3 scanner is compatible with the Acumatica mobile app? https://proglove.com/products/hardware/mark-3/

Hey everyone, I’m currently working on this error and trying a few different things on the Shipstation Configuration settings as well as the the Acumatica to Shopify Entity settings. I’m not seeing it at all on the community so I figured I’d post it here while I work on it. If anyone has any suggestions, please send them my way.  This shipment cannot sync due to this error. It seems to only be an issue on a handful of shipments but it’s possible that this might be a continued error. “Error on errors : All fulfillment orders must have the same delivery method type. Multiple delivery method types ["none", "shipping"] were found.;”

On a number of our clients’ Shopify stores, we can’t access Acumatica App, getting this error: This happens in Google Chrome, Mozilla Firefox, and Safari.  Tried on Windows and MacOS.Any thoughts, @KarthikGajendran , @smarenich ?Thank you!

Can I configure the Acumatica Connector to sync our Customer Attributes from Acumatica to Big Commerce? 

Two core settings in our Big Commerce website have mysteriously reset.  One is “Track Inventory”.  Our system is set up to track inventory and so when stock goes to zero, the item is automaticsally removed from our webset and when we restock the item the item is automatically returned to the website.  The “Track Inventory” setting was “unchecked on hundreds of items and hundreds of out of stock items reappeared on our website.  Two, some of our items are set to “do not sell on the website” and instead “Call for Pricing” appears under the item.  All of these call for pricing items were reset and the “do not sell” box is not checked. And the Call for pricing has disappeared.  We are on 2022 R2.  What is happening?  Big Commerce has not idea what is causing this to happen.  Can anyone help us? 

Does anyone have any experience using SQUARE POS? We have a Retail Store, BigCommerce site and we use Acumatica as our ERP. I would like to start using SQUARE for our POS.

Good afternoon Acumatica community! We are hoping to get a question answered about the sync between Shopify and Acumatica for the Payment entity.We have one Shopify store connected. Every Entity other than Payment is syncing as expected. We are using ShopifyPay to process CC payments for orders through our website. At the tier we’re on, ShopifyPay charges 2.6% + $0.30 per order.This information doesn't seem to be imported into Acumatica for us at this point. The payment comes through like this:Image pulled from the Sync History (Commerce module)Image pulled directly from the payment entry generated by the sync We are sure the system is capable of importing the fee information based on the following screen shot from Shopify’s backend. Our VAR advised us to add Shopify’s fee manually later in the process, but this is cumbersome and ultimately not scalable. We are looking for advice about where to add these fees (potentially in the payment methods of Acumatica?) If someone has done this b

When we are in the sales categories, we do see all items and template items associate to each sales categorie, but we can’t have access to templates items when we click on the link. We only have access to stock items.When we click on a template item that appear in the sales categories, we got a blank page associate to sotkc item IN20500. It seem like there’s a problem or a bug.It would be more efficient if we could also have link instead of having to open another tab and make another search.

We are exploring the use of Shopify as a gateway to import orders from TikTok Shop into Acumatica. TikTok has finally started developing their own solution for this but it is lightyears behind other social media shopping channels. Does anyone have any experience in this area yet?

Hello folks,I was wondering why RC order type was chosen as the only supported return order type for the Commerce Connector? It seems like RM order type would be better suited, as it allows for issues and for receipts, credit memos and invoices, it’s more versatile. One of our clients said:The reason we prefer RM is that this Order Type allows both Operation types: Issue & Receipt AND it allows for an Invoice.The other two types are more limited.For instance, an RC does not allow for things like charging a Restocking Fee (Issue)And an RR allows for an even exchange but not for an exchange where money changes hands (which is 80% of what we do)What do you think about this? Are there any drawbacks of allowing to use RM order type for ecommerce returns / replacements?Thank you!

I don’t know why when I release a PO receipt that has a line with a Service line type, the accrual account is missing as illustrated below; 

The following error is getting shown up whenever I am trying to import the Sales Order which consists partial payment with Gift Certificate ($25) through BigCommerce.  

Does anyone know if it’s possible to have a virtual warehouse/inventory in Acumatica? We receive inventory files from vendors and it would be great to be able to “receive” that inventory into a virtual warehouse so our salespeople can see available quantities from the vendor. In theory we could then also sync that inventory to Shopify so we can prevent overselling on drop ship inventory.If it’s not currently possible in native Acumatica, are there any 3rd party solutions? Or ideas for workarounds?

Hi Team,We are working with Shopify connector (build: 21.224) to import Shopify Orders into Acumatica. We have a date field that we want to update with Shopify order created date time. This field is split on the UI as Date and Time part but is a single field only. We tried like below but the field value is not updating. Can you please review below details and suggest the best possible way to do that. DAC:  #region UsrKNSPSBOrderPlacedTimeStamp        [PXDBDateAndTime(PreserveTime = true)]        [PXUIField(DisplayName = "Placed Datetime")]        public DateTime? UsrKNSPSBOrderPlacedTimeStamp { get; set; }        public abstract class usrKNSPSBOrderPlacedTimeStamp : PX.Data.BQL.BqlDateTime.Field<usrKNSPSBOrderPlacedTimeStamp> { }        #endregionGraph:public class KNSPSBSalesOrderProcessorExt : PXGraphExtension<SPSalesOrderProcessor>    {        public static bool IsActive() { return true; }                public delegate void MapBucketImportDelegate(SPSalesOrderBucket buc

Hi All, Is it possible to have a unique Default Order Type based on which branch or company you are logged into? We have 2 separate companies in our instance. Company A uses Quotes, or QT order type, for 99% of their orders. Meanwhile, Company B uses Sales Orders with Allocation, or SA order type, for a majority of their orders. Changing the sales default sales order setting affects the default for both companies: Is there a unique setting per company or branch that can be used to configure this instead?

Hi Team,We are working with BigCommerce connector (build: 23.105). In BigCommerce Stores screen under inventory setting tab, we have Default Stock Categories field (Dropdown field) it loads all item sales categories by default. I want to override this field to load only required categories. We tried with fieldSelecting event but values are not updating in the Default Stock Categories field. Can you please review below details and suggest the best possible way to do that. Graph:   public class KNBCROBCBigCommerceStoreMaintExt : PXGraphExtension<BCBigCommerceStoreMaint>    {        public static bool IsActive() { return true; }        protected virtual void BCBindingExt_StockSalesCategoriesIDs_FieldSelecting(PXCache cache, PXFieldSelectingEventArgs e)        {            BCBindingExt row = e.Row as BCBindingExt;            BCBinding bCBinding = PXSelect<BCBinding, Where<BCBinding.bindingID, Equal<Required<BCBinding.bindingID>>>>.Select(Base, row?.BindingID);

We’re just rolling out Acumatica. We’re starting to utilize Template Items heavily. I’m wondering if there’s a feature we can turn on to just auto-generate the Template ID rather than having to enter something? It would save a lot of time! 

   -----------------------------------------------------------------------------------------------------------------UPDATE: Now the Matrix Item can be made as Product Kit easily by selecting the Is a Kit checkbox in the Matrix Item form. Please check this article    ----------------------------------------------------------------------------------------------------------------Create Product Kits as Matrix Items by following the below steps. Please pay attention to the screenshots were I have created a Template Item called EnergyDrink with the 3 Product Kits as Pack of 4, 8, 12 and linked them as a Matrix Items to the EnergyDrink Template Item. Steps:Create an Attribute from Attributes(CS205000) form, which would be treated as a Variant option to the Matrix Items.    Create an Item Class from Item Classes(IN201000) form and link the Attribute created in step 1 and make sure the category is set as Variant.    Create individual Stock Items from Stock Items(IN202500) form which are going

We recently upgraded to 23R1 and are interested in turning on the Order Types for Export feature under Shopify Stores > Order Settings in Acumatica. However, we’re trying to get a better understanding of what will happen once we select the order types that we want to export to Shopify.Does anyone know if the connector will sync all historical orders of those types? Or will it sync only new orders from that point on? Is there a way to control which orders are synced?

My shopify sales order is imported with a ship via that is checked as will call. This Ship Via is called PICKUP and is also set to my store shipping method. Shipment export to Shopify generated the following error:Error converting value "pick-up" to type 'PX.Commerce.Shopify.API.REST.FulfillmentOrderDeliveryMethodType'. Path 'fulfillment_orders[0].delivery_method.method_type', line 1, position 1459. Am I missing a mapping? Thanks!  

Hi,  Acumatica automatically sends the Vendor Ref number on Purchase Receipts to Shopify as the tracking number. Since we’re using the field for what it was actually intended for (Invoice Numbers), can we restrict Acumatica not to send those?