New install but with some tables from 151

Hi
First , let me take my hat for the developers of 155.
just made a fresh install , and the installer, the admin and front page looks real nice.
Just miss some smacks architecture with scss, but generally speaking, the zen state it's probably a utopia.

But, my question is:

I'm not going to upgrade, I'll start from scratch , but I'm going to export / import, customers, orders.... not sure what else, but those tables that are really needed related to customers and orders...so the essencial stuff.
Then, modules, etc.. it's all fresh.... hum, and probably the ezpages info too.

So, considering this, do I need to do something special on this tables ? or they'll work nice on 155

Thanks

mesnitu, I think that your best approach is to update your entire database using zc_install's upgrade path. There are a whole lot of table interdependencies that will be taken care of using that script.

I was really trying to avoid that, to start has clean as possible. A lot of modules that the shop wont use anymore, others that will.
Not to speak the configuration and configuration groups tables.... finding out what is to remove vs not.
But, I'll try that upgrade tables process

Thanks

but I'm going to export / import, customers, orders
Orders are dependent upon having the products related tables in place,
customers are dependent upon so many tables to capture order history etc

If you want any of this, you really need to import your full database and upgrade it

In keeping with the best-practice of keeping the existing database, this is the procedure that I follow when upgrading most sites: http://www.zen-cart.com/entry.php?3-How-do-I-rebuild-my-site-on-the-new-version-instead-of-upgrading

Note also... Even though previous plugins were installed that modified the database in some way, if the code that accompanies a setting is not present, then modifying that setting doesn't affect anything. Ie, a setting that remains behind say in the configuration menu.

Also, there is a plugin (name escapes me at the moment) that reviews/evaluates your setup and identifies changes that have been made away from a default install. That information can help to "clean up" areas that are a possible nuissance or just database bloat. :)

Thanks.
Just to say that I didn't mentioned, but I would first import all related to products, categories ... but my simple plan was not to import the tables, but use EP4 to do it.
So all categories , special price, categories to products ( or the other way around ), product types, etc, etc... would be in place with products ID.
Then all related to customers and orders, that would catch the products id.
It was a nice simple plan.

Do I feel hope in the air ?

I have to look for that plugin, cause I more or less know the modules, but the idea on going through each one of them to see the uninstall !
Not to mention, that to see them... I actually must have all the files.... oh... I was struck by reality right now !

Using the existing database is still much easier. Importing the products with ep on a clean database does not guarantee you will end up with the same product id's. After which importing old orders and customers is moot.
My opinion is, it is much easier to clean up the obsolete mods from the database manually, using phpmyadmin.

mesnitu:

Thanks.
Just to say that I didn't mentioned, but I would first import all related to products, categories ... but my simple plan was not to import the tables, but use EP4 to do it.
So all categories , special price, categories to products ( or the other way around ), product types, etc, etc... would be in place with products ID.
Then all related to customers and orders, that would catch the products id.
It was a nice simple plan.

Do I feel hope in the air ?

I have to look for that plugin, cause I more or less know the modules, but the idea on going through each one of them to see the uninstall !
Not to mention, that to see them... I actually must have all the files.... oh... I was struck by reality right now !

No hope in the air no more :)
ok, thanks all !

Maybe this mod can help in the clean up. https://www.zen-cart.com/downloads.php?do=file&id=2039
I think this will also be added to the core in a future Zen Cart release.

mesnitu:

No hope in the air no more :)
ok, thanks all !

Design75:

Using the existing database is still much easier. Importing the products with ep on a clean database does not guarantee you will end up with the same product id's. After which importing old orders and customers is moot.
My opinion is, it is much easier to clean up the obsolete mods from the database manually, using phpmyadmin.

Agree with all not directly related to bold text above. EP4 now offers the ablity to import and export on products_id so it is possible to one-for-one establsh/re-establish product by their products_id. But the upgrade process remains the preferred and suggested method.

Design75:

Using the existing database is still much easier. Importing the products with ep on a clean database does not guarantee you will end up with the same product id's. After which importing old orders and customers is moot.
My opinion is, it is much easier to clean up the obsolete mods from the database manually, using phpmyadmin.

Agree with all not directly related to bold text above. EP4 now offers the ablity to import and export on products_id so it is possible to one-for-one establsh/re-establish product by their products_id. But the upgrade process remains the preferred and suggested method.

ok
So, I had to try it right ?

In this case, I really don't want no modules, no files that I don't even remember, ( just the translations and not all of it ) and I'll work all over again in the store configs and taxes, new template and template configs, etc.. or even try to add some more stuff, like zones, countries, etc...

Had a litle situation, cause in the online shop, the products ID started at 5. So uploading the products only with EP4 woudn't work.
Just imported the data from products table, ( just inserted, didn't drop or create ), and with those IDs in place, with EP4, it populated all the rest.
Then imported the customers, orders, addressees, etc.
And I've been comparing both of the "shops" , and until now, they look the same on orders, products pruchase, viewed , etc...
So hope to the world !

Of course, I should stress this out, that this is related to this particular situation, where I really want to install modules from scratch, cause today I have a better understanding what the shop needs and what I can do.

I might be partying before time, but for a while that I've been "walking" around, and all looks good.

Just imported the data from products table,
What about categories, categories_description,customers_basket, customers_basket_attributes, customers_info, orders_products, orders_products_attributes, orders_status, orders_status_history, orders_total, products_attributes, products_description, products_options, products_options_types, products_options_values, products_options_values_to_products_options, products_to_categories.

allow me to re-iterate when everyone has previously said, all data is good... doing the database upgrade, even if you have extra records, fields, files and the like will still work fine on a fresh code install...

the db upgrade will put your data ready to use for v1.5.5 and i'm of the opinion that it will be easier to delete what data you do not need (hardly seems worth the effort); then trying to figure out what the heck you missed or what index is not matching to another index on another table.

frankly, if you feel you have a better understanding of ZC, then it would behoove you to more focus on the code of the plugins and keeping as much of that separate from the core. just my 2 cents.

good luck!

All there. ( what I need )

But again, this was for this situation, where no attribute or products options. Never work with attributes and options. But I don't see how ep4 can ignore a products id.

Categories, manufactures description: the shop doesn't have them, if it did, EP4 doesn't take care of them.

 if you feel you have a better understanding of ZC

No

mesnitu:

All there. ( what I need )

But again, this was for this situation, where no attribute or products options. Never work with attributes and options. But I don't see how ep4 can ignore a products id.

Categories, manufactures description: the shop doesn't have them, if it did, EP4 doesn't take care of them.

if you feel you have a better understanding of ZC

> 
> No

Default EP4 operation as explained in the instructions uses the products_model as the primary key for import/export. This means that products_id doesn't mean anything to EP4. There is a setting in the configuration menu though that allows/offers import AND export to be by products_id... This setting though allows more direct access to the database and from a spreadsheet perspective ("tool" for EP4) this can be easily/accidentally changed. So it is my recommendation to use this option wisely and as needed for a specific situation/type of use...

Category information is covered by a separate import "file". Specifically because category data is in a table set of it's own and not directly related to a product but can contain many products or other categories...