Retail Edition QnA
Recently active
Is there way we can flow the Phone number from ACM to Customer/Company in shopify via custom mapping? Thank you in advance
Has anyone encountered a Shopify order with the SHOP_CASH payment method yet?We received a handful of orders on one of our Shopify Stores where customers have redeemed Shop Cash (Shopify’s points system) to pay for a portion of their order. In the Shopify documentation it states that you cannot opt out of accepting Shop Cash without disabling the Shop App for the store. The Process Data action for the order fails with the following error, indicating that the new Store Payment Method needs to be mapped in the store settings - which is straightforward enough:“The payment could not be imported because the combination of the SHOP_CASH store payment method and the store order payment method is not mapped to an ERP payment method for the USD currency or the mapping is inactive in the store settings.”The big question is, what type of ERP payment method should this be configured to? Can it just be mapped to the same payment method as the primary SHOPIFY_PAYMENTS method, is it a new Payment
Our customer is using the Amazon IntegrationEach order creates a Payment on AcumaticaAmazon sends a deposit to the customers bank that consists of multiple payments less feesFor this customer this deposit can consist of more than 1000 paymentsWhat are best practices to enter these deposits?Does anyone have automation for this?
Hi everyone! I wanted to share some thoughts about the challenges we’ve faced with syncing Template-Matrix items as Product-with-Variants in Shopify. As many of you know, we’ve run into a couple of limitations:Shopify can only support 3 options. There’s a cap of 100 variants per product.The first limitation has already been addressed in a previous discussion here. However, our Template item has 4 options and nearly 4,000 variants, which has been quite a challenge.We’ve tried breaking down the Template items into new ones with 3 options, but we’re still hitting the second limitation with some Template items exceeding 100 variants.The really exciting news is that Shopify has recently announced their new GraphQL product APIs, which now support up to 2,000 variants! 🎉 This is a game changer for us and anyone facing similar issues.I’m curious to know: when can we expect to see this new capability available in the Acumatica-Shopify connector? Any insights would be greatly appreciated!Thanks
Hi I am settling up a connection to BigCommerce and have template items which are syncing with BigCommerce using the connector. I have attached images to my attributes used in the configuration of my matrix item and would like these to sync with the Variant Options in BigCommerce. Does anyone know if this is possible please? Thanks Matt
Using the Amazon integration. Does anyone have a way to automate the batching of deposits from Amazon Payments?
My company is a seed company and often times we wish to discount a specific lot of seed that may have a lower germination rate, but we don’t want to discount ALL of that seed’s inventory. Is there a way to discount just a specific lot of product? Thanks!
Has anyone had success with filtering the BigCommerce Shipment export based on specific line item details from the sales order? The business case is as follows:Customer places an online BigCommerce order for a kit.In Acumatica there is an import scenario that expands the kit onto the sales order and updates a user defined field with the parent kit inventory id. The exploded line items have a non-zero quantity and the price is $0. When the shipment is synchronized back to BC, the sync returns an error because the kit components were not on the original sales order. We would hope to skip over those items and only update the items that were originally on the order. Any thoughts on how to handle this scenario?Thanks in advance!
BigCommerce:eCommerce Admin can choose how the customers should checkout in BigCommerce as shown in the below screenshot. If the customer decide to checkout as guest a customer account will not be created in BigCommerce. So in Acumatica the Sales Order will be imported with Generic Guest Customer provided in the Store Settings as shown below. If a customer decide to checkout with account details, then a customer account will be created in BigCommerce. And in Acumatica while importing this Sales Order, Commerce connector will create a new customer if the email address doesn't exist already and then link this customer to the sales order. Customers are allowed to checkout as guest but BigCommerce will create a customer account as soon as the order is placed and in Acumatica while importing this Sales Order, Commerce connector will create a new customer if the email address doesn't exist already and then link this customer to the sales order. Customers cannot checkout as guest in BigComm
Hello everyone,We are encountering an issue with the Shopify connector for Acumatica24R1 regarding the synchronization of Business Customers (B2B). Both Company and Customer entities are active and both in bi-direction. Here’s the scenario:A business customer categorized as an organization is set up in Acumatica, with several contacts and locations. When this business customer was synced to Shopify, a Company was created using the same name as the business customer in Acumatica. All contacts were synced in Shopify as Customers associated with the newly created Company. The locations were also synced successfully, which looks good. During the next sync (in the aforementioned bi-directional direction), several new records were synced under the Customer entity. Upon reviewing the synced customer records, we discovered that the connector had created new Acumatica Customers, categorized as Individuals—one for each contact of the existing Business Customer (Company). This resulted in the dup
Is there a solution to sending package tracking numbers to customers as a link to USPS or even Google?If I click the link in the email below, it currently will send me to google with the Acumatica field nameThis is the html code I used to create the link...<a href="https://www.google.com/search?q=((Packages.TrackNumber))" style="text-decoration:none;display:inline-block;color:#ffffff;background-color:#034e7d;border-radius:4px;width:auto;border-top:1px solid #034e7d;border-right:1px solid #034e7d;border-bottom:1px solid #034e7d;border-left:1px solid #034e7d;padding-top:5px;padding-bottom:5px;font-family:Arial, Helvetica Neue, Helvetica, sans-serif;text-align:center;mso-border-alt:none;word-break:keep-all;" target="_blank">
This topic provides a workaround to calculate the max possible quantity that can be assembled for a non-stock kit or a stock kit. And uses an import scenario to update an attribute on the non-stock kit for the max availability. Assumptions:1-Create an attribute KITAVAIL and assign to the non-stock kit class 2-There is a condition to filter on the warehouse storing the components used to assemble the kit Hint: The GI pulls stock and non-stock kit. it can be enhanced to only pull non-stock kit. Precaution: The import scenario that I attached is only updating the availability for non-stock kit. it will FAIL on stock kits, you might need to create another import scenario for this purpose. How to use it:1-Import the GI:”Kit Max Availability.xml”2-Create import scenario:IN202000-UpdateKitaAvailability.xml Since the import scenario is based on a GI it is dynamic, you can run it manually or run using a schedule. Screenshot from the import scenario : Commerce connector use: The import scena
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
I am prepping to launch an additional Shopify store and would like to complete some integration testing with other customizations in a recent copy of our production tenant. I just want to be sure that activating a store in the Test Tenant will not count towards our Max Number of Stores of our license, preventing me from enabling in Production at go live. Can anyone confirm this? The test tenant is in the same SaaS instance as our production tenant (not a stand alone sandbox).
Please note,Shopify does not immediately fulfill gift card orders automatically. It is by checkout settings. Even if fulfilled, Acumatica will import these orders. Acumatica will not import only the Archived orders. So with that, what I would suggest you is either you should make Gift Cards not be fulfilled automatically or make the order not to be Archived as soon as it is fulfilled. I would go with the former.Please see the below screenshot for more clarity. It is excerpt from Shopify Checkout settings.
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
We are using the Shopify shipping option for the customer to pickup in our store. However, when the order goes to the warehouse to pick/pack/ship it is confirmed shipped when the order goes to the store to await pickup. This triggers Shopify to notify the customer that their order is on the way. Shopify has a multi-email system set up so you can email the customer that the order is ready for pick up (which is what it is not shipped), but Acumatica can’t send different information to Shopify to specify which email to send, or so I was told during our integration.Is there any way to have Acumatica not trigger the email if a certain shipment option is selected? I would rather no email than a misleading one being sent to these customers. But I don’t want all our other customers not to get their shipping information emails.Or has anyone found a way to send out different emails for different shipping options in Shopify with Acumatica? Even if it is a third party partner app.
In this topic, I want to share how to create a customization to export matrix item cost info to Shopify product variant. This customization can work well on 2023R2.Create a customization project Create a new code file, and extend the Graph from “PX.Commerce.Shopify.SPTemplateItemProcessor”. Select the “OVERRIDE METHOD” from the menu, and then select the Method “SaveBucketExport” from the list. Modify the code as below. Create the new instance of ProductRestDataProvider and InventoryItemRestDataProvider object Use the ProductRestDataProvider instance to get the existing Product/Product variant info from Shopify, cost info doesn’t save in Product variant object, it’s in the InventoryItem object, so we need to get the InventoryItemId from the variant object. We save the variant mapping info(ExternID is Product variant ID, LocalID is the Matrix item NoteID) in BCSyncDetails, so we can find the associated Matrix item by NoteID. All matrix items are saved in Bucket.Product.Local
We are creating ERP shipments in advance of actually shipping merchandise, and do not want the information to synchronize until shippments are confirmed. We defined an export filter to limit the Big Commerce synchronization to only shipments that have been confirmed, however it is not working. When the filter below is active, ALL of the shipments are filtered. Our version is 24.109.0016. We also tried filtering on Status but with similar results. Any thoughts what could be wrong?Thanks in advance!
On Shopify we arrange our variants in a certain order for many conversion related reasons such as cheapest first, what we want featured on collection pages (since it defaults to first variant of a product), most popular color first, putting a item line that’s mostly sold out last, etc. We always understood that Acumatica does not have its own variant priority/sort order, which is true as far as customizable, but we were fine managing that on Shopify side only. We have found however that template sync will rearrange all the variants on the product in Shopify even if there were no changes, if template is pushed, or if something else changed on the template.Things we have tried:1. Unmapping option 1,2,3 in template and stock item export mapping. This stops the variant order from being overwritten, but does not work since it doesn’t support any new variants being added or syncing a new product since it then pushes everything as an empty default with no attributes.2. Manipulating Acumatica’
