fixion

ot_tax missing after using order_editor 5.0.6_6 to edit an order :( Hi. I wanted to use order_editor to edit my orders - as the normal OSC order editor can't handle shipping without a VAT charge. I edited an order - but now the ot_tax entry in the orders_total table is missing for that order :( I tried searching this thread for notes on this, but I can't figure out how to see which (of the 29 pages - with many posts on each) actually mentions ot_tax.. Anyone know how to see the posts in this thread, that mentions ot_tax ? Any help is appreciated - I am a programmer - I'm just not experienced with the order_editor code.. I was hoping someone could give me a pointer. I'll glady insert trigger_error("whatever info you want",E_USER_WARNING); lines in the code to pull out data that could help.

I have a problem I actually thought QTpro solved, but I can't see how - so I'm going to "throw it outthere" to see if you have any idea how I can solve this :) I have an item which has 2 option types: subscription type, and subscription period. My problem is that, I want the price to differ, depending on both. ie. subscriptiontype1 has a price for a 1 year period and a 2 year period. subscriptiontype2 has a different(!) price for a 1 year period and 2 year period. This means I need some sort of "correlation" between options, and differing in price, depending on which was chosen. Would be no problem if all options were simply shown in 1 dropdown. I know qtpro does it in regards to stock, but how do I do the same (it seems to be the same) with prices on options?

No, I simply didn't have that one - and for some reason I missed it when I diff'ed for differences :(

It seems I fixed it by adding a } right before this line: // Update products_ordered (for bestsellers list) I just hope that didn't "screw" with the logic :)

I just tried to simply replace my checkout_process.php with the one included in qtpro4.0 package - and it fails the exact same way. IE. it's a bug in the qtpro4.0 example :( PHP Parse error: parse error, unexpected T_ELSE in /www/customers/linuxpusher2/html/checkout_process.php on line 199 (it's line 199 - because it's the original file - no longer my own file). I use php-4.3.10. Anyone have a checkout_process.php file that works for them? I'd like to see it, and compare it to the one in qtpro4.0.

OOPS (thought it worked). I copy'pasted from qtpro4 - but it still complains on the exact same line - so something must be up.. I've put the file here: http://vsen.dk/files/checkout_process.php.txt it's line 251 as before :( I hope to get my shop ready soon - then I'll start on looking at writing other options, than the "drop-down" - so qtpro4 can be made to support the same as the "option type feature" enables (which does not support qtpro4). If anyone succeedes in adding another "option type" for qtpro (which seems much easier - using Ralph's clever plugin design) I would very much like it if you'd share the code.. with small "intro" how to merge with qtpro4.0.

They are completely different things - which can complement each other. master products allows you to show products, as sub-products on a products page - nothing else. qtpro allows you to add stock control of options to a product (not the same as sub-products! - you should know options already - as they are in the base OSC)

Hi, Have an odd error, I can't see could ever have worked -but I can't figure out to fix it either.. hope you could shed some light on it.. PHP Parse error: parse error, unexpected T_ELSE in /www/customers/linuxpusher2/html/checkout_process.php on line 251 and my line 251 looks like this (it's the one with --line251--> in the beginning :) //++++ QT Pro: Begin Changed code $actual_stock_bought = $order->products[$i]['qty']; } else { if (is_array($products_attributes)) { $all_nonstocked = true; $products_stock_attributes_array = array(); foreach ($products_attributes as $attribute) { if ($attribute['track_stock'] == 1) { $products_stock_attributes_array[] = $attribute['option_id'] . "-" . $attribute['value_id']; $all_nonstocked = false; } if ($all_nonstocked) { $actual_stock_bought = $order->products[$i]['qty']; } else { asort($products_stock_attributes_array, SORT_NUMERIC); $products_stock_attributes = implode(",", $products_stock_attributes_array); $attributes_stock_query = tep_db_query("select products_stock_quantity from " . TABLE_PRODUCTS_STOCK . " where products_stock_attributes = '$products_stock_attributes' AND products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"); if (tep_db_num_rows($attributes_stock_query) > 0) { $attributes_stock_values = tep_db_fetch_array($attributes_stock_query); $attributes_stock_left = $attributes_stock_values['products_stock_quantity'] - $order->products[$i]['qty']; tep_db_query("update " . TABLE_PRODUCTS_STOCK . " set products_stock_quantity = '" . $attributes_stock_left . "' where products_stock_attributes = '$products_stock_attributes' AND products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"); $actual_stock_bought = ($attributes_stock_left < 1) ? $attributes_stock_values['products_stock_quantity'] : $order->products[$i]['qty']; } else { $attributes_stock_left = 0 - $order->products[$i]['qty']; tep_db_query("insert into " . TABLE_PRODUCTS_STOCK . " (products_id, products_stock_attributes, products_stock_quantity) values ('" . tep_get_prid($order->products[$i]['id']) . "', '" . $products_stock_attributes . "', '" . $attributes_stock_left . "')"); $actual_stock_bought = 0; } } --line251--> else { $actual_stock_bought = $order->products[$i]['qty']; } //++++ QT Pro: End Changed Code

Any other "known bugs" we should know about ? ;)

