woocommerce > customers DB export issue

  • Resolved hisungwook

    (@hisungwook)


    3 years, 2 months ago

    Hello
    First of all, I’m using a translator to ask questions. Please understand even if the meaning is not conveyed well. Thank you.

    I am working on relocating the woocommerce DB.

    This is the current status.
    A site
    Users = Approximately 28,000 people.
    Order = 18,000 cases.
    Customers = approximately 33,000 people.

    This is the current status after some work has been done to move the DB to the B site.

    B site (We moved the DB until November 2021. I’m going to move to December DB later.)

    Users = 2,7700 people.
    Order = 17500 cases.
    CUSTOMERS = Approximately 1,4900 people.

    The problem is that the number of customers is different.
    Customers know that information such as user orders and guest orders is included.

    The difference between customers on the two sites is about 18,000 people.

    I imported customers db to WooCommerce Customer/Order CSV Export by skyVerge plugin.
    The CSV file has 30,000 data. Of these, 3,000 are customers with an id value of 0.

    I wonder why 33,000 customer DB cannot be exported. Is there a way to get a perfect DB?

    Thank you.

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Mirko P.

    (@rainfallnixfig)

    Hi @hisungwook,

    Thanks for reaching out.

    I understand there is an issue exporting customers and orders from one site and importing them back to another site.

    As a first step, could you please share a copy of your site’s System Status? You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, paste it here in your response.

    Thanks.

    Thread Starter hisungwook

    (@hisungwook)

    Hi @rainfallnixfig

    I express my gratitude for your response.

    I put what you said here.

    Please give me a way or hint to solve this problem.

    ————

    
### WordPress Environment ###

WordPress address (URL): https://blackvue.com
Site address (URL): https://blackvue.com
WC Version: 6.0.0
REST API Version: ? 6.0.0
WC Blocks Version: ? 6.3.3
Action Scheduler Version: ? 3.3.0
WC Admin Version: ? 2.9.4
Log Directory Writable: ?
WP Version: 5.8.2
WP Multisite: –
WP Memory Limit: 100 GB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache/2.4.29 (Ubuntu)
PHP Version: 7.4.21
PHP Post Max Size: 256 MB
PHP Time Limit: 30000000
PHP Max Input Vars: 1000
cURL Version: 7.58.0
OpenSSL/1.1.1

