• Stop being a LURKER - join our dealer community and get involved. Sign up and start a conversation.

ChatGPT - This is pretty awesome :)

:banana: Exciting news! We've revolutionized our review process with the power of ChatGPT and the OpenAI API. Say goodbye to manual posting, as our new online reviews are now automatically shared on Facebook in real-time.

From selecting the best part of the review to creating stunning graphics and crafting engaging post text, we've got it all covered.

First, I used Open AI's API to pick out the best part of the review (max 25 words so that it will be more visually appealing on a graphic).

Then, I used an image generation API to create a social media graphic for the shortened review from a set of 20+ pre-designed templates (it randomly selects a template, so there's ad variety).

Finally, Open AI writes the social media post text and then shares it all on Facebook!

And that's just the beginning! We're also expanding posting to Google Business Profile and Instagram, and soon, we'll be integrating with the Facebook Marketing API to retarget our website visitors and constantly remind them of our great reputation.

What are your thoughts on ChatGPT, and how are you using it in your workflow?

faceboo screen.PNG
 
Last edited:
@Ryan Everson That's Awesome. Our AI is now powered by it as well. Wait till you see the engagement it's getting. It's crazy.
Yeah, you guys jumped right on it quickly; very impressed by the speed of development compared to some other CRMs. Glad we could finally partner and get DriveCentric live at one of our stores, hopefully more soon!
 
Well... It debugged the code for me! LOL

This is just a test but I don't think it would take very much at all to have this thing to build out a full blown inventory plugin for basically any WordPress site.


PHP:
<?php
/*
Plugin Name: Test Vehicle Inventory Parser 3.0
Description: Parses a CSV file and stores the data in a MySQL database
Version: 1.0
Author: Rick Buffkin and ChatGPT
*/
defined( 'ABSPATH' ) or die( 'No script kiddies please!' );

register_activation_hook( __FILE__, 'vehicle_inventory_parser_activate' );
add_action( 'vehicle_inventory_parser_cron_job', 'vehicle_inventory_parser_run' );
add_action( 'admin_menu', 'vehicle_inventory_parser_menu' );
add_action( 'admin_post_vehicle_inventory_parser_process', 'vehicle_inventory_parser_process' );

function vehicle_inventory_parser_activate() {
    if ( ! wp_next_scheduled( 'vehicle_inventory_parser_cron_job' ) ) {
        wp_schedule_event( time(), 'every_four_hours', 'vehicle_inventory_parser_cron_job' );
    }
}

function vehicle_inventory_parser_run() {
    vehicle_inventory_parser_process();
}

function vehicle_inventory_parser_process() {
    global $wpdb;
    $table_name = $wpdb->prefix . 'vehicle_inventory';
    $charset_collate = $wpdb->get_charset_collate();
    $csv_file = plugin_dir_path( __FILE__ ) . 'broadwayinven.csv';

    $sql = "CREATE TABLE IF NOT EXISTS $table_name (
        id mediumint(9) NOT NULL AUTO_INCREMENT,
        time datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
        column1 text NOT NULL,
        column2 text NOT NULL,
        column3 text NOT NULL,
        PRIMARY KEY (id)
    ) $charset_collate;";

    require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
    dbDelta( $sql );

    $wpdb->query( "TRUNCATE TABLE $table_name" );

    if ( ( $handle = fopen( $csv_file, 'r' ) ) !== false ) {
        while ( ( $data = fgetcsv( $handle, 1000, ',' ) ) !== false ) {
            $col1 = $data[0];
            $col2 = $data[1];
            $col3 = $data[2];

            $wpdb->insert(
                $table_name,
                array(
                    'time' => current_time( 'mysql' ),
                    'column1' => $col1,
                    'column2' => $col2,
                    'column3' => $col3,
                )
            );
        }
        fclose( $handle );
    }

    $redirect_url = admin_url( 'admin.php?page=vehicle-inventory' );
    wp_redirect( $redirect_url );
    exit;
}

