Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Deleted a product BUT it still is there!


footwearinc

Recommended Posts

Hi,

 

I have deleted one of my products and it was successfully deleted. However, when I look back at my home I see the product still there. I have looked through ALL the products for the product picture and file name associated with it. And it is not there.

 

While I have a problem deleting this, this does not effect my ability to add more pictures and it displays the new ones as its suppose to. And also, I can delete other products with no problem at all :)

 

My question is simply how can I get rid of this product that is really not in the database anymore becuase I have deleted it? :lol:

 

Any suggestions?

 

Thanks,

Tim

Link to comment
Share on other sites

do you use cache? if so, empty all of the cache folders and hit reload

 

 

Hi have hitten to clear the cach 2 times before this and 1 time after you have asked :D and the product is still there.

 

Im still open to suggestions please.

 

Thanks for all your time.

 

Thanks,

Tim

Link to comment
Share on other sites

do you use chemo's page cache contribution as well as the standard osc cache?

many times i've forgotten about that and went crazy because a deleted product was still up for purchase :)

 

as well, do you have the product in multiple categories?

if you link it to more than 1 and then delete, you will only be deleting it from the category you physically delete it from.. the other will still be present.

 

does the item still show in your admin panel?

Link to comment
Share on other sites

do you use chemo's page cache contribution as well as the standard osc cache?

many times i've forgotten about that and went crazy because a deleted product was still up for purchase :)

 

as well, do you have the product in multiple categories?

if you link it to more than 1 and then delete, you will only be deleting it from the category you physically delete it from.. the other will still be present.

 

does the item still show in your admin panel?

 

Yes, I have previously checked to see if the products are in 2 different categories just to make sure although I thought I deleted both at the same time :) then I do not have any cache contribution whatsoever installed and I am using the default oscomerce cache. I set this to true from day one of my shop and no problems deleting or anything.

 

Also this product is no where to be seen in the admin section. And whats even more is I can upload and delete other products and it works normal. It is ONLY for this one :(

 

This all began when I was fiddling with the product_info.php file to include the description where the price and name is displayed. As this caused many errors and I am not php ready hehe. I have replaced the code with the original. And ever since then I could not delete this product but every other one works normal.

 

I hope this helps :D

 

Thanks everyone,

Tim

Link to comment
Share on other sites

messing with the product_info.php won't store something like that. if anything, you'd get errors from mucking a code but nothing more peculiar.

 

by chance, did you erase your browser cache too?

 

i can't fathom what else would store a product that was recently deleted.. that is very weird.

 

is it still showing in your admin panel?

Link to comment
Share on other sites

messing with the product_info.php won't store something like that. if anything, you'd get errors from mucking a code but nothing more peculiar.

 

by chance, did you erase your browser cache too?

 

i can't fathom what else would store a product that was recently deleted.. that is very weird.

 

is it still showing in your admin panel?

 

Its not showing at all. this is very pecilular. And I really appreciate you taking the time to help me man. I mean the picture is called af1_37.jpg and you could visit my website at erbanfootwear and it should be the first picture on the top left hand corner with the four other shoes :) Let me know if you can see it or if its just me.

 

There is nothing in my admin and I have cleared the cache using 2 browsers of IE and Firefox and so far no good. Maybe the database knows the answer somehow? just a thought. and yea I did not expect the Product_info.php to be the problem at all.

 

thanks again man,

Tim

Link to comment
Share on other sites

the first one i see is:

AF1_37

Nike Air Force One

$39.99

 

which is right beneath the "Home" link

and i was able to add it to my cart. if i can add it to my cart, it most definitely is not a cache issue, moreso a database issue.

 

 

 

 

 

do you have phpmyadmin?

 

do a full database backup (export), then:

 

if so, click "products"

 

click "products_id"

notice the ordering for the order ID... look for #243

 

delete it if it is there.

 

then head to:

products_attributes

products_description

products_notifications

products_options

products_options_values

products_options_values_to_products_options

products_to_categories

 

and delete anything related to that product_id

 

 

if THIS doesn't solve your problem, there is definitely something weirder going on!

Link to comment
Share on other sites

the first one i see is:

AF1_37

Nike Air Force One

$39.99

 

which is right beneath the "Home" link

and i was able to add it to my cart. if i can add it to my cart, it most definitely is not a cache issue, moreso a database issue.

do you have phpmyadmin?

 

do a full database backup (export), then:

 

if so, click "products"

 

click "products_id"

notice the ordering for the order ID... look for #243

 

delete it if it is there.

 

then head to:

products_attributes

products_description

products_notifications

products_options

products_options_values

products_options_values_to_products_options

products_to_categories

 

and delete anything related to that product_id

if THIS doesn't solve your problem, there is definitely something weirder going on!

 

Yes I will try this as of tomorrow. I had a windows IIS server driven by a mysql database and this is where my website is contained just to let you know. As I recall I believe its the same or something very similar to that of what you said. :)

 

Im sure this will make this problem right and if not I will be posting back and not expecting a reply as umm this should be the answer to everything :lol:

 

Cheers to you man!

 

oh by the way do you have the latest Paypal IPN installed by any chance? I did have a quick question there also...and although its very off topic...I could use some help of course. I may opt ot PM you though on that one :)

 

thanks,

Tim

Link to comment
Share on other sites

i'm not familiar with iis and oscommerce, but if you can figure out how to delete the database tables (which will obviously of course, be the same) you're deleting directly from the source.

 

unless there's a deeper problem, this should solve the problem with that product showing.

 

 

 

i'm sure you've already checked, but by chance, did you modify anything in admin/categories.php recently? it is possible you may have altered the delete function that rendered it useless (which would be why that product is still there). if so, it would be any easy fix to reverse.

 

and i do not recall my specific version of ipn, but i do use it.

and feel free to pm me if you can't get the help through the board, but i can't guarantee a fast reply during the week :)

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...