Mapping Local Pickup Details to Excel Fields
-
Hello,
I’m a using the WooCommerce Local Pickup plugin by thedotstore.
My goal is to export order data to Excel, including the customer’s chosen pickup location details. I reached out to the Local Pickup support team who provided the following meta fields for this purpose:
_dslpfw_pickup_location_id
_dslpfw_pickup_location_name
_dslpfw_pickup_location_address
_dslpfw_pickup_location_phone
_dslpfw_pickup_location_itemsHowever, when I tried to enter these fields in the custom field mapping section (screenshot attached: [https://prnt.sc/v5I9woBTVvtX]), the information remains blank in the exported Excel (screenshot attached: [https://prnt.sc/neJR07UaJwOw]).
Could you please advise on how to correctly map these fields to ensure the pickup location details are included in the export?
-
please, add this code to section “Misc Settings”
add_filter( "woe_fetch_order", function($row, $order, $object ){
//take 1st shipping
$items = $order->get_items("shipping");
if(empty($items)) return $row; // no shipping ?
$item = reset($items);
$item_id = array_keys($items)[0];
$ds_local_pickup = dslpfw();
$items_to_choose = $order->get_items();
$items_to_pickup = ( !empty( $item['_dslpfw_pickup_items'] ) ? array_map( 'absint', maybe_unserialize( $item['_dslpfw_pickup_items'] ) ) : [] );
$appointment = $ds_local_pickup->get_dslpfw_appointments_object()->get_shipping_item_appointment( $item_id );
$pickup_date = ( $appointment ? $appointment->get_start() : null );
$appointments_mode = $ds_local_pickup->dslpfw_get_shipping_method_instance()->pickup_appointments_mode();
$data = array();
$data['_dslpfw_pickup_location_id'] = $item->get_meta("_dslpfw_pickup_location_id");
$data['_dslpfw_pickup_location_name'] = $ds_local_pickup->get_dslpfw_orders_object()->get_dslpfw_order_items_object()->get_order_item_pickup_location_name( $item_id );
$data['_dslpfw_pickup_location_address'] = $ds_local_pickup->get_dslpfw_orders_object()->get_dslpfw_order_items_object()->get_order_item_pickup_location_address( $item_id, 'plain' ) ;
$data['_dslpfw_pickup_location_phone'] = $ds_local_pickup->get_dslpfw_orders_object()->get_dslpfw_order_items_object()->get_order_item_pickup_location_phone( $item_id, false );
$items = [];
foreach ( $items_to_choose as $id => $item_data ) {
if ( isset( $item_data['name'], $item_data['qty'] ) && in_array( $id, $items_to_pickup, true ) ) {
$items[] = ( is_rtl() ? '× ' . $item_data['qty'] . ' ' . $item_data['name'] : $item_data['name'] . ' × ' . $item_data['qty'] );
}
}
$data['_dslpfw_pickup_location_items'] = implode( ', ', $items ) ;
foreach($data as $k=>$v)
if(isset($row[$k])) $row[$k] = $v;
return $row;
},10,3);
- You must be logged in to reply to this topic.
