Export order info in one cell

hello

please use >Setup Fields>Shipping>Full Address

to export all products in one cell – please read https://docs.algolplus.com/algol_order_export/add-new-fields/ and adapt 1st code.

There is no full address option

And what i mean nor export all product in one cell i want export one product with name quantity and size in one cell like this

product name \n sku \n quantity \n size

Do you use last version? You should see field “Full Address”.

to combine one product fields – use this way https://docs.algolplus.com/algol_order_export/add-calculated-field-for-product/

Thank u so much

And what are the variables for sku and size? item[‘sku’] item[‘variation’] not work

try $product->get_sku() and $item->get_meta(‘size’)

$product->get_sku() work

$item->get_meta(‘size’) not work

please, use this way to get necessary value
?
$variation = WC_Order_Export_Data_Extractor::get_product_variation( $item, false, $item->get_id(), $item->get_product() );
?

It work, thank you so.much

And last problem, when export xls file and full address is display like

Anne Lam 1568 30th ST Bett, IA 53723

Not

Anne Lam
1568 30th ST
Bett, IA 53723

What’s wrong with it?

There are actually line breaks, but the style doesn’t show the line breaks

Hello

please, open section “Misc Settings” and add this code

add_action( 'woe_xls_print_header', function($objPHPExcel, $formater ) {
$objPHPExcel->getDefaultStyle()->getAlignment()->setWrapText(true);
},10,2);

Hello, thank you for your answer, and it work berrer, if i want to set HORIZONTAL_CENTER and VERTICAL_TOP what’s the code is?

Thank you again for your help

for only one column? or for all columns?

for all columns

Please replace existing code with

add_action( 'woe_xls_print_header', function($objPHPExcel, $formater ) {
$objPHPExcel->getDefaultStyle()->getAlignment()->setWrapText(true);
$objPHPExcel->getDefaultStyle()->getAlignment()->applyFromArray(
array(
'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER,
'vertical' => PHPExcel_Style_Alignment::VERTICAL_TOP
)
);
},10,2);

Thank you so much, all is work all, but if it possible make Embedded Product Image diaply the in the center?