bulkOperationRunMutation productCreate with variants

Retired Boards Appdev Graphql Basics And Troubleshooting
1

Hello,

I’m trying to use bulk import to create products but Shopify returns an error for each “variants” field saying:

Field ‘xxx’ doesn’t exist on type ‘ProductVariantConnection’.

Assume the jsonl file was successfully uploaded.

This is my Query part:

mutation bulkOperationRunMutation($mutation: String!, $stagedUploadPath: String!) {
     bulkOperationRunMutation(mutation: $mutation, stagedUploadPath: $stagedUploadPath) { 
          bulkOperation { id url status } userErrors { field message }}}

This is my Variables part:

"mutation": "mutation call($input: ProductInput!) { productCreate(input: $input) {
     product { title productType vendor tags options { name } variants { price weight sku options { values } } } 
     userErrors { message } } }",
"stagedUploadPath": "tmp/xxxxx/bulk/xxx-80f2-46ff-a5da-5aadd83/myfile.jsonl"

And this is an example jsonl file:

{ "input": { "title": "Product Title", "productType": "ANYTYPE", "vendor": "The Vendor", "tags": "dddd, eee,ggg", "options": ["Size", "Color"], "variants": [ { "price": "111", "weight": 1, "sku": "4444444", "options": ["S", "Rainbow"] }, { "price": "222", "weight": 1.3, "sku": "bbb", "options": ["S", "Blue"] }, { "price": "333", "weight": 1.3, "sku": "tttt", "options": ["M", "Pink"] } ] } }

The Response is:

{
    "data": {
        "bulkOperationRunMutation": {
            "bulkOperation": null,
            "userErrors": [
                {
                    "message": "Invalid Bulk Mutation Field - Field 'price' doesn't exist on type 'ProductVariantConnection'"
                },
                {
                    "message": "Invalid Bulk Mutation Field - Field 'weight' doesn't exist on type 'ProductVariantConnection'"
                },
                {
                    "message": "Invalid Bulk Mutation Field - Field 'sku' doesn't exist on type 'ProductVariantConnection'"
                },
                {
                    "message": "Invalid Bulk Mutation Field - Field 'options' doesn't exist on type 'ProductVariantConnection'"
                }
            ]
        }
    },
    "extensions": {
        "cost": {
            "requestedQueryCost": 10,
            "actualQueryCost": 10,
            "throttleStatus": {
                "maximumAvailable": 1000.0,
                "currentlyAvailable": 990,
                "restoreRate": 50.0
            }
        }
    }
}

If I don’t use the ‘variants’ part, the BulkOperation runs fine (obviously removing the ‘variants’ part in jsonl file).

What am I missing?

2

Hey Bro!
Have you done that ?
i need your help I am doing the same thing but i didn’t able to upload JSONL file to shopify can i get some example code for it?
Thanks in advance God Bless u

1 Like
3

Hi @syedusama0786 :waving_hand:

The variables containing the mutation needs to connect to the variant edges/nodes as shown below:

mutation($input: ProductInput!) {
    productCreate(input: $input) { 
        product {
            id
            variants {
                edges {
                    node {
                        id
                    }
                }
            }
        }
    }
}

I’d recommend using our codelabs workshop here that contains example code to help streamline the bulk mutation upload process.

Hope that helps!

4

HEY BRO @ShopifyDevSup !
Thanks, bro for your time. I am very grateful.
I see codelabs workshop I done the same thing but I got an error as I adding a pic.

syedusama0786_0-1674676785975.png
syedusama0786_0-1674676785975.png789×341 31.5 KB

and the code for my bulk Mutation after uploading the JSONL File is:

const BULK_OPERATION = mutation { bulkOperationRunMutation( mutation: "mutation call($input: ProductInput!) { productCreate(input: $input) { product {id title variants(first: 10) {edges {node {id title inventoryQuantity }}}} userErrors { message field } } }", stagedUploadPath: "tmp/21759409/bulk/89e620e1-0252-43b0-8f3b-3b7075ba4a23/bulk_op_vars") { bulkOperation { id url status } userErrors { message field } } }

try {
const resp = await client.query({
data: {
query: BULK_OPERATION,
},
});
} catch (error) {
if (error instanceof GraphqlQueryError) {
throw new Error(
${error.message}\n${JSON.stringify(error.response, null, 2)}
);
} else {
throw error;
}
}
PLEASE GUIDE ME WHAT CAN I DO AND WHAT IS THE ISSUE WITH THIS CODE.