export customer and sales data

[neit]

I have recently installed version 1.3.8a
to an online shop, then version 1.3.9a and 1.3.9b came out.

Rather then me go through the process of upgrading the cart to
version 1.3.9a I just installed a clean version of that then
did the upgrades to version 1.3.9b, I uploaded my template
and product data.

As the shop was only live for over a week it only has one user
and made one sale from version 1.3.8a.

I would like to transfer the customers data and order into the
fresh install of version 1.3.9b.

Could someone please point me in the direction of which
database tables I would need to export the data from.

I believe I may need to export the data from:

address_book
customers
customers_basket
customers_info
orders
orders_products
orders_status_history
orders_total

Thanks

[kobra]

Could someone please point me in the direction of which
database tables I would need to export the data from.

You insert the full DB from the previous version and run zc_install and upgrade the DB only

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

[neit]

I had to make some changes to the default database.
I needed to increase the number of characters for products name
and description for 13000 items.

If I run the the database upgrade will this reset these fields
to the lower character count and thus truncate the product names
and descriptions

[kobra]

If I run the the database upgrade will this reset these fields
to the lower character count and thus truncate the product names
and descriptions

That is why you ALWAYS backup befor doing these things

Try it and see

[neit]

Thankyou this did appear to work ok.

I have one query i have a fresh install of version 1.3.9b has only
93 tables where as version 1.3.8 and database upgrade has 95 tables should this make any difference.

[neit]

There seems to have been an issue with as It is no longer pulling entering the product_descriptions into the order which I had set it up yo do.

[neit]

Now I had everything working from a fresh install of 1.3.9b and I havehad to add an additional field to the orders table called
products_description but it did work. Now since the upgrade of the database the product description is not
showing on check out, order history or the admin section when I check an order.

[neit]

Having checked this again when I manually enter the description
into the products_description field I created orders_products
the admin side pulls out the description as expected.
The issue appears on the customer side when it does not
display the discription during checkout or enter into the database.

I'll have to dig a little deeper

[neit]

Resolved I did not amend the order.php in the store side of the script.
thanks
for the help

[Gamer]

I have basicly done the same thing.... But...

Due to PCI compliance, a non shared server was required.

Exported all of the old 1.3.7 data and upgraded it...

My issue is that Im doing everyting on a new server that won't go live untill I tell the host to switch over to the new server.


It's taken me a couple months to get everything setup the way I want.... So in that time I have gained a few customers on the old server and need to import those customers into the new server just before we go live.

My database is rather large thus I would like to know how to import just the customer & sales data.

My intention is to have a seamless transfer and reduce the down time while I move.