Can’t clear “Date sale price ends” by CSV upload

  • Resolved exitoffroad

    (@exitoffroad)


    3 months ago

    Super simple task, just trying to delete the dates (“Date sale price ends”) that were applied for when our recent sale ended, which was 2024-12-01. The date has now passed and the date didn’t drop out of each of the products (over 1500 products) in the back end. The start date deletes itself once that date has passed. I can manually delete them, but that would take forever.

    I tried uploading a super simple CSV file with just the SKU and a blank “date sale price ends” field, but it doesn’t clear that field.

    Any suggestions for what to put into that field in the CSV so that those dates would be cleared out?

    In the future, if I add a sale price to any one of those items, I don’t want it to not work because the expiration date is still in there and has already past. I’ve found the date start and date end functions to be super glitchy and probably won’t use them again.

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Support Reynier (a11n)

    (@reynierc)

    Hi @exitoffroad

    I understand clearing out past sale end dates from a large number of products can be quite a task. Just to check, are you using a third-party sales countdown plugin to manage the start/end date of a sale? If yes, can you let me know which one?

    About the data on the CSV file, instead of leaving the “date sale price ends” field blank in your CSV, try entering “NULL” (without quotes) in that column for each SKU. This should remove the expired dates when you import the CSV back into WooCommerce.

    Let me know how it goes.

    Thread Starter exitoffroad

    (@exitoffroad)

    Hello, thanks for the reply.

    No, I’m using the built-in import/export function. And there’s a feature to “schedule” the start/end dates of a product in the product itself.

    I just tried importing a single product with the end date of “NULL” and it still kept the old date in the field. I’ve made these screenshots to share showing the button I press to import, the scheduled date, and the CSV.

    https://exitoffroad.com/wp-content/uploads/2024/12/Screenshot-product-import-date-issue.jpg

    Plugin Support Reynier (a11n)

    (@reynierc)

    Hi @exitoffroad

    Thanks for the screenshots and extra details, they really help. It looks like the “NULL” method isn’t working as expected, in this case. Can you try using “0000-00-00” instead of “NULL” for the “date sale price ends” field in your CSV (without the quotes ” “). Then import your file again. (It’s always recommended to secure a backup of your site before bulk updates).

    Also, ensure you select ‘Update existing products’ while importing. This guide can help.

    Give that a go and let us know how it works out.

    Thread Starter exitoffroad

    (@exitoffroad)

    Great, that worked, using “0000-00-00” in the end date field worked and cleared out the dates.

    Once that was working, and verified, I tested the end date again. It specifically says in the ? box of the scheduler that the end date will end at 23:59:59 of the “to” date. I just did that, for today with an upload by CSV by using “2024-12-03” on a single product, and it immediately stopped showing the sale price of that product. If I manually add today’s date in the scheduler, the sale prices stays (assuming until midnight). I don’t know what to do about that.

    Are we able to use something like “2024-12-04 2:59:59” to set the time to end at a specific time of the day during a CSV upload? And if so, is there a way it will show up in that field of the product box? Because if I try to upload something like that now, I can’t tell if it actually took it and will work properly at the date and time I’m requesting.

    Plugin Support Reynier (a11n)

    (@reynierc)

    Hi @exitoffroad

    I’m glad to hear that using “0000-00-00” cleared out the dates successfully. Now, regarding your question about setting a specific end time, the import via CSV should indeed recognize the format “YYYY-MM-DD HH:MM:SS”. For setting an end time of 23:59:59, you would enter “2024-12-03 23:59:59” in the field.

    When you import your CSV with this date/time format, the product scheduler in the WooCommerce interface won’t show the exact time (it’ll just show the date), but the system will process the end date and time as intended.

    After importing, you can verify this by checking if the sale stops as scheduled after 23:59:59. If it doesn’t display the time in the product data box and you need to confirm that the exact time is set, you may need to view the product details directly in the database or alternatively check your site at the specified end time.

    Remember to always keep backups when working with product imports or any other bulk changes. Also, if you want to be absolutely certain, you may want to conduct a test on a single product to confirm the behavior before applying it in bulk.

    Hope this helps!

    I have the same problem. Neither NULL nor 0000-00-00 methods work for me. I had to search for and install a third party plugin (Product Import Export by WebToffee) to be able to do such a basic task.

    It’s beyond my understanding why WooCommerce would not allow you to clear fields by csv import..

    Plugin Support shahzeen(woo-hc)

    (@shahzeenfarooq)

    Hi there!

    I can understand your frustration, especially since you’re facing a similar issue.

    However, per forum best practices shown here, it is advised that you create a new thread so that we can address your issue(s) separately.

    You can create a new thread here: https://www.ads-software.com/support/plugin/woocommerce/#new-topic-0 and make sure to include as much information as you can.

    Thanks for understanding!

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