Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

sonictrip.net

Members
  • Posts

    216
  • Joined

  • Last visited

About sonictrip.net

  • Birthday 01/01/1979

Profile Information

sonictrip.net's Achievements

  1. Yes there is! Pdesigner.net have a custom t-shirt design module for osCommece which was being sold for $199 and now its free!!! www.pdesigner.net/en/custom-t-shirt-for-oscommerce I've been trying to install this myself on an older oscommerce site and im having problems, also the author didnt release the files as a mod so you will have to use code compare software to compare his files and copy across his code to your shop if its been modified already. Not a bad t-shirt module though, its obviously not as flashy as the Spreadshirt one (i was quoted $1800 for a similar flash based t-shirt designer) and you can't do as much with this one but its perfect for 1 logo, 4 lines of text and front and back design. Does the job and its free! Can't find a demo of it anywhere but here's the dev site im working on which still has some issues to resolve like support of GIF and PNG images and making the final designed t-shirt appear back on the product page when you click "Done": www.sonictrip.net/customtshirt/product_info.php?products_id=1183
  2. Hi all, I've had this mod installed for a while and everything had been working fine until we began noticing that when trying to view or edit customers in the admin who have been addeed since the mod was installed we get errors trying to access these particular customers... customers that existed before the mod was added are still accessible with no errors. I've tracked the problem down to the cusotmers_info table on the DB under the field customers_info_stores_id All new customers that have been added since the mod was installed have customers_info_stores_id of between "1" and "10", these are the customers which show an error. Customers with customers_info_stores_id of "NULL" are working fine and show all details when viewing their customer details in the admin. I've found a fix for the error on another thread which is to do with an array problem in object_info.php on line 17 and 18 and the fix is: This fix didnt work for me to get the details displaying again probably because the fix has nothing to do with this mod or the customers_info_stores_id table. A fix in object_info.php which involves the following code change: Add: if (!is_array($object_array)) return; Directly Under: function objectInfo($object_array) { This code suppresses the following error in admin when trying to view a customer: Warning: reset() [function.reset]: Passed variable is not an array or object in /catalog/admin/includes/classes/object_info.php on line 17 Warning: Variable passed to each() is not an array or object in /catalog/admin/includes/classes/object_info.php on line 18 However, it doesnt solve the problem of letting you view the customers details. The customers details still end up being blank but it just doesnt show an error anymore now. So, how would i add customers_info_stores_id to the query in admin/customers.php in order to solve this problem of not being able to view customers details in the admin? or does anyone have any other ideas? We have our customers tables split up into separate tables for each store but left the customers_info table the same for all stores which could be a problem. I wonder would splitting this table up be the answer? Thanks for any help!
  3. Yes, the new SEO URLS v5 by FWR media will work the best with your setup, it now supports Windows servers too.
  4. Im also looking for something like this, seems like not nobody has developed a proper solution for this yet, maybe they could get ideas from other scripts like Affiliate Niche Script which is great for automatically managing an Amazon or eBay affiliate store...
  5. Hi, If i want to have an XML feed of products coming from one of our suppliers which will be automatically shown on our site with their prices etc. and buy now buttons linking to their shopping cart, is this the mod im looking for? Or does this mod just output an XML feed of my own stores products for others to use? We have a catalog of products already on our site but we'd like to also offer one of our suppliers product catalog on our site through an XML feed which will hopefully automatically add all of their products to our site. Thanks.
  6. Jeez, is this still not possible? This would be a really handy feature...
  7. Has anyone managed to use Flash to display the product listing, product info page and checkout pages? Kinda like this site: http://www.wastenotrecycledart.com/ click the store button I'd love to use Flash to completely display the oscommerce catalog, is this possible and has anyone done it?
  8. Another way to fix the register globals issue is to create a blank notepad file called php.ini and upload it to the root folder (/catalog/), put this code in the file: register_globals = 1;
  9. nice, i was looking for that one, thanks hostxxi! Another little error popping up on mine: Notice: Constant 95 already defined in d:\domains\catalog\includes\functions\html_output.php on line 767 Line 767 of html_output.php is: define(JPEGQUALITY, 95); Weird... But like someone else pointed out, you can disable all Flash Carousel error messages by commenting out this line in includes/classes/flash_carousel_image_resize.php: // error_reporting(E_ALL);
  10. I found the solution to this for anyone that needs it, edit the file catalog/includes/modules/payment/paypal_ipn.php: Find this line around line 203: 'orders_status' => $order->info['order_status'], And add this on the line after: 'orders_stores_id' => STORES_ID, //rmh M-S_multi-stores That should do it! You'll now see your PayPal enabled Multi Store orders coming up with the correct store name in the order list :)
  11. On another note, im having a problem getting the PayPal IPN module to work properly with the 6th copy of my multi store site, the others use CC processing which works fine, just that the Orders list is saying that the order came in from the 1st store name instead of the 6th Gizmo Shop name in the order details. Anyone got any ideas? It concerns the STORES_ID number being set to STORES_ID = '1' instead of STORES_ID = '6' when PayPal completes the payment. My return page from PayPal is set to go to checkout_success.php but thats causing an error, what file should i be looking in to change the STORE_ID? Thank you!
  12. My clients main multi store site is a newspaper Reader Offer site called: www.markettown.ie He also has 4 other newspaper reader offer sites which sell the same products but i probably shouldn't say their names here. I recently made a version of his site too and called it www.thegizmoshop.net which is the 6th version of his site now and is aimed at a younger market rather than (much) older newspaper readers, lol, i still need to disable some of his products from my version. So check out my version for all your gadgets and gizmos and i'll get a small percentage of the sale! :) He's considering selling copies of his site to the public to run and market yourselves while he adds any new products to all the sites himself and posts the products out to customers too. So all you'd need to do is market the products yourself and get people to buy off your version of the site, PM me if anyone is interested in this! Could be a good way to make a few quid and learn more about the multi store mod and i can give whoever wants it a copy of the admin folder too. So PM me if anyone is interested in this :)
  13. It's one of the hardest and most time consuming mods to add to an existing few stores. I recently did it for a client who has 5 seperate osCommerce stores and it took 2 weeks just to modify his existing files and template files etc. to work with it and another 2 weeks of testing just to iron out all the bugs from his company specific requirements for the way he wanted it to work which included keeping the customers tables seperate, having reports added for each stores sales per month and a few other standard mods. What an ordeal, i completely undercharged him by atleast 50% ! But atleast next time i'll be able to do it quicker... It's definitely worth it in the end though and worth the try if you're installing on a new store or an unmodified store which would take way less time...! www.thegizmoshop.net is my version of his store if you're interested to see what's possible with the Multi Store mod :) If anyone is looking for it installed and configured etc. PM me!
  14. If you've tried everything trying to get popup images to work with STS then maybe this is the one little thing left to try. It seems to have kinda half worked for me. Go into Configuration/My Store in the admin and change "Use Search-Engine Safe URLs" to False. Mine was set to true and was interfering with the links generated for the popup images :)
  15. Halelujah! I managed to get the Reports mod working with the Multi Store mod and amazingly, there were only a few small changes... although its not perfect but it works when you just click one of the checkboxes... The Reports mod i used is called "stats_products_purchased-2f" which comes with 2 files, the file that goes in the multistore/admin folder is called stats_products_purchased.php and uses the following code, be sure to replace STORE1NAME, STORE2NAME, STORE3NAME etc. with the names of the stores you're using and also change the STORE_ID for each SQL query which looks like this: AND orders_stores_id = '1' !: <?php /* $Id: stats_products_purchased.php,v 1.29 2003/06/29 22:50:52 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'); if (isset($HTTP_GET_VARS['start_date'])) { $start_date = $HTTP_GET_VARS['start_date']; } else { $start_date = date('Y-m-01'); } if (isset($HTTP_GET_VARS['end_date'])) { $end_date = $HTTP_GET_VARS['end_date']; } else { $end_date = date('Y-m-d'); } if(isset($_GET['keywords']) && $_GET['keywords'] != ''){ $keywords = trim($_GET['keywords']); } ?> <!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> <link rel="stylesheet" type="text/css" href="includes/stylesheet.css"> <script language="javascript" src="includes/general.js"></script> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF"> <!-- header //--> <?php if ($printable != 'on') { require(DIR_WS_INCLUDES . 'header.php'); }; ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="2" cellpadding="2"> <tr> <?php if ($printable != 'on') {;?> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </table> <?php }; ?> </td> <!-- body_text //--> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <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_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> </tr> </table></td> </tr> <tr><td> <?php echo tep_draw_form('date_range','stats_products_purchased.php' , '', 'get'); ?> <table> <tr><td class="main"> <?php echo ENTRY_STARTDATE . tep_draw_input_field('start_date', $start_date); echo ' '.ENTRY_TODATE . tep_draw_input_field('end_date', $end_date). ' '; echo ' </tr><tr><td class="main"> '; echo ENTRY_KEYWORDS. tep_draw_input_field('keywords', $keywords). ' '; echo ENTRY_PRINTABLE . tep_draw_checkbox_field('printable', $print). ' '; echo ENTRY_SORTGROSS . tep_draw_checkbox_field('gross', $gross). ' '; echo ENTRY_STORE1NAME . tep_draw_checkbox_field('store1name', $store1name). ' '; echo ENTRY_STORE2NAME . tep_draw_checkbox_field('store2name', $store2name). ' '; echo ENTRY_STORE3NAME . tep_draw_checkbox_field('store3name', $store3name). ' '; echo ENTRY_STORE4NAME . tep_draw_checkbox_field('store4name', $store4name). ' '; echo ENTRY_STORE5NAME . tep_draw_checkbox_field('store5name', $store5name). ' '; echo '<input type="submit" value="'. ENTRY_SUBMIT .'">'; echo '</td>'; $totalgross = 0; ?> </td></tr> </table></form></td></tr> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_NUMBER; ?></td> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_MODEL; ?></td> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS; ?></td> <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_PURCHASED; ?> </td> <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_GROSS; ?> </td> </tr> <?php if ($store1name=='on') { $products_query_raw = "select op.products_id, op.products_model, op.products_name, sum(op.products_quantity) as quantitysum , sum(op.products_price*op.products_quantity)as gross 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 ".(isset($keywords) ? " AND orders_stores_id = '1' AND (op.products_name LIKE '%".$keywords."%' OR op.products_model LIKE '%".$keywords."%') " : '')."GROUP BY op.products_id ORDER BY gross DESC,quantitysum DESC, op.products_model"; } elseif ($store2name=='on') { $products_query_raw = "select op.products_id, op.products_model, op.products_name, sum(op.products_quantity) as quantitysum , sum(op.products_price*op.products_quantity)as gross 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 ".(isset($keywords) ? " AND orders_stores_id = '2' AND (op.products_name LIKE '%".$keywords."%' OR op.products_model LIKE '%".$keywords."%') " : '')."GROUP BY op.products_id ORDER BY gross DESC,quantitysum DESC, op.products_model"; } elseif ($store3name=='on') { $products_query_raw = "select op.products_id, op.products_model, op.products_name, sum(op.products_quantity) as quantitysum , sum(op.products_price*op.products_quantity)as gross 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 ".(isset($keywords) ? " AND orders_stores_id = '3' AND (op.products_name LIKE '%".$keywords."%' OR op.products_model LIKE '%".$keywords."%') " : '')."GROUP BY op.products_id ORDER BY gross DESC,quantitysum DESC, op.products_model"; } elseif ($store4name=='on') { $products_query_raw = "select op.products_id, op.products_model, op.products_name, sum(op.products_quantity) as quantitysum , sum(op.products_price*op.products_quantity)as gross 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 ".(isset($keywords) ? " AND orders_stores_id = '4' AND (op.products_name LIKE '%".$keywords."%' OR op.products_model LIKE '%".$keywords."%') " : '')."GROUP BY op.products_id ORDER BY gross DESC,quantitysum DESC, op.products_model"; } elseif ($store5name=='on') { $products_query_raw = "select op.products_id, op.products_model, op.products_name, sum(op.products_quantity) as quantitysum , sum(op.products_price*op.products_quantity)as gross 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 ".(isset($keywords) ? " AND orders_stores_id = '5' AND (op.products_name LIKE '%".$keywords."%' OR op.products_model LIKE '%".$keywords."%') " : '')."GROUP BY op.products_id ORDER BY gross DESC,quantitysum DESC, op.products_model"; } elseif ($gross =='on') { $products_query_raw = "select op.products_id, op.products_model, op.products_name, sum(op.products_quantity) as quantitysum , sum(op.products_price*op.products_quantity)as gross 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 ".(isset($keywords) ? " AND (op.products_name LIKE '%".$keywords."%' OR op.products_model LIKE '%".$keywords."%') " : '')."GROUP BY op.products_id ORDER BY gross DESC,quantitysum DESC, op.products_model"; } else { $products_query_raw = "select op.products_id, op.products_model, op.products_name, sum(op.products_quantity) as quantitysum , sum(op.products_price*op.products_quantity)as gross 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 ".(isset($keywords) ? "AND (op.products_name LIKE '%".$keywords."%' OR op.products_model LIKE '%".$keywords."%') " : '')."GROUP BY op.products_id ORDER BY quantitysum DESC, op.products_model"; } $rows = 0; $products_query = tep_db_query($products_query_raw); while ($products = tep_db_fetch_array($products_query)) { $rows ++; $totalgross = $totalgross + $products['gross']; if(strlen($rows) < 2) { $rows = '0' . $rows; } ?> <tr bgcolor="<?php echo ((++$cnt)%2==0) ? '#e0e0e0' : '#ffffff' ?>"> <td class="dataTableContent"><?php echo $rows ; ?>.</td> <td class="dataTableContent"><?php echo $products['products_model']; ?> <td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_CATEGORIES, 'action=new_product_preview&read=only&pID=' . $products['products_id'] . '&origin=' . FILENAME_STATS_PRODUCTS_PURCHASED . '?page=' . $HTTP_GET_VARS['page'], 'NONSSL') . '">' . $products['products_name'] . '</a>'; ?></td> <td class="dataTableContent" align="center"><?php echo $products['quantitysum']; ?> </td> <td class="dataTableContent" align="right"><?php echo sprintf("%01.2f", $products['gross']); ?> </td> </tr> <?php } ?> <tr><td></td><td></td><td class="dataTableContent" align="right"><b><?php echo(ENTRY_TOTAL) ?>:</b></td><td></td><td class="dataTableContent" align="right"><b><?php echo sprintf("%01.2f", $totalgross); ?></b></td></tr> </table></td> </tr> <tr> <td colspan="3"><table border="0" width="100%" cellspacing="0" cellpadding="2"> </table></td> </tr> </table></td> </tr> </table></td> <!-- body_text_eof //--> </tr> </table> <!-- body_eof //--> <!-- footer //--> <?php if ($printable != 'on') { require(DIR_WS_INCLUDES . 'footer.php'); } ?> <!-- footer_eof //--> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> And the other file which goes in multistore/admin/includes/languages/english is called stats_products_purchased.php: <?php /* $Id: stats_products_purchased.php,v 1.5 2002/03/30 15:52:31 harley_vb Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2002 osCommerce Released under the GNU General Public License */ define('HEADING_TITLE', 'Products Purchased'); define('TABLE_HEADING_MODEL', 'Model'); define('TABLE_HEADING_NUMBER', 'No.'); define('TABLE_HEADING_PRODUCTS', 'Products'); define('TABLE_HEADING_PURCHASED', 'Purchased'); define('TABLE_HEADING_GROSS', 'Gross'); define('ENTRY_STARTDATE', 'Start Date:'); define('ENTRY_TODATE', 'End Date:'); define('ENTRY_PRINTABLE', 'Printable:'); define('ENTRY_SORTGROSS', 'Sort on Gross'); define('ENTRY_TOTAL', 'Total'); define('ENTRY_SUBMIT', 'Submit'); define('ENTRY_KEYWORDS','Keywords: '); define('ENTRY_STORE1NAME','Store 1: '); define('ENTRY_STORE1NAME','Store 2: '); define('ENTRY_STORE3NAME','Store 3: '); define('ENTRY_STORE4NAME','Store 4: '); define('ENTRY_STORE5NAME','Store 5: '); ?> I hope to get this organised for a contribution very soon and will post it to the multi store mod page and maybe the stats_products_purchased mod page too :) Thanks to Ryan Hobbs again for the biggest and most excellent mod available for osCommerce! :)
×
×
  • Create New...