SUHOSIN Installed: –
MySQL Version: 5.7.22-log
Max Upload Size: 256 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ? Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected.
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 5.9.0
WC Database Prefix: wp_
Total Database Size: 4562.21MB
Database Data Size: 4026.59MB
Database Index Size: 535.62MB
wp_woocommerce_sessions: Data: 3.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_order_items: Data: 2.52MB + Index: 1.52MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 14.55MB + Index: 16.03MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_actions: Data: 2.02MB + Index: 1.31MB + Engine InnoDB
wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Data: 1.02MB + Index: 0.61MB + Engine InnoDB
wp_affiliate_wp_affiliatemeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_affiliate_wp_affiliates: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_affiliate_wp_campaigns: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_affiliate_wp_coupons: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_affiliate_wp_creatives: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_affiliate_wp_customermeta: Data: 0.06MB + Index: 0.06MB + Engine InnoDB
wp_affiliate_wp_customers: Data: 0.09MB + Index: 0.06MB + Engine InnoDB
wp_affiliate_wp_payouts: Data: 0.11MB + Index: 0.09MB + Engine InnoDB
wp_affiliate_wp_referralmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_affiliate_wp_referrals: Data: 1.52MB + Index: 0.06MB + Engine InnoDB
wp_affiliate_wp_rest_consumers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_affiliate_wp_sales: Data: 0.08MB + Index: 0.05MB + Engine InnoDB
wp_affiliate_wp_visits: Data: 4.52MB + Index: 1.52MB + Engine InnoDB
wp_ahm_amazons3_sync: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ahm_assets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ahm_asset_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ahm_download_stats: Data: 89.63MB + Index: 0.00MB + Engine InnoDB
wp_ahm_emails: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ahm_sessions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ahm_social_conns: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ahm_user_download_counts: Data: 8.52MB + Index: 0.00MB + Engine InnoDB
wp_as3cf_items: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_aws_cache: Data: 12.52MB + Index: 0.00MB + Engine InnoDB
wp_aws_index: Data: 2.02MB + Index: 0.55MB + Engine InnoDB
wp_bv_activities_store: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_bv_fw_requests: Data: 80.09MB + Index: 0.00MB + Engine InnoDB
wp_bv_ip_store: Data: 0.23MB + Index: 0.27MB + Engine InnoDB
wp_bv_lp_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_cleantalk_ac_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_cleantalk_sessions: Data: 6.13MB + Index: 0.00MB + Engine InnoDB
wp_cleantalk_sfw: Data: 0.44MB + Index: 0.33MB + Engine InnoDB
wp_cleantalk_sfw_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_cleantalk_spamscan_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_cleantalk_ua_bl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_commentmeta: Data: 0.34MB + Index: 0.34MB + Engine InnoDB
wp_comments: Data: 76.61MB + Index: 72.25MB + Engine InnoDB
wp_css_js_manager: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_dlm_order: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_dlm_order_customer: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_dlm_order_item: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_dlm_order_transaction: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_dlm_session: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_download_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_email_log: Data: 777.67MB + Index: 0.00MB + Engine InnoDB
wp_e_submissions: Data: 0.02MB + Index: 0.23MB + Engine InnoDB
wp_e_submissions_actions_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_e_submissions_values: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_fm_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_gf_addon_feed: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_gf_entry: Data: 8.52MB + Index: 1.97MB + Engine InnoDB
wp_gf_entry_meta: Data: 29.56MB + Index: 42.03MB + Engine InnoDB
wp_gf_entry_notes: Data: 10.52MB + Index: 4.03MB + Engine InnoDB
wp_gf_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_gf_form_meta: Data: 0.50MB + Index: 0.00MB + Engine InnoDB
wp_gf_form_revisions: Data: 1.52MB + Index: 0.03MB + Engine InnoDB
wp_gf_form_view: Data: 0.34MB + Index: 0.27MB + Engine InnoDB
wp_gf_rest_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_icl_cms_nav_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_icl_content_status: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_icl_core_status: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_icl_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_icl_languages: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_icl_languages_translations: Data: 0.20MB + Index: 0.13MB + Engine InnoDB
wp_icl_locale_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_icl_message_status: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_icl_mo_files_domains: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_icl_node: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_icl_reminders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_icl_strings: Data: 14.52MB + Index: 16.92MB + Engine InnoDB
wp_icl_string_batches: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_icl_string_packages: Data: 0.14MB + Index: 0.00MB + Engine InnoDB
wp_icl_string_pages: Data: 2.52MB + Index: 3.03MB + Engine InnoDB
wp_icl_string_positions: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
wp_icl_string_status: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_icl_string_translations: Data: 8.52MB + Index: 5.03MB + Engine InnoDB
wp_icl_string_urls: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_icl_translate: Data: 31.02MB + Index: 2.11MB + Engine InnoDB
wp_icl_translate_job: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wp_icl_translations: Data: 1.52MB + Index: 5.75MB + Engine InnoDB
wp_icl_translation_batches: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_icl_translation_downloads: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_icl_translation_status: Data: 42.16MB + Index: 0.27MB + Engine InnoDB
wp_itsec_bans: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_itsec_dashboard_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_itsec_distributed_storage: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_itsec_fingerprints: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_itsec_geolocation_cache: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_itsec_lockouts: Data: 0.06MB + Index: 0.08MB + Engine InnoDB
wp_itsec_logs: Data: 8.52MB + Index: 1.30MB + Engine InnoDB
wp_itsec_mutexes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_itsec_opaque_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_itsec_temp: Data: 0.05MB + Index: 0.06MB + Engine InnoDB
wp_itsec_user_groups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_kboard_board_attached: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wp_kboard_board_content: Data: 4.52MB + Index: 0.17MB + Engine InnoDB
wp_kboard_board_latestview: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_kboard_board_latestview_link: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_kboard_board_meta: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_kboard_board_option: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wp_kboard_board_setting: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_kboard_comments: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_kboard_comments_option: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_kboard_meida: Data: 0.19MB + Index: 0.05MB + Engine InnoDB
wp_kboard_meida_relationships: Data: 0.06MB + Index: 0.05MB + Engine InnoDB
wp_kboard_order_item: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_kboard_order_item_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_kboard_vote: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_layerslider: Data: 2.34MB + Index: 0.00MB + Engine InnoDB
wp_layerslider_revisions: Data: 4.52MB + Index: 0.00MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailerlite_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ngg_album: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ngg_gallery: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ngg_pictures: Data: 1.52MB + Index: 0.02MB + Engine InnoDB
wp_options: Data: 28.05MB + Index: 4.14MB + Engine InnoDB
wp_oses_attachments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_oses_clicks: Data: 1.02MB + Index: 0.28MB + Engine InnoDB
wp_oses_emails: Data: 53.02MB + Index: 1.02MB + Engine InnoDB
wp_oses_email_attachments: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_oses_failures: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
wp_oses_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_images: Data: 0.19MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_imports: Data: 0.03MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_postmeta: Data: 637.72MB + Index: 113.77MB + Engine InnoDB
wp_posts: Data: 69.44MB + Index: 9.58MB + Engine InnoDB
wp_posts_testing: Data: 0.30MB + Index: 0.25MB + Engine InnoDB
wp_rg_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_rg_form_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_rg_form_view: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_rg_incomplete_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_rg_lead: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_rg_lead_detail: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_rg_lead_detail_long: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_rg_lead_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_rg_lead_notes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_spbc_auth_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_spbc_backups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_spbc_firewall_data: Data: 6.52MB + Index: 4.52MB + Engine InnoDB
wp_spbc_firewall_logs: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
wp_spbc_firewall__personal_countries: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_spbc_firewall__personal_countries_temp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_spbc_firewall__personal_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_spbc_firewall__personal_ips_temp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_spbc_scan_results: Data: 8.02MB + Index: 2.25MB + Engine InnoDB
wp_ssf_wp_addon: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ssf_wp_region: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ssf_wp_setting: Data: 0.03MB + Index: 0.00MB + Engine InnoDB
wp_ssf_wp_stores: Data: 0.20MB + Index: 0.00MB + Engine InnoDB
wp_ssf_wp_tag: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_ssf_wp_tracking: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
wp_ssf_wp_track_store: Data: 1.50MB + Index: 0.00MB + Engine InnoDB
wp_store_ratings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_termmeta: Data: 0.09MB + Index: 0.11MB + Engine InnoDB
wp_terms: Data: 0.28MB + Index: 0.34MB + Engine InnoDB
wp_term_relationships: Data: 2.31MB + Index: 1.39MB + Engine InnoDB
wp_term_taxonomy: Data: 0.28MB + Index: 0.30MB + Engine InnoDB
wp_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_usermeta: Data: 75.63MB + Index: 58.14MB + Engine InnoDB
wp_usermeta1: Data: 37.58MB + Index: 36.13MB + Engine InnoDB
wp_usermeta_02_06: Data: 37.58MB + Index: 36.13MB + Engine InnoDB
wp_usermeta_old: Data: 37.58MB + Index: 37.13MB + Engine InnoDB
wp_users: Data: 4.52MB + Index: 4.55MB + Engine InnoDB
wp_users_02_06: Data: 3.52MB + Index: 4.55MB + Engine InnoDB
wp_users_1: Data: 3.52MB + Index: 4.55MB + Engine InnoDB
wp_users_old: Data: 3.52MB + Index: 4.55MB + Engine InnoDB
wp_wcch_page_history: Data: 1650.98MB + Index: 0.00MB + Engine InnoDB
wp_wcpdf_invoice_number: Data: 0.17MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 3.52MB + Index: 4.03MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.09MB + Index: 0.11MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 2.52MB + Index: 3.81MB + Engine InnoDB
wp_wc_order_stats: Data: 3.52MB + Index: 3.30MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.22MB + Index: 0.36MB + Engine InnoDB
wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfblockediplog: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wp_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wfconfig: Data: 3.28MB + Index: 0.00MB + Engine InnoDB
wp_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wffilemods: Data: 11.52MB + Index: 0.00MB + Engine InnoDB
wp_wfhits: Data: 1.02MB + Index: 1.16MB + Engine InnoDB
wp_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfissues: Data: 0.06MB + Index: 0.06MB + Engine InnoDB
wp_wfknownfilelist: Data: 4.52MB + Index: 0.00MB + Engine InnoDB
wp_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wflogins: Data: 1.02MB + Index: 1.08MB + Engine InnoDB
wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wfstatus: Data: 1.02MB + Index: 0.09MB + Engine InnoDB
wp_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wonderplugin_carousel: Data: 1.45MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_exported_csv_items: Data: 45.08MB + Index: 7.02MB + Engine InnoDB
wp_woocommerce_order_itemmeta_testing: Data: 4.52MB + Index: 1.83MB + Engine InnoDB
wp_woocommerce_order_items_testing: Data: 0.09MB + Index: 0.05MB + Engine InnoDB
wp_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpie_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wt_iew_action_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wt_iew_cron: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wt_iew_ftp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wt_iew_mapping_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_yith_wcwl: Data: 0.09MB + Index: 0.02MB + Engine InnoDB
wp_yith_wcwl_lists: Data: 0.09MB + Index: 0.11MB + Engine InnoDB
wp_yoast_indexable: Data: 9.52MB + Index: 6.70MB + Engine InnoDB
wp_yoast_indexable_hierarchy: Data: 0.09MB + Index: 0.14MB + Engine InnoDB
wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yoast_primary_term: Data: 0.08MB + Index: 0.06MB + Engine InnoDB
wp_yoast_seo_links: Data: 2.33MB + Index: 1.20MB + Engine InnoDB
wp_yoast_seo_meta: Data: 1.45MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

