Commerce Edition QnA
- 367 Topics
- 1,528 Replies
I am trying to figure out a way to update Fulfillment status and Confirm a shipment in one call instead of doing 2 separate calls, to get this approach working would it be difficult to extend the web service endpoints?Do y’all have any better option or the best way to go is make multiple calls?
I have an export scenario set up to export using the Customer screen layout to an excel file. I am trying to export the following records from the Customer screen and want to use a Source restriction to restrict the export to a couple particular customer classes.When I run it using the source filter (and not setting the customer id to ‘=every’, the address field data for the account and shipping addresses that are exported are all the same as the first customer, although other fields do export correctly.Any thoughts on what I can do to make this right so I can use source restrictions? My testing of using the =’every’ for customer ID and a source restriction results in no data being prepared all all. The example below has the =every, but removing it is what gives me the same data in the address fields for all records.Any thoughts are greatly appreciated!
We are new to the platform. We are experiencing difficulties when trying to sync returns from Shopify. We are getting the error message: The following tax identifiers from the external system could not be matched: PA STATE TAX. The ERP has failed to save the tax ID or the tax amount differs from the one that has been expected. Make sure that taxes are configured for the tax zone and tax categories. Also, make sure that taxes either have the same identifiers in the ERP and external system or are mapped on the Substitution Lists (SM206026) form. Has anyone experienced this issue and how do we correct the issue? We are currently manually entering all returns into Acumatica at this point. We do not experience this problem with a normal order or with a POS return.
BigComm order is synced into 2022R2 cleanly. But then it is switching back to "Prepared" Status in Sync History
We just upgraded to 2022R2 - Build 22.207.0013.And we are having performance issues with our order syncs from BigCommerce. The orders are Preparing and Processing as expected - and this is verified in the Sync History page.However - shortly after processing into the system, the order gets switched back to a status of “Prepared”. The system is then trying to re-process the same order - even though it already exists now.This is causing system perf issues as the day goes on - and the number of orders grows. The Prepare and Process jobs are scheduled to run every 60 seconds.Thoughts?
Hey Folks,Couldn’t find much on this, so wanted to see if anyone had any thoughts:In template item creation, under the “matrix item” tab, it is picking up the “last cost” and it seems to push this to Shopify as the product cost even though the item has a ‘current’ cost defined under the Stock Item: These particular items have a “Current Cost” but not a “Last Cost”: Do we happen to know why the Shopify Connector uses the Last Cost and not Current? Are we supposed to be updating the cost to “last cost” routinely?Cheers,k2
We would like to map the Acumatica Entity Usage Type field in a Customer Profile to the analogous field in BigCommerce’s Customer table, so that we can set whether a customer is tax-exempt or taxable from Acumatica. We use Taxjar as our tax solution, and to set a customer as taxable such that the Tax integration between BigCommerce and Taxjar will work properly to recognize the tax status of a customer, we need to either leave the field blank or fill it with “TAXABLE”. Any value other than Taxable in the BigCommerce field will send a customer tax-exempt value when Bigcommerce does an API call to Taxjar for that customer.If we sync the field as it stands now, the value for taxable in Acumatica in the Entity Usage Type is “Default”, which if entered in the BigCommerce field will make that customer exempt (opposite of what we want). Is there a way to either update the pick-list for entity usage types in Aculatica to add “TAXABLE”, or for us to use some sort of substitution in the connecto
Hello, We have been having an issue with our BigCommerce connection into Acumatica whenever a customer creates their first order on the website. When the customer creates an order from BigCommerce, it syncs into Acumatica and uses the Ship To Name and Address for the Customer profile instead of using the Bill To Name and Address. We have to manually override the Name and Address every time, on every tab to correct this. Also, if a new location is created in Acumatica for that customer, it defaults back to the original Attention and Ship To Addresses that were incorrect, even after they’ve been changed. Any ideas for a fix to this issue? Thanks!
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
Shopify Connector : Action Required - Migrate your custom app to the Fulfillment Orders API by March 31, 2023
Our client has received the following email from Shopify.. The customer is preparing to upgrade to 22R2 build 202 right now. Any impacts of these that we need to be aware of or execute. Action Required - Migrate your custom app to the Fulfillment Orders API by March 31, 2023Your custom app is leveraging the deprecated Fulfillment API. Please note that the Fulfillment API will stop working as intended on March 31st, 2023 in favor of our new Fulfillment Order API. Read our migration guide and take action as soon as possible to avoid breaking changes.The following app(s) you are using currently use Fulfillments API and should be moved to Fulfillment Orders before March 31st, 2023:
[22R2]-Import Matrix Items, Template Items using Import Scenario, Convert Stock/Non-Stock item to Matrix Item and vice versa..
In continuation withThe existing ImportMatrixItems customization is upgraded to 2022R2 with the below interesting changes. Now there are Import Scenarios for both Template Items and Matrix Items.Import Scenario for Template Items Import Scenario for Matrix Items The Edit Template ID checkbox in the Item Class form which enabled the Template Item ID field in the Stock/Non-stock form is removed. The Template ID selector is always enabled and filtered based on the Item Class of the Stock/Non-stock. Template ID selector is filtered based on Item ClassThe Is a Kit checkbox is enabled in the Matrix Item which allows the Matrix Item to be created as a Product Kit. Check Template ID and Is a Kit fields are always enabledIf the selected Template ID in the Matrix Item does not match with default fields with each other then a popup warning is provided to the user. The fields that are checked are TypeValuation MethodTax CategoryBase UnitSales UnitPurchase UnitPopup warning when default fields
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
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
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!
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.
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 😎
While working through an RC, is there a way to process it like the “Pick pack and ship” or “Receive and put away?” We have several coming back as a stock lift so one RC could have 10,000 pcs. I’m sure something is available, but I cannot seem to find it through my VAR, or my limited research.
Using the BigCommerce/Bundle B2B connector, is there any way to handle the following business need? We would like to create a specific Sales Price Worksheet for approximately 600 of our customers. In Acumatica, this is feasible in the Sales Price Worksheet module by attributing the worksheet to a specific Customer Price Class and then assigning that Customer Price Class to the 600 customers. There doesn’t seem to be a way for BigCommerce and Bundle B2B to read that information in the hierarchy we are looking for. Any suggestions?
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.