Commerce Edition QnA
- 371 Topics
- 1,540 Replies
Hi, I think that batch picking needs to be fixed in the WMS. Below are the issues I ran into while trying to implement this. It would be helpful if everyone else adds their issues. Batch picking by location doesn’t give a quick filter where you can select multiple locations from a list. You can either add it manually, or you could upload an excel sheet, but that takes a minute and is time-consuming The “known limitation” of not being able to batch pick nonstock kits Acumatica doesn’t show you what SH has a non-stocked kit and will add those shipments to the batch Once you run into this issue, there is no real way of fixing it besides removing all items that might be in a kit. Even if you have the same item on a SH not part of a kit Once a picker scans a picking sheet, there is no way to go back. If someone else wants to pick it instead, or if you want to cancel the picking sheet, it won’t let you The lack of system messages regarding the process and what you need to do next. i.e. In
Hello Acumatica Community! Check out the latest joint case studies with BigCommerce & Acumatica:https://www.bigcommerce.com/case-study/van-cafe/ (119% growth in revenue) https://www.bigcommerce.com/case-study/ink-custom-tees/ (186% growth in revenue) Cheers!Colleen Sheacolleen.firstname.lastname@example.org Manager, Strategic Partnerships
Good afternoon Acumatica community! We are hoping to get a question answered about the sync between Shopify and Acumatica for the Payment entity.We have one Shopify store connected. Every Entity other than Payment is syncing as expected. We are using ShopifyPay to process CC payments for orders through our website. At the tier we’re on, ShopifyPay charges 2.6% + $0.30 per order.This information doesn't seem to be imported into Acumatica for us at this point. The payment comes through like this:Image pulled from the Sync History (Commerce module)Image pulled directly from the payment entry generated by the sync We are sure the system is capable of importing the fee information based on the following screen shot from Shopify’s backend. Our VAR advised us to add Shopify’s fee manually later in the process, but this is cumbersome and ultimately not scalable. We are looking for advice about where to add these fees (potentially in the payment methods of Acumatica?) If someone has done this b
When sales orders are pushed into Acumatica and are in a status of Open but the Sales Order has not been approved in Acumatica, the BigCommerce Connector pushes back a status update to the order in BigCommerce and changes the order status to “Manual Verification Required”. Is there a way we can change that mapping and/or ignore that in the connector?
We have released the latest AcuPOS powered by IIG for 2021R1 and 2021R1 IIGPOS User Guide.The latest AcuPOS by IIG build is 105 and User Guide works with the latest Acumatica ERP 2021 R1 build 116. This information can be found Community >Product Downloads > Add-ons and Integrations > Acumatica Point of Sale (POS) powered by IIG
Hi, Acumatica automatically sends the Vendor Ref number on Purchase Receipts to Shopify as the tracking number. Since we’re using the field for what it was actually intended for (Invoice Numbers), can we restrict Acumatica not to send those?
Hello everyone,I create matrix items from a Template Item, with description segment settings uses the Template Item Description together with Attribute value.After creating matrix items, I updated the Template Item Description, hoping that it will auto updates every matrix item description inheriting the changes I made in the Template Item. But it does not.Clicking the Update Matrix Items button doesn’t work also.Is there a way to update the matrix items description from the template description changes without updating each of them?Appreciate your help. :)
Hi all! We are currently on 2023R1 and plan to upgrade to 2023R2 very soon.We have a group of products - safety glasses - that have pricing set by the pair of glasses, but we sell them in box quantity of 12. In the individual stock items and the template items when applicable, the conversion is set with EA as the base unit, BOX as the sales and purchase unit. The EA to BOX conversion is defined. When we export these glasses to the website, the price and product availability are showing up as the Base Unit instead of the Sales Unit, which is not what we want. We would like the export to shopify to use the Sales Unit.I’m providing a few screenshots here to illustrate the relevant details:Stock Item Page - Base/Sales/Purchase Units are defined hereLinked Template Item page - Base/Sales/Purchase Units are defined exactly the same way hereStock Item Price (price differs by lens color so price is defined here, for base UOM)Vendor purchase unit is set to BOXVendor purchase unit is set to BOXW
I need to map the phone number associated with the default address from Shopify to a specific field in the customer record in Acumatica, but I can’t seem to figure out how to specify the phone number associated with the default address, not the phone number associated with one of the other (non-default) addresses, in a formula in the Customer entity.Does anyone have a suggestion regarding how to accomplish this?
Hello Everyone,I have an instance with Build 20.212.0038 and have configured Authorize.Net as processing center and payment method and using to map with BigCommerce Authorize.Net payment method.But as soon as I am selecting Processing Center ID the Release Payments checkbox getting disabled and then the synced payment records are not getting released automatically.Can someone please suggest on how we can configure the settings to Release, synced payments automatically.
We have a customer who uses Shopify and imports those orders to Acumatica, along with the customer’s payment at the time the order is placed.It is possible that an item becomes unavailable and the Sales Orders that have that item on them have to be partially refunded and that SO line canceled.What best practices have you seen to:Processes a partial refund on a prepaid sales order and sends that information back to Shopify. Cancels the SO line for the affected item.This would ideally be done in a bulk process. They could have several hundred sales orders with that item that need to be refunded.Thanks for any help provided!
Hi everyone.We encountered this issue. In the Bigcommerce, If a Customer uses a Credit Card during the checkout process, we have to Override their "Default Payment" method on the sales order. It needs to be overwritten with "AUTH NET." I just conducted a test transaction. The Customer in question has a default payment method of "ACH." But, during the checkout process I used a Credit Card. When the order synced to Acumatica, the Sales Order pulled the default payment method of "ACH." This issue gets even worse when a Customer has a Default Payment Method of "CREDITCARD" in our system. In that scenario a Customer could pay with a credit card during Checkout and then Acumatica will run their card again when the order is invoiced. Double charging the Customer.
Is there a way to export record notes from an SO to BigCommerce?I’m currently working with a user who needs to make timestamped document notes on a Sales Order to update customers on their order statuses.Currently attempting to leverage Export Mapping on the Entities screen, however I am getting an error. Any thoughts/ideas? Thanks!
We have been using the “Fetch” and then “Sync” method in “Commerce / Processes”. Using this approach we were finding that hundred of items would show as “Pending” even after we Fetched and Synced. We were told to change our procedure and first “Fetch” in Processes, and then sync using the “Sync Status” process ( and not the “Sync” in the Processes area). Is this method the prefered way sync? Should we stop using the “Sync” button in the “Commerce / Processes” area?
Is it possible to allocate product to ship from a specific warehouse location based on the customer’s location? For example: ItemA is available in both California Warehouse and New York Warehouse Customer is located in Colorado and orders ItemA Acumatica automatically allocates inventory to ship from California Warehouse
I've set up a connection between my Shopify and Acumatica systems. When a customer placed an order and made a payment, it resulted in the creation of an order (SO.30.10.00) and a prepayment (AR.30.20.00).However, today, the customer decided to cancel the order. Now, when I check the 'Sync History,' I've encountered an error message stating, 'The applied amount cannot exceed the unbilled balance.' What might I have done incorrectly? Why is Acumatica preventing me from syncing this transaction?P/S Acumatica version = 2023 R1Build 23.111.0019
I’m curious if there is any direct documentation about utilizing the commerce connector and various entity settings at different Acumatica structure levels, primarily Tenant vs Company. Most of the existing documentation appears to center around configuring a single BigCommerce or Shopify store to a single tenant but, for example, what are the options/limitations around connecting store 1 to company 1 and store 2 to company 2, within a single tenant?If anyone has explored this configuration or is using it currently, I’d be interested to understand how it’s working for you and any issues encountered.
Hello everyone! We are converting our inventory into a template-matrix item using this customization: https://community.acumatica.com/retail-commerce-113/popular-retail-commerce-customization-packages-6934I am just facing some concern when there are some corrections made in the stock/matrix items in Acumatica that should reflect in BigCommerce.Consider an example of a template with attribute Size (Small, Medium, Large) and Color (Red, Green, Blue). Not all permutations are available. And the item was synced in BigCommerceNow, the business decided to change the color attribute name from Red to Rose, Blue to Navy Blue and Green to Lime Green. It was changed in Acumatica, but the variant details was not reflected in BigCommerce.Maybe one way is to delete the item in BC and resync the item. But that is not desirable especially if we made lots of changes in BC side of product details, and a transaction has already been made. Can you pls help how to fix the issue? Thank you
I am wondering if there is any update regarding the B2B features mentioned in this press release:https://www.acumatica.com/corporate-newsroom/press-releases/acumatica-broadens-strategic-relationship-with-shopify-to-enhance-experiences-for-b2b-buyers/It would be advantageous to maintain customer pricing in Acumatica and see that reflected for wholesales customers on Shopify. Any thoughts on best practices with the current connector?
Synchronizing Payment from Shopify to Acumatica, I got this:“The payment could not be imported because the SO064037 sales order has been fully invoiced. Create the payment manually on the Payments and Applications (AR302000) form and apply it to the invoice.”Yes I agree, we receive this order 2 days ago, and we shipped it and invoiced. customer paid it today. Why Acumatica cannot create Payment? What setting I have to check?
Login to the community
Social LoginLogin with your Acumatica account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.