OsCommerce Data Importer - Errors

[NemesisNG]

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.

[skipwater]

Try looking at the zen cart mysql data base using myphpadmin or similar.

customers table (How many records)
customers_info table (How many records)

They should match record count.

Next address_book table (This should have > customer records)

The only thing that I can think of that might be causing this is bad data in a record. I think it would be in the customer_id field.

Skip

[NemesisNG]

Both the customers table and customers_info tables have 2,737 reccords in them.

The address_book table has 3,056 in it.

Not really sure where to go from here now...

Thanks

Nick

[NemesisNG]

I've tried it in IE and Firefox unless I was being stupid with the browser but it's the same. I've also tried it on the test server by backing up the OSc database and setting it back up on the test server and them importing it to Zen. I've now also tried it on the live server by setting up a fresh Zen instance and temporary database and importing to Zen directly from the live OSc database on the same server, in case something was going wrong with me moving it to a test server. But it's all still the same.

Nick

[skipwater]

Can you pm me with a sampling of the data so I can take a look at it. Because I can not duplicate your error.

Skip

[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