Forums / Setting Up Categories, Products, Attributes / Copy categories / products to new zencart website

Copy categories / products to new zencart website

Locked

Views: 4,178

Results 1 to 10 of 10
This thread is locked. New replies are disabled.
18 Apr 2008, 4:24 AM
#1
level5 avatar

level5

New Zenner

Join Date:
Apr 2008
Posts:
7
Plugin Contributions:
0

Copy categories / products to new zencart website

:wacko: How can i copy whole products and categories from the broken old zencart website to brand new design zencart website? istead of i have to recreate whole thing..

Hope hear from you guys soon thanks...:frusty:

Nick

18 Apr 2008, 5:32 PM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Copy categories / products to new zencart website

If the design is broken ... you just need a new template ...

If the data is broken ... then that is a more difficult fix ...

Can you be more specific on your actual problem on what is broken? :smile:

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

19 Apr 2008, 8:14 PM
#3
level5 avatar

level5

New Zenner

Join Date:
Apr 2008
Posts:
7
Plugin Contributions:
0

Re: Copy categories / products to new zencart website

you can see simple error like space letters as HEADER_TITLE_CATALOG, BUTTON_GOTO_PROD_DETAILS_ALT and some.. its minor issue and things its only simple issues so how can i got it fixed???..

check it
http://allstarwholesales.com/store/

20 Apr 2008, 12:35 AM
#4
kuroi avatar

kuroi

Totally Zenned

Join Date:
Apr 2006
Location:
London, UK
Posts:
10,475
Plugin Contributions:
11

Re: Copy categories / products to new zencart website

This looks like you are missing some critical language files. This shouldn't affect your database in any way, and as Ajeh suggests, this is more about correcting your template than going through the pain of transferring your data into a new install and then applying the same faulty template.

Is your site spposed to be in English, or another language. If it's another language - which one and where did you get your language pack.

Kuroi Web Design and Development | Twitter

(Questions answered in the forum only - so that any forum member can benefit - not by personal message)

20 Apr 2008, 10:16 AM
#5
getcdkey avatar

getcdkey

New Zenner

Join Date:
Apr 2008
Posts:
4
Plugin Contributions:
0

Re: Copy categories / products to new zencart website

YOu can export the data with good zen website.
and import the data to old version.
Then it will works fine

21 Apr 2008, 6:55 PM
#6
level5 avatar

level5

New Zenner

Join Date:
Apr 2008
Posts:
7
Plugin Contributions:
0

Re: Copy categories / products to new zencart website

getcdkey:

YOu can export the data with good zen website.
and import the data to old version.
Then it will works fine

I tried to backup and reload to other database.. it dont even work im confused.. im so used with cpanel not 1 and 1 hosting company with their limited system

im really fueled cause im been trying figure out.. so anybody can help ?

import error was

"Error

SQL query:

{ \ rtf1 \ ansi \ ansicpg1252 \ cocoartf949 \ cocoasubrtf270{ \ fonttbl \ f0 \ fswiss \ fcharset0 Helvetica

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{\rtf1\ansi\ansicpg1252\cocoartf949\cocoasubrtf270
{\fonttbl\f0\fswiss\fcharset0' at line 1 "

26 Apr 2008, 2:38 AM
#7
zodc avatar

zodc

New Zenner

Join Date:
Apr 2008
Posts:
2
Plugin Contributions:
0

Re: Copy categories / products to new zencart website

SQL syntax means your code is written incorrectly. Sometimes it could be simple like missing quote or bracket.

26 Apr 2008, 11:25 AM
#8
kuroi avatar

kuroi

Totally Zenned

Join Date:
Apr 2006
Location:
London, UK
Posts:
10,475
Plugin Contributions:
11

Re: Copy categories / products to new zencart website

level5:

I tried to backup and reload to other database.. it dont even work im confused.. im so used with cpanel not 1 and 1 hosting company with their limited system

im really fueled cause im been trying figure out.. so anybody can help ?Unfortunately all we can see is that you have somehow attempted to execute as SQL something that isn't. Could you tell us more about how you made your backup and how you are trying to restore it?

Kuroi Web Design and Development | Twitter

(Questions answered in the forum only - so that any forum member can benefit - not by personal message)

29 Aug 2009, 5:50 AM
#9
rlexyd avatar

rlexyd

Zen Follower

Join Date:
Nov 2006
Location:
Sydney, Australia
Posts:
475
Plugin Contributions:
0

Re: Copy categories / products to new zencart website

Hi,
I want to copy my current Products/Photos and Categories to my new zen-cart website from an old zen-cart website both version 1.3.8.

How do I do that?

I do not want to list all my products again one by one on the new website.
I have changed a few things from the old to the new website that I don't want to copy the whole website, just the products, images and categories!

I am not an expert on zen-cart but I have an understanding of the basics and can follow what you tell me very well!

Awaiting your guidance.

Best Regards,
rlexyd

*Zen Cart eCommerce Solution - Putting the Dream of Owning an Online Business within reach of anyone!

29 Nov 2009, 1:05 PM
#10
jayzilla avatar

jayzilla

New Zenner

Join Date:
Feb 2009
Posts:
11
Plugin Contributions:
0

Re: Copy categories / products to new zencart website

level5:

I tried to backup and reload to other database.. it dont even work im confused.. im so used with cpanel not 1 and 1 hosting company with their limited system

im really fueled cause im been trying figure out.. so anybody can help ?

import error was

"Error

SQL query:

{ \ rtf1 \ ansi \ ansicpg1252 \ cocoartf949 \ cocoasubrtf270{ \ fonttbl \ f0 \ fswiss \ fcharset0 Helvetica

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{\rtf1\ansi\ansicpg1252\cocoartf949\cocoasubrtf270
{\fonttbl\f0\fswiss\fcharset0' at line 1 "

-----------JAYZILLA----------------
I had built a site using 1 and 1 hosting and their server got infected with a virus and it wrote encrypted php code to the top of every page in the site and killed it. I painstakingly removed them ALL! I uploaded the site after it was all fixed and with in an hour the same thing happened again.. I tried to talk to 1 and 1 and they just told me they don't do tech support for when things screw your site up from their servers not being secure. So long story short I had to move to a godaddy account because I knew it was safe and wasn't going to loose days of work again because of some hack with a pc in his basement calling himself a hosting company lol... Besides godaddy is really good about backing things up everyday and so you can always roll back any changes to html files and if you tell it to your database can do the same, you have to set it up though :) Probably not a bad idea if it's a live site ;)