Zen Cart Logo
Forums / Setting Up Categories, Products, Attributes / Imported products missing from admin, but present for orders and front-end display

Imported products missing from admin, but present for orders and front-end display

Views: 935

Results 1 to 2 of 2
18 Feb 2011, 5:10 AM
#1
austinthemes avatar

austinthemes

New Zenner

Join Date:
Feb 2011
Location:
Austin, TX
Posts:
2
Plugin Contributions:
0

Imported products missing from admin, but present for orders and front-end display

As part of a recent project, a PHP script was created that parses a standard file feed (UIEE) into the zen cart products database.

This works successfully, and populates both the znc_products and znc_products_description MySQL tables with the products. The products display great on the front-end, with products_status set at 1, and if you add them to the cart everything seems to work fine.

However, not a single product, other than a couple that were added manually, display when trying to find them in categories/products.

Has anyone else had this issue with batch importing, or is this a more complicated issue than some simple display hinderance?

I greatly appreciate any help in advance, as it's currently a project showstopper

v1.3.9h

20 Feb 2011, 8:48 AM
#2
austinthemes avatar

austinthemes

New Zenner

Join Date:
Feb 2011
Location:
Austin, TX
Posts:
2
Plugin Contributions:
0

Re: Imported products missing from admin, but present for orders and front-end display

Ok, probably a newbie mistake.

For each item imported, the product_id must be associated with records in znc_products, znc_products_description, and znc_products_to_categories.

After adding the znc_products_to_categories entries for the products, they displayed succesfully in the admin and front-end areas.