Merging Product Data from another store.

[SDImagine]

I have another store that has the product list I need. My theory is to extract the following db tables;

categories
categories_description
manufacturers
manufacturers_info
products
products_attributes
products_attributes_download
products_description
products_discount_quantity
products_notifications
products_options
products_options_types
products_options_values
products_options_values_to_products_options
products_to_categories
product_music_extra
product_types
product_types_to_category
product_type_layout
project_version
project_version_history

and inject them to the new site. Should work eh? From what I can see, the manufacturer tables will retain the manufacturer settings already specified on each product, categories will of course retain structure (which is a primary requirement.) Of course ALL the categories tables will provide me with all information.

I probably should of just copied the store and then modified it.

[frank18]

You may want to investigate Easy Populate - it could (?) do the trick for you. Although, I must admit that I am not too au fait with this mod.

[SDImagine]

You may want to investigate Easy Populate - it could (?) do the trick for you. Although, I must admit that I am not too au fait with this mod.

I was looking at it. I have extensive DB experience, I'm not new to Zencart and although this project was last minute; I'm scrambling on it. I don't generally do e-commerce solutions for my clients. It's more of a favor for a friend type of deal LOL.

From what I could gather in the quick code scan overs and db setup, it appears that those tables I listed are the keys to moving. I'll know for sure in the morning when I drag myself out of bed and get back to work. LOL.

[schoolboy]

Some of the tables are relational in terms of their associations - with the ID being the key.

You may also find this in the manufacturers table where the product ID is used to associate the products with a given manufacturer. I have not looked inside the DB, so can't say for sure - but it wouldn't surprise me of the product-to-manufacturer is just a list of the products' ID's and the manufacturers' ID's.

Easy Populate (1.2.5.4) works only with the categories and products tables - none of the others you mention.

While it IS possible to bring in data from other databases and their tables, you need to know what is related to what in ZC - and constructing the SQl to do the transferring of data can be finicky.

[SDImagine]

Worked like a charm! :)