{"id":1221,"date":"2013-06-19T08:16:08","date_gmt":"2013-06-19T08:16:08","guid":{"rendered":"http:\/\/www.websitedesignwebsitedevelopment.com\/?p=1221"},"modified":"2014-03-19T09:13:41","modified_gmt":"2014-03-19T09:13:41","slug":"woocommerce-csv-importer-resume-feature","status":"publish","type":"post","link":"https:\/\/androidbubble.com\/blog\/website-development\/php-frameworks\/wordpress\/plugins\/woocommerce-csv-importer-resume-feature\/","title":{"rendered":"Woocommerce CSV importer – Resume Feature"},"content":{"rendered":"

Woocommerce CSV importer – Resume Feature<\/h2>\n


\nif(!function_exists('wce_gallery_resume')){
\n\tfunction wce_gallery_resume($post_id){
\n\t\t\t$files = array();
\n\t\t\t$check_image = get_post_meta($post_id, '_product_image_gallery', true);
\n\t\t\t$check_image = is_array($check_image)?$check_image:explode(',',$check_image);
\nif(!empty($check_image)){
\n\t\t\t\tforeach($check_image as $image){
\n\t\t\t\t\t$i = basename(get_post_meta($image, '_wp_attached_file', true));
\n\t\t\t\t\t$files[$i] = $image;
\n\t\t\t\t}
\n\t\t\t}
\n\t\t\treturn $files;
\n\t\t}
\n\t}<\/code><\/p>\n

How to use this?<\/h3>\n
    \n
  1. Locate this file “include\/woocommerce-csvimport-functions.php”<\/li>\n
  2. Locate function “woocsv_import_products_from_csv”<\/li>\n
  3. Locate this line “if ( isset( $data[13] ))” around line no. 242<\/li>\n
  4. And insert this line $images_exist = wce_gallery_resume($post_id);<\/code>inside IF CONDITION<\/li>\n
  5. Update the next line too as woocsv_add_featured_image ( $post_id , $data[13], $dir, $images_exist );<\/code><\/li>\n
  6. Don’t forget to update this function too for a new parameterfunction woocsv_add_featured_image($post_id,$image_array,$dir, $images_exist)<\/code><\/li>\n<\/ol>\n

    How does Woocommerce CSV importer Resume Feature work?<\/h3>\n

    In fact whenever you will face directory limit reach issue either on localhost or live so you will get the follow warnings:
    \n
    \nWarning#1<\/strong>
    \nWarning: imagejpeg() [function.imagejpeg]: Unable to open 'D:\\xampp\\htdocs\\website.com\/wp-content\/uploads\/2013\/06\/xyz-64-14-120_03-150x150.jpg' for writing: Permission denied in D:\\xampp\\htdocs\\website.com\\wp-includes\\class-wp-image-editor.php on line 334<\/code><\/p>\n

    Warning#2<\/strong>
    \nWarning: file_put_contents(D:\\xampp\\htdocs\\website.com\/wp-content\/uploads\/2013\/06\/xyz-60-9-135.jpg) [function.file-put-contents]: failed to open stream: Permission denied in D:\\xampp\\htdocs\\website.com\\wp-content\\plugins\\woocommerce-csvimport\\include\\woocommerce-csvimport-functions.php on line 310<\/code><\/p>\n

    So when you will get these warnings, you will notice that you are unable to create any file\/folder in that particular folder because of limit reach or permission denied warning.<\/p>\n

    What to do next?<\/h3>\n

    Follow these steps to use resume feature in this plugin:<\/p>\n

      \n
    1. Find meta_value in postmeta table with current month no. e.g. June = 06 so your query will be like thisSELECT meta_value FROM wp_postmeta WHERE meta_value LIKE '%06\/%'<\/code><\/li>\n
    2. Now update these values with some other table which should exist e.g. “04” or “05” etc.<\/li>\n
    3. Now move all images to that new folder and database is updated as well from current folder to another folder<\/li>\n
    4. You can run csvimport again, the good thing about this function is that it will not fetch the existing images again because an extra parameter passed to the function “woocsv_add_featured_image” to compare<\/li>\n
    5. It will take around half hour for around 7000+ products to reach the previous crash point to continue further<\/li>\n<\/ol>\n

      Suggestions for Plugin Author<\/h3>\n