Forums / Upgrading from 1.3.x to 1.3.9 / Importing products from 1.3.0 to 1.3.7 after upgrade?

Importing products from 1.3.0 to 1.3.7 after upgrade?

Locked

Started by lisk on 12 Jan 2007, 8:15 AM · Views: 1,899

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
12 Jan 2007, 8:15 AM
#1
lisk avatar

lisk

Zen Follower

Join Date:
Jun 2006
Posts:
118
Plugin Contributions:
0

Importing products from 1.3.0 to 1.3.7 after upgrade?

Hi - I had to do a clean install after my 1.3.0 site was hacked. I installed 1.3.7 and then followed the OSC --> Zen Cart instructions ( https://www.zen-cart.com/tutorials/index.php?article=10 ) to import the products from my old site to my new site. I didn't get any database errors, and importing seemed to work, but none of the products are showing up in my new store. I'm not sure what I did wrong.

Are there step by step instructions for exporting the products/categories from an older version of Zen cart to the latest version of Zen cart?

Thanks! :)

-Lis

12 Jan 2007, 1:03 PM
#2
merlinpa1969 avatar

merlinpa1969

Totally Zenned

Join Date:
Mar 2004
Posts:
13,031
Plugin Contributions:
4

Re: Importing products from 1.3.0 to 1.3.7 after upgrade?

did you import the categories and the categories to products tables?

Zen cart PCI compliant Hosting

13 Jan 2007, 3:41 AM
#3
lisk avatar

lisk

Zen Follower

Join Date:
Jun 2006
Posts:
118
Plugin Contributions:
0

Re: Importing products from 1.3.0 to 1.3.7 after upgrade?

I thought I had. I just tried to re-do it, and I'm running into an error. I exported the products table from my 1.3.0 database (and chose data and complete inserts and nothing else) and then tried to import it into my 1.3.7 database and I got this error:

SQL query:

-- phpMyAdmin SQL Dump
-- version 2.9.0.2
-- http://www.phpmyadmin.net

-- Host: localhost
-- Generation Time: Jan 12, 2007 at 09:22 PM
-- Server version: 4.1.21
-- PHP Version: 4.4.2

-- Database: liskidde_zc2

--
-- Dumping data for table zen_categories

INSERT INTO zen_categories ( categories_id , categories_image , parent_id , sort_order , date_added , last_modified , categories_status )
VALUES ( 3, 'catdicpen.jpg', 0, 2, '2006-05-29 14:35:32', '2006-10-20 01:59:52', 1 ) ;

MySQL said:

#1062 - Duplicate entry '3' for key 1

I'm sorry for all these dumb questions. :(