Error in integrating Zen-cart to WordPress with this plugin

Setting up this plugin is pretty straight forward.. Issues occur if the prerequisites are not met or if one of the admin options does not match your Zen Cart /includes/configure.php file.

Please check both.. I’m certain the issue is in one or both..

Does your WordPress/Zen Cart setup match the required prerequisites??

Prerequisites for Zen Cart for WordPress (zen4wp)

• A Zen Cart store installed and operable. Tested with Zen Cart v1.5.x.
• WordPress installed and operable. Tested with WordPress v3.5.x – v3.9.x.
• The Zen Cart and WordPress installations share a common mySQL database. (use table prefixes to separate WordPress tables from Zen Cart tables)
• The Zen Cart and WordPress installations must share the same domain.
• Update the admin configuration options with the correct filepath to the WordPress installation.

Note: If your store/blog configuration does NOT match these prerequisites, then Zen Cart for WordPress (zen4wp) will not function

If your WordPress and Zen Cart setup meets the prerequisites, then set the plugin option settings to the value of the like-named entry in your Zen Cart’s /includes/configure.php file. They need to match EXACTLY..

The error message you are getting is pretty straight forward. If WordPress and Zen Cart do not SHARE the SAME database or if you entered the database prefix incorrectly in the admin options, then I would expect to see the error you are getting.. Check this and all your other settings..

Please post back if you are still having issues.. ??

Wanted to add some more info..

Doesn’t matter which one you install first (Zen Cart or WordPress), but during the installation when you are asked for your database information you MUST use the SAME database information for both. (DB name, DB Password, DB Username)

Regarding database prefixes: The default Zen Cart database prefix is ” (i.e. none) and the default WordPress prefix is ‘wp_’. While PERSONALLY I prefer using a DB prefix for BOTH Zen Cart and WordPress (i.e. Typically I use zen_ for Zen Cart and for WordPress I use wp_), as long as the prefixes are different, you should be good-to-go!

Changing the table prefix for the Zen Cart tables is pretty easy, but NOT REQUIRED. For anyone who has already installed Zen Cart without a table prefix (the default), and now WANTS to add a table prefix, there is a very SIMPLE script you can run to add a table prefix to one’s Zen Cart install.

SELECT Concat('ALTER TABLE ', TABLE_NAME, ' RENAME TO my_prefix_', TABLE_NAME, ';') FROM information_schema.tables WHERE table_schema = 'my_database'

Your result set will be a bunch of queries that you can copy and paste into your favorite MySQL editor (phpMyAdmin, whatever). Just paste those in and execute, and you’re all done.

Once the script its run, an update to the store and admin configure.php files to include the new table prefix is all that’s needed..

Hello. Thank you for creating this plugin. I happen to be having the same problem as the subscriber above. I also have the error:
No configuration keys were found in the table zen_configuration. Either the value you entered for ZEN_DB_PREFIX
I am using zencart v1.5.4 and WP 4.2.3
Zen cart is installed on diamondintheround.com
WP is installed on diamondintheround.com/blog
Please remember, I am NOT a programmer.
I do not know if the SQL matches or what EXACTLY needs to be entered.
I do not know if the prerequisites have been met. I also do not know how to add a table script. It does not matter how “clearly” something is stated if the reader does not understand.
Thank you.

@diamondintheround.. This issue was marked resolved so you really should have started a new post so that I get the notifications from this support forum..

I understand you are not a developer, but most of the folks using this plugin are not developers either.. and they don’t have to be..

That said, honestly if you cannot confirm whether or not the prerequisites have been met it’s hard to know what the issue is..

If the prerequisites have been met and you enter the correct information from the Zen Cart configure.php file into the admin settings for this plugin, it will work.

If you are still having issues, please pot a NEW thread, and I’ll try my best to help you.. However, it’s very possible that you may need to pay someone to assist you in making sure this plugin is installed correctly and that the prerequisites for using this plugin and configuration settings are correct.