Retail

We are using sales orders to process sales.  The sales come by Shopify, API (woo commerce) and manual.  Creating sales orders works great!Where we struggle is returns/order changes.  Our most common situation removing an item from the sales order that is not in-stock followed by partial credits.  Currently:Step 1: We go into the sales order and remove the item that is not in-stock.  Then we add a non-stock item to the order for exact same amount.  Create the shipment, ship it and invoice the order.  The reason we add a non-stock item is the order comes in with a payment.  If we don’t close the order for the exact amount the payment remains open with balance.  Step 2: Since it was paid order we credit the customers credit card on Woo Commerce or Shopify.  Then we go into ACU create a return order using the non-stock item with amount of the item removed and any tax.  Then we create a refund payment in ACU,

I am looking to connect with merchants who sell unique/one of a kind items online through eCommerce. We see this use case mostly in merchants dealing with used products or unique items, such as coins, antiques, or similar products. Typically, we see such merchants needing to individually price the products based on their characteristics as such as condition, quality, potency, etc.,If you fall into this category, please let me know. I’d like to discuss how you are currently processing these items using Acumatica.Are you utilizing any customizations?  Additionally, I’d love to learn more about the nature of your business. Looking forward to connecting with you!

Hello,Has anyone experienced syncing historical orders from one e-commerce platform to another? For example, we previously used BigCommerce as our e-commerce platform connected to Acumatica, but we have since switched to Shopify.Now, we want to sync the historical orders from BigCommerce for our customers into Shopify. However, we found that the orders are filtered due to existing External Reference numbers. Clearing this field isn’t a viable solution since most of the orders are already completed. I can process the orders in the Sync History > Filtered tab, but I hope there is a more elegant approach.

Hello, anyone had an issue before when import a REFUND?The tax amount calculated by the external tax provider cannot be applied to the document. An error occurred during processing of the field Applied To Order value 18.41 Incorrect value. The value to be entered must be less than or equal to 18.40.Obviously, the amounts would be different, but the idea is clear I hope: payment (refund) in Shopify is larger than what Acumatica calculates using the Avalara integration.Acumatica used to have this issue with order import, but it was fixed once the Disable Automatic Tax Calculation configuration was added on the Order Types screen. However, the issue with Refunds seems to persists, regardless of the value of that box on the Order Types screen for RC type.

We have a strange situation happening with our Big Commerce Website.  We cannot determine if it is set up / configeration issue or a design flaw in the Acumatica-Big Commerce Connector.  Any help would be greatly appreciated.  We are on 2024 R1.We have set up Acumatica / Big Commerce so that only SKUs that are in stock will show up on our Big Commerce Website. When a SKU drops to zero in stock, the SKU automatically stops showing up on our Big Commerce website as it should.  This works perfectly well.  The isssue is when a SKU is out of stock, and we make the SKU inactive in Acumatica. As soon as we make the SKU “inactive” in Acumatica, the SKU reappears on the Big Commerce website, and the configuation for that inactive SKU in Big Commerce is changed to show on the website even if zero of the SKU is in stock. The act of making a SKU "inactive" in Acumatica causes changes in Big Commerce so the SKU shows up on the website.Is this a configuration issue we

Hello, We have our Shopify store setup to use Available for Shipping. The On Hand amount is 1,423 but it’s in a quality location and cannot be sold. The available for shipping amount is 0. However, in Shopify it’s showing the total amount on hand. Does anyone know what can be done to fix this? Thank you!   

We handle the 10x10 frame and various colored covers separately in Acumatica. When a customer orders a tent, frame and cover is bundled manually and shipped together. (a) I have included all covers in the template item using color as a variable attribute. How can I add the frame to the matrix item?(b) If I want to use the 10x10 frame in a second template item, can this stock item be utilized across different template items?Thank you!

Template items is working just fine on first attempt. How to create color swatches for items with color variants synced to Shopify? Thank you!

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!

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.