Forums / General Questions / Products Price Manager Dissapearing from some items will not diplay those items

Products Price Manager Dissapearing from some items will not diplay those items

Views: 2,402

Results 1 to 20 of 30
13 Jun 2013, 2:17 AM
#1
wiccanwitch420 avatar

wiccanwitch420

Zen Follower

Join Date:
Nov 2008
Posts:
196
Plugin Contributions:
0

Products Price Manager Dissapearing from some items will not diplay those items

We are having an issue with products mysteriously dissapearing on the site. I do not know how it is happening. I am showing you a screen shot of one of the products that this is happening to. I found one a few months back at FC05BU- and I just remade the item. I found another a few weeks ago, FC05BB- but that product is discontinued and we were out of stock anyways, but now I just found another item 39050.
Attachment 12650
We went through all the clothing items and found that the following items have the same problem:
39050, FC05BB, FC05BU (the old one since now there is a remade one), 38180, 36746. I know that these were all on the site recently, as we sold one item in april and jason was looking at these other items when we put them on ebay about a month ago.
If you notice the item that is bad, there is a missing green icon, and when you hover over the other green icons it says "Products Price Manager"
When you go to edit the item that is missing the green money icon, it goes to a page like this
"404 not found - the requested document was not found on the server"
It will not let me go to the item or edit it , or anything.

I decided to try and look at the products with attributes stock and see if it was there, so I looked up, and low and behold the item was there. You can even click on the item, and it will take you to the page that is missing when you try and edit it. Makes no sense to me. But the customer cannot see these items that are missing the green money sign.

The pictures of these items still show up in areas on the site such as "reviews" like if there is a review written on the product, and you can click on its picture then you get a page not found. Or it was showing a thing that sais "new products for june" and it showed the item 39050- and that is how i found the error just now, i click on it and then it said "page not found" so that is when I went to the backend and found that it was missing a green money sign the product price thing. I need to find

the item, just fine in the attributes stock keeping stock and everything

On the stock by attributes the title of the item is there and clickable, well when you try and click on it from tjere, it takes you to the item and shows you the items back end, and you can see it, so the file is really there It has just lost its way.

I need to figure out this issue as now 5 of my items have this problem.

Once this happens it will not let me edit the item, delete the item , or do anything the only thing you can do is activate or deactivate the product - flip the green and red button- it just acts like it is not there.

Please help me,

Also when I go to the Products price manager tab on the backend and try to look up those items, it will list them in the list, but when you click on them to see the information, there is nothing there. The titles only show up in the list. I have NO clue how this is happening or why.

This is isolated to JUST our clothing items which all have products with attributes. Please help me. :no:

13 Jun 2013, 4:28 AM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Products Price Manager Dissapearing from some items will not diplay those items

If you EDIT a product that you cannot see the icon for the Product Price Manager, what do you see in the URL for the product_type=XX ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

13 Jun 2013, 5:18 PM
#3
wiccanwitch420 avatar

wiccanwitch420

Zen Follower

Join Date:
Nov 2008
Posts:
196
Plugin Contributions:
0

Re: Products Price Manager Dissapearing from some items will not diplay those items

Ajeh:

If you EDIT a product that you cannot see the icon for the Product Price Manager, what do you see in the URL for the product_type=XX ...

oh you mean in the url it has a long one but says at the end " .php?cPath=127&product_type=0&pID=1061&action=new_product"

My web girl says this...
The problem that is happening is that the products are losing their "Product Type" - I checked the db and there were 5 products that had products_type=0 which should have been a 1. However, I'm not sure where or why they are losing the Product Type, so the root cause is not yet fixed until I find that out.

Does anyone have any insight as to why this is happening>? Fix?

13 Jun 2013, 5:43 PM
#4
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Products Price Manager Dissapearing from some items will not diplay those items

WiccanWitch420:

&product_type=0

...

I checked the db and there were 5 products that had products_type=0

