Customer data migration

  • Resolved abatechnicalhelp

    (@abatechnicalhelp)


    2 years, 6 months ago

    Hello, I want to migrate from lexblogger.com all subscriptions, orders associated to these subscriptions and also their customer accounts to access this data from their customer portal.

    The destination wordpress is under a license I also have under my yithemes account for the domain legalbox.plus – where I already have customers who signed up using yith from legalbox.plus.

    For this migration, I think the below are the main tables to take into account and wanted to confirm with you whether this steps and tables are correct before doing it myself.

    [ redundant link removed ]

    SUBSCRIPTIONS
    The tables I have identified from the yith subscriptions are as follows:
    v6jpo05u3_yith_ywsbs_activities_log
    v6jpo05u3_yith_ywsbs_order_lookup
    v6jpo05u3_yith_ywsbs_revenue_lookup
    v6jpo05u3_yith_ywsbs_stats

    I would need to add these above to the same tables in destination domain.

    ORDERS (woocommerce)
    The tables I have identified from the woocommerce orders associated to yith subscriptions are as follows:
    wpstg1_woocommerce_order_items

    CUSTOMERS (wordpress)
    I can export personal data from wordpress but HOW do I import to the TO domain in wordpress so customer gain access from legalbox.plus to see the same information they see in lexblogger right now?

    QUESTIONS:
    1- Do I have to check if any of the subscriptions id or orders id are already in the TO domain before adding these to the TO domain? (to avoid overwriting information in TO domain)
    2-I was able to export personal data from FROM domain lexblogger but unable to find an option to import to the TO domain legalbox.plus.

    One of the challenges I have is that the TO domain, legalbox.plus, is already working with new customers and I cannot just migrate the whole site with any plugins available but need to migrate pieces of it such as subscriptions in this case.

    Could you please advise?

    Many thanks for all your help in moving forward with this migration.

    Ainhoa

    • This topic was modified 2 years, 6 months ago by abatechnicalhelp.
    • This topic was modified 2 years, 6 months ago by abatechnicalhelp.
    • This topic was modified 2 years, 6 months ago by Jan Dembowski. Reason: Moved to Fixing WordPress, this is not an Everything else WordPress topic
    • This topic was modified 2 years, 6 months ago by Jan Dembowski.
    • This topic was modified 2 years, 6 months ago by James Huff.
    • This topic was modified 2 years, 6 months ago by James Huff.

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

Viewing 4 replies - 1 through 4 (of 4 total)

  • Hi @abatechnicalhelp

    Thanks for sharing all the details about the migration.

    It is not clear if the query is related to the core WooCommerce, but so that we can check that 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.

    Just to keep you informed that this particular forum is for questions that are directly related to the features and functionality of the free WooCommerce core plugin.

    We’ll look forward to seeing the System Status report.

    Thanks

    Thread Starter abatechnicalhelp

    (@abatechnicalhelp)

    Thanks Margaret for your response. Here is the report as requested.

    
### WordPress Environment ###

