no products

[ukracer]

Hi

 

I have got a store working and its been stable for a while now however I have just logged on to check what products I have listed and I find there is none......having checked via admin that I do have at least one products listed I am confused as to what has happend.

 

The only two mods I have done is WYSIWYG and that is in admin anyway and another one to introduce bullets from this thread. http://www.oscommerce.com/forums/viewtopic.php?p=83922

 

can anyone shed any light on why I can see products in admin but not in the main store??

 

Thanks in advance

[burt]

URL might help :roll:

[ukracer]

URL might help   :roll:

 

sorry as it shows no products I did not think a url would help. my mistake.

 

 

http://www.exams4you.co.uk

 

is where the site is sitting just now!

 

thanks

[Ajeh]

And you put your shop in what directory? :shock:

[Ajeh]

Turn of Search Engin Friendly URLs in the Admin ... see if the magic occurs ... :D

[ukracer]

And you put your shop in what directory? :shock:

 

root :)

[Ajeh]

I found it in /catalog

 

Did you put it anywhere else? Or is this the correct one?

 

And in your products table ... you do see products, correct? :D

[ukracer]

Turn of Search Engin Friendly URLs in the Admin ... see if the magic occurs ... :D

 

Nope that did not help.

 

One thing I have done is edited categories.php to add the mod for bullets.

Its actually quite wierd in that if I add new products they show up as products. If I move or copy the products I already have in the store they do not show up. The only thing is I do have a negative number showing as stock so perhaps this is preventing this showing up. Although if it is I dont like it as I still need the facility to order working even on nil stock or less as the product can be sent direct from source.

 

hope this clarifies things a little

[Ajeh]

That can be customize, but depending on your setup the > 1 quanity is why you have no products.

 

Also, make sure the status setting in products table is 1 and not 0

[ukracer]

I found it in /catalog  

 

Did you put it anywhere else? Or is this the correct one?

 

 

And in your products table ... you do see products, correct? :D

 

Sorry I now understand what you asked. :) Yes this is the correct one. you will see reply which might clarify things a little.

 

You mean in the products table in the database? If so I am not sure how to read a mysql datsbase and what tools I need to read it. In fact I might go and check that out now as I will soon need to move to a new server and will need to move the database as well.

[ukracer]

That can be customize, but depending on your setup the > 1 quanity is why you have no products.

 

Ok great. Stipidly simply really but I did not notice I have purchased two radios in a fit of light indulgance (especially as the cart is not live) <grin>

JUst noticed and will change the number now to see if it helps now!

Also, make sure the status setting in products table is 1 and not 0

 

By products table do you mean in admin or Mysql data base..

 

Thanks for your assistance again.

[Ajeh]

If you use phpMyAdmin to view the raw database, then in the products tabe the status needs to be 1 to show.

 

If in the Admin, click the Green button to turn on a product if the red button is selected.

 

Note: Even if you turn it on, the first purchase will make it go away if you have stock tracking on as it will reset to status of 0 if stock is less than 1

[ukracer]

If you use phpMyAdmin to view the raw database, then in the products tabe the status needs to be 1 to show.

 

If in the Admin, click the Green button to turn on a product if the red button is selected.

 

Note: Even if you turn it on, the first purchase will make it go away if you have stock tracking on as it will reset to status of 0 if stock is less than 1

 

Hey hey thats the boyo. All sorted now. Thats brilliant and superb and I am one happy bunny now :) Thanks!

 

It was the red and green things. I also have php my admin so I guess I can also look at that to see if it will move the database to another server. Its easy to drag and drop an access database but mysql has me beat so far <grin> I have got a lot of work to get this cart up to scratch and speed to go live but I now have permission to set up another server instead of my own I am using for development so that should make things easier now I know about the red and green buttons :)

[Ajeh]

Those read and green things are the status set to 1 or 0 for the not into database types ... :D

 

Glad it is working better now.

[blueline]

Looks like you fixed it. the /catalog/default.php is the trick.

 

You may want to look at the links on your main page however, as those do not work.

 

-Chris

[ukracer]

Looks like you fixed it. the /catalog/default.php is the trick.

 

You may want to look at the links on your main page however, as those do not work.

 

-Chris

 

Yeah fixed now as linda said it was them red and green things :)

 

Also that page is only a place holder. I did not do the site I just stripped most of what I was sent to put a dummy page with just one working link for now....you think I would design with red in black :).....well probably im crap with graphics but all will be sorted when I get the new server on stream. The one that the shop he has presently is on an ASP server and I need to get a unix box set up so we can use PHP instead.

 

Now the shop on http://www.dcracing.co.uk has broken I am pressed to bring the project forward by 2 months and I know very little about PHP and its not easy without help from people like you and linda.

 

Thanks again.

[blueline]

Well, I am by no means a PHP master. I am learning everyday, but I do try and help where and when I see an opening.

 

-Chris

[ukracer]

Well, I am by no means a PHP master. I am learning everyday, but I do try and help where and when I see an opening.

 

-Chris

 

what forum would I go to ask about moving a database to another server is it installation or a contribution??

 

TIA

[blueline]

No contribution that I know of. I just did that last night, and man what a mess. Just be careful. The first problem I ran into was that the hosting company created all databases with my user 'user_' in front, which made the osC that I had previously installed not work.

 

I just got it fixed, 24 hours later. BIG problems. If you need any help though, just ask.

 

-Chris

 

Just move your files over, then go into your mySQL database, and create a data only backup. Then all you have to do is enter the outputed file into a mySQL query on the new server.

[ukracer]

No contribution that I know of. I just did that last night, and man what a mess. Just be careful. The first problem I ran into was that the hosting company created all databases with my user 'user_' in front, which made the osC that I had previously installed not work.  

 

I just got it fixed, 24 hours later. BIG problems. If you need any help though, just ask.

 

.

 

Ok Im asking :)

 

I have copied the catalog anmd admin files via FTP just fine.

 

I have created a database on the new server but its called a different name......so I edited the configure file.......but I do not know if the user and password will be the same as the old exported datbase or not...if it is it does not work. If now how do I find out what it should be .

 

thanks in advnace