Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

veni

Members
  • Content count

    51
  • Joined

  • Last visited

  1. Hello guys, I have a site that is very simple example, no prices are listed. I wish to remove some of the column headers in Easy Populate, these items are : v_products_name_2 v_products_url_2 v_products_description_2 v_products_name_3 v_products_url_3 v_products_description_3 v_products_price v_products_quantity v_products_weight v_date_avail v_date_added v_categories_image_1 v_categories_name_2 v_categories_image_2 v_categories_name_3 v_categories_image_3 v_categories_name_4 v_categories_image_4 v_categories_name_5 v_categories_image_5 v_categories_name_6 v_categories_image_6 v_categories_name_7 v_categories_image_7 v_tax_class_title Is is possible to remove these Items as I don't use them in my site at all?
  2. Thank you surfalot I managed to make the necessary changes.
  3. I'm using EP_v2_76f_MS2 and I would like to know, how I can change the order in which items appears in the header of the .cvs file? For example, I want v_products_image to be right after v_products_name_1 as currently, that is not the case.
  4. Which version of Easy Populate do I need to install with Oscommerce-2.2rc2a ? Or does it even matter?
  5. Which version of Easy Populate do I need to install with Oscommerce-2.2rc2a ? Or does it even matter?
  6. veni

    Temp directory

    My problem is now fixed this was solution Admin---> Includes ---> configure.php CHANGED define('DIR_FS_DOCUMENT_ROOT', 'D:/Wamp/www/e-commerce/'); define('DIR_FS_ADMIN', 'D:/Wamp/www/e-commerce/admin/'); define('DIR_FS_CATALOG', 'D:/Wamp/www/e-commerce/'); TO define('DIR_FS_DOCUMENT_ROOT', 'Z:/www/e-commerce/'); define('DIR_FS_ADMIN', 'Z:/www/e-commerce/admin/'); define('DIR_FS_CATALOG', 'Z:/www/e-commerce/');
  7. veni

    Temp directory

    I tried changing the easypopulate.php $tempdir = DIR_FS_DOCUMENT_ROOT . "temp/"; TO $tempdir = DIR_FS_DOCUMENT_ROOT . "Z:/www/e-commerce/temp"; But it still does not work.
  8. I have all of my files hosted locally on my PC. The Temp directory used to be at D:\www\e-commerce\temp but I recently changed my DocumnetRoot directory and now the temp file resides at Z:\www\e-commerce\temp Everything works well except easypopulate I can no longer Import files the following error is displayed Warning: move_uploaded_file(D:/Wamp/www/e-commerce/temp/=NEW=.txt) [function.move-uploaded-file]: failed to open stream: No such file or directory in Z:\www\e-commerce\admin\easypopulate_functions.php on line 43 Warning: move_uploaded_file() [function.move-uploaded-file]: Unable to move 'd:/Wamp/tmp\php75.tmp' to 'D:/Wamp/www/e-commerce/temp/=NEW=.txt' in Z:\www\e-commerce\admin\easypopulate_functions.php on line 43 File uploaded. Temporary filename: d:/Wamp/tmp\php75.tmp User filename: =NEW=.txt Size: 1405 Warning: file(D:/Wamp/www/e-commerce/temp/=NEW=.txt) [function.file]: failed to open stream: No such file or directory in Z:\www\e-commerce\admin\easypopulate.php on line 805 Warning: Invalid argument supplied for foreach() in Z:\www\e-commerce\admin\easypopulate.php on line 844 What lines or line must I change and in what file must I specify that the new temp dir in now at Z:\www\e-commerce\temp
  9. So, as far as Easy Populate is concerned, it cannot truly handle a list of 1000 items in one file; so it might be wise to split the easy populate file prior to uploading it, am I understanding correctly?
  10. Hello guys, I'm currently using Easy Populate 2.76d-MS2 for my store and I was wondering what is the maximum number of items that I can store on the database using easy populate? Also how can I increase the number of items found in the database? I currently have 1560 items and I wish to have a database that will accept an infinite number of items. Could anyone help me please?
  11. Below is the code for the Similar Product contribution of the the Similar_products.php. If need the contribution can be found here: http://www.oscommerce.com/community/contri...search,info+box Curently the BOx is displayed vertically, I would like to have it displayed HORIZONTALLY how can I modify the code below to achieve such thing? <?php /* $Id: similar_products.php,v 1.0 2004/06/06 jck Exp $ Based on whats_new.php,v 1.31 by hpdl osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2004 osCommerce Released under the GNU General Public License */ // Set the sort order for the display switch(SIMILAR_PRODUCTS_ORDER){ case 'Random': $sort_order = 'RAND() '; break; case 'Products ID': $sort_order = 'p.products_id '; break; case 'Model Number': $sort_order = 'p.products_model '; break; case 'Price': $sort_order = 'p.products_price '; break; case 'Date Added': $sort_order = 'p.products_date_added '; break; case 'Last Modified': $sort_order = 'p.products_last_modified '; break; case 'Products Ordered': $sort_order = 'p.products_ordered '; break; case 'Products Name': $sort_order = 'pd.products_name '; break; case 'Products Viewed': $sort_order = 'pd.products_viewed '; break; default: $sort_order = 'RAND() '; } // switch switch(SIMILAR_PRODUCTS_SORT_ORDER){ case 'Ascending': $sort_order .= 'asc'; break; case 'Descending': $sort_order .= 'desc'; break; default: $sort_order .= 'asc'; } // switch // Find the id # of the category that the current product is in $category_query = tep_db_query("select categories_id from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . (int)$_GET['products_id'] . "'" ); $category = tep_db_fetch_array($category_query); $category_id = $category['categories_id']; // Count prods in category; if less than 2 dont display (removes empty infobox from pages) $product_count_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc where p.products_id = pc.products_id and p.products_id = pd.products_id and p.products_id != '" . (int)$_GET['products_id'] . "' and p.products_status = '1' and pc.categories_id = '" . (int)$category_id . "' and pd.language_id = '". (int)$languages_id ."'" ); $product_count = tep_db_fetch_array($product_count_query); // if less than total similar prods displayed exist in current category, dont display (empty) infobox if ($product_count['total'] >= MAX_SIMILAR_PRODUCTS) { // Select the other products in the same category $products_query = tep_db_query("select p.products_id, p.products_image, p.products_price, p.products_model, pd.products_name, p.products_tax_class_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc where p.products_id = pc.products_id and p.products_id = pd.products_id and p.products_id != '" . (int)$_GET['products_id'] . "' and p.products_status = '1' and pc.categories_id = '" . (int)$category_id . "' and pd.language_id = '" . (int)$languages_id . "' order by " . $sort_order . " limit " . MAX_SIMILAR_PRODUCTS ); // Write the output containing each of the products $products_string = ''; $count_products = 0; while ($products = tep_db_fetch_array($products_query)) { if ($products['products_id'] != $_GET['products_id']) { $products_string .= '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products['products_id']) . '">'; $products_string .= tep_image(DIR_WS_IMAGES . $products['products_image'], $products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT); $products_string .= '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products['products_id']) . '">'; if (SIMILAR_PRODUCTS_SHOW_MODEL == 'true' && tep_not_null($products['products_model'])) { $products_string .= $products['products_model'] . '<br>'; } if ((SIMILAR_PRODUCTS_SHOW_NAME == 'true') && tep_not_null($products['products_name'])) { $products_string .= $products['products_name'] . '<br>'; } if (SIMILAR_PRODUCTS_SHOW_PRICE == 'true') { #$products_string .= $currencies->display_price($products['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '<br>'; $products_string .= $currencies->display_price($products['products_price'], tep_get_tax_rate($products['products_tax_class_id'])) . '<br>'; } $products_string .= '</a><br>'; $count_products++; } } ?> <!-- similar_products //--> <tr> <td> <?php $info_box_contents = array(); $info_box_contents[] = array('text' => BOX_HEADING_SIMILAR_PRODUCTS); new infoBoxHeading($info_box_contents, false, false); $info_box_contents = array(); $info_box_contents[] = array('align' => 'center', 'text' => $products_string ); new infoBox($info_box_contents); ?> </td> </tr> <? } // END PROD TOTAL (WITHIN CURRENT CATEGORY) CHECK ?> <!-- similar_products_eof //-->
  12. You were right on the Ball, your suggestion fixed my prolem. I thank you a great deal and keep up the good work.
  13. After searching the board I came accross a thread where it suggested to rmove the $ sign. my Configure.php went from this: define('DIR_FS_$DOCUMENT_ROOT', 'D:/Wamp/www/e-commerce/'); // where the pages are located on the server and now back to the original code this: define('DIR_FS_DOCUMENT_ROOT', 'D:/Wamp/www/e-commerce/'); // where the pages are located on the server I'm now using the "Import EP file from Temp Dir" field to import the data in my database. I do have a EP2007Jan21-1806.txt file in my /Wamp/www/e-commerce/temp folder, when I click on INSERT into db I get the following errors: Filename: EP2007Jan21-1806.txt Warning: file(D:/Wamp/www/e-commerce//e-commerce/temp/EP2007Jan21-1806.txt) [function.file]: failed to open stream: No such file or directory in D:\wamp\www\e-commerce\admin\easypopulate.php on line 824 Warning: Invalid argument supplied for foreach() in D:\wamp\www\e-commerce\admin\easypopulate.php on line 844 This is line 824 of my easypopulate.php $readed = file($tempdir . $localfile); This is line 844 of my easypopulate.php foreach ($readed as $read){ I need some serious help as I don't know what else I should do.
  14. Or maybe it's because EP cannot write to the temp folder. I'm hosting everything using Wamp on my local machine
  15. In my /catalog/admin/includes/configure.php I have it set this way define('DIR_FS_$DOCUMENT_ROOT', 'D:/Wamp/www/e-commerce/'); // where the pages are located on the server But as per the errors I'm getting, it seems to not like something about the easypopulate_functions.php on line 43
×