Hello @bhzone,
You can export your orders, including the invoice date and number, within WooCommerce > Export Orders > Set up fields to export, adding the _wcpdf_invoice_number
and _wcpdf_invoice_date_formatted
fields, this way:
- Click on Common > Add field, on the right side, and select
_wcpdf_invoice_number
in the dropdown.
- Write your custom name in Column name field, e.g. Invoice Number
- Drag & drop the new added field to the left panel in your desired position. Each field here represents a column in the export document, and the organization is based on the position of the field, e.g., if you drag the fields to the top, they appear in the first position to the left of the document.
Then, repeat these steps with _wcpdf_invoice_date_formatted
.
Let me know if it works!
Thread Starter
bhzone
(@bhzone)
Thanks for you reply. The steps you mentioned are exactly the same steps I tried, thanks you for confirming that they are correct.
But in preview and in the exported excel those columns are not populated 🙁
I tried to define “Field format” to be “text” but didnt worked either.
The newly added custom fields are blinking untill i drag them to the left side, beside other export fields, its normal behaviour or im doing something wrong?