Support » Plugin: WooCommerce » Email doesn’t Contain Download Links
Email doesn’t Contain Download Links
-
Hi.
I´m starting to build my e-commerce with low knowledges.
I will sell only digital copies.
The problem id that i don´t receive download link in the confirmation order received.
So i went to the net and i´ve found that the problem could be a missing SQL Table.
(wp_woocommerce_downloadable_product_permissions ) or a DB name to long.I went to PHP My Admin and the Table is present.
My SQL name is less that 20 Characters.
I went on GITHUB to see the structure of the SQL Table and it looks that every parameters are correct.What am i missing?
Any help will be welcome.
Thank you.
Phil.- This topic was modified 2 years, 6 months ago by Phil0671.
-
Hi @pjil-the-beat,
Sorry to hear about that issue. As a first step, kindly provide us the following:
- 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.
- Error Log: Share a copy of any fatal error log found under WooCommerce > System Status > Logs (if available).
Thanks!
Hi @rainfallnixfig
thanks for the support.Here is the report:
### WordPress Environment ### WordPress address (URL): https://simflightboutique.fr Site address (URL): https://simflightboutique.fr WC Version: 5.6.0 REST API Version: ✔ 5.6.0 WC Blocks Version: ✔ 5.5.1 Action Scheduler Version: ✔ 3.2.1 WC Admin Version: ✔ 2.5.1 Log Directory Writable: ✔ WP Version: 5.8.1 WP Multisite: – WP Memory Limit: 512 MB WP Debug Mode: – WP Cron: ✔ Language: en_GB External object cache: – ### Server Environment ### Server Info: Apache PHP Version: 7.3.29 PHP Post Max Size: 128 MB PHP Time Limit: 360 PHP Max Input Vars: 200000 cURL Version: 7.71.0 OpenSSL/1.1.1d SUHOSIN Installed: – MySQL Version: 5.5.5-10.3.31-MariaDB Max Upload Size: 128 MB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔ ### Database ### WC Database Version: 5.6.0 WC Database Prefix: wpag_wp2021 Total Database Size: 23.83MB Database Data Size: 22.20MB Database Index Size: 1.63MB wpag_wp2021woocommerce_sessions: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wpag_wp2021woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpag_wp2021woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpag_wp2021woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpag_wp2021woocommerce_order_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpag_wp2021woocommerce_order_itemmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpag_wp2021woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpag_wp2021woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpag_wp2021woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpag_wp2021woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpag_wp2021woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpag_wp2021woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpag_wp2021woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpag_wp2021woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpag_wp2021actionscheduler_actions: Data: 0.07MB + Index: 0.05MB + Engine MyISAM wpag_wp2021actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpag_wp2021actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpag_wp2021actionscheduler_logs: Data: 0.06MB + Index: 0.05MB + Engine MyISAM wpag_wp2021commentmeta: Data: 0.01MB + Index: 0.02MB + Engine MyISAM wpag_wp2021comments: Data: 0.02MB + Index: 0.01MB + Engine MyISAM wpag_wp2021dokan_announcement: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpag_wp2021dokan_orders: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpag_wp2021dokan_refund: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpag_wp2021dokan_vendor_balance: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpag_wp2021dokan_withdraw: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpag_wp2021e_submissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpag_wp2021e_submissions_actions_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpag_wp2021e_submissions_values: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpag_wp2021links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpag_wp2021mailchimp_carts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpag_wp2021mailchimp_jobs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpag_wp2021options: Data: 14.16MB + Index: 0.58MB + Engine MyISAM wpag_wp2021postmeta: Data: 2.72MB + Index: 0.52MB + Engine MyISAM wpag_wp2021posts: Data: 4.43MB + Index: 0.11MB + Engine MyISAM wpag_wp2021revslider_css: Data: 0.09MB + Index: 0.01MB + Engine MyISAM wpag_wp2021revslider_css_bkp: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wpag_wp2021revslider_layer_animations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpag_wp2021revslider_layer_animations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpag_wp2021revslider_navigations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpag_wp2021revslider_navigations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpag_wp2021revslider_sliders: Data: 0.08MB + Index: 0.00MB + Engine MyISAM wpag_wp2021revslider_sliders_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpag_wp2021revslider_slides: Data: 0.29MB + Index: 0.00MB + Engine MyISAM wpag_wp2021revslider_slides_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpag_wp2021revslider_static_slides: Data: 0.03MB + Index: 0.00MB + Engine MyISAM wpag_wp2021revslider_static_slides_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpag_wp2021termmeta: Data: 0.02MB + Index: 0.03MB + Engine MyISAM wpag_wp2021terms: Data: 0.01MB + Index: 0.02MB + Engine MyISAM wpag_wp2021term_relationships: Data: 0.03MB + Index: 0.06MB + Engine MyISAM wpag_wp2021term_taxonomy: Data: 0.01MB + Index: 0.01MB + Engine MyISAM wpag_wp2021usermeta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM wpag_wp2021users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpag_wp2021wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine MyISAM wpag_wp2021wc_admin_note_actions: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wpag_wp2021wc_category_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpag_wp2021wc_customer_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpag_wp2021wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpag_wp2021wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpag_wp2021wc_order_product_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpag_wp2021wc_order_stats: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpag_wp2021wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpag_wp2021wc_product_meta_lookup: Data: 0.01MB + Index: 0.03MB + Engine MyISAM wpag_wp2021wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpag_wp2021wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpag_wp2021wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpag_wp2021wemail_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpag_wp2021wpforms_tasks_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpag_wp2021yith_wcwl: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpag_wp2021yith_wcwl_lists: Data: 0.00MB + Index: 0.00MB + Engine MyISAM ### Post Type Counts ### attachment: 174 custom_css: 1 customize_changeset: 31 e-landing-page: 1 elementor_library: 6 mc4wp-form: 1 nav_menu_item: 111 page: 38 post: 15 product: 103 product_variation: 68 revision: 250 shop_order: 13 ts_footer_block: 6 ts_logo: 18 ts_mega_menu: 12 ts_portfolio: 24 ts_size_chart: 1 ts_team: 6 ts_testimonial: 3 wpcf7_contact_form: 2 ### Security ### Secure connection (HTTPS): ✔ Hide errors from visitors: ✔ ### Active Plugins (15) ### Redux: by Redux.io – 4.2.14 Elementor Pro: by Elementor.com – 3.4.1 Elementor: by Elementor.com – 3.4.3 Happy Elementor Addons: by weDevs – 3.1.0 One Click Demo Import: by OCDI – 3.0.2 Slider Revolution: by ThemePunch – 6.5.8 ThemeSky: by ThemeSky Team – 1.0.2 Under Construction: by WebFactory Ltd – 3.89 Photo Reviews for WooCommerce: by VillaTheme – 1.1.4.3 WooCommerce Conversion Tracking: by weDevs – 2.0.8 WooCommerce Stripe Gateway: by WooCommerce – 5.4.1 WooCommerce Payments: by Automattic – 2.9.1 WooCommerce PayPal Payments: by WooCommerce – 1.5.1 WooCommerce Shipping & Tax: by WooCommerce – 1.25.18 WooCommerce: by Automattic – 5.6.0 ### Inactive Plugins (8) ### Contact Form 7: by Takayuki Miyoshi – 5.4.2 Jetpack: by Automattic – 10.1 Mailchimp for WooCommerce: by Mailchimp – 2.5.2 MC4WP: Mailchimp for WordPress: by ibericode – 4.8.6 weMail - Email Marketing Simplified With WordPress: by weDevs – 1.6.1 WPForms Lite: by WPForms – 1.6.9 YITH WooCommerce Compare: by YITH – 2.5.4.1 YITH WooCommerce Wishlist: by YITH – 3.1.0 ### Must Use Plugins (1) ### Elementor Safe Mode: by Elementor.com – 1.0.0 ### Settings ### API Enabled: – Force SSL: – Currency: EUR (€) Currency Position: right 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: #51 - /boutique/ Basket: #52 - /cart/ Checkout: #53 - /checkout/ My account: #54 - /my-account/ Terms and conditions: ❌ Page visibility should be public ### Theme ### Name: GoStore Version: 1.0.3 Author URL: https://theme-sky.com/ Child Theme: ❌ – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme WooCommerce Support: ✔ ### Templates ### Overrides: gostore/woocommerce/archive-product.php gostore/woocommerce/content-product-cat.php gostore/woocommerce/content-product.php gostore/woocommerce/content-widget-product.php gostore/woocommerce/loop/add-to-cart.php gostore/woocommerce/loop/loop-end.php gostore/woocommerce/loop/loop-start.php gostore/woocommerce/loop/orderby.php gostore/woocommerce/loop/rating.php gostore/woocommerce/single-product/rating.php gostore/woocommerce/single-product/tabs/description.php gostore/woocommerce/single-product.php ### WooCommerce PayPal Payments ### Onboarded: Yes Shop country code: FR PayPal card processing available in country: Yes Pay Later messaging available in country: Yes Vault enabled: Yes ### Action Scheduler ### Complete: 352 Oldest: 2021-08-21 11:11:50 +0200 Newest: 2021-09-09 09:38:37 +0200 ### Status report information ### Generated at: 2021-09-09 23:19:37 +02:00
And here is the log:
2021-09-04T21:07:29+00:00 CRITICAL Uncaught Error: Call to undefined method Automattic\Jetpack\Connection\Manager::is_connected() in /home/simfmbbh/public_html/wp-content/plugins/jetpack/class.jetpack.php:1745 Stack trace: #0 /home/simfmbbh/public_html/wp-content/plugins/jetpack/class.jetpack.php(1992): Jetpack::is_connection_ready() #1 /home/simfmbbh/public_html/wp-content/plugins/jetpack/class.jetpack.php(3432): Jetpack::load_modules() #2 /home/simfmbbh/public_html/wp-content/plugins/jetpack/class.jetpack.php(3325): Jetpack::plugin_initialize() #3 /home/simfmbbh/public_html/wp-includes/class-wp-hook.php(303): Jetpack::plugin_activation(false) #4 /home/simfmbbh/public_html/wp-includes/class-wp-hook.php(327): WP_Hook->apply_filters('', Array) #5 /home/simfmbbh/public_html/wp-includes/plugin.php(470): WP_Hook->do_action(Array) #6 /home/simfmbbh/public_html/wp-admin/includes/plugin.php(698): do_action('activate_jetpac...', false) #7 /home/simfmbbh/public_html/wp-content/plugins/woocommerce-services/classes/class-wc-connect-nux.php(700): activate in /home/simfmbbh/public_html/wp-content/plugins/jetpack/class.jetpack.php on line 1745
- This reply was modified 2 years, 6 months ago by Phil0671.
Hi @pjil-the-beat,
Thanks for getting back with the error logs and your System Status.
Just to clarify on this:
The problem id that i don´t receive download link in the confirmation order received.
When a new order is submitted, if you’ve enabled new order email notifications, both the admin and the customer will receive an email and, if the order status is not “Completed”, then that email will not show the link to the digital product.
Once you change the order status to “Completed” the customer will receive another email with the link to the downloadable product.
Link to image: https://snipboard.io/E9QVsf.jpgPlease confirm and we’ll go from here.
@rainfallnixfig unknown background knowledge 😉
After this stage established, everything works fine.
I should maybe open another post, but i have few more questions regarding the completion process:
– How to activate or not the email notification “review our product”?
-After the customer have proceed to the paiement the email confirmation with the download link can not be send automatically?One more time thank you for the support.
Hey @pjil-the-beat,
After this stage established, everything works fine.
It sounds like the download link now shows in the completed email after the order status has completed. Great to hear!
After the customer have proceed to the paiement the email confirmation with the download link can not be send automatically?
From what I understand, your orders are first going to
processing
, however, you’d like successful payments to go directly tocomplete
status so that the email will include the download link right away, correct?In this case, you’ll want to make sure your product is set to
downloadable
ANDvirtual
, like so:
Link to image: https://d.pr/i/uqMe6ZThis will set all successful payments to go directly to the completed status and send the completed email with the download link.
How to activate or not the email notification “review our product”?
By default, WooCommerce does not have an email template that sends an email to review products purchased. To enable product reviews, you would go to WooCommerce > Settings > Products under the Reviews section here:
Link to image: https://d.pr/i/5A5yWrIf you want to send emails, you can use an extension such as AutomateWoo to send a custom email to customers. You can, for example, set up an email rule to remind customers to review after X days after purchase.
@yukikatayama you resolved my interrogations 😉
Thank you for the quick support.
One more thing sorry. Regarding the email send to the customer asking to review the product he bought, it´s send automatically telling him that he can get a cupon if he post a review.
Hoe can i disable the “get a cupon” and not review?
Hey @pjil-the-beat,
It sounds like you already have a review email plugin? Checking your SSR, is it this: Photo Reviews for WooCommerce: by VillaTheme?
If that plugin is sending the review emails and includes the coupon option, I’d recommend asking the VillaTheme support team about that.
Let me know if I’m completely misunderstanding! 🙂
- This reply was modified 2 years, 6 months ago by Yuki K a11n..
The plugin is installed but not activate.
Hello.
I still have the “on-hold” email confirmation
And in the order woo-commerce admin panel the product still “on-old” and don´t go automatically to “completed”
Hi @pjil-the-beat 👋
Thanks for the updates!
Regarding the email send to the customer asking to review the product he bought, it´s send automatically telling him that he can get a cupon if he post a review.
WooCommerce does not have an automatic email notification like this by default, so it’s likely coming from a plugin or was custom made.
You can check all of the email notifications available via WooCommerce > Settings > Emails, as shown here: https://d.pr/i/HexJu5
Could you please review all of the emails listed on that page to see if one of them mentions a coupon? I would say it might have been added manually to the ‘Completed order` email notification or might be a custom one added.
Then regarding:
I still have the “on-hold” email confirmation
And in the order woo-commerce admin panel the product still “on-old” and don´t go automatically to “completed”The order will be ‘On-Hold’ if the user has not paid for the purchase yet or if the payment is not reflecting yet.
Can you please confirm if the payment was received in your bank account or by the payment gateway for the order? If so, which payment method is your customer using (Stripe, PayPal, Bank Deposit, etc.)?
Thnaks for the quick support.
Ok i´ve done another “buy test” and yes i don´t receive anymore the “review this product to get a cupon” (that´s a good news.
I think you have pointed the right missing thing. You´re asking me : “wich payement method is your customer using”
At he moment i´m just using it myself with the “test payement method” as described below
Regarding the process below are all the screenshots of the settings and email received:
1:
https://e.pcloud.link/publink/show?code=XZTSV5Zu54rHPOEeRL8GK8uwC4oIV33u6BX2:
https://e.pcloud.link/publink/show?code=XZISV5ZKgs99L7R1hSAFnYlF9674b5JfqJV3:
https://e.pcloud.link/publink/show?code=XZdSV5ZfPuN7nz3wQV6dnkatT2IhSKTuFrX4:
https://e.pcloud.link/publink/show?code=XZKSV5ZJmzeHqcTWnme0NgvyjrvR8lj8l275:
https://e.pcloud.link/publink/show?code=XZxSV5ZrbiLdT3LmJHdwueFcJU0zF0o3dYVHey @pjil-the-beat,
Thanks for the screenshots.
In the “Reviews” section under WooCommerce > Settings > Products > General you can enable or disable settings for reviews, but there is no function to send an email to the customer asking to review your products. That feature is probably added by a 3rd party plugin (Photo Reviews for WooCommerce) as mentioned above by my colleague.
When you placed your test order it appears with the status “On hold” (screenshot 04) under WooCommerce > Orders as you’re awaiting the payment, but you still receive a New Order notification (screenshot 05) to the Admin email.
You can read more about managing order and email notifications here:
– https://docs.woocommerce.com/document/managing-orders/
Let us know if you have any other questions.
For the unable review, i think it´s resolved.
Now for the downloadable setting in the product menu “add new”
This is how it´s set and what i keep receiving.
Setting product add new:
https://e.pcloud.link/publink/show?code=XZNrV5ZmckfjPhBPB4NtmHpx6Rm7pCRHMAXAfter purchase done, the emails confirmation:
https://e.pcloud.link/publink/show?code=XZcrV5ZFmPymGTjwLuRNvkEoRAIUfFNacFX
https://e.pcloud.link/publink/show?code=XZycV5Z3taSI9DdvE5x4K8Nc3BLlHdv2CRXStill on old:
https://e.pcloud.link/publink/show?code=XZkcV5ZVaYVKYWyLlh5edCOyD2AR7jzWb47I put it manually on “completed”, i received a third email “thank you for shopping with us” with the download link:
https://e.pcloud.link/publink/show?code=XZ5cV5ZLWQ3POgzO4bYTrsuEA8BhBob6XaXI hope i understand all you described above and i´m not missing anything.
- This reply was modified 2 years, 6 months ago by Phil0671.
Hey @pjil-the-beat,
Thanks for sharing the screenshots of your test order process.
It looks like the downloads table and links issue is now resolved, which is great!
From the order confirmation email, I can see that WooCommerce Payments was used as the payment method, but the order was placed on hold.
The most likely reason for this happening is if the payment is not captured immediately when an order is placed.
Could you please go to Payments > Settings in your website dashboard and then check if the “Issue an authorization on checkout, and capture later” setting is checked?
That setting means that payments are authorized at the point of order but money isn’t captured unless you go into the order and select “Capture charge” from the “Order Actions” box.
You can read more about this process here: https://docs.woocommerce.com/document/payments/#section-9
If you don’t need the ability to do that then I would recommend you uncheck that option and save your settings. Then if you place another test order, you should receive the download link immediately.
I hope that helps!
Kind regards,
- The topic ‘Email doesn’t Contain Download Links’ is closed to new replies.