Hi,
I replaced the ps_order_export with the original one and it is still using the billing address for both shipping and billing. I have also replaced all the other files with the originals.
Also just looking at the code (and by any means i am definately no expert) and am wondering if the label will also make the data correspond i.e.
//name + address
$sheet->write($startRow + 13, $col, $VM_LANG->_('PHPSHOP_ORDER_PRINT_CUST_BILLING_LBL'), $addressFormat);
$sheet->write($startRow + 14, $col, $db->f("title")." ".$db->f("first_name")." ".$db->f("last_name"));
$sheet->write($startRow + 15, $col, $db->f("address_1"));
$sheet->write($startRow + 16, $col, $db->f("address_2"));
$sheet->write($startRow + 17, $col, $db->f("city"));
$sheet->write($startRow + 18, $col, $db->f("country"));
$sheet->write($startRow + 19, $col, $db->f("zip"));
$col=3;
//name + address
$sheet->write($startRow + 13, $col, $VM_LANG->_('PHPSHOP_ORDER_PRINT_CUST_SHIPPING_LBL'), $addressFormat); - Will having this shipping label make all the data eg name address correspond the the data the customer entered in the shipping address fields?
$sheet->write($startRow + 14, $col, $db->f("title")." ".$db->f("first_name")." ".$db->f("last_name"));
$sheet->write($startRow + 15, $col, $db->f("address_1"));
$sheet->write($startRow + 16, $col, $db->f("address_2"));
$sheet->write($startRow + 17, $col, $db->f("city"));
$sheet->write($startRow + 18, $col, $db->f("country"));
$sheet->write($startRow + 19, $col, $db->f("zip"));
The reason i ask this is because all the $sheet->write... are the same for both shipping and billing, the only difference is the label.
Thanks