Commerce Edition QnA
- 370 Topics
- 1,540 Replies
Today in Acumatica, when Sales Orders are processed into Shipments, the system will by default process based on a limited set of available filters at the Sales Order document level. This method involves the assignment of inventory (SKU’s) generally based on the date ordered. SKU’s that are not available may be back ordered and processed into a separate shipment at a later date. This method appears to assume that all SKU’s on any given order are available or will be available in the short term to fill all open orders. It also appears to assume that companies who wish to capture payment prior to shipment would process the payment on the Sales Order regardless of which items may have been shipped or back ordered. Example scenarios where the current process may fall short.Companies engaged in B2B and B2C sales where priority may be given to one customer type over the other based on a variety of variables. Companies selling limited availability items which need to be distributed across the
How to sync Sales Order User Defined Fields at the time of Order Import from BigCommerce to Acumatica
Hi Team,We have a requirement where we want so sync some BigCommerce order details to Acumatica Sales Order User Defined Fields at the time or order import.Can someone suggest the possible way to achieve this. Thank you in advance !
Acumatica 2020 R1, Build 20.101.0032, Screen ID: PO301000 Is there a way to have the Promised On field located within Purchase Order screen default as blank? It currently defaults to the date that the Purchase Order is created. Using Automation Steps, we can change the date that shows in that field immediately after creating a new Purchase Order, but as soon as a Vendor is selected it reverts back to the current date. We do not have any lead times set for our Items - so I’m not sure if that is partially causing this issue.
Hi There,Is it possible to make it so you can edit fields directly on the generic inquiry screen?For example, I created Attributes for amazon prices and asins, and it would be convenient to be able to edit them on one screen / on the fly for all the products instead of having to go into each item or doing a data import. Would like to create something like the sales prices screen where you can edit all the prices in one spot. Thanks in advance for the help.
Hello,We are trying to understand the how the refund integration works in Shopify and why we are getting “voided payments” created instead of “customer refunds.”Our Shopify website is setup to capture payments at the sale. When we go to refund an order, we start the process through Shopify and hit the refund button (picture attached) and then we let the integration build the refund. Instead of creating a “customer refund” (which we think we want), the integration has been creating voided payments. What is the logic for how this integration is supposed to work and is there something we can do to have the integration create customer refunds instead?
What is Gift Certificate and Gift Certificate Payment and how it is handled in eCommerce and Acumatica ERP?
Gift Certificate/Gift Card: It is a non taxable non stock item which is associated with a unique code every time the customer buys it. This is maintained at the eCommerce site. User FlowCustomer buys the Gift Certificates in eCommerce site for $100.00 and also a Acer Laptop. eCommerce site assigns a unique code to each Gift Certificate. Eg: “16R-K2A-18X-5YL” Gift Certificates/Gift Cards are imported using a Generic Non Stock Item that is provided in the Commerce Connector Store Settings form under the Order Settings tab. Sales Order with the Gift Certificate as a item. Please see the below screenshots. Numbered referencing the above points. Gift Certificate/ Gift Card Payment: Once a Gift Certificate is bought by a customer, then the customer can use it to buy products on the eCommerce site as it is created like a Credit Card. The eCommerce site will validate the Gift Certificate unique code when the order is paid using the Gift Certificate. User FlowCustomer places the order usin
To ensure the sustainability and reliability, Acumatica announce the change of Shopify API update plan.From now to keep ecosystem healthy Acumatica will adopt Shopify connector with latest stable Shopify API version semiannually.To support the changes in the Shopify API versions, the following changes were added: Helpful links:Shopify API version support by connector Supported by Shopify Shopify Release Notes Acumatica changes affected versions Changes in connector 2023-07 yes https://shopify.dev/docs/api/release-notes/2023-07 2022R1 Update 24 or later 2022R2 Update 17 or later 2023R1 Update 10 or later 2023R2 Update 2 or later New property have been added to OrderDiscountAllocation discount_class New property have been added to OrderData po_number 2023-04 yes https://shopify.dev/docs/api/release-notes/2023-04 2022R1 Update 22 to 2022R1 Update 23 2022R2 Update 15 to 2022R2 Update 16 2023R1 Update 6 to 2023R1 Update 9
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
How guest customer sales orders from eCommerce site like BigCommerce and Shopify are handled in Acumatica?
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! I’m having an issue with the sync between my BigCommerce store and my Acumatica Sandbox environment. I have a customer that will not sync to Bigcommerce. Previously it had been syncing to our Bigcommerce stores, but I believe that at one point the account on the Bigcommerce side had been deleted. Now, when I go to process data (or sync from sync history), the sync runs indefinitely. It does not throw an error, it just keeps going with no result. I’ve tried re-creating the customer in BigCommerce and changing the external ID on the sync to match the new one. That did not clear up the issue. Any ideas?
Hello, a few of our client have the same issue: when exporting shipment information from Acumatica to BigCommerce, the export fails, when there are 2 or more packages on the shipment, and no items are assigned to each box:The error on the export would be: The [shipment number] shipment could not be exported because the [tracking number] box has no items. Please delete this box or assign an item to it.Can we have Acumatica disregard any and all tracking numbers, UNLESS it’s the only tracking number (1 package on a shipment) or the package has items assigned?Thank you!
Our implementation is such that all customers will be generated in Acumatica and pushed to BC prior to the customer logging into the BC storefront. Is it possible to push the CustomerID to BC into a customer user field? I looked into the articleHowever, it doesnt seem to allow CustomerID to be a source - nor does it seem to allow custom fields on the BC Customer object.We have some supplemental API inquiries that BC is going to do which require the CustomerID and it would be best if it were already there. Relying on the email address as a unique key when it isnt required to be unique in Acumatica doesnt seem like the right way to go.Any thoughts?
Hi ,Requirement: map the fields from acumatica to Big Commerce in Entities screen. In the above screenshot I changed “source field” values. I want to get details from Export mapping tab .where will I get this information and where can I write the code for this.
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.
I'm working to upgrade from 2019R1 to 2021R2.Credit card processing is quite different in 21R2 than I'm familiar with. I need some direction for how to process Sales Orders with Credit Cards using the REST API in 21R2.I'm currently using the REST API to insert Sales Orders with a credit card payment (authorized only, not captured) using the SalesOrder endpoint. As part of the API call to the SalesOrder endpoint, I only have to provide the PaymentMethod and external PreAuthorizationNbr. This corresponds to a tab in the SO called "Payment Settings". It works great, but no longer exists in 21R2. I understand that I now need to use the Sales Order -> Payments tab, but it's not clear to me how to associate the external pre-authorization with the Payment and Application using the REST API.Can anyone point me to documentation or examples or using the REST API to insert Sales Orders with pre-authorized (or even captured) credit card transactions.Should I use the REST API to build a Payment
Shopify Connector : Action Required - Migrate your custom app to the Fulfillment Orders API by March 31, 2023
Our client has received the following email from Shopify.. The customer is preparing to upgrade to 22R2 build 202 right now. Any impacts of these that we need to be aware of or execute. Action Required - Migrate your custom app to the Fulfillment Orders API by March 31, 2023Your custom app is leveraging the deprecated Fulfillment API. Please note that the Fulfillment API will stop working as intended on March 31st, 2023 in favor of our new Fulfillment Order API. Read our migration guide and take action as soon as possible to avoid breaking changes.The following app(s) you are using currently use Fulfillments API and should be moved to Fulfillment Orders before March 31st, 2023:
AcuPOS - Latest 21R2 & 22R1 Builds, Help Section, User Guide, and Release Notes are available - July 2022
Hello Acumatica Community,We have released the latest AcuPOS powered by IIG for 2021R2 & 2022R1 2021R2 Build 207R06 - Build, Help Section, User Guide, & Release Notes 2022R1 Build 106R01 - Build, Help Section, User Guide & Release NotesThis information can be found Community >Product Downloads > Add-ons and Integrations > Acumatica Point of Sale (POS) powered by IIG
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.