The standard n8n Shopify node only supports a few Shopify REST API endpoints. Because the Shopify REST API is already deprecated, I highly recommend using the Shopify GraphQL API instead. This gives you the full power of the entire Shopify API.
In addition, you can use the bulk features to fetch and update thousands of products or orders without hitting the rate limit or using pagination and cursors.
Watch the YouTube video on how to install my n8n Shopify community node, and use it to call the Shopify GraphQL API and use its bulk features.