Jump to content

lucky644

Members
  • Content count

    23
  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    Jeff
  1. So, say I wanted to import a product like so. Category: Trees Product name: Maple Tree Price: $300 How would that be put into the spreadsheet?
  2. Wow this is a huge thread...I'll try posting and reading it after. Anyhow, I installed this long ago but never got around to using it, I downloaded the txt of my existing inventory and it looked too complicated to bother using. Recently I ran into a problem...I have to enter HUNDREDS of items into the store, so now I'm going to have to use this. Is there a way, to import with excel, just the price/name? No taxes, no options, no picture. Just the proper category.
  3. Gah, wish this would let me edit...I hate spamming. Anyhow, I fixed those other pages by adding define('TEXT_CALL_FOR_PRICE', 'Call for Price'); to them all. I'm learning, slowly :P I still can't figure out why /products_new.php doesn't want to show up... I'll post the code, maybe someone will see where I screwed up. <?php /* $Id: products_new.php,v 1.27 2003/06/09 22:35:33 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCTS_NEW); $breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_PRODUCTS_NEW)); ?> <!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> <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <link rel="stylesheet" type="text/css" href="stylesheet.css"> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="3" cellpadding="3"> <tr> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> <!-- 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="0"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> <td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_products_new.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php $products_new_array = array(); $products_new_query_raw = "select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on (p.manufacturers_id = m.manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_date_added DESC, pd.products_name"; $products_new_split = new splitPageResults($products_new_query_raw, MAX_DISPLAY_PRODUCTS_NEW); if (($products_new_split->number_of_rows > 0) && ((PREV_NEXT_BAR_LOCATION == '1') || (PREV_NEXT_BAR_LOCATION == '3'))) { ?> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="smallText"><?php echo $products_new_split->display_count(TEXT_DISPLAY_NUMBER_OF_PRODUCTS_NEW); ?></td> <td align="right" class="smallText"><?php echo TEXT_RESULT_PAGE . ' ' . $products_new_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } ?> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <?php if ($products_new_split->number_of_rows > 0) { $products_new_query = tep_db_query($products_new_split->sql_query); while ($products_new = tep_db_fetch_array($products_new_query)) { if ($new_price = tep_get_products_special_price($products_new['products_id'])) { $products_price = '<s>' . $currencies->display_price($products_new['products_price'], tep_get_tax_rate($products_new['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($products_new['products_tax_class_id'])) . '</span>'; } else { $products_price = $currencies->display_price($products_new['products_price'], tep_get_tax_rate($products_new['products_tax_class_id'])); } ?> <tr> <td width="<?php echo SMALL_IMAGE_WIDTH + 10; ?>" valign="top" class="main"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products_new['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $products_new['products_image'], $products_new['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a>'; ?></td> <td valign="top" class="main"></td> <td valign="top" class="main"><?php // echo '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products_new['products_id']) . '"><b><u>' . $products_new['products_name'] . '</u></b></a><br>' . TEXT_DATE_ADDED . ' ' . tep_date_long($products_new['products_date_added']) . '<br>' . TEXT_MANUFACTURER . ' ' . $products_new['manufacturers_name'] . '<br><br>' . TEXT_PRICE . ' ' . $products_price; ?></td> <td align="right" valign="middle" class="main"><?php if($products_price == '$999,999.00') { echo '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products_new['products_id']) . '"><b><u>' . $products_new['products_name'] . '</u></b></a><br>' . TEXT_DATE_ADDED . ' ' . tep_date_long($products_new['products_date_added']) . '<br><br>' . TEXT_PRICE . ' ' . $lc_text . = TEXT_CALL_FOR_PRICE;; } else { echo '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products_new['products_id']) . '"><b><u>' . $products_new['products_name'] . '</u></b></a><br>' . TEXT_DATE_ADDED . ' ' . tep_date_long($products_new['products_date_added']) . '<br><br>' . TEXT_PRICE . ' ' . $products_price; } ?></td> <td align="right" valign="middle" class="main"><?php if($products_price == '$999,999.00') { echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_NEW, tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $products_new['products_id']) . '">' . '</a>'; } else { echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_NEW, tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $products_new['products_id']) . '">' . tep_image_button('button_in_cart.gif', IMAGE_BUTTON_IN_CART) . '</a>'; } ?></td> </tr> <tr> <td colsp?an="3"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } } else { ?> <tr> <td class="main"><?php echo TEXT_NO_NEW_PRODUCTS; ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } ?> </table></td> </tr> <?php if (($products_new_split->number_of_rows > 0) && ((PREV_NEXT_BAR_LOCATION == '2') || (PREV_NEXT_BAR_LOCATION == '3'))) { ?> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="smallText"><?php echo $products_new_split->display_count(TEXT_DISPLAY_NUMBER_OF_PRODUCTS_NEW); ?></td> <td align="right" class="smallText"><?php echo TEXT_RESULT_PAGE . ' ' . $products_new_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></td> </tr> </table></td> </tr> <?php } ?> </table></td> <!-- body_text_eof //--> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> <!-- right_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_right.php'); ?> <!-- right_navigation_eof //--> </table></td> </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'); ?>
  4. I just noticed another problem, in the 'whats new' box on the left, when viewing the following pages: Shipping & Returns Privacy Notice Conditions of Use Contact Us The text under any images that are set to 'call' are showing as; TEXT_CALL_FOR_PRICE Instead of; Call for Price Bah, error after error :(
  5. I had the same problem, doing that fixed my main page, however my other page doesnt even show up; http://www.pretendmysiteishere.com/products_new.php Thoughts? I tried reverting back to the original, and it still doesn't show.
  6. lucky644

    Scrolling Images Carousel

    Alright, found a post I missed before when searching that fixed the php problem, and now when I enable it, I get this; //Specify the slider's width (in pixels) var sliderwidth="760"; //Specify the slider's height var sliderheight="150"; //Specify the slider's slide speed (larger is faster 1-10) var slidespeed=2; //configure background color: slidebgcolor="#e9f7f8"; //Specify the slider's images var leftrightslide=new Array(); var finalslide=''; 1064 - You have an error in your SQL syntax near 'UNION SELECT p2c.products_id FROM products_to_categories p2c WHERE p2c.categorie' at line 1 SELECT p2c.products_id FROM products_to_categories p2c WHERE p2c.categories_id='0' UNION SELECT p2c.products_id FROM products_to_categories p2c WHERE p2c.categories_id='21' UNION SELECT p2c.products_id FROM products_to_categories p2c WHERE p2c.categories_id='22' UNION SELECT p2c.products_id FROM products_to_categories p2c WHERE p2c.categories_id='23' ORDER BY products_id desc [TEP STOP] bah! I give up.
  7. lucky644

    Scrolling Images Carousel

    Okay, I messed around in the database and found key 153 was paypal....so I removed it. Now I get this error, and key 147 doesnt seem to exist. 1062 - Duplicate entry '147' for key 1 insert into configuration set configuration_id = '147', configuration_title = 'Scrolling Product Header', configuration_key = 'DISPLAY_SCROLLING_HEADER_PRODUCTS', configuration_value = '0', configuration_description = 'Number of items to display in a scrolling header bar for products in current category and subcategories', configuration_group_id = '1', sort_order = '21', date_added = now() [TEP STOP] EDIT: Argh, okay I missed it, turns out it was the money order module....and now i have ANOTHER error, and I don't think I can remove this one.... 1062 - Duplicate entry '142' for key 1 insert into configuration set configuration_id = '142', configuration_title = 'Scrolling Product Header', configuration_key = 'DISPLAY_SCROLLING_HEADER_PRODUCTS', configuration_value = '0', configuration_description = 'Number of items to display in a scrolling header bar for products in current category and subcategories', configuration_group_id = '1', sort_order = '21', date_added = now() [TEP STOP] 142 Recreate Session SESSION_RECREATE False Recreate the session to generate a new session ID ... 15 7 NULL 2005-08-13 13:23:29 NULL tep_cfg_select_option(array('True', 'False'), I tried changing the key, but no matter what I change it to, the php error changes with it.
  8. Hello, I am trying to install this contribution; http://www.oscommerce.com/community/contri...earch,slideshow However, when I do the step where I visit the PHP file I created, that is supposed to put in the entries, I get this error; 1062 - Duplicate entry '153' for key 1 insert into configuration set configuration_id = '153', configuration_title = 'Scrolling Product Header', configuration_key = 'DISPLAY_SCROLLING_HEADER_PRODUCTS', configuration_value = '0', configuration_description = 'Number of items to display in a scrolling header bar for products in current category and subcategories', configuration_group_id = '1', sort_order = '21', date_added = now() [TEP STOP] Hopefully someone can tell me what's wrong :( --Jeff
×