404 error in admin after product import

[Scott_C]

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/.php?page=1&product_type=0&cPath=84&pID=309&action=new_product

Thanks,

Scott.

[Scott_C]

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.

[DrByte]

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.

[Scott_C]

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

Ill have another look at it.

[Scott_C]

Holy crap that ONE missing value made all the difference!

Thanks DrByte! I owe you another donut!

[DrByte]

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.

[Scott_C]

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

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

[DrByte]

http://www.zen-cart.com/wiki/index.p...ers_-_Database

[Scott_C]

Thanks

[Scott_C]

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