function vehicle_inventory_parser_menu() {
    add_menu_page( 'Vehicle Inventory', 'Vehicle Inventory', 'manage_options', 'vehicle-inventory', 'vehicle_inventory_parser_display_data', 'dashicons-chart-line', 6 );
}

function vehicle_inventory_parser_display_data() {
    if ( isset( $_GET['action'] ) && $_GET['action' ] == 'process' ) {
vehicle_inventory_parser_process();
}
global $wpdb;
$table_name = $wpdb->prefix . 'vehicle_inventory';
$results = $wpdb->get_results( "SELECT * FROM $table_name", ARRAY_A );
echo '<h1>Vehicle Inventory</h1>';
echo '<p><a href="' . admin_url( 'admin-post.php?action=vehicle_inventory_parser_process' ) . '" class="button-primary">Process CSV</a></p>';
echo '<table class="wp-list-table widefat fixed striped posts">
<thead>
<tr>
<th>ID</th>
<th>Time</th>
<th>Column 1</th>
<th>Column 2</th>
<th>Column 3</th>
</tr>
</thead>
<tbody>';
foreach ( $results as $result ) {
echo '<tr>
<td>' . $result['id'] . '</td>
<td>' . $result['time'] . '</td>
<td>' . $result['column1'] . '</td>
<td>' . $result['column2'] . '</td>
<td>' . $result['column3'] . '</td>
</tr>';
}
echo '</tbody></table>';
}

register_deactivation_hook( __FILE__, 'vehicle_inventory_parser_deactivate' );

function vehicle_inventory_parser_deactivate() {
wp_clear_scheduled_hook( 'vehicle_inventory_parser_cron_job' );
}
 
This is one of the areas I find really intriguing - ChatGPT can open consoles and run commands too.
I keep telling people that the hardest part about ChatGPT is thinking of all the ways you could use it - and then remembering to use it.

It feels so unnatural still, but it's entering my workflow more and more every day.
Could be something as simple as a grammar check or summarizing a long report into key takeaways.

The code it wrote for Rick is very basic, but by definition it's also.. "by the book". It does things the Wordpress way, not some random way to achieve the objective.
 
  • Like
Reactions: Rick Buffkin
Well... It debugged the code for me! LOL

This is just a test but I don't think it would take very much at all to have this thing to build out a full blown inventory plugin for basically any WordPress site.


PHP:
<?php
/*
Plugin Name: Test Vehicle Inventory Parser 3.0
Description: Parses a CSV file and stores the data in a MySQL database
Version: 1.0
Author: Rick Buffkin and ChatGPT
*/
defined( 'ABSPATH' ) or die( 'No script kiddies please!' );

register_activation_hook( __FILE__, 'vehicle_inventory_parser_activate' );
add_action( 'vehicle_inventory_parser_cron_job', 'vehicle_inventory_parser_run' );
add_action( 'admin_menu', 'vehicle_inventory_parser_menu' );
add_action( 'admin_post_vehicle_inventory_parser_process', 'vehicle_inventory_parser_process' );

function vehicle_inventory_parser_activate() {
    if ( ! wp_next_scheduled( 'vehicle_inventory_parser_cron_job' ) ) {
        wp_schedule_event( time(), 'every_four_hours', 'vehicle_inventory_parser_cron_job' );
    }
}

function vehicle_inventory_parser_run() {
    vehicle_inventory_parser_process();
}

function vehicle_inventory_parser_process() {
    global $wpdb;
    $table_name = $wpdb->prefix . 'vehicle_inventory';
    $charset_collate = $wpdb->get_charset_collate();
    $csv_file = plugin_dir_path( __FILE__ ) . 'broadwayinven.csv';

    $sql = "CREATE TABLE IF NOT EXISTS $table_name (
        id mediumint(9) NOT NULL AUTO_INCREMENT,
        time datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
        column1 text NOT NULL,
        column2 text NOT NULL,
        column3 text NOT NULL,
        PRIMARY KEY (id)
    ) $charset_collate;";

    require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
    dbDelta( $sql );

    $wpdb->query( "TRUNCATE TABLE $table_name" );

    if ( ( $handle = fopen( $csv_file, 'r' ) ) !== false ) {
        while ( ( $data = fgetcsv( $handle, 1000, ',' ) ) !== false ) {
            $col1 = $data[0];
            $col2 = $data[1];
            $col3 = $data[2];

            $wpdb->insert(
                $table_name,
                array(
                    'time' => current_time( 'mysql' ),
                    'column1' => $col1,
                    'column2' => $col2,
                    'column3' => $col3,
                )
            );
        }
        fclose( $handle );
    }

    $redirect_url = admin_url( 'admin.php?page=vehicle-inventory' );
    wp_redirect( $redirect_url );
    exit;
}

