Skip to content

Instantly share code, notes, and snippets.

@kkarpieszuk
Created February 20, 2026 14:16
Show Gist options
  • Select an option

  • Save kkarpieszuk/5814d5547a642cfe9d553d4ad5c31d68 to your computer and use it in GitHub Desktop.

Select an option

Save kkarpieszuk/5814d5547a642cfe9d553d4ad5c31d68 to your computer and use it in GitHub Desktop.
/**
* Sets WC Price History migration options (equivalent to INSERT into wp_options).
* Runs once on plugin activation from wp-admin, or via WP-CLI: wp eval-file set-wc-price-migration-status.php
*/
function set_wc_price_migration_status_run() {
$options = array(
'wc_price_history_db_version' => '2.0.0',
'wc_price_history_migration_status' => 'completed',
'wc_price_history_migration_total' => '222',
'wc_price_history_migration_processed'=> '222',
);
foreach ( $options as $name => $value ) {
update_option( $name, $value, 'yes' ); // 'yes' = autoload
}
// Product IDs array (serialized in original SQL) – pass as array so WP serializes it on save
$migrated_products_serialized = 'a:222:{i:0;s:5:"51971";i:1;s:5:"47682";i:2;s:5:"39618";i:3;s:4:"3426";i:4;s:4:"3430";i:5;s:4:"3396";i:6;s:4:"3375";i:7;s:5:"35728";i:8;s:5:"35741";i:9;s:4:"3153";i:10;s:4:"3428";i:11;s:4:"3389";i:12;s:4:"3395";i:13;s:4:"3380";i:14;s:4:"3400";i:15;s:4:"3398";i:16;s:4:"3328";i:17;s:4:"3409";i:18;s:4:"3329";i:19;s:5:"29834";i:20;s:4:"3335";i:21;s:4:"3404";i:22;s:4:"3369";i:23;s:4:"3360";i:24;s:5:"54696";i:25;s:4:"3367";i:26;s:4:"3383";i:27;s:4:"3416";i:28;s:5:"51973";i:29;s:4:"3278";i:30;s:4:"3419";i:31;s:4:"3365";i:32;s:5:"54704";i:33;s:4:"3357";i:34;s:4:"3377";i:35;s:5:"54706";i:36;s:4:"3368";i:37;s:4:"3296";i:38;s:4:"3281";i:39;s:5:"57836";i:40;s:5:"49438";i:41;s:4:"3359";i:42;s:4:"3341";i:43;s:4:"3415";i:44;s:5:"35271";i:45;s:4:"3413";i:46;s:4:"3324";i:47;s:4:"3330";i:48;s:5:"39245";i:49;s:4:"3373";i:50;s:5:"57838";i:51;s:5:"29749";i:52;s:5:"33848";i:53;s:5:"33856";i:54;s:4:"3331";i:55;s:5:"31267";i:56;s:4:"3243";i:57;s:4:"3327";i:58;s:4:"3161";i:59;s:5:"33832";i:60;s:4:"3382";i:61;s:4:"3313";i:62;s:5:"56277";i:63;s:4:"3286";i:64;s:4:"3288";i:65;s:4:"3422";i:66;s:4:"3297";i:67;s:4:"3397";i:68;s:4:"3402";i:69;s:4:"3283";i:70;s:4:"3325";i:71;s:4:"3293";i:72;s:4:"3294";i:73;s:4:"3295";i:74;s:4:"3342";i:75;s:4:"3292";i:76;s:4:"3290";i:77;s:4:"3291";i:78;s:4:"3384";i:79;s:4:"3418";i:80;s:4:"3421";i:81;s:4:"3425";i:82;s:4:"3289";i:83;s:4:"3345";i:84;s:4:"3376";i:85;s:4:"3363";i:86;s:4:"3370";i:87;s:4:"3355";i:88;s:4:"3159";i:89;s:4:"3338";i:90;s:4:"3381";i:91;s:4:"3378";i:92;s:4:"3343";i:93;s:4:"3349";i:94;s:4:"3347";i:95;s:4:"3364";i:96;s:4:"3414";i:97;s:4:"3316";i:98;s:4:"3322";i:99;s:4:"3336";i:100;s:4:"3351";i:101;s:4:"3326";i:102;s:4:"3284";i:103;s:4:"3423";i:104;s:4:"3337";i:105;s:4:"3282";i:106;s:4:"3407";i:107;s:4:"3371";i:108;s:4:"3412";i:109;s:4:"3417";i:110;s:4:"3333";i:111;s:4:"3366";i:112;s:4:"3385";i:113;s:4:"3362";i:114;s:4:"3411";i:115;s:4:"3372";i:116;s:4:"3346";i:117;s:4:"3350";i:118;s:4:"3320";i:119;s:4:"3323";i:120;s:4:"3332";i:121;s:4:"3391";i:122;s:4:"3339";i:123;s:5:"42786";i:124;s:4:"3315";i:125;s:5:"38532";i:126;s:5:"54218";i:127;s:4:"3388";i:128;s:4:"3410";i:129;s:4:"3358";i:130;s:5:"34109";i:131;s:4:"3312";i:132;s:4:"3287";i:133;s:5:"34039";i:134;s:4:"3403";i:135;s:4:"3279";i:136;s:4:"3393";i:137;s:4:"3405";i:138;s:5:"54268";i:139;s:4:"3318";i:140;s:4:"3321";i:141;s:4:"3401";i:142;s:4:"3387";i:143;s:4:"3277";i:144;s:4:"3386";i:145;s:4:"3379";i:146;s:4:"3305";i:147;s:5:"57033";i:148;s:4:"3285";i:149;s:5:"30977";i:150;s:5:"51828";i:151;s:4:"3424";i:152;s:4:"3399";i:153;s:4:"3406";i:154;s:4:"3408";i:155;s:4:"3348";i:156;s:4:"3420";i:157;s:5:"51975";i:158;s:5:"57117";i:159;s:4:"3236";i:160;s:4:"3857";i:161;s:5:"55735";i:162;s:5:"60283";i:163;s:4:"4842";i:164;s:5:"61672";i:165;s:4:"3310";i:166;s:5:"62385";i:167;s:5:"62390";i:168;s:5:"64416";i:169;s:5:"64502";i:170;s:5:"64594";i:171;s:5:"64596";i:172;s:5:"67005";i:173;s:5:"67007";i:174;s:5:"67176";i:175;s:5:"67857";i:176;s:4:"3280";i:177;s:5:"69629";i:178;s:5:"70293";i:179;s:5:"71824";i:180;s:5:"72388";i:181;s:5:"73054";i:182;s:5:"73058";i:183;s:5:"73060";i:184;s:4:"3300";i:185;s:4:"3854";i:186;s:5:"74347";i:187;s:5:"74349";i:188;s:5:"74351";i:189;s:5:"74370";i:190;s:4:"3429";i:191;s:5:"74693";i:192;s:5:"75001";i:193;s:5:"57118";i:194;s:5:"57119";i:195;s:5:"57120";i:196;s:5:"57121";i:197;s:5:"79937";i:198;s:5:"81092";i:199;s:5:"81543";i:200;s:4:"3304";i:201;s:5:"85433";i:202;s:5:"85435";i:203;s:5:"85623";i:204;s:5:"52881";i:205;s:5:"30374";i:206;s:5:"30102";i:207;s:5:"39832";i:208;s:5:"86241";i:209;s:5:"86885";i:210;s:5:"86913";i:211;s:5:"86917";i:212;s:5:"86919";i:213;s:5:"86927";i:214;s:5:"86931";i:215;s:5:"86934";i:216;s:5:"86941";i:217;s:5:"86952";i:218;s:5:"86954";i:219;s:5:"86955";i:220;s:5:"86961";i:221;s:5:"86962";}';
$migrated_products = maybe_unserialize( $migrated_products_serialized );
if ( is_array( $migrated_products ) ) {
update_option( 'wc_price_history_migrated_products', $migrated_products, 'yes' );
}
}
// Run on plugin activation
add_action( 'plugins_loaded', 'set_wc_price_migration_status_run' );
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment