Woocommerce Import Plugin/Script

I need someone to write a simple script or plugin that will take a csv file similar to the attached and upload it to the product section of a woocommerce website. I need to be able to utilize this script or plugin on multiple woocommerce sites so however it is coded needs to be universal. Be able to assign which column contains which info would be an added plus. This script could potentially be importing thousands of rows so needs coded properly so as to not experience timeout issues.

Specifically, I need the following columns to be imported:

• Column B “Punctuated Part Number” to import into the SKU section of Woocommerce. However, I need it to be none punctuated but still the full length. IE if sku is “0012-3456” I need it to import into woocommerce as “00123456”.

• Column D “partDescription” needs to import into the product Title or Product Name field.

• Column F “brandName” needs to import into the product Brand field.

• Column G “suppliernumber” needs to import into the MPN field of the product.

• Column K “baseretailprice” needs to import into the price field of the product.

• Column M “partimage” this has a few more steps than the rest. This link will download a zipped file which could contain one or multiple images. This needs to be download, extracted, and then all images needs attached to the woocommerce product accordingly.

• Column Q-AN “bullet##” these fields are all bullet points that need to be imported into the product description with bullet points. If the field is blank then it can be skipped and no bullet point should be included for the blank field. Every product will have a different number of bullet points so the script should review these fields and skip if blank but insert the content with a bullet point into the item description if content exists.

WooCommerce PHP Plugin MySQL

Project ID: #29496049

About the project