Retail

Hello everyone,In the documentation, there is mentioned External ID for Customer Locations, and I assume it will also be populated when we synced a Customer location originally from Acumatica, in a bidrectional sync. But I can’t see such External Id on the Customer Location screen. We want to find a common ID between Shopify and Acumatica for Customer location, and this location is for Customer Organization (B2B) synced as Shopify Company.Do you have idea how to achieve that, if the External ID in location screen is not yet available?We are in 24R1.​​​​​​​

Hi,Was wondering if there is any documentation, or how others are handling BOPIS functionality with Shopify. Specifically with regards to marking order as ready to pickup, and then once the order is picked up. And how that syncs between Acumatica / Shopify (screenshot of shopify example below). Few specific questions:Are people handling this in shopify or Acumatica, and how does it syncIf you “pick” an order in Acumatica, can you sync to shopify to say this order is ready for pickup if you mark the order as shipped in Acumatica, does it then “mark as picked up” in ShopifyThanks in advance.Mitchell

Is anyone having success exporting sales orders and/or invoices to Shopify? We can export Acumatica sales orders to Shopify, but the problem is that it creates a new Shopify order for processing. Our goal is to give customers visibility to their Acumatica sales orders and invoices in their Shopify account.  

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 m

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 

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!

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.

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 im

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

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 partn

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

Be default, commerce connector merges customers from external systems using the same email address. i.e. when you have two or more customers from one or more stores irrespective of the connectors(Shopify, BigCommerce etc.,) imported into Acumatica, the connector creates one customer record for all.But because of some business scenarios if this is required to not to be merged and create separate customer records, then this could be done using the attached customization. Once the customization is published, you see a new checkbox called “Merge Duplicate” in Entities(BC202000) form. If checked for the stores for the customer entity, then customer records from different stores would be merged and you would have one customer per email ID. If checked for few stores and not for all, then checked stores will create a separate customer records but unchecked stores will share a common customer record.  

Hey folks,Question when going-live and transitioning to Acumatica.  I was testing a few scenarios where I have Shopify orders that are fulfilled/pending payment (not archived).  These orders will be associated to a legacy system order that was already shipped and invoiced.   On conversion we will bring over inventory/qoh and our GL balances, including any open AR.In my test I found the following:    It looks like it bring this order over with an open qty that needs to be fulfilled, the SO In ‘open’ status.  Since our beginning inventory and AR will already account for this, what is the protocol here to make sure we do not relieve inventory of another product (since it has already shipped in legacy). When the payment is received in Shopify it will close and ARCHIVE the order, however it does seem to still bring the payment in, but it brings it in as a prepayment (is this because the SO hasn’t ‘shipped’ in ACU?). 

Our Acumatica instance is 23 R1 build 120 and I am trying to override the default URL for Shopify Products using the Custom URL field in the Ecommerce tab on stock items.  When I make changes to this field, the prepare data screen picks them up but after I process data, the product’s URL handle under search engine listing remains unchanged.  Is there something additional that has to be done to make this work?  I don’t think I’m misunderstanding the purpose of this field, given that if I try to include /products/ in the front of the Custom URL value, the system automatically removes /products and leaves a leading slash followed by my custom value.

When we refund Sales tax or a Freight only (no products) in Shopify it creates an RC Sales order and put those refunds in the appropriate places, freight or sales tax.  However with no line items the Sales Order cannot create an Invoice.  If a CM Order type is used, it does activate the Create Invoice button, but then gives the error that no AR Transactions were found in the system.  However this isn’t exactly true because it will should create ARTran lines for Freight and Sales Tax Payables.Current work around is to add a line with a quantity of 1 and 0 Price.  I can create a business event to do this as well, but it’d be nice if it can be handled by the ECommerce connector instead. What other work arounds or fixes do you have?

Hi,  How do I map Ship Via to the correct carrier in Shopify, i.e. I ship something with Estes trucking, I want Shopify to recognize the carrier. 

Are there any retail store operators out there that have a good process for receiving that relies on vendor UPCs to match products on a PO against your Stock Items? Our receiving team struggle to know which product is which amongst our large truck deliveries and they need a screen in Acumatica to be able to scan the vendor’s UPC/barcode and pull up the Stock Item in Acumatica. The standard Stock Item screen doesn’t seem to search through the Cross Reference. Is there a way to change that search function or is there another screen where we can do a quick check?

We are investigating building connectors to Commerce marketplaces.I’d like partners/customers/partners to share with me how they’d rank the following marketplaces in order of priority (#1 highest) and comment on any others that I’m missing.Partners - If you can tell me how many prospects/customers are requesting the marketplaces that will be a bonus. Thank you.Marketplaces and AggregatorsAmazon.com Amazon Business Amazon Vendor Central eBay Walmart Google Shopping Target WayFair NewEgg Overstock Home Depot Channel Advisor Feedonomics SellerCloud 

Team,Just wanted to share some insights on the “Earliest Order Date” that is available in almost of the Connectors from Acumatica. This configuration tells the Connector, the date from which the orders should be brought into Acumatica from the external system and vice versa. Introduction of this configuration helps to define the cutoff date when your Connector goes live. When Acumatica goes through upgrade / any system restarts, it suggested this date is reset to the current date, so Connector does not go and get the old orders once again into Acumatica. This is a point that should be added in your go live checklist for Acumatica upgrades.  By ensuring this date is set correctly before upgrade live, you can avoid lots of old order data hitting your Acumatica and causing sync