OsCommerce Data Importer - Errors

[igrossiter]

i'm sorry, i have removed zencart, going to install all over again, soon i'll post here again.
Thank you and sorry for the inconvenience

[igrossiter]

it's ok now! skip, you can see through that link http://www.casasnossasenhoradosprazeres.com/loja/

Thank you

[enricoweb]

I have the same problem locally.
Display only the number of products and categories and is not clickable.
No errors are reported during import.
I checked and there are all the categories and products but id language is different.
I changed the language but id does not work.
In the backend, however, do not categories and products.
Maybe it's because you can create oscommerce subcategories and products together?
Help is blocked.
Thanks in advance for your reply and sorry for my English.

Enrico

[skipwater]

I have the same problem locally.
Display only the number of products and categories and is not clickable.
No errors are reported during import.
I checked and there are all the categories and products but id language is different.
I changed the language but id does not work.
In the backend, however, do not categories and products.
Maybe it's because you can create oscommerce subcategories and products together?
Help is blocked.
Thanks in advance for your reply and sorry for my English.

Enrico

Enrico

The script will not convert(change) the data's values.
You have language_id set to 4 in your osc data base as seen in your screen shot of categories_description. And in your new zen cart language table you have your Italiano language_id set to 1 as seen in your screen shot of languages.

You need to set the language_id in the language table to match your products language_id values.

So try and set your language_id in the language table to 4.

Skip

[enricoweb]

Hi skipwater

I changed the language id and now, after restarting mysql, categories and products I see in the backend.
Remains the problem that the frontend does not see it.
Has not changed anything from the picture I sent you.
What could be the problem?

Thanks in advance

Enrico

[skipwater]

Hi skipwater

I changed the language id and now, after restarting mysql, categories and products I see in the backend.
Remains the problem that the frontend does not see it.
Has not changed anything from the picture I sent you.
What could be the problem?

Thanks in advance

Enrico

In the admin are all the Categories / Products showing?

All your languages files are in /includes/languages/Italian

Are the Category set to active?

Are the Products set to active?

Check that your Admin and Catalog are using the same database:
/includes/configure.php
/admin/includes/configure.php

Skip

[1kell]

Transfer of customer database is done - but no customers were transferred. I ran the script and it said it was done and it transferred "0" of everything. It didn't report any errors with username etc. I uploaded my files to my top directory, but my shopping carts are not in the top. This is what I mean:

mywebsite.com (where I uploaded the transfer files)
mywebsite.com/osc (old shopping cart)
mywebsite.com/estore (new zencart)

Is the problem with where the transfer files are sitting? Or does something else usually cause this? Here is my site here.

[1kell]

the only funny thing i see is there is a table prefix for the old shopping cart, but none for zencart. If that would affect things???

[skipwater]

the only funny thing i see is there is a table prefix for the old shopping cart, but none for zencart. If that would affect things???

The location of osc to zen scripts only need to be on a url that can access both the original osc database and your new zen database.

Backup both your databases, OsCommerce and ZenCart.

Edit import_osc_configure.php with the correct mysql server, database name, user, password information, table prefix (if any) and MYSQL Character Set code if needed.

Note:
The variables are set in one section for osc database (source) and the second set of variables are set for the zen database (target).

If your osc uses a table prefix enter it in $source_db_table_prefix = ''; variable.

[suekay]

Hi,

I've imported everything and everything is working fine apart from some of the products that were disabled in OSC and then I subsequently deleted in ZEN are still showing in the "New Products For May" section, when I click the link obviously the product cannot be found. Can someone show me how to delete from where in the database?

Thanks
Suekay