Commerce Edition QnA
- 371 Topics
- 1,540 Replies
Hi All, one of our customers is wanting to integrate with Amazon in the UK, the native connector is not currently certified for Amazon UK but the customer has Shopify. I was wondering if anyone had any experience with one of the apps at all? I take it shopify gets the amazon order, syncs to acumatica, acumatica processes the order and it does the reverse back to shopify and amazon but any info from people with experience would be appreciated. ThanksMatt
We just want to confirm if this is what we expect for the connector when a customer was deleted in Acumatica. Please consider the ff:1. A customer was created in Acumatica2. It was synced to BigCommerce3. Customer now exists in BC4. Customer was deleted in Acu5. Synced the customer in AC sync history6. Customer still exists in BCIs it what we are expecting? Do we have some indication in BC if a Customer was deleted from it's Acu source? Can we forbid them to log-in and place order in BC? Thank you
How to create a custom field in BigCommerce and map it with a field in Acumatica using Acumatica Commerce Connector?
The Custom Field in BigCommerce could be added using the Commerce Connector from the Entities form(BC202000). Imagine you would like to map a attribute or custom field or any field from Acumatica Stock Item form to a custom filed in BigCommerce product page and this custom field in BigCommerce is not yet created. Go to Entities form(BC202000), select Stock Item Entity. Go to Export Mapping Tab Click plus (+) button In the Source Object, select the required Acumatica object. Eg: Attributes or Advanced In the Source Field/Value, select the required Field. In the Target Object, select the object as Product->Custom Fields. In the Target Value/Field, select <<Automapping>> as shown in the screenshot. Now when the stock item is exported next time, connector will automatically create the Custom Field in BigCommerce with the same name as in Acumatica. If the field already existing in BigCommerce then just the value of the field will be exported to existing field. Limitatio
Acumatica 2020 R1, Build 20.101.0032, Screen ID: SO301000 Is there any way to overwrite the customer tax zone field based on order type? We have an external selling channel that collects sales tax on our behalf. We create these orders in Acumatica for fulfillment and inventory allocation purposes, but we don’t need sales tax to be reflected since it’s collected by the third party. Open to any suggestions that could eliminate the need for manually overwriting and changing the tax zone - as that could be an easily missed step.
Acumatica allows us to create Unit Of Measure Conversions, which is extremely helpful. It allows clients to sell the same item as an ‘each’ or a ‘case’ and counts it as 1 item which can be differentiated in the cross reference as 2 separate barcodes. So the warehouse can scan either the barcode on the individual item (the ‘each’) or the barcode on the case of 4 (the ‘case’). In Shopify & BigCommerce you are not able to create Unit of Measure conversions. You are required to create a variant for the each and the case instead. With this in mind how can these 2 differences still work with the commerce connector? It appears to me like I may be forced to have my client create 2 separate stock items in Acumatica, then create a Template item, plus new attributes, then add them to the Item Class, then add these 2 items to the Template item, as well as require them to maintain 2 separate inventories for the same 1 item moving forward just so they can sell it as an ‘each’ or a ‘case.’ I hope
Use Case: Users would like to sell in Commerce sites the same product in different UOMs than the default Sales UOM in Acumatica. Example, merchant could sell apples in Kilogram(KG) and also in Pounds(LBS). In Acumatica, the user could have the Sales UOM as LBS but sells in Commerce site as KG. Most of the sites do not support UOM. Both Shopify and BigCommerce does not support it. Solution: Provide the SKU code of the product in Commerce site in the Cross-Reference tab in the Alternate ID field with the required UOM in the Stock/Non-Stock forms in Acumatica. Commerce Connector, will get the SKU code from the Commerce site’s sales order product and checks in Acumatica if there is a matching Inventory ID, if it finds, then it will be used with this UOM in Acumatica SO Line. If not, connector will check the Alternate ID from the Cross-Reference tab with Alternate Type as Global. If it matches, then the UOM will be taken from the cross reference tab for the SO Line. Please see below screens
Does anyone know if it is possible to sync related items under a product in Acumatica to a single, list-type metafield?Example:Product A has Products B and C selected as Related items in Acumatica. Product B and Product C are synced together to a single list metafield as “Product B, Product C” (or something along those lines). Later, Product C is removed as a related item in Acumatica and replaced by Product D. Now, Product B and Product D are synced together to the single list metafield.
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?
Hello everyone!Do you have any success stories with Acumatica & a bookshop? It would be helpful if you could provide me with a reference in this particular retail store. Thank you so much for your help! My chances of winning a deal could improve if I use it! -David 😎
Hello, my company switched to Acumatica this year. For our b2b website we went down the road of using BigCommerce and the Acumatica connector for it but I’m not much of a fan of the BigCommerce environment so am looking at alternatives. Our current website is PHP/MySQL based (which is what I know best) but is still using our old ERPs “cart” integration, which is no good long term (we basically have to continue to maintain and setup products in our old ERP just for this cart purpose and then export them out and import them into Acumatica). I’m curious if others are using any custom or off-the-shelf site/cart solutions which are integrated into Acumatica via the API, besides BigCommerce/Shopify/Magento. Our current website’s data is already being pulled from Acumatica (the MySQL db is updated with Acumatica data daily), I just essentially need the “cart” part and then the ability to automatically push those submitted orders into Acumatica. Any comments/thoughts/advice would be appre
Hello I am trying to sync related products against template items between Acumatica and BigCommerce. I am able to do this with non template items and it works as expected. For template items I have tried adding a related item to one of the SKU’s in the template item but it does not sync through. Is there a way to associate related products to template items please? Thanks Matt
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!
Hi everyone, I just have a question.Do B2B Bigcommerce supports Sales Prices sheet, customer specific discount, qty discounts on a line item level, and order level discounts from Acumatica? I just want to make sure that everything how it is currently operating in Acumatica, can be replicated in BC. or whether TranZetta pricing will work. Thank you.
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.
Hello Everyone,For Acumatica 2020 R1 version, is there any possibility to fetch specific orders, based on specific BigCommerce order statuses from BigCommerce to Acumatica.For an example: I want to fetch only the BigCommerce orders having order status as: “Awaiting Payment” and to import further in Acumatica.Can we achieve this from any mappings/configurations or we have to do a specific customization. If customization is needed, can you please help with sample code. Thank you in advance !
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?
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?
Hello! I’m having an issue with the sync between my BigCommerce store and my Acumatica Sandbox environment. I have a customer that will not sync to Bigcommerce. Previously it had been syncing to our Bigcommerce stores, but I believe that at one point the account on the Bigcommerce side had been deleted. Now, when I go to process data (or sync from sync history), the sync runs indefinitely. It does not throw an error, it just keeps going with no result. I’ve tried re-creating the customer in BigCommerce and changing the external ID on the sync to match the new one. That did not clear up the issue. Any ideas?
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
Hello, a few of our client have the same issue: when exporting shipment information from Acumatica to BigCommerce, the export fails, when there are 2 or more packages on the shipment, and no items are assigned to each box:The error on the export would be: The [shipment number] shipment could not be exported because the [tracking number] box has no items. Please delete this box or assign an item to it.Can we have Acumatica disregard any and all tracking numbers, UNLESS it’s the only tracking number (1 package on a shipment) or the package has items assigned?Thank you!
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.
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.