Jump to content


  • Content count

  • Joined

  • Last visited

Profile Information

  • Real Name
  • Gender
  • Location
    BC Canada
  1. I thought I posted this question but it appears it didn't stick. Sorry if this is a re-post... I have a client who's offices are located in Canada where we currently have the Canada Post shipping module set up and working fine. Since he gets a lot of American orders and lives near the border, he has opened up a USPS account using a US Post Office Box where he wants to offer his US customers the option to ship via USPS (saving money in doing so). He would then ship the order out of the US post box. I installed the USPS module and have the proper account created and is live on the production server. However, I am getting error messages when I go to place an order. There appears to be a conflict between the store's mailing address (Canadian) and the USPS needing a US mailing address (despite the account being set up using a US address). Is there a way to get around this where we can offer the purchaser the option of sending their parcel EITHER through Canada Post OR USPS if they are located outside of Canada? Any help in this would be greatly appreciated. Thanks Susan
  2. Hi, I have a client physically located in Canada and we currently use the Canada Post shipping module no problems. He lives near the border and has now opened a USPS account in the states (along with a PO box number) so purchasers can save shipping costs from within the states. I enabled the USPS module and have created the account and am activated on the production server. However, I'm still getting the error message: An error occured with the USPS shipping calculations. If you prefer to use USPS as your shipping method, please contact the store owner. If I change the Postal Code to the US Zip code in the shipping/Packaging area, then I get an error in the Canada post shipping rates (Illegal Postal Code)and the USPS still has the same error message. I'm assuming I'm getting a conflict between using both shipping options. Is there a way around this so that the purchaser can choose Canada Post if they live in Canada OR USPS if they live in the states? Any help with this would be greatly appreciated. Susan
  3. SusanF

    All Payments Processed Offline

    Thank you Geoffrey, that's all I needed to hear to ensure I didn't mess anything up! Much appreciated, Susan
  4. SusanF

    All Payments Processed Offline

    I'm looking for something similar - we just want to have an on-line catalog with inventory tracking. Our buyers log in (to their profile), place a wholesale order, but NO payment and NO shipping is calculated. We simply want our buyers to place their order through the catalog and they will be invoiced through our own off-line system. There may be a future need to fully integrate all of osC purchasing options for retail sales, but for now, we need a "dummied down" version. Will simply uninstalling all of the payment modules do the trick? Or is there an actual contribution that will bypass all the unnecessary payment and shipping options? - Susan
  5. SusanF

    Customer File Upload Script

    Hi, I was wondering if a solution was found for this? I am needing something very similar - where the customer uploads one or several files and then goes through the check-out process and pays for the amount of files they uploaded. Ideally, I'd like to also see a follow up where, when the order has been processed, the customer can re-log in and retrieve (download) the "fixed" files. Does such an animal exist? Thanks, Susan
  6. SusanF

    Paypal Return to merchant

    It's working now - we installed the Paypal IPN contribution and all is well with the world once again :)
  7. SusanF

    Paypal Return to merchant

    Hi, I'm now having the same difficulty but am not having the same luck as others with a fix. Exact same scenario as detailed above. I've got PayPal set up for IPN with the return URL as being: http://www.annemarieevers.com/catalog/checkout_process.php But the "return to merchant" link still takes me to the login page and there's no record of a purchase being made. This site is live and I've got 3 people asking where their download link is for their purchase - yikes! I need this fixed ASAP - can someone help please? There must be another setting that I haven't set correctly.... If I install the contribution mentioned previous, will that fix it? Thanks Much, Susan
  8. I don't know if Abstract Zones is what I'm looking for so am checking first to see if there's an "easier" way. I'm selling books and some of them have an e-book (downloadable) version. How do I prevent the e-book version from being charged shipping? I'm using flat rate shipping across the board for all regular books. Thanks, Susan
  9. Never mind... fixed it after hours of pulling out my hair. Turns out it was an images folder permissions problem. We're on a Windows server (which I completely forgot to compensate for) and was incorrectly setting the permissions. Once I finally figured it out, voila, the thumbnails are now showing up as should....
  10. Hi, I've tried to read through this thread to find the answer to what ails me, but alas, can't find it... I've installed and used the Auto Thumbnailer with much success in the past but for whatever reason, this time around I'm getting grief. Honestly, I don't know if my troubles are due to the Thumbnailer, but I sure hope someone can help... To preface - all product images and thumbnails work wonderfully... It's the catalog thumbnails that aren't showing up. Please see this page: http://wendydewarhughes.com/catalog/index.php?cPath=21 When I go to add in an image for a particular category, I'm getting this error message: Error Error: File upload not saved. And of course, a broken image on the page I posted above. To add to my troubles, if I look at my view sources, not all of the image paths are that similar to: product_thumb.php?img=images/bra pads-header-e-store.gif&w=70&h=57 some, like the "serenity" category, show as: images/serenity-header-e-store.gif Now to clarify - that serenity pic is showing up because I manually uploaded it into the images folder... Can anyone shed some light on the subject for me please?? Thanks
  11. Import has been successfully finished. SQL query: # This install provided by management@betterthannature.com # any questions just email us and we will try to help # Copyright October 23 2004 ALTER TABLE products ADD products_weight_type ENUM( 'lbs', 'kgs' ) NOT NULL default 'lbs' AFTER products_weight, ADD products_dim_type ENUM( 'in', 'cm' ) NOT NULL default 'in' AFTER products_weight_type, ADD products_length DECIMAL( 6, 2 ) DEFAULT '12' NOT NULL AFTER products_dim_type, ADD products_width DECIMAL( 6, 2 ) DEFAULT '12' NOT NULL AFTER products_length, ADD products_height DECIMAL( 6, 2 ) DEFAULT '12' NOT NULL AFTER products_width, ADD products_ready_to_ship ENUM( '0', '1' ) NOT NULL default '0' AFTER products_height;# Affected rows: 9 # Done # this will add the setting in your DB for Canada Post Shipping Module with dimensions 3.4-3.7 IT WORKED!!! THANK YOU THANK YOU THANK YOU THANK YOU!!!! Now I just need to go back and put in the dimensions for the Admin panel and we're off to the races! Did I mention how thankful I am? I was really tearing my hear out and here it was that silly .sql file - I saw it but had no idea what to do with it - thank to you I now do!
  12. This is what is in my PRODUCTS table: products_id int(11) products_quantity int(4) products_model varchar(12) products_image varchar(64) products_price decimal(15,4) products_date_added datetime products_last_modified datetime products_date_available datetime products_weight decimal(5,2) products_status tinyint(1) products_tax_class_id int(11) manufacturers_id int(11) products_ordered I see I don't have the dim_type but you do ... ?
  13. Thank you so much! I am so frustrated right now - I think my troubles began when I installed the shipping module WITH DIMENSIONS as opposed to just the normal shipping module. Update: I went to the shipping module contribution area http://www.oscommerce.com/community/contributions,391/page,2 and installed these files, overriding the previous (with dimentions) install. I then went back and restored all of the files that I manually edited (as per the instructions in the "with dimensions" install.txt file back to their originals (which should have removed all references to the dimensions) I then did another test upload of a new item and it all worked great! Whew! UNTIL I went to the live shopping cart, and tried to purchase that item - now I'm getting the following error when I click on "buy now": 1054 - Unknown column 'p.products_dim_type' in 'field list' select p.products_id, pd.products_name, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_dim_type, p.products_weight_type, p.products_length, p.products_width, p.products_height, p.products_ready_to_ship, p.products_tax_class_id from products p, products_description pd where p.products_id = '35' and pd.products_id = p.products_id and pd.language_id = '1' [TEP STOP] I suspect the mySQL is still remembering the dim_type from the previous install? If so... I'm lost... MySQL: Client API version 3.23.49 PHP Version 4.4.3 Thanks.....
  14. Hi Nim, I'm having my own difficulties with the CP shipping module, but I was able to get to the point of activating the module - did you go through the install.txt file and go through all the Shopping Cart Edits? I think once I did that, then CP showed up in the ADMIN panel to install... I think!
  15. Yikes, that doesn't sound good - what do I do if I don't know MySQL? Is this a web host provider problem? Or am I SOL in using this module?