Retail

Receiving an error when test syncing one of our Customer Prices Lists. The error says “Phone is invalid” but no further details.  My immediate assumption is that a customer/company account in Shopify does not have a phone number or the phone number is invalid. However, it does not tell which record is causing the issue.Any ideas of input on how to narrow down the source of the error?

Hi all! We are currently on 2023R1 and plan to upgrade to 2023R2 very soon.We have a group of products - safety glasses - that have pricing set by the pair of glasses, but we sell them in box quantity of 12. In the individual stock items and the template items when applicable, the conversion is set with EA as the base unit, BOX as the sales and purchase unit. The EA to BOX conversion is defined. When we export these glasses to the website, the price and product availability are showing up as the Base Unit instead of the Sales Unit, which is not what we want. We would like the export to shopify to use the Sales Unit.I’m providing a few screenshots here to illustrate the relevant details:Stock Item Page - Base/Sales/Purchase Units are defined hereLinked Template Item page - Base/Sales/Purchase Units are defined exactly the same way hereStock Item Price (price differs by lens color so price is defined here, for base UOM)Vendor purchase unit is set to BOXVendor purchase unit is set to BOXW

I am wondering if there is any update regarding the B2B features mentioned in this press release:https://www.acumatica.com/corporate-newsroom/press-releases/acumatica-broadens-strategic-relationship-with-shopify-to-enhance-experiences-for-b2b-buyers/It would be advantageous to maintain customer pricing in Acumatica and see that reflected for wholesales customers on Shopify.  Any thoughts on best practices with the current connector? 

Hi Everyone, We are collecting feedback from our customers about any challenges and pain points they face while using Acumatica via the survey linked below.We would appreciate your feedback. It could be related to the commerce connectors or related to any other area of the ERP (CRM, Shipping, Financials, etc) Examples: Processing Returns and Refunds are hard, Importing the orders through the connector is hard, Taxes issues etc.,We’d also like to understand which external apps you’re using to supplement features within Acumatica. This could be due to Acumatica not offering the same functionality or the Acumatica functionality is not user friendly. Please use this survey as an opportunity to share with us what you’d like to see improved.If you are open to it, we will schedule a call with each of you to collect more feedback, better understand your position and (hopefully) work to provide a solution.  Survey Form:https://forms.office.com/r/wJJUFqReEm Thank you

Hi TeamWe have a requirement where we want to update Acumatica Customer level attributes value (based on some configuration) while customer sync from BigCommerce to Acumatica.Can you please suggest what is the best possible way to achieve it.  Thank you in Advance!

How do I clear out a backordered sales order for a line item we are not going to ship?

We’ve entered our count and are now reviewing it via the Physical Inventory Review and a GI from the same info. I’m curious as to why we’re not seeing any values in the “Estimated Ext. Variance Cost” field? I can imagine that the “Final” value will populate once it’s completed, but how we get that Estimated Variance in order to review before completing it?   

Hi There, Is there a way to bulk update the external ID that connects Acumatica items and Shopify items? I see that there is an option to enter the external ID in the Sync History, but I cannot find this field at the product level.

We want to start using the Parent-Child Account feature in Acumatica.  Can someone tell is if we use Acumatica Parent-Child accounts, will multiple Big Commerce accounts be created (we hope multiple Big Commerce accounts are created)?

I’m ultimately trying to add each of our 70,000 items to each of a couple hundred fictious locations for purposes of a semi annual full count of our retail store. I know that we can add items one by one (article), but of course that would take ages. So, I’m trying to create an import scenario to accomplish the same thing. Here’s what I have so far:  When Importing the excel doc, I get an error that says “the scan action cannot be found”. Does anyone know what this means? Is it not going to let it be updated by import?   

Good day,We would like to upgrade to Acumatica 2023 R2 but are being delayed waiting on True Commerce upgraded package.Has anyone else experienced the delay or maybe you have the package?It is interesting that the package is not available for 2023R2 since it has been released a few months ago.Thank you. 

I’m trying to do a very simple Attribute Import. I created a Data Provider with an Excel doc that has 2 columns:Inventory ID INSZINPLNTINSZINPLNT is the Attribute ID. I am trying to test import just 1 Item (Inventory ID = FIHYW2). I want the Attribute Value to = ‘2’   2 does exist as an Attribute Value and the Attribute has a Control Type = Combo. I confirmed that I added this attribute to the Item Class for this item. Below is what the Import Scenario looks like. I’ve read all the community articles and help articles on this topic and believe I set it up consistently.  When I try to Import the Import Scenario, I get the following error: Field: Value, Value: 2, Error: The 406 class does not have the INSZINPLNT attribute. Make sure the attribute name is correct or consider adding the attribute to the class.I thought I accounted for the Item Class. Is it another class that I’m missing? 

