Jump to content

c-sargent

Members
  • Content count

    30
  • Joined

  • Last visited

About c-sargent

  • Birthday 10/01/1966

Profile Information

  1. Hi, I'm sure this is a simple problem, but I have searched for a solution and failed to find anything.... I have 2 stores, I wanted to copy the database from one to the other so I set up easy populate v2.78 on both stores, did an export from one and then imported the file straight into the other one. In catalog-admin I can see all the products but on the store I get No products in this category. I thought it might be possible to just point the second store at the first stores database so I changed the database name in admin-includes-configure.php and catalog-includes-configure.php but that gave me problems as I hadn't set up the same contribs on each store so I reverted that change! So now I'm back with the problem that I can see the categories, sub-categories and products in Admin but not on the store itself. Anyone goy any ideas? thanks Chris
  2. I have a problem when trying to install EP 2.78 In the install notes it says to edit the file \admin\modules\filenames.php but I don't have an admin\modules folder and this is on a vanilla installation. I have filenames.php in catalog\admin\includes and catalog\includes Could someone please let me know which file it is I'm supposed to be updating? thanks Chris
  3. Fixed it...well Jan on the SPPC thread did.
  4. c-sargent

    Seperate Pricing Per Customer v3.5

    Thanks Jan, your guess was correct. The SPPC code worked fine for PWA. Fantastic, time-saving contrib with quick and knowledgable support. Chris
  5. I have a problem when trying to install EP 2.78 In the install notes it says to edit the file \admin\modules\filenames.php but I don't have an admin\modules folder and this is on a vanilla installation. I have filenames.php in catalog\admin\includes and catalog\includes Could someone please let me know which file it is I'm supposed to be updating? thanks Chris
  6. c-sargent

    Seperate Pricing Per Customer v3.5

    Hi hope there's someone with a better knowledge of PHP than me! I am trying to combine PWA with SPPC (with price breaks) but have run into a bit of a problem. I am using winmerge to make the changes. The file I have a problems with is catalog/admin/order.php The PWA file has the following code: if (isset($HTTP_GET_VARS['cID'])) { $cID = tep_db_prepare_input($HTTP_GET_VARS['cID']); $orders_query_raw = "select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.customers_id = '" . (int)$cID . "' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' order by orders_id DESC"; } elseif (isset($HTTP_GET_VARS['status']) && is_numeric($HTTP_GET_VARS['status']) && ($HTTP_GET_VARS['status'] > 0)) { $status = tep_db_prepare_input($HTTP_GET_VARS['status']); $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and s.orders_status_id = '" . (int)$status . "' and ot.class = 'ot_total' order by o.orders_id DESC"; } else { $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' order by o.orders_id DESC"; } The SPPC file has this on the same line numbers: if (isset($HTTP_GET_VARS['cID'])) { // BOF Separate Pricing Per Customer $cID = tep_db_prepare_input($HTTP_GET_VARS['cID']); $orders_query_raw = "select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total, cg.customers_group_name from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id) left join " . TABLE_CUSTOMERS . " c on c.customers_id = o.customers_id left join " . TABLE_CUSTOMERS_GROUPS . " cg using(customers_group_id), " . TABLE_ORDERS_STATUS . " s where o.customers_id = '" . (int)$cID . "' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' order by orders_id DESC"; } elseif (isset($HTTP_GET_VARS['status'])) { $status = tep_db_prepare_input($HTTP_GET_VARS['status']); $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total, cg.customers_group_name from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id) left join " . TABLE_CUSTOMERS . " c on c.customers_id = o.customers_id left join " . TABLE_CUSTOMERS_GROUPS . " cg using(customers_group_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and s.orders_status_id = '" . (int)$status . "' and ot.class = 'ot_total' order by o.orders_id DESC"; } else { $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total, cg.customers_group_name from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id) left join " . TABLE_CUSTOMERS . " c on c.customers_id = o.customers_id left join " . TABLE_CUSTOMERS_GROUPS . " cg using(customers_group_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' order by o.orders_id DESC"; // EOF Separate Pricing Per Customer } Can anyone tell me how I can combine the 2 successfully? I think I need to check whether its a PWA order or a SPPC group order and run the correct "$orders_query_raw =" call, but how do I do that? I know its asking a lot but if anyone can help I would really appreciate it. I have also posted a copy of this on the PWA thread. Thanks Chris
  7. Hi hope there's someone with a better knowledge of PHP than me! I am trying to combine PWA with SPPC (with price breaks) but have run into a bit of a problem. I am using winmerge to make the changes. The file I have a problems with is catalog/admin/order.php The PWA file has the following code: if (isset($HTTP_GET_VARS['cID'])) { $cID = tep_db_prepare_input($HTTP_GET_VARS['cID']); $orders_query_raw = "select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.customers_id = '" . (int)$cID . "' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' order by orders_id DESC"; } elseif (isset($HTTP_GET_VARS['status']) && is_numeric($HTTP_GET_VARS['status']) && ($HTTP_GET_VARS['status'] > 0)) { $status = tep_db_prepare_input($HTTP_GET_VARS['status']); $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and s.orders_status_id = '" . (int)$status . "' and ot.class = 'ot_total' order by o.orders_id DESC"; } else { $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' order by o.orders_id DESC"; } The SPPC file has this on the same line numbers: if (isset($HTTP_GET_VARS['cID'])) { // BOF Separate Pricing Per Customer $cID = tep_db_prepare_input($HTTP_GET_VARS['cID']); $orders_query_raw = "select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total, cg.customers_group_name from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id) left join " . TABLE_CUSTOMERS . " c on c.customers_id = o.customers_id left join " . TABLE_CUSTOMERS_GROUPS . " cg using(customers_group_id), " . TABLE_ORDERS_STATUS . " s where o.customers_id = '" . (int)$cID . "' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' order by orders_id DESC"; } elseif (isset($HTTP_GET_VARS['status'])) { $status = tep_db_prepare_input($HTTP_GET_VARS['status']); $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total, cg.customers_group_name from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id) left join " . TABLE_CUSTOMERS . " c on c.customers_id = o.customers_id left join " . TABLE_CUSTOMERS_GROUPS . " cg using(customers_group_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and s.orders_status_id = '" . (int)$status . "' and ot.class = 'ot_total' order by o.orders_id DESC"; } else { $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total, cg.customers_group_name from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id) left join " . TABLE_CUSTOMERS . " c on c.customers_id = o.customers_id left join " . TABLE_CUSTOMERS_GROUPS . " cg using(customers_group_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' order by o.orders_id DESC"; // EOF Separate Pricing Per Customer } Can anyone tell me how I can combine the 2 successfully? I think I need to check whether its a PWA order or a SPPC group order and run the correct "$orders_query_raw =" call, but how do I do that? I know its asking a lot but if anyone can help I would really appreciate it. I have also posted a copy of this on the SPPC thread. Thanks Chris
  8. Hi all, hope someone can help me with this problem..... I have just installed EP but when I try to create the file to download or create the file on the temp directory nothing happens. I dont get any errors but no file downloads or is created. I have created the admin/temp folder and set the permissions to 777 anyone got any ideas? I have just uploaded an unedited version of easypopulate.php with the SPPC bit commented out(I am using the SPPC version) but I still dont get a file to download. thanks Chris
  9. c-sargent

    No file to download

    I have installed EP, but when I click on any of the links to download or create the file nothing happens. I have created the admin/temp folder and set the permissions to 777. I have checked using OSC file manager and smartFTP but o file is being created. Could anyone point me in the right direction? thanks Chris
  10. c-sargent

    Which versions

    Thank again Jan, I have downloaded that version and will have a bash at installing it tonight. I think I was getting confused as one version I looked at said I needed a version of QPBPP installed first and then to install QPBPP4SPPC over the top :'( Thanks for these excellent mods Chris
  11. c-sargent

    Which versions

    thanks Jan (I think).....there seem to be a lot of different versions, bug fixes for this, patches for that.........
  12. c-sargent

    Which versions

    Can anyone tell me the versions I need to install Quantity Price Break when I already have SPPC 4.2 installed? ta, Chris
  13. c-sargent

    Currency flags

    I have installed the Currency Flags contrib. The flag images show in Admin but not on the website. Right clicking and properties on the missing images gives the full path but no filename. Any ideas what I've done wrong? thx Chris
  14. c-sargent

    SPPC 4.20

    Hi, Is it possible to assign a default currency based on the customer group? I have some customers who pay in GBP and some who pay in EUR so I would like to be able to select which currency is used based on group membership.FYI, I do not use an exchange rate ie. GBP1.00 = EUR1.00 for some customers, for others I use GBP1.00 = EUR1.50 and for rest it is either just GBP or EUR at the current exchange rate. If it's not possible then can I add this to a "wishlist"? or can someone write the required code? or do I have to get a copy of PHP for Dummies? :'( cheers Chris
  15. c-sargent

    STS v4.5.8

    Have fixed this. Copied a clean copy of application_top and the error stopped
×