Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

MWebb

Members
  • Content count

    60
  • Joined

  • Last visited

Everything posted by MWebb

  1. 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.
  2. MWebb

    Seperate Pricing Per Customer v3.5

    @@greasemonkey Ah ok thanks for the info
  3. by the way, this is the contribution that I'm using with sppc http://addons.oscommerce.com/info/5569
  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 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.
  8. MWebb

    Discount groups

    I've looked at sppc and while it worked, it didn't do the discounts in percentages (unless I missed something)
  9. 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.
  10. 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
  11. 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]
  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"
  16. I've installed the SPPC contribution but I don't know how to setup the different prices for different customer groups. I've created 2 user accounts and put one in the guest (default group) and the other in retail and tested it out. Although in the guest group there was a special offer on one of the items when I clicked to buy that product, the price reverted to the normal price which is the same as the retail group. Can someone please either show me or tell me how I can set the different prices for each group (I have 3).
  17. MWebb

    Seperate Pricing Per Customer v3.5

    @@Jan Zonjee I've installed the sppc along with member approval. Now I've created 3 groups; guest, member of and retail. However although these groups have been created there doesn't seem to be an option to actually change the prices for each customer groups. That or I'm looking in the wrong place. Any help would be appreciated.
  18. @@multimixer I'm currently looking through the topic for SPPC In the downloaded file there's a folder which is called new_installations 2.3.1 and I checked the files in there and they were the files that you need to change but they all ready had the changes on them, so I just uploaded those files using ftp. Should I not have done that and just edited the files in the normal oscommerce file and then uploaded them?
  19. @@multimixer Do I need to do a reinstall then? Because I checked that file and it is there (unless I need to change something in the code), if I need to change something in the code could you tell me which bit please?
  20. I've checked that the file you mentioned is there and it is. The version that i have installed is this Full set of new and amended files for SPPC 4.2.2 on oscommerce 2.3.1 (so it should be the latest version, it's also the only one that seems to work for me). By special offer I'm referring to the specials box on the right hand side of the main page. When I was signed in as a guest it showed a different price to when I was signed into a retail account, but when I clicked on that product as a guest to get the special price, it reverted back to the price that was the same for the retail account. I hope I have made it clearer
  21. I'm trying to install SPPC along with member approval. Now I've managed to get member approval working fine but after I've installed the SPPC, the store page just goes blank but still has the header at the top of the page while the admin page just goes blank. I've followed the instructions and I think I've managed to merge both the SPPC and member approval instructions correctly but I'm not sure what's wrong. Can someone help please?
×