WP Update Post/Products from CSV import (example)

<?php
    session_start();
?>
<?php
    require_once(dirname(__FILE__)."/wp-load.php");
?>
<?php

// GET ALL DATA FROM CSV, USE WHAT WE WANT LATER
$row = 1;
if (($handle = fopen("test_csv.csv", "r")) !== FALSE) {
  while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
    if($row != 1) {
        $tag = $data[0];
        $category = $data[1];
        $sku = $data[2];
        $name = $data[3];
        $available = $data[4];
        $stock = $data[5];
        $price = $data[6];
        $published = $data[7];

        // QUERY TO DB TO GET THE POST_ID OF EACH PRODUCT BASED ON SKU
        $product_id = $wpdb->get_var( $wpdb->prepare( "SELECT post_id FROM $wpdb->postmeta WHERE meta_key='_sku' AND meta_value='%s' LIMIT 1", $sku ) );

        // UPDATE PRICE
        update_post_meta($product_id,'_regular_price',$price);
        update_post_meta($product_id,'_price',$price);
        update_post_meta($product_id,'_stock',$stock);

        // UPDATE PRODUCT TAG
        // wp_set_post_tags not working for products, use wp_set_object_terms instead
        wp_set_object_terms($product_id, array($tag), 'product_tag');

        // UPDATE PRODUCT CATEGORY
        // Gets term object from the database.
        $term = get_term_by('name', $category, 'product_cat');
        wp_set_object_terms($product_id, $term->term_id, 'product_cat');

        // UPDATE WP_POSTS TABLE DATA
        // if 0 is publish, else 1 is private
        if($published == 1) {
                    $my_post = array(
                          'ID'       => $product_id,
                          'post_title'      => $name,
                          'post_status'   => 'publish',
                          'post_modified' => date("Y-m-d H:i:s")
                      );
                } else {
                    $my_post = array(
                          'ID'       => $product_id,
                          'post_title'      => $name,
                          'post_status'   => 'private',
                          'post_modified' => date("Y-m-d H:i:s")
                      );
                }

                wp_update_post( $my_post );
    }
$row++;
}
fclose($handle);
}

?>