WordPress address (URL): https://legalbox.plus
Site address (URL): https://legalbox.plus
WC Version: 6.4.1
REST API Version: ? 6.4.1
WC Blocks Version: ? 7.2.2
Action Scheduler Version: ? 3.4.0
WC Admin Version: ? 3.3.2
Log Directory Writable: ?
WP Version: 5.9.3
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: ?
Language: es_ES
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.3.33
PHP Post Max Size: 128 MB
PHP Time Limit: 0
PHP Max Input Vars: 10000
cURL Version: 7.71.0
OpenSSL/1.1.1d

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.3.32-MariaDB-cll-lve
Max Upload Size: 128 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 6.3.1
WC Database Prefix: w47fa_
Tama?o total de la base de datos: 447.76MB
Tama?o de los datos de la base de datos: 403.20MB
Tama?o del índice de la base de datos: 44.56MB
w47fa_woocommerce_sessions: Datos: 0.09MB + índice: 0.02MB + Motor InnoDB
w47fa_woocommerce_api_keys: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
w47fa_woocommerce_attribute_taxonomies: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
w47fa_woocommerce_downloadable_product_permissions: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB
w47fa_woocommerce_order_items: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
w47fa_woocommerce_order_itemmeta: Datos: 0.16MB + índice: 0.06MB + Motor InnoDB
w47fa_woocommerce_tax_rates: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB
w47fa_woocommerce_tax_rate_locations: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
w47fa_woocommerce_shipping_zones: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_woocommerce_shipping_zone_locations: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
w47fa_woocommerce_shipping_zone_methods: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_woocommerce_payment_tokens: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
w47fa_woocommerce_payment_tokenmeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
w47fa_woocommerce_log: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
w47fa_actionscheduler_actions: Datos: 0.42MB + índice: 0.58MB + Motor InnoDB
w47fa_actionscheduler_claims: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
w47fa_actionscheduler_groups: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
w47fa_actionscheduler_logs: Datos: 0.28MB + índice: 0.23MB + Motor InnoDB
w47fa_affiliate_wp_affiliatemeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
w47fa_affiliate_wp_affiliates: Datos: 0.06MB + índice: 0.02MB + Motor InnoDB
w47fa_affiliate_wp_campaigns: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
w47fa_affiliate_wp_coupons: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
w47fa_affiliate_wp_creatives: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
w47fa_affiliate_wp_customermeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
w47fa_affiliate_wp_customers: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
w47fa_affiliate_wp_lifetime_customers: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
w47fa_affiliate_wp_payouts: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
w47fa_affiliate_wp_referralmeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
w47fa_affiliate_wp_referrals: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
w47fa_affiliate_wp_rest_consumers: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
w47fa_affiliate_wp_sales: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
w47fa_affiliate_wp_visits: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
w47fa_commentmeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
w47fa_comments: Datos: 0.23MB + índice: 0.09MB + Motor InnoDB
w47fa_cw_saved_widgets_options: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_cw_widgets_options: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_e_events: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
w47fa_e_submissions: Datos: 0.11MB + índice: 0.27MB + Motor InnoDB
w47fa_e_submissions_actions_log: Datos: 0.02MB + índice: 0.11MB + Motor InnoDB
w47fa_e_submissions_values: Datos: 0.09MB + índice: 0.03MB + Motor InnoDB
w47fa_gdpr_cc_options: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_learndash_pro_quiz_category: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_learndash_pro_quiz_form: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
w47fa_learndash_pro_quiz_lock: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_learndash_pro_quiz_master: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_learndash_pro_quiz_prerequisite: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_learndash_pro_quiz_question: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
w47fa_learndash_pro_quiz_statistic: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_learndash_pro_quiz_statistic_ref: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
w47fa_learndash_pro_quiz_template: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_learndash_pro_quiz_toplist: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_learndash_user_activity: Datos: 0.02MB + índice: 0.13MB + Motor InnoDB
w47fa_learndash_user_activity_meta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
w47fa_links: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
w47fa_options: Datos: 6.39MB + índice: 0.22MB + Motor InnoDB
w47fa_postmeta: Datos: 270.52MB + índice: 5.83MB + Motor InnoDB
w47fa_posts: Datos: 95.52MB + índice: 0.55MB + Motor InnoDB
w47fa_rank_math_404_logs: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
w47fa_rank_math_analytics_gsc: Datos: 3.45MB + índice: 4.81MB + Motor InnoDB
w47fa_rank_math_analytics_inspections: Datos: 0.06MB + índice: 0.11MB + Motor InnoDB
w47fa_rank_math_analytics_objects: Datos: 0.09MB + índice: 0.05MB + Motor InnoDB
w47fa_rank_math_internal_links: Datos: 0.14MB + índice: 0.05MB + Motor InnoDB
w47fa_rank_math_internal_meta: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_rank_math_redirections: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
w47fa_rank_math_redirections_cache: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
w47fa_redirection_404: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB
w47fa_redirection_groups: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
w47fa_redirection_items: Datos: 0.02MB + índice: 0.09MB + Motor InnoDB
w47fa_redirection_logs: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB
w47fa_sg_action: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_sg_config: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_sg_schedule: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_smush_dir_images: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
w47fa_swp_analytics: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_tab_event_log: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB
w47fa_tab_tests: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
w47fa_tab_test_items: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB
w47fa_tap_error_log: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_tcb_api_error_log: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_tcm_email_hash: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_tcm_logs: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
w47fa_td_fields: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_td_groups: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_termmeta: Datos: 0.03MB + índice: 0.03MB + Motor InnoDB
w47fa_terms: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
w47fa_term_relationships: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
w47fa_term_taxonomy: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
w47fa_tge_answers: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
w47fa_tge_questions: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
w47fa_tho_event_log: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_tho_tests: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_tho_test_items: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_thrive_debug: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_tm_taskmeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
w47fa_tm_tasks: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
w47fa_tqb_event_log: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
w47fa_tqb_results: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_tqb_results_links: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB
w47fa_tqb_tests: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_tqb_tests_items: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_tqb_users: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB
w47fa_tqb_user_answers: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_tqb_variations: Datos: 0.05MB + índice: 0.00MB + Motor InnoDB
w47fa_tva_bundles: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_tva_ipn_log: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_tva_orders: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
w47fa_tva_order_items: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
w47fa_tva_tokens: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_tva_transactions: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_tve_leads_contacts: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_tve_leads_contact_download: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_tve_leads_event_log: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
w47fa_tve_leads_form_summary: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
w47fa_tve_leads_form_variations: Datos: 0.27MB + índice: 0.06MB + Motor InnoDB
w47fa_tve_leads_group_options: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_tve_leads_saved_group_options: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_tve_leads_split_test: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_tve_leads_split_test_items: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_tve_ult_designs: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_tve_ult_emails: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_tve_ult_events: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_tve_ult_event_log: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_tve_ult_settings_campaign: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_tve_ult_settings_templates: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_tvo_activity_log: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_usermeta: Datos: 2.52MB + índice: 3.03MB + Motor InnoDB
w47fa_users: Datos: 0.19MB + índice: 0.16MB + Motor InnoDB
w47fa_wcpdf_invoice_number: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_wc_admin_notes: Datos: 0.05MB + índice: 0.00MB + Motor InnoDB
w47fa_wc_admin_note_actions: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
w47fa_wc_category_lookup: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_wc_customer_lookup: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
w47fa_wc_download_log: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
w47fa_wc_order_coupon_lookup: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
w47fa_wc_order_product_lookup: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB
w47fa_wc_order_stats: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB
w47fa_wc_order_tax_lookup: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
w47fa_wc_product_attributes_lookup: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
w47fa_wc_product_meta_lookup: Datos: 0.02MB + índice: 0.09MB + Motor InnoDB
w47fa_wc_rate_limits: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
w47fa_wc_reserved_stock: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_wc_tax_rate_classes: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
w47fa_wc_webhooks: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
w47fa_wsal_metadata: Datos: 14.02MB + índice: 25.08MB + Motor InnoDB
w47fa_wsal_occurrences: Datos: 5.52MB + índice: 0.80MB + Motor InnoDB
w47fa_wt_iew_action_history: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_wt_iew_cron: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_wt_iew_ftp: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_wt_iew_mapping_template: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_yith_vendors_commissions: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_yith_vendors_commissions_notes: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_yith_vendors_payments: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_yith_vendors_payments_relationship: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_yith_wcac_background_process_batches: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
w47fa_yith_wcac_register: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_yith_wcac_waiting_orders: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
w47fa_yith_wcaf_affiliates: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_yith_wcaf_clicks: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_yith_wcaf_commissions: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_yith_wcaf_commission_notes: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_yith_wcaf_payments: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_yith_wcaf_payment_commission: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_yith_wcaf_payment_notes: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_yith_wcmbs_downloads_log: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_yith_wc_stripe_blacklist: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB
w47fa_yith_ywsbs_activities_log: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_yith_ywsbs_delivery_schedules: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_yith_ywsbs_order_lookup: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_yith_ywsbs_revenue_lookup: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
w47fa_yith_ywsbs_stats: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB

