Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

MWebb

Members
  • Content count

    60
  • Joined

  • Last visited

Posts 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. 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?


  3. @@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.


  4. 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


  5. 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]


  6. 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.


  7. 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?


  8. 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.


  9. @@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?


  10. 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


  11. 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).


  12. 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?

×