sale products

Hi there!

Could you provide us with the shortcode you have used?

Looking at the documentation here, the shortcode would look something like this;

[products limit="4" columns="4" orderby="popularity" on_sale="true" ]

Here is the short code generated by wp backery

[vc_row][vc_column][sale_products per_page=”4″ columns=”4″ orderby=”title” order=”ASC”][/vc_column][/vc_row]

Tested page

• This reply was modified 5 years, 10 months ago by chitrag135.

Where is it ? WP-Admin dashboard ? Can you advice me steps to find it ?

If you edit this page in Visual Composer, https://www.egtours.com/travel-deals/, you will see the following shortcode is added to the page;

[sale_products per_page=”4″ columns=”4″ orderby=”title” order=”ASC”]

It is probably added with a shortcode element from Visual Composer.

Replace that shortcode with the following one and check if the products display then;

[products limit=”4″ columns=”4″ orderby=”title” order=”ASC” on_sale=”true” ]

This shortcode displays all products available. I want to display only product on sale,

Ok, that should not be the case.

Could you 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.

Here is the report

### WordPress Environment ###

WordPress address (URL): https://www.egtours.com
Site address (URL): https://www.egtours.com
WC Version: 3.6.2
Log Directory Writable: ?
WP Version: 5.1.1
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: LiteSpeed
PHP Version: 7.2.17
PHP Post Max Size: 24 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
cURL Version: 7.62.0
OpenSSL/1.0.2k

