Copy products from one zencart to another

Hi ppl!

What do i need to copy from one zencart to another if i want to copy all products? What db tables? What files?

I had already copied img files and few tables (_categories, _categories_description, _manufacturers, _products, _producs_description, _products_to_categories) but it still won't work as it should.

Both zencarts are 1.3.7 version.

tia

Looks like your missing the manufacturers_info table. You might want to take a look at this wiki entry.

Other than that it's difficult to comment without knowing more specifically "won't work as it should" means.

U R 100% right.

"won't work as it should" means:

• in front page I get "-> (158)" where categories list should be
• in admin panel i get empty category list and no products at all while in the phpmyadmin i can see them all in _category table.

I did a copy of _manufacturers_info as well no and still no reaction.

Are you sure that the categories_description copy worked. Also how did you copy the tables? Is it possible that the categories_id column may have gotten out of sync between the categories and the categories_description tables?

omg I had terrible problems with internet connection :/ I was trying to write more but I couldn't :/ I checked all tables few times, they are fine.

But the problem can be somewhere else.

I'm trying to copy products from single language (polish) zencart to zencart tjat uses 3 languages (english, polish and russian). I had already try to deactivate english and russian in second zencart but it still did not worked.

Why can't you copy the entire database instead of trying to pick and choose what tables you're copying? Do you want to avoid duplicating customer information? How are you attempting to copy the information?

Of course I can try to copy entire database, just I was hoping to do it in a nice way :) more over it will take to much to customize everything from the very beginning and it has to work tommorow :/

What did you copy those tables into? Was it a clear install of Zen Cart?

it wasnt a clear installation of zen cart.

I do realize that I should write about every changes there were made in the past but its impossible now.

How did I copy tables? I did use php my admin to export each table, drop the table that i did want to reapleace and import option for each of them. It looked to be the easiest and fastes way to do this.

I guess I will have to try figure out some sollution really fast :)

tnx for helping

Unfortunately, everything that you've described and your methodology should work. At Kuroi, we do this sort of thing regularly without problems, in a very similar way to how you've done it.

The only thing we haven't discussed, is whether you have options on any of your products, in which case your table list would be incomplete.

OK, ids doesn't matter for now. I decided to copy entire database and make necessary changes.

But in future I will try to find out what was wrong. Maybe some other ppl will have similar problems.

Maybe it will tell you sth if I will write that the database I was trying to copy was from https://www.kobast.pl. Maybe there is something already installed that I have to copy with tables as well. Maybe Image Handler 2 ? But it seems to be out of suspicions.

my ability to reply in a more appropriate category seems to be blocked so i am using this one instead.

i need to copy (not link) 28 (this number will be increasing dramatically in the future so it will become even more critical) products to 3 other categories. i need to change only the model number in the different categories. i have a painfully slow satellite connection and it would take hours to do this.

i know that the best way to do it (short of an addon that i can not find) is to edit the SQL. i use PHPmyAdmin to export and import the SQL as i do not have tools to deal with the SQL directly. there are some strange things that need to be considered using excel to edit the exported data and import it and still have it work because of all the strange stuff that excel does but i have figured out how to do this in most cases.

i do not have attributes for the products, do have images, descriptions and that is about all. what tables do i need to work with to copy these products?

is there a recommended tool that will allow me to edit the SQL directly in a friendly way? i need to be able to copy entries and do replace on keys in selected multiple entries.

You should be able to use the copy feature already present in Zen Cart to copy the products to the "new" category. Once the copy is complete, you will automatically be in the "new" category with the "new" products. You should then be able to edit them as necessary. I know you said your connection is slow, but by the time you try to figure out what tables to copy and what to change, you could probably be done with the copying.

not only do i need to do this right now with 28 products to 3 other categories but i will be needing to do many more in the future. it would take me about 3 hours (satellite is unbelievably slow) to do this cloning and it would be impossible to maintain this sort of product as i change it.

there is no way to copy many products at once but there is easy populate with which i have been experimenting. i backed up my entire SQL (and checked to make sure that restore really works) and then started hacking away at things with easy populate. it does everything i want and more. i had been writing scripts to correct the garbage that excel makes of various exports using PHPmyAdmin and every cases seemed to need different treatment because my product descriptions contain lots of "s \s and ,s.
http://www.zen-cart.com/forum/images/smilies/clap.gif
:clap:
easy populate works perfectly and i don't have to worry about text qualifiers field delimiters etc that match what excel wants. i could never get some of my SQL data to even show up in some exported CSV files.

i had even screwed up a whole set of 4659 products and had them restored in a matter of minutes.

easy populate is exactly what i need. it was wondering how i would merge another 1000 products that needed to be in a particular sort order without having to write another 5 or so perl scripts to deal with what excel messes up. tonight's experiment has shown that easy populate is all i need.

thank you so much to whoever wrote this . it will save me countless hours of work. i was thinking that the only option was to install mySQL and a web server locally on my computer to be able to edit the SQL locally. with a satellite connection you can not do multiple queries to a remote database in any reasonable time. it takes 2 seconds to say hello to the satellite and get a reply. this times 18,000 amounts to a lot of time. the satellite is fine for large files but the latencykills you with multiple requests.:clap: