Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Omar_one

Members
  • Posts

    563
  • Joined

  • Last visited

  • Days Won

    9

Everything posted by Omar_one

  1. @@aespinal did you add this In admin\includes\boxes\catalog.php ?? '<a href="' . tep_href_link(FILENAME_QUICK_INVENTORY, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CATALOG_QUICK_INVENTORY . '</a><br>' .
  2. Here is the code for shown products location In catalog/admin/orders.php Find require('includes/application_top.php'); require(DIR_WS_CLASSES . 'currencies.php'); $currencies = new currencies(); add after tep_db_query("update orders_products , products set orders_products.products_bin = products.products_bin where orders_products.products_model = products.products_model"); 4:>>>>>>>>> In catalog/admin/packingslip.php Find <td class="dataTableHeadingContent" colspan="2"><?php echo TABLE_HEADING_PRODUCTS; ?></td> Add after <td class="dataTableHeadingContent">BIN Number </td> NOTE: BIN Number can be replaced with something of a different language or if someone wants to have this for multi-languages a Table Heading variable will have to be set-up and defined for each language. Find ' <td class="dataTableContent" valign="top">' . $order->products[$i]['model'] . '</td>' . "\n" . ' </tr>' . "\n"; Add before ' <td class="dataTableContent" valign="top">' . $order->products[$i]['bin'] . '</td>' . "\n" . 5:>>>>>>>>>> in catalog/admin/includes/classes/order.php Find $orders_products_query = tep_db_query("select orders_products_id, products_name, products_model, Add After products_bin Find 'model' => $orders_products['products_model'], Add After 'bin' => $orders_products['products_bin'], I don't know why it is not shown..???
  3. Hello I installed Products Location add-on http://addons.oscommerce.com/info/7762 on osCommerce 2.3 BS Edge and i don't have any error but it is not show the products location in the packingslip page. I edited it to show in the order page (admin) but it is not show the products location there either. Just the header of the products location is shown there. I can see products location in product edit page . any help?..or if there is another add-on will work with osCommerce 2.3 BS Edge? BR Omar
  4. @@auzStar the add-on was Miinify Code (http://addons.oscommerce.com/info/9480/v,23 i didn't fix it .. I just uninstall it :D BR Omar
  5. @auzStar thank you for your reply.. There is nothing wrong with your add-on New Equal Height Module its works well . another add-on make that mess Thank you for this add-on and for your help BR Omar
  6. @@auzStar thank you for your reply No, i haven't this problem with the old one.. my oscommerce version is OSC 2.3 BS Edge. here is product_listing.php <?php /* $Id$ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2016 osCommerce Released under the GNU General Public License */ $num_list = (isset($_GET['view']) && ($_GET['view'] == 'all') ) ? 999999 : MAX_DISPLAY_SEARCH_RESULTS; $listing_split = new splitPageResults($listing_sql, $num_list, 'p.products_id'); ?> <?php if ($messageStack->size('product_action') > 0) { echo $messageStack->output('product_action'); } ?> <div class="contentText"> <?php if ( ($listing_split->number_of_rows > 0) && ( (PREV_NEXT_BAR_LOCATION == '1') || (PREV_NEXT_BAR_LOCATION == '3') ) ) { ?> <div class="row"> <div class="col-sm-6 pagenumber hidden-xs"> <?php echo $listing_split->display_count(TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?> </div> <div class="col-sm-6"> <div class="pull-right pagenav"><ul class="pagination"><?php echo $listing_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></ul></div> <span class="pull-right"><?php echo TEXT_RESULT_PAGE; ?></span> </div> </div> <?php } if ($listing_split->number_of_rows > 0) { ?> <div class="well well-sm"> <div class="btn-group btn-group-sm pull-right"> <button type="button" class="btn btn-default dropdown-toggle" data-toggle="dropdown"> <?php echo TEXT_SORT_BY; ?><span class="caret"></span> </button> <ul class="dropdown-menu text-left"> <?php $lc_show_model = false; $lc_show_manu = false; $lc_show_qty = false; $lc_show_lbs = false; for ($col=0, $n=sizeof($column_list); $col<$n; $col++) { //sort order if ($column_list[$col] == 'PRODUCT_LIST_SORT_ORDER'){break;} //end sort order switch ($column_list[$col]) { case 'PRODUCT_LIST_MODEL': $lc_text = TABLE_HEADING_MODEL; $lc_show_model = true; break; case 'PRODUCT_LIST_NAME': $lc_text = TABLE_HEADING_PRODUCTS; break; case 'PRODUCT_LIST_MANUFACTURER': $lc_text = TABLE_HEADING_MANUFACTURER; $lc_show_manu = true; break; case 'PRODUCT_LIST_PRICE': $lc_text = TABLE_HEADING_PRICE; break; case 'PRODUCT_LIST_QUANTITY': $lc_text = TABLE_HEADING_QUANTITY; $lc_show_qty = true; break; case 'PRODUCT_LIST_WEIGHT': $lc_text = TABLE_HEADING_WEIGHT; $lc_show_lbs = true; break; case 'PRODUCT_LIST_IMAGE': $lc_text = TABLE_HEADING_IMAGE; break; case 'PRODUCT_LIST_BUY_NOW': $lc_text = TABLE_HEADING_BUY_NOW; break; case 'PRODUCT_LIST_ID': $lc_text = TABLE_HEADING_LATEST_ADDED; break; } //sort order if ($column_list[$col] == 'PRODUCT_LIST_SORT_ORDER'){break;} if ( ($column_list[$col] != 'PRODUCT_LIST_BUY_NOW') && ($column_list[$col] != 'PRODUCT_LIST_IMAGE') && ($column_list[$col] != 'PRODUCT_LIST_MULTIPLE')) { // if ( ($column_list[$col] != 'PRODUCT_LIST_BUY_NOW') && ($column_list[$col] != 'PRODUCT_LIST_IMAGE') ) { //end sort order $lc_text = tep_create_sort_heading($HTTP_GET_VARS['sort'], $col+1, $lc_text); echo ' <li>' . $lc_text . '</li>'; } } ?> </ul> </div> <?php if ( (defined('MODULE_HEADER_TAGS_GRID_LIST_VIEW_STATUS') && MODULE_HEADER_TAGS_GRID_LIST_VIEW_STATUS == 'True') && (strpos(MODULE_HEADER_TAGS_GRID_LIST_VIEW_PAGES, basename($PHP_SELF)) !== false) ) { ?> <strong><?php echo TEXT_VIEW; ?></strong> <div class="btn-group"> <a href="#" id="list" class="btn btn-default btn-sm"><span class="fa fa-th-list"></span><?php echo TEXT_VIEW_LIST; ?></a> <a href="#" id="grid" class="btn btn-default btn-sm"><span class="fa fa-th"></span><?php echo TEXT_VIEW_GRID; ?></a> </div> <?php } ?> <div class="clearfix"></div> </div> <?php $listing_query = tep_db_query($listing_split->sql_query); $prod_list_contents = NULL; while ($listing = tep_db_fetch_array($listing_query)) { $prod_list_contents .= '<div class="item list-group-item col-sm-6" itemprop="itemListElement" itemscope="" itemtype="http://schema.org/Product">'; $prod_list_contents .= ' <div class="productHolder equal-height">'; if (PRODUCT_LIST_IMAGE > 0) { if (isset($HTTP_GET_VARS['manufacturers_id']) && tep_not_null($HTTP_GET_VARS['manufacturers_id'])) { $prod_list_contents .= ' <a href="' . tep_href_link('product_info.php', 'manufacturers_id=' . $HTTP_GET_VARS['manufacturers_id'] . '&products_id=' . $listing['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $listing['products_image'], $listing['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'itemprop="image"', NULL, 'img-responsive thumbnail group list-group-image') . '</a>'; } else { $prod_list_contents .= ' <a href="' . tep_href_link('product_info.php', (isset($sort) ? 'sort=' . $sort . '&' : '') . ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $listing['products_image'], $listing['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'itemprop="image"', NULL, 'img-responsive thumbnail group list-group-image') . '</a>'; } } $prod_list_contents .= ' <div class="caption">'; if (PRODUCT_LIST_NAME > 0) { $prod_list_contents .= ' <h2 class="group inner list-group-item-heading">'; if (isset($HTTP_GET_VARS['manufacturers_id']) && tep_not_null($HTTP_GET_VARS['manufacturers_id'])) { $prod_list_contents .= ' <a itemprop="url" href="' . tep_href_link('product_info.php', 'manufacturers_id=' . $HTTP_GET_VARS['manufacturers_id'] . '&products_id=' . $listing['products_id']) . '"><span itemprop="name">' . $listing['products_name'] . '</span></a>'; } else { $prod_list_contents .= ' <a itemprop="url" href="' . tep_href_link('product_info.php', ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing['products_id']) . '"><span itemprop="name">' . $listing['products_name'] . '</span></a>'; } $prod_list_contents .= ' </h2>'; } $prod_list_contents .= ' <p class="group inner list-group-item-text" itemprop="description">' . strip_tags($listing['products_description'], '<br>') . '…</p><div class="clearfix"></div>'; $extra_list_contents = NULL; if ( (PRODUCT_LIST_MANUFACTURER > 0) && tep_not_null($listing['manufacturers_id']) ) { $extra_list_contents .= '<dt>' . TABLE_HEADING_MANUFACTURER . '</dt>'; $extra_list_contents .= '<dd><a href="' . tep_href_link('index.php', 'manufacturers_id=' . (int)$listing['manufacturers_id']) . '">' . $listing['manufacturers_name'] . '</a></dd>'; } if ( (PRODUCT_LIST_MODEL > 0) && tep_not_null($listing['products_model']) ) { $extra_list_contents .= '<dt>' . TABLE_HEADING_MODEL . '</dt>'; $extra_list_contents .= '<dd>' . $listing['products_model'] . '</dd>'; } if ( (PRODUCT_LIST_QUANTITY > 0) && (tep_get_products_stock($listing['products_id']) > 0) ) { $extra_list_contents .= '<dt>' . TABLE_HEADING_QUANTITY . '</dt>'; $extra_list_contents .= '<dd>' . tep_get_products_stock($listing['products_id']) . '</dd>'; } if (PRODUCT_LIST_WEIGHT > 0) { $extra_list_contents .= '<dt>' . TABLE_HEADING_WEIGHT . '</dt>'; $extra_list_contents .= '<dd>' . $listing['products_weight'] . '</dd>'; } if (tep_not_null($extra_list_contents)) { $prod_list_contents .= ' <dl class="dl-horizontal list-group-item-text">'; $prod_list_contents .= $extra_list_contents; $prod_list_contents .= ' </dl>'; } if ( (PRODUCT_LIST_PRICE > 0) || (PRODUCT_LIST_BUY_NOW > 0) ) { $prod_list_contents .= ' <div class="row">'; if (PRODUCT_LIST_PRICE > 0) { if (tep_not_null($listing['specials_new_products_price'])) { $prod_list_contents .= ' <div class="col-xs-6" itemprop="offers" itemscope itemtype="http://schema.org/Offer"><meta itemprop="priceCurrency" content="' . tep_output_string($currency) . '" /><div class="btn-group" role="group"><button type="button" class="btn btn-default"><del>' . $currencies->display_price($listing['products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . '</del></span> <span class="productSpecialPrice" itemprop="price" content="' . $currencies->display_raw($listing['products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . '">' . $currencies->display_price($listing['specials_new_products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . '</span></button></div></div>'; } else { $prod_list_contents .= ' <div class="col-xs-6" itemprop="offers" itemscope itemtype="http://schema.org/Offer"><meta itemprop="priceCurrency" content="' . tep_output_string($currency) . '" /><div class="btn-group" role="group"><button type="button" class="btn btn-default"><span itemprop="price" content="' . $currencies->display_raw($listing['products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . '">' . $currencies->display_price($listing['products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . '</span></button></div></div>'; } } if (PRODUCT_LIST_BUY_NOW > 0) { $prod_list_contents .= ' <div class="col-xs-6 text-right">' . tep_draw_button(IMAGE_BUTTON_BUY_NOW, 'fa fa-shopping-cart', tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $listing['products_id']), NULL, NULL, 'btn-success btn-sm') . '</div>'; } $prod_list_contents .= ' </div>'; } $prod_list_contents .= ' </div>'; $prod_list_contents .= ' </div>'; $prod_list_contents .= '</div>'; } echo '<div id="products" class="row list-group" itemtype="http://schema.org/ItemList">'; echo ' <meta itemprop="numberOfItems" content="' . (int)$listing_split->number_of_rows . '" />'; echo $prod_list_contents; echo '</div>'; } else { ?> <div class="alert alert-info"><?php echo TEXT_NO_PRODUCTS; ?></div> <?php } if ( ($listing_split->number_of_rows > 0) && ((PREV_NEXT_BAR_LOCATION == '2') || (PREV_NEXT_BAR_LOCATION == '3')) ) { ?> <div class="row"> <div class="col-sm-6 pagenumber hidden-xs"> <?php echo $listing_split->display_count(TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?> </div> <div class="col-sm-6"> <div class="pull-right pagenav"><ul class="pagination"><?php echo $listing_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></ul></div> <span class="pull-right"><?php echo TEXT_RESULT_PAGE; ?></span> </div> </div> <?php } ?> </div>
  7. Hi auzStar. I installed the addon but it is not working well,the products dont seem to be displaying correctly, there is some empty product column, and uninstall it and install the old one ... and still the same problem. any help plz? BR Omar
  8. @@raiwa They say (There are no stupid questions, only stupid answers.) I dont have product info content module installed.. but now its work fine .. i just remove module and install it again with your code changes and now its WORKING :thumbsup: Thank you Rainer
  9. :( 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MODULE_CONTENT_PRODUCT_INFO_ADMIN_RELATED_PRODUCTS_MAX_ROW_LISTS_OPTIONS' at line 5 select pa.*, pd.products_id from products_related_products pa left join products_description pd on pa.pop_products_id_master = pd.products_id and pd.language_id = '5' order by pd.products_name, pa.pop_order_id, pa.pop_id LIMIT 0, MODULE_CONTENT_PRODUCT_INFO_ADMIN_RELATED_PRODUCTS_MAX_ROW_LISTS_OPTIONS
  10. here the changes $related_what = "p.products_id"; $related_from = " from products p, products_related_products pa"; $related_from .= ", products_description pd"; $related_where = " where pa.pop_products_id_master = p.products_id"; if (MODULE_CONTENT_PRODUCT_INFO_ADMIN_RELATED_PRODUCTS_USE_MODEL == 'True') { $related_what .= ", p.products_model"; } if (MODULE_CONTENT_PRODUCT_INFO_ADMIN_RELATED_PRODUCTS_USE_NAME == 'True') { $related_what .= ", pd.products_name"; //$related_from .= ", products_description pd"; $related_where .= " and p.products_id = pd.products_id"; $related_where .= " and pd.language_id = '" . $languages_id . "'"; // edit relation master product menu $related_what = "p.products_id"; $related_from .= ", products_description pd"; $related_from = " from products p"; $related_where = " where p.products_id > '0'"; if (MODULE_CONTENT_PRODUCT_INFO_ADMIN_RELATED_PRODUCTS_USE_MODEL == 'True') { $related_what .= ", p.products_model"; } if (MODULE_CONTENT_PRODUCT_INFO_ADMIN_RELATED_PRODUCTS_USE_NAME == 'True') { $related_what .= ", pd.products_name"; //$related_from .= ", products_description pd"; $related_where .= " and p.products_id = pd.products_id"; $related_where .= " and pd.language_id = '" . $languages_id . "'"; } <?php $related_what = "p.products_id"; $related_from .= ", products_description pd"; $related_from = " from products p"; $related_where = " where p.products_id > '0'"; if (MODULE_CONTENT_PRODUCT_INFO_ADMIN_RELATED_PRODUCTS_USE_MODEL == 'True') { $related_what .= ", p.products_model"; } if (MODULE_CONTENT_PRODUCT_INFO_ADMIN_RELATED_PRODUCTS_USE_NAME == 'True') { $related_what .= ", pd.products_name"; //$related_from .= ", products_description pd"; $related_where .= " and p.products_id = pd.products_id"; $related_where .= " and pd.language_id = '" . $languages_id . "'"; } $related_what = "p.products_id"; $related_from .= ", products_description pd"; $related_from = " from products p"; $related_where = " where p.products_id > '0'"; if (MODULE_CONTENT_PRODUCT_INFO_ADMIN_RELATED_PRODUCTS_USE_MODEL == 'True') { $related_what .= ", p.products_model"; } if (MODULE_CONTENT_PRODUCT_INFO_ADMIN_RELATED_PRODUCTS_USE_NAME == 'True') { $related_what .= ", pd.products_name"; //$related_from .= ", products_description pd"; $related_where .= " and p.products_id = pd.products_id"; $related_where .= " and pd.language_id = '" . $languages_id . "'"; and now new error appear Products with relations: >> 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MODULE_CONTENT_PRODUCT_INFO_ADMIN_RELATED_PRODUCTS_MAX_ROW_LISTS_OPTIONS' at line 5 select pa.*, pd.products_id from products_related_products pa left join products_description pd on pa.pop_products_id_master = pd.products_id and pd.language_id = '5' order by pd.products_name, pa.pop_order_id, pa.pop_id LIMIT 0, MODULE_CONTENT_PRODUCT_INFO_ADMIN_RELATED_PRODUCTS_MAX_ROW_LISTS_OPTIONS
  11. Thank you @@raiwa sorry about not type what the exact add-on and store version.. Related_Products_234_BS_6.1r2 and oscommerce 2.3 bs edeg I made the changes but still same error. BR Omar
  12. Hi, i removed the module and reinstall it again, now the module not shown and there is error on the admin side when i try go to Catalog => related products and here is the error 1054 - Unknown column 'pd.products_name' in 'order clause' select distinct p.products_id from products p, products_related_products pa where pa.pop_products_id_master = p.products_id order by pd.products_name I dont know what i have been done o:) Thank you for any help BR Omar
  13. @@raiwa I checked the product_info.php for missing closing </div> tag.. i didn't found any missing closing </div> tag BR Omar
  14. Hello, I had Related Products BS http://addons.oscommerce.com/info/9499 after i update it for the new one (Related_Products_234_BS_6.0), in product_info page where there is related product, the left column disappear, and right column shows just before the footer. but if there is no related product to product, the page show fine.. ps. when remove the module.. everything work fine.. any help plz BR Omar
  15. thank you Jim, i will give it another try to install it on osC 2.3.4 Bootstrap. do you think that osC 2.3.4 Bootstrap Edge can be on live shop? I have webshop based on oscommerce 2.2RC2a. and i updated to oscommerce 2.3 Bootstrap Edge. of course old shop still live and new (Bootstrap Edge) in subcategory not yet. BR Omar
  16. @@kymation do you have a User's Manual for oscommerce 2.3 bs ? thanks Omar
  17. Hello, Have any one used on oscommerce 2.3 bs ?? omar
  18. Hello, @@SpicyGirl did got it working in BS. If yes, can you please share it with us, BR Omar
  19. Hello , i have problem with SEO in oscommerce 2.3 bs Edge i have multi languages in the store, the SEO in english language working, but in the another language not working well , its show the product name, category name,.... then it show MODULE_HEADER_TAGS_PRODUCT_SEO_SEPARATOR, MODULE_HEADER_TAGS_CATEGORY_SEO_SEPARATOR . example: it show like this ( kangol Avalon 507MODULE_HEADER_TAGS_PRODUCT_SEO_SEPARATOR) BR Omar
  20. Hello, I just installed OTPro on OSC 2.3.4 Bootstrap (Edge) .. I got error 500 in the admin side .. did any one have same issue? did any one has install it and worked well on OSC 2.3.4 Bootstrap (Edge)? BR Omar
  21. And for Optional Related Products this one http://addons.oscommerce.com/info/8057 works well with Bootstrap. BR Omar
  22. thank you @Mention it was my mistake ..I related products to inactive product.. BR Omar
  23. its say in the Instructions that i have to making changes to the following files: [catalog/]product_info.php [catalog/]includes/languages/english.php [catalog/]includes/languages/english/product_info.php but there is no instructions there to make the changes??? BR Omar
×
×
  • Create New...