read the message - Table 'testshop.TABLE_PRODUCTS_STOCK' doesn't exist.. hmm. I'm pretty sure it doesn't. Shouldn't TABLE_PRODUCTS_STOCK have been "converted" to the actual table name? Where is this done.. hmm. try looking at includes/database_tables.php (or whatever it's name is).. ;)

If you could post exactly(!) what part of the install.txt (linenumbers pls.) you have problems with, perhaps we can help. Also - you do know how to use diff? (or some windows diff program if you use windows). That's how I did it. diff with -bduNr options.

I found the problem. The contribution creates lists with the language ID chosen in the admin. But when the admin is in english - and the user is in danish - they don't see the newsletters (as they don't exist for the chosen language). IMHO my proposed solution, would be to add a "language selection" box, to the newsletter - which would contain the enabled languages, AND a "All Languages" having the value of 0 - indicating it was valid for all languages.

Hi guys, I was heavily missing a forum for discussing the "newsindex" aka. Multiple Newsletters contribution. http://www.oscommerce.com/community/contributions,2445 This contribution allows you to create an arbitrary amount of newsletters, with an indication of a type. This type indication, makes it a good candidate for further developments, such as creating a newsletter of the type "MailMan List" - which when you send a mail to that list, it will do it through mailman (I'm going to code this feature - cause I need it :) Also - one might consider merging this, and the contrib that allows none-users to subscribe to your newsletter http://www.oscommerce.com/community/contributions,535 I currently have a "small" problem with this contrib, as it does NOT show the newsletters in the account_newsletters.php file as it should (it simply returns blank). everything else seems(!) to work fine. All help is appreciated.

Just to get my last post in 2004 in ;) - has the admin side of qtpro changed from 3.1 to 4? (just before I rip out qtpro-3.1 to integrate qtpro-4 :)

It just dawned on me that you (or someone else) might think I was just bitching - so I just wanted to assert, that the reason I'm having to do the "crap job", is ofcourse because qtpro4 is sooo great (it really is), that I think it's worth it :) IMHO QTPro4 should be added to 2.2MS3-CVS, as it is definetely a much needed feature, AND IMHO the plugins structure and the javascript-that makes sure customers can't order, what isn't in stock is REALLY REALLY BRILLIANT. If anyone knows somewhere to suggest to the devs to look at qtpro4, I'd gladly do it. I'll start with ripping out my own integration work (back to scratch on product_info.php :) and then I'll learn to write plugins, by writing a static options plugin, that works like the static options contrib does now (so it will work with "compare options" contribution as the orig does) - and that'll hopefully make some users happy :) Have a great new year.

I'll get started "ripping" option type feature and static options out of my code (crap job - took me some time to integrate static options and option type feature :) - so I can integrate qtpro4 and then hopefully someone have the time, so I (and perhaps others needs this too?) can pay them to do it :)

