Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

shawnm

Archived
  • Posts

    54
  • Joined

  • Last visited

Everything posted by shawnm

  1. OK Update. I think it is a bug, or else it calculates different that what I am thinking. The default settings for commission is stored in the admin under Configuration. If you update an individual commission rate, the affiliate will still get the default commission rate. If you delete the default commission rate, then each individual affiliate commission rate will then be used. It seems like it should be the opposite, or else it is a bug. You should be able to have a default commission rate, and if you update an individual affiliate commission rate, then the default is ignored and the individual rate is used. Am I missing something or doing something wrong? Thank you.
  2. When I change an affiliates individual commission here: Pay per Sale Payment % Rate: 8% And normal commission is 10%... I look at the Participating Affiliates in the admin... and it still shows 10% commission in Commission column in the middle of the screen... but when I click on that affiliate, on the right side column it shows 8%. Is there something wrong with my setup or is this normal? Thank you for any advice you can give me. Shawn
  3. DJmonkey... thanks a bunch! I see that now... I never created a new order to try to edit it... I was just looking at old orders. Thanks for the help on the tax issue! Shawn
  4. I have installed tons of contributions... however I am just not getting this one. I installed it and I see Category Fields in the admin section. When I click on that I see: Field Name Category Type Sort Order. I add that, but I do not see where you can input text at? How do you add text to show under the subcategories? Thank you, Shawn
  5. Thanks the makers of this wonder contribution. The latest release has a typo in the code though... Error in code: make_an_offer.php Line 45: $products_price = $currencies->display_price($procuctid... Correct code: $products_price = $currencies->display_price($productid... Another feature that would be nice to have for this contribution, and I am not sure if it is doable or not... Have the offers post in the admin control panel. You could have check boxes for all the offers on one page, Offer Accepted or Offer Declined. The page could show the original price and the offer price for easy viewing. The admin could easily go through 100 offers for all the various products in a matter of seconds and accept or reject them. If the offer is accepted, the customer is sent an email verification link. When the user clicks that unique link, the user is taken to the shopping cart with the item in it for the accepted offer price. If it is declined, a typical "im sorry" email is sent to the customer. This would put this contribution over the edge! Anybody think it is doable? Thanks, Shawn
  6. Default shipping tax rate is not working I don't believe. I have changed the default shipping from 0 to 8 in the shipping_tax table. Also, in the my store config in the admin "select a tax class" I have defined as Taxable goods. The default tax rate appears for the products, but not for shipping. I can of course manually type it in. Just wondering if I missing something else, or is it a bug? Great contribution by the way. Using v3.0.2.1 with bug fixed, digitally remastered version. Thank you, Shawn
  7. Is there a way to only allow customers to use 1 coupon if they have 2 valid coupons? I was wanting two different coupons being advertised in different places, but I do not want the two combined on checkout should a customer get their hands on both of them. Is this possible? Thanks, Shawn
  8. Is there a contribution that will automatically fix spelling problems from the end user. Like google has, an example would be the user types in "trucsk" and the contribution would say "did you mean trucks". Anything similar to that available? I have searched but havent seen anything. Thanks, Shawn
  9. Jack, Thanks again... here's the update in case anyone else is having a problem... It appears that Easy Populate will create a new manufacturer if it doesn't exsist, however it will only create the manufacturer in the manufacturer table, not in both the manufacturer table and the manufacturer_info table. The manufacturer_info table is left blank. So, what I did was go through all the manufacturer's and input this into MySQL: INSERT INTO `manufacturers_info` VALUES (434, 1, '', 0, NULL, NULL, NULL, NULL); That fixed my manufacturers not being listed on the Manufacturer page and allowed me to edit and upload a picture for each manufacturer. Not sure if it's a code problem on Easy Populate or what... but I just wanted to post this to maybe help someone out... Thanks again Jack, nice contribution! Shawn
  10. Jack, Thanks for the quick response... I think i may have found the problem... I noticed that my categories no longer have pictures as well... I used Easy Populate to upload most of my products and that is what created most of my categories... is it possible that by using Easy populate, it did not create or update both tables? Cause I am looking in MySQL and it is showing all of my categories and it is showing my pictures, but for some reason it is not displaying the pictures to go along with it.... What do you think? Thanks again! Shawn
  11. Jack, congrats to the great contribution! Very very nice! One quick question... I just installed the latest version... Header Tags Controller v2.5.9 Complete Jack_mcs 25 Apr 2006 and I am having an issue with the manufacturers page in the admin section. It appears to only be listing Manufacturer's that have info listed in the manufacturers_info table. I checked MySQL and I have about 300 manufacturer's, however only about 10 of them are listed in the manufacturers_info table. Those are the 10 that are showing up when I am at the Manufacturers section of the admin. All the manufacturers show up those in the online catalog in the manufacturers pulldown menu. Does the Manufacturers section of the admin now require all manufacturers to have a manufacturers_info listing as well as it seems that is where it is pulling the manufacturers from. Or is this a bug? Thank you, Shawn
  12. Can you please tell us exactly what you did, because I installed v2.1d and it is still not working correctly. When I have the redirects enabled... the manufacturers pull down menu does not work. Thanks, Shawn
  13. UPDATE: THIS MAY HELP YOU IF YOU ARE HAVING PROBLEMS. I think I just fixed my problems... I turned off this: Enable automatic redirects? FALSE This will activate the automatic redirect code and send 301 headers for old to new URLs. I set that to False and now it works perfect! I thought the redirects being set to true meant that it would redirect the old URLs to the New URLs... not sure why, but setting this to False seems to make everything work right. Thanks to anyone who can add input to this subject. Shawn
  14. Ok, I just noticed that my manufacturer's listing is not redirecting either. It is given me product not found on every manufacturer. Can anyone help with this? Thank you, Shawn
  15. When I type in a URL to test the redirect it does not work... Here is an example, I took out my domain so the forum would not shorten the URL. Let's say I type in this: /catalog/product_info.php?products_id=15 It will redirect to this: /catalog/product_info.php?catalog=product_info.php and it will show "No Product Found." Any ideas?
  16. Hey all, quick question. I just installed Ultimate SEO URLs 2.2 release date: 8 April 2006... and having a small problem. When I try to call my old URL, it does not redirect... example I use this URL: http://www.mydomain.com/catalog/product_in...oducts_id=15106 and it tells me "Product Not Found" Any idea why this is happening or what I can do to fix it? Thank you, Shawn
  17. I have spent many of hours trying to get this with still no luck. My cart is adding tax on the shipping charges, which it is suppose to do, however the tax added to shipping is not being carried to the final total. Is there anyway for me to simply add tax to the shipping charges for the final total? Example lets say my total tax is $5. My shipping charges tax is $0.50. My cart will show tax is $5, but when you add up the total, it is 50 cents short. The solution seems a like a simple fix but i just can't find it. Thanks again, Shawn
  18. I have a strange problem. This is the results I am getting when someone checks out: Sub-Total: $153.79 United Parcel Service (1 x 11lbs) (Ground): $9.55 Tax (Texas Only): $13.48 Total: $176.03 If you add it up it should be: 176.82. The total is not adding in the tax on the shipping charges. In the tax portion it is added in. But that addiontional .79 for the taxable shipping is not carried on to the total. Any ideas on this? I believe this started happening when I installed CCGV. I know it worked before. Thanks in advance, Shawn
  19. This mod seems great, but I have one question. Is there anyway you can print it out according to catagory or sub categories? It seems that it prints out in alphabetical order. Being able to specify which categories to print or what order to print them would be great. Thanks. Shawn
  20. Wrong message board, this should have been posted in the EasyPopulate message board. Sorry. I tried to delete my own message, but I dont think you can.
  21. I am having a problem with timeouts. I now have over 13,000 products and when I try to download the complete file, it timesout with a 500 error. I have tried to send the complete file to the temp directory and download it via FTP, but it still timesout now that I have added more products. Any idea how to get around this? Thanks in advance, Shawn
  22. Very nice contribution! I love Click For Price! I am trying to get this to work with Seperate Pricing Per Customer, this contribution: http://www.oscommerce.com/community/contributions,716 Has anyone gotten this to work? If so, how did you go about doing it? Thanks in advance, Shawn
  23. I am slowly learning PHP I think! hehe. Not really I am still an amatuer. I got MAP to work with SPPC. If anyone needs help with this please PM me and I will help you out if I can. Special thanks to JanZ and Marvin Miller for all of their hard work. I'm sure this contributition took tons of hours to create and they give it to us free and offer us all the free support they can and I think that is wonderful. Thanks guys for everything you do and congrats on the great contribution! Sincerely, Shawn
  24. I am running into some problems and need some help please. I have installed Seperate Pricing Per Customer and I already had MAP (Minimum Advertised Pricing) installed. This is the error I am getting on product_info.php: Parse error: parse error, unexpected T_ELSE in /homepages/25/d103504835/htdocs/catalog/product_info.php on line 102 Here was my working code (starting on line 79) for product_info.php before installed SPPC: } else { $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_retail_price, p.products_price, p.products_map, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_info = tep_db_fetch_array($product_info_query); tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and language_id = '" . (int)$languages_id . "'"); if ($product_info['products_price']<$product_info['products_map']){ $products_price = '<a href="' . tep_href_link(FILENAME_CALL_FOR_PRICE, 'products_id=' . $product_info['products_id']) . '">' . CLICK_FOR_PRICE . '</a>'; }else{ if ($new_price = tep_get_products_special_price($product_info['products_id'])) { if ($new_price<$product_info['products_map']){ $products_price = '<s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s> <a href="' . tep_href_link(FILENAME_CALL_FOR_PRICE, 'products_id=' . $product_info['products_id']) . '">' . CLICK_FOR_PRICE . '</a>'; }else{ $products_price = '<s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>'; } } else { $products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])); } } if (tep_not_null($product_info['products_model'])) { $products_name = $product_info['products_name'] . '<br><span class="smallText">[' . $product_info['products_model'] . ']</span>'; } else { $products_name = $product_info['products_name']; } ?> Here is how I merged the two together and getting an error: } else { $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_retail_price, p.products_price, p.products_map, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_info = tep_db_fetch_array($product_info_query); tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and language_id = '" . (int)$languages_id . "'"); if ($product_info['products_price']<$product_info['products_map']){ $products_price = '<a href="' . tep_href_link(FILENAME_CALL_FOR_PRICE, 'products_id=' . $product_info['products_id']) . '">' . CLICK_FOR_PRICE . '</a>'; }else{ if ($new_price = tep_get_products_special_price($product_info['products_id'])) { if ($new_price<$product_info['products_map']){ $products_price = '<s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s> <a href="' . tep_href_link(FILENAME_CALL_FOR_PRICE, 'products_id=' . $product_info['products_id']) . '">' . CLICK_FOR_PRICE . '</a>'; } else { // BOF Separate Price per Customer $scustomer_group_price_query = tep_db_query("select customers_group_price from " . TABLE_PRODUCTS_GROUPS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id']. "' and customers_group_id = '" . $customer_group_id . "'"); if ($scustomer_group_price = tep_db_fetch_array($scustomer_group_price_query)) { $product_info['products_price']= $scustomer_group_price['customers_group_price']; } // EOF Separate Price per Customer $products_price = '<s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>'; } else { // BOF Separate Price per Customer $scustomer_group_price_query = tep_db_query("select customers_group_price from " . TABLE_PRODUCTS_GROUPS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id']. "' and customers_group_id = '" . $customer_group_id . "'"); if ($scustomer_group_price = tep_db_fetch_array($scustomer_group_price_query)) { $product_info['products_price']= $scustomer_group_price['customers_group_price']; } // EOF Separate Price per Customer } $products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])); } } if (tep_not_null($product_info['products_model'])) { $products_name = $product_info['products_name'] . '<br><span class="smallText">[' . $product_info['products_model'] . ']</span>'; } else { $products_name = $product_info['products_name']; } ?> I am an amatuer and doing the best I can to figure this out, but I have spent hours and hours on this and not getting anywhere. Anyone who can help me I would gladly appreciate it! Thanks, Shawn
  25. First of all, congrats on the new release of SPPC. I have read a little about it and it seems very nice! I am not sure if I need B2BSuite or SPPC, need some input please. I need a contribution which will allow me to input individual prices per group (or customer). Will SPPC allow for individual product pricing for groups? Or does it just allow for a % discount all the way across the board? I would like a contribution that would allow for either % or specific pricing. I would like to be able to use Easy Populate as well to be able to easily change pricing, does B2BSuite or SPPC integrate with Easy Populate? Also, I read that B2BSuite has alot of VAT (tax i.d.) numbers on forms that maybe difficult to get rid of, has that been fixed? I appreciate all input on this, as I am not sure which one I need to install to fit my needs. Thanks in advance, Shawn
×
×
  • Create New...