How to sync Sales Order User Defined Fields at the time of Order Import from BigCommerce to Acumatica

Hi @smarenich 

Thank you for the response.

Actually, here I do not want to create a new field but wants to use Sales Order header User Defined Fields to store some data.

Suppose BiCommerce order notes has some message like: “Deliver to xyz location”.

Now this BiCommerce order notes, I want to updated in one of the User Defined Fields (that will be basically a Text type Attribute) at the time of order import.

Hi @vivekm, Thanks for the question. 

You can do this from Entities(BC202000) form. I assume these UDF fields are for the entire order and not for a line item. For order import, you can choose Connector as BigCommerce and the required Store and Entity as Sales Order in the Summary Section of the entities form and then map these fields with the required field from BigCommerce in the Import Mapping tab. Off course, if needed you could even create formulas in the Source Field/Value field and select the value from UDF field combo box based on the formula’s result. The below screenshots are from 2021R1.

Vivekm,

You can try to use Substring function in the mapping. In case you have clear criteria you can do it.

If not, than you need to parse string with the code similar to my previous link.

Hi @smarenich @KarthikGajendran 

Thank you for the inputs.

We are not sure about Notes structure and the occurrence of details in the notes, as if certain data is not available to BigCommerce order that will not be the part of order notes, and in this case the mapping option will not be suitable.

Can you please suggest any option to access UDF fields to MapBucketImport() method (on BCSalesOrderProcessor graph) or Sales Order graph.

Also, can you please share a sample to use Substring function and parse string in the mappings for our knowledge base.

Hi @smarenich 

I tried to implement similar to custom fields but getting error like: “Field with viewname=Document and fieldname=STAFFNOTES does not exist” at the time of order import.

Please find below details for review and suggest:

• Code Implementation.

public delegate void MapBucketImportDelegate(BCSalesOrderBucket bucket, IMappedEntity existing);
        [PXOverride]
        public void MapBucketImport(BCSalesOrderBucket bucket, IMappedEntity existing, MapBucketImportDelegate baseMethod)
        {
            baseMethod(bucket, existing);         

            MappedOrder obj = bucket.Order;
            OrderData data = obj.Extern;
            SalesOrder impl = obj.Local;

            impl.Custom = new PX.Api.ContractBased.Models.CustomField[]
                    {
                                new CustomStringField()
                                {
                                     ViewName = "Document",
                                     FieldName = "StaffNotes", //Field name also tried as “STAFFNOTES”                                                                                             //  (AttributeID) and  as                                                                                                                             // “Staff Notes” (Attribute Description)
                                     Value = impl.Note.ValueField()
                                }
                    }.ToList();          
        }

• Attribute used as UDF on Sales Order screen

• Order Import

Hi @smarenich,

The suggested modification worked as expected.

Thanks so much!