Jump to content


  • Content count

  • Joined

  • Last visited

Everything posted by Zappo

  1. Zappo

    Seperate Pricing Per Customer v3.5

    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. Zappo

    Fancier Invoice & Packingslip v1.0

    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 and // 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: require(DIR_FS_ADMIN . DIR_WS_LANGUAGES . $language . "/" . FILENAME_ORDERS_INVOICE); 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']; Done! Seems to work perfectly, and keeps the store's email notifications 'in Sync' (did this also with the Dutch iDEAL payment plugin (iDealm)
  3. Zappo

    Seperate Pricing Per Customer v3.5

    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. Zappo

    Seperate Pricing Per Customer v3.5

    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)??? Thanx, Albert
  5. Zappo

    e-gold payment Module

    Ever hear of SEARCHING?!?!? Just going to the Contributions Section, and doing a Search for "eGold" gave me 2 results... http://www.oscommerce.com/community?contri...mp;category=all There ya go...
  6. Zappo

    Master Products - MS2

    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. P.S. Ask away, :thumbsup: no harm in that!
  7. 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...
  8. It would be nice to post the solution to your problems, just in case someone runs into the same problem! Don't you think it's fair that when you're asking for help, to provide some help yourself when you can? (Don't mean to be naggin' all the time ;) )
  9. Zappo

    Master Products - MS2

    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.
  10. Zappo

    Master Products - MS2

    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.
  11. 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!
  12. 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.
  13. 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"> <tr> <td><?php echo $messageStack->output('upload'); ?></td> </tr> <?php 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?
  14. 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.
  15. 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) Regards, Albert
  16. I'm gonna try placing both additions after each other, and add the ", $real_ids" after the "$attributes" (donno if I'm gonna do that twice tho...) Need to finish editing the other files first, then troubleshoot (probably :D )
  17. I currently have modified/added the code from the following Option Feature Files: product_info.php shopping_cart.php checkout_process.php And am currently working on includes/application_top where I have the following problem: QTPro File: //++++ QT Pro: Begin Changed code $attributes=array(); if (isset($HTTP_POST_VARS['attrcomb']) && (preg_match("/^\d{1,10}-\d{1,10}(,\d{1,10}-\d{1,10})*$/",$HTTP_POST_VARS['attrcomb']))) { $attrlist=explode(',',$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) $attributes[$oid]=$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'); $products_options_file->set_destination(DIR_FS_UPLOADS); 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; $products_options_file->set_filename("$insert_id"); if (!($products_options_file->save())) { break 2; } } else { break 2; } } else { // No file uploaded -- use previous value $real_ids[TEXT_PREFIX . $HTTP_POST_VARS[UPLOAD_PREFIX . $i]] = $HTTP_POST_VARS[TEXT_PREFIX . UPLOAD_PREFIX . $i]; } } } $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.... Regards, Albert
  18. Ow, and for many product_info.php changes, I've had to go for adding them to includes/classes/pad_base.php (because creating a new product attribute display plugin is beyond my comprehension...)
  19. 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... Greetings, Albert Whoops! Double post there; forgot the closing (code)'s
  20. -------------Text Deleted to save some room-------------
  21. Zappo

    Is there a better way?

    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) Greetings, Zappo