Retail Edition QnA
Hello, On the Sync History screen, I’ve noticed I can search for an individual order or group of orders if I know the External ID or External Description and it loads very fast with no issues. I’m trying to search for a group of transactions from our Shopify store, but group them by their ERP ID.If I search for something by ERP ID, it times out every single time with the error “Request Entity is too large”. I try filtering by Last Attempt date down to just one day, only the Sales Order Entity, only Processed or Ready to Process Status, and still times out. Is there any other way to search for a sync history transaction if I only know the ERP ID and not the external? Thanks in advance!
Trying to sync Sales Orders coming from Shopify and it has that error.I also tried for Customers created from Shopify.
Hey Everyone, I have a unique situation I’ve never come across before. I have a client using the Shopify connector. In their Shopify store they sell the same product with the same SKU as a stand alone product as well as selling it as a part of up to 4 matrixed items. Acumatica only allows us to assign 1 Template item per product, however I need the ability to assign multiple template items to 1 stock item. Ideally I would also need the ability to sync the individual stock item by itself.The primary reason we need the ability to do this is to allow us to sync product availability to the stand alone product in shopify as well as the sock item that is a part of the template items in order for Shopify to have correct product availability for all the iterations that this 1 stock item is sold as in Shopify.I’m hoping someone else may have come across this and might have a workaround or solution. I created a case with Acumatica and they suggested a customization might be the only solution. An
Hi Acumatica folks,I just want to ask if anybody noticed too the order Description in Acumatica that is created from BigCommerce and synced to Acumatica.As shown in the screenshot, the Description contains the name of the store, the BigCommerce Order ID, and the status of the order in BigCommerce. Sometimes it say Awaiting Payment, sometimes it says Awaiting Fulfillment.Just wondering why despite orders being processed in Acumatica (created and confirmed shipment and creates and pay invoice), the status in the Description keeps saying Awaiting Fulfillment/Payment. Sometimes, it confuses us.Do you see that as a concern as well? If yes, what have you done to update the Description with the actual status? Or alternative way to avoid the confusion?Best regards
Hi Guys,I need help to sync Line Item properties to Acumatica. Shopify apparently stores the variant options in and array format. Default connector only syncs the 1st option from line item properties but it could have up to 10+ options in that field.Is there a way we can create a loop to loop through the array and show all the options in Acumatica? Thanks for your help.
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
We have been testing the BigCommerce B2B customization on Acumatica 23R1 ahead of launching our BigC store, and we have seen a lot of issues with it. I was wondering if others have run into these problems and have a way of dealing with it or even just a better way of thinking about these problems so that we can live with them.We find it confusing that the main contact rather than the primary contact (except for the primary contact name) is used as the first admin info in BigC and don’t know how to treat the primary contact in Acumatica to make this less confusing. We also find it confusing that the 2nd rather than the 1st main contact phone number is synced to BigC. We don’t know how to handle the possibility of a customer deleting the first admin in their company in BigCommerce B2B since that is how the connector is connecting the customer in Acumatica to the company in BigC. We have noticed many, many issues with modifying existing customer data in either Acumatica or BigC. The data
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.
Hi All,The Commerce Retail team has recently prepared a technical guide about import of Refunds supported by the Acumatica Shopify connector in version 2023r2. This guide covers the most common refunds scenarios for Shopify orders with cash or credit card payments. We believe that this document will help to improve users’ knowledge of the refund import process and what results they can expect.If there are any other frequent scenarios of refunds applicable for Shopify orders, please let us know in replays for this post. Thanks
IntroductionShopify provides Restock item option(as shown in the screenshot 1) when Refund is performed. When this is checked, it means that the returned items goes back to inventory.By default, the Restock item option is checked by Shopify. In some scenarios, the seller advises the buyer to keep the product or discard and not ship back the product because those are not resellable, return cost is higher etc.,In those cases, buyer would like to uncheck the Restock item option when refunding so that the item does not go inventory. ScenariosScenario Recommendation Buyer wants the seller to ship back the item that is returned. Check Restock item option Buyer while processing the refund, not sure what to do with Restock item option. Check Restock item option Buyer cannot resell the returned item so do not want the item to be shipped back. Check Restock item option and put this item in the garbage location in Acumatica based on the reason code for accounting purpose. The corre
Hello - we recently implemented the Ecommerce edition to our existing distribution edition to connect with our Shopify store. We do not have any 3rd party integrations for calculating tax in Acumatica as most of our business runs B2B, so we manually set up Tax ID’s and zones and apply them whenever necessary.One area that we do have to charge taxes in via web sales. For most states, we are only dealing with a single flat rate per state. However, there are a few states, like California, where you are charging State + County + Local in some cases.Shopify handles this as 3 distinct API calls, as opposed to a single calculation of tax and a pass to Acumatica.I’ve tried to do some mapping to change all the incoming tax rate names from Shopify to match up with my associated rates in Acumatica, but with this being 3 calls in the example above, it seems like Acumatica wants to add 3 rows with the same Tax ID name, which it obviously can’t do/will error.I know you can build out more robust
In continuation with the below article, the current article explains how the same can be done in 23R1 and the difference between 22R2 and 23R1. Like in 22R2, in 23R1 there are out of box import scenarios for Template Item(Import Template Items), Matrix Item (Import 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 Is a Kit checkbox is enabled in the Matrix Item which allows the Matrix Item to be created as a Product Kit. Check All the above is done out of the box. Now to make the Template ID field editable in the Matrix item screen, the user has to publish the attached customization(“ImportMatrixItems2023R100.zip”) to this article. This customization package must be used only with 2023R1 and above. There is a customization package for users who do not have commerce module as well. Check the attachment: “ERPImportMatrixItems2023R1002.zip” For 22R2, check If the selected Templ
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 information is not exported to Shopify, so even after the order is paid, it still shows as 'Pa
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.Enumerable.<OfTypeIterator>d__95`1.MoveNext() at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source) at _CustomMethod(Object , Objec
Hi All, I just want to ask regarding how to restrict the visibility of all sales order records and only show my sales order records? Please refer to the screenshot below. Regards,Nadia
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 ?
Does anyone know if it is possible to sync related items under a product in Acumatica to a single, list-type metafield?Example:Product A has Products B and C selected as Related items in Acumatica. Product B and Product C are synced together to a single list metafield as “Product B, Product C” (or something along those lines). Later, Product C is removed as a related item in Acumatica and replaced by Product D. Now, Product B and Product D are synced together to the single list metafield.
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!
Use Case: Users would like to sell in Commerce sites the same product in different UOMs than the default Sales UOM in Acumatica. Example, merchant could sell apples in Kilogram(KG) and also in Pounds(LBS). In Acumatica, the user could have the Sales UOM as LBS but sells in Commerce site as KG. Most of the sites do not support UOM. Both Shopify and BigCommerce does not support it. Solution: Provide the SKU code of the product in Commerce site in the Cross-Reference tab in the Alternate ID field with the required UOM in the Stock/Non-Stock forms in Acumatica. Commerce Connector, will get the SKU code from the Commerce site’s sales order product and checks in Acumatica if there is a matching Inventory ID, if it finds, then it will be used with this UOM in Acumatica SO Line. If not, connector will check the Alternate ID from the Cross-Reference tab with Alternate Type as Global. If it matches, then the UOM will be taken from the cross reference tab for the SO Line. Please see below screens
Hello folks,Wanted to see if this was remotely possible. But i have an import mapping setup that work in the following manner on the SALES ORDER entity in Commerce Connector: As you can see this will look for the “MISC” tag and if it exists it will map the customerID to my “ECOMGUEST” customer. If FALSE, it maps to the C0000011 customer. What I would LIKE to occur is that on the FALSE result of the IIF statement that it reverts to actually using the native connectors logic to either use the existing shopify customer or create a new one. Possible?
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 holdThis will result into adding the tag once the “Hold fulfillment” action happens 2-Create a filter in Acumatica to filter orders having this tag 3-Create another trigger to remove the tag from the Shopify Order once the hold status is released This will cause the order to flow back to Acumatica-------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
