Archive Shopify Products if Sold Out for 30 Days

This scheduled trigger runs once per day at your configured time (default is typically midnight or early morning). It initiates the workflow that checks the "Sold Out Shopify Product Tracker" database for products that have been out of stock for 30 or more days. You can customize the schedule frequency and time in the trigger settings to match your business needs.

This step runs a SQL query against your "Sold Out Shopify Product Tracker" table to find products where Status = "Active" (not already archived) and the Sold Out Start Date is 30 or more days in the past. The query calculates the day count by comparing the current date to the Sold Out Start Date and returns only records that meet the 30-day threshold. Results include Product ID, Product Title, Sold Out Start Date, and Sold Out Day Count for each product that qualifies for archiving.

This loop step iterates through each record returned by the database query. For every product that's been sold out for 30+ days, the loop executes the subsequent archiving and database update steps. The loop processes products sequentially until all qualifying products have been archived and their records updated.

This step updates the corresponding record in the "Sold Out Shopify Product Tracker" table by setting Status to "Archived" and Sold Out End Date to the current timestamp. The record now shows the complete sold-out lifecycle from start date to end date. Changing the status to "Archived" ensures the next daily run won't find this product in the query results, preventing duplicate archiving attempts.

This step updates the product status to "archived" in Shopify using the Product ID from each loop iteration. Archiving the product removes it from your online storefront and collections while keeping it in your Shopify admin for future reactivation. The product remains searchable in admin and retains all its data (images, descriptions, variants) so you can easily unarchive and republish when restocked.