Fresh install but old data

[hamid84]

Hi,

I am on mission today and i have decided to do a fresh install of Zencart after getting so many issues with current setup.

Biggest problem is customers can not create an account easily. Whenever they try, nothing happens and fields become blank.

In new new installation, all I want is Customers, their orders, address book.

I then plan to install only a few modules that i need coz at the moment i have so much crap.

What is the best way to complete this mission? I have made a list of database files.

Also my db is in this format gjh6_orders. In new install, would i get the same prefix ( gjh6 ) or i would have to change that manually?

A small guide will help me to complete this job with peace of mind.

Thanks

[kobra]

Suggest that you follow the upgrade steps and not try to pick & choose

https://www.zen-cart.com/tutorials/index.php?article=98

[hamid84]

HI Kobra,

Trouble is there is much junk in db which i do not want in new site thats why i want to do a fresh install and import whatever i need.

Let me know if im making any sense.

[kobra]

thats why i want to do a fresh install and import whatever i need.

Because you are asking, it is apparent that you are not fully up to speed on the dependencies in the DB
If there are orders and products have attributes there are many tables inter-indexed to maintain the customer history
Leave something out and it can break things with mysql errors

there is much junk in db

Please elaborate on what you class as "junk"

[hamid84]

My Junk means modules that i have installed over the past 3 years and never used them.

There is so much mess and biggest issue is customers can not create account and due to that we have seen drop in sale.

[kobra]

My Junk means modules that i have installed over the past 3 years and never used them.

And you have a list of exactly what these are??
Need to ferret out which ones add tables, alter tables, have no DB interaction.

Those that only add tables - can drop those tables
Those that alter a table, must determine how to back out the alteration
Some well written mods have uninstall sql
Others are only files and will not be part of your new install

There is so much mess and biggest issue is customers can not create account and due to that we have seen drop in sale.

Correcting why an account cannot be created is a seperate issue and should be fixed first

[hamid84]

I have been playing with other test sites to make sure whatever action i take is right and finally managed to assign the same db prefix " gjh6" to the new database and then imported customers and address book which worked fine.

Only issue that system shows them as these customer registered for an account today. Can this date be changed to orginal one when they signed up?

Here is the list of tables i plan to export/import.

customers
address book
orders
customer_orders
order_products
order_status_history
order_status
orders_total
products_quantity_discount
customer_admin_notes
reviews
reviews_description

Please have a look and let me know this will be enough. All products have been saved using EP module.

Thanks Kobra

[kobra]

You continue to want to pick & choose, so you are on your own

Being that it is a test install no harm done but you most likely will experience additional issues

[hamid84]

Can i then leave everything under your capable softhands?

Pick n choose is the only way i can think of with fresh install without any modules.

Help please

[kobra]

Biggest problem is customers can not create an account easily. Whenever they try, nothing happens and fields become blank.

Fix this first
https://www.zen-cart.com/tutorials/index.php?article=82