If you are using OpenCart and you have like 1000+ inventories, you will do yourself a great favor by using this tool called “Total Import Pro” written by these great people @ HostJars.com. You can thank me later.
As with all great piece of software, you also get your share of annoying little bugs that somehow got shipped along with the good stuff. And today, I just wrote to them about the possibility that their importer could be causing special HTML characters not parsed correctly in OpenCart.
I’ve been using Total Import Pro for the past 3 years, and I must say you guys have saved hours of my life. For that, I would like to thank you for such a great piece of software.
However, I recently noticed a Total Import bug that would eat up at least 50 hours of my life if I am to fix them manually. So, I really want to reach out to you and hope you can once again save my life (50 hours of it).
Here’s what happened:
1) I have a product with the title “K&N Performance Air Filter 33-2922”. Notice the special character & in there.
2) When I import using Total Import Pro, what happen next is, I am not able to find the product after I type the character “K”. So, imagine the number of products I have with the starting letter K…
3) However, I could fix the problem if I manually save the product again using OpenCart. Somehow when I save using OpenCart, the ampersand is properly parsed in the database as a valid character. In other words, when I import using Total Import Pro, the symbol ampersand is not treated as such.
4) This also leads to the problem of generating a valid sitemap for Google, because each time I tried to load my sitemap, Chrome will tell me the “Sitemap is not well-formed”. Well-formed or not, I am not looking for a kick-ass, bootylicious XML, but at least one that will not return any errors when parsing special characters in the product title.
As such, I would really appreciate it if you could tell me how I can import my products with the special characters registered normally in OpenCart.
Name a price for 50 hours of my life.
I will post it up here once I get a response from them.
And on Sep 22, I got a reply from Matt of Hostjars.com
Thanks for getting in touch! It looks like you have discovered a bug, as we offer bug fixes for free this will not cost you anything to have fixed! In fact, our developers have just released a patch for this issue this morning. It is still undergoing our internal review process, but to save you any further delay while this happens I am going to send you a copy of the latest version of Total Import PRO which contains this fix.
Follow the installation instructions and overwrite your existing files to update your installation.
Once you have updated please try your import again and let me know if you have any further problems.
Can’t wait to install the new patch on my OpenCart.