If you sell clothing and want to set up a sale on your category T-Shirts. In Bulk Table Editor this is an easy task. Just select the category i.e T-Shirts and enter a value in the bulk function for sale price i.e 25 and select in the dropdown box – decrease in %. Bulk Table Editor then calculates a 25% sale based on your regular product price and add it to all your products in the category T-Shirts.
After this you just can set a sale start or a sale end date. This is done by selecting the dates in the bulk functions for start and end date, Bulk Table Editor then fills the rows for you automatically. Just uncheck products you do not want on sale and click the save all button.
Sales dates
Sales dates is optional. This means that you can i.e use start dates and no end dates. This gives you a sale that starts on a date and runs until you stop it by clearing the sale price (function for this). The same goes for using only the sale end date, means that the sale starts now and ends on the date you selected. If you create a sale with no dates the sale starts now and runs until you remove the sale price.
Sale time
You will also find sale start / end time in the Sale date columns. This will enable you to set when the sale starts and ends (minute). With this function you can have hour sales if you like. Use the bulk set time in the heading for quick set and remember to save.
By default the sale schedule works like this:
- If you set only a sale price and save, the sale starts now and lasts until you remove the sale price.
- If you set a sale price and sale start date, the sale starts on the date set (00:00:00) and lasts until you remove the sale price.
- If you set a sale price and sale end date the sale ends on this date at 23.59.59, and the sale price and dates will be removed from your product.
Action Scheduler
To make sure your sale starts and ends as you have scheduled it (using date + time) you need to enable using Action Scheduler for cron jobs. To enable this go to WooCommerce > Settings > Bulk Table Editor > Cron Jobs (sales) and set your interval (how often to check if a sale is started or ended). Read more…
