Import settings?

Import/export should work just fine. Export first to see what the data should look like. Unfortunately customer roles are stored as serialized data so it’s not really human-friendly but it can be done.

An export just shows these columns:

post_title
post_excerpt
post_status
post_parent
menu_order
post_date
discount_type
coupon_amount
free_shipping
expiry_date
minimum_amount
maximum_amount
individual_use
exclude_sale_items
product_ids
exclude_product_ids
product_categories
exclude_product_categories
customer_email
usage_limit
usage_limit_per_user
limit_usage_to_x_items
usage_count
_used_by
sc_restrict_to_new_user
wc_sc_add_product_details
sc_coupon_validity
validity_suffix auto_generate_coupon
coupon_title_prefix
coupon_title_suffix
is_pick_price_of_product
sc_disable_email_restriction
sc_is_visible_storewide

With an export plugin we get these:

post_title
ID
post_excerpt
post_status
post_date
post_author
discount_type
coupon_amount
individual_use
product_ids
exclude_product_ids
usage_count
usage_limit
usage_limit_per_user
limit_usage_to_x_items
expiry_date
free_shipping
exclude_sale_items
product_categories
exclude_product_categories
minimum_amount
maximum_amount
customer_email

How can we include the user role when importing?

Following up on this, how can we include the user role when importing?

What export plugin do you use?

https://www.webtoffee.com/product/order-import-export-plugin-for-woocommerce/

It’s the Order, Coupon, Subscription Export Import for WooCommerce by WebToffee (used to be Xadapter).

It looks like that plugin requires a filter for custom meta fields, e.g.: https://www.webtoffee.com/export-url-coupons-meta-data-along-coupon-details-woocommerce/

Either find another import/export plugin or you can contact us at soft79.nl if you want a quote from us to create an integration snippet.