• Resolved jmargel74

    (@jmargel74)


    Changed a product from simple to variation. Lost all the subscribers for that product. Is there a way to manually input or import the users that were removed? Any possible way to do it through myPhpAdmin?

Viewing 5 replies - 1 through 5 (of 5 total)
  • abhirup23

    (@abhirup23)

    Hi,

    We save the product subscriber in product meta using the product id for simple product and using child id(variable child id) for variable product.

    that’s why the product meta did no showing.

    As a suggesion, you have to get the data using

    $all_subscriber = get_post_meta( $product_id, '_product_subscriber', true );

    $interest_persons = get_post_meta($product_id, 'no_of_subscribers', true);

    then save this for in variable child id

    update_post_meta( $variation_child_id, '_product_subscriber', $all_subscriber );

    update_post_meta($variation_child_id, 'no_of_subscribers', $interest_persons);

    Note – You have to find out the product id and variation product id.

    let me know if you need any help.

    Thread Starter jmargel74

    (@jmargel74)

    All I am looking for is the ability to add in the names and emails that were wiped out when I chagned this product. I have the list, just looking for the best way to get them back in without going to that product on the page and manually doing it (due to the time it would take and the email alerts they would get again).

    Thread Starter jmargel74

    (@jmargel74)

    Doing a little research it seems you put the data in the wp_postmeta table. Looking at a product that I subscribed to the data looks like this: a:1:{i:0;s:21:”[email protected]”;}

    I am assuming the following

    a = total number of subscribers to the product

    i= the index of that subscriber

    s= length of email address

    So if I would do something like this in the appropriate row for this product

    a:4:{i:0;s:21:"[email protected]";i:1;s:19:"[email protected]";i:2;s:15:"[email protected]";i:3;s:17:"[email protected]";}

    Would this work?

    • This reply was modified 2 years ago by jmargel74.

    Hi,

    Sorry, for late update, some how we missed this thread,

    Kindly copy all the content and then add this to your database post meta table –

    <code>update_post_meta( $variation_child_id, '_product_subscriber',$all_subscriber</code>?);

    Regards,

    Plugin Author MultiVendorX

    (@wcmp)

    Hi @jmargel74, we haven’t heard back from your, so we presume this issue is resolved.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Manual entry or import?’ is closed to new replies.