Shopify CSV to WooCommerce Format Converter
Budget: $10 – $30 USD
Project Title:
Python Script in Google Colab to Convert Shopify CSV to WP All Import Format (WooCommerce)
Project Goal:
Create a Python script (running in Google Colab) that transforms Shopify product CSV files into a clean, fully compatible WooCommerce format for direct import via WP All Import — with no errors and using the exact required structure.
Scope of Work:
Develop a Python script that:
Processes Shopify CSVs.
Outputs a WooCommerce-ready CSV for WP All Import.
Runs in Google Colab ( mandatory).
Removes all unused or extra Shopify columns automatically.
Maintains the structure required by WP All Import.
Required Output Format:
The output CSV must include exactly these 17 columns, in this order:
nginx
Copy
Edit
handle
title
bodyhtml
vendor
tags
option1name
option1value
option2name
option2value
option3name
option3value
variantsku
variantinventoryqty
price
variantcompareatprice
imageposition
imagesrc
Note: We intentionally excluded the type column. Do NOT include it in the final output.
Each product must be structured with:
One parent row (same handle).
One row per variant.
Maximum of 4 images per product (1 main + up to 3 variants).
Proper grouping by handle for WP All Import to process variations correctly.
Image URL Replacement (Multi-Supplier Logic):
Shopify image URLs must be fully replaced with our BunnyCDN path.
The script must allow setting a custom base_url like:
python
Copy
Edit
base_url = "https://orcadealmedia.b-cdn.net/fragrancenet/fragrance/"
Then, for each image:
Strip the original Shopify URL.
Keep only the filename.
Build the final path:
ruby
Copy
Edit
https://orcadealmedia.b-cdn.net/fragrancenet/fragrance/123456.jpg
Important: Do NOT hardcode folder names. The base_url must be editable so we can reuse the script for other suppliers.
All image filenames are already clean (lowercase, no spaces or special characters).
Technical Requirements:
Python script (clean, readable, reusable code).
Must run smoothly on Google Colab.
100% match with the required CSV structure — no missing or renamed columns.
Final file must import directly into WP All Import with no errors.
Critical Notes:
We’ve had major issues with freelancers modifying field names, skipping fields, or misaligning structures.
Do not apply if you’re unsure about WP All Import compatibility or CSV logic.
You may be asked to run a test with 3 sample products to prove the script works before full approval.
Bonus:
If the script works well, we’ll likely expand the task across multiple suppliers, so this could lead to ongoing projects.
Final Reminder:
This is not a trial-and-error job. We only want experts who fully understand the format, structure, and WP All Import behavior. Respecting every detail is key.
Python Script in Google Colab to Convert Shopify CSV to WP All Import Format (WooCommerce)
Project Goal:
Create a Python script (running in Google Colab) that transforms Shopify product CSV files into a clean, fully compatible WooCommerce format for direct import via WP All Import — with no errors and using the exact required structure.
Scope of Work:
Develop a Python script that:
Processes Shopify CSVs.
Outputs a WooCommerce-ready CSV for WP All Import.
Runs in Google Colab ( mandatory).
Removes all unused or extra Shopify columns automatically.
Maintains the structure required by WP All Import.
Required Output Format:
The output CSV must include exactly these 17 columns, in this order:
nginx
Copy
Edit
handle
title
bodyhtml
vendor
tags
option1name
option1value
option2name
option2value
option3name
option3value
variantsku
variantinventoryqty
price
variantcompareatprice
imageposition
imagesrc
Note: We intentionally excluded the type column. Do NOT include it in the final output.
Each product must be structured with:
One parent row (same handle).
One row per variant.
Maximum of 4 images per product (1 main + up to 3 variants).
Proper grouping by handle for WP All Import to process variations correctly.
Image URL Replacement (Multi-Supplier Logic):
Shopify image URLs must be fully replaced with our BunnyCDN path.
The script must allow setting a custom base_url like:
python
Copy
Edit
base_url = "https://orcadealmedia.b-cdn.net/fragrancenet/fragrance/"
Then, for each image:
Strip the original Shopify URL.
Keep only the filename.
Build the final path:
ruby
Copy
Edit
https://orcadealmedia.b-cdn.net/fragrancenet/fragrance/123456.jpg
Important: Do NOT hardcode folder names. The base_url must be editable so we can reuse the script for other suppliers.
All image filenames are already clean (lowercase, no spaces or special characters).
Technical Requirements:
Python script (clean, readable, reusable code).
Must run smoothly on Google Colab.
100% match with the required CSV structure — no missing or renamed columns.
Final file must import directly into WP All Import with no errors.
Critical Notes:
We’ve had major issues with freelancers modifying field names, skipping fields, or misaligning structures.
Do not apply if you’re unsure about WP All Import compatibility or CSV logic.
You may be asked to run a test with 3 sample products to prove the script works before full approval.
Bonus:
If the script works well, we’ll likely expand the task across multiple suppliers, so this could lead to ongoing projects.
Final Reminder:
This is not a trial-and-error job. We only want experts who fully understand the format, structure, and WP All Import behavior. Respecting every detail is key.