SUHOSIN Installed: –
MySQL Version: 5.6.43
Max Upload Size: 20 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ? Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected.
DOMDocument: ?
GZip: ?
Multibyte String: ? Your server does not support the mbstring functions - this is required for better character encoding. Some fallbacks will be used instead for it.
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 3.6.2
WC Database Prefix: wp_
MaxMind GeoIP Database: ?
Total Database Size: 43.00MB
Database Data Size: 32.09MB
Database Index Size: 10.91MB
wp_woocommerce_sessions: Data: 0.01MB + Index: 0.00MB
wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB
wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.01MB
wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB
wp_woocommerce_order_items: Data: 0.00MB + Index: 0.00MB
wp_woocommerce_order_itemmeta: Data: 0.01MB + Index: 0.02MB
wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB
wp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB
wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB
wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB
wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB
wp_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB
wp_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB
wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB
core37_form_kv: Data: 0.00MB + Index: 0.00MB
core37_form_sessions: Data: 0.00MB + Index: 0.00MB
wp_booking: Data: 0.00MB + Index: 0.00MB
wp_bookingdates: Data: 0.00MB + Index: 0.00MB
wp_cf_form_entries: Data: 0.00MB + Index: 0.01MB
wp_cf_form_entry_meta: Data: 0.04MB + Index: 0.01MB
wp_cf_form_entry_values: Data: 0.01MB + Index: 0.02MB
wp_cf_tracking: Data: 0.00MB + Index: 0.00MB
wp_cf_tracking_meta: Data: 0.00MB + Index: 0.01MB
wp_commentmeta: Data: 0.00MB + Index: 0.01MB
wp_comments: Data: 0.01MB + Index: 0.01MB
wp_duplicator_packages: Data: 0.00MB + Index: 0.00MB
wp_ewwwio_images: Data: 0.01MB + Index: 0.01MB
wp_formmaker: Data: 0.04MB + Index: 0.00MB
wp_formmaker_backup: Data: 0.09MB + Index: 0.00MB
wp_formmaker_blocked: Data: 0.02MB + Index: 0.00MB
wp_formmaker_query: Data: 0.02MB + Index: 0.00MB
wp_formmaker_sessions: Data: 0.00MB + Index: 0.00MB
wp_formmaker_submits: Data: 0.00MB + Index: 0.00MB
wp_formmaker_themes: Data: 0.56MB + Index: 0.00MB
wp_formmaker_views: Data: 0.00MB + Index: 0.00MB
wp_fortyfour_logs: Data: 0.00MB + Index: 0.00MB
wp_frm_fields: Data: 0.00MB + Index: 0.01MB
wp_frm_forms: Data: 0.00MB + Index: 0.00MB
wp_frm_items: Data: 0.00MB + Index: 0.00MB
wp_frm_item_metas: Data: 0.00MB + Index: 0.00MB
wp_gdrts_itemmeta: Data: 0.00MB + Index: 0.01MB
wp_gdrts_items: Data: 0.00MB + Index: 0.01MB
wp_gdrts_logmeta: Data: 0.00MB + Index: 0.01MB
wp_gdrts_logs: Data: 0.00MB + Index: 0.02MB
wp_hugeit_maps_circles: Data: 0.00MB + Index: 0.00MB
wp_hugeit_maps_directions: Data: 0.00MB + Index: 0.00MB
wp_hugeit_maps_maps: Data: 0.00MB + Index: 0.00MB
wp_hugeit_maps_markers: Data: 0.00MB + Index: 0.00MB
wp_hugeit_maps_polygons: Data: 0.00MB + Index: 0.00MB
wp_hugeit_maps_polylines: Data: 0.00MB + Index: 0.00MB
wp_huge_it_contact_contacts: Data: 0.00MB + Index: 0.00MB
wp_huge_it_contact_contacts_fields: Data: 0.01MB + Index: 0.00MB
wp_huge_it_contact_general_options: Data: 0.00MB + Index: 0.00MB
wp_huge_it_contact_styles: Data: 0.00MB + Index: 0.00MB
wp_huge_it_contact_style_fields: Data: 0.04MB + Index: 0.01MB
wp_huge_it_contact_submission: Data: 0.00MB + Index: 0.00MB
wp_huge_it_contact_subscribers: Data: 0.00MB + Index: 0.00MB
wp_links: Data: 0.00MB + Index: 0.00MB
wp_nf3_actions: Data: 0.00MB + Index: 0.00MB
wp_nf3_action_meta: Data: 0.04MB + Index: 0.01MB
wp_nf3_fields: Data: 0.01MB + Index: 0.00MB
wp_nf3_field_meta: Data: 0.34MB + Index: 0.05MB
wp_nf3_forms: Data: 0.00MB + Index: 0.00MB
wp_nf3_form_meta: Data: 0.03MB + Index: 0.01MB
wp_nf3_objects: Data: 0.21MB + Index: 0.08MB
wp_nf3_object_meta: Data: 1.40MB + Index: 0.15MB
wp_nf3_relationships: Data: 0.00MB + Index: 0.00MB
wp_nf3_upgrades: Data: 0.00MB + Index: 0.00MB
wp_ngg_album: Data: 0.00MB + Index: 0.00MB
wp_ngg_gallery: Data: 0.00MB + Index: 0.00MB
wp_ngg_pictures: Data: 0.00MB + Index: 0.00MB
wp_options: Data: 14.35MB + Index: 9.27MB
wp_postmeta: Data: 1.62MB + Index: 0.36MB
wp_posts: Data: 12.14MB + Index: 0.26MB
wp_termmeta: Data: 0.01MB + Index: 0.02MB
wp_terms: Data: 0.11MB + Index: 0.20MB
wp_term_relationships: Data: 0.04MB + Index: 0.09MB
wp_term_taxonomy: Data: 0.13MB + Index: 0.11MB
wp_tm_taskmeta: Data: 0.00MB + Index: 0.00MB
wp_tm_tasks: Data: 0.00MB + Index: 0.00MB
wp_usermeta: Data: 0.38MB + Index: 0.02MB
wp_users: Data: 0.00MB + Index: 0.01MB
wp_wc_download_log: Data: 0.00MB + Index: 0.00MB
wp_wc_product_meta_lookup: Data: 0.00MB + Index: 0.01MB
wp_wc_webhooks: Data: 0.00MB + Index: 0.00MB
wp_wfBadLeechers: Data: 0.00MB + Index: 0.00MB
wp_wfBlockedIPLog: Data: 0.00MB + Index: 0.00MB
wp_wfBlocks: Data: 0.00MB + Index: 0.00MB
wp_wfBlocksAdv: Data: 0.00MB + Index: 0.00MB
wp_wfConfig: Data: 0.00MB + Index: 0.01MB
wp_wfCrawlers: Data: 0.00MB + Index: 0.00MB
wp_wfFileMods: Data: 0.00MB + Index: 0.00MB
wp_wfHits: Data: 0.01MB + Index: 0.00MB
wp_wfHoover: Data: 0.00MB + Index: 0.00MB
wp_wfIssues: Data: 0.00MB + Index: 0.00MB
wp_wfKnownFileList: Data: 0.00MB + Index: 0.00MB
wp_wfLeechers: Data: 0.00MB + Index: 0.00MB
wp_wfLockedOut: Data: 0.00MB + Index: 0.00MB
wp_wfLocs: Data: 0.00MB + Index: 0.00MB
wp_wfLogins: Data: 0.00MB + Index: 0.00MB
wp_wfNet404s: Data: 0.00MB + Index: 0.00MB
wp_wfReverseCache: Data: 0.00MB + Index: 0.00MB
wp_wfScanners: Data: 0.00MB + Index: 0.00MB
wp_wfSNIPCache: Data: 0.00MB + Index: 0.00MB
wp_wfStatus: Data: 0.00MB + Index: 0.00MB
wp_wfThrottleLog: Data: 0.00MB + Index: 0.00MB
wp_wfVulnScanners: Data: 0.00MB + Index: 0.00MB
wp_wpbooking_availability: Data: 0.00MB + Index: 0.00MB
wp_wpbooking_favorite: Data: 0.00MB + Index: 0.00MB
wp_wpbooking_order: Data: 0.00MB + Index: 0.00MB
wp_wpbooking_order_hotel_room: Data: 0.00MB + Index: 0.00MB
wp_wpbooking_payment: Data: 0.00MB + Index: 0.00MB
wp_wpbooking_review_helpful: Data: 0.00MB + Index: 0.00MB
wp_wpbooking_service: Data: 0.00MB + Index: 0.00MB
wp_wpgmza: Data: 0.02MB + Index: 0.00MB
wp_wpgmza_categories: Data: 0.02MB + Index: 0.00MB
wp_wpgmza_category_maps: Data: 0.02MB + Index: 0.00MB
wp_wpgmza_maps: Data: 0.02MB + Index: 0.00MB
wp_wpgmza_polygon: Data: 0.02MB + Index: 0.00MB
wp_wpgmza_polylines: Data: 0.02MB + Index: 0.00MB
wp_wplc_chat_msgs: Data: 0.05MB + Index: 0.00MB
wp_wplc_chat_sessions: Data: 0.11MB + Index: 0.00MB
wp_wplc_offline_messages: Data: 0.02MB + Index: 0.00MB
wp_wp_criticalcss_api_queue: Data: 0.00MB + Index: 0.00MB
wp_wp_criticalcss_processed_items: Data: 0.00MB + Index: 0.00MB
wp_wp_criticalcss_template_log: Data: 0.00MB + Index: 0.00MB
wp_wp_criticalcss_web_check_queue: Data: 0.00MB + Index: 0.00MB
wp_yoast_seo_links: Data: 0.07MB + Index: 0.02MB
wp_yoast_seo_meta: Data: 0.03MB + Index: 0.03MB

### Post Type Counts ###

attachment: 497
clickfunnels: 1
custom_css: 3
custom-css-js: 6
customize_changeset: 8
deasil_team: 8
fmemailverification: 1
foogallery: 12
frm_form_actions: 3
frm_styles: 1
itineraries: 5
nav_menu_item: 58
nf_sub: 10
ngg_gallery: 2
ngg_pictures: 10
oembed_cache: 1
page: 47
payment: 7
polylang_mo: 6
post: 14
product: 28
product_variation: 1
revision: 937
rtbs_tabs: 1
scheduled-action: 17
shop_coupon: 1
shop_order: 2
tabs: 1
tabs_builder: 1
tabs_responsive: 1
testimonial: 8
tmm: 2
tr-tabs-pro: 1
tt_font_control: 1
user_request: 1
wp-travel-payment: 1
wpcf7_contact_form: 4
wpforms: 1

### Security ###

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

### Active Plugins (11) ###

Akismet Anti-Spam: by Automattic – 4.1.1
Autoptimize CriticalCSS.com Power-Up: by Deny Dias & Optimizing Matters – 1.15.2
Autoptimize: by Frank Goossens (futtta) – 2.5.0
Classic Editor: by WordPress Contributors – 1.4
Contact Form 7: by Takayuki Miyoshi – 5.1.1
Deasil Core: by Mold Themes – 1.5
WPBakery Page Builder: by Michael M - WPBakery.com – 5.7
One Click Demo Import: by ProteusThemes – 2.5.1
Really Simple SSL: by Rogier Lankhorst
Mark Wolters – 3.1.5

