Commerce Edition QnA
- 252 Topics
- 916 Replies
When syncing Customer Price Class (type) price lists that contain prices for matrix inventory and template items to BigCommerce, the price list in BigCommerce contains the list of items, but the prices are all $0.00.This is how it’s set up in Acumatica:and this is how it comes out in BigCommerce:I’m aware that Customer specific prices are not supported by the connector, but this is not a customer-specific price.Any ideas on how to overcome this issue?Thank you!
Hello! We’re attempting to troubleshoot a new store connection and seem to have everything in place on the Shopify side – when we try to sync the orders we get the following error:Inserting 'Sales Order' record raised at least one error. Please review the errors. CuryOpenTaxTotal: Tax is not up-to-date. CuryUnbilledTaxTotal: Tax is not up-to-date. ShipVia: 'Ship Via' cannot be empty.Shipping address and methods are present in the order JSON along with Tax lines which appear to all be accurate. Any input on where the misconfiguration could be would be greatly appreciated!
Hello,Is there a way to export a specific price attached to a price code to Shopify so that the price of an item updates when the price attached to the price code is updated?Alternatively, is there a way to make the “RETAIL” price code populate the “default price” field as this would also solve the issue?
We have template items setup with matrix items that map to the BigCommerce variants. Client does not want price or weight to populate BigCommerce from Acumatica. They want to maintain that in BigCommerce only. I’ve set in both the Stock Item and Template Item entity to unmap these fields yet the variant in BigCommerce is updating the price/weight based on what is on the variant in Acumatica. Is there a better way to accomplish this? This is 22 R1 for reference.
Some stock items do not sync over to BigCommerce, most of them do but for every 50-100 items that do sync over there is 4-5 items that do not. Most of the items, if I change the price, category, description it will re-sync itself and usually the ones that don’t I can force the re-sync and it will work. But occasionally a stock item won’t sync no matter what I change or how many times I resync everything, even if I force the re-sync it won’t pick up the changes on that specific stock item. I have set stock items the synced successfully and stock items that will not sync, side by side and both of them have the same settings. does anybody know what could be causing this issue? Thank You….
Acumatica suggested we create a Big Commerce Sandbox to test configurations, changes, etc. We have created a Big Commerce Sandbox and linked it to an Acumatica Sandbox. Our VAR has set up the Big Commerce Connector, but cannot make the sync work. Nothing will sync. Our VAR has suggested we post here for help. When I test the connection, I get a green check mark indicating the connections are working. But I still cannot get the sync to work. Any suggestions are greatly appreciated.
There are only 2 choices to show available for the web store. My client would prefer that negative available is ignored and factored into the calculations. In the example below, they want to see 10.This is an example I set up and tested with the store setting for Availability Mode for Available and Available for Shipping.When set to Available the store shows a qty of 8 When set to Available for Shipping it shows 20 If I allocate the sales order for the 10 pieces it changes to either 8 or 10. Generally, we do not set the sales orders to allocate because it ties up inventory you could use for orders with earlier ship dates. Unfortunately, there is no way to allocate orders based on date.
A client has two web stores being synced to the same Acumatica tenant. One store, B2B only, will only use customer group pricing (AR Sales Prices by Customer Price Class) with a fallback to Default price and the other will use the Default pricing with occasional specials. The default price in a Big Commerce store can only be updated from the stock item or template item. The client wishes to update the default price on the B2Cstore using AR Sales Prices because the price may be different from the stock item default price for the B2B customers. Unfortunately the Base Price and Price List entities do not allow Export Mapping.Has anyone had this issue and how do they resolve it? Is it even possible to customize the sync process?
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?
Does Acumatica support to automatically import files from my vendors (on daily/hourly frequency) with tracking details for the our POs, and based of that to create a shipment to the associated SalesOrders dropshipped line items? I guess this is very important for anyone that has BigCommerce connector and/or Amazon connector for FBM orders, in order to get the tracking out to the SalesChannel. Also this should add the real shipping cost for that line item, to calculate accurate profit analysis. The tracking file from our vendors contains:PO Number, VendorSku, Shipped Qty, Tracking #, Carrier, ServiceLevel, Fright Cost @smarenich @josh.fischer
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.
How should the system ideally work if there is only a gift card on the order? Right now, when an order only has a gift card in Shopify, it is immediately fulfilled in Shopify which causes the order not to import into Acumatica
Please note,Shopify does not immediately fulfill gift card orders automatically. It is by checkout settings. Even if fulfilled, Acumatica will import these orders. Acumatica will not import only the Archived orders. So with that, what I would suggest you is either you should make Gift Cards not be fulfilled automatically or make the order not to be Archived as soon as it is fulfilled. I would go with the former.Please see the below screenshot for more clarity. It is excerpt from Shopify Checkout settings.
Has anyone configured the BigCommerce connector to work with an existing BigCommerce store? Our client has a well established store and wants to connect to their new Acumatica install. We started testing the syncs in a sandbox to see how it would work and have run into errors. With the stock item sync, we can only export from Acumatica to BC, but the items already exist in BC. When we try to sync anyways, the error says the item already exists. Is there a way to somehow map the two together to resolve the sync issue? Any other gotchas we need to look for in configuring the connector for an existing store? Thanks for your help!
The Real-Time Import and Export Features on the Entities screen (BC202000) will be disabled for Customers, Customer Location, Sales Category and Customer Price Classes in version 2022R1 of Acumatica ERP.The reason behind this decision is performance issues of the SAAS system. The use of the Real-Time sync with the large amount of customers accounts requires a lot of system resources, which may affect the Connector performance.But fear not!First, for the customers which already use the Real-Time synchronization, we have prepared the customization project which enables this feature back. You may find the customization package file attached to this article, it will work with 2022R1 version.And secondly, we have more effective feature as an alternative solution. It’s the Default Automation Schedules. They are more stable and more effective feature than the Real-Time Sync.
Shipping seems to me to be an overlooked area of Acumatica, and I’m not sure why others have not come across this issue.In summary: We are getting inaccurate shop for rates prices when switching a package in the shipmentThis is our box setup, I will demonstrate using a USPS flat rate boxBOX017 = Small Flat Rate Box We add the package (box017) in the shipment and attach a weight of 2 lbswhen I shop for rates I get a return price of $7.79. The actual price for a small flat rate USPS box is $7.90In order to get the correct price to show up, I have to close the window and re-open the shipment. If for whatever reason I want to change the box (ex. the large flat rate Box014) and the weight to 3 pounds, the shop for rates screen is frozen to the previous dimensions when I edit the package. Once again, I need to save the document, close the shipment, and re-open to get the correct pricing. Seems like this glitch makes us prone to inaccurate price quotes.
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!
Hello everyone,I need some advice for my inventory report..I need to compare inventory values between BigCommerce and Acumatica to make sure I see any discrepancies. The problem is that in BigCommerce I see the parent SKU... not the child SKUs that the acumatica is presenting. So if I saw this in Acumatica:01-10-0001-LG-BK-NP-C = 101-10-0001-LG-CH-NP-C = 001-10-0001-LG-DCB-NP-C = 1201-10-0001-LG-TO-NP-C = 501-10-0001-MD-BK-NP-C = 101-10-0001-MD-CH-NP-C = 1In BigCommerce it would show this:01-10-0001 = 20So I need the data from Acumatica that matches the data in that CSV from BigCommerce. I need some sort of automated report that is fairly straightforward to run that will show me the available inventory for in Acumatica and also the Inventory for the variations in BigCommerce.Any idea how I can aggregate this?Thank you.-Bernadeth
Hi we have setup a processing center to connect to Authorize.net and have tested successfuly. Is there any online form or tool to allow customers to enter their credit card information? I’m surprised I haven’t been able to find anything….customer portal looks like it might have something but I don’t want to give every customer a username/password. Any suggestions how I can have customers enter their own cc details online for authorization?
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.