Adding WooCommerce Attribute via PHP code

Question

I could see a lots of question on adding woocommerce product attribute. But doing so, I could see those added attributes in this screen

wp-admin/edit.php?post_type=product&page=product_attributes

My question is how can we add the attributes via PHP code to so that it appears in this above specified woocommerce attribute screen ? My intention is to make these attributes visible under 'Layered Navs' widget to filter out.

Answer 1

Following code will create the attribute programmatically which will be visible on the product_attributes page in the backend.

        global $wpdb; 

        $insert = $wpdb->insert(
            $wpdb->prefix . 'woocommerce_attribute_taxonomies',
            array(
                'attribute_label'   => 'name',
                'attribute_name'    => 'slug',
                'attribute_type'    => 'type',
                'attribute_orderby' => 'order_by',
                'attribute_public'  => 1
            ),
            array( '%s', '%s', '%s', '%s', '%d' )
        );

        if ( is_wp_error( $insert ) ) {
            throw new WC_API_Exception( 'woocommerce_api_cannot_create_product_attribute', $insert->get_error_message(), 400 );
        }

        // Clear transients
        delete_transient( 'wc_attribute_taxonomies' );

Change name, slug etc with the relevant values.