### Post Type Counts ###

_tcb_form_settings: 9
attachment: 375
custom_css: 1
customize_changeset: 8
e-landing-page: 1
elementor_library: 22
nav_menu_item: 13
oembed_cache: 3
page: 72
post: 48
product: 13
revision: 4530
shop_coupon: 16
shop_order: 38
shop_order_refund: 2
tcb_content_template: 7
tcb_symbol: 3
thrive_image: 1
thrive_layout: 3
thrive_section: 1
thrive_template: 17
thrive_typography: 2
tqb_optin: 1
tqb_quiz: 1
tqb_results: 1
tqb_splash: 1
tva_chapter: 1
tva_course_overview: 5
tva_course_type: 1
tva_lesson: 12
tva_module: 2
tva-acc-restriction: 2
tve_form_type: 2
tve_lead_1c_signup: 2
tve_lead_2s_lightbox: 2
tve_lead_group: 2
tve_lead_shortcode: 6
tve_notifications: 1
wp_global_styles: 1
wpcf7_contact_form: 1
ywsbs_subscription: 41

### Security ###

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

### Active Plugins (62) ###

AffiliateWP - Lifetime Commissions: por Sandhills Development
LLC – 1.6.1

AffiliateWP - PayPal Payouts: por Pippin Williamson and Andrew Munro – 1.4
AffiliateWP: por AffiliateWP – 2.9.3
AffiliateWP - ActiveCampaign: por Daniel J Griffiths – 1.0.1
AffiliateWP - Affiliate Area Shortcodes: por Sandhills Development
LLC – 1.3

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

