Shopify Connector Line Item Properties

@sams,  could you provide more details? Which version are you using? The question is related to the product import or sales order import? Any screen shots? 

We had the same exact issue on a store we opened, but didn’t have time to figure out a solution. 

With another Shopify site coming soon, I would also love to see a solution, if there is one. 

@simonliang91 
Thanks for the info! Would we be customizing the e-commerce connector itself? Is there any guides for something similar you’re aware of?

Thanks again, 

Thanks for that info that’s great to have! 

I was looking at the GetExternCustomFieldValue method under the SPSalesOrderProcessor graph, I noticed the FirstOrDefault method getting called here and think it might be related to the line items properties. I haven’t done a ton of customization yet so fumbling through it lol.

But thanks again for that info that’s great to have to help learn the customization options more. I think the Salesforce connector isn’t available when I try to view it under “view business logic” so I assumed shopify would be too at first. 

@gorazem, the GetExternCustomFieldValue method uses to handle the order item properties mapping, but the main functionality is ensure the value from item property can be assigned to the correct SalesOrder detail in ERP. 

Hi @simonliang91,
Thanks for your help. I get an error message.

 

using PX.Api.ContractBased.Models;
using PX.Commerce.Core;
using PX.Commerce.Core.API;
using PX.Commerce.Objects;
using PX.Commerce.Shopify.API.GraphQL;
using PX.Commerce.Shopify.API.REST;
using PX.Common;
using PX.Data;
using PX.Objects.Common;
using PX.Objects.CS;
using PX.Objects.GL;
using PX.Objects.IN;
using PX.Objects.SO;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading;
using System.Threading.Tasks;
using PX.Objects;
using PX.Commerce.Shopify;


public class ShopifyOrderLineItem
{
    public int ShopifyLineId { get; set; } // Unique identifier from Shopify
    public List<ShopifyProperty> Properties { get; set; } // List of properties
}

public class ShopifyProperty
{
    public string Name { get; set; }
    public string Value { get; set; }
}

namespace PX.Commerce.Shopify
{
  public class SPSalesOrderProcessor_Extension : PXGraphExtension<PX.Commerce.Shopify.SPSalesOrderProcessor>
     {
        // Your method to sync Shopify order data to Acumatica

  public delegate void MapBucketImportDelegate(SPSalesOrderBucket bucket, IMappedEntity existing);
public void MapBucketImport(SPSalesOrderBucket bucket, IMappedEntity existing, MapBucketImportDelegate baseMethod)
        {
            // Example Shopify Order Data (this should come from your integration logic)
            var shopifyOrder = bucket.Order.Extern;

            // Get the Acumatica Sales Order
            var acumaticaOrder = bucket.Order.Local;

            // Loop through each line item in the Shopify order
            foreach (var shopifyLineItem in shopifyOrder.LineItems)
            {
                // Find the corresponding line item in Acumatica Sales Order
                var acumaticaLineItem = acumaticaOrder
                    .Details
                    .FirstOrDefault(line => line.LineNbr == shopifyLineItem.OrderLineItem.Properties);

                if (acumaticaLineItem != null)
                {
                    // Loop through properties of the Shopify line item
                    foreach (var property in shopifyLineItem.Properties)
                    {
                        // Assuming each property has a 'Name' and 'Value'
                        var propertyName = property.Name;
                        var propertyValue = property.Value;

                        // Map the Shopify property to Acumatica line item note
                        // Modify the following code based on your specific field mappings
                        if (propertyName == "CustomField1")
                        {
                            acumaticaLineItem.Note = propertyValue;
                        }
                        // Add more mappings as needed
                    }
                }
            }

            // Save the updated Acumatica Sales Order

        }
    }
}

This is the error
 

\App_RuntimeCode\SPSalesOrderProcessor.cs(56): error CS1061: 'OrderLineItem' does not contain a definition for 'OrderLineItem' and no accessible extension method 'OrderLineItem' accepting a first argument of type 'OrderLineItem' could be found (are you missing a using directive or an assembly reference?)

@simonliang91 
Sorry I am not very knowledgeable with the code.

Where do I insert this line? What line number?
 

await baseMethod(bucket, existing,cancellationToken);

@simonliang91 
See attached screenshot.

@simonliang91 Thank you for your help. I got the code validated and published but it is not putting the shopify line item properties in the note box.

I modified the code to get all line item properties.

using PX.Api.ContractBased.Models;
using PX.Commerce.Core;
using PX.Commerce.Core.API;
using PX.Commerce.Objects;
using PX.Commerce.Shopify.API.GraphQL;
using PX.Commerce.Shopify.API.REST;
using PX.Common;
using PX.Data;
using PX.Objects.Common;
using PX.Objects.CS;
using PX.Objects.GL;
using PX.Objects.IN;
using PX.Objects.SO;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading;
using System.Threading.Tasks;
using PX.Objects;
using PX.Commerce.Shopify;

public class ShopifyOrderLineItem
{
    public int ShopifyLineId { get; set; } // Unique identifier from Shopify
    public List<ShopifyProperty> Properties { get; set; } // List of properties
}

public class ShopifyProperty
{
    public string Name { get; set; }
    public string Value { get; set; }
}

