JangoF
-
Posts
239 -
Joined
-
Last visited
Posts posted by JangoF
-
-
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?
-
I think the easiest way to do that is to upload a partial file with only the items you wish to import.
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?
-
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?
-
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 got that fixed easily. You just have to make sure Shipping is enabled under Order Totals, and it will show.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
-
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') .
;)
-
Please, anyone? I'm getting really desperate here!
-
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!
-
Anyone?
-
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?
-
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.
-
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?
-
- Firstly, Is there a way to limit how many items are shown related to the product someone is viewing? At the moment it is showing upto 10. I only want it to show 6.
I would also like to know if this is possible.
-
@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?
-
I hate to bump my own topic, but I would really like an answer to my question.
-
Please, anyone know why this happens?
-
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? :)
-
Maybe a silly question, but how do I get a linebreak between each contact form email I have entered?
-
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.
-
Does anyone have Paypal IPN working for MVS? Please, I'm REALLY desperate about this.
-
Anyone?
-
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. :)
-
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? :)
-
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?
-
Nevermind, I actually found it out myself.
I just had to look in the Order Total file in includes\modules\order_total and look for the value I wanted to show, then just add it in an echo on the page :)
Page text editor contribution exists?
in General Add-Ons Support
Posted