OsCommerce Data Importer - Errors

[skipwater]

Thank you for responding :)

Right, the customer data is currently still live and being used in the OSc shop, I just coppied the database to a test server to work on.

Where a customer has 2 address' logged, I can click the link and it will display all of the correct data, both addresses etc etc listed.

Clicking the customer data from the list once does nothing, the space below the edit button stays blank. With a new customer, not one imported, it does show the info correctly.

After selecting a imported customer and clicking edit, I get taken to the edit page but all of the fields are blank.

What I can see is that if I hover over the edit button the part which says "zen/storeadmin/customers.php?page=1&cID=&action=edit" seems to be missing the actual ID number. If I manually edit that url and add in a number for the cID=1234 it works fine.

This is a fresh install of Zen, I think it was 1.3.8 which I have upgraded in the last couple of weeks to 1.3.9a and now 1.3.9b.

From my web hosting I can see: PHP version 5.2.11, and it's a Linux shared hosting package I believe.

OK Found your problem:

In the address_book table field entry_country_id you have ID's that are not the real zen cart country codes.

Example:
In your OSC address_book table, field entry_country_id GB = 245
In ZEN countries table field countries_id GB = 222

And at the same time ZEN country codes only go to 240 so any country > 240 the record will fail.

To fix you need to change all the entry_country_id values in address_book table, field entry_country_id

US from 244 to 223
GB from 245 to 222

They are the ones that I know there are others.

I think that your osc data base is a very old version because the newer versions match zen cart data base.

Hope that helps

Skip

[NemesisNG]

Certainly was the problem!

I've ended up removing all the data in the countries table from the Zen install and importing all the data from the OSc install to make it all tie in for every customers address book.

All sorted and moving onto the template work to get my store moved over to Zen.



Nick

[laurelsstitchery]

I'm using ZenCart version 1.3.9d - a one-click install from Dreamhost - a fresh install, not upgraded
I have no addons installed yet and the site isn't customized at all

My problem is I've used the OSC Data Importer which worked perfectly. I can see all my items in ZC admin, but when I click a category link on my store site, no items load.

Here's the store link: http://rainbowstitchery.com/testzen/

This is just a test site, but my normal site is down due to a botched server move by the webhost, so I'd like to get this up and running ASAP. Any help you could provide would be gratefully accepted. Thanks! :)

[skipwater]

I'm using ZenCart version 1.3.9d - a one-click install from Dreamhost - a fresh install, not upgraded
I have no addons installed yet and the site isn't customized at all

My problem is I've used the OSC Data Importer which worked perfectly. I can see all my items in ZC admin, but when I click a category link on my store site, no items load.

Here's the store link: http://rainbowstitchery.com/testzen/

This is just a test site, but my normal site is down due to a botched server move by the webhost, so I'd like to get this up and running ASAP. Any help you could provide would be gratefully accepted. Thanks! :)

Something is wrong with the install I get a product list with this link http://www.rainbowstitchery.com/test...ndex&cPath=679 sometimes. And your main page is not loading correctly.

I think you should try a new install with out using one-click install from Dreamhost.

And none of your images are showing up. Did you upload them to the correct folders?

Skip

[laurelsstitchery]

Ok I will reinstall. I didn't bother copying the images over yet because I wanted to make sure I could make it work before I went to all that trouble. My database has >17000 items, so it's quite a job to copy all of them. Anyway, I'll reinstall and try again to see what happens. Thanks!

Something is wrong with the install I get a product list with this link http://www.rainbowstitchery.com/test...ndex&cPath=679 sometimes. And your main page is not loading correctly.

I think you should try a new install with out using one-click install from Dreamhost.

And none of your images are showing up. Did you upload them to the correct folders?

Skip

[laurelsstitchery]

OK I've reinstalled the software here: http://rainbowstitchery.com/catalog/

If you could give that a quick look just to make sure it looks like it should, I would appreciate it. When I hear back, I'll go ahead and do the data import again. Thanks so much for your help! :)

[skipwater]

Yes now it looks like Zen Cart default install.

Skip

[laurelsstitchery]

I only did the products import and the site is now doing the same thing. I chose products status as approved and did not import specials. I have the results of the import if you need to see that. I don't understand what I'm doing wrong.

[skipwater]

I only did the products import and the site is now doing the same thing. I chose products status as approved and did not import specials. I have the results of the import if you need to see that. I don't understand what I'm doing wrong.

It seems a post of mine went to never never land. So try again.

What version OSC are you coming from?

From what I can see there is bad data in your import. By what I can tell it almost looks like a zen to zen transfer (which this mod can not do).

Skip

[laurelsstitchery]

The OSC version is 2.2MS2

It seems a post of mine went to never never land. So try again.

What version OSC are you coming from?

From what I can see there is bad data in your import. By what I can tell it almost looks like a zen to zen transfer (which this mod can not do).

Skip