acf-field: 297
acf-field-group: 20
attachment: 13586
custom_css: 1
customize_changeset: 1
elementor_library: 301
elementor_snippet: 1
firmware: 4
itsec-dash-card: 17
itsec-dashboard: 2
kboard: 541
nav_menu_item: 173
ngg_album: 1
ngg_gallery: 111
ngg_pictures: 915
oembed_cache: 57
page: 157
post: 1057
product: 132
product_variation: 682
revision: 1586
shop_coupon: 761
shop_order: 18000
shop_order_refund: 233
tm_global_cp: 5
video: 89
wc_product_tab: 312
wpdmpro: 795

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?

### Active Plugins (69) ###

Gravity Forms: by Gravity Forms – 2.5.15
AffiliateWP - Change Admin Emails: by Pippin Williamson – 1.1
LayerSlider WP: by Kreatura Media – 6.11.9
Advanced Custom Fields YITH WooCommerce Compare support: by Oleh Odeshchak – 1.0.4
Advanced Custom Fields PRO: by Delicious Brains – 5.11.4
Advanced Woo Search: by ILLID – 2.43
AffiliateWP: by Sandhills Development
LLC – 2.8.1

AffiliateWP - Affiliate Area Tabs: by Sandhills Development
LLC – 1.4

All-in-One WP Migration: by ServMask – 7.51
Blackhole for Bad Bots: by Jeff Starr – 3.2
BBQ Firewall: by Jeff Starr – 20210719
Anti-Spam by CleanTalk: by СleanTalk  – 5.168
Connector GravityForms MailerLite: by closemarketing – 1.4.1
ELEX DHL Express/DHL Paket WooCommerce Shipping with Print Label: by ELEX – 4.1.8
Download Manager: by W3 Eden
Inc. – 6.0.2

