garjowan

// start random new products $new_products_query = tep_db_query("select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and s.status = '1' order by rand() limit " . MAX_DISPLAY_SPECIAL_PRODUCTS); // end random new products You will notice on the last line I have chaned what is normally "order by s.products_id desc" or "order by p.products_date_added desc" to "order by rand()" That is all you need to do to get random queries from the database! I hope this helps someone I had been trying to work it out for ages! THANK YOU!...LOL!!! I have been messing with contri's trying to get this to work with my templates and no go... this did the trick, I can't believe I didn't think of it! Thanks again!

I have just installed this cont' and all wen well... My cats are all on and I disable the ones I don't want... the Sub-Cats are on I disable the ones I don't want... The problem is that all the individual products are OFF... Over 20K of them... I know there must be some part of the code to change or something... I have searched forever to no avail. I tried changing the "default" in SQL, but they don't change. Any thoughts? Where would the code for this be? Thanks, Gary

I just installed this and am having problems... I have the information in hte osc admin areas but whe I try to upload the new inventory list and insert into the database, I get this error... I know nothing about DB's so any help is appreciated. Filename: oscommerce_inventory_list_NEWEST.txt 1054 - Unknown column 'p.products_mfgmodel' in 'field list' SELECT p.products_mfgmodel as v_products_mfgmodel, p.products_id as v_products_id, p.products_model as v_products_model, p.products_image as v_products_image, p.products_price as v_products_price, p.products_weight as v_products_weight, p.products_date_added as v_date_avail, p.products_tax_class_id as v_tax_class_id, p.products_quantity as v_products_quantity, p.manufacturers_id as v_manufacturers_id, subc.categories_id as v_categories_id FROM products as p, categories as subc, products_to_categories as ptoc WHERE p.products_id = ptoc.products_id AND p.products_model = '111128' AND ptoc.categories_id = subc.categories_id I am assuming this is a DB issue... I renamed the "products_artist" to "products_mfgmodel" and I know I changed all the instances. I am clueless here...LOL!!! Thanks, Gary

I give up, this is pathetic... I will try another script. I have never had so much trouble as this... I have hacked through everything from UBB to PHPadmin and never encountered this kind of headache. Install instructions are almost idiotic... They don't tell you "exactly" ... ANYTHING! ahhhhhh... now that that's outta the way... Anyone wanna help out a crazed lunatic with this? LOL!!!!

Sorry for the delay, I am at work now and still trying to get this thing going! LOL!!!

It's in "store"... I figured that out and put the temp dir in the "store" file and gave it 777, I then uploaded the .xls file to the temp dir and tried inserting into db... too big right? So I tried splitting with the EZ program and nothing happened... I am I wrong here so far?

Nothing... I uploaded the file to my directory and then attempted to split... nothing! I also tried the "Import from Temp Dir (catalog/easypopulate/)" then inserted into DB....nothing. Are there any idiot proof step by step instructions anywhere? Is it the list? It has over 20K items.

I have tried for hours to get this to work... nothing! I used the "split files" to break down a large inventory excel file and nothing happens, I get no files created... I have searched the forums and none of the posts really help. Is there any easier to understand instructions? I think I am doing it right but it's not working, I know it's got to be something simple. Thanks, Gary