SELECT COUNT AS term_count, terms.term_id AS term_count_id FROM modellblausitz_posts INNER JOIN modellblausitz_term_relationships AS term_relationships ON modellblausitz_posts.ID = term_relationships.object_id INNER JOIN modellblausitz_term_taxonomy AS term_taxonomy USING INNER JOIN modellblausitz_terms AS terms USING LEFT JOIN modellblausitz_term_relationships ON (modellblausitz_posts.ID = modellblausitz_term_relationships.object_id) INNER JOIN modellblausitz_postmeta ON ( modellblausitz_posts.ID = modellblausitz_postmeta.post_id ) INNER JOIN modellblausitz_postmeta AS mt1 ON ( modellblausitz_posts.ID = mt1.post_id ) WHERE modellblausitz_posts.post_type IN ( ‘product’ ) AND modellblausitz_posts.post_status = ‘publish’ AND ( modellblausitz_posts.ID NOT IN ( SELECT object_id FROM modellblausitz_term_relationships WHERE term_taxonomy_id IN ( ) AND modellblausitz_term_relationships.term_taxonomy_id IN (111,112,113,114,115,116,118,180,189,190,192,193,194,195,196,197,198,214,261,320,330,331,332,333,334,335,336,337) ) AND ( ( modellblausitz_postmeta.meta_key = ‘_stock_status’ AND modellblausitz_postmeta.meta_value NOT IN (‘outofstock’) ) OR ( mt1.meta_key = ‘preorder-status’ AND mt1.meta_value = ‘enabled’ ) ) AND terms.term_id IN (303,240,257,258,168,169,319,262,271,170,301,359,289,171,340) GROUP BY terms.term_id

Query Problems

Many Joins:

The query joins posts, term_relationships, term_taxonomy, terms, and twice postmeta. This causes significant load for large tables.

Subselect in the WHERE clause:

modellblausitz_posts.ID NOT IN (SELECT object_id FROM modellblausitz_term_relationships WHERE term_taxonomy_id IN (8))

Subselects in the WHERE clause are extremely expensive – a LEFT JOIN with IS NULL would be a better alternative here.

Double Use of Postmeta:

Two JOINs on postmeta (postmeta and mt1), which degrades performance if not indexed correctly.

Large IN Lists:

Many IN (...) conditions on term_taxonomy_id and term_id result in a large scan load if these columns are not indexed.

GROUP BY in conjunction with COUNT DISTINCT:

Grouping across many entries can overload the database if there are a large number of products.

Hello There

We kindly recommend submitting a ticket using the link provided below. Our team

will be pleased to assist you and resolve your query as promptly as possible.

Ticket Link- https://webkul.uvdesk.com/en/customer/create-ticket/

With Regards

Team Webkul

Done

Hello There

Yes,it supports variable products also.

With Regards

Team Webkul

For variable products, can I set a pre order price for each variable? Or how does it work

Hello There

Greetings from Webkul!!

Yes,you can set a pre order price for each variations for variable products.

For reference See Attached Link Link – https://webkul.chatwhizz.com/share/view-recording/667109852091350726e47bf7

With Regards

Team Webkul

Hello There,

Greetings!

Pre-order and normal product are listed on same product page?

—>> Yes

After the time is over for presale the product will appear as a normal product to order?

—>> Yes

If you have any question or concern for us please reach out to us at support@webkul.com

With Regards,

Team Webkul

Hello there

Greetings,

Hello. I tried the demo and one thing want to make sure. Is the plugin only allow one pre-order product per order? I mean you cannot add other available or pre-order products in the cart at the same time, right?

>> Yes, the WordPress WooCommerce Pre Order plugin allow only one pre-order product per order.

Is it a setting we can change to have multiple pre-order in one order, or it limited by the plugin?

>> At the moment, the plugin doesn’t have the built-in capability to have multiple pre-order products in one order.

However, we can develop it for you via customization (paid service).

Meanwhile, You can check User guide of the module and Demo for all the features-

User guide – https://webkul.com/blog/woocommerce-pre-order/

Demo link – https://wpdemo.webkul.com/woocommerce-pre-order-103-80-65-178/

Please tells us if you have any question or concerns for us at support@webkul.com

With Regards

Team Webkul

Hello There

Greetings!

Hello, your plugin support bulk actions, for example allow pre-order of all out of stock simple and variable products of one category?

>> Dear sir, yes this plugin supports Bulk action functionality.

To enable the bulk actions for pre-order functionality, the admin needs to navigate to Woocommerce Pre-Order >> Woo-commerce Pre-Order List. After this admin needs to choose the desired products and then click on the Bulk Action menu and then select “Enable” Funally user needs to click on the Apply button

We have already provided the User Guide and Demo for the same. You can check all the functionalities below here -

User Guide Link – https://webkul.com/blog/woocommerce-pre-order/

Demo Link – https://wpdemo.webkul.com/woocommerce-pre-order/

If you have any questions or concerns for us, feel free to reach us at support@webkul.com

With Regards

Team Webkul

thanks

Hello There

thanks

>> You’re most welcome.

With Regards

Team Webkul

Hello There,

Greetings of the day!

Thanks for showing interest in our plugin.

Has the option to turn off the clock been added to the settings options? —>>Yes, Currently the preorder countdown timer will display on the product page, so the admin can enable and disable it from the backend. —>>No there is no such kind of functionality in the module.if you want that so we can developed it via customization.

Are the colors customizable to the store’s aesthetic?

Will there ever be a developer version of this plugin? ->>We did not provide a developer version for the module, you can only use it once you purchased it.

Please let me know if you have any other question for me you can also connect with us at support@webkul.com

Thanks & Regards Team Webkul

Hello There,

Greetings of the day!

Thanks for showing interest in our plugin.

1) Has the option to turn off the clock been added to the settings options? Yes, Currently the preorder countdown timer will display on the product page, so the admin can enable and disable it from the backend.

