How to remove compareAtPrice ProductVariantsBulkUpdate

[mtbd-ljceranic]

Hey there,

I am trying to do a productVariantsBulkUpdate mutation to remove a compareAtPrice (setting it to null), but it seems to be ignored. Possibly json serialization excluding any properties that are null?

Just wondering what the best way is to remove a compare at price on a variant?

var productVariantsBulkUpdateInputList = new List<ProductVariantsBulkInput>();
var productVariantsBulkUpdateInput = new ProductVariantsBulkInput
{
    id = productVariant.id,
    price = itemPrice,
    compareAtPrice = null
};
productVariantsBulkUpdateInputList.Add(productVariantsBulkUpdateInput);

var graphRequest = new GraphRequest
{
    Query = """
            mutation ($productId: ID!, $variants: [ProductVariantsBulkInput!]!){
                productVariantsBulkUpdate(
                  productId: $productId
                   variants: $variants
                ) {
                    __typename
                    product {
                        __typename
                        id
                    }
                    userErrors {
                        __typename
                        field
                        message
                        code
                    }
                }
            }
            """,
    Variables = new Dictionary<string, object>
    {
        { "productId", shopifyProduct.id },
        { "variants", productVariantsBulkUpdateInputList }
    }
};

await graphService.PostAsync<ProductVariantsBulkUpdateResult>(graphRequest);

[olivierp9]

Got exactly the same issue...
@mtbd-ljceranic did you find a work around?

[nozzlegear]

Hey! Sorry, I've been super busy and haven't had much time to look into things lately. I agree this is very likely a serialization issue; the serializer is likely following the REST serializer's rules, so when it sees null it will decide not to send anything.

I have some ideas on how to fix this, but a quick and dirty fix would be sending a custom class that inherits from ProductVariantsBulkInput like so:

public record CustomProductVariantsBulkInput : ShopifySharp.GraphQL.ProductVariantsBulkInput
{
    /// <summary>
    /// The compare-at price of the variant.
    /// </summary>
    [System.Text.Json.Serialization.JsonPropertyName("compareAtPrice")]
    [System.Text.Json.Serialization.JsonIgnore(Condition = JsonIgnoreCondition.Never)]
    public new decimal? compareAtPrice { get; set; } = null;
}

And you'd use it like this:

var productVariantsBulkUpdateInputList = new List<CustomProductVariantsBulkInput>()
{
  new CustomProductVariantsBulkInput
  {
    id = productVariant.id,
    price = itemPrice,
    compareAtPrice = null
  }
};

var graphRequest = new GraphRequest
{
    Query = yourGraphQuery,
    Variables = new Dictionary<string, object>
    {
        { "productId", shopifyProduct.id },
        { "variants", productVariantsBulkUpdateInputList }
    }
};

await graphService.PostAsync<ProductVariantsBulkUpdateResult>(graphRequest);

The key here is adding that JsonIgnore(Condition = JsonIgnoreCondition.Never) attribute to compareAtPrice.

Give that a try @mtbd-ljceranic, @olivierp9 and let me know if it fixes the problem?

[olivierp9]

@nozzlegear worked on my end! thanks!

[mtbd-ljceranic]

Thanks a lot for the reply @nozzlegear ! Appreciate the assistance