WordPress® for Zen Cart® (wp4zen) [Support Thread]

[gjh42]

Having Zen Cart look up info in WP tables in a database ZC already has access to is a world of difference from having to establish credentials and communication with a different database. The two table systems can be separated with prefixes if necessary; the capability is built into Zen Cart.

[lat9]

Having Zen Cart look up info in WP tables in a database ZC already has access to is a world of difference from having to establish credentials and communication with a different database. The two table systems can be separated with prefixes if necessary; the capability is built into Zen Cart.

Exactly, Glenn. The database-prefix capability is also built into WordPress!

[DivaVocals]

<p>
**deleted**</p>

[DivaVocals]

Having Zen Cart look up info in WP tables in a database ZC already has access to is a world of difference from having to establish credentials and communication with a different database. The two table systems can be separated with prefixes if necessary; the capability is built into Zen Cart.

Exactly, Glenn. The database-prefix capability is also built into WordPress!

Nods in agreement with ALL of the above..

Hi DivaVocals, just one question: why it requires the same database as the zen-cart uses? Could I configure a different database for the blogs? I don&#39;t think it&#39;s that desirable to mess the product and order data with blog data? Maybe it makes sense to give users the option to use a different database. Just one thought.

I have NO PLANS to make any such change for the reasons stated above..

[landron]

How does one set this up for wordpress and Zencart to share a database? Zencart is in my root and wordpress is installed in a subdirectory. Do I need to reinstall wordpress in a different manner?

[DivaVocals]

How does one set this up for wordpress and Zencart to share a database? Zencart is in my root and wordpress is installed in a subdirectory. Do I need to reinstall wordpress in a different manner?

It's pretty simple.. 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 use the SAME database information for both. (DB name, DB Password, DB Username) You also need to make sure you are using a DB prefix for BOTH installs. For Zen Cart you can use zen_ and for WordPress you would use wp_.

[landron]

OK, it sounds like I need to wipe-out and reinstall WP manually as it was installed with simplescripts and I never had the option of selecting or naming a database. My Zencart install is ver 1.51 and was a manual install about a year ago. Will the default database settings for this install conform to these rules? There's no way that I'd want to re-install Zencart now that the site is built and customized.

It's pretty simple.. 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 use the SAME database information for both. (DB name, DB Password, DB Username) You also need to make sure you are using a DB prefix for BOTH installs. For Zen Cart you can use zen_ and for WordPress you would use wp_.

[lat9]

The default Zen Cart database prefix is '' (i.e. none) and the default WordPress prefix is 'wp_'. As long as the prefixes are different, you should be good-to-go!

[DivaVocals]

OK, it sounds like I need to wipe-out and reinstall WP manually as it was installed with simplescripts and I never had the option of selecting or naming a database. My Zencart install is ver 1.51 and was a manual install about a year ago. Will the default database settings for this install conform to these rules? There's no way that I'd want to re-install Zencart now that the site is built and customized.

During the WordPress install, when you are asked for your database information, you use the SAME database information that you used for Zen Cart (DB name, DB Password, DB Username). Set the table prefix to wp_.

[DivaVocals]

The default Zen Cart database prefix is '' (i.e. none) and the default WordPress prefix is 'wp_'. As long as the prefixes are different, you should be good-to-go!

Because there are still a few errant WordPress plugins which do not inheirit/use the wp_ table prefix, I ALWAYS include a table prefix in all of my Zen Cart installs to be SUPER SURE that the two are distinguishable.. I do realize that this is simply me being SUPER PARANOID..

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, 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..