Download Plugins and Themes from Dashboard: by WPFactory – 1.8.1
Elementor Pro: by Elementor.com – 3.5.2
Elementor: by Elementor.com – 3.5.1
Email Log: by Sudar – 2.4.8
Essential Addons for Elementor - Pro: by WPDeveloper – 4.4.0
Essential Addons for Elementor: by WPDeveloper – 4.9.7
Express Checkout via PayPal for WooCommerce: by wpgateways – 4.0.5
Featured Video Plus: by Alexander H?reth – 2.3.3
Multiple Columns for Gravity Forms: by WebHolism – 4.0.0
GTranslate: by Translate AI Multilingual Solutions – 2.9.6
HubSpot WooCommerce Integration COMPLIMENTARY: by MakeWebBetter – 2.0.1
Import and export users and customers: by codection – 1.19.1.2
iThemes Security Pro: by iThemes – 7.0.3
KBoard : Comments: by ????? - Cosmosfarm – 4.8
KBoard : Forum: by ????? - Cosmosfarm – 5.7
MGR CUSTOMER PORTAL: by MGR – 1.1
Official MailerLite Sign Up Forms: by MailerGroup – 1.4.9
PowerPack Pro for Elementor: by Team IdeaBox - PowerPack Elements – 2.2.0
reSmush.it Image Optimizer: by reSmush.it – 0.4.2
String Locator: by Clorith – 2.4.2
Sucuri Security - Auditing, Malware Scanner and Hardening: by Sucuri Inc. – 1.8.30
Super Store Finder WordPress: by Joe Iz – 6.5
SVG Support: by Benbodhi – 2.3.19
UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
DavidAnderson – 2.16.22.24

