trey8611/import-woocommerce-rest-api-feed.md

## import-woocommerce-rest-api-feed.md

      
    Raw
  

              import-woocommerce-rest-api-feed.md
            
          
    This function can be saved in your child theme's functions.php file, or in a code snippets plugin ( https://wordpress.org/plugins/code-snippets/ ), then used in WP All Import to download a product feed via the WooCommerce REST API. Things that need to be/can be changed are:

In the function call, change "100" to the amount of product you want per-page request.
In the code, change the $max_pages value from 3 to however many pages you want to fetch.
In the code, change the $key and $sec (secret value) values to the correct ones from your WooCo API key details.

Usage (in the Download a file › From URL field in WP All Import):
[my_fetch_products("https://example.com/wp-json/wc/v3/products?per_page=100","json")]

Code:
function my_fetch_products( $url, $type ) {
    if ( empty( $url ) ) return;
    $key      = 'ck_xxxxx'; // wooco rest api key
    $sec      = 'cs_xxxxx'; // wooco rest api secret
    $uploads  = wp_upload_dir();
    $type     = 'json';
    $filename = $uploads['basedir'] . '/' . basename( strtok( $url, '?' ) ) . '.' . $type;

    if ( file_exists( $filename ) ) {
            @unlink( $filename );
    }
    
    $ch = curl_init();
    
    $filtered      = 'start';
    $page          = 1;
    $final_results = array();
    $max_pages     = 3; // change this
    
    while ( ! empty( $filtered ) && $page <= $max_pages ) {
        $url = add_query_arg( array( 'page' => $page ), $url );
        curl_setopt( $ch, CURLOPT_URL, $url );
        curl_setopt( $ch, CURLOPT_RETURNTRANSFER, 1 );
        curl_setopt( $ch, CURLOPT_CUSTOMREQUEST, "GET" );
        curl_setopt( $ch, CURLOPT_USERPWD, $key . ':' . $sec );
        $result = curl_exec($ch);
        if ( curl_errno( $ch ) ) {
            exit( 'Error:' . curl_error( $ch ) );
        }
        
        $filtered = json_decode( $result, 1 );
        $filtered = array_filter( $filtered );
        $final_results = array_merge( $final_results, $filtered );
        
        $page++;
    }
    
    file_put_contents( $filename, json_encode( $final_results ) );
    
    curl_close( $ch );
    
    return str_replace( $uploads['basedir'], $uploads['baseurl'], $filename );
}