That is the reason the Product Price Manager is not working ...

Do you import your Products or add them all manually directly in Zen Cart admin?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

13 Jun 2013, 6:47 PM
#5
wiccanwitch420 avatar

wiccanwitch420

Zen Follower

Join Date:
Nov 2008
Posts:
196
Plugin Contributions:
0

Re: Products Price Manager Dissapearing from some items will not diplay those items

Ajeh:

That is the reason the Product Price Manager is not working ...

Do you import your Products or add them all manually directly in Zen Cart admin?

We add them directly into zen cart admin,. these are old products these happened to. Ones that were put in at different times, were active a couple months ago- at least some of them were, and then this happened to them. My web girl changed them to make them active now, BUT i want to know why this might be happening , and what type of fix to make sure it does not happen again in the future. ?

13 Jun 2013, 6:54 PM
#6
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Products Price Manager Dissapearing from some items will not diplay those items

Do you have any add ons in your Admin?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

13 Jun 2013, 6:58 PM
#7
wiccanwitch420 avatar

wiccanwitch420

Zen Follower

Join Date:
Nov 2008
Posts:
196
Plugin Contributions:
0

Re: Products Price Manager Dissapearing from some items will not diplay those items

Ajeh:

Do you have any add ons in your Admin?

Like mods and stuff? Here is a list of all my mods and things.

