Retail

We’re using Shopify with AvaTax both in Acumatica and on Shopify.The sales orders come in fine with the correct tax and the correct state on the tax tab (i.e. if shipping to NJ, it will calculate NJ). However when it get’s to the invoice it recalculates the tax based on our warehouse (SC)

I’m looking for a fully mobile label printing solution. I’m looking at the zebra zq500 series. It says it is compatible with iOS apps, but would like to confirm that I would be able to print from Acumatica’s iPhone app to one of those printers. If not, could we use a Zebra mobile device to send the print jobs from there?

Hello,I wanted to share this setting since it took me a while to find it and searching the forums did not help.With Ecommerce some marketplaces like Home Depot and Lowes will use the same customer order number. Normally having the Sales Order not allow duplicates is the correct setting but if enabled you will get orders that will not import since the Customer Order Nbr is the same.Here is the screen name you need to navigate to change the setting.Order Types (SO201000) > Choose SO as Order Type > Order Settings.  

Hello,We have just upgraded from 2019R2 to 2023R1. In 2019R2 I was previously able to change the template ID of an existing and assigned stock item if I had the “Edit Template ID” checkbox enabled in the item class. Today I went to do that and the Template ID is greyed out and unable to be edited. Is this a bug or new behavior? Is there anyway around this without making a customization to reenable this field?Thanks you in advance. 

Since we integrated Shopify and Acumatica we have been having an issue with the vendor name not going up to Shopify for all products. It works with the stock items but does not send anything up for template items (just sends our company up for template items).We are upgrading to 23.1 and hoping that may fix the issue but in using the two for the past few months, I have come to realize that some of the vendor information in the ERP will never be accurate if passed to Shopify. Different company name on the books in the ERP than the brand name on the product.So it would be best if that would be something I can just manually enter into Shopify instead of letting Acumatica send it at all. Does anyone know if this is possible? I guess I am asking to unmap the vendor.

I can sync stock items to Shopify; however, it always creates a new item instead of updating an item that already exists. I have tried using the SKU and/or description/title but I cannot update a product origionally created in Shopify. The integration will only update products created from the sync. Any ideas?

Hi everyone,I created a template item with two variants that will create two option sets in the BigCommerce. My goal is to make the “Choose Your Golf Cart” as the first option set before the “Choose Your seat color”.  Is there a proper way I can make it in the process of creating the template item in Acumatica?  

We use an address validation tool in BigCommerce to validate addresses prior to them being imported through the BC Compactor into Acumatica. Recently we started receiving errors like the following: The AU country does not have a state with the name 'VI'. Make sure that you have specified the state according to the 3166-1 alpha-2 standard. We have set up the two-character codes for state, in this case “VI” for Victoria, Australia in the Countries/States screen in the entry for Australia. Yet we still get the error. We only recently implemented this address validation tool. Prior to that we did not validate and accepted three-character states for AU. Any thoughts on what we can do to get these orders through the connector? ThanksPatrick

Hello Community,I was wondering if Acumatica supported Merchandise Planning. If yes, please guide me through steps. Else how can we achieve this in our Acumatica system.Thanks in advance. 

We have a customer who uses Shopify and imports those orders to Acumatica, along with the customer’s payment at the time the order is placed.It is possible that an item becomes unavailable and the Sales Orders that have that item on them have to be partially refunded and that SO line canceled.What best practices have you seen to:Processes a partial refund on a prepaid sales order and sends that information back to Shopify. Cancels the SO line for the affected item.This would ideally be done in a bulk process. They could have several hundred sales orders with that item that need to be refunded.Thanks for any help provided!

We’re implementing Acumatica and I just learned that it’s not possible to fulfill orders in Shopify and have that information sync back with Acumatica which is very disappointing. Does anyone do that today? Maybe through a customization or how else could it be handled? Or, maybe am I forced to change our process so we do the fulfillment step in Acumatica? We do our own local delivery through a Shopify app which makes it easier for us to do in Shopify. 

Anyone know if it’s possible to set the variant Inventory Policy in Shopify based on the Item Status of the stock item in Acumatica? I’ve played around with the Export Mapping under the Stock Item entity but I can’t seem to get it to work. The Inventory Policy is a checkbox in Shopify so I tried the below formula but it had no affect in Shopify:  

