Export Order Product Title has 1 x added to start of title (quantity)
-
One more question on the export order from vendor dashboard and from the orders page itself.
In the column Product Title, it includes “Qty x” (eg “1 x”) before title. This should be two separate columns, one for quantity and one for actual title. The reason my vendors download these csvs is to upload into their system, and they would have to parse this column every single time to make sure they have the quantity and title as separate fields. The title column should match the actual title, not have extra letters and numbers added to the beginning.
Here is link again to show what output looks like. https://www.dropbox.com/scl/fi/1gc0ec73f2zwotpeces78/wc-vendor-download.jpg?rlkey=rhk0wj2mxnvg6g4mtrbmknqzp&dl=0
Dashboard>Orders also displays it that way, however since they aren’t using that to upload anywhere it’s not as big a deal.
Is there a way to have these as two separate columns in the export order csv?
-
Hi @eftcolumbus,
Thanks for the reply.
I have raised the issue to show the product quantity in a separate column to our development team. In the meantime, you can remove the product quantity from the exported orders CSV file by adding the PHP code snippet below to your child theme’s functions.php file or via a code snippet plugin:
add_filter( 'wcv_order_export_csv_rows', 'wcv_order_export_csv_rows_1', 10, 2 );
/**
* Remove the product quantity in the CSV export.
*
* @param array $rows Array of rows.
* @param array $orders Array of orders.
*/
function wcv_order_export_csv_rows_1( $rows, $orders ) {
if ( empty( $orders ) ) {
return $rows;
}
foreach ( $rows as &$row ) {
// Fetch the order using the order_number from the row.
$row_order = wc_get_order( $row['order_number'] );
if ( ! $row_order ) {
continue; // Skip if the order couldn't be retrieved.
}
// Initialize products string.
$products = '';
// Fetch the order items from the WC_Order object.
$vendor_order_items = $row_order->get_items();
foreach ( $vendor_order_items as $item_id => $item ) {
// Get the product name for each order item.
$item_name = $item->get_name();
$products .= $item_name . '\n'; // Add product name to the products list.
}
// Add the products list to the row data.
$row['products'] = $products;
}
unset( $row );
return $rows;
}I hope this helps, let me know how it goes.
Best regards,
Hi @eftcolumbus, the PHP code snippet removes the product quantity from the “Product Title” column on the exported orders CSV file as seen on the screenshot below. However, it doesn’t remove the product quantity shown on the Orders screen in the dashboard.
- You must be logged in to reply to this topic.
