Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.


  • Content count

  • Joined

  • Last visited

Everything posted by magicspon

  1. magicspon

    Ultimate SEO problem

    Hello, I've just installed the ultimate SEO contribution on to my site www.cocoshop.co.uk I followed the instructions exactly as they appear in the instructions file. However there are a few problems 1. If you go to www.cocoshop.co.uk you are asked for a username and password 2. There is no SEO section in the configurations in the admin of the site any ideas where i could have gone wrong. thanks in advance dave
  2. magicspon

    Ultimate SEO problem

    hello... just noticed that. Thats fixed the first problem, but there is still no mentioning of SEO in the configuration section of the admin... thanks for the super speedy reply!! top stuff dave
  3. Hi, Sorry little bit lost here. 1. What does on the fly mean? (probably a stupid question!!!) :blush: 2. Once all of the files are uploaded, am i right in saying that you can't access the products to alter them at all from the admin section? Thanks dave
  4. Where will i find the tips and tricks... thanks
  5. So, in my spreadsheet, if i say that there is 1 in stock, once that's sold will it automatially go offline. Also i will be selling books in my actual shop so if i sell something in person (rather than online) how can i delete the product. Also, i'm going to make a load of categories (i.e. history/biography/science etc etc) should i make these categories first in my store online, then upload the EP. thanks dave
  6. If i wanted to delete 1000 products in one go, could i just remove all of the products, remove what i need from the spreadsheet, then reload the ep file? Thanks dave
  7. Hi, Yes i've managed to upload 8000 products. But no description have upload or prices. I've read the manual but to be honest it's a weee bit confusing! I'm slowly but surely getting there. Do you know if its possible to delete multiple products. And in regards to categories, do i need to create the categories so that the products go to the right places. Thanks dave www.gumproductions.co.uk/catalog
  8. Hi, Okay i've managed to upload the test file (EP2007Jan12-1212). But i've not noticed any products being added to the store. I tried again using my own spreadsheet which i saved as a txt file, its got 8000+ products so i split the file using the Upload and Split EP File tool, but it didn't work. Do the row headers need any specific titles? What happens once the file has been upload? thanks again dave
  9. Cancel that i got it.... lets see if it works now!! Thank you very much for all your help, i appreciate it immensly. :thumbsup: Dave
  10. Hi, I can't write to this file... When i try to edit the file using the file manager in the oscommerce back end i get this message at the top of the screen: Error: I can not write to this file. Please set the right user permissions on: /home/magic/public_html/catalog//admin/includes/configure.php How do i set the right user permissions? Thanks for your help dave
  11. Here you go <?php /* osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ // Define the webserver and path parameters // * DIR_FS_* = Filesystem directories (local/physical) // * DIR_WS_* = Webserver directories (virtual/URL) define('HTTP_SERVER', 'http://gumproductions.co.uk'); // eg, http://localhost - should not be empty for productive servers define('HTTP_CATALOG_SERVER', 'http://gumproductions.co.uk'); define('HTTPS_CATALOG_SERVER', 'https://gumproductions.co.uk'); define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module define('DIR_FS_DOCUMENT_ROOT', '/home/magic/public_html/catalog/'); // where the pages are located on the server define('DIR_WS_ADMIN', '/catalog/admin/'); // absolute path required define('DIR_FS_ADMIN', '/home/magic/public_html/catalog/admin/'); // absolute pate required define('DIR_WS_CATALOG', '/catalog/'); // absolute path required define('DIR_FS_CATALOG', '/home/magic/public_html/catalog/'); // absolute path required define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/'); define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/'); define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/'); define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/'); // define our database connection define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers define('DB_SERVER_USERNAME', '*********'); define('DB_SERVER_PASSWORD', '*********'); define('DB_DATABASE', '**********'); define('USE_PCONNECT', 'false'); // use persisstent connections? define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql' ?> Thanks Dave
  12. Hi, Do you mean includes/configure.php as there isn't a configure.php in the admin folder.. it just has the configuration.php file thanks dave
  13. Hi, I've changed the DIR_FS_DOCUMENT_ROOT to this $tempdir = DIR_FS_DOCUMENT_ROOT . "temp/"; Still not working. I contacted my host and asked them to make sire the temp directory is writeable (chmod 777) and i was told that chmod 777 is not possible but chmod 775 is (which is apparently similar)! I was asked by pixclinic to post my configuration file, so here it is. <?php /* $Id: configuration.php,v 1.43 2003/06/29 22:50:51 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions [url=http://www.oscommerce.com]http://www.oscommerce.com[/url] Copyright © 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); $action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : ''); if (tep_not_null($action)) { switch ($action) { case 'save': $configuration_value = tep_db_prepare_input($HTTP_POST_VARS['configuration_value']); $cID = tep_db_prepare_input($HTTP_GET_VARS['cID']); tep_db_query("update " . TABLE_CONFIGURATION . " set configuration_value = '" . tep_db_input($configuration_value) . "', last_modified = now() where configuration_id = '" . (int)$cID . "'"); tep_redirect(tep_href_link(FILENAME_CONFIGURATION, 'gID=' . $HTTP_GET_VARS['gID'] . '&cID=' . $cID)); break; } } $gID = (isset($HTTP_GET_VARS['gID'])) ? $HTTP_GET_VARS['gID'] : 1; $cfg_group_query = tep_db_query("select configuration_group_title from " . TABLE_CONFIGURATION_GROUP . " where configuration_group_id = '" . (int)$gID . "'"); $cfg_group = tep_db_fetch_array($cfg_group_query); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo TITLE; ?></title> <link rel="stylesheet" type="text/css" href="includes/stylesheet.css"> <script language="javascript" src="includes/general.js"></script> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF" onLoad="SetFocus();"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="2" cellpadding="2"> <tr> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </table></td> <!-- body_text //--> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo $cfg_group['configuration_group_title']; ?></td> <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> </tr> </table></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CONFIGURATION_TITLE; ?></td> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CONFIGURATION_VALUE; ?></td> <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?> </td> </tr> <?php $configuration_query = tep_db_query("select configuration_id, configuration_title, configuration_value, use_function from " . TABLE_CONFIGURATION . " where configuration_group_id = '" . (int)$gID . "' order by sort_order"); while ($configuration = tep_db_fetch_array($configuration_query)) { if (tep_not_null($configuration['use_function'])) { $use_function = $configuration['use_function']; if (ereg('->', $use_function)) { $class_method = explode('->', $use_function); if (!is_object(${$class_method[0]})) { include(DIR_WS_CLASSES . $class_method[0] . '.php'); ${$class_method[0]} = new $class_method[0](); } $cfgValue = tep_call_function($class_method[1], $configuration['configuration_value'], ${$class_method[0]}); } else { $cfgValue = tep_call_function($use_function, $configuration['configuration_value']); } } else { $cfgValue = $configuration['configuration_value']; } if ((!isset($HTTP_GET_VARS['cID']) || (isset($HTTP_GET_VARS['cID']) && ($HTTP_GET_VARS['cID'] == $configuration['configuration_id']))) && !isset($cInfo) && (substr($action, 0, 3) != 'new')) { $cfg_extra_query = tep_db_query("select configuration_key, configuration_description, date_added, last_modified, use_function, set_function from " . TABLE_CONFIGURATION . " where configuration_id = '" . (int)$configuration['configuration_id'] . "'"); $cfg_extra = tep_db_fetch_array($cfg_extra_query); $cInfo_array = array_merge($configuration, $cfg_extra); $cInfo = new objectInfo($cInfo_array); } if ( (isset($cInfo) && is_object($cInfo)) && ($configuration['configuration_id'] == $cInfo->configuration_id) ) { echo ' <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_CONFIGURATION, 'gID=' . $HTTP_GET_VARS['gID'] . '&cID=' . $cInfo->configuration_id . '&action=edit') . '\'">' . "\n"; } else { echo ' <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_CONFIGURATION, 'gID=' . $HTTP_GET_VARS['gID'] . '&cID=' . $configuration['configuration_id']) . '\'">' . "\n"; } ?> <td class="dataTableContent"><?php echo $configuration['configuration_title']; ?></td> <td class="dataTableContent"><?php echo htmlspecialchars($cfgValue); ?></td> <td class="dataTableContent" align="right"><?php if ( (isset($cInfo) && is_object($cInfo)) && ($configuration['configuration_id'] == $cInfo->configuration_id) ) { echo tep_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '<a href="' . tep_href_link(FILENAME_CONFIGURATION, 'gID=' . $HTTP_GET_VARS['gID'] . '&cID=' . $configuration['configuration_id']) . '">' . tep_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . '</a>'; } ?> </td> </tr> <?php } ?> </table></td> <?php $heading = array(); $contents = array(); switch ($action) { case 'edit': $heading[] = array('text' => '<b>' . $cInfo->configuration_title . '</b>'); if ($cInfo->set_function) { eval('$value_field = ' . $cInfo->set_function . '"' . htmlspecialchars($cInfo->configuration_value) . '");'); } else { $value_field = tep_draw_input_field('configuration_value', $cInfo->configuration_value); } $contents = array('form' => tep_draw_form('configuration', FILENAME_CONFIGURATION, 'gID=' . $HTTP_GET_VARS['gID'] . '&cID=' . $cInfo->configuration_id . '&action=save')); $contents[] = array('text' => TEXT_INFO_EDIT_INTRO); $contents[] = array('text' => '<br><b>' . $cInfo->configuration_title . '</b><br>' . $cInfo->configuration_description . '<br>' . $value_field); $contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_update.gif', IMAGE_UPDATE) . ' <a href="' . tep_href_link(FILENAME_CONFIGURATION, 'gID=' . $HTTP_GET_VARS['gID'] . '&cID=' . $cInfo->configuration_id) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>'); break; default: if (isset($cInfo) && is_object($cInfo)) { $heading[] = array('text' => '<b>' . $cInfo->configuration_title . '</b>'); $contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(FILENAME_CONFIGURATION, 'gID=' . $HTTP_GET_VARS['gID'] . '&cID=' . $cInfo->configuration_id . '&action=edit') . '">' . tep_image_button('button_edit.gif', IMAGE_EDIT) . '</a>'); $contents[] = array('text' => '<br>' . $cInfo->configuration_description); $contents[] = array('text' => '<br>' . TEXT_INFO_DATE_ADDED . ' ' . tep_date_short($cInfo->date_added)); if (tep_not_null($cInfo->last_modified)) $contents[] = array('text' => TEXT_INFO_LAST_MODIFIED . ' ' . tep_date_short($cInfo->last_modified)); } break; } if ( (tep_not_null($heading)) && (tep_not_null($contents)) ) { echo ' <td width="25%" valign="top">' . "\n"; $box = new box; echo $box->infoBox($heading, $contents); echo ' </td>' . "\n"; } ?> </tr> </table></td> </tr> </table></td> <!-- body_text_eof //--> </tr> </table> <!-- body_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> <br> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> Thanks for all your help guys, muchly appreciated. dave
  14. okay... need some help here. Making a site for a book shop with over 20000 products. I have all the information in an excel spreadsheet. I've installed the contribution with no troubles. Been reading through the manual and a lot of it is above my head. I chopped up the spreadsheet just to test it with only 30 so products. I've saved the sheet as a text file. when i upload the file i get this message I do have catalog/temp in my directory... can anyone explain to me where i'm going wrong. I noticed in the manual it mentions CHMOD 777, what is this, how do i access this or enable this... Thanks in advance for any help, my brain is beginning to leak out my nose!!!! :'( dave
  15. Hi, Is it possible to delete multiple products at a time using this contribution thanks dave
  16. Hi, Which version do you recommend i download? I see that the latest version is just a BETA version. Thanks dave
  17. Hi, I'm about to make an online book shop with over 17000 books. Will this contribution allow me upload and delete 1000's of products at a time Thanks in advance dave
  18. magicspon

    SSL required for paypal?

    I'm going to be using paypal pro aswell. I believe i should get a cert to protect the privacy of the customers, where is the cheapest place i can get a cert.. Thanks dave
  19. I have basially completely finished my site, i just need to install SSL and sort out the payment process, if i install this contribution will it destroy all my work.. i also use the simple template system.. Thanks dave
  20. magicspon

    More than 1 template

    Hi I need to use two different templates.. One for the homepage and the other for all other pages. How do i go about doing this. Thanks dave
  21. magicspon

    Flash on home page

    Hi, For my site i need to have two different flash movies. The image below shows the layout i want.. This is for the home page, obviously the flash movie won't appear in the content page for the product pages. How do i replace the current home page with a flash movie (includes/langauges/english/index.php???) And How do i place a flash movie on the left hand side of the screen (as shown in picture above) I am using the latest version of STS. Any help would be great Thanks Dave
  22. Hi, :huh: Need some help with a few things 1. How do i change the number of products shown per page. 2. How do i change the number of columns the product pages use. 3. How do i edit the design of the product boxes. I'm using STS v4. thanks dave
  23. Hi, How do i change the way that the products are listed and how do i edit the box which each product is in? I would like to have two column of products. Also how do i change the width of the shopping cart box. I've changed the boxes/shopping_cart.php file so that it is 140px wide. However when i add a product to the shopping cart the box is stretched. thanks dave
  24. magicspon

    changing Font

    Hi, I've replaced the default font (Verdana, Arial, sans-serif) in the CSS file with my own font family (Comic Sans MS, Arial, Bimini) and it has made no changed at all. I've saved it several times and uploaded it again, just not working. I am using STS could this effect it. Thanks dave
  25. Hi, i'm making my own template using the latest version of STS, i've built a table with fixed widths but when i put the $content tag the table is enlarged to fit the content in when i view the page www.pulp-stationery.co.uk/shop Any ideas how i stop this, what file do i need to edit. thanks dave