-
Posts
563 -
Joined
-
Last visited
-
Days Won
9
Everything posted by Omar_one
-
@@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>' .
-
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..???
-
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
-
[Addon] New Equal Height Module for osC 2.3.4 bootstrap
Omar_one replied to auzStar's topic in General Add-Ons Support
@@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 -
[Addon] New Equal Height Module for osC 2.3.4 bootstrap
Omar_one replied to auzStar's topic in General Add-Ons Support
@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 -
[Addon] New Equal Height Module for osC 2.3.4 bootstrap
Omar_one replied to auzStar's topic in General Add-Ons Support
@@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> -
[Addon] New Equal Height Module for osC 2.3.4 bootstrap
Omar_one replied to auzStar's topic in General Add-Ons Support
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 -
Optional Related Products, Version 4.0
Omar_one replied to Skittles's topic in General Add-Ons Support
@@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 -
Optional Related Products, Version 4.0
Omar_one replied to Skittles's topic in General Add-Ons Support
:( 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 -
Optional Related Products, Version 4.0
Omar_one replied to Skittles's topic in General Add-Ons Support
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 -
Optional Related Products, Version 4.0
Omar_one replied to Skittles's topic in General Add-Ons Support
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 -
Optional Related Products, Version 4.0
Omar_one replied to Skittles's topic in General Add-Ons Support
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 -
Optional Related Products, Version 4.0
Omar_one replied to Skittles's topic in General Add-Ons Support
@@raiwa I checked the product_info.php for missing closing </div> tag.. i didn't found any missing closing </div> tag BR Omar -
Optional Related Products, Version 4.0
Omar_one replied to Skittles's topic in General Add-Ons Support
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 -
Thank you Jim BR Omar
-
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
-
@@kymation do you have a User's Manual for oscommerce 2.3 bs ? thanks Omar
-
Hello, Have any one used on oscommerce 2.3 bs ?? omar
-
Hello, @@SpicyGirl did got it working in BS. If yes, can you please share it with us, BR Omar
-
thank you @@MrPhil :thumbsup:
-
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
-
[Contribution] QTpro - Quantity Tracking Professional
Omar_one replied to zonetown's topic in General Add-Ons Support
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 -
Quantity Price Breaks in bootstrap version?
Omar_one replied to HighCastle's topic in General Add-Ons Support
And for Optional Related Products this one http://addons.oscommerce.com/info/8057 works well with Bootstrap. BR Omar -
Optional Related Products, Version 4.0
Omar_one replied to Skittles's topic in General Add-Ons Support
thank you @Mention it was my mistake ..I related products to inactive product.. BR Omar -
Optional Related Products, Version 4.0
Omar_one replied to Skittles's topic in General Add-Ons Support
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