Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

SusanF

Archived
  • Posts

    16
  • Joined

  • Last visited

Profile Information

  • Real Name
    Susan
  • Gender
    Female
  • Location
    BC Canada

SusanF's Achievements

  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. Thank you Geoffrey, that's all I needed to hear to ensure I didn't mess anything up! Much appreciated, Susan
  3. 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
  4. 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
  5. It's working now - we installed the Paypal IPN contribution and all is well with the world once again :)
  6. 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
  7. 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
  8. 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....
  9. 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
  10. Import has been successfully finished. SQL query: # This install provided by [email protected] # 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!
  11. 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 ... ?
  12. 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.....
  13. 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!
  14. 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?
  15. This is my first post to the osCommerce forum, but I've visited many times and have always found the answers I needed before having to post a plea of my own.. until now... I just installed the Canada Post Shipping Module With Dimensions (latest version) and carefully went through all of the Shopping Cart Edits that were outlined in the install.txt file but have had miserable luck in getting the module to work. When I go to create a new product, and click "insert" to publish it, I'm getting the following error message: 1054 - Unknown column 'p.products_dim_type' in 'field list' 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_dim_type, p.products_weight_type, p.products_length, p.products_width, p.products_height, p.products_ready_to_ship, 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 products p, products_description pd where p.products_id = '32' and p.products_id = pd.products_id and pd.language_id = '1' [TEP STOP] This is just be beginning, the products that were already in my store are now all riddled with error messages too: http://wendydewarhughes.com/catalog/shoppi...art.php?sort=2a Any advice on what to do? Should I uninstall and start over again? I've spent hours already and am getting very frustrated.... Sue
×
×
  • Create New...