Jump to content

MWebb

Members
  • Content count

    60
  • Joined

  • Last visited

Profile Information

  • Real Name
    Matthew
  • Gender
    Male
  1. MWebb

    Seperate Pricing Per Customer v3.5

    @@greasemonkey Ah ok thanks for the info
  2. by the way, this is the contribution that I'm using with sppc http://addons.oscommerce.com/info/5569
  3. I'm using customer group discounts for sppc but I'm having a problem. On the admin page, I go to the group discounts page and enter a discount for my group "test" (10%) and that seems to work fine, however when I log into my test account for that group and then go to a product, I seem to get all sorts of different discounts. For example I have a test product that starts at £299.99 but when I add it to my cart, it becomes £269.99 (which to my knowledge isn't 10% of £299.99). Another example I have is; the starting price is £29.99 but when it gets to my cart, it becomes £35.09. That isn't a reduction nor the correct percentage. Has anyone else had a similar problem or can help me fix it? The percentages seem to be working (which is good) but they are not showing the correct price.
  4. MWebb

    Seperate Pricing Per Customer v3.5

    I don't know if this has been asked before, but is it possible to set specials for different customer groups using sppc? I have multiple groups and if I set my test account to a test group, I don't see any specials, all I see is a blank space where the specials should be. However if I put my test account into the retail group, I see the specials. So is there a way to set special prices for other groups or is that just set for retail?
  5. Can anyone recommend an add-on that will allow me to add discounts (as a percentage) to different customer groups? I've tried using sppc but it doesn't seem to do discounts as a percentage (unless I missed something. Thanks in advance for any suggestions.
  6. MWebb

    Discount groups

    @@joli1811 If you can recommend an add-on (other than the one that I'm using) that will allow me to give discounts as a percentage (sppc doesn't seem to be able to do it) to different groups, then I would appreciate it.
  7. MWebb

    Discount groups

    I've looked at sppc and while it worked, it didn't do the discounts in percentages (unless I missed something)
  8. MWebb

    Discount groups

    @@joli1811 Yes it is that add-on that I'm trying to use. I'm trying to get it so that I can create multiple customer groups and give each group a discount, this is the only add-on that seems to "work" for me. I've managed to fix the error regarding 1146 - Table 'oscommerce_0.TABLE_GROUPS_TO_CATEGORIES' doesn't exist however @@multimixer I am still getting all of the syntax errors. ps I haven't logged in in a while as I've been doing other things but I'm back on this project now and I saw that you had added a bit more to the conversation so I'd thought I'd update my situation.
  9. MWebb

    Discount groups

    I've also just noticed that when I log in as a customer and then click on a product (any product) I get this message. 1146 - Table 'oscommerce_0.TABLE_GROUPS_TO_CATEGORIES' doesn't exist select discount from TABLE_GROUPS_TO_CATEGORIES where customers_groups_id = 2 and categories_id=0 [TEP STOP] I've looked at my database and there is a table called groups_to_categories does exist
  10. MWebb

    Discount groups

    Ok the error that I get after clicking edit is this: 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 'and c.categories_id = g.categories_id and c.categories_id = f.categories_id orde' at line 1 select c.discount, c.categories_id, c.customers_groups_id, g.categories_name, f.parent_id from groups_to_categories c, categories_description g, categories f where c.customers_groups_id= and c.categories_id = g.categories_id and c.categories_id = f.categories_id order by g.categories_name [TEP STOP] And the error I get if I click the delete button is this: 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 '' at line 1 delete from groups_to_categories where customers_groups_id= [TEP STOP] If I go through edit and then click update, I get this 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 'where customers_groups_id =' at line 1 update customers_groups set customers_groups_name='', customers_groups_discount= where customers_groups_id = [TEP STOP] And finally if I go through edit and then insert I get this 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 '' at line 1 select * from groups_to_categories where categories_id=0 and customers_groups_id= [TEP STOP]
  11. MWebb

    Discount groups

    I am trying to install Dicount groups version 1.1.1 I seem to have edited everything correctly. However when I go to to do something other than create a new group, I get this 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 'and c.categories_id = g.categories_id and c.categories_id = f.categories_id orde' at line 1 I get different versions of these when I click on: Edit, Delete, or if I go into edit and then update. I've tried using the fix in this link http://forums.oscommerce.com/topic/144095-1064-you-have-an-error-in-your-sql-syntax/ but it doesn't solve the problem. If anyone can help it would be greatly appreciated.
  12. I'm trying to install customer group discounts but I've run into a problem. The instructions say to go to admin/includes/boxes/customer.php and insert this line <a href="' . tep_href_link('customer_group_discounts.php', '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CUSTOMER_GROUP_DISCOUNTS . '</a><br>. Now I look in that folder and I don't see a customer.php so I assume it must be a spelling mistake and meant customers.php. When I go into that file I don't see code like that, all I see is array( 'code' => FILENAME_ORDERS, 'title' => BOX_CUSTOMERS_ORDERS, 'link' => tep_href_link(FILENAME_ORDERS) ), I've tried compensating and making the code that I need to add similar to that by making it like this array( 'code' => FILENAME_CUSTOMERS_GROUP_DISCOUNT, 'title' => BOX_CUSTOMERS_GROUP_DISCOUNT, 'link' => tep_href_link(FILENAME_CUSTOMER_DISCOUNT) ), but all that does on the admin page is this If I click on the link "BOX_CUSTOMERS_GROUP DISCOUNTS" it comes up with message Not Found The requested document was not found on this server. Can someone please tell me what I've done wrong and how to fix it please?
  13. I've installed the quick updates for SPPC v1.5 with SPPC, I also have member approval installed. My problem is that when I select the quick price updates link, the menu goes a bit dodgy (that's not a big problem as I can live with that) however the main problem is that whenever I go to update something or do something i.e select a customer group, it just sends me back to the main admin page and doesn't save any of the changes. Could someone help me with this please? I'm not entirely sure what's wrong.
  14. MWebb

    Seperate Pricing Per Customer v3.5

    @@14steve14 I don't think I have that page, I have (in the configuration area) product listing and within that area I have display product pricing (with a value of 3) but I can only change the value not the price. Have installed the module incorrectly at some point or something?
  15. @@14steve14 I've checked all the files according to the installation guide and everything seems to be there. This is the version that I downloaded as it seemed to be the only one that worked properly after installing, the other just messed up my site. "Full set of new and amended files for SPPC 4.2.2 on oscommerce 2.3.1"
×