Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

magicspon

Archived
  • Posts

    127
  • Joined

  • Last visited

Posts posted by magicspon

  1. check the file called

     

    .htaccess

     

    ..thats probably where the fault lies...

     

    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

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

  3. 1) EP is not able to delete multiple products.

    The best way to do this, if you have 8000 products with no description/prices and want to start from scratch is to use the admin backup/restore function (did you backup first ? ;-)

     

    If not, another solution consists in going in the Myphpadmin control panel on your hosting service and empty the table products and products descriptions, (the "empty" tab at the top of the table display)

     

    2) no need to create categories in admin, if you create your categories and subcategories in easypopulate, they are created on the fly when the file is imported. Just be careful that, if you already have some categories set up and want to retreive your products in them, that the names in the EP file match exactly what you already have on the site.

     

    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. EP does not ever remove a product. Everything you upload will be either created or updated. You may upload any sub-set of the products at one time.

     

    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

  5. 1) EP is not able to delete multiple products.

    The best way to do this, if you have 8000 products with no description/prices and want to start from scratch is to use the admin backup/restore function (did you backup first ? ;-)

     

    If not, another solution consists in going in the Myphpadmin control panel on your hosting service and empty the table products and products descriptions, (the "empty" tab at the top of the table display)

     

    2) no need to create categories in admin, if you create your categories and subcategories in easypopulate, they are created on the fly when the file is imported. Just be careful that, if you already have some categories set up and want to retreive your products in them, that the names in the EP file match exactly what you already have on the site.

     

    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

  6. have you successfully downloaded an export and examined the format? Have you applied that format to your import file?

     

    Have you assigned a unique Model Number to each product as the docs state? have you thoroughly read the docs?

     

    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

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

     

    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

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

     

    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

  9. The correct path for your document root must be:

     

      define('DIR_FS_DOCUMENT_ROOT', '/home/magic/public_html/'); // where the pages are located on the server

     

    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

  10. yes that's what I mean. Sorry I forget the includes

     

    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

  11. This is NOT your configuration file

     

    Your admin configuration file is located in:

     

    admin/configure.php

     

    for security reasons (for you) don't post the last lines including the username and password to your database.

     

    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

  12. You should do a complete export of your oringinal items (or the osC test data) and examine that to make sure your import is formatted correctly.

     

    You need to create a temp folder on your site. You need to make sure the temp folder is setup (pointed to) correctly in the settings of EP.

     

    I see this: /home/magic/public_html/catalog//catalog/temp/testbollocks.txt in your error message. this tells me your shop is in the /catalog/ sub-directory of your site. if this is true then this should be your setting in the EP file:

    $tempdir = DIR_FS_DOCUMENT_ROOT . "temp/";

     

    your next step is to ask your host to make sure this directory exists and is writeable (chmod 777)

    /home/magic/public_html/catalog/temp/

     

    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

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

     

    Warning: move_uploaded_file(/home/magic/public_html/catalog//catalog/temp/testbollocks.txt) [function.move-uploaded-file]: failed to open stream: No such file or directory in /home/magic/public_html/catalog/admin/easypopulate_functions.php on line 43

     

    Warning: move_uploaded_file() [function.move-uploaded-file]: Unable to move '/tmp/phpd5yJga' to '/home/magic/public_html/catalog//catalog/temp/testbollocks.txt' in /home/magic/public_html/catalog/admin/easypopulate_functions.php on line 43

     

     

    File uploaded.

    Temporary filename: /tmp/phpd5yJga

    User filename: testbollocks.txt

    Size: 12781

     

    Warning: file(/home/magic/public_html/catalog//catalog/temp/testbollocks.txt) [function.file]: failed to open stream: No such file or directory in /home/magic/public_html/catalog/admin/easypopulate.php on line 805

     

    Warning: Invalid argument supplied for foreach() in /home/magic/public_html/catalog/admin/easypopulate.php on line 844

     

    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

  14. If you signed up for a Website Payments Pro account with PayPal, you have to install this contribution:

     

    http://www.oscommerce.com/community/contributions,3647

     

    The Direct Payments option allows you to accept credit cards on your site via a form instead of the customers having to leave your site to go to PayPal.

     

    Hi,

     

    Which version do you recommend i download? I see that the latest version is just a BETA version.

     

    Thanks

    dave

  15. i'm convinced

     

    thanks for all those great points guys

    :)

     

    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

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

    example.jpg

     

    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

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

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

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

×
×
  • Create New...