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.