Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

mushindo

Pioneers
  • Posts

    251
  • Joined

  • Last visited

Everything posted by mushindo

  1. I have a question regarding this contribution. Forgive me if this question was already answered, but after doing a browse through first dozen of 151 pages on this topic...plus unsuccessful searches, I thought I would see if anyone here knows about this bug. Recent version of this contribution downloaded and installed few months ago. Just discovered by accident that when using FIXED AMOUNT: 10.00 that it is not taking $10.00 off total of order, but rather taking $10 off every SINGLE item in the order. Tried this out myself few times with same results. Can anyone assist me on this? Not sure if this is a setting or known bug or what, but obviously an issue.
  2. Just got done installing USPS Methods 4.3.2 on a clients site and noticed an issue. Domestic is showing option for FLAT RATE BOX, while international shows options for SMALL FLAT RATE BOX, MEDIUM FLAT RATE BOX, and LARGE FLAT RATE BOX. 1. On front end for domestic with DOMESTIC FLAT RATE BOX checked, it is showing MEDIUM FLAT RATE box label and price? Its defaulted to medium at like $10 vs. small for $5.15? 2. How come it doesnt show the options for flat rate small, medium and large under DOMESTIC? Any help on this is greatly appreciated, as my client needs to be able to offer small flat rate for his products, and would like to improve this module to offer all 3 since each client has different needs. Thanks in advance :).
  3. Steve, Sorry I was unable to help out on this. I am as stumped as you right now, since this error line: SQL error Unknown column 'products.manufacturers_id' in 'on clause' Indicates the manufacturers_id is missing from the products table. Anyone else have any ideas?
  4. GREAT NEWS! I am currently working on another update to the automated feeds system which shall include some general improvements, but also include some never seen before feeds! The following are what is being worked on right now, but only time will tell if these will all make the final cut: 1. shopping.com 2. buy.com 3. nextag.com More updates to follow as they are done.
  5. Hello Steve, I am 99% sure that you have a field missing in your PRODUCTS table, which appears to be the manufacturers_id field. Ran into a similar issue with another client, unrelated to this contribution, and that was the end result. Go into your phpMyAdmin tool or other MySQL tool, VIEW the PRODUCTS table. Typically this field is between the products_tax_class_id and the products_ordered fields. If you do not see it there, then for whatever reason it was deleted from your database. Setup the field again as follows into the PRODUCTS table: `manufacturers_id` int(11) default NULL Be sure to let me know if this resolved your issue.
  6. Paulie stated: Not a bad idea, since so many people are using the salesmaker contribution, including me. However since I try to update these contributions to make them universal so they are not dependant upon other contributions, I would probably code this out in such a manner whereby it: A. Tries to check for the salesmaker database table. B. IF exists, then see if any sales exist / don't exist determine product price. c. IF doesn't exist, continue using existing code. Thoughts?
  7. I would assume this is caused since most SEO URL systems do some rework to the /catalog/includes/functions/html_output.php tep_link function, but no corresponding updates to the admin area, which is really not needed anyways. The store feed files build their links using the /admin/includes/functions/html_output.php tep_link function versus the front end one, so thus it would not create SEO friendly URLs automatically. Since I am unsure which SEO contribution you are using, and assuming that it DOES do a modification to the tep_link function, my suggestion would be one of two things: 1. Modify your admin tep_link function (not suggested) 2. Modify the contribution store feed files to pull from the frontend tep_link function instead of the admin one (not easy, but doable) 3. Copy the tep_link function from your /catalog/includes/functions/html_output.php file, into the /admin/includes/functions/html_output.php file....rename that function say 'tep_link2' anywhere in the store feed files, then try running again to see if it works okay for you. Let me know if this helps.
  8. Hello Jessica, Without any additional information or php error code, it is bit of a guessing game for me to try to troubleshoot for you on this. Best suggestion is for you to ensure that your /feeds/ folder is set via ftp to CHMOD 777, which is a very common reason why it may not be working. Let me know if this helps or if you figured out a solution already in advance, what you did to resolve so others can benefit from this.
  9. GOOGLE BASE CONTACT: This is the URL to use to report issues with your google base account. This can be used for reporting FTP problems, or issues with your bulk upload. http://base.google.com/support/bin/request.py
  10. FTP LOGIN ISSUE: With the revamp of Froogle, now called Google Base, their system now requires you to do the following for creating a bulk upload for your store: 1. Create a bulk upload: indicate filename, title, description, and optional URL. 2. Create a new FTP account: many people miss this one and just use the email / password to FTP into google for uploading bulk uploads. The issue I have run across today, and confirmed with 3 other customers, is that after setting up an FTP login set and including it into your admin "feed settings" section, it continued to come back with the FTP connection errors most people are reporting. My next step in troubleshooting was to attempt to use these logins via a browser and an FTP client, with logic being IF I can successfully login via browser or FTP client, that indicates the issue is most likely not with the coding but with Google. Sure enough I plugged in uploads.google.com then my username and password into an FTP client, and it rejected it. This may or may not be the reason so many people feeds are being rejected, but if you do experience a FTP error when running your feed, I suggest you take your logins and plug them into an FTP program first. If it rejects it, then report it to google. If not, then report it back here with the exact error to help us improve the code. Thanks.
  11. A few people have reported running into errors like the following when running the froogle.php page: Here is an explanation of this error and a solution. 1. OPEN /ADMIN/FROOGLE.PHP. 2. Search for: $OutFile = DIR_FS_DOCUMENT_ROOT."feeds/".FROOGLE_FTP_FILENAME; The issue causing this for some people is the DIR_FS_DOCUMENT_ROOT variable, found within the /admin/includes/configure.php page. Here is an example of a common definition for this variable that will toss that error: define('DIR_FS_DOCUMENT_ROOT', '/home/somesite/www'); // where the pages are located on the server And here is the proper way this should be listed: define('DIR_FS_DOCUMENT_ROOT', '/home/somesite/www/'); // where the pages are located on the server Notice at the end of the second example there is a / after the www. Without this / you will continue to run across this problem. You have one of two solutions: A. Change this in the /admin/froogle.php page from this: $OutFile = DIR_FS_DOCUMENT_ROOT."feeds/".FROOGLE_FTP_FILENAME; To this $OutFile = DIR_FS_DOCUMENT_ROOT."/feeds/".FROOGLE_FTP_FILENAME; B. Change the DIR_FS_DOCUMENT_ROOT in the /admin/includes/configure.php from this: define('DIR_FS_DOCUMENT_ROOT', '/home/somesite/www'); // where the pages are located on the server To this: define('DIR_FS_DOCUMENT_ROOT', '/home/somesite/www/'); // where the pages are located on the server Hope this helps out.
  12. In response to the numerous reported issues and suggestions I have received so far for this contribution, I am starting a new thread to discuss: - reported bugs - fixes made - suggested improvements Over the coming few weeks I will be making some improvements to the coding to combat against incompatibility errors many people have found with the automatic uploads, plus adding some new features in based upon your feedback. So anyone having issues or suggestions for improvements I ask that you post them here, and I will post either fixes, or notifications once new versions have been released. Thanks.
  13. Have a client who requires addition of multiple productions into each page. This is not a "family of products" type of setup. The store in question is selling bed linen sets, etc, whereby they want to show something like this: PRODUCT SET NAME General description MODEL STYLE DESCRIPTION COLOR WAS (RETAIL) OUR PRICE QUANTITY DUVET SET (this is first product in set) 12345 Single Some text [dropdown] $50.00 $40.00 [textfield] 56789 Single Some text [dropdown] $50.00 $40.00 [textfield] PILLOW COVERS (this is second product in set) 54585 Single Some text [dropdown] $10.00 $7.00 [textfield] Get the idea? Any contributions close to this or good for a core start? Thanks.
  14. Do you have extra weight added to your items? Check in ADMIN > CONFIGURATION > SHIPPING / PACKAGING: Package Tar weight. That would be the only place I could guess it may be coming from. If that is 0 or null, then you have a problem elsewhere.
  15. Same one I am using I believe. Its the one that places a product_thumb.php into your /catalog/ directory, correct? Works like a charm! I even took it as far as adding a code snippet to the install files so it will check to ensure the hosting account is compatible with this contribution. If not, it gives a message and tells me / someone else "The automatic thumbnail generation system is not compatible with your hosting account, due to not having the GD library installed. To avoid errors, please replace /includes/functions/html_output.php with /includes/functions/html_output.backup.php" Gets the point across and reminds me on new installs if it will work or not :).
  16. NOTE: I am not looking to hire anyone on this. I am simply looking for advice that anyone may have on a creative solution. DO NOT PM me or post a message saying you could do this work. Wanted to clarify this to meet with board rules. --------- Here is an interesting challenge presented by one of our customers that I am looking for advice on from people here who have worked with or customized osc shipping modules: Customer store has the following items installed and turned on: - UPS XML Shipping Module - USPS Methods - Free Shipping over $x The UPS and USPS modules are the ones retrieving real time quotes on shipping options to show the customer. The "free shipping over $X" of course is set to a dollar amount of choice and when a customers order reaches that total, it doesnt show any other shipping options and simply tells them they qualify for free shipping. NOTE: For those of you who are using this, it is found under MODULES > ORDER TOTAL > SHIPPING: where you can indicate a dollar value and turn free shipping on or off. ------------- Now that everyone is up to speed, here is the challenge: Basically the customer wishes to use all 3 of these. Easy enough and works beautifully. However the challenge comes into play on two items: 1. If customer qualifies for free shipping, they want the cheapest shipping options shown as $0 and preselected. Say the cheapest method is USPS Priority mail, it would have that option preselected and show $0. So obviously with USPS and UPS on, the cheapest option selected will likely be Priority Mail or UPS Ground. The main reason for this, is so when the order from oscommerce is sent to their warehouse, the warehouse will know exactly which shipping option / carrier to use for this order. 2. It would show all other shipping options, so if the customer doesn't want the free option, they could instead select say UPS Overnight. ------------ As you can see, quite the challenge especially since the default FREE shipping module, by passes all other shipping modules IF customers order meets the free shipping dollar value. Pulling my hair out trying to figure out a solution for this one. Do any contributions exist for this, or if anyone has some ideas?
  17. Hello Dave, Wonderful contribution. I added to it a bit just to show some user friendly instructions within admin tools to help developers and customers alike to set this up properly. Please feel free to critique it. Now onto my questions: ----- 1. Weight Issue: Ran into a bit of an issue / unexpected bug. Here is the problem: For those not aware, USPS Priority only allows up to 70 lbs. When I added more items to my cart and the total weight came over 70 lbs, it comes back with an error and won't retrieve ANY of the USPS shipping methods. As soon as I got the weight down below 70, it worked fine again. Any suggestions? 2. Order: Is there any way to reorder the available shipping options during checkout to show cheapest to most expense? The UPS XML system does a wonderful job of this. ---------- Any help you can provide on these items is greatly appreciated.
  18. The contribution I am referring to is the USPS Methods shipping module found below: http://www.oscommerce.com/community/contributions,487/ And yes that is me who released the latest version, but only added a help page and did not edit the original contribution coding. :P Ran a test today specifically by adding items to my cart equaling roughly 65 lbs. No problem, it showed me all applicable USPS shipping methods and correct pricing, including priority mail. Here is the problem: For those not aware, USPS Priority only allows up to 70 lbs. When I added more items to my cart and the total weight came over 70 lbs, it comes back with an error and won't retrieve ANY of the USPS shipping methods. As soon as I got the weight down below 70, it worked fine again. Has anyone run into this and more importantly, figured out a solution for this? Any help is greatly appreciated!
  19. I figured out how to get the title dynamically created by adjusting the header_tags.php page, but still cannot figure out how to dynamically fill the product_descriptions table for the new header controller fields. Any help is greatly appreciated. Thanks in advance.
  20. Thanks for the help. This does help me somewhat, but main thing I am trying to do within the product_info.php page is: Pretty much Im trying to use a query to update the database with existing fields into the new fields for the meta tags. Another reason why I am choosing to do it this way is since my client hs requested that his website be spidered by search engines so someone could put in a modle number or a product name and see his site come up. Long story....anyways..lol. I know it should jsut be two quick queries, but everytime i try it my coding bombs out. My coding was so bad on this page truthfully I deleted it completely otherwise I would post it here. Any help is greatly appreciated.
  21. I also realized that it may be possible to insert the product_name, product_model, product_manufacturer all into the keywords field. Also would it wreck anything if i tried to move the main prdocut inquiry near top of page, just above the page title but below these two new queries? Thanks.
  22. I thought my last post on this was deleted since i could not find it to add to it. Check it out in better detail here: http://www.oscommerce.com/forums/viewtopic.php?t=56849 Thanks.
  23. Hello, I have a great idea on customizing the header controller a bit to automate some things, but cannot figure out how to do it. Here is the overview: 1. Have a client with over 2000+products who we installed the header controller contribution for. 2. they dont have the time to manually enter for each product into the new title, keywords, and description fields for meta tags. I am tryign to come up with a solution for automating this and have a good idea but keep running into problems with coding. I figure if I was to add a two queries into the product_info.php page: 1. new query to ull product info based upon product_id passed in URL. 2. Second new query to update the product_description table would automatically push these: product_name value into the product_meta_title field product_model and product_name and manufacturer (if possible) into the product_meta_keywords field. product_description into the product_meta_description field. This way in theory if these two queries are run at top of page BEFORE it creates the title and meta tags, then by the time the regular product query hits the page, it will be updated automatically and display. My coding keeps bombing out. Any suggestions? Any help is greatly appreciated.
  24. We have oscommerce MS1 installed for one of our clients with the header tags controller, and admin tools for it to allow custom title, keywords and description meta tags on a per product basis. This client currently has over 1500 products though, and wouldnt have the time to write up titles, keywords and descriptions for each individual product. What our idea is, on the product_info.php page, is to run two new queries: 1. First query shall call upon product record, based upon the passed URL product_id. 2. Second query shall update the product_description table within oscommerce, by doing the following: a. taking existing product name, and adding that into the product_meta_title field for same product. b. taking existing product description, and adding that into the product_meta_description field for same product. c. taking existing product name AND model, and adding that into the product_meta_keywords field for same product. Then in theory, the next time the page reloads for this product, the header controller will kick in and show the new automated title, keywords and descirption meta tags directly from the database! I have tried adding the coding manually at the top of the product_info.php page but it keeps tossing errors. I am still learning bit more about PHP, so could anyone help me with this by providing a block of coding for me to use that WOULD work? Thanks in advance! :)
×
×
  • Create New...