Home Forums WoodMart support forum Waitlist – need info / help

Waitlist – need info / help

Viewing 15 posts - 1 through 15 (of 15 total)
  • Author
    Posts
  • #591282

    pavel.vutkow
    Participant

    Hi,

    I need some information and directions.
    Yesterday I looked at this option you released and I am facing the following:

    1. How do I get admin notified/mail notification that a customer has signed up for a product wait?
    – I saw that only the client gets a notification.

    2. How do I remove the waitlist validation requirement?
    – This step is not pleasant for the customer and requires additional interaction.

    3. Where is the information and texts translated from, how can I change them in the product?
    – Where can I translate the email and the template that the client receives?

    4. Can I display the information about registered customers on the main dashboard?

    —————-
    Problem:

    If a customer has signed up for a product, when I try to delete it, it won’t let me.

    I can’t find a way to manually send a notification to the customer about the availability of the item either individually or in bulk – how can I do this?

    Regards,
    Pavel

    #591307

    Artem Temos
    Keymaster

    Hello,

    Thank you for your questions.

    1. There is no admin email for this at the moment. You can browse all waitlists in Dashboard -> Products -> Waitlists.

    2. Just disable the email in WooCommerce -> Settings -> Emails.

    3. All texts can be translate with Loco translate and via WooCommerce -> Settings -> Emails.

    4. Do you mean to browser all waitlists as admin? Check in Products -> Waitlists. You can also delete any records from there https://gyazo.com/1409170c9dfdffbbd62615d9e1e8b02d

    Kind Regards

    #591487

    pavel.vutkow
    Participant

    Hello,

    It’s a great idea and I’ve been waiting for it for a long time since I’m currently using a plugin for this possibility, but unfortunately it has a lot of basic functionalities and lacks basic ones that need to be improved so that it can be used and is really useful, not only have it as an option:

    I add this:

    1. There is no admin email for this at the moment.
    – I hope you fix this as it is difficult to track or log in every day to check if anyone is logged into this list.

    2. Just disable the email in WooCommerce -> Settings -> Emails.
    – This is not a solution and leads to another problem.

    If I turn off the email, the client doesn’t get an email saying they’re on that list, and they also don’t get on the subscribed list, and I have no way to see in the dashboard if someone has subscribed, because apparently you’re tied to that functionality and confirmation before they entered the waiting list.

    — I did a test and when my emails are turned off, it says in the product that I have signed up, but in Products -> Waitlists nothing is displayed since I have not actually validated the registration.

    That’s why I asked how to exclude the mandatory requirement for email validation or registration/subscription.

    3. Also if the customer has registered without being logged in or entered the list in Products -> Waitlists from where I can possibly delete it. The customer cannot be registered a second time. When logging in from another browser, it says that this email is already registered for waiting, but if the product appeared and then was sold out again, how is the customer expected to be registered again?

    4. There must be a way to delete the customers – I’m showing on the video that I have such a record and I can’t delete it. I also show the above issues.

    The video is here: Private content

    5. The option doesn’t work for bulk products and variations, which makes it a bit pointless. I.e. this only applies to standalone products.

    Regards,
    Pavel

    #591498

    Artem Temos
    Keymaster

    2. You don’t need to disable all emails. But only about the confirmation. And after that, users still get emails that they are subscribed (without need to confirm the subscription).
    If it doesn’t work for you, please provide us with your admin access so we can check.

    3. When the product appears in stock and the email is sent, the subscription is deleted. It means that now the same email can be registered again.

    4. Please send us your admin access so we can investigate why it doesn’t work on your website.

    5. This option works both for simple products and variable products. You can add all variations to waitlist separately.

    Kind Regards

    #591527

    pavel.vutkow
    Participant

    Hello,

    2. You don’t need to disable all emails. But only about the confirmation. After that, users still get emails that they are subscribed (without the need to confirm the subscription).
    If it doesn’t work for you, please provide us with your admin access so we can check.

    Ok, I turned off the verification email only and got an email saying I was put on the waitlist.

    But unfortunately in the list in Products -> Waitlists, I don’t see my waitlist for this product. In this case, the administrator has no way to know that someone has signed up to wait for the product.

    ———

    3. When the product appears in stock and the email is sent, the subscription is deleted. It means that now the same email can be registered again.

    The reason I’m asking about deletion is that a product may no longer load and this email and customer should be able to delete it manually rather than waiting for the product to become available to be deleted from the list.

    5. This option works both for simple products and variable products. You can add all variations to the waitlist separately.

    Yes, now I see that it works, but if the product is in draft or personal, it does not work. The product must be published.
    What about the bulk products?

    Regards,
    Pavel

    #591663

    Artem Temos
    Keymaster

    Hello,

    2. We just tested this on your website it works correctly. Check the following screenshots

    https://gyazo.com/a38f9fe3fe87ccb6d797e55dc4409b30
    https://gyazo.com/37890aff605c44fc2c1c0756becbee85
    https://gyazo.com/cb7d593f0a48f0712449a8c539f738e5
    https://gyazo.com/20c2c5598c7465e5d67d2beca42df489
    https://gyazo.com/4f42fe3c41d0b4db27f0f832bcd49695

    3. Customer can delete it manually via My account -> Waitlist https://gyazo.com/4f42fe3c41d0b4db27f0f832bcd49695

    4. Please send us your FTP access as well.

    5. Yes, the product needs to be published. Could you please clarify what bulk products mean? Send an example, please.

    Kind Regards

    #591701

    pavel.vutkow
    Participant

    Hi,

    I’m sorry, but none of what you shared is happening for me:

    Here is a separate clip, of how I add a product to the list and it does not display in the dashboard!
    https://streamable.com/2zqa2d

    Here is a clip where I try to delete both the user and the product, but nothing happens!
    https://streamable.com/7f5blt

    3. Customer can delete it manually via My account -> Waitlist https://gyazo.com/4f42fe3c41d0b4db27f0f832bcd49695

    Yes, but if the client is a guest, how could he delete it? So there must be a manual method to delete and to be able to be re-added to overwrite the addition. There should be no limit to how many times the customer has registered. When it comes to guests.
    Regards,
    Pavel

    #591775

    Artem Temos
    Keymaster

    As we can see, this functionality is affected by some cache on your website https://monosnap.com/file/4cJ4v5YS8DXzunSYsdrHO7unSdDMZ8
    When we flush the cache, it works correctly.

    #591792

    pavel.vutkow
    Participant

    OK,

    This is the Redis cache, but the whole site works fine except for the waiting list, so I believe the problem isn’t with the cache. Redis is primarily used for fast access to data and enhancing database performance, but it doesn’t directly manage static assets like JavaScript or CSS. The fact that the rest of the site operates smoothly suggests that Redis is functioning as expected. Therefore, it’s more likely that the issue lies within the application logic that handles the waiting list, rather than with Redis itself.

    Investigating the specific logic or database queries involved in the waiting list feature might reveal the root cause of the problem.

    P.S.
    Redis is particularly beneficial for WooCommerce sites, which often handle a large number of dynamic requests, such as product searches, cart updates, and checkout processes. Unlike standard caching plugins that cache static pages, Redis stores data in RAM, allowing for lightning-fast retrieval of dynamic content and database queries. This means that for WooCommerce, Redis helps to significantly speed up operations by reducing the load on the database, ensuring a smoother and faster shopping experience for users. By leveraging Redis, WooCommerce stores can handle high traffic and large volumes of transactions more efficiently.

    Given Redis’s role in speeding up dynamic content retrieval and database queries by utilizing RAM, it’s unlikely that the issue with the waiting list is caused by Redis. In fact, Redis is designed to enhance performance, so it’s more likely that the problem lies elsewhere in the application logic.

    #591793

    pavel.vutkow
    Participant

    Not only the whole site but also your theme and all the options in it work fine expect the waiting list.

    Thanks in advance.

    #591806

    Artem Temos
    Keymaster

    Hello,

    We use WP cache functions there so maybe the plugin affects them somehow. Try to edit the file wp-content\themes\woodmart\inc\integrations\woocommerce\modules\waitlist\list-tables\class-users-table.php

    replace the following code

    		if ( ! wp_cache_get( 'wd_waitlist_users_table_data' ) ) {
    			wp_cache_set(
    				'wd_waitlist_users_table_data',
    				$wpdb->get_results( //phpcs:ignore;
    					"SELECT
    						$wpdb->wd_waitlists.<code>user_id</code>,
    						$wpdb->wd_waitlists.<code>user_email</code>,
    						$wpdb->wd_waitlists.<code>unsubscribe_token</code>,
    						$wpdb->wd_waitlists.<code>created_date_gmt</code> as <code>created_date</code>
    					FROM $wpdb->wd_waitlists"
    					. $where_query_text .
    					' LIMIT 50;',
    					ARRAY_A
    				)
    			);
    		}
    
    		return wp_cache_get( 'wd_waitlist_users_table_data' );

    with this one

    return $wpdb->get_results( //phpcs:ignore;
    			"SELECT
    				$wpdb->wd_waitlists.<code>user_id</code>,
    				$wpdb->wd_waitlists.<code>user_email</code>,
    				$wpdb->wd_waitlists.<code>unsubscribe_token</code>,
    				$wpdb->wd_waitlists.<code>created_date_gmt</code> as <code>created_date</code>
    			FROM $wpdb->wd_waitlists"
    			. $where_query_text .
    			' LIMIT 50;',
    			ARRAY_A
    		);

    also edit the file wp-content\themes\woodmart\inc\integrations\woocommerce\modules\waitlist\list-tables\class-waitlist-table.php

    and replace

    	if ( ! wp_cache_get( 'wd_waitlist_table_data' ) ) {
    			wp_cache_set(
    				'wd_waitlist_table_data',
    				$wpdb->get_results( //phpcs:ignore;
    					"SELECT
    						$wpdb->wd_waitlists.<code>list_id</code>,
    						$wpdb->wd_waitlists.<code>product_id</code>,
    						$wpdb->wd_waitlists.<code>variation_id</code>,
    						COUNT( $wpdb->wd_waitlists.<code>user_id</code> ) as <code>user_count</code>,
    						$wpdb->wd_waitlists.<code>created_date_gmt</code> as <code>created_date</code>
    					FROM $wpdb->wd_waitlists
    					INNER JOIN $wpdb->posts
    						ON $wpdb->posts.<code>ID</code> = $wpdb->wd_waitlists.<code>product_id</code>"
    					. $where_query_text .
    					" GROUP BY
    						$wpdb->wd_waitlists.<code>product_id</code>,
    						$wpdb->wd_waitlists.<code>variation_id</code>
    					LIMIT 50;",
    					ARRAY_A
    				)
    			);
    		}
    
    		return wp_cache_get( 'wd_waitlist_table_data' );

    with this

    return $wpdb->get_results( //phpcs:ignore;
    			"SELECT
    				$wpdb->wd_waitlists.<code>list_id</code>,
    				$wpdb->wd_waitlists.<code>product_id</code>,
    				$wpdb->wd_waitlists.<code>variation_id</code>,
    				COUNT( $wpdb->wd_waitlists.<code>user_id</code> ) as <code>user_count</code>,
    				$wpdb->wd_waitlists.<code>created_date_gmt</code> as <code>created_date</code>
    			FROM $wpdb->wd_waitlists
    			INNER JOIN $wpdb->posts
    				ON $wpdb->posts.<code>ID</code> = $wpdb->wd_waitlists.<code>product_id</code>"
    			. $where_query_text .
    			" GROUP BY
    				$wpdb->wd_waitlists.<code>product_id</code>,
    				$wpdb->wd_waitlists.<code>variation_id</code>
    			LIMIT 50;",
    			ARRAY_A
    		);

    Let me know how it works.

    #592034

    pavel.vutkow
    Participant

    Hi, thanks for the information.

    Not working and I think now is broken the part for the admin dashboard – please check the video.

    #592114

    Artem Temos
    Keymaster

    Hello,

    Sorry, some symbols were replaced and the code here is broken. Please revert the changes and copy the code from the document here https://docs.google.com/document/d/1TDdyIUYDXaW9n2BLybvbyKxJeOLxeiZ0NVhsdSjJqdw/edit

    Kind Regards

    #592160

    pavel.vutkow
    Participant

    Hello,

    Right now it all seems to be working. I have a little slight delay in the availability notification to the customer.

    – Will you fix it in the next version?

    The other thing is that they are still missing:

    1. Admin notification – mail.
    2. Easy editing of emails, including translation.
    3. Easy overview in the main dashboard.
    4. Ability to manually send information to customers – optional
    5. Ability to save the log for registered customers, this should include an option that does not prevent the customer from registering again if the product runs out again.
    6. After keeping a log and notification, whether an email has already been sent to the customer.
    7. Option to export the log
    ————————————————– ———
    Here is an example:
    https://snipboard.io/ZOTk4J.jpg
    https://snipboard.io/GiBzpT.jpg

    Something you have as an advantage is that you have this list of registered customers in their account.

    Here I can recommend another idea for future improvement, such as:
    A POP UP form that can include more information that is useful for the administrator the site and the client:
    – To be able to add in this form, the customer’s name, telephone number of the product and/or comment, and others.

    I am attaching an example clip of the improvement:
    https://streamable.com/171rrz

    Thank you

    #592447

    Artem Temos
    Keymaster

    Hello,

    Yes, there is a delay to send emails every few hours to a batch of customers. We will add an option to configure this delay in our next update.

    As for the feature requests, you can post and discuss them here https://woodmart.canny.io/feature-requests

    Thank you in advance.

Viewing 15 posts - 1 through 15 (of 15 total)