AffiliateWP - Affiliate Dashboard Sharing: por Sandhills Development
LLC – 1.3

AffiliateWP - Affiliate Info: por Sandhills Development
LLC – 1.2

AffiliateWP - Allowed Products: por Sandhills Development
LLC – 1.3

AffiliateWP - External Referral Links: por Sandhills Development
LLC – 1.2

AffiliateWP - Leaderboard: por Sandhills Development
LLC – 1.2

AffiliateWP - Order Details For Affiliates: por Sandhills Development
LLC – 1.3

AffiliateWP - Sign Up Bonus: por Sandhills Development
LLC – 1.3

AffiliateWP - Store Credit: por Sandhills Development
LLC – 2.5

All-in-One WP Migration: por ServMask – 7.59
Titan Anti-spam & Security: por CreativeMotion – 7.3.0
Backup: por BackupGuard – 1.6.8.6
Better Click To Tweet: por Ben Meredith – 5.10.2
Child Theme Configurator: por Lilaea Media – 2.5.9
Editor clásico: por Colaboradores de WordPress – 1.6.2
Contact Form 7: por Takayuki Miyoshi – 5.5.6
Cookiebot | GDPR/CCPA Compliant Cookie Consent and Control: por Cybot A/S – 4.0.3
Yoast Duplicate Post: por Enrico Battocchi & Team Yoast – 4.4
Elementor Pro: por Elementor.com – 3.6.5
Elementor: por Elementor.com – 3.6.5
Site Kit by Google: por Google – 1.73.0
LuckyWP Table of Contents: por LuckyWP – 2.1.4
mowomo Support para Lex: por mowomo – 1.0.0
Regenerate Thumbnails: por Alex Mills (Viper007Bond) – 3.1.5
Rank Math SEO: por Rank Math – 1.0.87
LearnDash LMS: por LearnDash – 4.1.1
Simple Google reCAPTCHA: por Michal Novák – 3.9
Social Warfare: por Warfare Plugins – 4.3.0
Thrive Optimize: por Thrive Themes – 2.6.1
Thrive Apprentice: por <a href="https://thrivethemes.com">Thrive Themes</a> – 4.2.3
Thrive Automator: por <a href="https://thrivethemes.com">Thrive Themes</a> – 0.7
Thrive Clever Widgets: por <a href="https://thrivethemes.com">Thrive Themes</a> – 2.9.1
Thrive Comments: por <a href="https://thrivethemes.com">Thrive Themes</a> – 2.6.1
Thrive Headline Optimizer: por <a href="https://thrivethemes.com">Thrive Themes</a> – 2.3.1
Thrive Leads: por <a href="https://thrivethemes.com">Thrive Themes</a> – 3.6.2
Thrive Ovation: por <a href="https://thrivethemes.com">Thrive Themes</a> – 3.6.1
Thrive Product Manager: por Thrive Themes – 1.2.7
Thrive Quiz Builder: por <a href="https://thrivethemes.com">Thrive Themes</a> – 3.6.2
Thrive Ultimatum: por <a href="https://thrivethemes.com">Thrive Themes</a> – 3.6.2
Thrive Architect: por <a href="https://www.thrivethemes.com">Thrive Themes</a> – 3.8.2
Advanced Editor Tools (previously TinyMCE Advanced): por Automattic – 5.6.0
URL Coupons for WooCommerce: por WPFactory – 1.6.4
WordPress Users & WooCommerce Customers Import Export(BASIC): por WebToffee – 2.2.9
WooCommerce: por Automattic – 6.4.1 (la actualización a la versión 6.5.0 está disponible)
WordPress Importer: por wordpressdotorg – 0.7
WP-Optimize - Clean, Compress, Cache: por David Anderson
Ruhani Rabin
Team Updraft – 3.2.3

