Re: Convert product.json to shopify csv template

Convert product.json to shopify csv template

Sammy9
Shopify Partner
6 0 3

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

Replies 3 (3)

GemPages
Shopify Partner
5625 1262 1248

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

GemPages - Build any high-converting store pages for any business


- If you find my reply helpful, please hit Like and Mark as Solution
- Get connected: App Store | Blog | Community | Help Center
Sammy9
Shopify Partner
6 0 3

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

antonstroberg
Shopify Partner
5 0 1

Hi Sammy - I feel your pain 🙂 

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

1. Fetch all json pages automatically and move on once there's no more json

2. 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