Results 1 to 8 of 8
  1. #1
    Join Date
    Sep 2009
    Posts
    35
    Plugin Contributions
    0

    Default import sql from an old site without migrating the layout settings

    Hi guys.

    I am trying to import a sql file from an old Zencart site to a new instance of ZenCart. I would like to just import the products and not the layout settings from the old site.

    We currently are building two other websites which will carry the same products, however the layouts will be different and each time we import the entire ZenCart database the layout gets mangled.

    I am just wondering if anyone can tell me which tables in MySQL are responsible for the products and not the layouts so that perhaps I can just import those ones.

    Thanks!

  2. #2
    Join Date
    Jun 2005
    Location
    Hertfordshire, UK
    Posts
    10,216
    Plugin Contributions
    3

    Default Re: import sql from an old site without migrating the layout settings

    Are you wanting to import any other data, such as customers, addresses, order history, attributes... ?

    Specify exactly what product data you want.
    We host with Terranetwork.

  3. #3
    Join Date
    Sep 2009
    Posts
    35
    Plugin Contributions
    0

    Default Re: import sql from an old site without migrating the layout settings

    Nothing other than the product info, description, images.. no customer data or anything like that.

    This is a brand new store, it only shares the same products as the existing zen cart instance.

  4. #4
    Join Date
    Jun 2005
    Location
    Hertfordshire, UK
    Posts
    10,216
    Plugin Contributions
    3

    Default Re: import sql from an old site without migrating the layout settings

    My tables are prefixed with zen_ but if your's aren't, then ignore the zen_ part below

    zen_categories
    zen_categories_description

    zen_products
    zen_products_attributes
    zen_products_attributes_download
    zen_products_description
    zen_products_discount_quantity
    zen_products_notifications
    zen_products_options
    zen_products_options_types
    zen_products_options_values
    zen_products_options_values_to_products_options
    zen_products_to_categories
    zen_product_music_extra
    zen_product_types
    zen_product_types_to_category
    zen_product_type_layout

    Use phpMyAdmin to export these tables as a SQL dump

    I trust you know how to insert the data into the other database?

    I'd backup first... of course!
    We host with Terranetwork.

  5. #5
    Join Date
    Jun 2005
    Location
    Hertfordshire, UK
    Posts
    10,216
    Plugin Contributions
    3

    Default Re: import sql from an old site without migrating the layout settings

    Depending on whether you have meta tags set up for categories and products, you may also use the following:

    zen_meta_tags_categories_description
    zen_meta_tags_products_description
    We host with Terranetwork.

  6. #6
    Join Date
    Sep 2009
    Posts
    35
    Plugin Contributions
    0

    Default Re: import sql from an old site without migrating the layout settings

    yeah i know how to import data into the new databases.

    Now I'm just gonna export the tables you listed from the old db and try importing them into the new site and see what's gonna happen.

    Thanks for the help.

  7. #7
    Join Date
    Jun 2005
    Location
    Hertfordshire, UK
    Posts
    10,216
    Plugin Contributions
    3

    Default Re: import sql from an old site without migrating the layout settings

    You can also use Easy Populate 1.2.5.4 for exporting and importing data.
    We host with Terranetwork.

  8. #8
    Join Date
    Sep 2009
    Posts
    35
    Plugin Contributions
    0

    Default Re: import sql from an old site without migrating the layout settings

    I prefer the old school MySQL console..
    thanks for the help.

 

 

Similar Threads

  1. v151 can i salvage very old shipping settings from old database?
    By enddes in forum Upgrading to 1.5.x
    Replies: 4
    Last Post: 8 Oct 2012, 08:27 AM
  2. Migrating data from old site to new template
    By thebigkick in forum General Questions
    Replies: 2
    Last Post: 5 Jan 2012, 12:34 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR