Jump to content


  • Content count

  • Joined

  • Last visited

Posts posted by Zappo

  1. Just revisited this contribution because of an osC update, and I see there have been some descent (dB) changes since version 1.2!!!


    I just don't see what all the Database tables are for... Could someone explain what these tables are for:

    - products_group_(x) (auto generated - Which doesn't seem to happen with my store)

    - specials_retail_prices (Which doesn't seem to hold data with my store)


    Seems to me, all data can be (or even IS) stored in the existing "products_groups" and "specials" tables...

    Am I missing something?

  2. jesus dude, I know what the contribution does, I have it installed and working on my store, I'm asking what other people use as their payment gateway instead of Paypal's IPN with THIS contribution, if every other payment module other than Paypals IPN work perfectly with this contribution then say so, and maybe suggest one that has a populate function.


    If someone else is also looking for an alternative payment module to work this contribution I'm sure they would also look on this thread, I'm not going to start a new topic called "I can't use Paypal IPN with my Fancy Invoice & Packingslip Contribuiton what do u guys use as an alternative?" because you don't think it has anything to do with this contribution.


    Be constructive <_<


    I just edited catalog/includes/modules/payment/paypal_standard.php

    Replaced all standard stuff with the Fancier Invoice stuff in the file...

    If I remember correctly, between the lines:

    // initialized for the email confirmation


    // load the after_process function from the payment modules

    Replace everything with the code from catalog/includes/modules/email_invoice/email_invoice.php


    Then, in the newly pasted text from email_invoice.php, BEFORE the line:


    ADD (to get language name):

    	$language_query = tep_db_query("select directory from " . TABLE_LANGUAGES . " where languages_id = '" . $languages_id . "'");
    $language_array = tep_db_fetch_array($language_query);
    $language = $language_array['directory'];



    Seems to work perfectly, and keeps the store's email notifications 'in Sync' (did this also with the Dutch iDEAL payment plugin (iDealm)

  3. Replacing $order->products[$i]['tax'] with '0' or '' should work (haven't tried it).


    Probably the sub total will be more problematic. I think you would have to adapt includes/modules/order_total/ot_subtotal.php where it is processed in function process.


    Yep, X-actly like you said Jan:

    Products are now Displayed without tax, AND the SubTotal is Problematic.


    I'll go in the Order_Total Functions, and change it there (As I do want it like that for every customer(group))


    Thanks for the help so far!

  4. The quantity prices for retail customers are displayed throughout the site with sales tax included. It also displays the total amount with tax, but shows the tax ammount seperately in the order confirmation area. See pic..




    In the picture you can see that the Sub-Total already includes the tax, then the tax line item shows the tax amount (it is not added to the sub-total).


    I have this exact same problem.

    Retail prices are good (including tax) everywhere in the store, I just want to "split them up" on the Order Confirmation page:

    Product Prices --> Excluding Tax

    Sub-Total Price --> Excluding Tax

    Total Tax displayed seperately

    Total price --> Including Tax


    For Customer Groups having setting "Display without Tax" the above is done correctly.


    Anyone know a solution (or where to start looking)???



  5. Hi There.

    I've just set up Master Products for my shop to sell mp3 downloads.

    I am using the slaves as tracks on an album (which is the master)

    When choosing quantities for each track, would it be possible to set

    the default to 0 rather that 1?

    better still change it to a drop down (like the master) and limit it to

    0 or 1?

    or better still .....sorry.... just turn it into a check box (i'm sure people don't want to

    download multiple copies of mp3s!)


    i think i'm asking too many questions here, so i apologise...





    Hi "Primaudial"


    I can't seem to find it in a "normal" way, but try this adress: http://forums.oscommerce.com/lofiversion/i...67284-1350.html (I search the forums with Google: Much more accurate results)

    Your question seems to be answered before, somewhere in this topic's 89!!!! Pages...


    Hope this helps.



    Ask away, :thumbsup: no harm in that!

  6. Ok i am not getting the error now i changed the image/upload.php file permissions to 777 now the problem is its trying to upload the image but its not actually uploading it and the checkout isn't show it but i guess that's because its not actually uploaded to images/upload.php.


    Can someone please point me in the right direction


    Thank you




    May be a stupid question, but did you upload all the NEW files too? (not just the changed ones? --> Thinking of upload.php)

    I'm still working on adding another contrib, and will have a crack at this one soon, so I hope I can then assist you better...

  7. Just to clarify:

    The only thing I need, is when a Slave is put in the cart, I can see what Master it was selected from. (Same way you can see what attributes were selected)

    Later on I want to add Slave Option Type Attributes, but I've seen solutions for that already.

  8. WooHoo!!!... Finally got everything installed (thanks all) and at first glance seems to be working.


    I am starting up a T-Shirt site and will be matching the design transfer to the t-shirt after sale. I would like to have OSC track inventory on each.


    I gave qty 1 to both a test master design (no cost) and test slave shirt (costed & hidden) and ran them through a sale, I now have the following issue...


    Only slave showed in the invoice, packing list, and reduced inventory.


    1] There is no way to tell what design the customer was wanting.

    2] Master did not reduce inventory.


    Is this the way Master Products is intended to work, or is there an issue with it?




    I'm in need of the exact same functionality. (Did you ever figure it out, DailyLunatic?)

    I have a shop where I produce Crystal Blocks, with all kinds of engravings inside.

    I do not need "Master Inventory Tracking" though, because all my designs are digital, and I can't run out of those.


    But I do want to be able to use the Slaves to represent Crystal Block shapes, so I can use these products on a lot of different Masters.

    This way the quantities of the Slaves (the Crystal blocks) are always correct, no matter what Master (what design) was sold.


    Any help is much appreciated.

  9. Hmmmm.... Goed idee!


    I'd like this as well!

    I'd like to be able to have some custom products, with which the price depends on the customers wishes, and the amount of products to be ordered...


    Being able to react through the admin would be great, but I can imagine this is a bit much to ask.

    Just receiving an e-mail with the "Offer Request" would be a great start!

  10. I spent a week to figuring out what's wrong in my case.

    I realised that this contrib is incompatible with Master Prod contribution.

    And no one wrote a reply to my post so I gave up.


    That's pretty stupid right there.

    Do you really think someone is going to download your files to check the entire code for faults?

    My own admin-categories.php file has 2300 lines of code! No way I'm gonna check your file!

    I have this contrib working with Master Products (which actually was quite easy using KDiff) so it is compatible. (I think everything is, if you take the time and have some knowledge)

    I believe there were some lines that had to be added twice for UltraPics (something with "case 'new_product_preview'" and "case 'new_master_preview'")


    I copy and paste a lot too, and just doing that I can't help but getting some idea of what the code does.


    Just compare: 1. the original file, 2. the file you want to add and 3. the file you want to add to with a comparison tool (I like to use KDiff)

    Relax, take the time, save the stuff you Know you did right, and play around with the rest.

    You can figure it out.

  11. Anyone have this working well with master products?


    I'm also trying to combine these contributions.

    At least one problem is in the following code:

       <td width="100%" valign="top"><?php echo tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=add_product'), 'post', 'enctype="multipart/form-data"'); ?><table border="0" width="100%" cellspacing="0" cellpadding="0">
           <td><?php echo $messageStack->output('upload'); ?></td>

    To be combined with:

    <?php  echo '<form name="buy_now_" method="post" action="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=add_slave', 'NONSSL') . '">'; ?><table border="0" width="100%" cellspacing="0" cellpadding="0">


    Anyone got the Upload Feature working with Master Producs?

  12. Phffffff....


    I've tried all kind of things, but didn't get any decent results...

    One of the bigger problems is that I have no idea what file (or files) the problem could be in.

    Also, I've installed QTPro, UltraPics, ActualAttributePrices, and Attribute Sorter and Copier before attempting this. Could be a conflict between one of those too...


    I'm putting this to rest for now, as I don't seem to be getting anywhere.

  13. First try, first error:


    1146 - Table 'osCommerce.TABLE_PRODUCTS_OPTIONS_TYPES' doesn't exist
    select products_options_types_id, products_options_types_name from TABLE_PRODUCTS_OPTIONS_TYPES where language_id='4' order by products_options_types_id
    [TEP STOP]

    This occurs when in control panel, trying to go to product_attributes.


    I actually think I merged everything fine, except the "$cart->add_cart" problem I ran into above... (although that seems to have nothing to do with product_attributes.php)

    I eventually placed both filechanges after each other, except for the "$cart->add_cart"-line.

    In that last line I replaced the last $attributes with $real_ids


    Gonna try some other combo's on that file now (after a quick forum-check on the error message)




  14. I currently have modified/added the code from the following Option Feature Files:




    And am currently working on includes/application_top where I have the following problem:

    QTPro File:

    //++++ QT Pro: Begin Changed code
    							if (isset($HTTP_POST_VARS['attrcomb']) && (preg_match("/^\d{1,10}-\d{1,10}(,\d{1,10}-\d{1,10})*$/",$HTTP_POST_VARS['attrcomb']))) {
    							  foreach ($attrlist as $attr) {
    								list($oid, $oval)=explode('-',$attr);
    								if (is_numeric($oid) && $oid==(int)$oid && is_numeric($oval) && $oval==(int)$oval)
    							if (isset($HTTP_POST_VARS['id']) && is_array($HTTP_POST_VARS['id'])) {
    							  foreach ($HTTP_POST_VARS['id'] as $key=>$val) {
    								if (is_numeric($key) && $key==(int)$key && is_numeric($val) && $val==(int)$val)
    								  $attributes=$attributes + $HTTP_POST_VARS['id'];
    							$cart->add_cart($HTTP_POST_VARS['products_id'], $cart->get_quantity(tep_get_uprid($HTTP_POST_VARS['products_id'], $attributes))+1, $attributes);
    //++++ QT Pro: End Changed Code


    And the Option Feature File:

    // iii 030813 added: File uploading: save uploaded files with unique file names
    	  $real_ids = $HTTP_POST_VARS['id'];
    	  if ($HTTP_POST_VARS['number_of_uploads'] > 0) {
    		require(DIR_WS_CLASSES . 'upload.php');
    		for ($i = 1; $i <= $HTTP_POST_VARS['number_of_uploads']; $i++) {
    		  if (tep_not_null($_FILES['id']['tmp_name'][TEXT_PREFIX . $HTTP_POST_VARS[UPLOAD_PREFIX . $i]]) and ($_FILES['id']['tmp_name'][TEXT_PREFIX . $HTTP_POST_VARS[UPLOAD_PREFIX . $i]] != 'none')) {
    			$products_options_file = new upload('id');
    			if ($products_options_file->parse(TEXT_PREFIX . $HTTP_POST_VARS[UPLOAD_PREFIX . $i])) {
    			  if (tep_session_is_registered('customer_id')) {
    				tep_db_query("insert into " . TABLE_FILES_UPLOADED . " (sesskey, customers_id, files_uploaded_name) values('" . tep_session_id() . "', '" . $customer_id . "', '" . tep_db_input($products_options_file->filename) . "')");
    			  } else {
    				tep_db_query("insert into " . TABLE_FILES_UPLOADED . " (sesskey, files_uploaded_name) values('" . tep_session_id() . "', '" . tep_db_input($products_options_file->filename) . "')");
    			  $insert_id = tep_db_insert_id();
    			  $real_ids[TEXT_PREFIX . $HTTP_POST_VARS[UPLOAD_PREFIX . $i]] = $insert_id . ". " . $products_options_file->filename;
    			  if (!($products_options_file->save())) {
    				break 2;
    			} else {
    			  break 2;
    		  } else { // No file uploaded -- use previous value
    	  $cart->add_cart($HTTP_POST_VARS['products_id'], $cart->get_quantity(tep_get_uprid($HTTP_POST_VARS['products_id'], $real_ids))+1, $real_ids);
    // iii 030813 end of changes.


    In this case I don't know if I can just combine these as I did the above example, as the in the original file the last line of code is as follows:

    $cart->add_cart($HTTP_POST_VARS['products_id'], $cart->get_quantity(tep_get_uprid($HTTP_POST_VARS['products_id'], $HTTP_POST_VARS['id']))+1, $HTTP_POST_VARS['id']);

    In this case the code has been replaced, and I don't think just adding the "$real_ids" to the "$attributes" thingy would work....




  15. Hi there,


    I'm trying to combine QTpro and Option Type Feature (probably a fool's errand but I do like a challenge :)


    Right off the bat it's going places I don't know how to take it so I'm hoping someone here would be willing to give me a quick lesson in syntax.


    Here's the problem:


    In QTpro for the admin products_attributes.php it specifies this update on line 109

    tep_db_query("update " . TABLE_PRODUCTS_OPTIONS . " set products_options_track_stock='" . (int)$track_stock . "',products_options_name = '" . tep_db_input($option_name) . "' where products_options_id = '" . (int)$option_id . "' and language_id = '" . (int)$languages[$i]['id'] . "'");


    In Option Type Feature

    tep_db_query("update " . TABLE_PRODUCTS_OPTIONS . " set products_options_name = '" . tep_db_input($option_name) . "', products_options_type = '" . $option_type . "', products_options_length = '" . $option_length . "', products_options_comment = '" . $option_comment[$languages[$i]['id']] . "' where products_options_id = '" . (int)$option_id . "' and language_id = '" . (int)$languages[$i]['id'] . "'");


    So the question is how to go about combining these two statements? Or do I need to create a third "set some_option" to replace these two and then modify both contribs to use the value so they'll be happy? Or is there a third option I just don't know of?


    Thanks for any light you can shine on the subject or knowlegde you'd like to impart :lol:




    Hello Iggy,

    I'm joining you in your quest!


    I found a similar problem on line 58 (Or somewhat nearby --> I've installed more cotribs)


    Here are the Original code, the QTPro code, and the Option Feature code after each other:

    tep_db_query("insert into " . TABLE_PRODUCTS_OPTIONS . " (products_options_id, products_options_name, language_id) values ('" . (int)$products_options_id . "', '" . tep_db_input($option_name) . "', '" . (int)$languages[$i]['id'] . "')");
    tep_db_query("insert into " . TABLE_PRODUCTS_OPTIONS . " (products_options_id, products_options_name, language_id,products_options_track_stock) values ('" . (int)$products_options_id . "', '" . tep_db_input($option_name) . "', '" . (int)$languages[$i]['id'] . "', '" . (int)$track_stock . "')");
    tep_db_query("insert into " . TABLE_PRODUCTS_OPTIONS . " (products_options_id, products_options_name, language_id, products_options_type) values ('" . (int)$products_options_id . "', '" . tep_db_input($option_name) . "', '" . (int)$languages[$i]['id'] . "', '" . $option_type . "')");


    And I'll Merge this as follows:

    tep_db_query("insert into " . TABLE_PRODUCTS_OPTIONS . " (products_options_id, products_options_name, language_id, products_options_track_stock, products_options_type) values ('" . (int)$products_options_id . "', '" . tep_db_input($option_name) . "', '" . (int)$languages[$i]['id'] . "', '" . (int)$track_stock . "', '" . $option_type . "')");


    The trick here is in the original code, and comparing it against:

    1. The code that needs to be added

    2. The code you have at that moment (with other contribs as well)

    3. The original QTPro code (sometimes) to see what other contribs have changed...


    See what QTPro has changed, and if you could add to that. Sometimes QTPro REPLACES stuff, and that's when things can become complicated...

    Mind you, I'm JOINING you in your quest, and haven't tested anything yet. This just seems logical to me...





    Whoops! Double post there; forgot the closing (code)'s

  16. I'm having the same problem: I sell Crystal Blocks, with images engraved inside. (I engrave them myself)

    I AM using QTPro, along with other contrib's and work like this:

    - I made "standard" products (blocks shapes in my case, T-shirt colors in yours) as Iggy suggested, and added Attribute-options (Image and/or text in my case, Print-Design in yours)

    - For the different shirt sizes, you'll have to add those as standard products too. (I did this for every size and shape of Crystal I have, instead of (what you and I would prefer, a dropdown with sizes)

    - Then added the Contrib "UltraPics" to show some examples on the product's page (different designs, Skull and Butterfly)


    You'll have quite a boring list of products (each size/color combination is a product) and the option to add different example pictures (different designs) with each product.

    Customers look for the preferred size and color, and can choose the design on the product Page.

    You can now track stock on all the Shirts (which was important with my store, as I have osCommerce linked with my Accounting Software (osFinancials))

    And you should be able (I only have digital Attribute-options) to track the Designs through Attribute tracking.


    This works for me, although not ideal...


    What would REALLY do it, is being able to use "Phantom" or invisible products as Attributes (so they can be dropped down as an option on another product)