Patches Mods Installed:
Simple Category Tree (http://www.zen-cart.com/forum/showth...oducts&page=10)
Google Analytics (http://www.zen-cart.com/index.php?ma...roducts_id=412)
How Did you hear about us (http://www.zen-cart.com/index.php?ma...roducts_id=186)
Google Base Froogle (http://www.zen-cart.com/index.php?ma...roducts_id=473)
USPS Patch (http://www.zen-cart.com/forum/showthread.php?t=97461)
SQL Injection Protection (http://www.zen-cart.com/forum/showthread.php?t=108428)
Windows Live Feeder (http://www.zen-cart.com/index.php?ma...roducts_id=691)
Ultimate SEO http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=231
THIS ONE WAS INSTALLED AND THEN UNINSTALLED BECAUSE WE COULD NOT GET THE CALCULATOR TO WORK AFTER THAT:
Option Shipping Insurance (http://www.zen-cart.com/index.php?ma...roducts_id=348)
USPS International Shipping Problem: international shipping problem
Below are some patches and stuff that were done as well as updates:

All Security Patches Here: http://www.zen-cart.com/forum/showthread.php?t=131115
PCI Scan Patch: http://www.zen-cart.com/forum/showthread.php?t=130701
Security Remove Extra Folders: http://www.zen-cart.com/forum/showthread.php?t=142784
USPS Update: http://www.zen-cart.com/forum/showthread.php?t=144992
XXS Protection Patch http://www.zen-cart.com/forum/showthread.php?t=142927
We did some of these security recommendations: https://www.zen-cart.com/tutorials/index.php?article=73
Protection Whos Online: https://www.zen-cart.com/tutorials/index.php?article=320
Blocking Hacker Activity: https://www.zen-cart.com/tutorials/index.php?article=398

The templates and buttons and all design work is custom.

2011- had upgrade to 1.3.9h by zen 4 dummies, found out she was the dummy, then had numinix fix some things she didnt get right,

NUMINIX

  1. Google Merchant Center Feeder-$25 dollar installation fee. http://www.numinix.com/zen-cart-modules/marketing/google-merchant-center-feeder

  2. UTF-8 Character Set-$85 dollars http://www.numinix.com/zen-cart-modules/marketing/google-merchant-center-feeder

  3. Google Analytics- $30 dollar installation fee. You can purchase the install here: http://www.numinix.com/php-sql/zen-cart-module-installation.

  4. Dynamic Drop Downs (Custom for sizing display done by tim)

  5. Numinix product fields with making it so I can create a google product category as an attribute and it will not show up on the site visually with UPC field etc

  6. Change "delivered" to read as "shipped" (on invoices in admin)

  7. The discount code lookup page does not work any longer, I have no clue when this stopped working, it could have been a long time ago, or when the stupid lady upgraded my site.

http://www.mysticcrypt.com/discount_coupon.html
THIS WAS FIXED
8. I have categories with subcats, and I like it that way. But for instance when you look at a category, (for instance clicking Plus Size Gothic Clothing) on the left

http://www.mysticcrypt.com/plus-size-gothic-clothing-c-68.html

You can see it displays 10 per page. I wanted to add an option to where you can choose to display the 10 results - or 25 results- or 50 results - or ALL results. (Pagination)
9. Upgraded wordpress

  1. Paid to have you fix the seo urls which were not working after the upgrade from dummy.

( I think that is it as far as Numinix Goes)

NEW 7/24/2012
11. AJAX Auto Search Suggest (1.0.3)
Installation Installation

  1. The one hour of programming is for_
    A. If you go to https://www.MysticCrypt.com and you look at the left hand side and you see the categories, for instance click on any of the categories and then click on any item. You can see, for instance if I am looking at this item : http://www.mysticcrypt.com/50s-girl-in-poodle-skirt-creepy-horror-doll-by-bastet2329-p-1381.html
    You can see the the sub categorie that the item is in says " horror dolls" but when you click that link it goes back to the home page. This works the same for any item you are looking at. None of them click back to the right category, they all go to the home page.
    AND

B. There is one thing In the past I had paid for you to put the "view 10, 25,50 all" when looking at the product categories. We found that there is one that did not get set up

http://www.mysticcrypt.com/reviews.html

The $30 Install is for the save for later http://www.thatsoftwareguy.com/zencart_saveforlater.html to be installed

  1. Please replace the alpha filter with a select box that has the options to sort by name, newest, price (low to high), price (high to low) Best Sellers. This should be available on the following listings:
    • New Products
    • Featured Products
    • Specials
    • All Products
    • Product Listing
    • Reviews Listing
    • Best Sellers Listing

  2. Dev Site made by numinix admin devteam99 /dev

  3. Uploaded pictures to replace existing pics, such as reviews start, the trashcan, uploaded a new 5% off guy, and a sizing and measuring button on clothing items- Toots

  4. Facebook Open Graph- numinix installed by Toots-
    https://www.numinix.com/zen-cart-modules/social-networking/facebook-open-graph

  5. Facebook Like Button- numinix - installed by Toots
    https://www.numinix.com/zen-cart-modules/social-networking/facebook-like-button

  6. Social media buttons installed by Toots - had to do modifications to make them work.
    http://www.zen-cart.com/downloads.php?do=file&id=1274

  7. I see this on the config -CSS/JS Loader Configuration installed 8/13

  8. Pinterest
    https://www.numinix.com/zen-cart-modules/social-networking/pinterest-com-pin-it-button

  9. And Google Plus
    https://www.numinix.com/zen-cart-modules/social-networking/google-plus-one-button

  10. Contest System- with modifications from tootsContests
    Modified the defines pages and templates.
    Contest challenge question accepts a list of possible answers {A,B,C}.

http://www.zen-cart.com/downloads.php?do=file&id=831
23. Print invoice system programmed by toots.

  1. Then the restock notifications Ceon: heavily modified by toots file is in zen folder http://www.zen-cart.com/downloads.php?do=file&id=773

  2. Then this one where you have to re confirm your email to eliminate email address errors when signing up.- she had to do some modifications on itConfirm Email
    Auto-populate the Referral Source/Other Source with the user's previously entered data (in case of form submit errors).
    http://www.zen-cart.com/downloads.php?do=file&id=107

  3. I wanted to do this one below, where it ads a subject line to contact us. Modified by toots to make it work. Contact Us - Subject
    Auto-populate the Name, Email, Subject and Message fields with the user's previously entered data (in case of form submit errors).
    Modified the seo.url.php class to allow posting data to the contact form.
    http://www.zen-cart.com/downloads.php?do=file&id=226

  4. USPS.com Click-n-Ship AutoFill Button
    http://www.zen-cart.com/downloads.php?do=file&id=182

  5. Download Zencart Custom Session Timeout
    http://www.reloadedpc.com/zen-cart/zencart-custom-session-length/

  6. Automatically apply the NEWGHOUL discount code to a customer's first order

  • Manually updated includes/modules/pages/checkout_payment/header_php.php to apply the discount code.
  • Removed discount code from Sign Up/Login page
  • Removed reference to emailed discount on the account success page.
  1. USPS - United States Postal Service for Zen Cart v1.5.0
    http://www.zen-cart.com/showthread.php?205250-USPS-RateV3-January-27-2013

It is supposed to be an update file? http://www.zen-cart.com/downloads.php?do=file&id=1292

31 Toots- USPS Shipping Module Update: Here is the link to the new plug in: http://www.zen-cart.com/downloads.php?do=file&id=1292

  1. Toots- Numinix Mod- Then there is an update that we need that has some things that numinix had installed on our server. Here is the information on it: CSS JS Loader (v. 2.2.1): bug fix for cache folder.
    https://www.numinix.com/downloads/zen-cart-modules/other-modules/css-js-loader

  2. Toots- Fixing of the automatic coupon for 5% NEW GOUL to allow gift certificate people to purchase normally without an error since they cant use coupon.

  3. Adding Paypal Banners of Financing to the site

  4. Numinix Inventory Numinix Product Variants Inventory Manager- installed by Toots.

13 Jun 2013, 6:59 PM
#8
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Products Price Manager Dissapearing from some items will not diplay those items

If you look at Catalog ... Product Type ... what do you see on the listing?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

13 Jun 2013, 6:59 PM
#9
wiccanwitch420 avatar

wiccanwitch420

Zen Follower

Join Date:
Nov 2008
Posts:
196
Plugin Contributions:
0

Re: Products Price Manager Dissapearing from some items will not diplay those items

THIS ONE WE HAVE NOT DONE YET 35. Numinix Inventory Numinix Product Variants Inventory Manager- installed by Toots.

13 Jun 2013, 7:00 PM
#10
wiccanwitch420 avatar

wiccanwitch420

Zen Follower

Join Date:
Nov 2008
Posts:
196
Plugin Contributions:
0

Re: Products Price Manager Dissapearing from some items will not diplay those items

What do you mean?
Product Types
Product Types Add
to Cart Action
Product - General Y
Product - Music Y Info
Document - General N Info
Document - Product Y Info
Product - Free Shipping Y Info

13 Jun 2013, 7:08 PM
#11
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Products Price Manager Dissapearing from some items will not diplay those items

So you just see the 5 Original Product Types and no new Product Types added in there, correct?

And when in a Category, the dropdown for Product type defaults to Product - General, correct?

And if you look via phpMyAdmin at that table:
product_types_to_category

do you see anything in that table or is it empty?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

13 Jun 2013, 7:12 PM
#12
wiccanwitch420 avatar

wiccanwitch420

Zen Follower

Join Date:
Nov 2008
Posts:
196
Plugin Contributions:
0

Re: Products Price Manager Dissapearing from some items will not diplay those items

Ajeh:

If you look at Catalog ... Product Type ... what do you see on the listing?

What do you mean by this? I had her fix the items now, but we want to know why this might have happened, and what we can do to prevent it in the future, any ideas?

13 Jun 2013, 7:17 PM
#13
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Products Price Manager Dissapearing from some items will not diplay those items

Go to your Zen Cart Admin and in Catalog ... Product Types ... I am just confirming that you see 5 Product Types listed ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

13 Jun 2013, 7:27 PM
#14
wiccanwitch420 avatar

wiccanwitch420

Zen Follower

Join Date:
Nov 2008
Posts:
196
Plugin Contributions:
0

Re: Products Price Manager Dissapearing from some items will not diplay those items

Ajeh:

So you just see the 5 Original Product Types and no new Product Types added in there, correct?

And when in a Category, the dropdown for Product type defaults to Product - General, correct?

And if you look via phpMyAdmin at that table:
product_types_to_category

do you see anything in that table or is it empty?

YES, Just 5 product types.

and YES And when in a Category, the dropdown for Product type defaults to Product - General, correct? YES

and as for this one...And if you look via phpMyAdmin at that table:
product_types_to_category

do you see anything in that table or is it empty? I DO NOT KNOW BECAUSE I HAVE TO HAVE MY WEB GIRL LOOK THERE, I DONT KNOW HOW, BUT TELL ME WHAT SHE SHOULD LOOK FOR OR SEE?

13 Jun 2013, 7:30 PM
#15
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Products Price Manager Dissapearing from some items will not diplay those items

I am hoping that the table is empty or has valid data in it ...

Do you actually use any other Product Type besides Product - General?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

13 Jun 2013, 7:37 PM
#16
wiccanwitch420 avatar

wiccanwitch420

Zen Follower

Join Date:
Nov 2008
Posts:
196
Plugin Contributions:
0

Re: Products Price Manager Dissapearing from some items will not diplay those items

Ajeh:

I am hoping that the table is empty or has valid data in it ...

Do you actually use any other Product Type besides Product - General?

No we only use the product type general.

can you tell me how she gets to the table you are asking about in case she doesnt know?

13 Jun 2013, 7:39 PM
#17
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Products Price Manager Dissapearing from some items will not diplay those items

The Control Panel for your domain should have a way to gt to phpMyAdmin so that you can find your database that you are using and then see the tables and if the do or do not contain any data contents ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

13 Jun 2013, 7:45 PM
#18
wiccanwitch420 avatar

wiccanwitch420

Zen Follower

Join Date:
Nov 2008
Posts:
196
Plugin Contributions:
0

Re: Products Price Manager Dissapearing from some items will not diplay those items

Ajeh:

The Control Panel for your domain should have a way to gt to phpMyAdmin so that you can find your database that you are using and then see the tables and if the do or do not contain any data contents ...

and what if she finds jarbled stuff? What would that mean?

She already found that The problem that is happening is that the products are losing their "Product Type" - I checked the db and there were 5 products that had products_type=0 which should have been a 1. However, I'm not sure where or why they are losing the Product Type, so the root cause is not yet fixed until I find that out.

I am not sure if she has looked where you are talking about, but what if she finds jarble there what would it mean ? And what is valid data vs non valid data?

13 Jun 2013, 7:48 PM
#19
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Products Price Manager Dissapearing from some items will not diplay those items

I am just looking for possibilities of why the products_type is either being lost or set to 0 ...

So far, I am not able to reproduce the problem to make this happen ...

Was this a clean install of Zen Cart v1.3.9h or was it an Upgrade?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

13 Jun 2013, 8:15 PM
#20
wiccanwitch420 avatar

wiccanwitch420

Zen Follower

Join Date:
Nov 2008
Posts:
196
Plugin Contributions:
0

Re: Products Price Manager Dissapearing from some items will not diplay those items

wiccanwitch420:

and what if she finds jarbled stuff? What would that mean?

She already found that the problem that is happening is that the products are losing their "product type" - i checked the db and there were 5 products that had products_type=0 which should have been a 1. However, i'm not sure where or why they are losing the product type, so the root cause is not yet fixed until i find that out.

I am not sure if she has looked where you are talking about, but what if she finds jarble there what would it mean ? And what is valid data vs non valid data?

here it is

Attachment 12655