Jump to content

carmet

Members
  • Content count

    18
  • Joined

  • Last visited

Profile Information

  • Real Name
    carine li
  • Gender
    Female
  • Location
    Stay in Turkey but a Chinese
  1. carmet

    Quantity Price Breaks

    Hi Jan, You told me that if I want to use the SPPC, I should use the update one of SPPC 4.2.2 only, no need install 4.2.1 to upgrade 4.2.2 because of big work load. However, I checked that if I only install the SPPC 4.2.2, it is not the full package for new user. It was because I found out that some instructions of SPPC4.2.2 must add after the instruction of SPPC4.2.1. such as below: ____________________________________________ in catalog/admin/includes/functions/general.php Line 923-925 (this is in function tep_remove_product) **AFTER** // BOF Separate Pricing Per Customer tep_db_query("delete from " . TABLE_PRODUCTS_GROUPS . " where products_id = '" . (int)$product_id . "'"); // EOF Separate Pricing Per Customer **ADD** // BOF QPBPP for SPPC tep_db_query("delete from " . TABLE_PRODUCTS_PRICE_BREAK . " where products_id = '" . (int)$product_id . "'"); tep_db_query("delete from " . TABLE_PRODUCTS_TO_DISCOUNT_CATEGORIES . " where products_id = '" . (int)$product_id . "'"); // EOF QPBPP for SPPC ______________________________________________ And in my osc, there isn't any ''// BOF Separate Pricing Per Customer....'', how do I add the new installation?? Therefore, should I install the 4.2.1 first and then upgrade to 4.2.2?? Please kindly advice. Carmet
  2. carmet

    Quantity Price Breaks

    Hi Jan, Sorry, I know how to add it now. Thank you Carmet
  3. I am really appreciated on Brian's work. He is very helpful and provide many useful idea for me. Brian, Thank you so much!! :D

  4. carmet

    Quantity Price Breaks

    Hi Jan. Thanks for your advice. It is because there isn't any table of 'products_groups' in my database. So, I think that maybe I need install the 4.2.1 first. Finally, thanks for your advice. From the instruction, there is one instruction which show: 'UPDATE `configuration_group` SET sort_order = last_insert_id() WHERE `configuration_group_id` = last_insert_id();'. After I insert it to database, it shows 'error message' as below: ________________________________________________________ Error SQL query: SET sort_order = last_insert_id( ) WHERE `configuration_group_id` = last_insert_id( ) MySQL said: #1193 - Unknown system variable 'sort_order' _________________________________________________________ Sorry about that I am the new user of oscommerce and didn't know any database knownledge, actually, how to 'UPDATE `configuration_group` into the database?? Can you give me advice on it? Thanks for your attention. Carmet
  5. carmet

    Quantity Price Breaks

    Hi Jan, Finally, I found out the 'separate_price_v421', and there has some product_groups and customer_groups that I should add into my database. I want to ask one question that, should I need add all the things of v421 first? and then I modify it to upgrade v422. Am I correct? Hope to get your advice on it. Thank you so much of your contribution. Carmet
  6. carmet

    Quantity Price Breaks

    Hi Jan, I really want to have your advice. Sorry about that I dont know too much technique on database. After I saw the SPPC, it was very greatful for the price break of the products. If I deleted all the old one and want to add the SPPC, but I really can't find the 'product_groups' in database. How should I do? or I need to combine the QPBPP 1.3.5 and SPPC 4.2.2??? Could you please give me advice? :blush: Best regards Carmet
  7. carmet

    Quantity Price Breaks

    aiyo!! ........then how can I do now? :blink: have any advice?? because I am now uploading yours one,but I can't find the 'product_groups'. regards Carmet :(
  8. carmet

    Quantity Price Breaks

    Hi Jan, Sorry!! I just deleted all my old qpbpp_v1_3_5, and download the SPPC_price_break_v2_0. When I wanted add and alter the table in mySql, I have discovered that I didnt have the table of 'product_groups'. How do I alter this table in Database?? Could you have any orginial of 'product_groups' for my updated?? or Should I go anywhere to download this table?? Please kindly advice. Thanks for your great help. Carmet :o
  9. carmet

    Quantity Price Breaks

    Thank you so much. It means I need to delete the old one first before I download thıs new enhance version..... right?? ok. let me start now.... Anyway, thanks for your advice. :) Carmet
  10. carmet

    Quantity Price Breaks

    hi, Yesterday I downloaded the qpbpp (version 1.3.5 / osC 2.2 RC2a), after checking the admin page, it is working, however, when I back to the client page for checking, there is nothing on the 'Let's See What We Have Here'. After I checked all of the download files and modification, there is no any wrong. Anyone have any idea on it? And actually, I looked over the new addon after uploaded, the first step is: If some items has price break, I should add the items on discount category, shouldn't I?? if there is no any price break on some items. then I no need add the it to the discount category. right? Am I misunderstanding on the schedule? Sorry about that I am a new user and stupid on it. :blush: Best regards Carmet
  11. carmet

    Sitemap SEO

    Hi Jack, The sitemap is working now. :lol: Thanks for your great contribution and fast reply. Regards Carmet :D
  12. carmet

    Sitemap SEO

    hi Jack, do I need delete the sitemap_SEO_install.php?? Please kindly advice. Regards Carmet
  13. carmet

    Sitemap SEO

    Hi, .........DNS problem??? Sorry about that I dont know how to solve it...... I am the new user of oscommerce and dont know too much internet technique :o ..... have any idea?? Carmet :blink:
  14. carmet

    Sitemap SEO

    Hi Jack, Oh sorry. I think I was just revising something when u came to my site..... so, please go there to check again. I am really sorry about it.... regards Carmet :P
  15. carmet

    Sitemap SEO

    Hi Jack, I forgot to say that I just moved all the information box to the footer. but I make sure that I havent broken all the links of sitemap....... Regards Carmet
×