WordPress Users & WooCommerce Customers Import Export(BASIC): by WebToffee – 2.2.3
White Label CMS: by www.videousermanuals.com – 2.2.6
Widget Importer & Exporter: by ChurchThemes.com – 1.6
Wonder Carousel Pro: by Magic Hills Pty Ltd – 18.3C
Advanced Order Export For WooCommerce: by AlgolPlus – 3.2.2
Woocommerce Coupon Import: by JDSofttech – 1.0
WooCommerce Customer History: by Brian Richards – 1.2.1
WooCommerce Customer/Order CSV Export: by SkyVerge – 4.8.1
Print Invoice & Delivery Notes for WooCommerce: by Tyche Softwares – 4.6.4
WooCommerce Export Customer Email: by MH Mithu – 1.3
WooCommerce Stripe Gateway: by WooCommerce – 5.9.0
WooCommerce Min/Max Quantities: by WooCommerce – 2.4.15
WooCommerce PDF Invoices & Packing Slips: by Ewout Fernhout – 2.11.1
WooCommerce Product CSV Import Suite: by WooCommerce – 1.10.46
WooCommerce Shipping & Tax: by WooCommerce – 1.25.20
WooCommerce Tab Manager: by SkyVerge – 1.12.1
WooCommerce TM Extra Product Options: by themeComplete – 4.9.12.1
WooCommerce: by Automattic – 6.0.0
Yoast SEO Premium: by Team Yoast – 14.6.1
WP Crontrol: by John Blackbourn & crontributors – 1.12.0
WP Rocket: by WP Media – 3.6.1
WP Offload SES Lite: by Delicious Brains – 1.4.6
WPDM - Amazon s3: by WordPress Download Manager – 3.0.3
WP Remote: by WP Remote – 4.69
WPS Hide Login: by WPServeur
NicolasKulka
wpformation – 1.9.2

YITH WooCommerce Anti-Fraud Premium: by YITH – 1.2.9
YITH WooCommerce Compare Premium: by YITH – 2.3.20
YITH Pre-Order for WooCommerce Premium: by YITH – 1.5.7
YITH WooCommerce Wishlist: by YITH – 3.4.0
Youtube Thumbnail to Featured Image: by Chuy Sánchez – 1.1

### Inactive Plugins (15) ###

Advanced Custom Fields Multilingual: by OnTheGoSystems – 1.9.3
Download Monitor: by WPChill – 4.4.13
Elementor Pro: by Elementor.com – 3.5.1
Google Tag Manager for WordPress: by Thomas Geiger – 1.14.1
Jetpack: by Automattic – 10.4
Order / Coupon / Subscription Export Import Plugin for WooCommerce (BASIC): by WebToffee – 2.1.4
PixelYourSite: by PixelYourSite – 8.2.15
WooCommerce Customer/Order/Coupon Export: by SkyVerge – 5.3.3
WooCommerce Multilingual: by OnTheGoSystems – 4.12.1
WPML CMS Nav: by OnTheGoSystems – 1.5.5
WPML Media: by OnTheGoSystems – 2.6.5
WPML Multilingual CMS: by OnTheGoSystems – 4.4.12
WPML Sticky Links: by OnTheGoSystems – 1.5.4
WPML String Translation: by OnTheGoSystems – 3.1.10
WPML Translation Management: by OnTheGoSystems – 2.10.8

### Dropin Plugins (1) ###

advanced-cache.php: advanced-cache.php

### Must Use Plugins (1) ###

Elementor Safe Mode: by Elementor.com – 1.0.0

### Settings ###

API Enabled: ?
Force SSL: –
Currency: USD (USD)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-1 (rated-1)
rated-2 (rated-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)

Connected to WooCommerce.com: –

### WC Pages ###

Shop base: #56 - /shop/
Cart: #57 - /cart/
Checkout: #154978 - /checkout/
My account: #154979 - /my-account/
Terms and conditions: #110444 - /warranty-terms-conditions/

### Theme ###

Name: blackvue-child
Version: 1.0.0
Author URL: https://wpastra.com/about/
Child Theme: ?
Parent Theme Name: Astra
Parent Theme Version: 3.7.6
Parent Theme Author URL: https://wpastra.com/about/?utm_source=theme_preview&utm_medium=author_link&utm_campaign=astra_theme
WooCommerce Support: ?

