Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

10incher

Members
  • Posts

    80
  • Joined

  • Last visited

Everything posted by 10incher

  1. This just happened for some reason. I changed the currency info from CDN to CAD which fixed the Paypal issue now the prices are all showing as 0 for some reason. Im not sure what happened? Fiddled with changing the currency back and forth and now it seems to show fine. Can anyone confirm?
  2. Just setting up my site and noticed I keep getting this error page on Paypal when an order goes through, but only when the currency on my site is set to CA$. Seems to work fine if the currency on my site is set to US$ though: http://www.rewindtoys.ca/catalog/ Any idea if this is something on my Paypal account that needs to be updated? I have it setup to accept multiple currencies, to be added as a balance in that currency. Not sure what else it could be, any thoughts?
  3. Looks like that was the problem a duplicate htaccess file I didn't see messing it up, all fixed. Thanks so much for answering all my questions, your help is greatly appreciated. Take care!
  4. OK, having a look in my /catalog for the htaccess file, it looks like I have 2 htaccess files and an htaccess.text file, is this correct?
  5. 1. Sorry, this was a typo when posting my reply, the file does have the closing / 2. This page is not the header image of my store. The only reason I can think of why this is showing up is that it is a broken link (to the header.jpg) and is redirecting to the home page of my base site (not the store section) because of the redirect I have in place for broken links. Not sure if the redirect is throwing things off but it used to work before with the old version of the store I had up a few years back. Would it help if I pasted the code here from any of my pages?
  6. Thanks for the reply. I double checked and the .htaccess file in the catalog root directory is correct: Rewritebase /catalog . The link with SEO on is: http://www.rewindtoys.ca/catalog/board-games-strategy-games-kaisers-battle-vintage-1980-strategy-game-p-90.html Then with it turned back off, the same link is: http://www.rewindtoys.ca/catalog/product_info.php?products_id=90
  7. Hello, I just installed the Ultimate SEO URLs contribution on my 4.3.2.1 version of the store. While the urls all look correct when I click on products, the page that shows up is not the product page but looks to goto a dead link (it shows A the main homepage of my site rather than the product I click on, as I have a dead link redirect that points to the site's home page). Any ideas what to check? Can find the store section of my site at http://www.rewindtoys.ca/catalog/index.php but i currently have SEO Urls turned off in the admin section. Not sure really where to go from here to solve the problem and am wondering if its more than just an issue with the changes made when installing the contribution? I also use the alias domain of rewindtoys.ca for the store section of the site but don't think that is an issue. Do you think the dead link re-direct I am using may have something to do with this? I checked my configuration file and everything looks to be right. Any ideas would be appreciated on this.
  8. I forgot to add that I have the site setup so that if someone enters a wrong url, it re-directs to the home page. That seems to be why it is the home page of the site that is showing, but I don't think that is the reason why the links are not working.
  9. Hello, I just installed the Ultimate SEO URLs contribution on my 4.3.2.1 version of the store. While technically it seems to be functioning correctly and the urls all look correct when I click on products, the page that shows up is the main home page of my site rather than the product I click on. Its not the main store page, but the home page of the site. Any ideas what to check? Can find the store section of my site at http://www.rewindtoys.ca/catalog/index.php Mt main home page is www.action-figures.ca which is the page that keeps coming up. I use the alias domain of rewindtoys.ca for the store section of the site. Not sure really where to go from here to solve the problem and am wondering if its more than just an issue with the changes made when installing the contribution?
  10. We'll I think I found my answer about 60 pages back (phew that took awhile!). Haven't tried it yet but here it is again for the few others that asked about it a few pages back change in seo.class.php (includes/classes). Find function function Validatename($url, $type, $realID, $connection, $separator) (1036 line) and change two lines (comments them), like that : // header("HTTP/1.0 301 Moved Permanently"); // header("Location: $link");
  11. I have installed version 2.1 of Ultimate SEO URLS. When I enable it everything seems to work fine, except on any product listing pages that have allot of items which require more than one page to list them. No matter if you gto page, 2, 3 etc. it keeps reloading the first page. If anyone knows what to change to fix this, it would be greatly appreciated.
  12. Hello all, I am having a problem after my installation as well though somewhat different. It seems that in any categories where i have more than 1 page of products, when you click to view the next page, it just keeps coming up as the first page? I disabled the contribution and everything worked fine, so I know it is an issue with the contrib. Anyone have any ideas on how to fix this?
  13. After having a look at everything it looks like some of my code is different because I have the Order Editor contribution installed. The above problems are the only ones that i came across. If anyone knows how to implement the changes above or has a seperate list of changes to make (when installing shipping labels) when you have Order Editor installed, I would greatly appreciate it.
  14. I also noticed In catalog/admin/orders.php ### Replace the following line: *********** <td colspan="2" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS_INVOICE, 'oID=' . $HTTP_GET_VARS['oID']) . '" TARGET="_blank">' . tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID=' . $HTTP_GET_VARS['oID']) . '" TARGET="_blank">' . tep_image_button('button_packingslip.gif', IMAGE_ORDERS_PACKINGSLIP) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action'))) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a>'; ?></td> ###### With: <td colspan="2" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_SHIP_CANADAPOST, 'oID=' .(int)$HTTP_GET_VARS['oID'] . '&action=new&status=3') . '">' . tep_image_button('button_ship_canadapost.gif', IMAGE_ORDERS_SHIP) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS_INVOICE, 'oID=' . $HTTP_GET_VARS['oID']) . '" TARGET="_blank">' . tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID=' . $HTTP_GET_VARS['oID']) . '" TARGET="_blank">' . tep_image_button('button_packingslip.gif', IMAGE_ORDERS_PACKINGSLIP) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action'))) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a>'; ?></td> what I have for that line is slightly different is it safe to replace? Here's what I have: <td colspan="2" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS_EDIT, 'oID=' . $_GET['oID']) . '">' . tep_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS_INVOICE, 'oID=' . $_GET['oID']) . '" TARGET="_blank">' . tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID=' . $_GET['oID']) . '" TARGET="_blank">' . tep_image_button('button_packingslip.gif', IMAGE_ORDERS_PACKINGSLIP) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action'))) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a> '; ?></td>
  15. Hello, I am trying to install this contrib but have run into a bit of a problem. In catalog/admin/includes/classes/order.php I am trying to: ### To the following line: $order_query = tep_db_query("select customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, currency, currency_value, date_purchased, orders_status, last_modified from " . TABLE_ORDERS . " where orders_id = '" . (int)$order_id . "'"); ###### After last_modified add , cp_tracking The problem is that I have added some previous contributions or have an older version of OScommerce and I don't have that line anywhere in the code for this page. Does anyone know specifically where I can add the new line or how to implement it properly within the code that I do have? I would really love to add this contibution. Here is the code for the page that I have: <?php /* $Id: order.php,v 1.7 2003/06/20 16:23:08 hpdl Exp $ Modified for Order Editor 2.5 osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ class order { var $info, $totals, $products, $customer, $delivery; function order($order_id) { $this->info = array(); $this->totals = array(); $this->products = array(); $this->customer = array(); $this->delivery = array(); $this->query($order_id); } //Begin Order Editor modifications function query($order_id) { $order_query = tep_db_query("select * from " . TABLE_ORDERS . " where orders_id = '" . (int)$order_id . "'"); $order = tep_db_fetch_array($order_query); $totals_query = tep_db_query("select * from " . TABLE_ORDERS_TOTAL . " where orders_id = '" . (int)$order_id . "' order by sort_order"); while ($totals = tep_db_fetch_array($totals_query)) { $this->totals[] = array( 'title' => $totals['title'], 'text' => $totals['text'], 'class' => $totals['class'], 'value' => $totals['value'], 'sort_order' => $totals['sort_order'], 'orders_total_id' => $totals['orders_total_id']); } $this->info = array('currency' => $order['currency'], 'currency_value' => $order['currency_value'], 'payment_method' => $order['payment_method'], 'cc_type' => $order['cc_type'], 'cc_owner' => $order['cc_owner'], 'cc_number' => $order['cc_number'], 'cc_expires' => $order['cc_expires'], 'shipping_tax' => $order['shipping_tax'], 'date_purchased' => $order['date_purchased'], 'orders_status' => $order['orders_status'], 'cp_tracking' => $order['cp_tracking'], 'last_modified' => $order['last_modified']); $this->customer = array('name' => $order['customers_name'], 'company' => $order['customers_company'], 'street_address' => $order['customers_street_address'], 'suburb' => $order['customers_suburb'], 'city' => $order['customers_city'], 'postcode' => $order['customers_postcode'], 'state' => $order['customers_state'], 'country' => $order['customers_country'], 'format_id' => $order['customers_address_format_id'], 'telephone' => $order['customers_telephone'], 'email_address' => $order['customers_email_address']); $this->delivery = array('name' => $order['delivery_name'], 'company' => $order['delivery_company'], 'street_address' => $order['delivery_street_address'], 'suburb' => $order['delivery_suburb'], 'city' => $order['delivery_city'], 'postcode' => $order['delivery_postcode'], 'state' => $order['delivery_state'], 'country' => $order['delivery_country'], 'format_id' => $order['delivery_address_format_id']); $this->billing = array('name' => $order['billing_name'], 'company' => $order['billing_company'], 'street_address' => $order['billing_street_address'], 'suburb' => $order['billing_suburb'], 'city' => $order['billing_city'], 'postcode' => $order['billing_postcode'], 'state' => $order['billing_state'], 'country' => $order['billing_country'], 'format_id' => $order['billing_address_format_id']); $countryid = tep_get_country_id($this->delivery["country"]); $zoneid = tep_get_zone_id($countryid, $this->delivery["state"]); $index = 0; $orders_products_query = tep_db_query(" SELECT op.orders_products_id, op.products_name, op.products_model, op.products_price, op.products_tax, op.products_quantity, op.final_price, p.products_tax_class_id, p.products_weight FROM " . TABLE_ORDERS_PRODUCTS . " op LEFT JOIN " . TABLE_PRODUCTS . " p ON op.products_id = p.products_id WHERE orders_id = '" . (int)$order_id . "'"); while ($orders_products = tep_db_fetch_array($orders_products_query)) { $this->products[$index] = array( 'qty' => $orders_products['products_quantity'], 'name' => $orders_products['products_name'], 'model' => $orders_products['products_model'], 'tax' => $orders_products['products_tax'], 'tax_description' => tep_get_tax_description($orders_products['products_tax_class_id'], $countryid, $zoneid), 'price' => $orders_products['products_price'], 'final_price' => $orders_products['final_price'], 'weight' => $orders_products['products_weight'], 'orders_products_id' => $orders_products['orders_products_id']); $subindex = 0; $attributes_query = tep_db_query("select * from " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " where orders_id = '" . (int)$order_id . "' and orders_products_id = '" . (int)$orders_products['orders_products_id'] . "'"); if (tep_db_num_rows($attributes_query)) { while ($attributes = tep_db_fetch_array($attributes_query)) { $this->products[$index]['attributes'][$subindex] = array('option' => $attributes['products_options'], 'value' => $attributes['products_options_values'], 'prefix' => $attributes['price_prefix'], 'price' => $attributes['options_values_price'], 'orders_products_attributes_id' => $attributes['orders_products_attributes_id']); $subindex++; } } $index++; } } } //end Order Editor ?>
  16. I am using the Canadian Province Shipping v0.9 in conjunction with the Canada Post shipping module. The Canadian Province module is only being used to display shipping cost for Light Packet since the Canada Post module doesn't offer this choice. I have it set the Canadian Province module to show a shipping cost for a package weighing up to 0.2kg. The problem I want to solve is that if the package is over 0.2 kg I don't want the Canadian Province Shipping module to display anything. Currently it displays the shipping cost as $0 because i don't have any values set for over 0.2kg. Is their a way to set things up for the $0 choice to not be displayed at all if over 0.2kg? Right now customers can still select this choice even with it displaying $0. Does anyone know of a way to fix this up? Please help and hope this all makes sense.
  17. Just installed the contrib and having the same message stating that Canada Post cannot find my CPC ID. I was using my 7 digit Venture1 account number. So I take it this is not the ID number to enter, but we need to get them to assign us an actual CPC number correct?
  18. In the Admin section on the Orders page under Order Totals, is there a way to display the shipping cost seperately for each order? Maybe have two columns, one showing the actual cost of the items, the other showing just the shipping costs (for each order). I have been searching through the forums and contributions but can't seem to find anything.
  19. I noticed this contribution: http://www.oscommerce.com/community/contri...rch,canada+post I haven't tried it yet as I am looking for something similar but with a few more options. Is there anything out there that when viewing an order in admin, has a button that when pressed, can export the following data to Canada Post Shipping tools as well as update the order to shipped status: - customer information (name, address, email address, phone number, etc.) - order number - order total (not including shipping cost) - currency of order If anyone has tried the above contribution, please LMK if it can do these things. Thanks.
  20. I just installed the contribution and when I go to add a featured product in Admin, I get the following error: 1054 - Unknown column 'customers_group_name' in 'field list' select distinct customers_group_name, customers_group_id from customers order by customers_group_id [TEP STOP] Does anyone know what I can do to fix this?
  21. I am fairly new to this, but i got the module installed and working. My question is, how do you install more zones? The read me file states: Set the number of regions you need with $this->regions = xx; This is in the comment tags, so where exactlly do I put this line of code for it to work? Is there a specific section of the province.php file I have to put it in? Ultimately I want 3 zones for Canada, 3 zones for the USA and 1 zone for international. I'm sure its a simple fix, but any help would be appreciated.
  22. Hello, I am new here and just installed this wonderful program today. This may be an obvious question, but can any one direct me to a module or show me how to do the following: I want to set up my shipping based on 3 different zones and have a pricing table based on weight within each. For example Zone 1: Canada - up to 100g $2.00, 100g-500g $4.00, etc. Zone 2: USA- up to 100g $2.00, 100g-500g $4.00, etc. Zone 3: International - up to 100g $2.00, 100g-500g $4.00, etc. Thanks in advance, I have been searching through these forums and contributions but haven't been able to locate this.
×
×
  • Create New...