Ofcourse - that's understandable. Perhaps someone else who has the time, could use the money :) I'm sure I could figure it out myself too - but even though you've written a good proposal, as to how it should be implemented, I'm not so well-versed in QTPro code, that I feel confident that I could write those plugins (incl. the javascript - which I'm not good at) within a few days..

I'd gladly support (with US$) the development of a merged contrib, option type feature + qtpro4 (and perhaps static options too - just to bee feature complete smile.gif (any other mods that fit in with these? perhaps others with the same need can come forward and say if you need anything other than this - and we could collect a bunch of $ to pay to any dev who has the time and php/osc-experience to do this. in QTpro 4, the dev(ralph) has already written how we would propose it should be implemented - and he has changed qtpro to use plugins - so one could write plugins for option type feature.. perhaps he'd even be interested in this job..

Anyone got Option Type Feature merged with qtpro 4? those two contribs together, would be a SUPERB contribution. It's very annoying that I can't use Option Type Feature to add one item for a T-shirt - and then attributes (options) for sizes. Without QTPro - I can't keep track of my stock - and I risk my customers ordering something I don't have in stock - and I have to remove options, as they go out of stock and add them again when they're in stock :( I'd gladly support (with US$) the development of a merged contrib, option type feature + qtpro4 (and perhaps static options too - just to bee feature complete :) (any other mods that fit in with these? perhaps others with the same need can come forward and say if you need anything other than this - and we could collect a bunch of $ to pay to any dev who has the time and php/osc-experience to do this. in QTpro 4, the dev has already written how we would propose it should be implemented - and he has changed qtpro to use plugins - so one could write plugins for option type feature.. perhaps he'd even be interested in this job..

Anyone got qtpro4 working with "option type" contribution? I must say, it looks like a daunting task to merge the two - but what a great feature that would be.

tep_check_stock_new() - find that in qtpro40 source- make sure you have it (you do not have it - atleast not in the right place).

Hi guys, Just found this mod - that divides the "Product attributes" page into 3 pages (instead of the product attributes page being divided into three parts on same page) - seems really good - and with all those options type, static attributes etc. It isn't a bad idea :) http://www.oscommerce.com/community/contri...ll/search,links (an idea for inclusion in qtpro perhaps - so The One product options/attributes contrib could be created - qt pro is almost there :)

I tend to agree with hobbyhen - although I would think static options should be added too. The nice things about all these attribute/option addons is that they are something the site-admin can choose to use or not. so they are only an extra option - not something he's forced to use. I am rather fond of freedom of choice - and if we can give qtpro users the freedom to easily choose to use some of all the other option/attribute options - then that's definetely worth doing. In regards to the comments on other people having modded their own product_info.php etc. I'll say that if all the great attribute/option type features mentioned by hobbyhen and me is included - I can see no other mods (most if not any) can have added - other than design changes - which no matter what, will be simpler to merge in again - than merging X contributions with qtpro :) Just my 5 cent..

Hi - I just dl'ed qtpro4 - GREAT options. I am however VERY sorry that you yourself has no use for Option Types and static options and attributes copier contributions (because I do very much - and if you used them - you'd probably had included products_info.php etc. files in a Option types,static options version ;) if anyone who has the need for these with qtpro4 and manage to get it working - or perhaps want to work on it with me I would be very happy to hear from you. I'm not "into" OSC code enough to believe in myself enough to take the merging of qtpro4 with Option types and static options upon myself, just yet :) This would be sooo much easier if OSC was templates - so one could worry about the data manipulation first - and then handle the layout logic seperately :) I believe that's part of MS3 plans. It would be much easier to merge contributions if OSC was templated properly. (and BTS does not make it easier - because almost no contributions are written for it - so you have to convert them all to BTS - and THEN merge them). if OSC MS3 is templateable - every contribution will be easily mergeable to that... Enough mumbling :)

Hi guys, I'm very interested in QTPro - can't understand why OSCommerce supports options and not a different stock pr. option (most options has seperate stock obviously :) - but great QTPro is there. I'm also using Product_options_type (selectlist,radio etc. option types) and static options. I've merged in QTPro like this: $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix, pa.options_id, pa.options_values_id from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'"); echo '<table border="0" cellspacing="0" cellpadding="2"> '; while ($products_options = tep_db_fetch_array($products_options_query)) { //START get attribute stock values/show out of stock QTPro if (!$products_options_name['special']) { $attribute_stock_query = tep_db_query("select products_stock_quantity from " . TABLE_PRODUCTS_STOCK . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' AND products_stock_attributes REGEXP '(^|,)" . (int)$products_options['options_id'] . "-" . (int)$products_options['options_values_id']. "(,|$)' AND products_stock_quantity > 0"); $attrstock=tep_db_num_rows($attribute_stock_query); } // END get attribute stock values/show out of stock $static_attribute = false; if($products_options_name['products_options_is_static'] == '0'){ if ($attrstock == 0) $products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => " Out Of Stock - ".$products_options['products_options_values_name']); else ...(same as it was before). Only problem is, that I'm testing this on the matrox G200 MMS item from default shop (see here: http://www.ebutikdemo.minebutik.dk/product...4&products_id=1 ) and I've set the stock to be like this: Value 4 mb 1 Value 8 mb 0 Premium 4 mb 0 Premium 8 mb 4 ie. Premium 8mb should be in stock and premium 4mb should not - but on the product page, when I switch to premium it does not work - as 4mb is set to be in stock. The problem it would seem is that the Memory table, is not updated when I switch value to premium. Would it be best to "merge all selectlist options" - or is there some javascript one can use to "update" the table?