namespace PX.Commerce.Shopify
{
  public class SPSalesOrderProcessor_Extension : PXGraphExtension<PX.Commerce.Shopify.SPSalesOrderProcessor>
     {
        // Your method to sync Shopify order data to Acumatica
    public delegate void MapBucketImportDelegate(SPSalesOrderBucket bucket, IMappedEntity existing);

    public void MapBucketImport(SPSalesOrderBucket bucket, IMappedEntity existing, MapBucketImportDelegate baseMethod)

        {
         baseMethod(bucket, existing);  
          // Example Shopify Order Data (this should come from your integration logic)
            var shopifyOrder = bucket.Order.Extern;

            // Get the Acumatica Sales Order
            var acumaticaOrder = bucket.Order.Local;

            // Loop through each line item in the Shopify order
          foreach (var shopifyLineItem in shopifyOrder.LineItems)
{
    var acumaticaLineItem = acumaticaOrder
        .Details
        .FirstOrDefault(line => string.Equals(line.ExternalRef?.Value, shopifyLineItem.Id.ToString()));

    if (acumaticaLineItem != null)
    {
        // Use reflection to get all properties of ShopifyProperty class
        var shopifyProperties = typeof(ShopifyProperty).GetProperties();

        foreach (var property in shopifyLineItem.Properties)
        {
            // Iterate through each property dynamically
            foreach (var shopifyProp in shopifyProperties)
            {
                // Get the name and value of each property dynamically
                var propertyName = shopifyProp.Name;
                var propertyValue = shopifyProp.GetValue(property)?.ToString();

                // Map the Shopify property to Acumatica line item note
                // Modify the following code based on your specific field mappings
                if (!string.IsNullOrEmpty(propertyValue))
                {
                    // Example: Map dynamically based on property name
                    switch (propertyName)
                    {
                        case "Name":
                            acumaticaLineItem.Note = propertyValue;
                            break;
                        case "Value":
                            // Handle mapping based on other property names dynamically
                            break;
                        // Add more cases for additional properties as needed
                    }
                }
            }
        }
    }
}

Let me know what I am missing

I tried something similar using your code. I’m not getting any errors, but I’m also not getting anything to work either lol. None of my trace logs are logging at all.

 

using PX.Api.ContractBased.Models;
using PX.Commerce.Core;
using PX.Commerce.Core.API;
using PX.Commerce.Objects;
using PX.Commerce.Shopify.API.REST;
using PX.Common;
using PX.Data;
using PX.Objects.Common;
using PX.Objects.CS;
using PX.Objects.GL;
using PX.Objects.IN;
using PX.Objects.SO;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Reflection;
using System.Threading;
using PX.Commerce.Shopify.API.GraphQL.DataProviders;
using System.Threading.Tasks;
using PX.Commerce.Shopify.API.GraphQL;
using PX.Objects;
using PX.Commerce.Shopify;

public class ShopifyOrderLineItem
{
    public int ShopifyLineId { get; set; } // Unique identifier from Shopify
    public List<ShopifyProperty> Properties { get; set; } // List of properties
}

public class ShopifyProperty
{
    public string Name { get; set; }
    public string Value { get; set; }
}

namespace PX.Commerce.Shopify
{
    public class SPSalesOrderProcessor_Extension : PXGraphExtension<PX.Commerce.Shopify.SPSalesOrderProcessor>
    {       

        public delegate void MapBucketImportDelegate(SPSalesOrderBucket bucket, IMappedEntity existing);
        public void MapBucketImport(SPSalesOrderBucket bucket, IMappedEntity existing, MapBucketImportDelegate baseMethod)
        {

            PXTrace.WriteInformation("MapBucketImport");         
            baseMethod(bucket, existing);

            // Get Shopify order data model
            var shopifyOrder = bucket.Order.Extern;

            // Get ERP order data model
            var acumaticaOrder = bucket.Order.Local;

            // Loop through each line item in the Shopify order
            foreach (var shopifyLineItem in shopifyOrder.LineItems)
            {
                // Find the corresponding line item in Acumatica Sales Order
                var acumaticaLineItem = acumaticaOrder
                .Details
                .FirstOrDefault(line => string.Equals(line.ExternalRef?.Value, shopifyLineItem.Id.ToString()));

                if (acumaticaLineItem != null)
                {
                    PXTrace.WriteInformation("Line Items Found!");
                    // Loop through properties of the Shopify line item
                    foreach (var property in shopifyLineItem.Properties)
                    {
                        // Assuming each property has a 'Name' and 'Value'
                        var propertyName = property.Name;
                        var propertyValue = property.Value;

                        // Map the Shopify property to Acumatica line item note

                        acumaticaLineItem.Note += propertyValue;

                    }
                } else
                {
                    PXTrace.WriteInformation("No Line Items Found");
                    acumaticaOrder.Note = "No Line Item Object found";
                }
            }

            PXTrace.WriteInformation("Exiting MapBucketImport method");
            // Need to Save the updated Acumatica Sales Order?

        }
    }
}

@gorazem This works with multiple line items. 
Thanks for you help.

@simonliang91 Thanks for your help.