How to create a custom field in BigCommerce and map it with a field in Acumatica using Acumatica Commerce Connector?

Hello! Is it possible to do this with template items instead? I’ve tried using the same methods here and it doesn’t seem to work :(

*edit: never mind, I figured it out and you can. pls ignore!

Karthick, is it possible to map to a BigCommerce “meta field” instead of a custom field? We have a use case where this would be needed, as custom fields have a much lower character limit than meta fields.

@geoffreym Sorry, for now, we do not have this feature out of the box. You need a customization to achieve this. 

Is there something I need to do to get my from field from BC to show in the Entities screen so I can map it. @KarthikGajendran 

@lrains Sorry currently, we do not support array of objects. Meaning, many to one. 

A sales order can have one or more custom fields like Employee ID, Customer PO, Customer Notes etc., In order to import these we need to mention the Name and Value. Name would be Employee ID and Value would be “JohnDoe1234”. Currently, we cannot map two fields(Name and Value) from external system to one field in Acumatica. 

This can be achieved only using a customization where you can target the required name and its value. 

Hi @KarthikGajendran 

We have the following Customer Form fields defined in BigCommerce.  

But when we go to the Import mapping section, these are not loading there.  

 When we go into the Import mapping and try to load up the dropdown, nothing is showing up. 

Do we need to do anything specific here?  The customer instance is on version 21R2 build 210. 

@KarthikGajendran Does this mapping support for Customer Address form fields (for Customer Location sync)? In 2022 R2 this seems to be not working.

Hi @KarthikGajendran ,

Can you share an example of the customization code to map a BC custom address field to the Sales Order header in Acumatica?  It is the same scenario that @lrains described above.

Thanks in advance!

@lauraj46  I will ask one of the developers to look into this thread. 

Hi @KarthikGajendran ,

Were you able to find an example of the customization code to map a BC custom address field to the Sales Order header in Acumatica?

Thanks,

Laura

hi @lauraj46 and @KarthikGajendran,

Here is an example of mapping form field to a Sales order description.

using PX.Commerce.Core;
using PX.Data;
using System.Linq;
using System.Threading.Tasks;
using System.Threading;
using Newtonsoft.Json.Linq;

namespace PX.Commerce.BigCommerce
{
	public class BCCustomerFormField_Extension : PXGraphExtension<PX.Commerce.BigCommerce.BCSalesOrderProcessor>
	{
		public static bool IsActive() => CommerceFeaturesHelper.BigCommerceConnector;
		public delegate Task MapBucketImportDelegate(BCSalesOrderBucket bucket, IMappedEntity existing, CancellationToken cancellationToken);
		[PXOverride]
		public async Task MapBucketImport(BCSalesOrderBucket bucket, IMappedEntity existing, CancellationToken cancellationToken, MapBucketImportDelegate baseMethod)
		{
			await baseMethod(bucket, existing, cancellationToken);
			string externOrderJson = bucket.Order.Extern.JSON;
			bucket.Order.Local.Description = GetBillingCustomFormField(externOrderJson, "EmployeeID").ValueField();

			return;
		}

		private string GetBillingCustomFormField(string jSON, string formFieldToFind)
		{
			JObject obj = JObject.Parse(jSON);
			JArray formFields = (JArray)obj["billing_address"]["form_fields"];

			foreach (JObject formField in formFields.Cast<JObject>())
			{
				if (formField["name"].ToString() == formFieldToFind)
				{
					return formField["value"].ToString();
				}
			}

			return string.Empty;
		}
	}
}

Thanks @gabrielpaz86 !