Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

macmizer

Members
  • Content count

    63
  • Joined

  • Last visited

Everything posted by macmizer

  1. macmizer

    photo gallery for oscommerce

    Is there a way with the gallery to set it up so that you can upload any height and width image. Right now it is limited to 800 wide by 600 high. I know I cna just change those values but I don't want to keep guessing what size is a good size to set. I am also concerned about file size. It is set to 100000 right now. I know I can change all these values but what would be a good size? The way it is now is just not user friendly. Customers would have to know how to resize their files and if they have to do those additional steps they may get annoyed and end up not uploading at all.
  2. macmizer

    photo gallery for oscommerce

    Has anyone installed this contribution into cre loaded?
  3. macmizer

    photo gallery for oscommerce

    Ok I understand that part. Now I just need to find out why I am getting that sql error mentioned earlier. 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',,,3,,,,,,,,,,,,,,,,,,,,) and c.categories_id = cd.categories_id and cd.language' at line 1 select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id in (4,3,3,3,3,3,3,3,3,3,4,3,3,3,3,3,3,3,3,3,3,3,3,3,3,,,,,3,,,,,,,,,,,,,,,,,,,,) and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name
  4. macmizer

    photo gallery for oscommerce

    I am having the following error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',,,3,,,,,,,,,,,,,,,,,,,,) and c.categories_id = cd.categories_id and cd.language' at line 1 select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id in (4,3,3,3,3,3,3,3,3,3,4,3,3,3,3,3,3,3,3,3,3,3,3,3,3,,,,,3,,,,,,,,,,,,,,,,,,,,) and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name I reimported the gallery.sql and made sure the extra space before the last semi colon was removed. But it had not effect. There was another person in this forum that had the same error. I am not running 5.0 or higher of mysql either. I am running version 4.1.22 I get this error when I go to my main site. When i go into admin all I find is a Gallery link under configuration and once I click on it the page on the right shows "Clean up thumbnail folder" There is nothing else in that window under admin. SHouldn't I have more things to configure or look at?
  5. I have two suggestions. If you want to PM me I can arrange for an explanation but to document the many approaches I took is just too much for me to type out.
  6. I have implemented this contribution into a cre loaded store. I attempted this installation even though the I have cre loaded and not osCommerce. I have used both osCommerce and CRE loaded many times. My reason for attempting the installation is due to the fact that the documentation makes it seem very straight forward. Well I thought so at least. I am very close. I have the More Categories link showing under the Configuration section but I do not have the More Categories showing under Catalog at all. Nothing new there. I think it may be an issue with the file called catalog/includes/column_left.php. this column_left.php however is not used for the admin from what I can tell. I believe the file that should be showing the More Categories under Catalog in the admin is catalog.php. I did have an issue with the file located at admin/includes/boxes/catalog.php. Below is the code from that page. You will notice that I could not use the same exact code given to me in the readme.txt for the contribution. Does anyone know what may be causing this issue of not seeing the More Categories inside of the Catalog menu? <?php /* osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2002 osCommerce Chain Reaction Works, Inc Copyright © 2005 - 2006 Chain Reaction Works, Inc. Last Modified by $Author$ Last Modifed on : $Date$ Latest Revision : $Revision: 705 $ Released under the GNU General Public License */ ?> <!-- catalog //--> <tr> <td> <?php $heading = array(); $contents = array(); $heading[] = array('text' => BOX_HEADING_CATALOG, 'link' => tep_href_link(FILENAME_CATEGORIES, 'selected_box=catalog')); if ($selected_box == 'catalog' || $menu_dhtml == true) { $contents[] = array('text' => tep_admin_files_boxes(FILENAME_CATEGORIES, BOX_CATALOG_CATEGORIES_PRODUCTS) . tep_admin_files_boxes(FILENAME_PRODUCTS_ATTRIBUTES, BOX_CATALOG_CATEGORIES_PRODUCTS_ATTRIBUTES) . tep_admin_files_boxes(FILENAME_PRODUCTS_CATEGORY_OPTIONS, BOX_CATALOG_CATEGORIES_PRODUCTS_CATEGORY_OPTIONS) . tep_admin_files_boxes(FILENAME_PRODUCTS_MULTI, BOX_CATALOG_CATEGORIES_PRODUCTS_MULTI) . tep_admin_files_boxes(FILENAME_MANUFACTURERS, BOX_CATALOG_MANUFACTURERS) . tep_admin_files_boxes(FILENAME_REVIEWS, BOX_CATALOG_REVIEWS) . tep_admin_files_boxes(FILENAME_SHOPBYPRICE, BOX_CATALOG_SHOP_BY_PRICE) . tep_admin_files_boxes(FILENAME_XSELL_PRODUCTS, BOX_CATALOG_XSELL_PRODUCTS) . tep_admin_files_boxes(FILENAME_FEATURED, BOX_CATALOG_FEATURED) . tep_admin_files_boxes(FILENAME_PRODUCTS_EXPECTED, BOX_CATALOG_PRODUCTS_EXPECTED). tep_admin_files_boxes(FILENAME_MORE_CATEGORIES,BOX_CATALOG_MORE_CATEGORIES) . tep_admin_files_boxes(FILENAME_PRODUCTS_EXTRA_FIELDS,BOX_CATALOG_PRODUCTS_EXTRA_ FIELDS)); //Admin end } $box = new box; echo $box->menuBox($heading, $contents); ?> </td> </tr> <!-- catalog_eof //-->
  7. Yes I do understand about working on free contributions. ;-) Just wanting to make sure that I understand what the code was supposed to do. So does this mean there is no such feature yet in the code called Gift Voucher? Can someone confirm that I am correct in my evaluation of the feature set for the Discount Coupon piece? Rob.
  8. I have installed the following per a reference from GLCustoms here on oscommerce forums: http://addons.oscommerce.com/info/5743 It is called Gift Voucher (GV) and Discount Coupons (DC) for RC1, RC2, RC2a Luckily I had installed a brand new fresh copy of Ver 2.2 RC2 so all I had to do was overwrite files. I did so and loaded the sql tables that came with it. But when I follow the instructions to install a Discount coupon and it seems that this add on has alot less features then I would expect for a discount coupon feature. I can't even assign the coupon to a specific product or category or limit how long the coupon is good for. Furthermore, I do not see anything in the admin interface that pertains to Gift Voucher. This contrib refers to Gift Voucher and Discount Coupons. Where is the Gift Voucher config? Why does the discount coupon seem so limited?
  9. I see that the Discount Coupon Codes has several files on the contribution section. But for the past 5 or 6 uploads they are just fixes. I wanted to get a full copy of the Discount Coupon Codes with all the fixes embedded into it. Unless I am stuck downloading the full package from Sep 27, 2007 called Discount Coupon Codes 3.31. Please tell me I don't have to dowload the other 6 updates after that. Looks like the latest full package was on Sep 27. What is the difference between this contribution Discount Coupon Codes and the coupons built in already with osCommerce?
  10. macmizer

    Discount Coupon Codes download

    Please see my message below. I fixed the one issue with the discount not showing on the order on the customer side. I had to fix the sort order inside of Admin/modules/coupons. The sort order number was the same as another Order total item. Now I see the discount being applied. Please read the rest below. I cannot see anything that pertains to Gift Voucher and the Discount. Only see a very limited Discount Coupon contribution.
  11. macmizer

    Discount Coupon Codes download

    I have installed the following per a reference from GLCustoms here on oscommerce forums: http://addons.oscommerce.com/info/5743 It is called Gift Voucher (GV) and Discount Coupons (DC) for RC1, RC2, RC2a Luckily I had installed a brand new fresh copy of Ver 2.2 RC2 so all I had to do was overwrite files. I did so and loaded the sql tables that came with it. But when I follow the instructions to install a Discount coupon and it seems that this add on has alot less features then I would expect for a discount coupon feature. I can't even assign the coupon to a specific product or category or limit how long the coupon is good for. Furthermore, I do not see anything in the admin interface that pertains to Gift Voucher. This contrib refers to Gift Voucher and Discount Coupons. Where is the Gift Voucher config? Why does the discount coupon seem so limited? Another problem... no discount is being deducted from the order. I cash/cod set right now as a payment module. When I enter the coupon code where applicable, no discount appears for that order even if I confirm the order. I have tried either fix amount for a discount or percentage. Neither shows a deduction on the order.
  12. macmizer

    Discount Coupon Codes download

    What is the difference between the MS version of osCommerce and RC version of osCommerce? I just installed the RC version since that is what I found on the downloads section of this oscommerce.com site. So now I have a fresh install.
  13. macmizer

    Get 1 Free

    I have added this contribution and it seemed to be working fine at first. For example, we setup all 5 products we have in the catalog to offer buy 2 and get 1 of the same product free. If I go to any one of the products and say Buy Now it will allow me to change the quantity from 1 to 2 and then I will see two different items in my cart. One will show the two products I am buying as well as the total price for both and then it will show a 2nd pic of the same product I ordered 2 of. This time on the 2nd item it will show quantity of "1" and no cost. This is all well and good. But here is the problem, all of the products we sell have an attribute for the different flavors we sell. So for one product I may have three different flavors. If I order one chocolate and one vanilla, the buy 2 get one free does not work any longer. I can order one chocolate and then one vanilla and then add one chocolate again for a total of 2 chocolates. Then I have three line items in my cart, the one vanilla with a price next to it, 2 chocolates with the total of both items then a third line item that shows a price of $0.00. Now the first two line items have the name of the flavor right below the product name but for the freebie item it never shows the flavor the person is getting which in my test case would be chocolate. Is there some kind of workaround for this? Since the admin piece does not give me control over the attributes of the product I don't see a way around this. So if I have 3 to 5 flavors of a product I will have to create 3 or 5 seperate products all with identical info and just change the name of the product to include the flavor. Not an option we want to do. So to recap there are two issues, teh free product does not show the attribute of the product that is included free and when buying two of one item if there is an attribute involved it will not work either. Anyone have any ideas?
  14. I am running CRE loaded 6.15. I have merged the code from QTPro 4.25 into the CRE Loaded. All looks fine.. I can get through all pages with no more syntax errors or parse errors etc. I can order a product and once I confirm the order I see in the admin that the overall stock quantity is reduced. But the stock attribute quantity is not. So for example, a t-shirt, I set in the admin for that product that I have a total of 10 t-shirts. I have two stock attributes with the following quantities: small 2 medium 2 I go to the cart, order 1 small and 1 medium then I get the email about my order. The email matches what I bought, the over stock of 10 is reduced by two (2). But when I click the Stock button for that product the Small still says 2 and the Medium still says 2. I went through every single page in this forum thread before posting this question. i tried the fix from helpneeder and a few others. But nothing seemed to fix the problem. I did see alot of talks about this contribution and osCommerce and the Paypal contrib. The paypal is installed as well. But to simplify things for now I was buying the product using the check/money order option so I can stay on the shopping cart and not get redirected. I tried different combinations of the shipping methods and purchase methods but everything behaves the same way... no deduction of the stock for the attributes.. Maybe someone can help. I was thinking to start, someone could tell me the exact page that actually does the update to the stock attributes or "should" do the update to the stock attributes. Rob.
  15. I am getting this same problem. I have installed the latest version of this contribution. I took it from the contributions here and it is called Shipdate v2.3 Terra 8 Nov 2006 After doing the installation and rechecking everything three or four times I get the following on the checkout_shipping page. It states the title fo the page Delivery Information then right below it there is "Select Arrival Date" but then the rest of the page is blank. My webserver error log states: PHP Fatal error: Cannot redeclare class shippingschedule in /var/www/vhosts/t5photo.com/httpdocs/includes/classes/shipsched.php on line 3, referer: http://www.t5photo.com/shopping_cart.php I am not sure why I am getting this type of error. Can anyone help?
  16. I have installed the latest version of this contribution. I took it from the contributions here and it is called Shipdate v2.3 Terra 8 Nov 2006 After doing the installation and rechecking everything three or four times I get the following on the checkout_shipping page. It states the title fo the page Delivery Information then right below it there is "Select Arrival Date" but then the rest of the page is blank. My webserver error log states: PHP Fatal error: Cannot redeclare class shippingschedule in /var/www/vhosts/t5photo.com/httpdocs/includes/classes/shipsched.php on line 3, referer: http://www.t5photo.com/shopping_cart.php I am not sure why I am getting this type of error. Can anyone help?
  17. macmizer

    Fancier Invoice & Packingslip v1.0

    I removed all the code pasted into my reply so as to keep this answer shorter. Looks like your problem is that you are missing a file. There should be a file located here /admin/includes/languages/english/invoice.php This invoice.php file contains such things as the define('INVOICE_TEXT_INVOICE', 'Invoice'); Which would get rid of the INVOICE_TEXT_INVOICE and replace it with Invoice. Let me know how you make out. Rob.
  18. macmizer

    Authorizenet

    I have this contrib installed. But I had only tested it with the credit card module not the authorize.net credit card payment method. We use the authorize.net payment method only in production. When I put this code into production, a simple copy of the files, I looked at some orders we received last night and today after the installation. The issue: No orders using the authorize.net module are displaying the credit card number in the order details when I go into the cart admin interface. If I use the non authorize.net credit card payment method, again not what we want to use, I can see the credit card number and expiration etc. Shouldn't I be able to see the credit card number for authorize.net payments? What about paypal. If a client uses paypal to pay by credit card can we trap the credit card number as well? I read the documentation and it did not say it works with any credit card module we use and the docs also do not say it will not work with certain credit card payment modules. Is anyone having an issue such as this?
  19. macmizer

    Fancier Invoice & Packingslip v1.0

    What is the url, page name that you see in the browser? This is the link url you clicked on. I am assuming you are running MS2 of oscommerce not another version like CRE Loaded??
  20. I installed the Fancier invoice contrib and had one issue but cleared that up. Now what I want to confirm is the email I receive for the order. At the very bottom it has a section that looks like this: Payment Method ------------------------------------------------------ Credit Card Now my question is. Should the credit card details be included as part of this contrib? Should I be seeing the credit card number etc in that section? Where are all the places where the full credit card should be displayed when using this contribution? Rob.
  21. macmizer

    Fancier Invoice & Packingslip v1.0

    Well I went ahead and redid my /catalog/checkoout_process.php file I did this because I had a parse error when trying to test this mod and buying something. During the checkout process I got a parse error. So I took my original checkout_process.php page, it was also modded a month ago to work with QTPro. I took the file and inserted the code that was in the install.html file for this Fancier Invoice contrib. Then I was able to purchase something using the credit card payment module, i did not use Authoriznet payment module or paypal. I then received an order in the admin of my oscommerce. The order contained all the information about the credit card, including all digits of the credit card type. Hope this helps to some extent. Maybe take another look at your checkout_process.php page. Good Luck.
  22. macmizer

    Fancier Invoice & Packingslip v1.0

    Sorry I did not get an email that someone responded to my message. Tonight I logged on to see if anyone answered my question and Julie, that was when I saw your post. Here is the contribution/version I installed: Fancier Invoice & Packingslip v6.2_1
  23. macmizer

    Fancier Invoice & Packingslip v1.0

    I have installed this contribution and one of the main reasons why is so that I can see the credit card number in the admin details for the order. Many of my clients will place an order and then call up or email with a change to the order. In all the cases it involves me charging more for the order so I can update the order but without the credit card number displayed I have to ask the client for the card number again and that of course irritates them and more importantly slows down the fulfillment process because we end up playing phone tag. I use authorizenet for credit cards and we also use Paypal. So in both cases if the client uses the credit to pay for the order we want to be able to see that info on the order details under the admin interface. What I am confused about is how would the shopping administration interface know the credit card number if I do not see any credit card numbers in the database? I tried to look around in the database to see if credit card numbers are stored but it looks like that is a NO... What is stored in regards to the credit cards that customers use? Does osCommerce just pickup the last 4 digits or so? Rob.
  24. macmizer

    Product Listing in Columns v2.0

    I recently installed this contribution. Everything looks fine but I have one issue so far. When I add something to the cart and click checkout it brings me to login.php page and it does show me the additional section which states " Do you want to go straight to the checkout process? Would you like to check out without creating a customer account? Please note that all of our services will not be available to customers that do not wish to create an account. Also, you can not view the order status of your order, and each time you have to shop with us you will have to re-enter all of your data. Creating an account is Free. If you still wish to continue to checkout please click the checkout button to your right." I can see a button labeled Checkout. I have seen other sites that have this contribution installed and when you click on that button it will bring you to a page to fill out your name address etc. But for me when you put my mouse on the Checkout button it is showing me this url https://www.grafitechic.com/shop/create_acc...php?guest=guest but when I click on the button it takes me to the page that has the product on it where I can click on Update, Continue Shopping or Checkout. It does not behave the same way the other sites I have seen do. Anyone have an idea what is happening? Just so you know this is the latest version of osCommerce with no previous installations of contributions. and the page looks
  25. Actually I did not post there as I did not find many posts at all about QT Pro there. I will do so anyway. I figured even though it is QT Pro with CRE that this is a typical type of coding issue. Just have not found an answer yet. Thanks.
×