WP All Import Configuration + Product CSV Template
Product CSV Template (Product with variations) Here’s the sample CSV — check the structure and modify it as needed. Download Now WP All Import Settings/Configurations [{“id”:”6″,”options”:”a:507:{s:4:”type”;s:4:”post”;s:21:”is_override_post_type”;i:0;s:15:”post_type_xpath”;s:0:””;s:8:”deligate”;s:0:””;s:11:”wizard_type”;s:3:”new”;s:8:”ftp_host”;s:0:””;s:8:”ftp_path”;s:0:””;s:8:”ftp_root”;s:1:”/”;s:8:”ftp_port”;s:2:”21″;s:12:”ftp_username”;s:0:””;s:12:”ftp_password”;s:0:””;s:15:”ftp_private_key”;s:0:””;s:11:”custom_type”;s:7:”product”;s:14:”featured_delim”;s:1:”,”;s:10:”atch_delim”;s:1:”,”;s:25:”is_search_existing_attach”;s:1:”0″;s:15:”post_taxonomies”;a:2:{s:13:”product_brand”;s:156:”[{“item_id”:”1″,”left”:2,”right”:5,”parent_id”:null,”xpath”:””,”assign”:false},{“item_id”:”2″,”left”:3,”right”:4,”parent_id”:”1″,”xpath”:””,”assign”:false}]”;s:11:”product_cat”;s:185:”[{“item_id”:”1″,”left”:2,”right”:5,”parent_id”:null,”xpath”:”{category[1]}”,”assign”:false},{“item_id”:”2″,”left”:3,”right”:4,”parent_id”:”1″,”xpath”:”{subcategory[1]}”,”assign”:false}]”;}s:6:”parent”;i:0;s:23:”is_multiple_page_parent”;s:3:”yes”;s:18:”single_page_parent”;s:0:””;s:5:”order”;s:1:”0″;s:6:”status”;s:7:”publish”;s:13:”page_template”;s:7:”default”;s:25:”is_multiple_page_template”;s:3:”yes”;s:20:”single_page_template”;s:0:””;s:15:”page_taxonomies”;a:0:{}s:9:”date_type”;s:8:”specific”;s:4:”date”;s:3:”now”;s:10:”date_start”;s:3:”now”;s:8:”date_end”;s:3:”now”;s:11:”custom_name”;a:0:{}s:12:”custom_value”;a:0:{}s:13:”custom_format”;a:2:{i:0;s:1:”0″;i:1;s:1:”0″;}s:14:”custom_mapping”;a:0:{}s:17:”serialized_values”;a:2:{i:0;s:7:”[“”,””]”;i:1;s:7:”[“”,””]”;}s:20:”custom_mapping_rules”;a:2:{i:0;s:2:”[]”;i:1;s:2:”[]”;}s:14:”comment_status”;s:4:”open”;s:20:”comment_status_xpath”;s:0:””;s:11:”ping_status”;s:4:”open”;s:17:”ping_status_xpath”;s:0:””;s:12:”create_draft”;s:2:”no”;s:6:”author”;s:0:””;s:12:”post_excerpt”;s:0:””;s:9:”post_slug”;s:0:””;s:11:”attachments”;s:0:””;s:19:”is_import_specified”;s:1:”0″;s:16:”import_specified”;s:0:””;s:16:”is_delete_source”;s:1:”0″;s:8:”is_cloak”;i:0;s:10:”unique_key”;s:47:”{productname[1]} – {sku[1]}{attributevalues[1]}”;s:14:”tmp_unique_key”;s:47:”{productname[1]} – {sku[1]}{attributevalues[1]}”;s:9:”feed_type”;s:4:”auto”;s:22:”search_existing_images”;s:1:”1″;s:18:”create_new_records”;s:1:”1″;s:20:”is_selective_hashing”;s:1:”1″;s:17:”is_delete_missing”;s:1:”0″;s:20:”delete_missing_logic”;s:6:”import”;s:21:”delete_missing_action”;s:4:”keep”;s:24:”is_send_removed_to_trash”;s:1:”1″;s:32:”is_change_post_status_of_removed”;s:1:”0″;s:17:”status_of_removed”;s:5:”draft”;s:26:”status_of_removed_products”;s:10:”outofstock”;s:20:”set_missing_to_draft”;i:0;s:20:”is_update_missing_cf”;s:1:”0″;s:22:”update_missing_cf_name”;a:2:{i:0;s:0:””;i:1;s:0:””;}s:23:”update_missing_cf_value”;a:2:{i:0;s:0:””;i:1;s:0:””;}s:20:”is_keep_former_posts”;s:2:”no”;s:16:”is_update_status”;s:1:”1″;s:17:”is_update_content”;s:1:”1″;s:15:”is_update_title”;s:1:”1″;s:14:”is_update_slug”;s:1:”1″;s:17:”is_update_excerpt”;s:1:”1″;s:20:”is_update_categories”;s:1:”1″;s:16:”is_update_author”;s:1:”1″;s:24:”is_update_comment_status”;s:1:”1″;s:21:”is_update_ping_status”;s:1:”1″;s:19:”is_update_post_type”;i:1;s:21:”is_update_post_format”;i:1;s:23:”update_categories_logic”;s:11:”full_update”;s:19:”do_not_create_terms”;s:1:”0″;s:15:”taxonomies_list”;s:1:”0″;s:20:”taxonomies_only_list”;s:0:””;s:22:”taxonomies_except_list”;s:0:””;s:21:”is_update_attachments”;s:1:”1″;s:16:”is_update_images”;s:1:”1″;s:19:”update_images_logic”;s:11:”full_update”;s:15:”is_update_dates”;s:1:”1″;s:20:”is_update_menu_order”;s:1:”1″;s:16:”is_update_parent”;s:1:”1″;s:19:”is_keep_attachments”;i:0;s:21:”is_delete_attachments”;s:1:”0″;s:12:”is_keep_imgs”;i:0;s:14:”is_delete_imgs”;s:1:”0″;s:20:”do_not_remove_images”;s:1:”1″;s:14:”preload_images”;s:2:”no”;s:23:”is_update_custom_fields”;s:1:”1″;s:26:”update_custom_fields_logic”;s:11:”full_update”;s:18:”custom_fields_list”;s:1:”0″;s:23:”custom_fields_only_list”;s:0:””;s:25:”custom_fields_except_list”;s:0:””;s:18:”duplicate_matching”;s:4:”auto”;s:19:”duplicate_indicator”;s:5:”title”;s:21:”custom_duplicate_name”;s:4:”_sku”;s:22:”custom_duplicate_value”;s:0:””;s:18:”is_update_previous”;i:0;s:12:”is_scheduled”;s:0:””;s:16:”scheduled_period”;s:0:””;s:13:”friendly_name”;s:0:””;s:19:”records_per_request”;s:1:”2″;s:18:”auto_rename_images”;s:1:”0″;s:25:”auto_rename_images_suffix”;s:0:””;s:11:”images_name”;s:8:”filename”;s:11:”post_format”;s:8:”standard”;s:17:”post_format_xpath”;s:0:””;s:8:”encoding”;s:5:”UTF-8″;s:9:”delimiter”;s:1:”,”;s:16:”image_meta_title”;s:0:””;s:22:”image_meta_title_delim”;s:1:”,”;s:18:”image_meta_caption”;s:0:””;s:24:”image_meta_caption_delim”;s:1:”,”;s:14:”image_meta_alt”;s:0:””;s:20:”image_meta_alt_delim”;s:1:”,”;s:22:”image_meta_description”;s:0:””;s:28:”image_meta_description_delim”;s:1:”,”;s:34:”image_meta_description_delim_logic”;s:8:”separate”;s:12:”status_xpath”;s:0:””;s:15:”download_images”;s:2:”no”;s:17:”converted_options”;s:1:”1″;s:15:”update_all_data”;s:3:”yes”;s:12:”is_fast_mode”;s:1:”0″;s:9:”chuncking”;s:1:”1″;s:17:”import_processing”;s:4:”ajax”;s:26:”processing_iteration_logic”;s:4:”auto”;s:16:”save_template_as”;s:1:”1″;s:5:”title”;s:16:”{productname[1]}”;s:7:”content”;s:43:”{description[1]}rnrnTags: {tagskeywords[1]}”;s:4:”name”;s:20:”Test Import Football”;s:18:”is_keep_linebreaks”;s:1:”1″;s:13:”is_leave_html”;s:1:”0″;s:14:”fix_characters”;i:0;s:9:”pid_xpath”;s:0:””;s:10:”slug_xpath”;s:0:””;s:11:”title_xpath”;s:0:””;s:14:”featured_image”;s:29:”{photoofproduct1mainphoto[1]}”;s:23:”download_featured_image”;s:29:”{photoofproduct1mainphoto[1]}”;s:23:”download_featured_delim”;s:1:”,”;s:22:”gallery_featured_image”;s:0:””;s:22:”gallery_featured_delim”;s:1:”,”;s:14:”filters_output”;s:0:””;s:11:”is_featured”;s:1:”1″;s:24:”allow_delay_image_resize”;s:1:”0″;s:17:”is_featured_xpath”;s:0:””;s:20:”set_image_meta_title”;s:1:”0″;s:22:”set_image_meta_caption”;s:1:”0″;s:18:”set_image_meta_alt”;s:1:”0″;s:26:”set_image_meta_description”;s:1:”0″;s:18:”auto_set_extension”;s:1:”0″;s:13:”new_extension”;s:0:””;s:9:”tax_logic”;a:4:{s:13:”product_brand”;s:6:”single”;s:18:”product_visibility”;s:6:”single”;s:11:”product_cat”;s:12:”hierarchical”;s:11:”product_tag”;s:8:”multiple”;}s:10:”tax_assing”;a:4:{s:13:”product_brand”;s:1:”0″;s:18:”product_visibility”;s:1:”0″;s:11:”product_cat”;s:1:”1″;s:11:”product_tag”;s:1:”1″;}s:11:”term_assing”;a:4:{s:13:”product_brand”;s:1:”1″;s:18:”product_visibility”;s:1:”1″;s:11:”product_cat”;s:1:”1″;s:11:”product_tag”;s:1:”1″;}s:20:”multiple_term_assing”;a:4:{s:13:”product_brand”;s:1:”1″;s:18:”product_visibility”;s:1:”1″;s:11:”product_cat”;s:1:”1″;s:11:”product_tag”;s:1:”1″;}s:23:”tax_hierarchical_assing”;a:2:{s:13:”product_brand”;a:2:{i:0;s:1:”1″;s:6:”NUMBER”;s:1:”1″;}s:11:”product_cat”;a:2:{i:0;s:1:”1″;s:6:”NUMBER”;s:1:”1″;}}s:34:”tax_hierarchical_last_level_assign”;a:2:{s:13:”product_brand”;s:1:”0″;s:11:”product_cat”;s:1:”0″;}s:16:”tax_single_xpath”;a:4:{s:13:”product_brand”;s:0:””;s:18:”product_visibility”;s:0:””;s:11:”product_cat”;s:0:””;s:11:”product_tag”;s:0:””;}s:18:”tax_multiple_xpath”;a:4:{s:13:”product_brand”;s:0:””;s:18:”product_visibility”;s:0:””;s:11:”product_cat”;s:0:””;s:11:”product_tag”;s:17:”{tagskeywords[1]}”;}s:22:”tax_hierarchical_xpath”;a:2:{s:13:”product_brand”;a:2:{i:0;s:0:””;i:1;s:0:””;}s:11:”product_cat”;a:2:{i:0;s:0:””;i:1;s:0:””;}}s:18:”tax_multiple_delim”;a:4:{s:13:”product_brand”;s:1:”,”;s:18:”product_visibility”;s:1:”,”;s:11:”product_cat”;s:1:”,”;s:11:”product_tag”;s:1:”,”;}s:22:”tax_hierarchical_delim”;a:2:{s:13:”product_brand”;s:1:”>”;s:11:”product_cat”;s:1:”>”;}s:25:”tax_manualhierarchy_delim”;a:2:{s:13:”product_brand”;s:1:”,”;s:11:”product_cat”;s:1:”|”;}s:29:”tax_hierarchical_logic_entire”;a:2:{s:13:”product_brand”;s:1:”0″;s:11:”product_cat”;s:1:”0″;}s:29:”tax_hierarchical_logic_manual”;a:2:{s:13:”product_brand”;s:1:”0″;s:11:”product_cat”;s:1:”1″;}s:18:”tax_enable_mapping”;a:4:{s:13:”product_brand”;s:1:”0″;s:18:”product_visibility”;s:1:”0″;s:11:”product_cat”;s:1:”0″;s:11:”product_tag”;s:1:”0″;}s:25:”tax_is_full_search_single”;a:4:{s:13:”product_brand”;s:1:”0″;s:18:”product_visibility”;s:1:”0″;s:11:”product_cat”;s:1:”0″;s:11:”product_tag”;s:1:”0″;}s:27:”tax_is_full_search_multiple”;a:4:{s:13:”product_brand”;s:1:”0″;s:18:”product_visibility”;s:1:”0″;s:11:”product_cat”;s:1:”0″;s:11:”product_tag”;s:1:”0″;}s:29:”tax_assign_to_one_term_single”;a:4:{s:13:”product_brand”;s:1:”0″;s:18:”product_visibility”;s:1:”0″;s:11:”product_cat”;s:1:”0″;s:11:”product_tag”;s:1:”0″;}s:31:”tax_assign_to_one_term_multiple”;a:4:{s:13:”product_brand”;s:1:”0″;s:18:”product_visibility”;s:1:”0″;s:11:”product_cat”;s:1:”0″;s:11:”product_tag”;s:1:”0″;}s:11:”tax_mapping”;a:4:{s:13:”product_brand”;s:2:”[]”;s:18:”product_visibility”;s:2:”[]”;s:11:”product_cat”;s:2:”[]”;s:11:”product_tag”;s:2:”[]”;}s:17:”tax_logic_mapping”;a:4:{s:13:”product_brand”;s:1:”0″;s:18:”product_visibility”;s:1:”0″;s:11:”product_cat”;s:1:”0″;s:11:”product_tag”;s:1:”0″;}s:31:”is_tax_hierarchical_group_delim”;a:2:{s:13:”product_brand”;s:1:”0″;s:11:”product_cat”;s:1:”0″;}s:28:”tax_hierarchical_group_delim”;a:2:{s:13:”product_brand”;s:1:”|”;s:11:”product_cat”;s:1:”|”;}s:12:”nested_files”;a:0:{}s:17:”xml_reader_engine”;s:1:”0″;s:13:”taxonomy_type”;s:0:””;s:15:”taxonomy_parent”;s:0:””;s:13:”taxonomy_slug”;s:4:”auto”;s:19:”taxonomy_slug_xpath”;s:0:””;s:21:”taxonomy_display_type”;s:0:””;s:27:”taxonomy_display_type_xpath”;s:0:””;s:15:”import_img_tags”;s:1:”0″;s:28:”search_existing_images_logic”;s:6:”by_url”;s:24:”enable_import_scheduling”;s:5:”false”;s:17:”scheduling_enable”;s:1:”0″;s:22:”scheduling_weekly_days”;s:0:””;s:17:”scheduling_run_on”;s:6:”weekly”;s:22:”scheduling_monthly_day”;s:0:””;s:16:”scheduling_times”;a:1:{i:0;s:0:””;}s:19:”scheduling_timezone”;s:11:”Asia/Taipei”;s:25:”is_update_comment_post_id”;i:1;s:24:”is_update_comment_author”;i:1;s:30:”is_update_comment_author_email”;i:1;s:28:”is_update_comment_author_url”;i:1;s:27:”is_update_comment_author_IP”;i:1;s:23:”is_update_comment_karma”;i:1;s:26:”is_update_comment_approved”;i:1;s:26:”is_update_comment_verified”;i:1;s:24:”is_update_comment_rating”;i:1;s:23:”is_update_comment_agent”;i:1;s:25:”is_update_comment_user_id”;i:1;s:22:”is_update_comment_type”;i:1;s:18:”is_update_comments”;i:1;s:21:”update_comments_logic”;s:11:”full_update”;s:14:”comment_author”;s:0:””;s:20:”comment_author_email”;s:0:””;s:18:”comment_author_url”;s:0:””;s:17:”comment_author_IP”;s:0:””;s:13:”comment_karma”;s:0:””;s:14:”comment_parent”;s:0:””;s:16:”comment_approved”;s:1:”1″;s:22:”comment_approved_xpath”;s:0:””;s:16:”comment_verified”;s:1:”1″;s:22:”comment_verified_xpath”;s:0:””;s:13:”comment_agent”;s:0:””;s:12:”comment_type”;s:0:””;s:18:”comment_type_xpath”;s:0:””;s:15:”comment_user_id”;s:5:”email”;s:21:”comment_user_id_xpath”;s:0:””;s:12:”comment_post”;s:0:””;s:14:”comment_rating”;s:0:””;s:22:”comments_repeater_mode”;s:3:”csv”;s:32:”comments_repeater_mode_separator”;s:1:”|”;s:30:”comments_repeater_mode_foreach”;s:0:””;s:8:”comments”;a:9:{s:7:”content”;s:0:””;s:6:”author”;s:0:””;s:12:”author_email”;s:0:””;s:10:”author_url”;s:0:””;s:9:”author_ip”;s:0:””;s:5:”karma”;s:0:””;s:8:”approved”;s:0:””;s:4:”type”;s:0:””;s:4:”date”;s:3:”now”;}s:32:”use_alternative_excel_processing”;s:1:”0″;s:24:”is_multiple_product_type”;s:3:”yes”;s:21:”multiple_product_type”;s:8:”variable”;s:19:”single_product_type”;s:9:”{type[1]}”;s:18:”is_product_virtual”;s:2:”no”;s:22:”single_product_virtual”;s:0:””;s:23:”is_product_downloadable”;s:2:”no”;s:27:”single_product_downloadable”;s:0:””;s:18:”is_product_enabled”;s:3:”yes”;s:22:”single_product_enabled”;s:0:””;s:20:”is_variation_enabled”;s:3:”yes”;s:24:”single_variation_enabled”;s:0:””;s:19:”is_product_featured”;s:2:”no”;s:23:”single_product_featured”;s:0:””;s:21:”is_product_visibility”;s:7:”visible”;s:25:”single_product_visibility”;s:0:””;s:18:”single_product_sku”;s:8:”{sku[1]}”;s:31:”single_product_global_unique_id”;s:0:””;s:18:”single_product_url”;s:0:””;s:26:”single_product_button_text”;s:0:””;s:28:”single_product_regular_price”;s:16:”{retailprice[1]}”;s:25:”single_product_sale_price”;s:0:””;s:20:”single_product_files”;s:0:””;s:26:”single_product_files_names”;s:0:””;s:29:”single_product_download_limit”;s:0:””;s:30:”single_product_download_expiry”;s:0:””;s:28:”single_product_download_type”;s:0:””;s:30:”is_multiple_product_tax_status”;s:3:”yes”;s:27:”multiple_product_tax_status”;s:7:”taxable”;s:25:”single_product_tax_status”;s:0:””;s:29:”is_multiple_product_tax_class”;s:3:”yes”;s:26:”multiple_product_tax_class”;s:0:””;s:24:”single_product_tax_class”;s:0:””;s:23:”is_product_manage_stock”;s:3:”yes”;s:27:”single_product_manage_stock”;s:16:”{managestock[1]}”;s:24:”single_product_stock_qty”;s:8:”{soh[1]}”;s:20:”product_stock_status”;s:7:”instock”;s:27:”single_product_stock_status”;s:0:””;s:24:”product_allow_backorders”;s:2:”no”;s:31:”single_product_allow_backorders”;s:0:””;s:25:”product_sold_individually”;s:2:”no”;s:32:”single_product_sold_individually”;s:0:””;s:21:”single_product_weight”;s:0:””;s:21:”single_product_length”;s:0:””;s:20:”single_product_width”;s:0:””;s:21:”single_product_height”;s:0:””;s:34:”is_multiple_product_shipping_class”;s:3:”yes”;s:31:”multiple_product_shipping_class”;s:2:”-1″;s:29:”single_product_shipping_class”;s:0:””;s:28:”is_multiple_grouping_product”;s:3:”yes”;s:25:”multiple_grouping_product”;s:0:””;s:23:”single_grouping_product”;s:0:””;s:23:”single_product_up_sells”;s:0:””;s:26:”single_product_cross_sells”;s:0:””;s:14:”attribute_name”;a:1:{i:0;s:20:”{attributenames1[1]}”;}s:15:”attribute_value”;a:1:{i:0;s:21:”{attributevalues1[1]}”;}s:13:”in_variations”;a:2:{i:0;s:1:”1″;i:1;s:1:”1″;}s:10:”is_visible”;a:2:{i:0;s:1:”1″;i:1;s:1:”1″;}s:11:”is_taxonomy”;a:2:{i:0;s:1:”1″;i:1;s:1:”1″;}s:29:”create_taxonomy_in_not_exists”;a:2:{i:0;s:1:”1″;i:1;s:1:”1″;}s:11:”is_advanced”;a:2:{i:0;s:1:”0″;i:1;s:1:”0″;}s:22:”advanced_in_variations”;a:2:{i:0;s:3:”yes”;s:2:”00″;s:3:”yes”;}s:28:”advanced_in_variations_xpath”;a:2:{i:0;s:0:””;s:2:”00″;s:0:””;}s:19:”advanced_is_visible”;a:2:{i:0;s:3:”yes”;s:2:”00″;s:3:”yes”;}s:25:”advanced_is_visible_xpath”;a:2:{i:0;s:0:””;s:2:”00″;s:0:””;}s:20:”advanced_is_taxonomy”;a:2:{i:0;s:3:”yes”;s:2:”00″;s:3:”yes”;}s:26:”advanced_is_taxonomy_xpath”;a:2:{i:0;s:0:””;s:2:”00″;s:0:””;}s:24:”advanced_is_create_terms”;a:2:{i:0;s:3:”yes”;s:2:”00″;s:3:”yes”;}s:30:”advanced_is_create_terms_xpath”;a:2:{i:0;s:0:””;s:2:”00″;s:0:””;}s:28:”single_product_purchase_note”;s:0:””;s:25:”single_product_menu_order”;s:1:”0″;s:25:”is_product_enable_reviews”;s:2:”no”;s:29:”single_product_enable_reviews”;s:0:””;s:17:”single_product_id”;s:8:”{sku[1]}”;s:24:”single_product_parent_id”;s:11:”{parent[1]}”;s:36:”single_product_id_first_is_parent_id”;s:0:””;s:44:”single_product_first_is_parent_id_parent_sku”;s:0:””;s:39:”single_product_id_first_is_parent_title”;s:16:”{productname[1]}”;s:47:”single_product_first_is_parent_title_parent_sku”;s:0:””;s:36:”single_product_id_first_is_variation”;s:16:”{productname[1]}”;s:8:”_virtual”;i:0;s:13:”_downloadable”;i:0;s:24:”is_regular_price_shedule”;s:1:”0″;s:28:”single_sale_price_dates_from”;s:3:”now”;s:26:”single_sale_price_dates_to”;s:3:”now”;s:19:”product_files_delim”;s:1:”,”;s:25:”product_files_names_delim”;s:1:”,”;s:15:”matching_parent”;s:4:”auto”;s:16:”parent_indicator”;s:12:”custom field”;s:28:”custom_parent_indicator_name”;s:0:””;s:29:”custom_parent_indicator_value”;s:0:””;s:28:”missing_records_stock_status”;s:1:”0″;s:16:”variations_xpath”;s:0:””;s:17:”_variable_virtual”;s:0:””;s:22:”_variable_downloadable”;s:0:””;s:14:”variable_stock”;s:0:””;s:22:”variable_regular_price”;s:0:””;s:19:”variable_sale_price”;s:0:””;s:30:”is_variable_sale_price_shedule”;s:1:”0″;s:30:”variable_sale_price_dates_from”;s:0:””;s:28:”variable_sale_price_dates_to”;s:0:””;s:15:”variable_weight”;s:0:””;s:15:”variable_length”;s:0:””;s:14:”variable_width”;s:0:””;s:15:”variable_height”;s:0:””;s:23:”variable_shipping_class”;s:0:””;s:18:”variable_tax_class”;s:0:””;s:19:”variable_file_paths”;s:0:””;s:19:”variable_file_names”;s:0:””;s:23:”variable_download_limit”;s:0:””;s:24:”variable_download_expiry”;s:0:””;s:27:”is_variable_product_virtual”;s:2:”no”;s:32:”is_variable_product_manage_stock”;s:2:”no”;s:43:”is_multiple_variable_product_shipping_class”;s:3:”yes”;s:40:”multiple_variable_product_shipping_class”;s:2:”-1″;s:38:”single_variable_product_shipping_class”;s:0:””;s:38:”is_multiple_variable_product_tax_class”;s:3:”yes”;s:35:”multiple_variable_product_tax_class”;s:6:”parent”;s:33:”single_variable_product_tax_class”;s:0:””;s:21:”variable_stock_status”;s:7:”instock”;s:28:”single_variable_stock_status”;s:0:””;s:25:”variable_allow_backorders”;s:2:”no”;s:32:”single_variable_allow_backorders”;s:0:””;s:32:”is_variable_product_downloadable”;s:2:”no”;s:36:”single_variable_product_downloadable”;s:0:””;s:23:”variable_attribute_name”;a:2:{i:0;s:0:””;i:1;s:0:””;}s:24:”variable_attribute_value”;a:2:{i:0;s:0:””;i:1;s:0:””;}s:22:”variable_in_variations”;a:2:{i:0;s:1:”1″;i:1;s:1:”1″;}s:19:”variable_is_visible”;a:2:{i:0;s:1:”1″;i:1;s:1:”1″;}s:20:”variable_is_taxonomy”;a:2:{i:0;s:1:”1″;i:1;s:1:”1″;}s:38:”variable_create_taxonomy_in_not_exists”;a:2:{i:0;s:1:”1″;i:1;s:1:”1″;}s:28:”variable_product_files_delim”;s:1:”,”;s:34:”variable_product_files_names_delim”;s:1:”,”;s:14:”variable_image”;s:0:””;s:12:”variable_sku”;s:0:””;s:25:”variable_global_unique_id”;s:0:””;s:27:”is_variable_product_enabled”;s:3:”yes”;s:31:”single_variable_product_enabled”;s:0:””;s:19:”link_all_variations”;s:1:”0″;s:22:”block_low_stock_notice”;i:1;s:25:”variable_stock_use_parent”;s:1:”0″;s:33:”variable_regular_price_use_parent”;s:1:”0″;s:30:”variable_sale_price_use_parent”;s:1:”0″;s:30:”variable_sale_dates_use_parent”;s:1:”0″;s:26:”variable_weight_use_parent”;s:1:”0″;s:31:”single_variable_product_virtual”;s:0:””;s:42:”single_variable_product_virtual_use_parent”;s:1:”0″;s:36:”single_variable_product_manage_stock”;s:0:””;s:47:”single_variable_product_manage_stock_use_parent”;s:1:”0″;s:30:”variable_dimensions_use_parent”;s:1:”0″;s:25:”variable_image_use_parent”;s:1:”0″;s:49:”single_variable_product_shipping_class_use_parent”;s:1:”0″;s:44:”single_variable_product_tax_class_use_parent”;s:1:”0″;s:47:”single_variable_product_downloadable_use_parent”;s:1:”0″;s:34:”variable_download_limit_use_parent”;s:1:”0″;s:35:”variable_download_expiry_use_parent”;s:1:”0″;s:36:”single_product_variation_description”;s:16:”{description[1]}”;s:20:”variable_description”;s:0:””;s:31:”variable_description_use_parent”;s:1:”0″;s:15:”first_is_parent”;s:3:”yes”;s:28:”single_product_whosale_price”;s:0:””;s:22:”variable_whosale_price”;s:0:””;s:33:”variable_whosale_price_use_parent”;i:0;s:27:”disable_auto_sku_generation”;s:1:”0″;s:21:”is_default_attributes”;s:1:”1″;s:23:”default_attributes_type”;s:5:”first”;s:24:”default_attributes_xpath”;s:0:””;s:20:”disable_sku_matching”;s:1:”0″;s:21:”disable_prepare_price”;s:1:”1″;s:27:”prepare_price_to_woo_format”;s:1:”1″;s:25:”convert_decimal_separator”;s:1:”1″;s:18:”grouping_indicator”;s:5:”xpath”;s:30:”custom_grouping_indicator_name”;s:0:””;s:31:”custom_grouping_indicator_value”;s:0:””;s:22:”is_update_product_type”;s:1:”1″;s:19:”make_simple_product”;s:1:”0″;s:31:”create_new_product_if_no_parent”;s:1:”0″;s:23:”variable_sku_add_parent”;s:1:”0″;s:16:”set_parent_stock”;s:1:”0″;s:35:”single_product_regular_price_adjust”;s:0:””;s:40:”single_product_regular_price_adjust_type”;s:1:”%”;s:32:”single_product_sale_price_adjust”;s:0:””;s:37:”single_product_sale_price_adjust_type”;s:1:”%”;s:20:”is_update_attributes”;s:1:”1″;s:23:”update_attributes_logic”;s:11:”full_update”;s:15:”attributes_list”;a:0:{}s:20:”attributes_only_list”;s:0:””;s:22:”attributes_except_list”;s:0:””;s:33:”is_variation_product_manage_stock”;s:3:”yes”;s:37:”single_variation_product_manage_stock”;s:0:””;s:15:”variation_stock”;s:0:””;s:22:”variation_stock_status”;s:4:”auto”;s:30:”put_variation_image_to_gallery”;s:1:”1″;s:34:”import_additional_variation_images”;i:0;s:29:”single_variation_stock_status”;s:0:””;s:31:”single_product_low_stock_amount”;s:0:””;s:10:”pmwi_order”;a:102:{s:6:”status”;s:10:”wc-pending”;s:12:”status_xpath”;s:0:””;s:4:”date”;s:3:”now”;s:14:”billing_source”;s:5:”guest”;s:23:”billing_source_match_by”;s:8:”username”;s:23:”billing_source_username”;s:0:””;s:20:”billing_source_email”;s:0:””;s:17:”billing_source_id”;s:0:””;s:22:”billing_source_cf_name”;s:0:””;s:23:”billing_source_cf_value”;s:0:””;s:18:”billing_first_name”;s:0:””;s:17:”billing_last_name”;s:0:””;s:15:”billing_company”;s:0:””;s:17:”billing_address_1″;s:0:””;s:17:”billing_address_2″;s:0:””;s:12:”billing_city”;s:0:””;s:16:”billing_postcode”;s:0:””;s:15:”billing_country”;s:0:””;s:13:”billing_state”;s:0:””;s:13:”billing_email”;s:0:””;s:13:”billing_phone”;s:0:””;s:24:”guest_billing_first_name”;s:0:””;s:23:”guest_billing_last_name”;s:0:””;s:21:”guest_billing_company”;s:0:””;s:23:”guest_billing_address_1″;s:0:””;s:23:”guest_billing_address_2″;s:0:””;s:18:”guest_billing_city”;s:0:””;s:22:”guest_billing_postcode”;s:0:””;s:21:”guest_billing_country”;s:0:””;s:19:”guest_billing_state”;s:0:””;s:19:”guest_billing_email”;s:0:””;s:19:”guest_billing_phone”;s:0:””;s:17:”is_guest_matching”;i:0;s:15:”shipping_source”;s:4:”copy”;s:19:”shipping_first_name”;s:0:””;s:18:”shipping_last_name”;s:0:””;s:16:”shipping_company”;s:0:””;s:18:”shipping_address_1″;s:0:””;s:18:”shipping_address_2″;s:0:””;s:13:”shipping_city”;s:0:””;s:17:”shipping_postcode”;s:0:””;s:16:”shipping_country”;s:0:””;s:14:”shipping_state”;s:0:””;s:14:”shipping_phone”;s:0:””;s:17:”copy_from_billing”;i:0;s:22:”customer_provided_note”;s:0:””;s:12:”payment_date”;s:3:”now”;s:14:”payment_method”;s:0:””;s:20:”payment_method_xpath”;s:0:””;s:14:”transaction_id”;s:0:””;s:22:”products_repeater_mode”;s:3:”csv”;s:37:”products_repeater_mode_item_separator”;s:1:”#”;s:32:”products_repeater_mode_separator”;s:1:”|”;s:30:”products_repeater_mode_foreach”;s:0:””;s:15:”products_source”;s:8:”existing”;s:13:”product_items”;a:0:{}s:18:”fees_repeater_mode”;s:3:”csv”;s:33:”fees_repeater_mode_item_separator”;s:1:”#”;s:28:”fees_repeater_mode_separator”;s:1:”|”;s:26:”fees_repeater_mode_foreach”;s:0:””;s:4:”fees”;a:0:{}s:21:”refunds_repeater_mode”;s:3:”csv”;s:35:”refunds_repeater_mode_tax_separator”;s:1:”@”;s:36:”refunds_repeater_mode_item_separator”;s:1:”#”;s:31:”refunds_repeater_mode_separator”;s:1:”|”;s:29:”refunds_repeater_mode_foreach”;s:0:””;s:7:”refunds”;a:0:{}s:21:”coupons_repeater_mode”;s:3:”csv”;s:31:”coupons_repeater_mode_separator”;s:1:”|”;s:29:”coupons_repeater_mode_foreach”;s:0:””;s:7:”coupons”;a:0:{}s:22:”shipping_repeater_mode”;s:3:”csv”;s:37:”shipping_repeater_mode_item_separator”;s:1:”#”;s:32:”shipping_repeater_mode_separator”;s:1:”|”;s:30:”shipping_repeater_mode_foreach”;s:0:””;s:8:”shipping”;a:0:{}s:19:”taxes_repeater_mode”;s:3:”csv”;s:29:”taxes_repeater_mode_separator”;s:1:”|”;s:27:”taxes_repeater_mode_foreach”;s:0:””;s:5:”taxes”;a:0:{}s:18:”order_total_amount”;s:0:””;s:22:”order_total_tax_amount”;s:0:””;s:17:”order_refund_type”;s:4:”full”;s:26:”order_refund_issued_source”;s:5:”blank”;s:28:”order_refund_issued_match_by”;s:8:”username”;s:28:”order_refund_issued_username”;s:0:””;s:25:”order_refund_issued_email”;s:0:””;s:27:”order_refund_issued_cf_name”;s:0:””;s:28:”order_refund_issued_cf_value”;s:0:””;s:22:”order_refund_issued_id”;s:0:””;s:19:”notes_repeater_mode”;s:3:”csv”;s:29:”notes_repeater_mode_separator”;s:1:”|”;s:27:”notes_repeater_mode_foreach”;s:0:””;s:5:”notes”;a:0:{}s:33:”notes_add_auto_order_status_notes”;i:0;s:8:”products”;a:0:{}s:15:”manual_products”;a:0:{}s:19:”order_refund_reason”;s:0:””;s:19:”order_refund_amount”;s:0:””;s:17:”order_refund_date”;s:0:””;s:17:”order_total_logic”;s:8:”manually”;s:17:”order_total_xpath”;s:0:””;}s:25:”is_update_billing_details”;i:1;s:26:”is_update_shipping_details”;i:1;s:17:”is_update_payment”;i:1;s:15:”is_update_notes”;i:1;s:18:”is_update_products”;i:1;s:21:”update_products_logic”;s:11:”full_update”;s:14:”is_update_fees”;i:1;s:17:”is_update_coupons”;i:1;s:18:”is_update_shipping”;i:1;s:15:”is_update_taxes”;i:1;s:17:”is_update_refunds”;i:1;s:15:”is_update_total”;i:1;s:31:”do_not_send_order_notifications”;s:1:”1″;s:26:”is_update_advanced_options”;i:1;s:28:”is_update_catalog_visibility”;s:1:”1″;s:25:”is_update_featured_status”;s:1:”1″;s:38:”existing_parent_product_matching_logic”;s:12:”custom field”;s:29:”existing_parent_product_title”;s:0:””;s:31:”existing_parent_product_cf_name”;s:4:”_sku”;s:32:”existing_parent_product_cf_value”;s:0:””;s:33:”single_product_subscription_price”;s:0:””;s:39:”single_product_subscription_sign_up_fee”;s:0:””;s:48:”is_multiple_product_subscription_period_interval”;s:3:”yes”;s:45:”multiple_product_subscription_period_interval”;i:1;s:43:”single_product_subscription_period_interval”;s:0:””;s:39:”is_multiple_product_subscription_period”;s:3:”yes”;s:36:”multiple_product_subscription_period”;s:5:”month”;s:34:”single_product_subscription_period”;s:0:””;s:45:”is_multiple_product_subscription_trial_period”;s:3:”yes”;s:42:”multiple_product_subscription_trial_period”;i:0;s:40:”single_product_subscription_trial_period”;s:0:””;s:39:”is_multiple_product_subscription_length”;s:3:”yes”;s:36:”multiple_product_subscription_length”;i:0;s:34:”single_product_subscription_length”;s:0:””;s:38:”is_multiple_product_subscription_limit”;s:3:”yes”;s:35:”multiple_product_subscription_limit”;s:2:”no”;s:33:”single_product_subscription_limit”;s:0:””;s:24:”grouped_product_children”;s:5:”xpath”;s:30:”grouped_product_children_xpath”;s:0:””;s:18:”woo_add_on_version”;s:5:”4.0.5″;s:15:”is_update_price”;s:1:”1″;s:23:”is_update_regular_price”;s:1:”1″;s:20:”is_update_sale_price”;s:1:”1″;s:31:”is_update_sale_price_dates_from”;s:1:”1″;s:29:”is_update_sale_price_dates_to”;s:1:”1″;s:26:”is_update_sale_price_dates”;i:1;s:13:”is_update_sku”;s:1:”1″;s:16:”is_update_weight”;s:1:”1″;s:16:”is_update_length”;s:1:”1″;s:15:”is_update_width”;s:1:”1″;s:16:”is_update_height”;s:1:”1″;s:18:”is_update_up_sells”;s:1:”1″;s:21:”is_update_cross_sells”;s:1:”1″;s:18:”is_update_grouping”;s:1:”1″;s:24:”is_update_shipping_class”;s:1:”1″;s:15:”is_update_stock”;i:1;s:22:”is_update_stock_status”;s:1:”0″;s:22:”is_update_manage_stock”;s:1:”1″;s:26:”is_update_global_unique_id”;s:1:”1″;s:20:”is_update_backorders”;s:1:”1″;s:19:”is_update_tax_class”;s:1:”1″;s:20:”is_update_tax_status”;s:1:”1″;s:22:”is_update_downloadable”;s:1:”1″;s:24:”is_update_download_limit”;s:1:”1″;s:25:”is_update_download_expiry”;s:1:”1″;s:28:”is_update_downloadable_files”;s:1:”1″;s:17:”is_update_virtual”;s:1:”1″;s:26:”is_update_allow_backorders”;i:1;s:27:”is_update_sold_individually”;s:1:”1″;s:37:”is_update_woocommerce_general_options”;s:1:”1″;s:38:”is_update_woocommerce_shipping_options”;s:1:”1″;s:39:”is_update_woocommerce_inventory_options”;s:1:”1″;s:44:”is_update_woocommerce_linked_product_options”;s:1:”0″;s:24:”is_update_stock_quantity”;s:1:”1″;s:23:”is_update_purchase_note”;s:1:”1″;s:35:”is_using_new_product_import_options”;s:1:”1″;s:5:”xpath”;s:5:”/node”;}”,”scheduled”:””,”name”:”Test Import Football”,”title”:”N;”,”content”:”N;”,”is_keep_linebreaks”:”1″,”is_leave_html”:”0″,”fix_characters”:”0″,”meta”:”N;”}] Note: Save as .txt file then import here