Commerce Edition QnA
- 293 Topics
- 1,125 Replies
BigCommerce 2020R2 - How to Restrict Shipping Option Mapping
Hi Team,We are working with 20.221.0021 build and we have a requirement to use a default Ship Via on importing order from BigCommerce to Acumatica instead of using the Shipping Option Mapping grid. Can you please confirm if is it possible through Entities Mapping screen or the best possible way to do it.And if there is a way we can stop populating the Shipping Option Mapping grid. Thank you!
How the order with no Ship To Address can be imported into Acumatica from external system?
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
Taxing Digital Goods and Commerce Connectors
The question is regarding taxation of digital goods sales.In BigCommerce, you’re not required to provide your shipping address if you’re only purchasing a digital good (eBook, for instance). Therefore, your order looks like this:You may notice that Avalara still calculates the tax, based on the billing address (which is correct).However, when this order comes into Acumatica, there is no shipping address, the Ship Via is set to Will Call, and the tax is calculated based on the Warehouse location (which is WA, in this case).What is the best approach to manage these cases?Thank you!
Upcoming Webinar with Shopify/Acumatica and our customer Clive Coffee
Shopify is hosting a webinar with Acumatica, Shopify and our customer Clive Coffee.I can’t wait for our community to see this!Registration links are below and please be sure to share with your network. Really appreciate everyone’s support and interest in what our team is building. It’s literally changing the lives of these business owners!Josh How Clive Coffee met demand after a year of record-breaking growthWhen: May 5, 2022 at 11:00 am PT | 2:00 pm ETLearn how the combination of Shopify Plus and Acumatica:Increased revenue by $90K through back-in-stock notifications Reduced daily order processing times from 5 hours to 1 hour Launched 30+ new products from purchase order to fulfillment with automationRegister now
How to parse string field - BigCommerce Import Mapping
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
Admin Unable to Reset User Passwords
Hello, I have system admin user role in Acumatica, and I need to reset another users password. I have been able to do this in the past.Now, however, as soon as I click on the Reset Password button on the Users Screen… It changes over to my own user account in the system, so I would be changing my own password. Is there a way to workaround this issue? Thanks!
Commerce Entity exports not being able to use Substitution Lists
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?
Dashboards for Retail-Commerce module
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!
Sync Credit Hold from Acumatica to Big Commerce
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?
Government Interfacing with the Customer Portal
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!
Reinitializing items, sales categories, etc to sync with new BigCommerce site
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
Why does an item with ID C-A892:MD change to C-A892-MD when exported to BigCommerce?
We are having problems with exporting template items that have never been synchronised before. e.g. The item on Acumatica is called C-A892:MD with a : between the Template ID (C-A892) and the SKU code (MD). When it gets created in BigCommerce it is created as C-A892-MD which doesn’t match and gives an error on the export sync ( "The synchronization could not be completed because variant items do not match the 7386 product in BigCommerce.")Is there any way to get around this other than manually going into BigCommerce after the sync fails and changing it before resyncing?Thanks for any advice, even if it’s just that we have to manually do it and there is no way around it.Phil
Commerce Connector Synchronization Logs
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
Revamp Batch Picking Process
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
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
Product allocation based on warehouse location and customer location
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
Shopify to Acumatica 2
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?
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.
Default One Time Use Password for Commerce Integration
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
Default Business Events for Aborted Synchronisation Notifications.
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:
Sell Used Invenotry
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.
Already have an account? Login
Social LoginLogin with your Acumatica account
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.