Zen Cart Logo
Forums / Setting Up Categories, Products, Attributes / Problems adding products (showing up in admin but not in catalog)

Problems adding products (showing up in admin but not in catalog)

Locked

Views: 1,309

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
28 Jul 2007, 8:52 PM
#1
dinki avatar

dinki

Zen Follower

Join Date:
Oct 2006
Posts:
206
Plugin Contributions:
0

Problems adding products (showing up in admin but not in catalog)

Hey guys, I've been running my Zencart for about a year now without problem. I'm now having an issue where I can add a product and it shows up in admin but will not show up in my catalog.

I tried duplicating a product and changing it's name, but it won't show up in the catalog. I looked at the database for the lines and see that the master_categories_id for the two are different. I tried changing the new version to 0 like the original product but still no luck. Here's what the two lines look like from the database (products table):

products_id products_type products_quantity products_model products_image products_price products_virtual products_date_added products_last_modified products_date_available products_weight products_status products_tax_class_id manufacturers_id products_ordered products_quantity_order_min products_quantity_order_units products_priced_by_attribute product_is_free product_is_call products_quantity_mixed product_is_always_free_shipping products_qty_box_status products_quantity_order_max products_sort_order products_discount_type products_discount_type_from products_price_sorter master_categories_id products_mixed_discount_quantity metatags_title_status metatags_products_name_status metatags_model_status metatags_price_status metatags_title_tagline_status

Edit Delete 239 1 0 d5137 decals/funnysayings/d5137-RANDOM_IMAGES.gif 3.9900 0 0000-00-00 00:00:00 2005-07-03 18:30:14 NULL 0 1 1 0 0 1 1 0 0 0 0 0 1 0 0 0 0 3.9900 0 1 0 0 0 0 0

   Edit        Delete       580      1      0      d5137      decals/funnysayings/d5137-RANDOM_IMAGES.gif      3.9900      0      2007-07-28 13:32:58      2007-07-28 13:33:35      NULL      0      1      1      0      0      1      1      0      0      0      0      0      1      0      0      0      0      3.9900      29      1      0      0      0      0      0I'm runningZen Cart 1.3.6 Database Patch Level:  1.3.6

Any help is greatly appreciated.

28 Jul 2007, 9:13 PM
#2
dinki avatar

dinki

Zen Follower

Join Date:
Oct 2006
Posts:
206
Plugin Contributions:
0

Re: Problems adding products (showing up in admin but not in catalog)

A little extra research brought me to this post:

http://www.zen-cart.com/forum/showthread.php?t=52918&highlight=master_categories_id

Which gave me the answer to fixing my problem:

  1. do a full database backup of your mysql data
  2. Admin->Tools->Store Manager ---->Reset ALL Products Master Categories ID