Retail

Hello,We have two retail stores that are setup as two separate Branches in Acumatica - say Branch1 and Branch2. On Shopify POS each retail store is a separate Sales Channel - say Channel 1 and Channel 2. I have been unable to find a way to map or tell Acumatica that Shopify POS Sales from Channel 1 belong to Branch1 and Channel2 to Branch2. All Shopify POS Sales fall under the same Acumatica Branch. Is there a workaround or a setting I am missing? Thank You

Is there a process that allows us to create a shipment document out of a return to vendor? Once the “return to vendor” process has been completed, our warehouse needs the ability to physically ship the products back to the vendor. We are currently using the ShipEngine integration and therefore would need a Shipment document created so we can create the shipping labels for the return.

Our purchaser often receives new pricing for items and we would like to update the cost of goods before we place a purchase order. I understand that last cost of goods is updated upon the inventory receiving process, but how can we update costs without placing a purchase order?Most of our items are FIFO and I see that “Last Cost” is an editable field. Is that the best way to update costs?Thanks!

Hi Team,I am working with 23R2 (Build 23.209.0023) Shopify connector. I have a custom table and a custom screen. I want to create a new Entity similar to the Stock Item and sync the data from custom table to Shopify as stock items. I tried to create a new graph using SPProductProcessor but getting error while inheriting from this class. Then I used ProductProcessorBase, using which I am able to get the data in Sync History but during sync objects are getting null and further processes are failing.Can anyone suggest the best possible way to achieve it.Thank you in advance !

“New connection to support Shopify’s new payments platform is now available!We encourage you to act now by following these steps.You will need to make all changes by June 28, 2024, to prevent the payment card option at checkout from disappearing.”Shopify App: https://apps.shopify.com/authorize-netAnyone having issues with payment importation? (wrong processing center ID, no 10 digit trans key from auth.net) 

 IssueI am unable to find a field in the ecommerce Sales Order export mapping that indicates that an order has been paid via check on a related invoice. BackgroundWe work with government agencies across the nation, allowing them to pay via Purchase Orders, where we invoice them at Net 30 terms.We have set up a manual payment method on Shopify called 'Purchase Orders.' This method is configured in our e-commerce store settings in Acumatica but is not active. If we activate this manual payment method, orders will be marked as 'Paid' on Shopify, which can mislead some customers into thinking they owe nothing. This also adds a prepayment to the order, causing Acumatica to show all invoices as paid, resulting in no invoices being sent to customers. Consequently, we do not receive payment.To pay these orders, most customers send in a check, which we then apply to invoices in Acumatica. This payment informat

