Commerce Edition QnA
- 367 Topics
- 1,528 Replies
HI,I’m wondering how I can use the Acumatica Apis to retrieve the price for an item based on the inventoryID and the CustomerIDI’ve found the /entity/Default/20.200.001/SalesPricesInquiry API - I can use this to get the base price and the customer specific price.From what I understand in the Acumatica ERP there is a hierarchy for the price as follows Customer SpecificCustomer Price Classand then finally Base priceSo it appears that I could figure out the price for an item by making an inquiry for each of those steps and using the first one that returns a price?I feel that this is not a great solution though because this is getting into the details of the business logic of Acumatica. Is there a way to send the information for the Customer and Inventory ID to the API and just get the price?
We have a client that needs to implement Stripe so payments from events can be uploaded automatically into Acumatica under a general Customer ID. Then these transactions would be offset against a project under the Projects number and Project Task. Do we need to get a connector through an ISV for this? I know Acumatica has a license feature for Stripe. Any insight would be helpful or instructions?
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?
Not sure if I am missing something, but I have been having trouble overriding the SaveBucketImport method under 22r2 in the BC Connector. The prior definitions did not include the optional parameter CancellationToken.The new original signature looks like :public override async Task SaveBucketImport(BCSalesOrderBucket bucket, IMappedEntity existing, String operation, CancellationToken cancellationToken = default) In my extension I have public delegate Task SaveBucketImportDelegate(BCSalesOrderBucket bucket, IMappedEntity existing, String operation, CancellationToken cancellationToken = default); [PXOverride] public virtual async Task SaveBucketImport(BCSalesOrderBucket bucket, IMappedEntity existing, String operation, CancellationToken cancellationToken = default, SaveBucketImportDelegate baseMethod,) When i compile, it is indicating that the Optional parameter (CancellationToken) must be after the Required parameter (SaveBucketImportDelegate) - if i switch them around
We currently have 11 Branches set up in our Acumatica but we wanted to export those sales orders created in Acumatica that is under one particular branch only to Bigcommerce. So, we created export filtering, see reference below. I tried creating sales order but seems to filter all orders instead of letting only SLC-APPL orders through.Is this supported by the native connection of Acumatica-Bigcommerce? Or any suggestion on how we can possibly do it?Thank you.
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
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?
How to import orders from Shopify for Canadian orders where more than one province has same tax code
Background: In Canada, more than one province has the same tax code but with different tax rates. That is in Ontario the tax code used is HST with 13% and in New Brunswick it is HST with 15%. In Acumatica, a same tax ID cannot have two different rates. And in Shopify the Tax Code cannot be changed manually for US and Canada. But for other countries, the tax code could be manually modified. Commerce Connector:Connector should get the HST code from Shopify order Api for both provinces and import the order with appropriate tax rates in Acumatica. How is it done?Commerce connector works the following way for the Tax ID comparison for Order imports. Checks the Shipping Address first. If not found, then Billing address and gets the Country Code and Province Code from the address and does the concatenation as TaxCode+CountryCode+ProvinceCode for Tax ID.Eg: HSTCAON or HSTCANB Algorithm:First the connector check the Substitution List to find if there is any substituted tax id for HSTCAON.
Hi all,I know this is a very basic question, but sometimes confuses our users. In the Sync History, we have the column ERP ID, and it can be easily understood to refer to the Stock Item SKU. But the details displayed are Item Descriptions, and you are not able to search items using SKU/ERP ID. Any reason why it was called ERP ID, though it was intended for Description or Product Names? :)Thank you
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 firstname.lastname@example.org 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
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.