Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

assembler

Archived
  • Posts

    50
  • Joined

  • Last visited

Everything posted by assembler

  1. I am receiving the following error. Is there anyway for me to avoid it? Thanks. Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 293 bytes) in www/catalog/googlesitemap/sitemap.class.php on line 408
  2. You would have to link the query to the products table. Currently, the products table is not part of the query. Would have to check if the product sold still exists in the products table, and then pull the picture info. This could be a problem if you have changed a product into a new product_id, and reused a product_id.
  3. I just released a new version of xsell cart. It is much faster, and looks a bit cleaner. I removed the manufacturer information from being displayed. http://www.oscommerce.com/community/contributions,1808
  4. You make the changes to catalog/admin/orders.php
  5. Do you mean it is not removing them from the xsell in the shopping cart, or the xsell on the products page. Currently, it does not remove products from the list on the product_info page.
  6. This function could easily be added to this contribution. However, due to the db intensiveness of the queries, I decided that the information was not needed.
  7. Why do you need the page numbering to be correct? Wouldn't this depend on which invoices you filtered out anyway?
  8. I altered this contribution to auto update order status, and eliminated the use of frames. It uses CSS page breaks instead. http://www.oscommerce.com/community/contributions,3155
  9. This contribution allows you to batch print the orders on the orders.php screen. You can filter based on order status, and can then select/deselect orders for printing. Can batch update order status as well. Instead of using frames or a PDF, this contrib produces 1 invoice per page by using CSS page breaks. Can easily be adapted to your custom invoice layout. Batch Printing with Frames or PDF
  10. Adds a small line to your header that displays the number of items in the shopping cart, and the current subtotal. Clicking on the number of items or the subtotal brings you directly to the shopping cart. This allows you to remove the shopping cart box from column_right.php, while still allowing your customers to have access to the basic information on every page. Very easy to install. Backup first. Cart Information in Header
  11. First suggestion: Seems like you figured this one out: Change: $start_date = date('Y-m-d'); To: $start_date = date('Y-m-01'); Second: I removed the product_id from the SQL statement when I made the last batch of changes, and forgot that I was linking to the products. To fix the linking error, change the SQL query to: $products_query_raw = "select op.products_id, op.products_model, op.products_name, sum(op.products_quantity) as quantitysum FROM " . TABLE_ORDERS . " as o, " . TABLE_ORDERS_PRODUCTS . " AS op WHERE o.date_purchased BETWEEN '" . $start_date . "' AND '" . $end_date . " 23:59:59' AND o.orders_id = op.orders_id GROUP BY op.products_id ORDER BY quantitysum DESC, op.products_model"; Third Suggestion (Alternated Shaded Lines): Find: if(strlen($rows) < 2) { $rows = '0' . $rows; } ?> Add Directly After: <tr bgcolor="<?php echo ((++$cnt)%2==0) ? '#e0e0e0' : '#ffffff' ?>"> I do not really see the need for the calander pull down, but I may work on it if I have some time. I am uploading the updated file to the contrib page. http://www.oscommerce.com/community/contributions,2568
  12. What version does this? I installed the header tags contrib a while back, and it does not put keywords in the URL.
  13. Has anyone created a contribution that puts the products name in the URL? This would improve my search engine rankings. I've looked around for this, but haven't found it.
×
×
  • Create New...