### Templates ###

Overrides: blackvue-child/woocommerce/archive-product.php
/var/www/html/wp-content/plugins/woocommerce-tm-extra-product-options/templates/cart/cart-item-data.php
blackvue-child/woocommerce/cart/cart-shipping.php
blackvue-child/woocommerce/cart/cart-totals.php
blackvue-child/woocommerce/cart/cart.php version 3.7.0 is out of date. The core version is 3.8.0
blackvue-child/woocommerce/checkout/form-billing.php
blackvue-child/woocommerce/checkout/form-checkout.php
blackvue-child/woocommerce/checkout/form-login.php version 3.4.0 is out of date. The core version is 3.8.0
blackvue-child/woocommerce/checkout/form-shipping.php
blackvue-child/woocommerce/checkout/payment-method.php version 2.3.0 is out of date. The core version is 3.5.0
blackvue-child/woocommerce/checkout/review-order.php version 3.3.0 is out of date. The core version is 5.2.0
blackvue-child/woocommerce/checkout/terms.php
blackvue-child/woocommerce/checkout/thankyou.php
blackvue-child/woocommerce/content-single-product.php
blackvue-child/woocommerce/global/breadcrumb.php
blackvue-child/woocommerce/global/form-login.php
blackvue-child/woocommerce/global/quantity-input.php version 3.6.0 is out of date. The core version is 4.0.0
blackvue-child/woocommerce/global/sidebar.php
blackvue-child/woocommerce/global/wrapper-end.php
blackvue-child/woocommerce/global/wrapper-start.php
blackvue-child/woocommerce/myaccount/dashboard.php version 2.6.0 is out of date. The core version is 4.4.0
blackvue-child/woocommerce/myaccount/form-edit-account.php
blackvue-child/woocommerce/myaccount/form-login.php version 3.6.0 is out of date. The core version is 4.1.0
blackvue-child/woocommerce/myaccount/form-lost-password.php
blackvue-child/woocommerce/myaccount/my-account.php
blackvue-child/woocommerce/myaccount/my-orders.php
blackvue-child/woocommerce/myaccount/orders.php
blackvue-child/woocommerce/myaccount/view-order.php
blackvue-child/woocommerce/single-product/add-to-cart/external.php
blackvue-child/woocommerce/single-product/add-to-cart/grouped.php version 3.4.0 is out of date. The core version is 4.8.0
blackvue-child/woocommerce/single-product/add-to-cart/simple.php
blackvue-child/woocommerce/single-product/add-to-cart/variable.php
blackvue-child/woocommerce/single-product/add-to-cart/variation-add-to-cart-button.php
blackvue-child/woocommerce/single-product/add-to-cart/variation.php
blackvue-child/woocommerce/single-product/price.php
blackvue-child/woocommerce/single-product/product-attributes.php
blackvue-child/woocommerce/single-product/review.php
blackvue-child/woocommerce/single-product/share.php
blackvue-child/woocommerce/single-product/short-description.php
blackvue-child/woocommerce/single-product/tabs/additional-information.php
blackvue-child/woocommerce/single-product/tabs/description.php
blackvue-child/woocommerce/single-product/tabs/tabs.php version 2.4.0 is out of date. The core version is 3.8.0
blackvue-child/woocommerce/single-product/up-sells.php

Outdated Templates: ?
					
					
						Learn how to update

### Customer/Order CSV Export ###

Order Export Format: default_one_row_per_item
Customer Export Format: default
Automatically Export Orders: disabled
Automatically Export Customers: disabled

### Action Scheduler ###

Canceled: 1
Oldest: 2021-12-27 16:40:05 +0900
Newest: 2021-12-27 16:40:05 +0900

Complete: 3,999
Oldest: 2021-11-30 08:52:00 +0900
Newest: 2021-12-28 12:50:13 +0900

Failed: 1
Oldest: –
Newest: –

### Status report information ###

Generated at: 2021-12-28 13:07:24 +09:00
    Thread Starter hisungwook

    (@hisungwook)

    The problem has been solved.

    It was a problem caused by my mistake.

    • This reply was modified 3 years, 2 months ago by hisungwook.

    Hi @hisungwook

    Thanks for letting us know.

    Please feel free to open a new thread if you have any other questions.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘woocommerce > customers DB export issue’ is closed to new replies.