Jump to content


  • Content count

  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    Jon Cloud
  • Website
  1. JonCloud

    Easypopulate & Bulk Pricing

    Search the contributions section. I am sure there is somthing for this, or at least somthing close. I am using OscMAX, which has a field for entering the wholesale price when you add a product. So it at least gets it in the database. Also, it has a contribution in it, I think it is "seperate price per customer", which allows you to have both wholesale and retail customers. Hope that helps. JonCloud
  2. JonCloud

    Google Checkout Level 2

    Looks pretty good to me. Heres the page code, maybe somthing else will jump out at you. <code><!--- Google Checkout Start---> <?php require(DIR_WS_FUNCTIONS . 'GlobalAPIFunctions.php'); ?> <?php require(DIR_WS_FUNCTIONS . 'CheckoutAPIFunctions.php'); ?> <!--- Google Checkout End ---> <!-- body //--> <?php echo tep_draw_form('cart_quantity', tep_href_link(FILENAME_SHOPPING_CART, 'action=update_product')); ?><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> <td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_cart.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php if ($cart->count_contents() > 0) { ?> <tr> <td class="infoBoxHeading"> <?php $info_box_contents = array(); $info_box_contents[0][] = array('align' => 'center', 'params' => 'class="productListing-heading"', 'text' => TABLE_HEADING_REMOVE); $info_box_contents[0][] = array('params' => 'class="productListing-heading"', 'text' => TABLE_HEADING_PRODUCTS); $info_box_contents[0][] = array('align' => 'center', 'params' => 'class="productListing-heading"', 'text' => TABLE_HEADING_QUANTITY); $info_box_contents[0][] = array('align' => 'right', 'params' => 'class="productListing-heading"', 'text' => TABLE_HEADING_TOTAL); $any_out_of_stock = 0; $products = $cart->get_products(); for ($i=0, $n=sizeof($products); $i<$n; $i++) { // Push all attributes information in an array if (isset($products[$i]['attributes']) && is_array($products[$i]['attributes'])) { while (list($option, $value) = each($products[$i]['attributes'])) { echo tep_draw_hidden_field('id[' . $products[$i]['id'] . '][' . $option . ']', $value); //++++ QT Pro: Begin Changed code $attributes = tep_db_query("select popt.products_options_name, popt.products_options_track_stock, poval.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_OPTIONS_VALUES . " poval, " . TABLE_PRODUCTS_ATTRIBUTES . " pa where pa.products_id = '" . $products[$i]['id'] . "' and pa.options_id = '" . $option . "' and pa.options_id = popt.products_options_id and pa.options_values_id = '" . $value . "' and pa.options_values_id = poval.products_options_values_id and popt.language_id = '" . $languages_id . "' and poval.language_id = '" . $languages_id . "'"); //++++ QT Pro: End Changed Code $attributes_values = tep_db_fetch_array($attributes); $products[$i][$option]['products_options_name'] = $attributes_values['products_options_name']; $products[$i][$option]['options_values_id'] = $value; $products[$i][$option]['products_options_values_name'] = $attributes_values['products_options_values_name']; $products[$i][$option]['options_values_price'] = $attributes_values['options_values_price']; $products[$i][$option]['price_prefix'] = $attributes_values['price_prefix']; //++++ QT Pro: Begin Changed code $products[$i][$option]['track_stock'] = $attributes_values['products_options_track_stock']; //++++ QT Pro: End Changed Code } } } for ($i=0, $n=sizeof($products); $i<$n; $i++) { if (($i/2) == floor($i/2)) { $info_box_contents[] = array('params' => 'class="productListing-even"'); } else { $info_box_contents[] = array('params' => 'class="productListing-odd"'); } $cur_row = sizeof($info_box_contents) - 1; $info_box_contents[$cur_row][] = array('align' => 'center', 'params' => 'class="productListing-data" valign="top"', 'text' => tep_draw_checkbox_field('cart_delete[]', $products[$i]['id'])); $products_name = '<table border="0" cellspacing="2" cellpadding="2">' . ' <tr>' . ' <td class="productListing-data" align="center"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products[$i]['id']) . '">' . tep_image(DIR_WS_IMAGES . $products[$i]['image'], $products[$i]['name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a></td>' . ' <td class="productListing-data" valign="top"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products[$i]['id']) . '"><b>' . $products[$i]['name'] . '</b></a>'; if (STOCK_CHECK == 'true') { //++++ QT Pro: Begin Changed code if (isset($products[$i]['attributes']) && is_array($products[$i]['attributes'])) { $stock_check = tep_check_stock($products[$i]['id'], $products[$i]['quantity'], $products[$i]['attributes']); }else{ $stock_check = tep_check_stock($products[$i]['id'], $products[$i]['quantity']); } //++++ QT Pro: End Changed Code if (tep_not_null($stock_check)) { $any_out_of_stock = 1; $products_name .= $stock_check; } } if (isset($products[$i]['attributes']) && is_array($products[$i]['attributes'])) { reset($products[$i]['attributes']); while (list($option, $value) = each($products[$i]['attributes'])) { $products_name .= '<br><small><i> - ' . $products[$i][$option]['products_options_name'] . ' ' . $products[$i][$option]['products_options_values_name'] . '</i></small>'; } } $products_name .= ' </td>' . ' </tr>' . '</table>'; $info_box_contents[$cur_row][] = array('params' => 'class="productListing-data"', 'text' => $products_name); $info_box_contents[$cur_row][] = array('align' => 'center', 'params' => 'class="productListing-data" valign="top"', 'text' => tep_draw_input_field('cart_quantity[]', $products[$i]['quantity'], 'size="4"') . tep_draw_hidden_field('products_id[]', $products[$i]['id'])); $info_box_contents[$cur_row][] = array('align' => 'right', 'params' => 'class="productListing-data" valign="top"', 'text' => '<b>' . $currencies->display_price($products[$i]['final_price'], tep_get_tax_rate($products[$i]['tax_class_id']), $products[$i]['quantity']) . '</b>'); } //Google Checkout Start include("Google_Item_Code.php"); //Google Checkout End } new productListingBox($info_box_contents); ?> </td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td align="right" class="main"><b><?php echo SUB_TITLE_SUB_TOTAL; ?> <?php echo $currencies->format($cart->show_total()); ?></b></td> </tr> <?php if ($any_out_of_stock == 1) { if (STOCK_ALLOW_CHECKOUT == 'true') { ?> <tr> <td class="stockWarning" align="center"><br><?php echo OUT_OF_STOCK_CAN_CHECKOUT; ?></td> </tr> <?php } else { ?> <tr> <td class="stockWarning" align="center"><br><?php echo OUT_OF_STOCK_CANT_CHECKOUT; ?></td> </tr> <?php } } ?> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox"> <tr class="infoBoxContents"> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td class="main"><?php echo tep_image_submit('button_update_cart.gif', IMAGE_BUTTON_UPDATE_CART); ?></td> <?php $back = sizeof($navigation->path)-2; if (isset($navigation->path[$back])) { ?> <td class="main"><?php echo '<a href="' . tep_href_link($navigation->path[$back]['page'], tep_array_to_string($navigation->path[$back]['get'], array('action')), $navigation->path[$back]['mode']) . '">' . tep_image_button('button_continue_shopping.gif', IMAGE_BUTTON_CONTINUE_SHOPPING) . '</a>'; ?></td> <?php } ?> <td align="right" class="main"><?php echo '<a href="' . tep_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL') . '">' . tep_image_button('button_checkout.gif', IMAGE_BUTTON_CHECKOUT) . '</a>'; ?></td> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> </tr></form> <? //Google Checkout Start include("Google_Button_Code.php"); //Google Checkout End ?> </table></td> </tr> </table></td> </tr> <?php } else { ?> <tr> <td align="center" class="main"><?php new infoBox(array(array('text' => TEXT_CART_EMPTY))); ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox"> <tr class="infoBoxContents"> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td align="right" class="main"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> </tr> </table></td> </tr> </table></td> </tr> <?php } ?> </table></code>
  3. JonCloud

    Google Checkout Level 2

    Hey guys, anyone familiar with installing Google Checkout Level 2 w/ BTS template system in place? The install directions don't apply to it very well and I am a little unsure how to apply the changes to the shopping cart page since my file is shopping_cart.tpl.php. It's darn close, but I get an error. I think it's just a syntax thing but I don't know what it is. Parse error: syntax error, unexpected '}' in /home/hsphere/local/group-1/home/joncloud/deeptronics.com/templates/deep06/content/shopping_cart.tpl.php on line 193 It's referring to this. My lines 192, 193, 194. <?php } else { ?> If you can help, I would appreciate it much. - Thanks, JonCloud
  4. JonCloud

    cDynamic Meta Tags

    In regards to changing the output of the title tag for the product page on the meta_tags.php; How can I make the manufacturer name to appear first, like this: <title>[manufacturer] - [product name] - [model number]</title> I have played around with this and cant quite figure it out. I would also like the same format on the "All Products" page. Can you assist? I would appreciate it much. Best Regards, :-" JonCloud
  5. JonCloud

    Loyalty Discount

    Hi Guys, I did some searching and didn't find the answer I am looking for, nor did I find an official support thread for the Loyalty Discount contribution. Please feel free to direct me there if my post here is inappropriate. My question is this; I have the loyalty discount installed and working, but I can't find where to administrate it! It is applying a much-too-large-discount-for-my-margins discount, and I can't find where to change it. Can anyone point me in the right direction? I will appreciate it. Thanks, J
  6. JonCloud

    Easypopulate & Bulk Pricing

    That worked great!! Thanks!! :thumbsup:
  7. Hello all, I think I posted something about this awhile ago and I got most of the answer I need. Today, I seek the rest. I use easypopulate with great success, but I have one problem, and it is really an excel question, but I am hoping someone here can help because you should be able to understand my issue. I have a big csv file from my supplier and it contains all of my relevant product info and pricing. As far as pricing, it has a "wholesale column", and a "list price column". I went ahead and made "my own pricing column" in which I applied a formula to the "wholesale column" and retrieved my pricing. Get it? Here comes my problem. I then selected the data from "my own pricing column" and copied it. I then pasted it into my easypopulate file, but instead of pasting the actual prices, it pasted the formula, which is dependent on data in the next column. Still with me? Ok, this doesnt work for obvious reasons. Does anyone know how I can achieve my goal of bulk pricing my products? Any help will be much appreciated. Thanks, JonCloud
  8. Anyone know if there is a forum for this contribution? http://www.oscommerce.com/community/contributions,2619 Thanks! Jason :'(
  9. JonCloud

    No Product listing w/ linkpoint

    HAS ANYONE EVER FIGURED THIS OUT? I am gettting the same thing and need to figure it out. I am not getting the order confirmation from oscommerce since installing linkpoint connect. Myself, and the customer gets a receipt from linkpoint, but it doesnt record the order info in the db. There is record of payment with no record of order. How can we fix this? I am using the linkpoint connect contribution. Should I be using the newer API? Does the API contrib work with linkpoint connect gateway? Would be nice to make it work. Any help will be most appreciated. Thanks, Jason@ Deeptronics.com
  10. JonCloud

    Payment Options Based on Geography

    Thats awesome! Thanks! And if theres anything I can do for you, let me know! Jason
  11. JonCloud

    Payment Options Based on Geography

    Thanks! I am ready to make this happen. It absolutely has to! In my business, we are experiencing far too many cases of stolen credit card orders coming from international locations. Overseas orders are a big part of my business, and I don't want to exclude them, but I do want to only present them with options that will ensure a safer transaction. Namely, if they are NOT from the USA, then they do NOT get the option to input a credit card number. Instead, they are directed to use paypal, check/ money order, or bank transfer. But if they are from the USA, then the credit card option DOES appear, along with the other payment methods as well. I am not a php wiz. Actually, I am only slightly familiar with PHP syntax, but have successfully installed many mods. So I can follow instructions well. Can you or someone else help walk me through this? I don't fully understand what I need to do. Perhaps someone can explain it like the instructions in a contribution? I am looking for a solution and will trade favors or something else if you would like to get that solution. Please help if you can. Can someone look into it and contact me? Here is my website: www.deeptronics.com My email is: jason@deeptronics.com Thanks!! Jason
  12. Hello Fellow Web Slingers! B) I am sooo close to having this thing working, I just need a liitle help figuring out one little bug. (Hopefully it's a little bug!) I have the mod installed, and it seems to be working properly, with one exception. When I disable a category, all the products go away, as they should. But the category title itself does not come out of the categories box. So, you still see the category title, but when you click it, it is empty. So, it looks like it is working, but there is the matter of making the category name coming off of the list of categories. I am using Osc-Max (www.oscdox.com). It has the mod called "Categories Description 1.5" already installed, and I suspect that it may have something to do with my problem, but I can't be sure. I understand PHP somewhat, but not enough to deconstruct this problem. Any help that anyone can provide would be much appreciated. Anyone care to take a stab at this? Thanks! Jason aka JonCloud
  13. JonCloud

    Payment Options Based on Geography

    Cmon Guys....Help me out here. I am sure that there would be alot of support for a contribution that enabled you to choose payment options based on geographical location. I want my international customers to be able to choose Paypal, Check/ Money Order, or Bank Transfer if order is over $1000.00. I want my US customers to have those options plus my credit card option. Has anyone had any experience or seen anything relating to this idea? I would appreciate any feedback, JAson aka JonCloud
  14. JonCloud

    Help w/2 Checkout Module

    Hmmm... I see your debacle! And since I don't use 2 Checkout, my advise is not specific. But I do have a bit of insight into the matter as I am currently going through somthing similar. As to your first question, Do you need a secure server to use the OSCommerce 2 Checkout module? I don't think you will need one, per se, but for your customers sake, you should have one. I don't need one to use the credit card payment module that comes with oscommerce. But I have one. Although I am experiencing some difficulty with it right now. Its suppoed to be as simple as changing a couple of lines in the configure.php file, and getting the certificate installed on your domain by your hosting company. The default oscommerce module can break the cc number up, and only store the beggining and the end of the number in your db, and it sends the middle to you via email. So in addition to a ssl cert., it will be pretty secure. If the checkout part sends your customer to a 2 Checkout page, then it is likely taking them to an already secure page. But if they have to re-enter their information when they get there, it sounds like the variables are not being passed to their site. Check the url it sends you to. Does it say http:// or https://? With the "s" is a secure page. Check your configuration options for the payment module. And, somewhere, your oscommerce needs to know how to pass its data. So that is somthing to check. So, you may already have a secure checkout. Thats my 2 cents. Jason@deeptronics.com
  15. JonCloud

    Paypal help

    Hey Guys, I use the paypal option and I know what you mean about it skipping the orders db. What I have found to be true is that it does not totally skip the orders db entirely, but if the customer doesn't click the continue button, you get the money, but no order info. See my post here to see what I did about it. http://forums.oscommerce.com/index.php?sho...10entry387367 Jason@ deeptronics.com B)