function vehicle_inventory_parser_menu() {
    add_menu_page( 'Vehicle Inventory', 'Vehicle Inventory', 'manage_options', 'vehicle-inventory', 'vehicle_inventory_parser_display_data', 'dashicons-chart-line', 6 );
}

function vehicle_inventory_parser_display_data() {
    if ( isset( $_GET['action'] ) && $_GET['action' ] == 'process' ) {
vehicle_inventory_parser_process();
}
global $wpdb;
$table_name = $wpdb->prefix . 'vehicle_inventory';
$results = $wpdb->get_results( "SELECT * FROM $table_name", ARRAY_A );
echo '<h1>Vehicle Inventory</h1>';
echo '<p><a href="' . admin_url( 'admin-post.php?action=vehicle_inventory_parser_process' ) . '" class="button-primary">Process CSV</a></p>';
echo '<table class="wp-list-table widefat fixed striped posts">
<thead>
<tr>
<th>ID</th>
<th>Time</th>
<th>Column 1</th>
<th>Column 2</th>
<th>Column 3</th>
</tr>
</thead>
<tbody>';
foreach ( $results as $result ) {
echo '<tr>
<td>' . $result['id'] . '</td>
<td>' . $result['time'] . '</td>
<td>' . $result['column1'] . '</td>
<td>' . $result['column2'] . '</td>
<td>' . $result['column3'] . '</td>
</tr>';
}
echo '</tbody></table>';
}

register_deactivation_hook( __FILE__, 'vehicle_inventory_parser_deactivate' );

function vehicle_inventory_parser_deactivate() {
wp_clear_scheduled_hook( 'vehicle_inventory_parser_cron_job' );
}
That's impressive!

PS: You should check out WP All Import if you haven't heard of them already; we've been using their plugin for 10+ years to import hundreds of thousands of vehicles - super reliable and powerful!
 
  • Like
Reactions: Rick Buffkin
I presume the only way they can do this is the same way they attempt to identify duplicate content between sites.
The AI content doesn't have a signature it leaves behind - it's just a combination of words, re-arranged from other data sources.

I don't see them effectively being able to detect this, unless you're blatantly asking it to write keyword-stuffed SEO content.

I was part of a contest to rank for a certain local term. What eventually ranked number one for the term was lorem ipsum content with the proper keyword density, LSI usage and page structure. Google is nowhere near as smart as people give them credit for.

Googles is miles away from being able to detect this if properly used.
 
:banana: Exciting news! We've revolutionized our review process with the power of ChatGPT and the OpenAI API. Say goodbye to manual posting, as our new online reviews are now automatically shared on Facebook in real-time.

From selecting the best part of the review to creating stunning graphics and crafting engaging post text, we've got it all covered.

First, I used Open AI's API to pick out the best part of the review (max 25 words so that it will be more visually appealing on a graphic).

Then, I used an image generation API to create a social media graphic for the shortened review from a set of 20+ pre-designed templates (it randomly selects a template, so there's ad variety).

Finally, Open AI writes the social media post text and then shares it all on Facebook!

And that's just the beginning! We're also expanding posting to Google Business Profile and Instagram, and soon, we'll be integrating with the Facebook Marketing API to retarget our website visitors and constantly remind them of our great reputation.

What are your thoughts on ChatGPT, and how are you using it in your workflow?

View attachment 7754
This is extremely interesting.