Retail

When an order comes in with both products and gift cards how are you all handling them in the ERP?We have been marking the gift cards as complete before creating shipment (since Shopify sends the digital GC and our shipping department has nothing to scan or send if we don’t), but we are seeing that in doing this the gift card is not being added to the invoice and therefore is not being paid in the ERP.  Also, Acumatica is then only capturing the invoiced amount sans the gift card payment.How should we be doing this so that the correct money is being collected and the ERP is showing the GC sales? 

Anybody familiar with where these numbers are coming from? This is an error on the shipment export. These number is not the inventory CD, Inventory ID, or lot number of the items on the shipment. Some shipments are processing OK, but some are throwing this error. Any ideas?Thanks! 

I will occasionally get this error in the sync history preventing an order from importing into Acumatica. The inventory ID is not missing from the item on Shopify, and exists in Acumatica. See below for the highlighted error. Has anyone else experienced this and know the root cause of the error?  

We are using 22R1 and I am working through setting up Tax Zones and Taxes for GST and HST in Canada. I’m following the https://openuni.acumatica.com/courses/fin/f335-financials-advanced-value-added-taxes/ and this glances over setting up tax zones so that they are specific for a sate of several states.  The example uses canada as a whole, but never specifies how to select the country to match it to the zone.When I try to set up a Zone for say, Ontario, I expected to see the method described in the help whereby I could could select the state(s) associated with the zone, but all I see is a filter on Zip Code: Am I missing a step somewhere or a checkbox that would allow me to specify the country and/or province? Thanks! Patrick 

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?