keithclark Posted May 21, 2008 Share Posted May 21, 2008 I'm not sure how this can be....two items. Both are in the same catagory. If I click on one, it finds it and provides the correct description. When I click on the other, it says product not found. I changed the price on the one not found and it changes it just fine. I compared the two products in their products and products_description tables and both are the same. I'm at my ends here. IT is the same throughout the whole database. Some products choose to appear, others do not. Anyone help with this one? Keith Link to comment Share on other sites More sharing options...
keithclark Posted May 26, 2008 Author Share Posted May 26, 2008 Ok, I've been working on this issue for days, and I just can't find a solutions here. The catagories are displaying correctly, when I select a catagory, the correct products are listed, by product name under that catagory, including their price. When I click on the product name, all that comes up is "Product Not Found". I have a description field filled in in the products_description file, and I assume it is working because the products are listed correctly by name. Keith Link to comment Share on other sites More sharing options...
keithclark Posted May 26, 2008 Author Share Posted May 26, 2008 Ok, I've been working on this issue for days, and I just can't find a solutions here. The catagories are displaying correctly, when I select a catagory, the correct products are listed, by product name under that catagory, including their price. When I click on the product name, all that comes up is "Product Not Found". I have a description field filled in in the products_description file, and I assume it is working because the products are listed correctly by name. Keith I think I just may have found the problem. In my database, the productID index cannot be an int. Books use a convenient product code already, and ISBN number, but those may contain a letter, so I changed the field type to varchar. It does not create a problem until the file product_info.php is ran. At least that is what I can see so far, am I on the right track? Keith Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted May 26, 2008 Share Posted May 26, 2008 Leave product id alone (Back to how it was) and put the isbn no as the model no. Should sort it. 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...
keithclark Posted May 26, 2008 Author Share Posted May 26, 2008 Leave product id alone (Back to how it was) and put the isbn no as the model no. Should sort it. I am entering/creating the product data in a spreadsheet and importing it via .csv file. What do I put in the productID column? Will it not overwrite the auto number already generated? Keith Link to comment Share on other sites More sharing options...
keithclark Posted May 26, 2008 Author Share Posted May 26, 2008 I am entering/creating the product data in a spreadsheet and importing it via .csv file. What do I put in the productID column? Will it not overwrite the auto number already generated? Keith Also, when I go to reference other tables such as products_description, that will be difficult to use, as my local database uses the isbn as the productID. Keith Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted May 26, 2008 Share Posted May 26, 2008 I import my data using Easy Populate, it takes care of new categories and manufacturers. Site sizes vary beteen 7,000 products and 65. Read the documentation a few times but it is all there. 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...
keithclark Posted May 26, 2008 Author Share Posted May 26, 2008 I import my data using Easy Populate, it takes care of new categories and manufacturers. Site sizes vary beteen 7,000 products and 65. Read the documentation a few times but it is all there. Yeah, I've been through the docs many times and just can't see how to make the two databases interact. Keith Link to comment Share on other sites More sharing options...
keithclark Posted May 26, 2008 Author Share Posted May 26, 2008 Leave product id alone (Back to how it was) and put the isbn no as the model no. Should sort it. So, it is not possible to change the variable type on osCommerce then? Keith Link to comment Share on other sites More sharing options...
keithclark Posted May 27, 2008 Author Share Posted May 27, 2008 Leave product id alone (Back to how it was) and put the isbn no as the model no. Should sort it. Just wanted to drop you a quick note of thanks. Your advice worked out well for me! Keith 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.