After I imported a list of products, the products that were imported cannot be filtered until I edit the product from the admin panel and hit SAVE without changing anything. After that, it filters fine.
I recall this issue happened to me once when I imported and specified the “weight” attribute incorrectly. This time, I checked all the mandatory values and they all seem valid.
I also exported to XML after my import and all the products that are filterable are no different than the products that aren’t filterable.
To see this issue: Check out the web store in my signature and go to the Lexmark category. Then apply the “Original (OEM)” filter. You’ll notice that even though most of the products in the lexmark category actually have the “Original (OEM)” attribute, they don’t show up after the filter is applied.
Does anyone have any ideas of why this may be happening, how I could fix the problem, or what precautions I could take to ensure that it doesn’t happen for future imports?
Okay I think there was some corruption with one of my attributes. I tried all sorts of things, but in the end I just deleted the attribute and everything worked out fine.
I created a “mass-action” command to refresh items by simply loading them from the database, then saving them without doing any modifications. This ensures data consistency and helps reduce point-of-sale issues, essentially pseudo-testing each item. Maybe I’ll add this to my enhanced grid upcoming extension.