WooCommerce: by Automattic – 3.6.2
Yoast SEO Premium: by Team Yoast – 11.0

### Inactive Plugins (7) ###

AddToAny Share Buttons: by AddToAny – 1.7.35
Duplicator: by Snap Creek – 1.3.10
Envato Market: by Envato – 2.0.1
Health Check & Troubleshooting: by The www.ads-software.com community – 1.2.6
Hello Dolly: by Matt Mullenweg – 1.7
WooCommerce Blocks: by Automattic – 2.0.1
WooCommerce HBL: by  – 1.0.0 – Not tested with the active version of WooCommerce

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

Health Check Troubleshooting Mode: by  – 1.5.1

### Settings ###

API Enabled: ?
Force SSL: ?
Currency: USD ($)
Currency Position: left_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 ###

Shop base: #3795 - /shop/
Cart: #3797 - /cart/
Checkout: #3799 - /checkout/
My account: #3801 - /my-account/
Terms and conditions: #3700 - /our_policies/

### Theme ###

Name: Deasil
Version: 2.0
Author URL: https://moldthemes.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: deasil/woocommerce/archive-product.php
deasil/woocommerce/content-product.php version 3.4.0 is out of date. The core version is 3.6.0
deasil/woocommerce/content-product_cat.php
deasil/woocommerce/content-single-product.php version 3.4.0 is out of date. The core version is 3.6.0
deasil/woocommerce/content-widget-product.php
deasil/woocommerce/content-widget-reviews.php
deasil/woocommerce/global/breadcrumb.php
deasil/woocommerce/loop/add-to-cart.php
deasil/woocommerce/myaccount/my-account.php
deasil/woocommerce/myaccount/navigation.php
deasil/woocommerce/single-product/add-to-cart/external.php
deasil/woocommerce/single-product/add-to-cart/grouped.php
deasil/woocommerce/single-product/add-to-cart/simple.php
deasil/woocommerce/single-product/add-to-cart/variable.php
deasil/woocommerce/single-product/add-to-cart/variation-add-to-cart-button.php
deasil/woocommerce/single-product/add-to-cart/variation.php
deasil/woocommerce/single-product/product-thumbnails.php
deasil/woocommerce/single-product/related.php
deasil/woocommerce/single-product/title.php
deasil/woocommerce/single-product-reviews.php version 3.5.0 is out of date. The core version is 3.6.0
deasil/woocommerce/single-product.php
deasil/woocommerce/taxonomy-product_cat.php
deasil/woocommerce/taxonomy-product_tag.php

Outdated Templates: ?
					
					
						Learn how to update

### Action Scheduler ###

Complete: 16
Oldest: 2019-04-18 08:57:14 +0000
Newest: 2019-04-25 08:57:28 +0000

Pending: 1
Oldest: 2019-05-02 08:57:28 +0000
Newest: 2019-05-02 08:57:28 +0000

Canceled: 0
Oldest: –
Newest: –

In-progress: 0
Oldest: –
Newest: –

Failed: 0
Oldest: –
Newest: –

• This reply was modified 5 years, 10 months ago by Jan Dembowski.
• This reply was modified 5 years, 10 months ago by Jan Dembowski. Reason: Formatting

Thank you for sending that!

Sorry about this, but it seems I made a mistake in the shortcode I sent you before ;-(

Can you try this one;

[products limit=”4″ columns=”4″ orderby=”title” order=”ASC” on_sale=”1″]

With this code it shows all the products available both Products on sale and regular.

I just want to show products on sale only on a page if possible.

Wpbakery site builder generate following short code, but it does not work.

[vc_column][sale_products per_page=”4″ columns=”4″ orderby=”title” order=”ASC”][/vc_column][/vc_row]

Hey @chitrag135

Sorry for the late response!

I had a look at your https://www.egtours.com/travel-deals/ page again and can see only on-sale products there now.

What was the cause for them not showing?

No it is fixed. It was due to plugin conflicts. So after removing some of plugin it start working again.

Hi @chitrag135

Thanks for letting me know!

I’m going to mark this as resolved now and if you have any further questions, you can start a new thread.

It is resolved itself but I do not know how.