Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

JangoF

Archived
  • Posts

    239
  • Joined

  • Last visited

Posts posted by JangoF

  1. 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?

  2. 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?

  3. The OSC PayPal IPN contrib http://www.oscommerce.com/community/contributions,2679 was really easy to install (well documented, and very few if any (can't remember specifics) modifications to the store files) and took care of all of the problems I was having with PayPal including the customer not returning to your store issue. Just an FYI.

    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 don't know about the shipping totals. I would like to know about that as well. I think there may be a contrib/mod for that. Not sure though.

    Gary

    I got that fixed easily. You just have to make sure Shipping is enabled under Order Totals, and it will show.
  4. 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') .

     

    ;)

  5. 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!

  6. 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?

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

  8. 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?

  9. Your on the right track here, if you have this much of an idea, take a look at the "product_info.php" file, search for "products_image" and you will find all the references to pulling and displaying the product image. From there, you should be able to work out how get it, and how to display it(what size and such).

    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. :)

  10. 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? :)

×
×
  • Create New...