WooCommerce CSV Export-plugin: verschil tussen versies
Naar navigatie springen
Naar zoeken springen
Regel 1: | Regel 1: | ||
Volledige naam van deze WooCommerce-extentie (dus eigenlijk geen plugin): ''WooCommerce Customer / Order / Coupon Export'' | Volledige naam van deze WooCommerce-extentie (dus eigenlijk geen plugin): ''WooCommerce Customer / Order / Coupon Export'' | ||
+ | |||
+ | == Order-export - Issues == | ||
+ | |||
+ | === Two empty lines === | ||
+ | |||
+ | The resulting export file contains two empty lines at the top. So far, I have to remove these manually, before I can use the file for import using ''[[WooCommerce CSV Import Suite]]''. | ||
+ | |||
+ | === order_number missing === | ||
+ | |||
+ | The column ''order_number'' is empy, while ''order_number_formatted'' is not empty. So far, I have to correct this before import, otherwise an error will occur. | ||
+ | |||
+ | === Order notes incomplete === | ||
+ | |||
+ | The ''order notes'' (that describe the history of the order) lack time-stamps & the actors that did something. That's quite problematic, for it destroys the paper trail of an order. | ||
+ | |||
+ | This data is available in a WordPress-site in table <code>wp_comments</code>. E.g.: | ||
+ | |||
+ | <pre> | ||
+ | select | ||
+ | * | ||
+ | from | ||
+ | wp_comments | ||
+ | where | ||
+ | comment_post_id = 65353; | ||
+ | </pre> | ||
== Zie ook == | == Zie ook == |
Versie van 26 mei 2022 13:14
Volledige naam van deze WooCommerce-extentie (dus eigenlijk geen plugin): WooCommerce Customer / Order / Coupon Export
Order-export - Issues
Two empty lines
The resulting export file contains two empty lines at the top. So far, I have to remove these manually, before I can use the file for import using WooCommerce CSV Import Suite.
order_number missing
The column order_number is empy, while order_number_formatted is not empty. So far, I have to correct this before import, otherwise an error will occur.
Order notes incomplete
The order notes (that describe the history of the order) lack time-stamps & the actors that did something. That's quite problematic, for it destroys the paper trail of an order.
This data is available in a WordPress-site in table wp_comments
. E.g.:
select * from wp_comments where comment_post_id = 65353;