Story 48.1 Allowing “Removed” Products back in “Stock”

General Info

Our automation currently marks products as Removed by Seller or Removed from Sale when stock is set to 0, either via WordPress or via the Airtable field “quantity” + sync. Once removed, there is no way to restore the product—this creates a dead end.

Current behaviour:

If we change the quantity back to 1, the product status does not return to “In Stock”, and the order flow for future orders becomes disrupted. Product Statuses in Airtable are incorrectly displayed for future orders. Email notifications may not be sent, and the product may not appear on the website. WordPress continues to display the “Removed on [Date]” tag, even though the product is technically restocked.

We currently only send a Slack notification in #syb_bag_was_removed_by_seller when a seller removes a product via their account. There is no Slack notification when an admin manually removes a product by setting quantity to 0.

Expected behaviour:

This story enables the sales team to restore a removed product by setting the quantity back to 1 (in WordPress or Airtable) and syncing. The product status should return to In Stock, and all standard order flows and notifications should resume as if it had never been removed. Additionally:

• The WordPress tag should update to “Back in stock on [Date]”

• Slack notifications should be posted when either sellers or admins remove or restore products

• When an admin removes a product manually, the admin’s email address should be included in the Slack message

• All such notifications should be posted in a unified Slack channel renamed to #bag_was_removed

Changes

• Allow quantity change from 0 → 1 for products with status Removed by Seller or Removed from Sale

• On sync or manual WooC update:

  • Set product status to Stock in Airtable and InStock in WooC

  • Update or append WooC log: “Back in stock on [Date]”

• Trigger existing “Product Is Live” email to seller upon restoration

• Rename Slack channel from #syb_bag_was_removed_by_seller to #bag_was_removed

• Post Slack message in #bag_was_removed on restoration:

  The [Bagname (w/ link)] [SKU] was put back in stock by [admin email]

• New: When a product is manually removed by admin (quantity set to 0), post in #bag_was_removed:

  The [Bagname (w/ link)] [SKU] was removed by admin

  admin email: [admin@email.com]

• Ensure all downstream flows (selling, status transitions, email notifications) behave identically to a standard in-stock or removed product

• Confirm products can be removed and restored repeatedly without breaking order flows or logging

User Story

As a sales team member,

When I restore a product by changing its quantity from 0 back to 1 and syncing or updating,

Then the product should appear back in stock on the website,

And all order and notification workflows should work exactly as for any in-stock product,

Including sending the standard “Your bag is now live” email to the seller.

As a sales team member,

When a product is manually removed by admin/teammember (quantity set to 0),

Then a Slack message should be sent, just like when a seller removes a product,

Including the admin’s email who triggered the removal,

So the team has visibility into who took the action.

As a sales team member,

I want all removal and restoration messages to appear in a single renamed Slack channel: #bag_was_removed.

Acceptance Criteria