Commerce Edition QnA
- 249 Topics
- 912 Replies
This is the Example ERROR: Export of the Stock Item record cannot be completed. The Stock Item with the same field or fields (<<item description>>) already exists.The first item has been exported to BigCommerce but others with the same description field didn’t. How can I export all items even if they have the same description field?
HiI want to use my own Substitution Lists in my Commerce setup when exporting the Item entity.The formula function SubstitutionList and SubstitutionAll is available but during Process of data it fails with error SubstitutionList function unknown.Is this a bug?
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
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">
Is there a way to see BigCommerce “Awaiting Fulfillment” orders IN Acumatica Sales Orders without another customization? We can’t be the only customer who has the BigCommerce Plugin integration into the eCommerce edition of Acumatica? Why we can’t see the Awaiting Fulfillment orders in Acumatica baffles me.
Hello,Is there a way to export a specific price attached to a price code to Shopify so that the price of an item updates when the price attached to the price code is updated?Alternatively, is there a way to make the “RETAIL” price code populate the “default price” field as this would also solve the issue?
Hello! We’re attempting to troubleshoot a new store connection and seem to have everything in place on the Shopify side – when we try to sync the orders we get the following error:Inserting 'Sales Order' record raised at least one error. Please review the errors. CuryOpenTaxTotal: Tax is not up-to-date. CuryUnbilledTaxTotal: Tax is not up-to-date. ShipVia: 'Ship Via' cannot be empty.Shipping address and methods are present in the order JSON along with Tax lines which appear to all be accurate. Any input on where the misconfiguration could be would be greatly appreciated!
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!
AcuGateway - Acumatica Card Terminal EMV Chip Support by IIG Learn how AcuGateway by IIG is a credit card terminal integration supporting EMV Chip, Debit Pin Entry, and Signature Capture can streamline your processes and how your company can benefit from savings resulting from TranSafe integration. During this webinar we will be giving a full walk-through demonstration of this enhancement and its functionalities in:AcuPOSSales Order Payment Application Supporting:Credit Card TerminalEMV Chip ProcessingSignature CapturePIN Based Debit TransactionsLevel II and III Processing YouTube Overview and Demo:
Hi,I am trying to figure out a way to make cases that are being created by incoming emails automatically be assigned to to certain case classes based on rules. I only see how to assign them to different employees in the organization, not how to create a map for case classes. I appreciate the help!
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 Shopify Release Notes Acumatica changes affected versions Changes in connector 2023-01 TBA TBA TBA 2022-07 https://shopify.dev/api/release-notes/2022-07 2021R1 Update 28 or latter 2021R2 Update 19 or latter 2022R1 Update 15 or latter 2022R2 Update 5 or latter New Data Provider “FulfillmentOrderRestDataProvider” was added to accommodate changes in https://shopify.dev/api/release-notes/2022-07#fulfillment-endpoints-removed-from-the-rest-admin-api The “accepts_marketing” property was removed from CustomerData, “email_marketing_consent” used instead. The “source_identifier” and “source
Hello folks,I was wondering why RC order type was chosen as the only supported return order type for the Commerce Connector? It seems like RM order type would be better suited, as it allows for issues and for receipts, credit memos and invoices, it’s more versatile. One of our clients said:The reason we prefer RM is that this Order Type allows both Operation types: Issue & Receipt AND it allows for an Invoice.The other two types are more limited.For instance, an RC does not allow for things like charging a Restocking Fee (Issue)And an RR allows for an even exchange but not for an exchange where money changes hands (which is 80% of what we do)What do you think about this? Are there any drawbacks of allowing to use RM order type for ecommerce returns / replacements?Thank you!
Hello everyone,I need some advice for my inventory report..I need to compare inventory values between BigCommerce and Acumatica to make sure I see any discrepancies. The problem is that in BigCommerce I see the parent SKU... not the child SKUs that the acumatica is presenting. So if I saw this in Acumatica:01-10-0001-LG-BK-NP-C = 101-10-0001-LG-CH-NP-C = 001-10-0001-LG-DCB-NP-C = 1201-10-0001-LG-TO-NP-C = 501-10-0001-MD-BK-NP-C = 101-10-0001-MD-CH-NP-C = 1In BigCommerce it would show this:01-10-0001 = 20So I need the data from Acumatica that matches the data in that CSV from BigCommerce. I need some sort of automated report that is fairly straightforward to run that will show me the available inventory for in Acumatica and also the Inventory for the variations in BigCommerce.Any idea how I can aggregate this?Thank you.-Bernadeth
For AcuPOS merchants using an EPSON TM-T88IV, 88V, 88VI and the ADP Drivers with the Acumatica Device Hub set in the POS Preferences & POS Workstations:If you notice there is a larger than normal space being printed at the header and/or footer of the receipt, you will need to set the following under the EPSON Windows Drivers> Receipt Printing Preferences>Document Settings>Paper Conservation>Top & Bottom. Then Apply the setting changes.
Hi All, My first Summit and enjoyed meeting so many of you and appreciate the warm welcome. Successfully back in Toronto. Phew. Let me back over the border :-).Thought I would share Shopify’s just published Future of Commerce 2022 Report. Jam packed with info and stats to ramp up your knowledge and understand the trends. Hopefully a helpful resource to reference. Lots to dig into and share with your teams, colleagues and clients.https://www.shopify.com/research/future-of-commerceLook forward to continuing the conversation and beyond excited to explore and be part of the Acumatica / Shopify growth opportunities. Cheers, Ted
Last item in stock that is on an Acumatica sales order still shows on the Big Commerce website as available for sale
We do not want items sold out or not available for sale to show up on our Big Commerce Website. Here is our problem: When the last item in stock of a particular SKU is on an Acumatica sales order (but not invoiced) it still shows on the Big Commerce website as available for sale. How can we configure our Acumatica connector so when the last item of a SKU is on a sales order the item will not show up as available for sale on the Big Commerce website? We are on Acumatica 2020 R1.
We have recently had an issue where Base and Sales UOM for certain products do not match. In addition, our prices are set up for the Sales UOM. BigCommerce doesn’t distinguish between different UOM (you can only set a global UOM). As a result, when you sell a product in feet, but it’s Base UOM is inches, a sales order will have lines with inches. In order to force Acumatica to use Sales UOM (instead of Base UOM), we simply un-map UOM on the entities screen like this:When this is done, Acumatica’s default functionality kicks in, which uses Sales UOM on the Sales Orders screen (vs. Base UOM).If you need to add more granularity to how UOMs are selected for e-Commerce order, check out this article:
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.