I’m doing the V200-Commerce Edition training.I’ve setup a trial for BigCommerce and have configured the setup as per the guide within the training.When I try to create a BigCommerce store I get the following error:“Index was outside the bounds of the array.”Has anyone come across this issue? Stack Trace:    at PX.Data.PXStringState.get_ValueLabelDic()   at PX.Data.PXView.SortResult(List`1 list, PXSearchColumn[] sorts, Boolean reverseOrder)   at PX.Data.PXView.Select(Object[] currents, Object[] parameters, Object[] searches, String[] sortcolumns, Boolean[] descendings, PXFilterRow[] filters, Int32& startRow, Int32 maximumRows, Int32& totalRows, String[] sortAsImplicitColumns)   at PX.Commerce.Core.BCBindingMaint.<entities>d__4.MoveNext()   at System.Linq

We are using Average Cost on our invoicing. However the issue with this is the service orders only show the costing from when they were created. This means the totals tab calculates the estimated profit and loss from this. Shouldn't this be calculated off the average cost or am I missing something ?

Hi, I have been doing a lot of tests and I realized that when I map the Branch field at Order Level, the value is not changed but when I do it at the detail level, it does:**the 2 lines within the mapping are just an example, I ran the tests with one of them only. Does anybody found the same issue and a solution?  Thanks!  

Hi there, We are using the Shopify Connector for the POS side of things. During our Testing, we synced an Order to Acumatica, then refunded it partially and another example for a full refund.We get the following Error: At least one GraphQL error has occurred. Error: Access denied for exchangeV2s field.; COMMERCE]: At least one GraphQL error has occurred. Error: Access denied for exchangeV2s field.;Connector: SPC, Binding: 2, Entity: OR, SyncID: 24455, LocalID: , ExternID:PX.Commerce.Shopify.API.GraphQL.GraphQLAggregateException: At least one GraphQL error has occurred. Error: Access denied for exchangeV2s field.; Refunds are enabled and we have a Return Amount Item set-up. We are using the Shopify public App for Acumatica. Not sure where to start  

In this topic we will review how we can extend/workaround areas not supported by either Acumatica’s Shopify Connector or Fields not being passed by Shopify APIsIn the use case below. Customer wants to filter the orders that are “on hold” in Shopify. This status is currently not supported with the current connector but will be included in future releases once Acumatica switch to use the new “GraphQL”. For now the workaround was to use Shopify “Flow” to add a tag “ThisOrderIsOnHold” and filter on this tag in Acumatica. Following are the detailed steps1-Create a trigger in Shopify to add the tag “ThisOrderIsOnHold” when fulfillment status is “on hold” When user puts order on hold

Hello,We have two retail stores that are setup as two separate Branches in Acumatica - say Branch1 and Branch2. On Shopify POS each retail store is a separate Sales Channel - say Channel 1 and Channel 2. I have been unable to find a way to map or tell Acumatica that Shopify POS Sales from Channel 1 belong to Branch1 and Channel2 to Branch2. All Shopify POS Sales fall under the same Acumatica Branch. Is there a workaround or a setting I am missing? Thank You

I want to show you a way how can you configure saving of a Credit Card Profile inside Acumatica even if the payment is done on the BigCommerce side.This functionality is possible only if both of the systems have integration with the same Credit Card Processing Center. In my case I will use example of Authorize.NET as this processing center is supported and by Acumatica and by BigCommerce. Step 1: We should configure Authorize.NET plugin at BigCommerce (under Store Setup → Payments) to store credit cards:Please note that it will be up to user to store or not the credit card information with you. Step 2: Now if user places the order, there will be an option to save card for the future usage on the payment settings:

Hi, all orders coming from Shopify POS generate this error: “Object reference not set to an instance of an object.” What do you think I should check?

We are reviewing switching from Big Commerce to Shopify.  We are stuggling with cost effectively customizing our Big Commerce store.  Is Shopify B2B a good solution that can be customized cost effectively? 

Hey all,Error Msg on Sync: At least one GraphQL error has occurred. Error: Input size greater than 250.;I ran into this error originally on build 23.206.0006, now running 23.209.xxxx due to the replies on this thread mentioning a fix was implemented on 23.207.0025.Still running into the same error even on the newest build. I tried deleting the price list on Shopify and running prepare + sync again to no avail. It imports about half of our list and then errors out. It doesn’t appear to be an issue with Companies / Company Locations for us, as mentioned in the other thread above, as there aren’t very many companies associated to this Price List. Well under 250 companies / locations and ~4000 items on the Sales Price List.Please let me know if any other information would be helpful.

We are trying to have multiple guest accounts. Our client wants each guest customer to have an individual account. According to 'Help,' we need to change the limit to 1 because the default is per 10,000 orders.What will be the problem if we do that? Also, while checking the Web.config file, we couldn’t find the MaxOrderPerGuestAccount parameter. How can we change it?Thank you for answering this question.

With 2024 R2, we are adding ability for the users to import payment terms from the order in Shopify to the terms for the imported sales order.The rules for importing payment terms during the order import process, the connector shall: Check if there is a substitution list added to the Payment Terms checkbox in the Order Settings tab of the Shopify Stores (BC201010) form, and if found, match the payment term name from the substitution list to the credit term in ERP.  If no substitution list, check the actual Credit Terms(CS206500) name in Acumatica and if it finds a match the payment term name from Shopify, then use it. If still no match, use the default credit terms from the Customer record. To sync Payment terms from Shopify Order to Acumatica Sales Order using substitution list, the users can follow the steps outlined below: 

Hello Linkies,I have been trying to record the taxes payable and claimable by created SO/AR Invoices & PO/AP Bills, but not able to show it up on the Prepare Tax Reports (TX501000) form nor on the Tax Summary/Details reports. Kindly let me know what I am missing here.  The Tax Periods are also open.Thanks in advance.

Hello team, is there a setting in Acumatica for Shopify POS sales orders so that the orders status is set to completed instead of open? At the moment, all Shopify POS orders are coming in as open and we have to close them manually.

Hello,One of our team accidentally processed a credit card payment on the wrong customer’s order profile. Is it possible for us to remove this payment from the incorrect sales order, and apply it to the correct sales order for the correct customer? Thank youPatrick

Hi there,We are a Canadian company;  We’re using Shopify for our POS and Online store.  We are planning to sell to the US;  Does anyone know what need to set up in term of necessary item’s so that the fields will sync between Acumatica and Shopify?  We have two item’s fields in mind ie. the Commodity Code and Country Code.  It looks like a customization is needed in order for the Connector to sync these fields.We would greatly appreciate any advise of what exactly needs to be done before we can sell to the US.  Thanks...

Hi Team,We configured Shopify store in Acumatica build version - 23.212.0024, while sync the Sales Order, we are facing issue “The Company entity is not active. Activate it in the store settings.” Shared the screenshot for referenceCan you please review and suggest the solution. Thank you in advance!

Hi Team,We setup an instance of 24R1 (build 24.104.0008) and trying to configure Shopify store.But after providing configuration details when we are clicking save button, we are getting an error like: “Index was outside the bounds of the array”. Please find below screenshot for reference.Can you please review and suggest the possible root cause and resolution for the same. Thank you in advance!

We have drop ship products on our Shopify site - if purchased, the order will sync to Acumatica, a drop ship PO will be created, and then a drop ship receipt once the vendor has confirmed the order has shipped.Is there a way natively to mark these orders as fulfilled in Shopify? This happens automatically for orders with product we stock and can ship from our own warehouse; a shipment is created and confirmed and the order is marked as fulfilled in Shopify. However, because the drop ship process uses a receipt instead of a shipment document, and there is no place to enter tracking # information in a receipt, we cannot see a way to mark the order as fulfilled in Shopify.We are currently on 21R1, in the process of upgrading to 23R1; perhaps this has changed in the latest release?