Hello all,Currently I would like to stop Shopify orders that are on hold from importing into Acumatica right away.I figured I could use the “import filtering” on the Sales order entity, however the only valid values are numbers (they might correspond to an ID for something, but I have no proof for that) and I cannot find where these are defined anywhere.Does anyone know what the numbers correspond to? Or if this is changed in a newer version?If anyone knows any other way where I can stop orders on hold from coming in until they are off hold I would appreciate that as well.Thanks.

Hey everyone, we have a client that’s trying to sync orders from Shopify to Acumatica but they’re shipping orders through Shipstation. Unfortunately, Shipstation is picking up these digital items as physical items from Acumatica but not from Shopify? Is there some sort of work around? Given the fact that we cannot alter shipstation’s mapping, is there anything else we can do?

Use case:Our client is using the Shopify commerce connector. They have the Amazon connector for Shopify which imports Amazon orders into Shopify which are in turn imported into Acumatica. The system works very well. Recently they started doing Amazon FBA and need to impport fulfilled orders as well. Issue:The problem is that those orders are brought into Shopify as fulfilled, so they are not imported to Acumatica. Is there a way to modify the Fulfilled import filter to allow orders to the AMAZON FBA client to be imported?

We’re getting this error when trying to sync PO Receipt (drop shipment) from Acumatica to Shopify.Acumatica version is 22.114.0029.Any ideas, @KarthikGajendran ?

Hi All,We are working with 20.222.0017 build and trying to implement a customization to export multiple order types from Acumatica to BigC. In this build version we do not have the feasibility to export multiple order types from Acumatica to BigC. We did some modification and able to perform Prepare Data which brings the orders from more than one order types on Sync History but these records result in an error as: "The 900023 order has been skipped because the PX.Api.ContractBased.Models.StringValue order type is not supported." with “Invalid” status. But the order type that is configured in “Order Type for Import” field those orders are coming with “Prepared” status and we are able to sync such orders from Acumatica to BigC. Can you please review the attached sample code and suggest the best possible way to achieve it. Thanks!

When going in to make a payment on an invoice that has a prepayment, the system autofills the payment amount to be the total invoice amount instead of the balance due on the invoice.  Is there a setting to adjust for this? 

We’ve added some side panels to the Sales Order entry form screen using simple customizations based on the instructions found here.However, we can’t figure out how to modify the order in which the elements appear on the side panel. (i.e. SidePanelA appears 1st at the top, SidePanelB appears 2nd just under SidePanelA, etc.)Anyone know how to make changes to this?

Is there a way to add HxWxD as fields for items? I was thinking using attributes.Does this area feed SEO for BigCommerce PIM data?

Hi All, Acumatica BigCommerce and Shopify connectors (as well as others connectors build on the Commerce frameworks) have ability to collect verbose diagnostic logs. By default, the logging functionality is switched off to keep performance up, but on the development instances it can be enabled. You have 2 ways - logs in files and request profiler. File LoggingLogging is based on the Serilog, so it has to be enabled vin the web.config file with the following appSettings instructions.<appSettings>.............. <add key="serilog:minimum-level" value="Verbose" /> <add key="serilog:using:File" value="Serilog.Sinks.File" /> <add key="serilog:write-to:File.path" value="[ACUMATICA SITE PATH]\Site\App_Data\main-.clef" /> <add key="serilog:write-to:File.rollingInterval" value="Day"/> <add key="serilog:write-to:File.formatter" value="Serilog.Formatting.Compact.CompactJsonFormatter, Serilog.Formatting.Compact" /> <add key="serilog:write-to:File.shared" value

Hi Team, What is the best way you all have come up with to set up leasing in Acumatica? 

When I applying the invoice to debit adj it showing the following error. Error: Inserting  'AP Address' record raised at least one error. Please review the errors. Error: 'Country' cannot be empty.I checked the vendor has set up the country and the transaction  remittance has the country. Not sure what else has been missing.transaction error message transaction remittanceThank you.  

From time to time our shipper get the following message.“Transaction (Process ID 78) was deadlocked on lock recourses with another process and has been chosen as the deadlock victim. Rerun the transaction.”When we retry the step the process generally completes. Does anyone have any idea what causes this error,It appears that it may be related to the specific order being accessed by two users at the same time. But we are not sure and are looking for some insite.Thank you!

We have the Retail Commerce Edition.  Does the Retail Commerce Edition contain all of the features of the Distribution Edition?  If not, what general feature of the Distribution Edition are not contained in the Retail Commerce Edition?