Jump to content

JangoF

Members
  • Content count

    239
  • Joined

  • Last visited

Everything posted by JangoF

  1. Surfalot, any tips about my question above? :)
  2. http://www.oscommerce.com/community/contri...+conditions+sql
  3. Ok, so in my ordinary do-it-yourself spirit I have almost made it. Here are the modifications I have done so far (should be pretty much all of them): } else { // existing product, get the id from the query // and update the product data $row = tep_db_fetch_array($result); $v_products_id = $row['products_id']; echo "<font color='red'> SKU exists, so we skipped it!</font><br>"; /*$row = tep_db_fetch_array($result); $query = 'UPDATE '.TABLE_PRODUCTS.' SET products_price="'.$v_products_price. '" ,products_image="'.$v_products_image;*/ // uncomment these lines if you are running the image mods /*$query .= '" ,products_mimage="'.$v_products_mimage. '" ,products_bimage="'.$v_products_bimage. '" ,products_subimage1="'.$v_products_subimage1. '" ,products_bsubimage1="'.$v_products_bsubimage1. '" ,products_subimage2="'.$v_products_subimage2. '" ,products_bsubimage2="'.$v_products_bsubimage2. '" ,products_subimage3="'.$v_products_subimage3. '" ,products_bsubimage3="'.$v_products_bsubimage3; */ /*$query .= '", products_weight="'.$v_products_weight . '", products_tax_class_id="'.$v_tax_class_id . '", products_date_available= ' . $v_date_avail . ', products_date_added= ' . $v_date_added . ', products_last_modified=CURRENT_TIMESTAMP , products_quantity="' . $v_products_quantity . '", products_briefdesc="' . $v_products_briefdesc . '", products_condition="' . $v_products_condition . '", vendors_id="' . $v_vendors_id . '" ,manufacturers_id=' . $v_manufacturer_id . ' , products_status=' . $v_db_status . ' WHERE (products_id = "'. $v_products_id . '")'; $result = tep_db_query($query);*/ } else { // already in the description, let's just update it /*$sql = "UPDATE ".TABLE_PRODUCTS_DESCRIPTION." SET products_name='" . addslashes($name) . "', products_description='" . addslashes($v_products_description[$key]) . "', products_url='" . $v_products_url[$key] . "' WHERE products_id = '$v_products_id' AND language_id = '$key'";*/ // support for Lindas Header Controller 2.0 if (isset($v_products_head_title_tag)){ // override the sql if we're using Linda's contrib $sql = "UPDATE ".TABLE_PRODUCTS_DESCRIPTION." SET products_name = '" . addslashes($name) . "', products_description = '" . addslashes($v_products_description[$key]) . "', products_url = '" . $v_products_url[$key] ."', products_head_title_tag = '" . $v_products_head_title_tag[$key] ."', products_head_desc_tag = '" . $v_products_head_desc_tag[$key] ."', products_head_keywords_tag = '" . $v_products_head_keywords_tag[$key] ."' WHERE products_id = '$v_products_id' AND language_id = '$key'"; } // end support for Linda's Header Controller 2.0 //$result = tep_db_query($sql); //} There is just one minor thing left; how do I stop it from updating the date of the skipped product, so that it doesn't end up in the New Products infobox?
  4. I was just thinking in case of a dupe product number or something like that, since I operate with thousands of products. Any clue if it's possible to do?
  5. I'm using Easy Populate 2.76d-MS2. As it stands right now when I import new items and they have the same Products Model as an existing product, EP overwrites/updates that product. I was wondering if it's possible to make it so that IF the Products Model already exists in the database to skip that import line and continue with the rest until another one is found, then skip that, etc? Then output a line along the way of the rest saying the item was skipped or something?
  6. JangoF

    Multi_Vendor_Shipping new thread

    So you do have to make the checkout_process.php changes from MVS in Paypal IPN? I've just checked it at a glance, but a lot of the changes suggested don't even seem to be in the 2 files from Paypal IPN? Is it ok to bypass some of the changes, or are they important? I got that fixed easily. You just have to make sure Shipping is enabled under Order Totals, and it will show.
  7. JangoF

    Paypal Language Wrong

    Hi all, I asked earlier some weeks ago but I never got a reply. I have no multilingual features enabled on my site, it's only in English. But when my customers go to Paypal from the checkout, the Paypal page appears in Spanish. Any idea what is causing this and how to fix this? Please, it's urgent!
  8. JangoF

    Paypal Language Wrong

    If you ever have this problem, here is how to fix it: Open up includes\modules\payment\paypal.php Find tep_draw_hidden_field('cmd', '_xclick') . Below, add: tep_draw_hidden_field('lc', 'US') . ;)
  9. JangoF

    Paypal Language Wrong

    Please, anyone? I'm getting really desperate here!
  10. JangoF

    Paypal Language?

    Anyone?
  11. JangoF

    Paypal Language?

    Hello, I'm having a problem with Paypal. When my customers click on checkout and are redirected to Paypal, the page shows up in the wrong language. I run my site in only one language (english), so I'm wondering what might cause this?
  12. JangoF

    family 3.0 problems

    Sorry for doublepost, but I cannot edit my previous post. When I have Displaytype set to Box, and Displayformat set to Random, it selects random products from all groups. But when I have Displayformat set to Family, it always select the same products from that family. How can I make it select random products from the family?
  13. JangoF

    family 3.0 problems

    Nevermind. Seems like the rule on this forum is "do it yourself". :P Open up includes\modules\family_products.php Find all occurances of: limit " . MAX_DISPLAY_NEW_PRODUCTS); Replace with: limit x"); Where x is the number of items you want to shown.
  14. JangoF

    family 3.0 problems

    I would also like to know if this is possible.
  15. JangoF

    Multi_Vendor_Shipping new thread

    @gmltw: Nevermind, I solved it the easy/cheap way. I use the Paypal Autoreturn feature to get my customers back to the site and complete the order ;) I have another question related to MVS: How do I show the total shipping fees on the Order Confirmation page?
  16. Hello all, I'm having a problem with Paypal. When my customers click on checkout and are redirected to Paypal, the page shows up in the wrong language. I run my site in only one language (english), so I don't see what the problem could be. Does anyone know what could be wrong? :)
  17. I hate to bump my own topic, but I would really like an answer to my question.
  18. Please, anyone know why this happens?
  19. JangoF

    Super Contact us enhancement 1.0

    Maybe a silly question, but how do I get a linebreak between each contact form email I have entered?
  20. JangoF

    Official PayPal IPN Support Thread

    My customers do not return back to my site to complete the order. Why is this? I am using MVS, will Paypal IPN work with that? Please guys, I really need help fast.
  21. JangoF

    Multi_Vendor_Shipping new thread

    Does anyone have Paypal IPN working for MVS? Please, I'm REALLY desperate about this.
  22. Hi, I don't think my question belonged in the MVS thread, so I made a new topic about it. So basically I am trying to add product images for each product that is in packaging slip. I have got it working fine with 1 product (after loads of hours), but when there is more than 1 something goes wrong. Here is the code I am using at the moment: <?php $products_id_query = tep_db_query("select products_id from " . TABLE_ORDERS_PRODUCTS . " where orders_products_id = '" . $oID . "'"); $products_id = tep_db_fetch_array($products_id_query); $image_query = tep_db_query("select products_image from " . TABLE_PRODUCTS . " where products_id = '" . $products_id['products_id'] . "'"); $thumb_image = tep_db_fetch_array($image_query); echo tep_image(DIR_WS_CATALOG . DIR_WS_IMAGES . $thumb_image['products_image'], $oID, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT); ?> I'm not very good with using while and stuff, so can anyone help me fix this so that it works no matter how many products there are? :)
  23. JangoF

    Multi_Vendor_Shipping new thread

    I started my own thread in this forum regarding the matter (just missing how to print out multiple product images), since after I had done some thinking I figured it wasn't really specifically related to MVS. But thanks for the tip again Craig, you're the best. :)
  24. JangoF

    Multi_Vendor_Shipping new thread

    I guess what needs to be done is selecting products_id and products_image from TABLE_PRODUCTS and products_id from TABLE_ORDERS_PRODUCTS, compare the two products_id somehow, and if they are the same print the products_image. Anyone knows how to do this?
×