You have chosen to sponsor your bid up to a maximum amount of .
We have an input CSV that has a few thousand products. They are all variable products and have a lot of attributes. We need a freelancer to write a script that will allow us to import said CSV into the database.
The script we have at the moment works for some products but because some products have multiple attributes, this leads to 40,000 variations of the one product and therefore MySQL dies when trying to use wp_insert_post 40,000 times! Please note that every product variation must be inserted as a variation. For example a product that has 3 colours will need 4 entries in the database (the original product and 3 variations).
My recommendation is to write a script that converts the CSV into SQL insert statements rather than using wp_insert_post or any wordpress function and that way we can be sure that the import will succeed.
Please do not apply if you do not understand Jigoshop/Woocommerce.