Jump to content

wlsnoops

Members
  • Content count

    41
  • Joined

  • Last visited

Everything posted by wlsnoops

  1. wlsnoops

    [Addon} Modular Front Page

    Unfortunately, that didn't work. I have no issues with formatting on the other pages. I think I will poke around on one of those pages and see what works. Will post back here if I find a solution.
  2. wlsnoops

    [Addon} Modular Front Page

    When I click the source button, it shows the formatting. When I unclick the source button, the html becomes visible on the page. I have to delete it after that. For example, if I highlight a few words and change the font color to red, then click the source button, I see this for the words that I changed to red: <span style='"color: rgb(255, );' 0,="" 0)\\\"="">. After I unclick the source button, it stays there, visible on the web page. Then I have to go back and remove it. Hope you are understanding what I'm trying to say. Thanks for the quick replies.
  3. wlsnoops

    [Addon} Modular Front Page

    Hi Jim, That's exactly how I've been doing it, but it doesn't work for me. Looks okay until I click the "Save" button. Maybe it's something within CKEditor. Guess I'll poke around that website for a while. Thanks again.
  4. wlsnoops

    [Addon} Modular Front Page

    Is it possible to change the font color in the text main area? I am using CKEditor with my OSC 2.3.3.4 cart. I am able to change a font to bold but that is as far as formatting goes for me. Thanks.
  5. wlsnoops

    Margin Report not displaying reports

    Joli, It seems there was a file missing from the download package at http://addons.oscommerce.com/info/8147/v,23. There was no English language folder, just the Dutch and French folders. I translated the "margin_report.php" file in Dutch to English. (Hooray for Google Translate). That put the headers in their proper prospective. I now have to tackle the reports as they still aren't working. Thanks for your help. ...Will
  6. Oscommerce 2.3.3.4 Margin report v3.00 The margin report shows all the products, prices, costs and margins, but the reports do not work. I can chose any report and it comes up blank. Additionally, the column headings in the report do not display correctly. (See attached images.) I'm not unhappy with the addon as it does give me the basic information I want, but it would be nice if it worked as it should. I've mungled it up and can't find my mistake. Thanks.
  7. wlsnoops

    [Addon} Modular Front Page

    Thanks, Joli1811. I also found this one. So far, this seems to be working properly. Thanks again for your help.
  8. wlsnoops

    [Addon} Modular Front Page

    Well, I finally found the culprit. I had installed some code from addthis.com for a 'sharing slidebar'. I had this thing installed for over a month with no problems until last week. As soon as I disabled it, the scroll bar returned to normal. Ahh, the learning never stops. Thanks again, Jim and joli1811. ...Will
  9. wlsnoops

    [Addon} Modular Front Page

    @@joli1811 This is certainly one for the books. I still see the error even after I cleared the cache in Firefox. I've also cleared it in IE11. I am at seeing this at my office. I just went to another building and had someone else bring it up. Still looks the same. Here is a screen shot. I hope it is permissible to post this here. http://i62.tinypic.com/2u97hxt.jpg
  10. wlsnoops

    [Addon} Modular Front Page

    Thanks, Jim. I'll check into restoring the configuration tables. Have never tried this before, so it will be a learning experience for me. I appreciate all the help and advice you've given me recently.
  11. wlsnoops

    [Addon} Modular Front Page

    Ok, this is a little freaky. I restored from a back-up from nine days ago (well before the issue started) and it still overlaps the text. Is it even remotely possible that it could be database related? I did not restore the database, just the site itself. Thanks, ...Will
  12. wlsnoops

    [Addon} Modular Front Page

    Haven't tried the flex slider yet, but will give it a shot. Thanks for your help. ...Will
  13. wlsnoops

    [Addon} Modular Front Page

    No, unfortunately, that didn't make a difference.
  14. wlsnoops

    [Addon} Modular Front Page

    Sorry, Jim. No joy. On my end, I've tried it with IE 11, Firefox 31, Chrome and Opera 23 with the same results. For the record, I disabled CKeditor, erased everything in the 'text main' area and retyped everything from scratch and the issue is still there. Thanks, ...Will
  15. wlsnoops

    [Addon} Modular Front Page

    Hello Jim, Thanks for the reply. Here is the web site: www.tristateshippingsupplies.com. I will leave the scroller enabled so that you may take a look at it. My site has CKeditor installed and I made some changes using it to changes some verbiage on the index page. Not sure if it utilizes html or not. I've made similar changes many times before without any issues. Thanks for any help you can send my way. If I find a solution on my own, I will be sure to post back here. Thanks again. ...Will
  16. wlsnoops

    [Addon} Modular Front Page

    Oscommerce 2.3.3.4 Modular Front Page 1.4 Hello, This morning I added a couple of new items to my store and changed some wording in the "Text Main" section. After going back to the index page, the first couple of paragraphs jumped up under the scroller and the scroller itself is off-centered to the right. I have the scroller configured to go right above the text main area. I've tried to retrace my steps and even reloaded a backup from yesterday, but it still acts the same way. Any ideas as to what is causing this? Thanks. ...Will
  17. OSC 2.3.3.4 Mobile_OsC 7.5.0 Hello, I'm having some trouble updating my theme through Jquerymobile themeroller. Using the Design_customization_css.docx, I follow all the instructions down to this part: p. open your new jquey stylesheet: mobile/ext/css/theme-Mytheme-min.css find line 12: @@import "mobile_Osc_stylesheet.css"; Replace with: @@import "mobile_Mytheme_stylesheet.css"; What is unclear to me is that I do not find anything like that on line 12 when I open my new "mobile/ext/css/theme-Mytheme-min.css. Where am I going wrong? Thanks a million, as ususal.
  18. Found the problem! I had created an additional info box and needed to add a line in filenames.php. The issue was a missing semi-colon. Incorrect: define('FILENAME_CORPORATE_SALES', 'corporate_sales.php') <---missing semi-colon //BOF Mobile define ('FILENAME_CATALOG_MB', 'catalog_mb.php'); define ('FILENAME_SEARCH', 'search.php'); define ('FILENAME_ABOUT', 'about.php'); define ('FILENAME_OPTIONS', 'options.php'); //EOF Mobile ?> Correct: define('FILENAME_CORPORATE_SALES', 'corporate_sales.php'); <---with semi-colon //BOF Mobile define ('FILENAME_CATALOG_MB', 'catalog_mb.php'); define ('FILENAME_SEARCH', 'search.php'); define ('FILENAME_ABOUT', 'about.php'); define ('FILENAME_OPTIONS', 'options.php'); //EOF Mobile ?> Thanks, Rainer, for pointing me in the right direction.
  19. Thanks for the quick reply, Rainer. I thought that may have been the problem earlier, but when I add the lines to filename.php, it returns a 500 Internal Server Error. If I leave them out, two out of the five buttons at the top work. Other than what I described earlier, the cart appears to behave correctly. I was even able to place a dummy order successfully. Thanks again.
  20. OSC 2.3.3.4 Mobile_OsC 7.5.0 Hello, I'm sure the answer I need is somewhere in the 64 pages on this topic, but I can't seem to locate the answer. Got the mobile site to redirect just fine. The issue that I'm having is the Store, Search and Information buttons do not work. The Home and Account buttons work as they are supposed to. For instance the "Store" button returns this: http://store.tristateshippingsupplies.com/osc/mobile/FILENAME_CATALOG_MB instead of: http://store.tristateshippingsupplies.com/osc/mobile/catalog_mb.php Additionally, if I copy and paste: http://store.tristateshippingsupplies.com/osc/mobile/catalog_mb.php directly into my browser, the page comes up, but the product links have the same issue. I apologize if this has been answered before, but I have been staring at the screen so long, I'm getting cross-eyed. :wacko: Thanks in advance for any assistance.
  21. Hello, I am using Oscommerce 2.3.3.4. As I was adding products to my store today, I suddenly realized there is no field in admin/categories/products for the actual cost of an item. I would like to know at a glance what I last paid for the items so that profit margins can be maintained. Is there an easy way to do this or at least a workaround? Thanks.
  22. wlsnoops

    Product cost? Is there an easy way?

    <Solved> Stupid me. As I edit a particular file, I will rename the old and then upload the new one to the same directory. In the admin/includes/boxes directory, I had an additional 'reports' file with a different name which caused the apparent duplication. Thanks for all your help.
  23. wlsnoops

    Product cost? Is there an easy way?

    Is this what you need? Not sure what you meant what you meant by MySQL. Thanks again. ...Will ## Margin Report for OSCommerce v2.3.1 ### ### ### ### Based on Margin Report V3.00 ### ### ### ### Modifications done by Lennerd ### ### ### ############################################################################################################ ### ### ### Margin Report v3.00 ### ### ### ### Official Support Thread http://forums.oscommerce.com/index.php?showtopic=99144 ### ### ### ### If you find this contribution useful and would like to make a donation ### ### so that I can continue to build contributions for the community such as this one and Family Products.### ### Thanks and I hope you find this contribution useful. ### ### ### ### -Chris (a.k.a. blueline) P.S. ### ### ### ### If you find this contribution useful I'd like to hear about it. ### ### ### ### You can email me at osc@eclyptiq.com and let me know what you think. Thanks again. ### ### ### ### Margin Report v3.00 - - by mr_absinthe 2008/03/16 - www.OriginalAbsinthe.com ### ### percentage margin per order ### ### order status filter ### ### order number clickable to link to the order details ### ### ### ### ### ### Installation Instructions for OSCommerce 2.3.1 ### ### ### ### Files included: ### ### ### ### /catalog/admin/margin_report.php ### ### /catalog/admin/margin_report2.php ### ### /catalog/admin/includes/languages/dutch/margin_report.php ### ### /catalog/admin/includes/languages/dutch/images/buttons/button_export.gif * untouched * ### ### /catalog/admin/includes/languages/french/margin_report.php * untouched * ### ### /catalog/admin/includes/languages/french/images/buttons/button_export.gif * untouched * ### ### ### ### ### ### Files to Edit: ### ### ### ### /catalog/admin/categories.php ### ### /catalog/admin/includes/languages/english/categories.php ### ### /catalog/admin/includes/languages/english.php ### ### /catalog/admin/includes/boxes/reports.php ### ### /catalog/admin/includes/filenames.php ### ### /catalog/includes/classes/order.php ### ### /catalog/includes/classes/shopping_cart.php ### ### /catalog/checkout_process.php ### ### ### ### SQL to Alter (see bottom of this file) ### ############################################################################################################ Installation Instructions for OSCommerce 2.3.1 These instructions are the basic modifications to be done to get it working with your OSCommerce version 2.3.1. I did it on a quite modified shop and without any issue what so ever. First, copy the included files to your shop via FTP. Modifications to be done manually: Open: /catalog/admin/categories.php Find: <tr bgcolor="#ebebff"> <td class="main"><?php echo TEXT_PRODUCTS_PRICE_NET; ?></td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('products_price', $pInfo->products_price, 'onKeyUp="updateGross()"'); ?></td> </tr> Replace With: <tr bgcolor="#ebebff"> <td class="main"><?php echo TEXT_PRODUCTS_PRICE_COST; ?></td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('products_cost', $pInfo->products_cost, ''); ?></td> </tr> <tr bgcolor="#ebebff"> <td class="main"><?php echo TEXT_PRODUCTS_PRICE_NET; ?></td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('products_price', $pInfo->products_price, 'onKeyUp="updateGross()"'); ?></td> </tr> Find: if (isset($HTTP_GET_VARS['search'])) { $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p2c.categories_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and pd.products_name like '%" . tep_db_input($search) . "%' order by pd.products_name"); } else { $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' order by pd.products_name"); } Replace With: if (isset($HTTP_GET_VARS['search'])) { $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_cost, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p2c.categories_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and pd.products_name like '%" . tep_db_input($search) . "%' order by pd.products_name"); } else { $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_cost, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' order by pd.products_name"); } Find: 'products_price' => '', Replace With: 'products_price' => '', 'products_cost' => '', Find: $contents[] = array('text' => '<br>' . TEXT_PRODUCTS_PRICE_INFO . ' ' . $currencies->format($pInfo->products_price) . '<br>' . TEXT_PRODUCTS_QUANTITY_INFO . ' ' . $pInfo->products_quantity); Replace With: $contents[] = array('text' => '<br>' . TEXT_PRODUCTS_COST_INFO . ' ' . $currencies->format($pInfo->products_cost) . '<br>' . TEXT_PRODUCTS_PRICE_INFO . ' ' . $currencies->format($pInfo->products_price) . '<br><br>' . TEXT_PRODUCTS_PROFIT_INFO . ' ' . $currencies->format($pInfo->products_price-$pInfo->products_cost) . '<br><br>' . TEXT_PRODUCTS_QUANTITY_INFO . ' ' . $pInfo->products_quantity); Find: 'products_price' => tep_db_prepare_input($HTTP_POST_VARS['products_price']), Replace With: 'products_price' => tep_db_prepare_input($HTTP_POST_VARS['products_price']), 'products_cost' => tep_db_prepare_input($HTTP_POST_VARS['products_cost']), Find: } elseif ($HTTP_POST_VARS['copy_as'] == 'duplicate') { $product_query = tep_db_query("select products_quantity, products_model, products_image, products_price, products_date_available, products_weight, products_tax_class_id, manufacturers_id from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'"); $product = tep_db_fetch_array($product_query); tep_db_query("insert into " . TABLE_PRODUCTS . " (products_quantity, products_model,products_image, products_price, products_date_added, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id) values ('" . tep_db_input($product['products_quantity']) . "', '" . tep_db_input($product['products_model']) . "', '" . tep_db_input($product['products_image']) . "', '" . tep_db_input($product['products_price']) . "', now(), '" . tep_db_input($product['products_date_available']) . "', '" . tep_db_input($product['products_weight']) . "', '0', '" . (int)$product['products_tax_class_id'] . "', '" . (int)$product['manufacturers_id'] . "')"); $dup_products_id = tep_db_insert_id(); Replace With: } elseif ($HTTP_POST_VARS['copy_as'] == 'duplicate') { $product_query = tep_db_query("select products_quantity, products_model, products_image, products_price, products_cost, products_date_available, products_weight, products_tax_class_id, manufacturers_id from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'"); $product = tep_db_fetch_array($product_query); tep_db_query("insert into " . TABLE_PRODUCTS . " (products_quantity, products_model,products_image, products_price, products_cost, products_date_added, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id) values ('" . tep_db_input($product['products_quantity']) . "', '" . tep_db_input($product['products_model']) . "', '" . tep_db_input($product['products_image']) . "', '" . tep_db_input($product['products_price']) . "', '" . tep_db_input($product['products_cost']) . "', now(), '" . tep_db_input($product['products_date_available']) . "', '" . tep_db_input($product['products_weight']) . "', '0', '" . (int)$product['products_tax_class_id'] . "', '" . (int)$product['manufacturers_id'] . "')"); $dup_products_id = tep_db_insert_id(); Find: if (isset($HTTP_GET_VARS['pID']) && empty($HTTP_POST_VARS)) { $product_query = tep_db_query("select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product = tep_db_fetch_array($product_query); Replace With: if (isset($HTTP_GET_VARS['pID']) && empty($HTTP_POST_VARS)) { $product_query = tep_db_query("select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_cost, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product = tep_db_fetch_array($product_query); Save and close. Now open: * NOTE: In the V3.00 no version of the english margin report was included, so modify the part below to your languages. * /catalog/admin/includes/languages/english/categories.php Add: define('TEXT_PRODUCTS_COST_INFO', 'Cost: '); define('TEXT_PRODUCTS_PROFIT_INFO', 'Profit:'); define('TEXT_PRODUCTS_PRICE_COST', 'Products Price (Cost):'); Also add these lines to other languages you are using. Save and close. Now open: /catalog/admin/includes/languages/english.php Find: define('BOX_REPORTS_ORDERS_TOTAL', 'Customer Orders-Total'); Replace With: define('BOX_REPORTS_MARGIN_REPORT', 'Margin Report'); define('BOX_REPORTS_ORDERS_TOTAL', 'Customer Orders-Total'); Also replace these lines to other languages you are using. Save and close. Now open: /catalog/admin/includes/boxes/reports.php Find: array( 'code' => FILENAME_STATS_CUSTOMERS, 'title' => BOX_REPORTS_ORDERS_TOTAL, 'link' => tep_href_link(FILENAME_STATS_CUSTOMERS) ) Before add: array( 'code' => FILENAME_MARGIN_REPORT, 'title' => BOX_REPORTS_MARGIN_REPORT, 'link' => tep_href_link(FILENAME_MARGIN_REPORT) ), Save and close. Now open: /catalog/admin/includes/filenames.php Add: define('FILENAME_MARGIN_REPORT', 'margin_report.php'); define('FILENAME_MARGIN_REPORT2', 'margin_report2.php'); Save and close. Now open: /catalog/includes/classes/order.php Find: $orders_products_query = tep_db_query("select orders_products_id, products_id, products_name, products_model, products_price, products_tax, products_quantity, final_price from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$order_id . "'"); while ($orders_products = tep_db_fetch_array($orders_products_query)) { $this->products[$index] = array('qty' => $orders_products['products_quantity'], 'id' => $orders_products['products_id'], 'name' => $orders_products['products_name'], 'model' => $orders_products['products_model'], 'tax' => $orders_products['products_tax'], 'price' => $orders_products['products_price'], 'final_price' => $orders_products['final_price']); Replace With: $orders_products_query = tep_db_query("select orders_products_id, products_id, products_name, products_model, products_price, products_cost, products_tax, products_quantity, final_price from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$order_id . "'"); // $orders_products_query = tep_db_query("select orders_products_id, products_id, products_name, products_model, products_price, products_tax, products_quantity, final_price from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$order_id . "'"); while ($orders_products = tep_db_fetch_array($orders_products_query)) { $this->products[$index] = array('qty' => $orders_products['products_quantity'], 'id' => $orders_products['products_id'], 'name' => $orders_products['products_name'], 'model' => $orders_products['products_model'], 'tax' => $orders_products['products_tax'], 'price' => $orders_products['products_price'], 'cost' => $orders_products['products_cost'], 'final_price' => $orders_products['final_price']); Find: $this->products[$index] = array('qty' => $products[$i]['quantity'], 'name' => $products[$i]['name'], 'model' => $products[$i]['model'], 'tax' => tep_get_tax_rate($products[$i]['tax_class_id'], $tax_address['entry_country_id'], $tax_address['entry_zone_id']), 'tax_description' => tep_get_tax_description($products[$i]['tax_class_id'], $tax_address['entry_country_id'], $tax_address['entry_zone_id']), 'price' => $products[$i]['price'], 'final_price' => $products[$i]['price'] + $cart->attributes_price($products[$i]['id']), 'weight' => $products[$i]['weight'], 'id' => $products[$i]['id']); Replace With: $this->products[$index] = array('qty' => $products[$i]['quantity'], 'name' => $products[$i]['name'], 'model' => $products[$i]['model'], 'tax' => tep_get_tax_rate($products[$i]['tax_class_id'], $tax_address['entry_country_id'], $tax_address['entry_zone_id']), 'tax_description' => tep_get_tax_description($products[$i]['tax_class_id'], $tax_address['entry_country_id'], $tax_address['entry_zone_id']), 'price' => $products[$i]['price'], 'cost' => $products[$i]['cost'], 'final_price' => $products[$i]['price'] + $cart->attributes_price($products[$i]['id']), 'weight' => $products[$i]['weight'], 'id' => $products[$i]['id']); Save and close. Now open: /catalog/includes/classes/shopping_cart.php Find: // products price $product_query = tep_db_query("select products_id, products_price, products_tax_class_id, products_weight from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'"); if ($product = tep_db_fetch_array($product_query)) { $prid = $product['products_id']; $products_tax = tep_get_tax_rate($product['products_tax_class_id']); $products_price = $product['products_price']; $products_weight = $product['products_weight']; Replace With: // products price $product_query = tep_db_query("select products_id, products_price, products_tax_class_id, products_weight from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'"); if ($product = tep_db_fetch_array($product_query)) { $prid = $product['products_id']; $products_tax = tep_get_tax_rate($product['products_tax_class_id']); $products_price = $product['products_price']; $products_cost = $product['products_cost']; $products_weight = $product['products_weight']; Find: while (list($products_id, ) = each($this->contents)) { $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_tax_class_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$products_id . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); Replace With: while (list($products_id, ) = each($this->contents)) { $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_model, p.products_image, p.products_price, p.products_cost, p.products_weight, p.products_tax_class_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$products_id . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); Find: $products_array[] = array('id' => $products_id, 'name' => $products['products_name'], 'model' => $products['products_model'], 'image' => $products['products_image'], 'price' => $products_price, 'quantity' => $this->contents[$products_id]['qty'], Replace With: $products_array[] = array('id' => $products_id, 'name' => $products['products_name'], 'model' => $products['products_model'], 'image' => $products['products_image'], 'price' => $products_price, 'cost' => $products['products_cost'], 'quantity' => $this->contents[$products_id]['qty'], Save and close. Now open: /catalog/checkout_process.php Find: $sql_data_array = array('orders_id' => $insert_id, 'products_id' => tep_get_prid($order->products[$i]['id']), 'products_model' => $order->products[$i]['model'], 'products_name' => $order->products[$i]['name'], 'products_price' => $order->products[$i]['price'], 'final_price' => $order->products[$i]['final_price'], 'products_tax' => $order->products[$i]['tax'], 'products_quantity' => $order->products[$i]['qty']); Replace With: $sql_data_array = array('orders_id' => $insert_id, 'products_id' => tep_get_prid($order->products[$i]['id']), 'products_model' => $order->products[$i]['model'], 'products_name' => $order->products[$i]['name'], 'products_price' => $order->products[$i]['price'], 'products_cost' => $order->products[$i]['cost'], 'final_price' => $order->products[$i]['final_price'], 'products_tax' => $order->products[$i]['tax'], 'products_quantity' => $order->products[$i]['qty']); Save and close all files mySQL Instructions: Run mySQL Command by copying the code below: ALTER TABLE `products` ADD `products_cost` DECIMAL( 15, 4 ) DEFAULT '0.0000' NOT NULL AFTER `products_price`; ALTER TABLE `orders_products` ADD `products_cost` DECIMAL( 15, 4 ) DEFAULT '0.0000' NOT NULL AFTER `products_price`; Done!
  24. wlsnoops

    Product cost? Is there an easy way?

    Hello Geoffrey, I didn't alter the file, column_left.php, as the installation instructions never mentioned this file. The extra 'Reports' box was not there prior to my attempt at this installation. For good measure, though, I did take your suggestion and look at the column_left.php file, but didn't see (with my untrained eyes) that seemed out of whack or duplicated. My two table additions to MySQL database went smoothly and I didn't see any glaring mistakes there, either. Obviously, I've been staring at the files too long and have missed something. Thanks for your help, though. ...Will
  25. wlsnoops

    Product cost? Is there an easy way?

    I've installed this add-on and it does give me a margin report. There is one slight problem, though. When I go to the admin section, there are now two separate "Reports" boxes in the left column. The first one has the margin report in it, but the second one does not. How can I remove the second one that does not have the margin report in it? I tried to retrace my steps, but haven't found anything duplicated. I have some screenshots, but I don't know how to post them here. Thanks.
×