Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Mrmike

Pioneers
  • Posts

    32
  • Joined

  • Last visited

Profile Information

  • Real Name
    Mike
  • Gender
    Male
  • Location
    Victoria, BC

Mrmike's Achievements

  1. Otherwise, this module is working very well in 2.3.1! Thanks again
  2. Ive been needing something like this too. The ability to set only certain items at a fixed shipping rate is what I need, while other items continue to offer the rate as set by Canada Post module (which works great btw) The scenario is that the store offers both very small items and large items. The larger items are shipped in boxes and are usually going to be individualy ordered are fine with Cpost module rates, but the owner of the store also has items (golf flags) that are small and light weight. However, even at the smallest possible dimensions and weights allowable by the Canada Post module, the flags still want to ship at $10 per flag, which is alot for a $9 item. because the flags are small enough to ship in a padded envelope we want the option to set just flags at a rate of $5 per flag. Unfortunately the 'per item' module included in OSC 2.3.1 once activated then appears on the shipping page for ALL items, which doesnt work when the owner needs to send a 20lb item! It seems odd that this wouldnt be a built in function. I did look at MVS but it seems like a fairly complicated module to port into 2.3.1 and it does far more than the one task Im needing to do..
  3. Ok so I see my problem was I created a seperate ZONE for EACH province, when I should have a seperate ZONE for each RATE, then add the provinces accordingly ie: BC in its own ZONE (set at 12% and is calculating as such properly now) Ontario/NB/NFL in 13% ZONE Nova Scotia in its own HST zone (15% .. those poor suckers :x ) AB/SK/MB/QB/NWT/YT/NVT/PEI all into their own 5% zone (since I wont be charging PST out of province) USA into its own ZONE 0% so far so good..
  4. and now approx 20 min later Alberta starts processing at 0% again.. even though after I set it back to 0% it initially processed at 5% for the first 3-4 tests.. I leave it and come back, and its back to 0% .. :x
  5. Now i check back 20 minutes later and Alberta is processing 10% again, even though ealrier I had it processing 5% as it should.. so its adding my 5 % with the modules 5 % Im presuming.. what a pain in the *** lol
  6. Ok back to the drawing board, none of that makes sense as I tested Alberta again and now the module DOES want the 5% inputted, which doesnt explain the 10% it was putting in there earlier..
  7. it seems to me as though the module is calculating BC as a GST/PST zone. ie: If I add BC as 12% (HST) it calculates at 17% (must be adding Federal 5% to the 12% I set it to) If I add BC at 7% it calculates properly at 12% If I add Alberta at 0% it calculates 5% (federal) but f I add Alberta at 5% it calculates at 10% (so the module knows Alberta is 5% fed only) But if I add Ontario at 8% it calculates at 8% and doesnt add the 5% federal. Ontario is an HST (13% ) province, but if I add Ontario at 13% it calculates at 13% (so the module knows its HST province) Understadable it would be off on BC as BC only recently adopted HST (which was later voted out in a referendum and is to be back to PST/GST by March 2013) Still confusing, Ill have to make a test account for each province just to be sure its calculating properly.
  8. But not for Ontario, leading me to belive tha the module is still calculating BC as a GSt/ PST province,,, which it isnt anymore, until March 2013 haha
  9. Although if I input BC at 7% I see it calculates properly, automatically adding the 5% GST portion of BC's HST.. seems overly confusing im guessing the Module is calculating the Federal tax automatically and we have to add in in provincial for the HST provinces and leave it blank for the GST provinces.
  10. Rick, did you ever figure out the 17% in BC problem? Im having the same issue.. in my admin Ive set BC at 12% but it calculates it at 17% on checkout
  11. Canada Post add-on is here: http://addons.oscommerce.com/info/7900/v,23 Dont forget that BC will be switching back to GST / PST system by March 2013
  12. In the instructions it tells us to replace the same line twice. It may be an error in the instructions? Ive a slightly modified categories.php but as far as I know Id not modified that line out previously. The instructions say to find: $product_query = tep_db_query("select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'"); And replace with: (x code) But then later in the instructions is says to find that same line again and replace with: (x code)
  13. Ive gone over the install multiple times now and I get the same error. My admin/categories.php is giving a blank page with : () Any ideas? Ive set permissions, added the code to htaccess..
  14. Seems to be all sorted now. Thanks a million for your advice and a really great contribution! :thumbsup:
×
×
  • Create New...