Commerce Edition QnA
- 371 Topics
- 1,540 Replies
We need to map an attribute to the BC default price. For non-matrix items we can do that. When syncing the template does the process use the Stock Item mapping or does not sync use the template mapping and uses the stock item data?
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
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?
Hello Acumatica Community! Check out the latest joint case studies with BigCommerce & Acumatica:https://www.bigcommerce.com/case-study/van-cafe/ (119% growth in revenue) https://www.bigcommerce.com/case-study/ink-custom-tees/ (186% growth in revenue) Cheers!Colleen Sheacolleen.firstname.lastname@example.org Manager, Strategic Partnerships
Shopify is hosting a webinar with Acumatica, Shopify and our customer Clive Coffee.I can’t wait for our community to see this!Registration links are below and please be sure to share with your network. Really appreciate everyone’s support and interest in what our team is building. It’s literally changing the lives of these business owners!Josh How Clive Coffee met demand after a year of record-breaking growthWhen: May 5, 2022 at 11:00 am PT | 2:00 pm ETLearn how the combination of Shopify Plus and Acumatica:Increased revenue by $90K through back-in-stock notifications Reduced daily order processing times from 5 hours to 1 hour Launched 30+ new products from purchase order to fulfillment with automationRegister now
Hello,We are in the midst of implementing the Commerce Connector from Acumatica(build 21.208.0032) to an existing BigCommerce store. We are implementing in phases, with the first phase being stock and non-stock items, and inventory levels. We have a custom built integration that imports orders from BigCommerce. Most of our products need to be Matrix items with only 1 variant. I have followed the steps outlined here:With the exception of importing the items as we already have the items created in Acumatica. When trying to update a stock item to be tied to a template item, I get the following error:I have been able to use that attribute to create new matrix items following our part number format. I would greatly appreciate any help in resolving this error. Let me know if any further info is needed.Thanks!
AcuPOS (April 2022) has just released new builds along with updated User Guides and Release Notes. They can be found on the Acumatica AcuPOS Community PageRelease Versions:21R1 Build 104 R45 21R2 Build 207 R04 22R1 Build 100 R01Improvements:POS Orders forming PS sales orders with wrong taxEnhancements:Smart Scanning Receipts for Returns Receipt Format - Short & Regular Item Buttons Load from Stock Item Screen
I am trying to mass import Item Sales Categories for a commerce deployment. I was able to write an import utility to import the first tier but cannot import any child sub categories.I set the folder path using this syntax: Company/Level1/Level2/Level3 etc I then set the Category Description with using the final segmentIt seems that if the path category does not exist, then it will simply import the path string as the category name.What is the proper approach and syntax to get this to work?
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!
Upgraded to 2021R2 and running through full resync of relevant entities - Sales Category → Stock Item → Non Stock Item → Template Item. Got to Product Availability, and encountered a new error I’ve not previously seen: Error: Specified argument was out of the range of valid values.Parameter name: IdentifyNoteIDSteps: Ran a ‘Full’ Prepare request for Product Availability Entity (previous automation schedules inactive since just prior to cutover to new release). Attempt to Process records. Encountered error above. The records do not appear to fail (ie, do not move to a failed or aborted status in Sync History), but just remain in the ready to process queue. I’ve approached this from both the prepare/process screens and from the sync history screen, and keep encountering the same error. Acumatica Trace from this screen:Right now I don’t have a means to reconcile product availability since our cutover 72 hours ago, which is problematic.
Dimension Creation in AcuPOS:AcuPOS requires the DimensionCreation customization package to be published(only once for the instance) and then the AcuPOS build to be published to the Acumatica ERP instance. The DimensionCreation customization package creates "WORKSTATION - POS Workstation" segmented key record in the Segmented Keys(CS202000). It is required to create a "WORKSTATION - POS Workstation" segmented key before the AcuPOS publishing. This operation can be done either manually or by the DimensionCreation customization package. In the case of creating a new tenant occurs a situation when in the new-created tenant the workstation segmented key is not created but the User Profile has a Workstation ID field to be selected. PROBLEM:For this reason if you try to create a new tenant while the AcuPOS packages are still published you will receive the following error: Unable to cast object of type 'IGFS.DAC.IGFSUsersExt' to type 'PX.Objects.FS.FSxUser'. at memberwiseCloneExtensions(U
This is the Example ERROR: Export of the Stock Item record cannot be completed. The Stock Item with the same field or fields (<<item description>>) already exists.The first item has been exported to BigCommerce but others with the same description field didn’t. How can I export all items even if they have the same description field?
HiI want to use my own Substitution Lists in my Commerce setup when exporting the Item entity.The formula function SubstitutionList and SubstitutionAll is available but during Process of data it fails with error SubstitutionList function unknown.Is this a bug?
Is there a solution to sending package tracking numbers to customers as a link to USPS or even Google?If I click the link in the email below, it currently will send me to google with the Acumatica field nameThis is the html code I used to create the link...<a href="https://www.google.com/search?q=((Packages.TrackNumber))" style="text-decoration:none;display:inline-block;color:#ffffff;background-color:#034e7d;border-radius:4px;width:auto;border-top:1px solid #034e7d;border-right:1px solid #034e7d;border-bottom:1px solid #034e7d;border-left:1px solid #034e7d;padding-top:5px;padding-bottom:5px;font-family:Arial, Helvetica Neue, Helvetica, sans-serif;text-align:center;mso-border-alt:none;word-break:keep-all;" target="_blank">
A client with an existing Shopify store connected to their legacy ERP uses variants but they do not wish to utilized Matrix items in Acumatica. Instead the just want to have each variant as a individual SKU in Shopify. The Shopify help says to delete the variants and the default. They want to continue to sell the SKU’s in their store. For example SKU 1234 has ‘’, A , and B as variants and they want to have them as1234, 1234A, and 1234B as individual SKUs
We are having problems with exporting template items that have never been synchronised before. e.g. The item on Acumatica is called C-A892:MD with a : between the Template ID (C-A892) and the SKU code (MD). When it gets created in BigCommerce it is created as C-A892-MD which doesn’t match and gives an error on the export sync ( "The synchronization could not be completed because variant items do not match the 7386 product in BigCommerce.")Is there any way to get around this other than manually going into BigCommerce after the sync fails and changing it before resyncing?Thanks for any advice, even if it’s just that we have to manually do it and there is no way around it.Phil
Is there a way to see BigCommerce “Awaiting Fulfillment” orders IN Acumatica Sales Orders without another customization? We can’t be the only customer who has the BigCommerce Plugin integration into the eCommerce edition of Acumatica? Why we can’t see the Awaiting Fulfillment orders in Acumatica baffles me.
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.