Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

zzfritz

Archived
  • Posts

    496
  • Joined

  • Last visited

Everything posted by zzfritz

  1. I am SO glad to find this thread and quickly, too, and the fix using sprintf does indeed work. Before coming back here (I have been absent many months), I tried pinning this error down and was stumped except to recognize it was a rounding phenomenon. This happened to a site of mine that had run correctly for a full year at ipowerweb on one of its oldest servers, but when we migrated it to a new vDeck server, voila ... rounding occurs. Thank goodness for the osC forum and a robust user community! Happy Holidays to all.
  2. This is not an 'anomaly' but a feature known as 'tare weight' representing the added weight of packaging.<p>You shouldn't have to edit the database table; it should be set in admin => Configuration => Shipping, where you set the store's Postal Code, Country Code and maximum package weight.
  3. Now that I have achieved functionality with both PayPal IPN and Authorizenet Consolidated 1.7, I would like to address the problem noted above in posts #49-51 where the customer_id is not among the POST vars as expected. To answer Harald's question, I believe the only contributions affecting checkout in this installation are Authorizenet Consolidated 1.7 and QT Pro 3. (Among my dreaded tasks ahead is to bring this installation current to QT Pro 4.) Any suggestions to find why the customer_id is not being passed to PayPal?
  4. Greg's suggested coding and global declaration (post 47 above, on 7 Dec) does indeed solve the duplicate instantiation problem (of order_total) in my installation that has both PayPal IPN and Authorizenet Consolidated 1.7. Now both of these payment contributions are playing nicely together. So anyone else who uses them both should heed that suggestion.
  5. I found that order status was not being updated because the query string in ipn.php searched on both the order number and the customer id, and the latter was not in the POST vars as apparently expected. I edited the query, and the order status is being updated now. It is also important to note that IPN is not instantaneous: the status did not change from the interim 'Preparing [PayPal IPN]' for a few minutes and in one case it took 18 minutes before the verification was received and the order status updated.
  6. you state the obvious, mibble ... I guess that's how you racked up so many posts Inspecting the code, this appears to be a clash between Authorizenet Consolidated 1.7 and PayPal IPN. The authorizenet mod to checkout_process.php has its own 'new order_total' embedded inline, before the standard code calls all the payment modules' before_process(), which in the case of PayPal IPN includes another 'new order_total' instance. Can someone suggest a workaround? [specifics, not generalities]
  7. I had an opportunity to install and test the prerelease version from 11/26, and found it worked fine. Today I noticed the official contribution had been made, so I replaced all the files and installed it (after removing the old one, of course). Then I had someone test it, and the order went okay including the confirmation email, being listed in admin, and PayPal had the money. But she did not get returned to the confirmation success page, getting instead the error message: Fatal error: Cannot redeclare class order_total in /home/sonnybar/public_html/osc/includes/classes/order_total.php on line 13 While I sleuth this myself, I am posting hoping perhaps someone else will recognize the symptom more readily and save me some time/frustration. I really don't believe there had been any other relevant changes to the site. But I don't see any differences between the old and new scripts that appear likely to generate an extra class declaration ... hmm ...
  8. kingchui: be sure to set your country code in Admin -> Configuration -> Shipping/Packaging
  9. This error indicates you failed to upload the associated language file. I have no familiarity with this particular contribution, but doubtless it consists of a script named returns_track.php which you uploaded. Look again in the contribution and you should also find a file with the same name (but different contents) which must be uploaded to the directory includes/languages/english/. It is a general technique in osCommerce to supply language-specific files that contain the text displayed by the script. When returns_track.php runs, it references the text items defined in includes/languages/english/returns_track.php.
  10. Without making any recommendation, I am aware this export to QuickBooks exists: http://www.oscommerce.com/community/contributions,1861 and there are topics mentioning it in the Contribution Support channel. Tell us whether this is satisfactory (or if not, why not), as the subject is significant IMHO.
  11. The simplest thing (not requiring any coding) would be to use a tiny transparent gif as the image for all the products. You may as well use pixel_trans.gif, which is already in your images directory. Then the only oddity will be that the Show Larger button on the product page will not make sense. To remove that, we can help you edit the product_info.php code. Reading your post again carefully, I hesitate. If you want this feature for only some users, my suggestion would of course not be adequate. Detecting which users are on slow lines, and providing the alternative images (regular and tiny) would require quite a bit of coding.
  12. I am one of the co-authors, and posted the last revision v2.7. It is working fine for two of my sites and lots of others', so I suspect other mods made to your site may be interfering. Have you got any other shipping module to work? For instance, how about the standard USPS module? I always recommend getting a store working with standard payment and shipping modules before switching to contributed ones. Otherwise it is harder to troubleshoot.
  13. This is the support topic for Contact Us Choice, announced here: http://www.oscommerce.com/forums/index.php?showtopic=89801 I have endeavored to make the installation very simple. For the minimal enhancement, only two replacement files need be uploaded: catalog/contact_us.php catalog/includes/languages/english/contact_us.php To take advantage of the optional features to display additional store information, and link to an external map page, it is necessary only to edit the language file. The alternative email destination feature requires adding a single entry to the configuration table in the database, for which the SQL is included. Then the completion of the feature set up is done by using the Administration tool. No other osCommerce files need be edited to use this contribution, and I believe it is pretty well behaved. I am sure you will let me know if that is not the case.
  14. stevel: it does not "look awkward" for a post to be edited, in fact it shows you have taken the care to make corrections. Just be glad you have this capability, we didn't used to. To All: take caution and even seek advice when choosing the Category into which you make your contribution. There are some notable mis-categorized contributions that have not gotten the attention they deserved when people didn't find them in the expected place. Take for instance: AuthorizeNet Consolidated, which should be in Payment Modules, is in Credit Modules; and Discount for Payment Type, whose description even acknowledges it creates an order total class, is in Credit Modules but should be in Order Total Modules. Unfortunately, there is no present means for transferring contributions to their correct category.
  15. [gee, was it really necessary to post the whole script?] I am not familiar with the contribution, but a simple comparison to the original table.php discloses that the statement $order_total = $cart->show_shipping_total(); should be $order_total = $cart->show_total();
  16. If you already have made mods to admin/modules.php, just make this change: around line 37 change: switch ($HTTP_GET_VARS['action']) { case 'save': while (list($key, $value) = each($HTTP_POST_VARS['configuration'])) { tep_db_query("update " . TABLE_CONFIGURATION . " set configuration_value = '" . $value . "' where configuration_key = '" . $key . "'"); } to this: switch ($HTTP_GET_VARS['action']) { case 'save': while (list($key, $value) = each($HTTP_POST_VARS['configuration'])) { if( is_array( $value ) ) $value = implode( ", ", $value); tep_db_query("update " . TABLE_CONFIGURATION . " set configuration_value = '" . $value . "' where configuration_key = '" . $key . "'"); }
  17. Make sure to set the Postal Code and County Code for your store in Admin -> Configuration -> Shipping/Packaging (MS2).
  18. The capability you are looking for is not yet present in osCommerce: inventory kept at the attribute-combination level. I believe this is the most serious limitation we have for stores selling apparel such as your example. You should investigate two contributions: Master Products, and QTPro.
  19. CatDadRick: are you sure you installed v2.1.1 of the report? The column heading "exempt" was changed to "nontaxed" since v2.0. Click the Help button, and scroll to the bottom where it says "v 2.1.1" The month names in the left column should be active links, as should the tax values.
  20. You might try my contribution, Monthly Sales & Tax Report, which summarizes order financial information: http://www.oscommerce.com/community/contributions,539
  21. Since you are presumably editing a product that was already present, just adding the new field used by the contribution, you are not uploading a new image for the product. That is all the warning is about, that there is no image file uploaded. If I understand correctly, you went back and did not use the "Update" button on the preview page. So the update did not occur. Try again and press the Update button.
  22. Talon's example is a good demonstration of how elaborate a store's order total structure can be, and why it is so difficult to make this report work for everyone. But I do believe it can be done, using the sort order of the order total components, in the next major revision. Kendall, the reporting of store profit is a fine objective but must be the subject of another report. Just reporting the income is complicated enough for this project. I am looking for feedback to confirm the latest v2.1.1 is okay for those who wanted the nontaxed and taxed columns back in simple store configurations.
  23. Keep the feedback coming, it is helpful. I am studying the way order totals are calculated in checkout, so the report can reconstruct the summary in the same way. This requires finding the status (on or off) and the sort order of the configuration variables (MODULE_ORDER_TOTAL_SUBTOTAL_SORT_ORDER, MODULE_ORDER_TOTAL_TAX_SORT_ORDER, etc). The report could adapt (as it already does to the presence or absence of the low order fee and 'extra' orders total class such as gift voucher) to each store's configuration. This still leaves the question of whether taxed vs. nontaxed order subtotals are determined by the presence or absence of tax in the order total, or by the shipping zone. The former (presence or absence of tax) is probably better, although not absolutely perfect. If an order could contain both taxed and nontaxed items, neither method will produce a correct summary. That bothers me a little. Re the popup detail of tax, the method used is simply to group the orders total entries (for the relevant dates and status) by the title field. To use kooyan's example above, "enthaltene (incl). 16% MwSt:", "enthaltene (incl) 7% MwSt:" and "enthaltene (incl) MwSt. 16%:" are found in this field and therefore summarized separately because they are not identical. Can anyone explain why checkout (which creates the orders_total table entries), is storing the text description of the 16% tax in two different ways? If checkout stored the tax_class_id instead of (or in addition to) the tax_class_description, this question would not have to be asked.
  24. WHICH PayPal IPN contribution are you installing? There are several.
  25. Comparing the original whats_new.php v1.30 with the contribution mod, I find only three differences: the "order by" clause is removed from the database search, the name of the box heading is changed, and local variable $whats_new_price is renamed $rprod_price. So, the following is whats_new.php v1.31 with the same changes: <?php /* show_random.php: entirely based on $Id: whats_new.php,v 1.31 2003/02/10 22:31:09 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ if ($random_product = tep_random_select("select products_id, products_image, products_tax_class_id, products_price from " . TABLE_PRODUCTS . " where products_status = '1' limit " . MAX_RANDOM_SELECT_NEW)) { ?> <!-- show_random //--> <tr> <td> <?php $random_product['products_name'] = tep_get_products_name($random_product['products_id']); $random_product['specials_new_products_price'] = tep_get_products_special_price($random_product['products_id']); $info_box_contents = array(); $info_box_contents[] = array('text' => BOX_HEADING_SHOW RANDOM); new infoBoxHeading($info_box_contents, false, false, tep_href_link(FILENAME_PRODUCTS_NEW)); if (tep_not_null($random_product['specials_new_products_price'])) { $rprod_price = '<s>' . $currencies->display_price($random_product['products_price'], tep_get_tax_rate($random_product['products_tax_class_id'])) . '</s><br>'; $rprod_price .= '<span class="productSpecialPrice">' . $currencies->display_price($random_product['specials_new_products_price'], tep_get_tax_rate($random_product['products_tax_class_id'])) . '</span>'; } else { $rprod_price = $currencies->display_price($random_product['products_price'], tep_get_tax_rate($random_product['products_tax_class_id'])); } $info_box_contents = array(); $info_box_contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $random_product['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $random_product['products_image'], $random_product['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $random_product['products_id']) . '">' . $random_product['products_name'] . '</a><br>' . $rprod_price); new infoBox($info_box_contents); ?> </td> </tr> <!-- show_random_eof //--> <?php } ?>
×
×
  • Create New...