Unserialize data from Schedule Delivery Date plugin by Themehigh

hello

do you use this free plugin ?
https://www.ads-software.com/plugins/schedule-product-delivery-date-for-woocommerce/

for https://www.unserialize.com/s/635f96ae-1e3b-94e9-a233-00007593ea95
What results you expect to see inside the cell ?
I need exact text

Hey there, I use the paid version of that plugin.

This is what gets returned unserialized:

Array
(
    [2022-08-01] => Array
        (
            [quantity] => 1
            [status] => 1
        )

    [2022-08-03] => Array
        (
            [quantity] => 1
            [status] => 1
        )

    [2022-08-05] => Array
        (
            [quantity] => 1
            [status] => 1
        )

    [2022-08-08] => Array
        (
            [quantity] => 1
            [status] => 1
        )

    [2022-08-10] => Array
        (
            [quantity] => 1
            [status] => 1
        )

    [2022-08-12] => Array
        (
            [quantity] => 1
            [status] => 1
        )

    [2022-08-15] => Array
        (
            [quantity] => 1
            [status] => 1
        )

    [2022-08-17] => Array
        (
            [quantity] => 1
            [status] => 1
        )

    [2022-08-19] => Array
        (
            [quantity] => 1
            [status] => 1
        )

    [2022-08-22] => Array
        (
            [quantity] => 1
            [status] => 1
        )

    [2022-08-24] => Array
        (
            [quantity] => 1
            [status] => 1
        )

    [2022-08-26] => Array
        (
            [quantity] => 1
            [status] => 1
        )

)

Ideally I need just the dates. Or even explode the dates into separate columns with the product repeated under each date but… I know that’s a little more complicated.

hi
here simplest solution.

please,
follow to https://docs.algolplus.com/algol_order_export/add-calculated-field-for-product/
add key _ptdt_delivery_date
use this code

add_filter('woe_get_order_product_value__ptdt_delivery_date', function ($value, $order, $item, $product,$item_meta) {
$data = maybe_unserialize($value);
if(is_array($data)) {
  $lines = array();
  foreach($data as $day=>$info) 
    $lines[] = $day . ":" . $info['quantity'];
  $value =  join("\n", $lines);
}
return $value;
}, 10, 5);

Awesome ! This is closer to a solution I need. Before I purchase the pro version of this plugin… wondering if this scenario is possible:

Create a scheduled job, Export date range: Current week, **Filter orders by: _ptdt_delivery_date ** . AKA the report pulls the data of the products with delivery dates in the current week?

Right now I have this being generated: https://triwaredev.ca/smilk/wp-content/uploads/2022/08/orders-2022-08-18-15-33-35.pdf which is good… but I want to be able to generate the report for only items being delivered this week. As well I’d love to be able to group the rows by Date and teacher field, similar to this: https://triwaredev.ca/smilk/wp-content/uploads/2022/08/St.-Marys-Elementary_All_Grades_2022-06-20-2022-06-22_milk_order_summary.xlsx

Is it possible to sort and group by custom fields? Appreciate your help very very much.

Hello

Please, submit your request as new ticket to https://algolplus.freshdesk.com/.

This forum should be used only to discuss free version features.

thanks, Alex

Ok thank you. Thanks for your help!