Retail Edition QnA
Recently active
Hello, Could you please help me with the following issue?When trying to import sales order and credit card payment from Shopify to Acumatica, I get the following error: “Inserting 'Sales Order Adjust' record raised at least one error. Please review the errors.PrepaymentInvoiceRefNbr: 'PPI Nbr.' cannot be empty.”I follow the instructions from the training: V210 COMMERCE EDITION (SHOPIFY CONNECTOR) 2021 R1Have any of you already solved this problem or have an idea what it could be due to?Thank you in advance for any advice!
It might be extremely useful to get automated notification when some synchronization process has been aborted after a pre-defined amount of attempts. We have created several default business events that will automatically send the email notifications:Aborted Order. Aborted Refund. Aborted Shipment. Aborted Payment.These events will be available at version 2021R2.All of them are not active by default.To activate them open Business Events form (SM302050) and select one of these events (for ex., Aborted Order) and check the Active checkbox: That’s it! Next time when the synchronization of the entity (Sale Order in our example) will turn status to Aborted the automatic notification will be sent to the Store Admin email address which is set in the respective Stores forms BC201000, BC201010: The notification could be found in All Emails (CO409070): When you click the respective link on the All Emails form, you may see how the email notification itself looks like:
Acumatica Commerce Edition Overview July 15, 202110:00 am - 10:30 am PSTRegister now.Join us for a 30-minute webinar where you will hear an overview of Acumatica Commerce Edition. In addition, you will see a short demo and learn how to create online success with a streamlined back-office system powered by robust ERP software. Discover how you can start increasing the success of your eCommerce business today! Register now
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.
We need customers to be in more than one Acumatica Customer Price Class for when we sync to Big Commerce. We need one Customer Price Class for a 10% discount on Item Class A, and one Customer Price Class for a 15% discount on Item Class B. Our issue is that when we sync to Big Commerce, we seem to be able to put a customer in only one Customer Price Class (called Customer Group in Big Commerce). Does anyone know how to put a customer in two Customer Groups in Big Commerce?
As a long time user of BigCommerce and a relatively new adopter of Acumatica, curious if anyone has developed a best practice for handling changes to product variants and getting those changes to sync properly between Acumatica and BigCommerce. Example: Product A initially set up with option for colors Green, Blue, and Red. Manufacturer drops Red and replaces with Yellow. Thus far I have tried a) removing the depreciated SKU as a matrix item from the template item and adding the new matrix SKU to the template and syncing - error, b) same process but deleting the depreciated SKU from BigCommerce first - error, and c) same process but deleting all SKU variants from BigCommerce first - error. To resolve a time sensitive issue, I essentially deleted the item from BigCommerce and started over by pushing the template w/ associated matrix items back to the store and updating key fields from a prior export, which is not a viable maintenance strategy. Any BC store owners have a good workflow
BigCommerce and Acumatica: A Unified Ecommerce & ERP Solution for B2C Companies Thursday, June 17, 2021 10:00 AM Pacific Daylight Time 1 hourAs customer expectations rise around the entire shopping experience, the competition has also increased, making it difficult for organizations to get by with legacy commerce and ERP systems. The market has shifted tremendously, and B2C eCommerce has seen exponential growth over the past year, making legacy commerce and ERP systems inadequate to support the pace of modern business. Integrate your BigCommerce storefront with Acumatica’s ERP and elevate your customers' experience, gain greater insight into your business, and drive exponential revenue with a unified commerce platform from Acumatica and BigCommerce.Join Josh Fischer (Senior Manager, Product Management at Acumatica), Koy McDermott (Manager, Strategic Partnerships at BigCommerce), Dave Munson (CEO at Saddleback Leather) and Shawn Wyatt (Director of IT at Saddleback Leather) as the
Acumatica Commerce Edition Overview WebinarJune 24, 2021 10:00 am - 10:30 am PST Join us for a 30-minute webinar where you will hear an overview of Acumatica Commerce Edition. In addition, you will see a short demo and learn how to create online success with a streamlined back-office system powered by robust ERP software. Discover how you can start increasing the success of your eCommerce business today!Register now.
Hello Everyone,I want to sync Stock Item Attribute (combo/multi-select combo) Value Description instead of Attribute Value ID at the time of Stock Item Sync from Acumatica to BigCommerce as custom field name and value.From Entity Mapping it is not possible, so I did a customization but observed that one attribute value, updating across all other custom field values.Please find below sample code and screenshots for reference.Sample Code:public class KNBCStockItemProcessorExt : PXGraphExtension<BCStockItemProcessor> { public delegate object GetAttributeDelegate(BCStockItemEntityBucket bucket, string attributeID); [PXOverride] public object GetAttribute(BCStockItemEntityBucket bucket, string attributeID, GetAttributeDelegate baseMethod) { MappedStockItem obj = bucket.Product; StockItem impl = obj.Local; impl.Attributes?.Where(x => string.Equals(x?.AttributeDescription?.Value, attributeID, StringComparison.Inva
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?
Is it possible to map a specific tag to a custom field? I can see that you can import tags (in general) to something in Acumatica, but we really just want to set a command where “if a tag contains a ‘#’ then import to a specific custom field”The number we want to bring in is our Amazon sales #Our Amazon sales flow into shopify and then Acumatica. It works great except for lack of order number. Thanks for any help!
This article will be focused on the specifics synchronization used in the Acumatica Commerce Edition for Shopify and BigCommerce connectors.First, lets define the synchronization process - Synchronization of any entity in Acumatica Commerce edition happens in 2 steps: Preparation and Processing.Preparation is a process when Acumatica gets information that any entity requires a synchronization (ex, new order has been created or product has been updated). When information is received, connector needs to create a record in the Sync History screen, logging that the record has been received and pending sync. Processing is a process when Acumatica loads one single record and synchronizes it from one system to the other. As part of the processing, connector will perform some addition steps: getting record from both systems, fields mapping from source to the destination system, user defined mapping processing, error validations, duplicate validations, saving the record to the destination syste
Acumatica Commerce Edition Overview Tuesday, May 25, 2021 10:00 AM Pacific Daylight Time 45 minutesRegister Here.Acumatica is a company on a mission! We are a leading innovator in cloud ERP with customers located around the world. Acumatica ERP delivers adaptable cloud and mobile technology with a unique all-inclusive user licensing model, enabling a complete, real time view of your business anytime, anywhere.Hear a company overview followed by a product demo highlighting Acumatica Commerce Edition.Find out why more mid-sized companies are choosing Acumatica as their ERP solution.
Has anyone seen issues with prices going to $0 and no longer syncing in build 116 of the Big Commerce connector? After reverting back to 115 we were able to get prices to sync again.Thanks,Kurt Bauer
Acumatica Commerce Edition Overview Tuesday, April 27, 2021 10:00 AM Pacific Daylight Time 45 minutesRegister HereAcumatica is a company on a mission! We are a leading innovator in cloud ERP with customers located around the world. Acumatica ERP delivers adaptable cloud and mobile technology with a unique all-inclusive user licensing model, enabling a complete, real time view of your business anytime, anywhere.Hear a company overview followed by a product demo highlighting Acumatica Commerce Edition.Find out why more mid-sized companies are choosing Acumatica as their ERP solution.
Hi Team,We have a requirement where we want so sync some BigCommerce order details to Acumatica Sales Order User Defined Fields at the time or order import.Can someone suggest the possible way to achieve this. Thank you in advance !
How do you get the product barcodes to show on sales order screen? There is an alternativeID column on this screen, but there appears to be no way to influence what alternative ID (if any) goes into this column?
Acumatica Commerce Edition Overview WebinarMarch 25, 2021 10:00 am - 10:30 am PSTJoin us for a 30-minute webinar where you will hear an overview of Acumatica Commerce Edition. In addition, you will see a short demo and learn how to create online success with a streamlined back-office system powered by robust ERP software. Discover how you can start increasing the success of your eCommerce business today!REGISTER NOWMarch 25, 2021 Register Here
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.
We are struggling to set up Auto Sync. Since we went live in October 2020, we have been syncing manually due to sync issues. We have the sync issues solved now and want to set up Auto Sync. Can you help us set up Auto Sync?
While testing a customer integration with BigCommerce, we have some items on our BigCommerce site that are actually cross referenced to existing items in Acumatica. If we try to sync an order that uses that cross reference it doesn't recognize the item during the sync. On the following support case we were told this was reviewed with the commerce team and as of now there is no support for Cross References. (Case #169121)
If it does, how does Acumatica throttle its use of the API? Will it use all available resources in the Shopify's “Leaky Bucket” or is this adjustable?
We have built-in functionality, that sets items to ‘invalid’ status if that item have some parameters preventing it’s synchronization (i.e. sales order has wrong status in external or internal system, customer is a guest in store settings, etc.). Ideally, we would want to be able to execute those settings on all entities, even those that already synchronized. Unfortunately, currently this restrictions can only be executed on new items, that have not been synchronized to other system.The current design of the restrictions would cause a problems for an item status resolution if we would allow restricting of items existing in both systems. Since fetch procedure is initiated from internal or external system, for bidirectional entities the same item could go to ‘invalid’ or ‘pending’ status - based on the direction of the fetch procedure. If the item is modified externally, and in external system object has a status preventing sync process, it will go ‘invalid’ and will have an error messag
Gift Certificate/Gift Card: It is a non taxable non stock item which is associated with a unique code every time the customer buys it. This is maintained at the eCommerce site. User FlowCustomer buys the Gift Certificates in eCommerce site for $100.00 and also a Acer Laptop. eCommerce site assigns a unique code to each Gift Certificate. Eg: “16R-K2A-18X-5YL” Gift Certificates/Gift Cards are imported using a Generic Non Stock Item that is provided in the Commerce Connector Store Settings form under the Order Settings tab. Sales Order with the Gift Certificate as a item. Please see the below screenshots. Numbered referencing the above points. Gift Certificate/ Gift Card Payment: Once a Gift Certificate is bought by a customer, then the customer can use it to buy products on the eCommerce site as it is created like a Credit Card. The eCommerce site will validate the Gift Certificate unique code when the order is paid using the Gift Certificate. User FlowCustomer places the order usin
Acumatica does not a have Pre-Order date field on the Stock Item, but if Pre-Order is part of your business processes you can easily solve it suing an Attributes at the Item.But how to transfer it to the BigCommerce store? Here is the guide how can use use Commerce Entities mapping feature to map an Acumatica Attribute to BigCommerce API field:The Pre-Order Release Date should have following formula:=Year(CDate([StockItem -> Attributes.Product Purchase Date]))+'-'+Month(CDate([StockItem -> Attributes.Product Purchase Date]))+'-'+Day(CDate([StockItem -> Attributes.Product Purchase Date]))+'T00:00:00+00:00’ Also do not forget to define proper status on the e-Commerce Tab After sync, you will be able to see that this field is populated in BigCommerce:Hope it helps!
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
