[Resolved] WooCommerce _sale_price_dates_to renderd as a long number on frontend

[Author]

Posts

[Nashaat]

hi,
I have added following shortcode to Layout

[wpv-post-field name='_sale_price_dates_to']

the field renders long number instead date on the front end.

I have added this function to Code Snippet but this didnt help

function offer_end_date( $atts ){
  global $post;
  $sales_price_to = get_post_meta($post->ID, '_sale_price_dates_to', true);
  $sales_price_date_to = date("j M y", $sales_price_to);
  return $sales_price_date_to;
}
add_shortcode( 'end_date', 'offer_end_date' );

how can i fix this?

[Minesh]

Hello. Thank you for contacting the Toolset support.

Well - could you please tell me how and where you are using the custom shortcode you wrote.

It looks like field _sale_price_dates_to stores unix timestamp but I can guide you in right direction if you can share problem URL and access details with me.

*** Please make a FULL BACKUP of your database and website.***
I would also eventually need to request temporary access (WP-Admin and FTP) to your site. Preferably to a test site where the problem has been replicated if possible in order to be of better help and check if some configurations might need to be changed.

I would additionally need your permission to de- and re-activate Plugins and the Theme, and to change configurations on the site. This is also a reason the backup is really important. If you agree to this, please use the form fields I have enabled below to provide temporary access details (wp-admin and FTP).

I have set the next reply to private which means only you and I have access to it.

[Minesh]

Could you please check now.

I've added the following code to your code snippet:
=> hidden link

function func_offer_end_date( $atts ){
  global $post;
  $sales_price_to = get_post_meta($post->ID, '_sale_price_dates_to', true);
  $sales_price_date_to = date("j M y", $sales_price_to);
  return $sales_price_date_to;
}
add_shortcode( 'display_end_date', 'func_offer_end_date' );

And then with layout's cell - I've called the above shortcode as given under:

[display_end_date]

And now I can see the date is displaying with format you set:
=> hidden link

Could you please confirm it works at your end as well.

[Nashaat]

ok now i can see clearly a date but not the same date of woocommerce sale_date_to
in the product we have 28-06-2018
on the front end 27-6-2018

I have added another code for start date also and work the same as end date:
in the product we have 14-06-2018
on the front end 13-6-2018

function func_offer_end_date( $atts ){
  global $post;
  $sales_price_to = get_post_meta($post->ID, '_sale_price_dates_to', true);
  $sales_price_date_to = date("j M y", $sales_price_to);
  return $sales_price_date_to;
}
add_shortcode( 'display_end_date', 'func_offer_end_date' );

function func_offer_start_date( $atts ){
  global $post;
  $sales_price_from = get_post_meta($post->ID, '_sale_price_dates_from', true);
  $sales_price_date_from = date("j M y", $sales_price_from);
  return $sales_price_date_from;
}
add_shortcode( 'display_start_date', 'func_offer_start_date' );

[Nashaat]

Update:
when the product is submitted with Cred form, the right dates show up.
Product form : hidden link

but when the product submitted via WordPress dashboard and woocommerce the date show up wrong.

[Minesh]

Well - what if you change the timezone setting at: Settings => General => Timezone and set it to UTC+0 and save the setting.

After that try to create a new product and assign a date and try to display it - does that work?

[Nashaat]

Minesh you are a Genius! Thank you for your help, you always solve issues.

[Minesh]

Well - would you mind to resolve the ticket with happy face and feel free to share your feedback whatever you experience 🙂

[Nashaat]

Sure. Resolved and left a feedback for your awesome help!