• Resolved gvnet

    (@gvnet)


    Hi,

    I have imported sale prices with ‘sale_price_dates_from’ and ‘sale_price_dates_to’ dates to schedule the sale price via CSV Import. To end a sale manually, I import a ‘sale_price_dates_to’ using a date that has already expired. Normally, the schedule is then cleared from the product settings, so there is no sale price value and no sale start and sale end dates.

    This time, the sale price and sale start & end dates are still in the product settings?

    https://snipboard.io/TY3VDf.jpg

    I looked at running the woocommerce_scheduled_sales action via WP Crontrol, however it looks like that action has been deprecated: https://woocommerce.github.io/code-reference/namespaces/default.html#function_woocommerce_scheduled_sales

    I have also tried clearing the Woocommerce and WordPress expired transients from Woocommerce > Status > Tools, however the sale price and scheduled dates are still on the product page settings.

    Questions:

    Is there a new action that triggers the sale start / end schedule that I can manually trigger?

    I see a ‘cancel schedule’ link on the sale price settings, can this be run in bulk e.g. via import or an action, as I have hundreds of products so doing this manually is not an option?

    Woocommerce 9.1.4

    WordPress 6.6.1

    Many thanks.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello gvnet,

    Thank you for contacting Woo support.

    I tried the same steps on my test site and got the same result as you have.
    The date values are updated accordingly in the product settings.
    On the front end, the product is no longer on sale since the date has passed.

    This is the expected behavior of WooCommerce core.
    The values imported are added in the product settings and the sale price is displayed if the date has not expired.

    To confirm in the past, when you imported past dates in the “Sale price dates” field, the field would become blank. Is my understanding correct?
    If it is correct, could you tell me in which version of WooCommerce this was happening?
    I can investigate this further using that version.

    Regarding the woocommerce_scheduled_sales action, I suggest you post your question at the WP Crontrol support forum.

    Looking forward to your response. ??

    Best regards.

    Thread Starter gvnet

    (@gvnet)

    I know I did an import on 13 March 2024. As I keep Woocommerce up to date, it would have been whatever the current version of Woocommerce was at that time.

    Regarding the ‘woocommerce_scheduled_sales’ action, this was part of Woocommerce core but it seems to have been deprecated. So I am wondering if the Woocommerce developer shave replaced it with some other method? If I set a schedule sale price, it has to run that schedule daily I would imagine?

    Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello gvnet,

    Thank you for your reply.

    I rolled back the WooCommerce version to 8.7.0.
    This is the version that was the latest on 13 March 2024.

    Then I repeated the same steps and got the same results.
    The fields are not made black if we put past dates in the “Sale price dates” field.

    I even tried putting a blank “” in the CSV and as a result, this blank value is ignored by the import process. Then the value is not updated at all.

    Just to confirm, you were using the default import feature provided by WooCommerce and not a 3rd party plugin.

    Looking forward to your response. ??

    Best regards.

    Thread Starter gvnet

    (@gvnet)

    Thank you for testing this. I was using Woocommerce Product CSV Import Suite, which I did use again this time when the values were left in those fields. I can raise a ticket with Woo paid support for this if you like?

    The main reason I posted here was regarding the questions in the original post that do not relate to a paid plugin but Woo core instead:

    Is there a new action that triggers the sale start / end schedule that I can manually trigger? (instead of ‘woocommerce_scheduled_sales’?that is mentioned in many other support threads regarding sale prices and schedules not updating correctly)

    AND

    I see a ‘cancel schedule’ link on the sale price settings, can this be run in bulk e.g. via import or an action, as I have hundreds of products so doing this manually is not an option?

    Many thanks.

    Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello gvnet,

    Thank you for your reply.

    I was using Woocommerce Product CSV Import Suite, which I did use again this time when the values were left in those fields. I can raise a ticket with Woo paid support for this if you like?

    If you are using Product CSV Import Suite for WooCommerce then creating a ticket with WooCommerce.com would be a good idea.

    Is there a new action that triggers the sale start / end schedule that I can manually trigger? (instead of ‘woocommerce_scheduled_sales’ that is mentioned in many other support threads regarding sale prices and schedules not updating correctly)

    If you are looking for an alternate action to “woocommerce_scheduled_sales” then I suggest posting this question at Woo Community Slack or Woo Community Facebook group.
    There are many devs and other WooCommerce users that might be able to assist you with your question. This forum is intended to provide support for core WooCommerce features.

    I see a ‘cancel schedule’ link on the sale price settings, can this be run in bulk e.g. via import or an action, as I have hundreds of products so doing this manually is not an option?

    WooCommerce does not provide any option in the settings to run “cancel schedule” in bulk.
    I would suggest you also post this at Woo Community Slack or the Woo Community Facebook group.
    Hopefully, you will get some answers to solve this problem.

    I hope this helps. ??

    Best regards.

Viewing 5 replies - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.