2) Are the colours customizable to the store’s asthetic? No there is no such kind of functionality in the module.if you wan that so we can developed it va customization.

3)Will there ever be a developer version of this plugin? We did not provide a developer version for the module, you can only use it once you purchased it.

Please let me know if you have any other question for me you can also connect with us at support@webkul.com

Thanks & Regards Team Webkul

Nevermind, worked the 3rd time I tried.

Hello There,

Greetings of the day!

That’s great , Still, if you are facing any issue. so you can raise your concern and connect with us at support@webkul.com so that we can check and help you accordingly.

Thanks & Regards Team Webkul

Awesome i will purchase it and try it then thank you !

Sorry I’ve just seen a comment saying that it’s not compatible with variable products is this right ? Because all my products are variable ..

Hello there,

Please share your query overt the support@webkul.com the team will check and update you.

Thanks

Hello there,

Greetings for the day !!

That is most likely because either you have ulp-loaded the file at the incorrect place or vice-versa.

Please connect with us at support@webkul.com our team will check and help you accordingly.

Thanks

Okay, sure we will check and update you,

Thanks

As we have checked and found that the plugin is working fine – if you are still facing any issue

Kindly reach out to us at support@webkul.com

Thanks

Hello there,

Our plugin will support any theme if it works fine in default WooCommerce.

if a customer purchases a pre-order alongside other currently available options, does it process at the same time? thank you!

—> Yes, you can checkout a Pre-Order Product and a regular product simultaneously.

If you have any other queries or requirements then kindly reach out to us at support@webkul.com

Thanks

Hello there,

For, this we need would need more info from your end do you have PayPal integrated in your WooCommerce Website.

We recommend you to reach out to us at support@webkul.com so that we can check and help you out.

Thanks

Hello there!

Thanks for showing interest in our plugin.

Yes, using our plugin the store owners can add e-books as a pre-order product.

Which can then be downloaded by a reader/buyer on the respeective date of launch/release.

If you have any other queries or custom request kindly reach out to us at support@webkul.com

Thanks

Hello there!

We have checked your request and we can provide you a solution -

where the customers do not have to pay the shipping price twice – we will integrate this for you with the help of customization.

Kindly reach out to us at support@webkul.com our team will check and provide you a solution accordingly.

Thanks & regards

hello there,

No this plugin is not compatible with the WPML currently,

However, you can reach out to us at support@webkul.com with a customization request to make this work with WPML

Thanks

Hello there!

As per the current functionality of this plugin.

>> The pre order price value must be greater than or equal to 1.

However, if you want we can make customization to set it to 0 using this you do not need to add a new payment method No payment.

Please reach out to us at support@webkul.com with your complete requirements and we will check and update you with the solution.

Thanks

Hello there!

Using our plugin the admin can send Pre order reminder and in stock mail to customers.

No currently there is no option for the customers to cancel a Pre order if you want this feature it will be a part of customization.

Yes, in the backend their is a separate section Pre Order List where you can find all the pre ordered products.

Yes, under the My accounts page, the customers have a section Pre Order where all the pre orders made are listed.

The admin can add a partial payment with the help of this the customers can pay the remaining fee amount after once the product is back in stock.

The shipping costs are applied additionally with the Pre-order product price.

If you have any other queries you may also check the user guide – https://webkul.com/blog/woocommerce-pre-order/

As per your this requirement – We can make the customization to transform the out of stock product as pre-orders.

Further, if you want any additional feature please reach out to us at support@webkul.com for customization requirements.

We will check and provide you a solution accordingly.

Thanks

Hello,

You did not answer all the questions…

5. Do pre-ordered products automatically change to “available product” when the availability date passes? (Is it integrated in your extension, or do I have to go through another extension)

6. Can “out of stock” products be automatically transformed into pre-order products?

7. How is the down payment functionality of pre-orders managed?

Thanks,

Dear Customer!

Yes, pre-ordered products automatically change to “available product” when the availability date passes.

you can check it in the screenshot – https://cdnblog.webkul.com/blog/wp-content/uploads/2020/09/webkul-woocommerce-pre-order-cart-added-page-23.png

No, the “out of stock” products can’t be automatically transformed into pre-order products. If you want this feature it will be a part of customization.

The plugin provides a partial payment option for the pre-order products where the admin can set an initial amount that the customer needs to pay,

The remaining amount can be paid once the product is back in stock.

If you have any other queries or customization requests you can reach out to us at support@webkul.com

Thanks

Dear Customer!

Please explain us more regarding the complications that you are facing so that we can help you better.

Please reach out to us at support@webkul.com with your complete requirements and we will check and update you over the same.

Thanks

Hello there!

Yes, this module do works with downloadable products.

As per your request you would like to have a downloadable product which a customer would be able to download every time a new version is released.

Yes, so if a customer pre-orders a product using our plugin feature they will be sent an email to download the same as soon as the product’s new release is available.

There are some minor things that we would need to add with the help of customization paid, and discuss your requirements in detail.

Please discuss us in detail over support@webkul.com about your complete requirements and we will help you regarding the same.

Thanks

Dear Customer!

Thanks for showing interest in our module. please find the answer to your queries below.

The customer can still add a pre-order product to their cart and checkout by making the partial i.e initial payment or full payment as set by the admin.

If you want to auto process the remainder product price a day before release or full payment it will be a part of customization.

Further, if you want to disable the counter and showcase the normal release date then this could also be done using customization.

Please reach out to us at support@webkul.com with your complete custom requirements and we will help you provide the solution accordingly.

Thanks