Convert product.json to shopify csv template

Shopify Discussion
1

If anyone has script to convert product.json into correctly Shopify CSV template please help

2

Hello @Sammy9

I hope this blog can help : https://stackoverflow.com/questions/48445131/converting-shopify-api-json-to-csv

I hope the above is useful to you.
Best regards,
GemPages Support Team

3

This is incomplete and the code is not even working so many error

4

Hi Sammy - I feel your pain :slightly_smiling_face:

This was a bit of a hustle for us (developing shopify apps and needing various amounts or different products) so I made a script for it - it’s on git if you want to use it.

https://github.com/antonstroberg/Shopify-JSON-to-CSV-Converter

What you need:

You will need python3.x and requests - hopefully clear in readme file.

What it does:

Once you run the script you will be asked for a domain.

  1. Enter domain - For example yourdomain.com - avoid https etc. just domain

  2. Fetch all json pages automatically and move on once there’s no more json

  3. Convert it to csv files splitted into 1000 products per csv - this to ensure it keeps it under 15mb (shopify limit)

Hope it helps. Let me know if there’s problems.

Kind Regard

Andreas / Stackend.com