In addition to the Matrixify method, here is a method for automatically scheduling discount sales using Shopify Flow. Since you cannot set a discount price using Flow actions, we handle this by preparing two products with the same SKU and switching between them.
Example of setting up Shopify Flow to automatically start and end product discounts
[Setting Method 1] Duplicate the target product (same SKU) and set the pre-discount product to published status and the discounted product to draft status. Also, specify the publication date and end date for each product using tags in the specified format.
[Setup Method 2] Set up a Flow that will publish or switch the target product to draft status on a specified date using a daily schedule trigger.