WP Activity Log: por WP White Security – 4.4.1
WPS Hide Login: por WPServeur
NicolasKulka
wpformation – 1.9.4

YITH Active Campaign for WooCommerce Premium: por YITH – 2.8.0
YITH WooCommerce Checkout Manager: por YITH – 1.14.0
YITH Composite Products for WooCommerce Premium: por YITH – 1.10.0
YITH WooCommerce Multi Vendor Premium: por YITH – 3.15.0
YITH WooCommerce PDF Invoices & Packing Slips Premium: por YITH – 3.8.0
YITH WooCommerce Product Bundles Premium: por YITH – 1.12.0
YITH WooCommerce Quick View Premium: por YITH – 1.17.0
YITH WooCommerce Stripe Premium: por YITH – 2.10.0
YITH WooCommerce Subscription Premium: por YITH – 2.14.0

### Inactive Plugins (2) ###

AffiliateWP - Tiered Rates: por Sandhills Development
LLC – 1.2

Redirection: por John Godley – 5.2.3

### Dropin Plugins (1) ###

advanced-cache.php: advanced-cache.php

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

Elementor Safe Mode: por Elementor.com – 1.0.0

### Settings ###

API Enabled: –
Force SSL: –
Currency: EUR (€)
Currency Position: right_space
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 ###

Base de la tienda: #214 - /tienda/
Carrito: #215 - /carrito/
Finalizar compra: #216 - /finalizar-compra/
Mi cuenta: #217 - /mi-cuenta/
Términos y condiciones: #13910 - /condiciones-de-contratacion/

### Theme ###

Name: Astra Child
Version: 3.3.2.1619002987
Author URL: https://wpastra.com/about/
Child Theme: ?
Parent Theme Name: Astra
Parent Theme Version: 3.7.5 – 3.8.0 está disponible
Parent Theme Author URL: https://wpastra.com/about/?utm_source=theme_preview&utm_medium=author_link&utm_campaign=astra_theme
WooCommerce Support: ?

### Templates ###

Overrides: –

### Action Scheduler ###

Complete: 831
Oldest: 2022-04-14 11:44:16 +0000
Newest: 2022-05-11 09:17:43 +0000

Failed: 2
Oldest: –
Newest: –

Pending: 34
Oldest: 2022-05-12 08:08:58 +0000
Newest: 2023-05-11 07:38:20 +0000

### Status report information ###

Generated at: 2022-05-11 09:38:12 +00:00

    Hi @abatechnicalhelp,

    Thanks for sending over the system report. You’ll definitely want to reach out to the Yith team for help about migrating their subscriptions. Since they created that extension, they would be the best people to guide you.

    For WooCommerce orders, the data is stored in four database tables:

    _posts is used to keep the order date, status, order key, and a few other “high level” pieces of information. The post_id number here is used for the order number in WooCommerce.
    _postmeta keeps “custom fields” about the orders. This will have the total, shipping and billing addresses for example.
    _woocommerce_order_items will keep track of each item on every order. This way every order can have a “snapshot” of the products from the moment they were ordered. If a product is modified or deleted, it can remain on the order. Each order item gets its own ID number that is used to connect it to the order item meta table. Each product, shipping cost, and tax is considered a separate order item.
    _woocommerce_order_itemmeta stores additional information about each order item like the cost, tax, ?and so on.

    Migrating order and customer data can be complex because of the data being spread across so many tables. There are extensions you can use to export and import the data but I don’t know if they will work with Yith Subscriptions, so again, it’s best to ask them.

    If you need help with anything else, just let us know.

    Plugin Support Paulo P – a11n

    (@paulostp)

    Hello @abatechnicalhelp,

    This topic has been inactive for a while, so I’m marking it as resolved.

    Please open a new topic if you need additional assistance.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Customer data migration’ is closed to new replies.