Commerce Edition QnA
- 249 Topics
- 912 Replies
Has anyone had an experience with a government agency utilizing the customer portal to place orders? We produce and sell medical equipment to the military and are looking to simplify the ordering process but with the government’s security level we aren’t sure if they will be able to use the customer portal. Any advice? Thanks!
Currently, the Shopify Connector of Acumatica supports the metafields with the one and only type multi-line text.But some time ago Shopify had added different types of metafields like decimal, integer, Boolean, date and so on.The full detailed list of the metafield types you may find in Shopify documentation: https://shopify.dev/apps/metafields/types.This enhancement of the metafields functionality brought some problems in syncing the Entities with mapped metafields.The synchronization of the existing metafields with the different types in ERP and Shopify started to fail with the error:“Error on value: Is not using the expected value_type: ‘[Type]’;”.In other cases the metafield value type in Shopify was simply overwritten with multi-line text, no matter what it was originally.Now (starting from the version 2023R1), the export sync of the existing metafields will respect the type of the metafield assigned in Shopify.For example, if in Shopify the metafield type is ‘boolean’ then the va
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?
Hello Everyone, Today we have some out of the box dashboards provided in the commerce module. You can check those from Commerce Sync Monitoring(BC409010) form in the Commerce workspace(attached screenshot).We would like to know if this is useful? Also, would like to have more out of the box dashboards? If yes, what are the dashboards or KPIs you would like to see? Please let us know. We are planning to difference the Dashboards that are related to Sync & Error Handling and that are related to Commerce Sales with respect to Orders, Returns & Refunds, Products, Revenue, Customers. Would love to get your opinion on that. Please let us know what do you think. Thank you so much!
Is there a preferred method for adding a restocking fee to an RC return order? Our thought was to create a “RESTOCKFEE” non-stock item and add it to the RC with a negative amount to subtract the fee from the return. Does this make sense, or is there a better way to go about this?
Hi, We have a requirement to parse CustomerMessage string in mapping while importing Sales Order from BigCommerce to Acumatica. For example, we have customer Message string like this :” abc test some | PO Number : 123243 ”I need to get this value “123243” in one of my Acumatica Field.Can someone suggest how to achieve this? Thanks,Shikha
It might be extremely useful to get automated notification when some synchronization process has been aborted after a pre-defined amount of attempts. We have created several default business events that will automatically send the email notifications:Aborted Order. Aborted Refund. Aborted Shipment. Aborted Payment.These events will be available at version 2021R2.All of them are not active by default.To activate them open Business Events form (SM302050) and select one of these events (for ex., Aborted Order) and check the Active checkbox: That’s it! Next time when the synchronization of the entity (Sale Order in our example) will turn status to Aborted the automatic notification will be sent to the Store Admin email address which is set in the respective Stores forms BC201000, BC201010: The notification could be found in All Emails (CO409070): When you click the respective link on the All Emails form, you may see how the email notification itself looks like:
Hi All,During the implementation of different commerce connectors, you may face some issue or errors. In case you want to troubleshoot what is happening wrong, you may find Logs of the commerce integration very useful and beneficial.To do so, you should first enable logs in the Request Profiler:When logs are fully enabled, you can perform the sync you want to troubleshoot. Finally, you can go back to the request profiler and find out logs.In case you want to review requests and have many of them, I recommend you to apply filtering by user, screen id (BC3010000), or operation (sync).However, the most beneficial type of logs is - Event Log. This tab will provide you a comprehensive information about what exactly happening under the hood. To filter our only commerce requests, you can apply filtering by the - Message contains ‘[COMMERCE]’ and Message contains ‘API’.For example, here you can see operations performed as part of the customer synchronization. Especially, I would like to highl
ERROR: The sales order could not be imported because the combination of the New York State store shipping zone and the None store shipping method is not mapped to a Ship Via or the mapping is inactive in the store settings.
i am getting error when i process sales order ERROR:The sales order could not be imported because the combination of the New York State store shipping zone and the None store shipping method is not mapped to a Ship Via or the mapping is inactive in the store settings.
Hi,Does Acumatica BigCommerce connector supports Channel Manager?Currently, our customer has two channels in BigCommerce Its my understanding that this feature gives BigCommerce administratros to have 2 storefronts with the same store. Does the Connector has the possibility to separate which products will be exported and used in specific frontstore?Or the products should be configurated in a new BigCommerce store to use a new store in Acumatica connector? Thanks!
When creating a new Customer in Acumatica and pushing the entity over to an eCommerce website there is currently no way to directly define the password from within Acumatica by default. If a one time use password is desired it must be configured manually by an administrative or clerical user within the eCommerce platform ( Shopify / BigCommerce / etc ). The only alternative for the first login is to direct the customer (who’s new account has no password) to go through the password reset process which is cumbersome and takes multiple steps. It would be a far better user experience for the customer to instead be given a one time use “throw-away” password in Acumatica that is known in advance and then force to the user to reset after correctly authenticating for the first time similar to the process that exists within Acumatica. The only requirement here would be for Acumatica to add the password fields from the eCommerce API to the field mapping since the API on the eCommerce side alread
We have non-physical items that are sold on our Shopify store (software downloads). These are set up with the “This is a physical product” box unchecked in Shopify: However, this means that customers will not be prompted to enter a shipping address. Because of this, it seems we are getting a sync error: “Taxes cannot be calculated via the external tax provider because the address is missing”.We can go into the Shopify order and manually add the billing address as the shipping address and resync the order which works, but is there a way for us to still sync the order even without a shipping address?
Hello Acumatica Commerce Connector users, There are many features released in every version of Commerce Connector. The product is growing bigger each day. That being said we would love to hear from you about features you like and about the areas where we need to invest more time to improve. We would greatly appreciate if you take few minutes to provide us this feedback. The feedback page has two sectionsShort answer questions - Require less than 2 mins to answer. Long answer questions - Requires around 10 to 15 mins to complete. You could be generous and answer them or request for a meeting with product team who would be happy to schedule a call and discuss more. Feedback Link: https://forms.office.com/r/XNzEnLm7d6If you have any questions about the feedback or ifthe link is not accessible, please feel free to contact Karthik Gajendran (firstname.lastname@example.org).
How to split the Customer Account name in Acumatica and sync to the Shopify First and last name field.
We have a requirement from the client that during the customer sync from Acumatica to Shopify, Connector has to split the first and last name of the customers from the Account name with reference to the first space starting from left. For e,g. Let's say if a customer name is “Mike Thomas Gorden” Connector while syncing the name to Shopify first and last name field, the connector should check for the first space from the left and split the name into two parts as first and last name and send it to Shopify.Based on the above example Connector should sync the first name: Mike and the last name: Thomas Gorden to Shopify. To fulfill the customer requirement we have defined the following mappings at the connector Customer entity levelValidation has been successfully passed but while syncing the customer from Acumatica to Shopify we have found the below issue.While syncing the customers to Shopify, the connector has thrown an error “of an undefined FIND()” function. hence we could not achieve
What happens when you check the box for "Automatically show related products in storefront" in the BigCommerce product page?
This action causes a problem where the related products disappear. In the BigCommerce product pages there is a checkbox which displays as "Automatically show related products in storefront".If the box is checked the window collapses and no longer displays the related products that were imported.Before CheckingIn the Store View the related products display below the main item.After CheckingOnce the box is checked, the Related Products window is minimized, and the related items are not visible anymore.Note that the page must be saved for changes to take effect.The Store view displays exactly as it did before.ProblemIn the case that the user wishes to uncheck the box, he/she must go back into the product page and uncheck it. However, this causes the related products to disappear.If the user saves the current state of the product when exiting, the related products disappear in the Store View as well.If the user does not save, the related products continue to display in the Store View as th
The Order in External System might not have Ship To Address because all the items within the order are non stock items or digital items. Digital items do not require to be delivered physically and hence there is no ship to address. When such orders are imported into Acumatica, you might error related to Taxes or about missing the Ship to Address. Follow the below steps to successfully import the order. Make sure the non-stock item has the right Tax Category. If you are using Automatic tax engine like Avalara for tax calculation, then make sure the non-stock item has the non taxable tax category. Eg: ON030000 The complete list of Avalara tax categories can be found in this link https://taxcode.avatax.avalara.com/ If it is manual tax setup, then make sure the taxes are configured to not calculate taxes for this non-stock item. Make sure the Ship Via used for the order is a not a common carrier. If the Ship Via is not a common carrier(“Will Call” option check in the Sales Order), t
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
We have set up automatic credit hold in Acumatica. Can this credit hold be synced to Big Commerce, so if a customer on credit hold tries to place an order on Big Commerce, the customer is told in Big Commerce the customer is on credit hold and prohibited from placing a Big Commerce order?
My BigCommerce sandbox demo site got messed up and I created a new one. I was able to test the connection satisfactorily, however when I try to do a FULL Prepare and Process for items, sales categories, etc. it doesn’t show any items to export to the new BC site. I am assuming that there is sync data that needs to be cleared out on all the records. Is there a SQL script to reinitialize the data used by the entities so that they will publish to the new BC site? Or can this be done within Acumatica? Best, David Eichner, CPA
Hi, I’m wondering how to manage the stock and sales for used inventory.Say we sell item A as a brand-new product, but we’ll sometimes get a return where the product isn’t in brand new condition. We now want to sell Item A as a used product for a discounted price. We need to have a way to manage the inventory, sales, and cost of this product. It shares the same product ID and barcode as the brand-new product. Creating a new product ID and adjusting the inventory will create an issue since it won’t show the cost of the product.
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.