BigCommerce Bulk Product Import CSV Creation

Job ID: 38698230

Budget: $30 – $250 USD

I'm looking for a skilled freelancer to create a CSV file that can be uploaded to BigCommerce for bulk product import. The file will include multiple product options, sizes, and colors. Each product will need to have an image which will be provided from their google drive link. The google drive folder that contains the folder and images for each product contains thousands of images (about 4,000).

Here;s what I need:
Product Variations
Size:
New Borns- NB (Onesie), 6M (Onesie), 12M (Onesie), 18M (Onesie)
Toddlers - 2T, 3T, 4T, 5T
Youth - X-Small, Small, Medium, Large, X-Large,
Adult - Small, Medium, Large, X-Large, 2x-Large, 3x-Large

Price Adjustments:
Adult 2x-Large - +$2 for tees, +$4 for hoodies)
Adult 3x-Large - +$3 for tees, + $5 for hoodies)


Product Types:
Premium Tees - All sizes (NB - 3x-Large)
Hoodies - Youth and Adult sizes only

Colors: Black, White, Sports Grey, Red, Blue, Pink

*Freelancer will turn each file in the folder into a product while maintaining the folder structure which will turn each folder into a "product category" ie one product is in the file Washington Wizards which is inside the file NBA. Therefor I would like that file to be in the category of "Washington Wizards" which will be a subcategory of "NBA".

As a reference I'd like the product pages to look somewhat like this page, but more pleasing is always welcomed.
monmouthprintshop.com/test-update/?showHidden=true&ctk=493eec0f-4067-485e-8ea9-5ebb0c26a455


Please note:
You should be familiar with BigCommerce's product import and export process
Experience with CSV file formatting and eCommerce platforms is a must
A basic template is available, but you should probably know how to make your own script to automate the process.

If you think your a good fit, please apply and share relevant experience or past projects.