How can i add 200000 products into shopify using make? What are the limitations of make in terms of bandwidth and data processing?

Hi,

I have a case where i need to add around 200000 products in to shopify using make.com. Its basically a scenario that adds new products. As of now the products are in the form of JSON and XML and the file size is more than 200mb having almost 2miliion characters which needs to be formatted and mapped properly to each field in the shopify create a product module.

Till now i have tried hosting it on many drives and platforms then accessing the JSON file and then processing it using different modules. I have tried getting data as XML from the url as well.
I know its very difficult to process such data, but my client wants me to do it using make. Also, the client is ready to buy more operations so that we can get larger files but i am not sure if that would solve the issue of processing such large datasets.

Is there any way around it or anyone knows any way to bulk upload products into shopify without make?

Secondly i wanted to know the limitations of make.com like

  • How many characters can i put into any text field in make.com like parse JSON and other text fields in general.
  • If i find any way to process the data and run the scenario can a scenario run for multiple days nonstop till the job is finished. Or will it break midway

Do let me now if anyone has any information on this or any kind of documentation or whatever i am trying to do makes no sense.