peaceland Posted November 15, 2009 Share Posted November 15, 2009 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? Link to comment Share on other sites More sharing options...
spooks Posted November 15, 2009 Share Posted November 15, 2009 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. Sam Remember, What you think I ment may not be what I thought I ment when I said it. Contributions: Auto Backup your Database, Easy way Multi Images with Fancy Pop-ups, Easy way Products in columns with multi buy etc etc Disable any Category or Product, Easy way Secure & Improve your account pages et al. Link to comment Share on other sites More sharing options...
MrPhil Posted November 15, 2009 Share Posted November 15, 2009 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. Link to comment Share on other sites More sharing options...
peaceland Posted November 15, 2009 Author Share Posted November 15, 2009 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. 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? Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted November 15, 2009 Share Posted November 15, 2009 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. 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 Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
peaceland Posted November 15, 2009 Author Share Posted November 15, 2009 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. Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted November 15, 2009 Share Posted November 15, 2009 Maybe if you explain what the problem is someone will be able to help. G Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
Ben Nevis Posted November 15, 2009 Share Posted November 15, 2009 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. www.jyoshna.com. Currently using OsC with STS, Super Download Store, Categories Descriptons, Manufacturers Description, Individual Item Status, Infopages unlimited, Product Sort, Osplayer with flashmp3player, Product Tabs 2.1 with WebFx Tabpane and other bits and pieces including some I made myself. Many thanks to all whose contributions I have used! Link to comment Share on other sites More sharing options...
peaceland Posted November 15, 2009 Author Share Posted November 15, 2009 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! Link to comment Share on other sites More sharing options...
spooks Posted November 15, 2009 Share Posted November 15, 2009 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. Sam Remember, What you think I ment may not be what I thought I ment when I said it. Contributions: Auto Backup your Database, Easy way Multi Images with Fancy Pop-ups, Easy way Products in columns with multi buy etc etc Disable any Category or Product, Easy way Secure & Improve your account pages et al. Link to comment Share on other sites More sharing options...
spooks Posted November 15, 2009 Share Posted November 15, 2009 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! 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. PS site is very narrow, try making it at least 900 wide, looks tiny right now!! Sam Remember, What you think I ment may not be what I thought I ment when I said it. Contributions: Auto Backup your Database, Easy way Multi Images with Fancy Pop-ups, Easy way Products in columns with multi buy etc etc Disable any Category or Product, Easy way Secure & Improve your account pages et al. Link to comment Share on other sites More sharing options...
Xpajun Posted November 16, 2009 Share Posted November 16, 2009 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 My store is currently running Phoenix 1.0.3.0 I'm currently working on 1.0.7.2 and hope to get it live before 1.0.8.0 arrives (maybe 🙄 ) I used to have a list of add-ons here but I've found that with the ones that supporters of Phoenix get any other add-ons are not really neccessary Link to comment Share on other sites More sharing options...
multimixer Posted November 16, 2009 Share Posted November 16, 2009 We crossed posts! 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. PS site is very narrow, try making it at least 900 wide, looks tiny right now!! I agree. The main problem of this construction is not the sorting right now My community profile | Template system for osCommerce - New: Responsive | Feedback channel Link to comment Share on other sites More sharing options...
peaceland Posted November 16, 2009 Author Share Posted November 16, 2009 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? Link to comment Share on other sites More sharing options...
multimixer Posted November 16, 2009 Share Posted November 16, 2009 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 My community profile | Template system for osCommerce - New: Responsive | Feedback channel Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.