Commerce Edition QnA
- 369 Topics
- 1,534 Replies
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
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
Hello Customers and Partners, The Acumatica Retail Commerce team is focused on improving COMMERCE CONNECTOR ERROR messages with recommendations for what to do in each case. We are looking for your feedback on what are the most frequent or challenging errors where we may clarify and provide direction on how best to address. Please complete this poll with sections for each commerce connector Acumatica Retail-Commerce Team - ERROR Poll Poll includes written and screenshot option for each commerce platform below BigCommerce Shopify Magento Alternatively, if only a few errors, please comment on this thread and I’ll capture. Thank you in advance for your time. Stacie Jurczak, Program Manager, Retail -Commerce, Acumatica
I am getting the following error with an order syncing from Big Commerce to Acumatica. Any ideas on how I can fix this and get the order to sync? Updating the 'SOOrder' record failed because data in some field is too long. String or binary data would be truncated.The statement has been terminated.
My BigCommerce sandbox demo site got messed up and I created a new one. I was able to test the connection satisfactorily, however when I try to do a FULL Prepare and Process for items, sales categories, etc. it doesn’t show any items to export to the new BC site. I am assuming that there is sync data that needs to be cleared out on all the records. Is there a SQL script to reinitialize the data used by the entities so that they will publish to the new BC site? Or can this be done within Acumatica? Best, David Eichner, CPA
Here’s an easy one! There are a couple tables I’ve found in the sample database that I cannot find in the Code Repository. I’m wondering if they are legacy tables that are no longer used.For example, EPEquipmentTimeSheetDetail and EPTimeSheetDetail. The only place I find them when searching the entire solution is in a file “Settings except Attachmments.esc” <Exclude table="EPTimeSheetDetail" /> <Exclude table="EPEquipmentTimeSheetDetail" /> Are these “dead” files?
For some reason the pricing sync for Big Commerce when you have multiple units of measure enabled is to use the base unit and not the sales unit. This is a major problem because customers build pricing based on the sales unit and not the base/stocking unit. How do we go about getting this changed? This is a critical issue for one of our clients. https://help-2021r1.acumatica.com/Help?ScreenId=ShowWiki&pageid=994bc074-79eb-403b-81c4-9545d470a01dLimitations of Sales Price SynchronizationUOM-specific prices: In Acumatica ERP, if the Multiple Units of Measure feature is enabled on the Enable/Disable Features (CS100000) form, you can define a sales price of an item for each of the units of measure in which your company sells this item. However, only prices defined for the base UOM can be exported to BigCommerce.
Hi, I think that batch picking needs to be fixed in the WMS. Below are the issues I ran into while trying to implement this. It would be helpful if everyone else adds their issues. Batch picking by location doesn’t give a quick filter where you can select multiple locations from a list. You can either add it manually, or you could upload an excel sheet, but that takes a minute and is time-consuming The “known limitation” of not being able to batch pick nonstock kits Acumatica doesn’t show you what SH has a non-stocked kit and will add those shipments to the batch Once you run into this issue, there is no real way of fixing it besides removing all items that might be in a kit. Even if you have the same item on a SH not part of a kit Once a picker scans a picking sheet, there is no way to go back. If someone else wants to pick it instead, or if you want to cancel the picking sheet, it won’t let you The lack of system messages regarding the process and what you need to do next. i.e. In
Hi all,I tested creating a new user from the website and it failed to sync into Acumatica until that user was added to a B2B company.Any changes made on the B2B side of the company are now over-written by the Acumatica values (tested on addresses and price lists). I see the sync on this is bidirectional, can I use other option on this?Another thing, I have B2C and I was able to use the "Trade Application Application" to signup a new account that created a customer in BigCommerce and a Company in BundleB2B that was able to sync without issues after I approved the company. If we have all new customers sign up for accounts this way instead of the native BigCommerce account sign up this may be the way to do it? There are some limitations on B2C business. any advise? Thank you.
I’d like to make a processing screen that will allow me to add items to the grid of items to process.I’m basically trying to make a grid that you can run processing on that I can add/delete items. The only filter I have is at the top of the form that is a checkbox that changes the grid from “Show Posted”, “Show Unposted”. The filter checkbox pulls data from a custom table, so it is a “real filter” I want to be able to add items to the grid, and THEN process them. I also want to be able to import items into the grid.From all the things I can see, processing screens are designed to pull data for the grid that already exists in the system and are not editable. I’ve tried a plethora of things to try to get the grid on my processing screen editable with no luck.At this point, I created a Form/Grid screen and put “manual” processing buttons on it to process my grid items, but I want to be able to show the typical processing screen where it shows the Successful, Warnings, Failed etc. I
Hello Everyone, Today we have some out of the box dashboards provided in the commerce module. You can check those from Commerce Sync Monitoring(BC409010) form in the Commerce workspace(attached screenshot).We would like to know if this is useful? Also, would like to have more out of the box dashboards? If yes, what are the dashboards or KPIs you would like to see? Please let us know. We are planning to add different Dashboards that are related to Sync & Error Handling and also that are related to Commerce Sales with respect to Orders, Returns & Refunds, Products, Revenue, Customers. We would love to get your opinion on that. Please let us know what do you think. Thank you so much!
Recently updated to the build 21.216.0034. It would appear there has either been some change to what triggers a ‘Product Availability’ sync request, or otherwise a related bug. In previous builds, ‘Product Availability’ record prepared of course based on update to the given inventory ID (Template, Stock, Non Stock). Expected and documented functionality. Since our update to this build last week, it appears that nearly all Inventory ID records are entering the prepare/process queue, even though the majority of those records have not been modified by any expected action (ie, sales order created, PO received, inventory adjustment, etc). Is this a known situation? Have changes to what triggers a product availability request been meaningfully changed in this build? Why this matters in our integration: We override the ‘track inventory’ setting for BigCommerce products that we want to allow backorder on (ie, take an order for something not in stock). For items with low velocity, the Invento
Hi ,Requirement: map the fields from acumatica to Big Commerce in Entities screen. In the above screenshot I changed “source field” values. I want to get details from Export mapping tab .where will I get this information and where can I write the code for this.
Today in Acumatica, when Sales Orders are processed into Shipments, the system will by default process based on a limited set of available filters at the Sales Order document level. This method involves the assignment of inventory (SKU’s) generally based on the date ordered. SKU’s that are not available may be back ordered and processed into a separate shipment at a later date. This method appears to assume that all SKU’s on any given order are available or will be available in the short term to fill all open orders. It also appears to assume that companies who wish to capture payment prior to shipment would process the payment on the Sales Order regardless of which items may have been shipped or back ordered. Example scenarios where the current process may fall short.Companies engaged in B2B and B2C sales where priority may be given to one customer type over the other based on a variety of variables. Companies selling limited availability items which need to be distributed across the
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
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.