Bulk Import - Product Catalog Doesn't List Any

I setup a test install and my bulk import works and all products display in the Catalog, Categories/Products section of ZC as it should.

On the live site the bulk import worked, but none of the products will display in the Category section.

All of the products show up under New Products, but why it won't under Categories

I did not setup the "live" site (still under the IP address) http: //69. 4. 229. 40/~piramoo5/. If you click on "New Products" on the left you can see them, but they aren't under Apparel, Feminist.

On the test site: http://coyote. lannendesigns. com all is happy (ignore the no images displaying they weren't ftp'd)

my bulk import works
You have not elaborated on what you are using for this bulk import???

I used csv files for the bulk upload. The import worked perfectly on the test site, and the products display under Catalog, Categories/Products.

The same csv files were imported for the live site, but none of the products display under Catalog, Categories/Products.

I intentionally matched all of the categories so the ID's were the same.

I've looked at both databases and cannot see anything different. I even added a new product to the "live" site and it will display under Catalog, Categories/Products and then checked those values against the bulk import.

ZC 1.3.8a

Chris

No explanation why one wworked and another did not???

ZenCart's DB is cross-indexed in many places and I doubt that you have accounted for this through a csv import

Many use easy populate - a 3rd party module that if instructions are followed - once you learn to use it - it takes these into consideration

http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=395

I think I'm going to have to import everything into the site that works, and then export a sql statement that has everything to do with products/categories, etc..

then export a sql statement that has everything to do with products/categories, etc..
There are about 10-12 tables if no attributes and 14-16 tables with attributes
I did noit count them but this is an estimate from bad memory

The imported Products most like are not working as they are missing things in the products table such as:
products_type
master_categories_id
products_price_sorter

and check the products_to_categories table ... there has to be a Product to Category relationship to know where the Products belong ...

Do you use Linked Products, where a single Product belongs to more than 1 Category?

If not, there are ways to fix this built in ... :smile:

If you do use Linked Products, then another solution needs to be found ... :cry:

No linked products. The csv file (originally created in Excel) has every field name with a value. the column for the products_id was copied directly into the product description table.

If you peek at the products table in phpMyAdmin and browse the table and sort on the field:
master_categories_id

do you see all 0 values? Or do you see valid categories_id in the field?

If you compare the counts on the number of records (rows) on tables for:
products
products_description
products_to_categories

do they all match?