How to map PreOrder date from Acumatica to BigCommerce using Commerce Connector

  • 23 October 2020
  • 0 replies

Userlevel 7
Badge +3
  • Acumatica Commerce Edition Team Lead
  • 227 replies

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]))


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!

0 replies

Be the first to reply!


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved