Commerce Edition QnA
- 232 Topics
- 812 Replies
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 to prevent Acumatica ERP Sales Orders and Invoices from recalculating the taxes imported from external systems such as BigCommerce, Shopify, Amazon etc.,
In 2023R1, a new checkbox called “Disable Automatic Tax Calculation” is introduced in the Order Types(SO201000) form. When this checkbox is selected, the system will refrain from recalculating the taxes for the Sales Orders and Invoices. The Commerce connector will import the Taxes from external systems such as BigCommerce, Shopify, Amazon etc., if the “Tax Synchronization” checkbox is selected in the Stores form. If the “Tax Synchronization” checkbox is selected in the Stores form and if the selected Order Type in Order Type for Import selector has “Disable Automatic Tax Calculation” unchecked then a warning is shown to the user as “ The Disable Automatic Tax Calculation check box is cleared for the EO order type on the Order Types (SO201000) form. Taxes in sales orders imported from the BigCommerce store will be recalculated on invoice creation.” Once these taxes are imported, then it stays as the same even if the Sales Order or Invoice is modified. This “Disable Automatic Tax Ca
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
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?
Wondering if anybody has used the GiftShip app with Shopify and if so is there a way to map the gift message you can leave through to the sales order on Acumatica to print on documents? Wasn’t sure if the Shopify Connector within Acumatica would recognise any of the new fields.
Understanding eCommerce Merchant's Payment Scenarios and Challenges and how they are solved with Acumatica
I frequently receive inquires about the details of how payments are handled between eCommerce platforms and Acumatica. Below are details about this topic. Common eCommerce Merchant ProfilesWe see 2 primary types of Merchants who are selling via eCommerce and managing their back office via Acumatica.B2C/D2C Merchants Often, individual orders are small. B2C/D2C merchants rarely sell items which cost more than $2k Most Consumer purchases are done with a CC Sometimes merchants allow buyers to place an order, pickup/pay in store B2B Merchants Orders are typically larger Common to see orders which total at $5k - $30k Some buyers want to use CC for payment, or it's a requirement of the seller Many buyers will prefer to pay by check via NET30/NET45 Terms Rule of Thumb - best to not try to guess at how merchants will want to handle payments. Every merchant is different, and it's not an area where they are flexible. Goal is to make the technology as flexible/extendable as possible to acc
Price list syncs are taking a very long time, over 20 hours. Not to mention it usually errors out and needs to be manually restarted in this time period.I have tested this with a lot of price changes, and minimal price changes, and the time to sync did not change.Is there a better way to automate this process, and to only update the items which prices have changed (either + or - amount)?BigCommerce did recommend using Price List Importer/Exporter | BigCommerce. I have tested this on Sandbox, and this is a very fast way to update multiple price lists for multiple items at once (I did about 6,000 items in < 10 seconds). While this is an adequate solution, I don't see any way to automate this.
Starting from 2022R116 the users can import the Shopify Orders with the entities like Tips using the following scenario:Create in ERP non-stock item withe exactly the same product description as it appears in the Shopify order: Then try import the order with tips. It will look like: This logic should work for any entity which has no SKU and productID on the Shopify side and which the user wants to import to the ERP.In this case the system will search the ERP Items by the product description.
To assure compatibility with the enhance security provided by TLS 1.2 (which is now mandated by Microsoft and other system vendors), all FusionPOS registers must be updated prior to January 1, 2023.Failure to upgrade may result in the register processing transactions as desired. Please reach out to email@example.com to schedule your upgrade.Regrettably, with the FusionPOS register upgrade, Authorize.net will no longer be supported for integrated credit card processing. For FusionPOS users who are now using Authorize.net we are happy to offer other alternatives for integrated credit card processing. https://fusionrms.com/credit-card-processing.
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 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
Hi Team,We have some business scenarios where we are syncing the orders from BigCommerce, processing that in Acumatica, and Order gets completed and the order status in Acumatica is marked as ‘Completed’.Now on BigCommerce, the order gets modified and we have to resync the order to get those updates reflected in Acumatica, but during this scenario the connector is not picking up this particular order as this is already marked as completed withing Acumatica.Can you please suggest the best possible way to achieve this, to re-sync the orders even though those marked completed in Acumatica, through manual or Real Time or through a scheduler sync. The particular build where we are trying to achieve this is 21.119.0030. Thank you in Advance!
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
Is it possible to automatically add a non-stock item when a specific sales order type is selected/created? For example, we would like to be able to have a non-stock item automatically added to orders from a specific channel to make sure promotional materials specific to that channel are included in the shipment.
We would like to have a sales order type such that when selected to start a new sales order the ship-to address and ship-via for pickup will always be the same address/SHIPVIA and override the customer’s and/or customer class ship-to address/SHIPVIA. Is this possible?
Hi everyone,I created a template item with two variants that will create two option sets in the BigCommerce. My goal is to make the “Choose Your Golf Cart” as the first option set before the “Choose Your seat color”. Is there a proper way I can make it in the process of creating the template item in Acumatica?
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
Hi Everyone, I need a modifier (dropdown type) in some of the Items in the Bigcommerce that should came from Acumatica. I only know how to create a template item and building variants through attributes. But what I need is a modifier that will not create a new SKU/variant when I select the options.Is this possible?I made an example: the one under the category attribute should be the modifier But it didn’t sync in the BigCommerce
I have been asked to enable updates from Acumatica to BC when Sales Prices are updated using Sales Price Worksheets. We have several customer price classes in Acumatica (RET, WHL, 1STWHL, GUEST and Base). Any changes to prices for items made that day are updated every evening with a price class worksheet for each of these Price Classes.We want these updates to propagate to the sales price in BC automatically.In BC we have Price Lists for:WHLRETGUEST (inactive currently)and Customer Groups for : 1STWHL, WHL, RET, GUEST Is this something that is built into the BigCommerce Connector? I am a bit confused. I opened the Entities screen and see a Price List option.Do I simply make this active and then do a manual sync? I also see in the Push Notifications that there is BC-PUSH-Prices. If I open BC-PUSH-Prices and check the conditions it seems to be linked to AR-SalesPrice which is what I believe the Sales Price Worksheets update and in the conditions looking for Entity Type PR but if I ch
HelloAbout the different “Tax Type” available in the “Taxes” settings in Acumatica:I would like to know if all types need to be integrated/supported for the retail-ecommerce (ex: VAT, Sales, etc) or if only the type “Sales” can be used? If the tax type “VAT” is selected for a Tax ID, is there any impact on the retail-ecommerce for the related options that can be checked (ex: Reverse VAT, Internal VAT, etc)? Do we need to integrate all of them? Is there any document for retail-ecommerce about the different tax type integration with retail-ecommerce?Thank you,
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.