miikewordpress

Wow, I was writing a reply but you already sent me the code!

Your code did work except that the $comment = ""; has left several line breaks in the cell. But it’s still workable on Excel so it’s a lot better. Thank you very much.

May I ask you one thing if you don’t mind.

This works when we added Customer Note. But what if we would like to export only Private Note? Because our note isn’t really necessary for customers.
I don’t think is_private_note actually exists?

Thank you very much!

Thanks Alex for your super quick reply!

I have enabled both Order Notes and Customer Notes.

“Export all order notes” was off and I tried enabling it. I will explain my results.

If “Export all order notes” is OFF, Order Note field is like below,

Order status changed from Completed to Cancelled.
Order status changed from Processing to Completed.
Order status changed from Cancelled to Processing.
Manual Note
Order status changed from Completed to Cancelled.
Order status changed from Cancelled to Completed.
Order status changed from On hold to Cancelled.

If “Export all order notes” is ON, Order Note field is like below,

Order status changed from Completed to Cancelled.
Order status changed from Processing to Completed.
Order status changed from Cancelled to Processing.
Manual Note
Order status changed from Completed to Cancelled.
Order status changed from Cancelled to Completed.
Order status changed from On hold to Cancelled.
Awaiting BACS payment Order status changed from Pending payment to On hold.
Teleno (MS0349) stock reduced from 544 to 543.

Customer Note field is empty in both cases.

Thank you,

Hello Frank,

I tried with Shop Manager role then it worked. I was using a custom role that was created by Members plugin in the past. Maybe that role was a bit buggy.
I’m really sorry for the trouble and thank you very much for your kind answers!

Yes, I did use those exact slugs as I mentioned in the original post.

Left Right
WC Reports wc-reports
WC Settings wc-settings

But they don’t work.
Does it work with your WooCommerce installation if you have one?

Thanks for your answer!

1) I found that the slugs are the same for every role.

The code looks like this.
<ul class='wp-submenu wp-submenu-wrap'><li class='wp-submenu-head' aria-hidden='true'>WooCommerce</li><li class="wp-first-item current"><a href='edit.php?post_type=shop_order' class="wp-first-item current" aria-current="page">Orders <span class="awaiting-mod update-plugins count-5"><span class="processing-count">5</span></span></a></li><li><a href='admin.php?page=network-orders'>Network Orders</a></li><li><a href='admin.php?page=wc-order-export'>Export Orders</a></li><li><a href='admin.php?page=wc-product-subtitle-settings'>WooCommerce Product Subtitle</a></li><li><a href='admin.php?page=wpo_wclabels_options_page'>Address Labels</a></li><li><a href='admin.php?page=wc-reports'>Reports</a></li><li><a href='admin.php?page=wc-settings'>Settings</a></li><li><a href='admin.php?page=wc-status'>Status</a></li><li><a href='admin.php?page=wc-addons'>Extensions </a></li></ul></li>

So the menus that I wanted to disable were wc-reports and wc-settings
but I could not achieve this by adding them to the custom options.

Do you have any suggestions?

Thank you!

Okay I understood.

Thank you very much!

Hello,

Thank you very much for your help!

Oh wow that worked perfectly!

Thank you very much for your help!

Hello Alex!

That worked perfectly thank you,

but I forgot to mention that I need to merge State column as well
so I added below code at the end

.' '.get_post_meta($order->id,'_shipping_state',true);

But it’s giving me state code instead of state name.

Am I doing something wrong?

Thank you very much,

Mike

Has anyone solved this problem?

I found that WC version 3.0 cart.php changed capitalization of some phrases.

Such as,

Continue Shopping -> Continue shopping
Update Cart -> Update cart
Cart Totals -> Cart totals
Proceed to Checkout -> Proceed to checkout
Calculate Shipping -> Calculate shipping

I had to use text editor to change these phrases to match with cart.php to solve the issue because translation PO file for WC 3.0 of my language was not available yet.

But I still have problem with “Shipping” not being translated. I think this one is not related to the capitalization issue.

I tried reverting back to version 1.3.0, then customer notes are shown at the moment.

That worked! I didn’t know I could do add field on your plugin.

Thank you very much for your help!

Okay, thank you very much!

I’m using Express Checkout.