Retail

Hi Team,We have a requirement where we have to import BigCommerce orders with Invoice order template and have to Prepare & Release Invoice subsequently for this order.We are able to import orders with Invoice order template. Now, when we are trying to execute Prepare Invoice action using Base.prepareInvoice.Press(); we are getting errors like: The Prepare Invoice action is not available in the Sales Order: Order Type = IN; Order Nbr. = AR010201 document at the moment. The document is being used by another process. or simply Invoice. Please find below code piece for review that have tried:Approach 1: Results in error - The Prepare Invoice action is not available in the Sales Order: Order Type = IN; Order Nbr. = AR010201 document at the moment. The document is being used by another process.public delegate void PersistDelegate();        [PXOverride]        public void Persist(PersistDelegate basemethod)        {            basemethod();            if (Base.Document.Current.xyz == "")

In continuation withThe existing ImportMatrixItems customization is upgraded to 2022R2 with the below interesting changes. Now there are Import Scenarios for both Template Items and Matrix Items.Import Scenario for Template Items Import Scenario for Matrix Items The Edit Template ID checkbox in the Item Class form which enabled the Template Item ID field in the Stock/Non-stock form is removed.  The Template ID selector is always enabled and filtered based on the Item Class of the Stock/Non-stock. Template ID selector is filtered based on Item ClassThe Is a Kit checkbox is enabled in the Matrix Item which allows the Matrix Item to be created as a Product Kit. Check    Template ID and Is a Kit fields are always enabledIf the selected Template ID in the Matrix Item does not match with default fields with each other then a popup warning is provided to the user.  The fields that are checked are TypeValuation MethodTax CategoryBase UnitSales UnitPurchase UnitPopup warning when default fields

Hello,In Acumatica, I would like to update the Entities for Stock and Nonstock items. For Target Field = Weight, I would like to adjust the formula to look for a weight, and then default to a value of 1 if the weight is null. The goal is to make it so that we don't 1) have 0 weights in BC, and 2) Avoid having to manually enter weights into BC.We've received two tickets in the last 24 hours regarding unpurchasable giftboxes on our website. These all seem to be related to items with 0 weights. As sales continue to pick up, I anticipate this becoming more of an issue. I'm working internally to get accurate weights added to ACU, but would prefer a quick solution to prevent this issue in the short-term if possible.Is there a way to query items with no weights to remedy those?

When we create new products in Acumatica, we do not want them to show as Active in Shopify until we have a chance to update images, tags, etc. in Shopify. (We handle all of that in Shopify, not in Acumatica.)The connector automatically creates new products in Active status; is there a way to change this and set these products to Draft status when they are initially created? (Outside of creating a custom field or attribute and mapping to the Status field?)

Hello,I am Trying to find where/how to add a new “ERP Field / Value” to the BC202000 screen. We would like to be able to push an attribute with the “ERP Object => Template Items → Matrix” like we are able to with the “Template Items → attributes”.Or we would like to be able to push a custom field on a matrix item so we can push our UPCs to Shopify. How can I add custom fields to this dropdown?I’ve been looking through the PX.Commerce.Shopify source, but as far as I can find it pulls the values out of the ether.Thanks in advance!

Hi Teamwe have a customisation in place where we wanted to land all the categories to a specific category only so how we can override this redirection.  Thank you in advance.Best regards,

  We have tried integrating shopify to Acumatica before (importing stocks, customer, and sales order). However, we stopped for some issues encountered concerning the POS. Just recently, when we back to check it again, it prompted an error about the endpoint. We resolved it by creating another endpoint and another commerce store in Acumatica with the newly created endpoint. The setup from the first store we had was the same as the new one. However, when I tried to import a customer, there was an error that said: Sequence contains no matching element. Has anyone else experienced this?Trace Log:   

We use Template Items in Acumatica with Matrix items by Condition (New, Used, Refurbished, etc.). We really only have one attribute but we are required to use two in Acumatica in order to generate the Matrix items:  However, when the products sync to Shopify they sync both attributes as two different variant options: The 2nd variant option (in our case, “Condition Level”) is not necessary for us and shows up on the product page, which we do not want. Is there any way to unmap this specific variant option in the connector? Or another method to prevent this from syncing to Shopify?

We would like to be able to show a more formal description for each Matrix item on the BigCommerce site. Right now when you select a template on the BigCommerce site and then choose your variant options, the only fields that are displayed about the selected Matrix SKU are the image, the price and the SKU ID. The description for the item is simply a reiteration of the variant options selected on the checkout page, and nothing more. We would like to have the fill item’s description shown in Acumatica for that Matrix item displayed along with the SKU ID on the main page and the cart. When looking at the BigCommerce backend, we do not see a specific field for the description on the SKU columns. There are Bin Picking Number and UPC/ISBN as fields to be displayed, yet nothing in Acumatica found syncs to those fields.Does anyone have any suggestions on how to show a more detailed description of the SKU when the variant options are selected on the template?We are using Acumatica version 2023R1

We use Big Commerce as our website (and Acumatica 2022 R2).  Is Google BigQuery part of or easily installed into Big Commerce?  

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;