Retail Edition QnA
Recently active
We are interested in being able to offer BOPIS to our customers but the connector for BigCommerce does not offer mapping for locations/warehouses. The connector for Shopify does.
Hello,Does anyone able to manage sales categories in Acumatica and sync it to Shopify as product Collection?Thank you
In 21R2 the Retail-Commerce team has added support for selling personalized items on BigCommerce and Shopify then passing the personalization instructions into the Sales Order. This feature was requested by several existing customers and prospects. It was possible to accomplish in the past versions with customizations, but now it is much easier.Here is how it works:On the eCommerce site you must configure the Made to Order item. Within the ERP you must add a field within the Sales Order to accept this information. This requires a customization package. Below we are sharing a template to help you get started. You must use the entities window to map the eCommerce field to the Sales Order field you must use the entities window to map the fieldsMore details about each step are below. Customization Package TemplateAttached here is a template customization package. The template, when installed in 21R2, will add a column to the line items within the Sales Order window. The column header is "
When you have a Shopify store, and you use integrated carriers, Shopify will update an order when the package is out for delivery and then when it’s delivered. In Shopify it will look this:So, apparently, by this time, the order is shipped and completed in Acumatica. But these order delivery updates trigger the Shopify Connector to try to update the order in Acumatica, which returns an error: The status of the {{order number}} order does not allow modifications. Please synchronize records manually.Is there an elegant way to work around this?Thank you, friends!
Version 2023 R2: 23.208.0026Created an Order in Shopify with a Manual Discount Successfully synced the Discounted Order from Shopify into Acumatica Successfully completed the Order/Payment process for the discounted order in AcumaticaNow the next step is the errorIssue a refund in Shopify of the Discounted Order Process the refund Discounted Order into Acumatica Error: The Discounted Refund Order is pulling the full price $ and not the Discounted PriceThe Refund Entity is pulling the full price of the item and not the DiscWhy is the Full Price syncing into Acumatica and NOT the Discounted Price? In the build below under the Retail-Commerce section it mentions that this has been fixed but I’m still running into this errorUpdate 16 Build 23.116.0019 release notes (2024-03-15):Update 16 Release NotesRetail-Commerce AC-294136: A Shopify sales order with line item discounts had been imported with its payment to Acumatica ERP, then was completed in Acumatica ERP and set as Fulfilled in the S
I believe I heard at the last Summit that Shopify is now able to offer multiple units of measure as an option. If so, other than adding the unit of measure conversion on the Stock Items screen is there any other setup that would need to be done in Acumatica?Thanks
Is there a way to prevent SO lines with identical inventory IDs from being combined when creating a PO from them?
In the move from 23R1 to 23R2, it switched from mapping the Cross Reference Alternate Type of Barcode to Alternate Type of GTIN/EAN/UPC/ISBN. See below in the respective documentation for each version: 2023R1 documentation 2023R2 documentation We spent the last few weeks with our VAR testing this “bug” in our 23R2 sandbox and finally figured out that it was actually changed. When we launched on Acumatica in October, we came up with the procedure to add additional barcodes from our vendors into the cross reference as GTIN/UPC/ISBN so we can reference it when we receive the product. But, Shopify only take ONE barcode. So, we’ve built all of our inventory management/labeling procedures around the fact that it would be taking the Alternate Type of Barcode. Now that that’s flipped, we’d need to throw those procedures out the window, do some massive Import Scenario updates to the ~3 cross references on our 80,000 items and retrain our organization. Can someone let me know WHY this change wa
We have Shopify with the BOPIS option in two locations, and we want the inventory to be deducted from the location where the product will be picked up and not from the Default warehouse when an online order is placed. Please can help us to find where can we make this setting in Acumatica?
BigCommerce Integration VideosThis short video shares the most basic example of the integration between BigCommerce and Acumatica.Thorough introduction to the Commerce Edition for our VARs – 20 minutesThis is a thorough introduction of the 2020r1 Commerce Edition specifically for our VARs. I show a demonstration managing product data, Products with Variants, customer specific pricing, placing orders and processing shipments. Additionally I go into more detail about the connector, how it works, how data flow is managed and answer a few questions about pricing, etc. Quick demonstration of the Commerce Edition – 10 minutesThis is a brief demonstration of the Commerce Edition showing the product information flowing from the ERP to BigCommerce, the customer viewing and purchasing a product, the checkout process, the sales order creation from BigCommerce and the shipping status information flowing back to BigCommerce. Technical Deep Dive – 18 minutes Technical Deep Dive into the Connection
Shopify Payments syncing has been working great. However, we had our first backorder on a Shopify Payments order. The authorization from Shopify within Acumatica was captured for the amount of the order minus the backordered items/freight. We received the goods in to ship, but the authorization no longer had a balance even though we did not capture the full amount. Well in Shopify, you can still capture the balance. So we did. However, that second payment is not syncing to Acumatica so we cannot apply that payment to the shopify order/invoice. What are the plans to address this? Back ordering is common in our industry and we want to allow that for web orders. We can try to create a manual payment to mark the order/invoice as paid in Acumatica. But, that is not a real solution. Thoughts?
Have been getting the above error whenever I try to sync the prices to be exported to Customer Groups from Acumatica to BigCommerce.
Recently Shopify released a new app for selling Bundles on Shopify eCommerce sites. Multiple customers have reached out with questions about if this feature will work with Acumatica’s native integration.The quick answer is “Yes!” - and it’s pretty easy to configure and leads to great results.Below is an introduction to the solution as well as steps for configuring your Shopify site to sell bundles, then automatically importing those orders into Acumatica for easy picking and packing.Use CaseA merchant sells 3 individual items on their Shopify site They found that their customers typically buy 2 of the 3 items at the same time. They decide that if they sold all three of the items together into a bundle with a discounted price this may lead to more revenue and higher customer satisfaction. The merchant does not want a unique SKU that represents the bundle. Instead, they only want to maintain the individual item SKUs. Plus, they need to be sure that the bundles inventory is based on the q
We have just come across this issue having been using Acumatica with Bigcommerce for a couple of years. We have a promotion for an item XYZ which means a discount is applied when ordering 12 or over. We have also added a promotion for that same item when bought with another item ABC where it will be discounted by 2%. In BigCommerce this results in 11 items at the reduced price from the dozens discount with 1 item at a further reduced price from the ‘buy with item ABC’ discount. This is fine and as expected. Our BigCommerce store in Acumatica is set up to show discounts at the document level.The problem is that when the item syncs to Acumatica it results in multiple lines for item XYZ. One for the first 11 and another for a single item. These show the same price (the reduced dozens discount price) for both lines as the discount is being shown at the document level.I would expect as the discount is being applied at the document level these would be combined. This is causing extra wor
We currently have the Shopify Connector setup and want to start using the Shopify POS. I don’t see the Shopify and Shopify POS Connector option or Custom Connectors option in our production environment, just the Shopify Connector option. We have the Distribution Edition and added Shopify. We don’t have the Commerce Edition, I’m wondering if that is why, or is it just a completely different license and it’ll be added after we get a difference license that includes the POS Connector?
We’re trying to set up the Outlook Extension for Accounts Payable bills. Has anyone run into this issue where it doesn’t work for shared folders? I guess the extension needs to be engineered to accommodate shared folders. Is there another extension out there that accommodates that?
Hi Team,We are working with Build 23.112.0032 and working on a customization where we have to add an image url ( https://xyz.s3.amazonaws.com/kkltQWuXULPcHQ6TmoMsZkiJOK93x8.png) as File attachment to a Sales Order record through code. We tried to insert this image url under Name field in UploadFile table and later to map this record along with Sales Order NoteID under NoteDoc table but we are facing issue with approach. Can you please suggest the best possible way to achieve this. Thank you in advance!
Acumatica allows us to create Unit Of Measure Conversions, which is extremely helpful. It allows clients to sell the same item as an ‘each’ or a ‘case’ and counts it as 1 item which can be differentiated in the cross reference as 2 separate barcodes. So the warehouse can scan either the barcode on the individual item (the ‘each’) or the barcode on the case of 4 (the ‘case’). In Shopify & BigCommerce you are not able to create Unit of Measure conversions. You are required to create a variant for the each and the case instead. With this in mind how can these 2 differences still work with the commerce connector? It appears to me like I may be forced to have my client create 2 separate stock items in Acumatica, then create a Template item, plus new attributes, then add them to the Item Class, then add these 2 items to the Template item, as well as require them to maintain 2 separate inventories for the same 1 item moving forward just so they can sell it as an ‘each’ or a ‘case.’ I hope
