c-sargent

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

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

Fixed it...well Jan on the SPPC thread did.

Thanks Jan, your guess was correct. The SPPC code worked fine for PWA. Fantastic, time-saving contrib with quick and knowledgable support. Chris

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

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

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

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

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

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

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

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

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

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

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

I made a change to my sts_template.html file to include $cartbox and $orderhistorybox. saved and uploaded the template and now I get the following error when trying to load index.php Fatal error: Call to a member function on a non-object in /my account name/catalog/includes/header.php on line 14 Header.php line 14 is $sts->restart_capture ('applicationtop2header'); // Capture header from the actual script, needed to take out javascript If I comment this line out my shop loads with the default osc layout any ideas any one? thanks Chris

:rolleyes: You can ignore this now. Turned out is was my file permissions not letting me ftp the amended files across.

Hi Guys I really hope you can help with this. I installed STS v4.5.8 onto one of my online stores. This store has been modified with other contribs. When I went into admin --> modules I only see the Payment Options, Shipping Options and Total Orders. There is no STS module showing so I can't even install it :( I thought I must have missed a file copy or something so I did a restore, reinstalled the STS contrib and I still dont get the STS module showing in admin. I guess it could be to do with configure.php ......????? I have another store that only has the seperate price per customer contrib installed, so I installed STS to that as well, following the instructions very carefully and guess what? I still cant see the STS module in the admin for that site either. I have recently designed a new website for one of my customers and what to make the OSC site have the same look and feel. STS sounds like it will do this perfectly but only if I can actually install it in the admin. If I have f'd something up feel free to flame and abuse me just give me the answer first please!! Chris http://myweb.tiscali.co.uk/ctsonline