404 error in admin after product import

Hi, Ive written an SQL query to get my products from another mySQL databse and import them into zen cart.

The import is working, im getting all the products and Im also grabbing the product and category Ids from the old db.

In the backend, under catagories/products im seeing all the product categories and the products themselves.

When i click on a product to edit it though, Im getting a 404 'page not found' error. Does this have something to do with the fact that im importing my own product and category Ids? I noticed the url string when i click on a product drops the word 'product' out of 'product.php'

For example: admin**/.p**hp?page=1&product_type=0&cPath=84&pID=309&action=new_product

Thanks,

Scott.

p.s. It must be something to do my query as Im developing a friends store that is also migrating from the exact same old ecommerce software and Im getting the same error in the zc admin.

Can someone confirm if my trying to import IDs from another db (for both categories and products) is causing the error?

Thanks,

Scott.

Sounds like you're not setting all the data fields when importing. Namely, you're not setting the product_type field to a valid value.

Thanks DrByte, come to think of it my query doesnt include anything for product type. :blush:

Ill have another look at it.

Holy crap that ONE missing value made all the difference!

Thanks DrByte! I owe you another donut! :clap:

You'll likely also have problems with pricing if you don't set the products_price_sorter; and problems with products not showing in the right categories if you don't set the master_categories_id.
It's also prudent to go to Admin->Tools->Store Manager and run the Reset Products Price Sorter, and the Reset Master Categories IDs after doing those kinds of imports.

Thanks for that, im noticing some of the strange behaviour you mentioned.

At least Im on the right track now with the query.

http://www.zen-cart.com/wiki/index.php/Developers_-_Database

Thanks :smile:

I just have one more question;

Im dumping the price and tax id into zen cart as well. But the field in the products table; products_price - seems to be the net price field?

Is there a way for me to dump my product prices straight into the gross price field?

I cant seem to locate it in the db.

Thanks,

Scott

The gross price is calculated via the taxation module when tax is calculated based on customer shipping address or however you configure your taxation rules.

Ok, I thought something like that mightve been happening when i couldnt find it in the db. :)

Thanks.

Hi

I currently have a 404 page not found on both the admin and the store.

I had everything working really well and have been adding products via Easy populate without any problems. I had both the admin window and the store open and could see the most recent products I had added earlier today. I was uploading some images for these products and when I "refreshed" the page to show these, I could see that the images had added without any problem. I looked at all products and could see them ok.

HOWEVER, I tried to look at the specials page and it couldn't find it? I got a 404 error. The specials template page is still there are hasn't been touched.

Then the admin page disappeared - it was there one minute and gone the next. However, I cannot get into ANY pages now ... all showing a 404 error but I cannot see hoe adding images caused the problem. I was using Filezilla to move the images files.

Any ideas?

Thanks

Gillian

Hi

Must have been a problem with the hosting company (GoDaddy) as it is back now ...

Who knows ... the mysteries of the internet!

Gillian