Thread: Importer Tool - Works but strange results

Importer Tool - Works but strange results

Hi All

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?

Thanks

hey how do you run the script to bulk publish coupons