14 replies to this topic

[peaceland]

Where is all the data related to my store?
Is it possible to go under the hood and see all the products/sizes/lengths, etc.?
And edit them inside the files, rather than in the standard interface?

[spooks]

peaceland, on 15 November 2009, 17:26, said:

Where is all the data related to my store?
Is it possible to go under the hood and see all the products/sizes/lengths, etc.?
And edit them inside the files, rather than in the standard interface?

Yes, the data is all in the dbase, so log into your hosting cpanel, open phpMyAdmin, select your dbase, then the table your interested in, then select browse. [img]http://forums.oscommerce.com/public/style_emoticons/default/smile.gif[/img]

[MrPhil]

Most of your store data, except for some configuration stuff and the pictures, is stored in your database. You can use a tool such as phpMyAdmin to browse and even (with care!) edit your information. Your hosting service should provide it. If you want to do bulk updates from CSV files, look at the EasyPopulate add-on.

[peaceland]

spooks, on 15 November 2009, 18:23, said:

Yes, the data is all in the dbase, so log into your hosting cpanel, open phpMyAdmin, select your dbase, then the table your interested in, then select browse. [img]http://forums.oscommerce.com/public/style_emoticons/default/smile.gif[/img]

I know how to open files, but WHICH FILE IS THE DATABASE?
I looked through almost all of the files, and can't seem to find it.

What is the name of the database file in OS Commerce?
Thank you!

Which folder is it in?

[geoffreywalton]

spooks, on 15 November 2009, 18:23, said:

Yes, the data is all in the dbase, so log into your hosting cpanel, open phpMyAdmin, select your dbase, then the table your interested in, then select browse. [img]http://forums.oscommerce.com/public/style_emoticons/default/smile.gif[/img]

The db is not a file like index.php.

You have to access it as described above.

If you are unsure of the db name open /includes/configure.php and look twards the end of the file.

HTH

G

[peaceland]

geoffreywalton, on 15 November 2009, 20:09, said:

The db is not a file like index.php.

You have to access it as described above.

If you are unsure of the db name open /includes/configure.php and look twards the end of the file.

HTH

G

I see... thank you! I found it, but it still doesn't solve my problem. The sort for Size is still incorrect, and I am not finding that area, and not sure how to resort in anyway... Appreciate the pointer. I do see the database now... awesome.

[geoffreywalton]

Maybe if you explain what the problem is someone will be able to help.

G

[Ben Nevis]

Sorting information is mostly not contained in the database, except where a contribution or osC itself provides sort order instructions that are stored in a field in the database. Otherwise sorting is usually done by default - price, alphabetically, _id field etc, except in certain cases where the scripts themselves provide user-selectable sort orders. If want to impose a sort order on something that sort order instructions are not provided for in admin, then you will have to modify a script or use an add on that does so.

[peaceland]

This is the page that has the problem:
http://peacelandmusic.com/shoppingcart/product_info.php?cPath=21&products_id=28&osCsid=2ab8eef711b49d71bee843c36a409232

If you look at Size:
the 004 is at the bottom of the list, and should be at the top.

Appreciate any tips!

[spooks]

If your wanting to change default product sort order, this topic deals with that, if it by atributes its this one.

If you have any issues, the tips forum is always a good place to search first. [img]http://forums.oscommerce.com/public/style_emoticons/default/smile.gif[/img]

[spooks]

peaceland, on 15 November 2009, 22:58, said:

This is the page that has the problem:
http://peacelandmusi...ee843c36a409232

If you look at Size:
the 004 is at the bottom of the list, and should be at the top.

Appreciate any tips!

We crossed posts! [img]http://forums.oscommerce.com/public/style_emoticons/default/laugh.gif[/img]

If you bought that template, you should ask the supplier to frix the coding issues, if you don't you could have issues detailed here. [img]http://forums.oscommerce.com/public/style_emoticons/default/huh.gif[/img]

PS site is very narrow, try making it at least 900 wide, looks tiny right now!! [img]http://forums.oscommerce.com/public/style_emoticons/default/smile.gif[/img]

[Xpajun]

peaceland, on 15 November 2009, 22:58, said:

This is the page that has the problem:
http://peacelandmusic.com/shoppingcart/product_info.php?cPath=21&products_id=28&osCsid=2ab8eef711b49d71bee843c36a409232

If you look at Size:
the 004 is at the bottom of the list, and should be at the top.

Appreciate any tips!

Was the 004 added after the rest? just wondering if it listing on the ID # seeing as it is an attrubute

[multimixer]

spooks, on 15 November 2009, 23:08, said:

We crossed posts! [img]http://forums.oscommerce.com/public/style_emoticons/default/laugh.gif[/img]

If you bought that template, you should ask the supplier to frix the coding issues, if you don't you could have issues detailed here. [img]http://forums.oscommerce.com/public/style_emoticons/default/huh.gif[/img]

PS site is very narrow, try making it at least 900 wide, looks tiny right now!! [img]http://forums.oscommerce.com/public/style_emoticons/default/smile.gif[/img]

I agree. The main problem of this construction is not the sorting right now

[peaceland]

Xpajun, on 16 November 2009, 08:08, said:

Was the 004 added after the rest? just wondering if it listing on the ID # seeing as it is an attrubute

Yes, it was added after the rest. It is listed at the end of the list. Is there a way to move things up on the list? or change ID?

[multimixer]

People will not be able do buy anything in the moment they click on any of your tabs on the top menu. They will loose their session id and their cart will be empty again. And in this case it doesn't matter what size they choose or how they choose it