Data Migration Nightmare/ SQL and Easy Populate

[buddhaflow]

Hi everyone,

I need to copy my whole product inventory over to another ZC site.

One stumbling block might be that the first site is 1.3.8.1, the second is 1.3.8.1.sp1 (both installed with SimpleScripts, that might be part of the problem.)

I have just tried everything I can think of to do this. I have more than 1000 products, so doing it by hand is not practical. First, I copied the /images/ directory.

1) phpMyAdmin Export all relevant product tables to SQL, rename tables (1.3.8.1.sp1 adds "zen_" before every table name, hand check every table definition to make sure it's the same, import to the new ZC database.

Result: I see NO functioning categories, only a category with no name and all 1100 of the products. When I click on this blank category, no products show up.

2) I install easy populate 1.2.5.5 CSV, the same version that I have had on my first site. Export to CSV from my first site, import into the second site.

Result: Only one new category is added. It has one less than the expected number of parts. When I click on this category, it says there are no products to show.

When I do an easy populate export from the second site, it shows the full database, everything looks good. But things just refuse to show up in the "categories" list.

Can anyone shed some light on the situation? I am going crazy. It's a time sensitive thing, and I just can't get this data to migrate properly. What am I doing wrong? Do I have to just start over?

Thank you,
Sasha Shepherd
HyosungSource.com

[mprough]

Easy populate is ok, but your first thought was best IMO.

You likely missed the category related tables when you exported. There are quite a few tables to export.

I would drop the existing imported tables and re-import the following tables.

categories
categories_description
manufacturers
manufacturers_info
meta_tags_products_description
products
products_attributes
products_attributes_download
products_description
products_discount_quantity
products_options
products_options_values
products_options_values_to_products_options
products_to_categories
product_types_to_category

Just the basic, if using special product types or media you will need those as well.

Then to change the prefixes something like below for each

ALTER TABLE categories RENAME TO zen_categories;

~Melanie

[buddhaflow]

Thank you. I did finally get it to work, using EP...not sure why it ended up working in the end. This Zen Cart is a bit of an alchemy ;)

I DID do every single product table on the first step, using the "Database Schema" page. I still don't know why it didn't work, it sures seems like it ought to have. Oh well! Thank you for taking the time to read my long question :)