Square Champion

Bug Report: Disabled Item Variations Still Appear in Stock Filters After Deactivation at a Location

Environment:

  • Standard User Catalog Manager Interface

Description:
When an item’s variation is deactivated and stock tracking is disabled for a specific location, the item is still appearing in filtered inventory lists based on stock alerts. Even after unchecking "available" and "track stock" for a particular location and saving the changes, the item remains visible when filtering by conditions intended to exclude it (e.g., “Out of Stock” and stock quantity "> 1”). This behavior suggests that the item’s stock alert and tracking flags are not being fully deactivated at the backend level upon location deactivation.

 

Steps to Reproduce:

  1. Open an item that is available in multiple locations.
  2. Select “Edit Variation Details” for a variation of the item.
  3. Under “Manage Stock,” uncheck both “Available” and “Track Stock” for the desired location (e.g., deactivate the item at Location B).
  4. Save the changes.
  5. Navigate to the inventory management section and apply filters intended to show items meeting certain stock conditions (for example, filter inventory by:
    • Stock Alert: Out of Stock
    • Stock Quantity: > 1
      ).
  6. Observe that the item, which should be excluded due to its deactivation at the chosen location, still appears in the filtered results.

Expected Behavior:
Once the item variation is deactivated and tracking/alerts are disabled for a specific location, that item’s variation should not appear in filtered inventory results that rely on stock-based conditions. The deactivation should remove it from all views dependent on stock alerts and availability at that location.

 

Actual Behavior:
The item variation continues to appear in filtered inventory lists, indicating that the underlying stock alert and tracking flags were not properly cleared or updated after being deactivated at the location level.

 

Example Scenario:

  • Location A: JT Pets - Concession (Active)
  • Location B: JT Pets - Farmers Market (Deactivated)
    An item that is active and in stock at Location A but deactivated at Location B still appears in inventory searches filtered by stock alerts, even though it should not.

Date First Noticed:
Issue observed recently during the process of winding down operations at Location B.

 

Frequency:
Consistent whenever items are deactivated at one location and filtered by stock conditions afterward.

 

Workarounds Proposed:

  • Manually editing the catalog via a downloaded copy and re-uploading after removing all stock alerts and tracking flags. This is not an ideal or intended process, as these flags should be cleared automatically upon deactivation.

Impact:
This bug leads to confusion and incorrect inventory reporting, making it difficult to rely on filtered inventory views to accurately represent item availability. It may also result in incorrect fulfillment actions or ordering decisions if staff assume the filtered results are accurate.

 

Recommended Next Steps:

  • Investigate the backend handling of stock alert and tracking flags to ensure that deactivating an item at a location properly resets these flags.
  • Implement a fix so that once an item is deactivated at a location, it no longer appears in filtered inventory lists tied to stock availability or alerts.
  • If it’s necessary to maintain certain stock-related flags for historical or reporting purposes, consider updating the filter logic to check the item’s activation status at the location level before applying stock-based filters. This ensures only active, relevant items appear in filtered results.
  • Test and verify that items deactivated at a specific location do not appear in inventory filters meant to highlight active, in-stock items.

@isabelle for vis

 

2,048 Views
Message 1 of 15
Report
14 REPLIES 14
Square Champion

2,047 Views
Message 2 of 15
Report
Admin

@Summer2024 do you think you could escalate this to the Catalog Manager Product team? Looks like enough info to file a bug. 

 

I'll keep an eye on the thread too! 

Square Champions Logo
Isabelle
Square Community Manager
Learn about the Square Champions program here.
2,044 Views
Message 3 of 15
Report
Square Community Moderator

Hi @isabelle - Yes. Will file now! 

2,041 Views
Message 4 of 15
Report
Square Community Moderator

Hi @JTPets !

 

Our catalog team is having a hard time figuring out exactly what is going on here. I know you were super descriptive, but they are looking for more details. I believe they would like a couple more item examples as well as maybe a screen recording. 

2,025 Views
Message 5 of 15
Report
Square Champion

2,006 Views
Message 6 of 15
Report
Square Community Moderator

Thanks @JTPets - I will get this over to them. 

2,004 Views
Message 7 of 15
Report
Square Community Moderator

@JTPets - They are triaging my ticket now. I will provide updates as they become available. 

1,975 Views
Message 8 of 15
Report
Square Community Moderator

@JTPets - Engineers are still trying to determine what is going on here. I was hoping to have an update before the weekend, but it is not looking like that will happen. I am keeping my eyes on it today.

1,934 Views
Message 9 of 15
Report
Square Champion

1,932 Views
Message 10 of 15
Report
Square Community Moderator

Hi @JTPets ! 

 

I am back for a couple days following the Christmas holiday....I am still monitoring your ticket with engineers. They are still actively working on it. Just providing an update! 

1,908 Views
Message 11 of 15
Report
Square Community Moderator

Whew @JTPets - this was a difficult one....however, engineering has confirmed that this should be working properly on your account. Hopefully that is truly the case here! Sorry it took so long. It was a pretty complicated bug. 

 

 

1,257 Views
Message 12 of 15
Report
Square Champion

1,244 Views
Message 13 of 15
Report
Square Community Moderator

Sigh....I will report back to engineers. 

1,242 Views
Message 14 of 15
Report
Square Community Moderator

@JTPets  When using the stock filter “Equal to 0” I was able to get items that have 0 in stock at all locations. Can you try using this filter? 

1,234 Views
Message 15 of 15
Report