Import data from old store to new store

[antonios]

Hi,
How do I import data (products, customers and orders) from a zencart 1.3.8a with addons to a zencart 1.3.8.a without all the addons?
Simply backing up db and copying it into the new store doesn't work 'cause the new store had only 95 tables, and the old one 105 (due to add ons and such).

I basically want all my customer, products and order data imported in a clean store.

Anyone have any tips on how to do so?

Greetz Antonio

[kobra]

You will also need all the files for all your addons in the correct places

[antonios]

That's just it.
I don't want the addons in the new store, because the addons are the reason the shop isn't working right. They cause bugs ot whatever.

So is there a way to just import the relevant data like products, customers and orders, from an old store with addons to a new store without the addons.

greetz antonio

[kobra]

You will need all the 95 standard tables - -
BUT it is the "configuration table that will trip you up as it will contain references to every addon
As you are asking the questions that you are, I would proceed cautiously or enlist one that has the knowledge to correctly make this change

For Future reference ALWAYS backup the DB before adding any module that impacts the DB

[schoolboy]

Can be done using phpMyAdmin, but you need to go back through your notes that you made when you installed all the extra add-ons...

(You did keep notes, didn't you? ... of course you did! How silly of me to even ask the question...)

Anyway... some add-ons may make changes to the dbase, others may not.

Any add-on that required a SQL patch will have made changes to the database.

If you have a record of all add-ons, you will only need to concentrate on those that make dbase changes.

First thing is to make a COPY of your database - because you will tinker with the COPY and not the original. You do this by creating a new empty database with full user permissions in your cPanel, and then using the OPERATIONS tab in your current database, COPY the database to the new one you just created.

Switch to the new database in phpMyAdmin.

From your notes (or the readme files in your add-ons, remove or update the tables/fields relating to the addons.)

Now, create a FULL CLONE of your shop's folders and files in a sub-directory (can be done quickly and easily in cPanel).

Then, point this "duplicate" shop at the new database by altering the configure.php files as necessary.

Because your software files still have all the addons, this duplicate store is likely to work badly - or not at all, so you must now unpick the php files that relate to unwanted modules.

If any of these files are CORE files, you will need to use a file comparison tool to remove exctra bits of php that these add-ons wrote into the files, and then you will need to determine how to remove or edit the added bits of code.

It's a long process, and is very finicky.... IF all the above is gibberish to you, consider hiring someone to do it for you...

[antonios]

thank you schoolboy for thinking with me.
I'll give it a try.

I've got plenty of time and webspace (host my own server) and I'm gonna need it so it seems.