php - WP_insert_term creating duplicate categories during WooCommerce product import

I've been racking my brain for a few days on this issue and can't figure out why my code to import is creating duplicate product categories.

Problem: I am pulling in about 30,000 products from the third party API in JSON format it is then is inserted into a custom database, from which I pull each product's data and format for importing into WooCommerce, these processes are working fine the problem comes when I am inserting the category terms. When categories are inserted using wp_insert_term some categories are duplicated but have a different URL slug.

ie...

— Ranges, Cooktops & Ovens
— — Range Hoods & Downdraft Ventilation (slug: range-hoods-downdraft-ventilation ) 
— — Range Hoods & Downdraft Ventilation (slug: range-hoods-downdraft-ventilation-ranges-cooktops-ovens)

The child category gets duplicated but with a different slug.

Copy code

This is the Category array I'm looping through to create the hierarchical category paths:

"categoryPath":[{"id":"cat00000","name":"Company Name"},{"id":"abcat0900000","name":"Appliances"},{"id":"abcat0904000","name":"Ranges, Cooktops & Ovens"},{"id":"abcat0904002","name":"Range Hoods & Downdraft Ventilation"}]

Here is my single product import code the relevant category portion in at the bottom starting with $categoryPath, just wanted to give some context of what Im doing:

$result= $wpdb->get_var( "SELECT `results_array`
                                             FROM $table_name 
                                             WHERE `arr_serialize2` = $textProductSku  
                                             AND  `update_type` = 'create' 
                                        ");

            $final_product_formate_arrays = json_decode($result, true);

           

            $post = array(
                'post_title' => $final_product_formate_arrays['parent_or_simple_product']['title'],
                'post_content' => $final_product_formate_arrays['parent_or_simple_product']['longDescription'],
                'post_excerpt' => isset( $final_product_formate_arrays['parent_or_simple_product']['shortDescription']) ?  $final_product_formate_arrays['parent_or_simple_product']['shortDescription'] : '' ,
                'post_status' => "publish",
                'post_parent' => '',
                'post_type' => "product",
            );
            $post_id = wp_insert_post( $post );
            if (!$post_id) 
            {
                return false;
            }
            update_post_meta($post_id,'_complete_product_data',json_encode($final_product_formate_arrays));
            update_post_meta($post_id, '_sku', $final_product_formate_arrays['parent_or_simple_product']['sku']);
            update_post_meta( $post_id, '_visibility', 'visible' ); 
            
            if($final_product_formate_arrays['parent_or_simple_product']['inStoreAvailability'] > 0) 
            {
            
                update_post_meta( $post_id, '_manage_stock', "yes" );
                update_post_meta( $post_id, '_stock', $final_product_formate_arrays['parent_or_simple_product']['stockQuantity'] );
                update_post_meta( $post_id, '_stock_status', 'instock');

            } elseif($final_product_formate_arrays['is_variation']){
                
                update_post_meta( $post_id, '_manage_stock', "no" );
                update_post_meta( $post_id, '_stock_status', 'instock');
                
            } else  {


                update_post_meta( $post_id, '_manage_stock', "yes" );
                update_post_meta( $post_id, '_stock_status', 'outofstock');
                update_post_meta( $post_id, '_stock', 0 );
            }

            update_post_meta( $post_id, '_regular_price', $final_product_formate_arrays['parent_or_simple_product']['regularPrice'] );
            update_post_meta( $post_id, '_sale_price', $final_product_formate_arrays['parent_or_simple_product']['salePrice'] );
            update_post_meta( $post_id, '_price', $final_product_formate_arrays['parent_or_simple_product']['salePrice'] );
            update_post_meta( $post_id, '_weight', $final_product_formate_arrays['parent_or_simple_product']['weight'] );
            update_post_meta( $post_id, '_length', $final_product_formate_arrays['parent_or_simple_product']['depth'] );
            update_post_meta( $post_id, '_width', $final_product_formate_arrays['parent_or_simple_product']['width'] );
            update_post_meta( $post_id, '_height', $final_product_formate_arrays['parent_or_simple_product']['height'] );
            update_post_meta( $post_id, '_wc_average_rating', $final_product_formate_arrays['parent_or_simple_product']['reviewAverage'] );
            

         

                **$categoryPath = $final_product_formate_arrays['parent_or_simple_product']['categoryPath'];
                if(!empty($categoryPath))
                {
                    $parent_id='';
                    
                    
                    foreach ($categoryPath as $key => $value) {
                        
                        if($key!=0) {
                            $new_str = str_replace( array( ',', '&' ), '-', $value['name'] );
                            $new_str = sanitize_title( $new_str );
                            $parent_term = term_exists( $parent_id, 'product_cat' );  // array is returned if taxonomy is given
                            if( isset( $parent_term )) {
                            $parent_id = $parent_term['term_id'];  // get numeric term id
                            
                            } else{
                                $parent_id = 0;
                            }
                                                  
                                    $term = wp_insert_term( $value['name'], 'product_cat', [
                                        'description'=> $value['name'],
                                        'parent' => intval( $parent_id ),
                                        'slug' =>  $new_str,
                                    ]
                                );
                        
                                              
                       if( is_wp_error( $term ) && isset( $term->error_data['term_exists'] ) )
                        {
                            $term_id = isset( $term->error_data['term_exists'] ) ?  $term->error_data['term_exists'] :'';
                            $term_error = $term->get_error_message();
                            $term_error .="\n";
                            error_log($term_error, 3, $pluginlog);
                        } else if ( !is_wp_error( $term ) ) {
                            $new_term_id = isset( $term['term_id']) ? $term['term_id'] : '';
                            $term_id = $new_term_id;
                        }
                        $term_id = intval($term_id);
                       
                              
                        $parent_id = !empty($term_id)?$term_id:'';
                                       
                      wp_set_post_terms($post_id, $term_id, 'product_cat');**

                   
                    // wp_set_object_terms($post_id, $term_id, 'product_cat');
                    } else {

                        continue;
                    }

                    
                  }

                }

Copy code

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.