I'm trying to figure out the best way to sync third-party fulfillment products from a Shopify store into my Acumatica. My initial thought was to use a logic statement based on the Shopify line item vendor, and then push it into Acumatica as a generic non-stock item for that specific line on the Sales Order.However, I hit a snag because the ERP field for inventory ID isn't visible on the Entities for sales orders. I've attached a screenshot below for reference. Does anyone have any ideas or suggestions on how to make this work?  

When I got into the template item for a product we sell and try to delete one of the matrix items that we no longer offer I am getting an error. “Referenced in multiple tables”. The trace points to a number of locations including old sales orders and GL accounts entries. Is there a way to keep the references in the tables but remove from the matrix? (we use matrix to push to a number of ecommerce solutions our current work around works with some and not all) 

Looking for instructions on how to map the export from Acumatica to Shopify. I want to export the URL of the order in Acumatica to Shopify. This will help users quickly open the order in Acumatica. I can map the actual order number via the standard available fields. However, that’s a static field with out the URL. I’m looking for info on how to map the URL at the beginning.

Are there plans to sync the carrier over to Shopify when fulfillment occurs from a drop-ship PO?The situation we’re running into is when we sync the tracking number to Shopify, Shopify is choosing the carrier. I’m not 100% sure of their logic, but sometimes it chooses the incorrect carrier. When our customer looks up the tracking in Shopify (usually via the Shop Pay app), they are confused. Ideally, we’d be given the fields in Acumatica to sync the carrier, tracking number, and url (if necessary) so it doesn’t confuse our customers.Thanks in advance!

The encountered we encountered in the title is similar to this error.But, we are using ShipperHQ as Shipping app in our BigCommerce store. We also use the Advance feature of Delivery Date and Time, to display the delivery date and time in the checkout.In Acumatica syncing though, this resulted to a Shipping Method name with appended delivery dates  Since the dates are dynamically created, we need to manually map each date for same method in the BigCommerce Store screen.Do we have a way where we can map one time the FedEx (Ground Delivers) Shipping method to any FedEx (Ground Delivers) + Date that BigCommerce/ShipperHQ provides?

Prior to Acumatica, we simply managed the “Continue selling when out of stock” designation in Shopify. Now, it seems Acumatica wants to impose it’s will at a global level across all products for this setting.For 99% of our products, we want to NOT sell when out of stock. But, there are a handful that we DO. So, for those we’d like the “Continue Selling” checkbox to remain checked at all times so that when it does go out of stock, the customer can still buy it. See below from the Shopify Mapping Reference. I believe the setting I want is “Do Nothing” because that’s what I want I want Acumatica to do… Nothing (just leave Shopify alone). But, on the right, it seems to say that if the product goes to 0, then the checkbox is selected. But, I don’t want that to happen for the rest of my store. I’d like the ability to select that on a product by product basis.   It looks like the field lives at the Stock Item Level in the Ecommerce tab. However, it says “Store Default” and is not editable. Is

Big Commerce is not giving me a new, clean Big Commerce sandbox so I can connect it to the Accumatica 2023 R2 Sandbox and test them in preparation of going live with the Acumatica 2023 R2 upgrade.  I was told as a Big Commerce enterprize customer I will only get one sandbox.  I have a Big Commerce Sandbox from the last time we upgraded our Acumatica.  Big Commerce is saying I do not get a new, clean Sandbox for testing.  And Big Commerce will not “clean out” the existing Sandbox.  I believe I should have a new, clean Big Commerce Sandbox to test the Acumatica 2023 R2 upgrade.  What should I do? 

Hi Team,Do we have any document related to BigCommerce Connector where the default mapping of the fields mentioned between Acumatica and BigCommerce across all the entities. If anyone has this detail can you please share it.For example: Stock Item entity by default:Acumatica Inventory ID field mapped with BigCommerce SKU field.Acumatica Description field mapped with BigCommerce Product Title field. Thank you in advance! 

We do not currently have any Point of Sale system that we use with Acumatica. We do a very limited number of retail counter sales at our business, since most of our revenue is either install/service revenue driven through the service management module or wholesale sales orders. But, for those few counter sales, it’s become an issue for several reasons. We explored Acumatica’s POS (powered by Heuristyc) system, but the quote for the monthly subscription seemed very high for the limited amount we do. Is anyone using a different POS system with Acumatica? The only other one listed in Marketplace is 1Retail. Does anyone have any experience with them? 

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?)