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.

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

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.

:clap:

Nick

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! :)

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! :)

Something is wrong with the install I get a product list with this link http://www.rainbowstitchery.com/testzen/index.php?main_page=index&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

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!

skipwater:

Something is wrong with the install I get a product list with this link http://www.rainbowstitchery.com/testzen/index.php?main_page=index&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

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! :)

Yes now it looks like Zen Cart default install.

Skip

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. :(

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. :(
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

The OSC version is 2.2MS2

skipwater:

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

If someone need script for migration from Oscommerce to ZenCart, Opencart to Zencart, CreLoaded to Zencart and VirtueMart to Zencart can write me an email using my site Contact form

I've done a succesful import, great script!

If I import again. with the latest OSC database (my OSC shop is still 'live') will it just overwrite the existing zen-cart database?

I've imported an older version of the OSC DB so that I can tinker and get it all working. Once I'm done, I would like to upload the lastest OSC database so that I can go live with zen-cart. So I'd like to know if I can just import again, to basically update the database to the latest?

Thanks a lot!

ttfan:

I've done a succesful import, great script!

If I import again. with the latest OSC database (my OSC shop is still 'live') will it just overwrite the existing zen-cart database?

I've imported an older version of the OSC DB so that I can tinker and get it all working. Once I'm done, I would like to upload the lastest OSC database so that I can go live with zen-cart. So I'd like to know if I can just import again, to basically update the database to the latest?

Thanks a lot!

YES it will overwrite the old data.

Skip

Beautiful, thank you very much!!!

Hey Skip,

Used your import script and it worked great. One issue: I have two OSC sites/databases that I want to transfer over. I transferred one, then tried the other, and it overwrote the first transfer. I went back and did the first, bigger database import again. Is there any way to transfer a second one over without overwriting my zencart database?

THanks,
Lindsay

lwest:

Hey Skip,

Used your import script and it worked great. One issue: I have two OSC sites/databases that I want to transfer over. I transferred one, then tried the other, and it overwrote the first transfer. I went back and did the first, bigger database import again. Is there any way to transfer a second one over without overwriting my zencart database?

THanks,
Lindsay

NO OSC Importer can not append data into a database.

What you will need to do is create 2 ZC databases.
Transfer the OSC data to one each new ZC database and the use phpMyAdmin or similar to append the data into one ZC database.
Note: You will need to check that there are no dupes of customer numbers and other types of record numbers.

Skip

This is a great contribution. I had an easy time installing and running it. I am very happy to say goodbye to OsCommerce and hello to ZenCart. Thank you Skip, you are awesome for sharing this.

One area where I did notice a problem was the prices for my products. All the prices for the imported products are $0.00.

In my old OsCommerce shop, the products all have quantity discount pricing, which I was hoping would import but did not. Is there something I can do to at least import the main product prices, and possible even the quantity discounts?

One area where I did notice a problem was the prices for my products. All the prices for the imported products are $0.00.

Is there money values in your osc database in table products, field products_price?

Skip

skipwater:

Is there money values in your osc database in table products, field products_price?

Skip

Hi Skip :smile:

Here's a screenshot that probably will make more sense to you than anything I could type. I'm not a wizard with sql stuff.

It's very possible that the OsCommerce software was modified, so maybe the database structure was altered. Sorry to say I inherited it this way and it's taken a lot of digging just to get to this point.

If the database has been changed, is it maybe just a matter of renaming some values in your php files to draw the imported data from a different part of the table?

True the osc has been modified. There is no product_price table in osc.

Did they remove the table products?

If not is there any info in the table?

Next you have:
12 pieces (15% off) $122.40 is the 15% off 122.40 or 122.40 already is 15% off?

Skip