Importer Tool - Works but strange results
I've now used the importer tool, which loaded over 1000 coupons and marked them all as draft. I ran a script in MYSQL to change them all to "publish" and gave each a publish date & time.
On the home page it lists all categories however, for example, it shows Animals (0)
despite it having 6 coupons assigned (as can be seen in the admin panel). When I click on Animals
it correctly shows the 6 coupons assigned to the Animals category.
Also, one of the coupons is for PET STORE A
. When I do a search for PET STORE A
it doesn't give me option in the pre-emptive search panel meaning it doesn't think there are any coupons. However, if I go via the ALL STORES
link, and choose PET STORE A
then it will show the coupon.
I have Optimized, Repaired, Analyzed and Checked all the tables at MYSQL level and there are no known issues. I've also used WP
-Optimize but so far haven't found a fix.
Obviously somewhere a link has broken between posts, categorys and stores but does anyone know how to automatically correct this?