Build a CSV File for WooCommerce Import
Budget: $250 – $750 NZD
We have a large CSV that we need created.
It will consist of products to be uploaded to WooCommerce.
There are approximately 950 products, and around 28,000 variations.
The product data that we have is spread across 3 CSVs, which need to be combined into one and formatted as per the requirement for WooCommerce.
In addition to the formatting for WooCommerce, we have had a custom API built for our store. So the CSV needs to account for this as well. Each product has a special ID number that needs to be entered from another CSV file.
The image URLs are also a tricky one.
Currently, the CSV we have was exported from a platform that created the image URLs dynamicallly.
They are in the CSV like this: /spcimages/14822422/[COLOR_ID]/[SIZE]/1/t/prod.png
So the COLOUR_ID and SIZE is entered based on the product variation.
In our case, we only need to worry about the colour, we can use the same image for each size variation.
It will consist of products to be uploaded to WooCommerce.
There are approximately 950 products, and around 28,000 variations.
The product data that we have is spread across 3 CSVs, which need to be combined into one and formatted as per the requirement for WooCommerce.
In addition to the formatting for WooCommerce, we have had a custom API built for our store. So the CSV needs to account for this as well. Each product has a special ID number that needs to be entered from another CSV file.
The image URLs are also a tricky one.
Currently, the CSV we have was exported from a platform that created the image URLs dynamicallly.
They are in the CSV like this: /spcimages/14822422/[COLOR_ID]/[SIZE]/1/t/prod.png
So the COLOUR_ID and SIZE is entered based on the product variation.
In our case, we only need to worry about the colour, we can use the same image for each size variation.