Jump to content

darkside

Members
  • Content count

    54
  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    darkside
  • Website
  1. darkside

    Financial reporting contribution

    I searched the contributions high and low but nothing jumped out at me as meeting my needs. Thanks for the link - I'll have a look at the functionality.
  2. The aim of running the shop is to make money, right? Is the work of picking, packing, labeling, posting really worth the money you make after PayPal charges, packing cost and postage? Hopefully! However, I am sure a few people don't know how much they are actually making per order, in terms of clear profit. In my day job, I work in operational Marketing, were I am responsible for the profitability and pricing for a range of products (about 4,000 lines!) for a large corporation. As such I am constantly monitoring products to manage the gross margin. I am tracking this for my business with an Excel sheet - one for product costings and pricing and one for my order day book. I input the total product cost and net payment price (net of any charges such as commision from PayPal) and calculate clear profit and gross margin (before operating costs). OK - so I don't generate enough orders to leave work but equally don't want to make a loss! My idea is to add financial reporting funtionality into my shop, so I can generate on-line reports showing my profitability right in the shop, identifying where the price needs to go up or the cost come down, where I have room to promote slow moving lines and how much cash/turnover I am doing. As I see it, the mod would be quite easy: Product - add in a field for product cost (in db, add product and modify product) Maybe a total cost line could be added - postage costs can either be built in to the product cost or deducted from the net price. Order - add in a field for net price (in db and order admin) Then 'all' that is left to do is drop in some reporting into the order summary line in the admin panel: Cash Margin = Net price - total cost GM (%) = (net price-total cost)/net price Once it gets sophisticated, formatting could be set (say, lines under 40% GM are red; lines under ?5 cash margin are red) to allow quick identifications of troublemakers and similar top limits (over 100% GM are green). These values may be tweakable from the admin panel. Soooo.... Anyone think it's a good idea? Anyone want to help? Timescales wise, I need to get Xmas over, have a good break and then get stuck in!
  3. darkside

    [contribution] Simple Template System (sts)

    Bingo! Just came back to post an quick fix and saw you have posted too, CK! I have the header tags contribution installed. I had to take out <?php // BOF: WebMakers.com Changed: Header Tag Controller v2.5.2 // Replaced by header_tags.php if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) { require(DIR_WS_INCLUDES . 'header_tags.php'); } else { ?> <title><?php echo TITLE; ?></title> <?php } // EOF: WebMakers.com Changed: Header Tag Controller v2.5.2 ?> from the offending pages. Weirdly, that code is on other pages, that work fine. Oh well! It seems to be fixed - I am going to play more then make the move to the live site!
  4. darkside

    [contribution] Simple Template System (sts)

    OK- half way there but need a wee bit of help if at all possible! The development copy is on my backup server (php5), here: http://server.re-create-it.co.uk/dev/gravity-slaves/shop/ The STS skin is mostly there and it seems to match my site BUT a couple (only found two so far) of files just give a totally blank output, with the debug options not showing anything different... Product - nothing! Payment - I added this in the same way as I added another of my boxes - they all work but the payment one! Any idea what to look for when there is a totally blank screen?
  5. darkside

    fast easy checkout

    Wow! Brilliant contribution. I am still wading through the thread and tweaking my checkout process before I add the PWA section. I have a tweak and a question! Tweak: (Aplogies if this was already in the mod and I was being hasty/blind - but couldn't see it!) On my install, the 'progress bar' stil had four steps, and was jumping straight to step two. The link to step one was back to 'checkout_shipping.php' - or stage two again, since stage one has been done away with now. To make the progress bar to match the new process, I changed the toolbar. Find the toolbar code and over-write the following: In 'checkout_shipping.php': <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td width="33%"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td width="50%" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'checkout_bullet.gif'); ?></td> <td width="50%"><?php echo tep_draw_separator('pixel_silver.gif', '100%', '1'); ?></td> </tr> </table></td> <td width="33%"><?php echo tep_draw_separator('pixel_silver.gif', '100%', '1'); ?></td> <td width="33%"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td width="50%"><?php echo tep_draw_separator('pixel_silver.gif', '100%', '1'); ?></td> <td width="50%"><?php echo tep_draw_separator('pixel_silver.gif', '1', '5'); ?></td> </tr> </table></td> </tr> <tr> <td align="center" width="33%" class="checkoutBarCurrent"><?php echo CHECKOUT_BAR_PAYMENT; ?></td> <td align="center" width="33%" class="checkoutBarTo"><?php echo CHECKOUT_BAR_CONFIRMATION; ?></td> <td align="center" width="33%" class="checkoutBarTo"><?php echo CHECKOUT_BAR_FINISHED; ?></td> </tr> </table></td> </tr> In 'checkout_confirmation.php', replace the progress bar with: <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td width="33%"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td width="50%" align="right"><?php echo tep_draw_separator('pixel_silver.gif', '1', '5'); ?></td> <td width="50%"><?php echo tep_draw_separator('pixel_silver.gif', '100%', '1'); ?></td> </tr> </table></td> <td width="33%"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td width="50%"><?php echo tep_draw_separator('pixel_silver.gif', '100%', '1'); ?></td> <td><?php echo tep_image(DIR_WS_IMAGES . 'checkout_bullet.gif'); ?></td> <td width="50%"><?php echo tep_draw_separator('pixel_silver.gif', '100%', '1'); ?></td> </tr> </table></td> <td width="33%"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td width="50%"><?php echo tep_draw_separator('pixel_silver.gif', '100%', '1'); ?></td> <td width="50%"><?php echo tep_draw_separator('pixel_silver.gif', '1', '5'); ?></td> </tr> </table></td> </tr> <tr> <td align="center" width="25%" class="checkoutBarFrom"><?php echo '<a href="' . tep_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL') . '" class="checkoutBarFrom">' . CHECKOUT_BAR_PAYMENT . '</a>'; ?></td> <td align="center" width="25%" class="checkoutBarCurrent"><?php echo CHECKOUT_BAR_CONFIRMATION; ?></td> <td align="center" width="25%" class="checkoutBarTo"><?php echo CHECKOUT_BAR_FINISHED; ?></td> </tr> </table></td> </tr> and in 'checkout_success.php': <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td align="right" class="main"><?php echo tep_image_submit('button_continue.gif', IMAGE_BUTTON_CONTINUE); ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td width="33%"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td width="50%" align="right"><?php echo tep_draw_separator('pixel_silver.gif', '1', '5'); ?></td> <td width="50%"><?php echo tep_draw_separator('pixel_silver.gif', '100%', '1'); ?></td> </tr> </table></td> <td width="33%"><?php echo tep_draw_separator('pixel_silver.gif', '100%', '1'); ?></td> <td width="33%"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td width="50%"><?php echo tep_draw_separator('pixel_silver.gif', '100%', '1'); ?></td> <td width="50%"><?php echo tep_image(DIR_WS_IMAGES . 'checkout_bullet.gif'); ?></td> </tr> </table></td> </tr> <tr> <td align="center" width="33%" class="checkoutBarFrom"><?php echo CHECKOUT_BAR_PAYMENT; ?></td> <td align="center" width="33%" class="checkoutBarFrom"><?php echo CHECKOUT_BAR_CONFIRMATION; ?></td> <td align="center" width="33%" class="checkoutBarCurrent"><?php echo CHECKOUT_BAR_FINISHED; ?></td> </tr> Finally, I modified my include/languages/english.php file to give 3 simple steps: // checkout procedure text define('CHECKOUT_BAR_DELIVERY', 'Delivery'); define('CHECKOUT_BAR_PAYMENT', '1/ Delivery and Payment'); define('CHECKOUT_BAR_CONFIRMATION', '2/ Confirmation'); define('CHECKOUT_BAR_FINISHED', '3/ Finished!'); Don't forget to backup, folks! ;) Question: Can I show the order total as a line before shipping, just to remind the customer what they have in their basket? Here would be an ideal time to also remind them about any free shipping options you have (Spend another 'x' and get free shipping type promt/help notice!). I know the order total won't roll up until they choose the shipping option - but most people can do the sum and like to track what they are spending... Maybe? Hope that helps and TIA!
  6. Woohooo! Think I am done! First found this contrib as a fresh install, which worried me as I have products, customers and orders all stored. The SQL file had me going and I was ready to pick through it line by line - but a quick read of this thread and I am up and running with full UK formatting and all orignial data in tact! Looks great - thanks for all the coding, tutorials and help here! My turn to give a little (well, I did say little!) back! Yup - it can and is easy - when you know what you are looking for. I did it with a table edit from phpMyAdmin - hope you have access to this. Choose 'shop_database' -> 'address_format' -> Browse Edit the relevant field (#2 for me, as I had already applied the country fix above so UK address used Field #2) Input the below string against 'address_format' in the table: $firstname $lastname$cr$streets$cr$city, $state$cr$postcode$cr$country Note : You can add spaces and commas at will. The '$cr' gives your required line return in the formatting. Job's a good 'un! ;)
  7. darkside

    Change default shiping module selection

    Well, by commenting out the following /*if no shipping method has been selected, automatically select the cheapest method. // if the modules status was changed when none were available, to save on implementing // a javascript force-selection method, also automatically select the cheapest shipping // method if more than one module is now enabled if ( !tep_session_is_registered('shipping') || ( tep_session_is_registered('shipping') && ($shipping == false) && (tep_count_shipping_modules() > 1) ) ) $shipping = $shipping_modules->cheapest(); */ nothing is selected and the user cannot proceed until a shipping option is chosen. Just need to add the pop-up or a visual warning that no shipping method has been chosen - and job's a good 'un. Still be nice to pre-select the most common postage option, rather than the cheapest so if anyone has any ideas, would be good to hear!
  8. I have searched high and low with no luck - but am sure this must have been asked/done before! I currently have two 'delivery' options available - table rate and pick up. Since the 'pick up' cost is zero, it gets selected all the time as the best way to ship. However, the majority of people will want delivery. I'd like to save these guys the click (and possible order/billing error). What I would like to do is prevent the 'pick up' being counted in the best way calculation - or ensure that table rate is selected by default. Any clues?!
  9. darkside

    Strange table display in shipping modules

    Thanks for trying to help... The script doing the actual work (the shipping module) is not modified. I have simply 'wrapped' my template round the shop by editting the includes/top.php and includes/bottom.php but this does not impact on any of the functionality within the site. I have replaced the files with direct copies from my other working install (live store that I did for another client) and cannot seem to get this to work either on my local server or my host... :blink:
  10. darkside

    Strange table display in shipping modules

    With what? As stated, I am running the standard script, with no mods. I have already tried replacing the file with the original (same!) file but no joy. The self-same file that shows errors on my site works OK on another site, hosted on the same server. Turning all shipping modules off does fix it, but any one or more cause this output. I was wondering if this could be down to something in the shipping module config - but can't seem to find anything to turn off or over-ride under Modules -> Shipping.
  11. Here is a screen grab from my Checkout Shipping page. There seems to be some spurious output below the methods of shipping. This output is there no matter which method is selected. It only disappears when no shipping method is selected at all! I am using a standard script with no mods other than my template. This is running on another store I have deployed in the usual manner! Any clues?
  12. darkside

    HSBC secure-epayment module

    I think it was a dead heat :blink: Certainlly know how Neo felt in the Matrix - I can look at pages of code and exploded session arrays and understand them implicitly now!
  13. darkside

    HSBC secure-epayment module

    UPDATE! I have finally got orders appearing in the admin panel of the site!!! Wooohooo!! B) It's been a while and I have had to battle with server moves, file installation and undocumented problems along the way in order to get everything working! Thanks to everyone who helped. Even though your help may not have been the directly attributable to my exact problem, the overall troubleshooting, questioning and suuport has got me there in the end - as well as raising my coding ability and e-commerce understanding several notches!!! So, to sum up, things are looking good and I hope this is now running smoothly. Does anyone fancy helping in the compilation of a FAQ for this module? I have not found any detailled low-level documentation and feel something along these lines would be invaluable. If this sounds like a good idea, PM me and I'll start the structure - if only to 'give a bit back' to the forum!
  14. darkside

    HSBC secure-epayment module

    Cheers! By plural of files, I presume you mean store and admin? Store: define('HTTP_SERVER', 'http://www.fivefortykitesports.co.uk'); // eg, http://localhost define('HTTPS_SERVER', 'https://www.fivefortykitesports.co.uk'); // eg, https://localhost define('ENABLE_SSL', true); // secure webserver for checkout procedure? define('HTTP_COOKIE_DOMAIN', 'www.fivefortykitesports.co.uk'); define('HTTPS_COOKIE_DOMAIN', 'www.fivefortykitesports.co.uk'); define('HTTP_COOKIE_PATH', '/shop/'); define('HTTPS_COOKIE_PATH', '/shop/'); define('DIR_WS_HTTP_CATALOG', '/shop/'); define('DIR_WS_HTTPS_CATALOG', '/shop/'); define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/'); define('DIR_FS_CATALOG', '/home/fivefort/shop/'); define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/'); define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/'); // define our database connection define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers define('DB_SERVER_USERNAME', '****'); define('DB_SERVER_PASSWORD', '****'); define('DB_DATABASE', '****); define('USE_PCONNECT', 'false'); // use persistent connections? define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql' And the admin one for good measure define('HTTP_SERVER', 'http://www.fivefortykitesports.co.uk'); // eg, http://localhost define('HTTP_CATALOG_SERVER', 'http://www.fivefortykitesports.co.uk'); define('HTTPS_CATALOG_SERVER', 'https://www.fivefortykitesports.co.uk'); define('ENABLE_SSL_CATALOG', 'true'); // secure webserver for catalog module define('DIR_FS_DOCUMENT_ROOT', '/home/fivefort/public_html/'); // where the pages are located on the server define('DIR_WS_ADMIN', '/shop/admin/'); // absolute path required define('DIR_FS_ADMIN', '/home/fivefort/public_html/shop/admin/'); // absolute pate required define('DIR_WS_CATALOG', '/shop/'); // absolute path required define('DIR_FS_CATALOG', '/home/fivefort/public_html/shop/'); // absolute path required define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/'); define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/'); define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/'); define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/'); // define our database connection define('DB_SERVER', 'localhost'); // eg, localhost define('DB_SERVER_USERNAME', '****'); define('DB_SERVER_PASSWORD', '****'); define('DB_DATABASE', '****'); define('USE_PCONNECT', 'false'); // use persisstent connections? define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql' I think I found one error and am now getting returned to the store with the message The transaction was rejected by FraudShield At least I am logged in and that part seems to be working now!!!
  15. darkside

    HSBC secure-epayment module

    Turning force cookies on causes a 'red' error line to be shown and a cookie is set on the local machine, so those settings seem to be working.... define('HTTP_SERVER', 'http://www.fivefortykitesports.co.uk'); // eg, http://localhost define('HTTPS_SERVER', 'https://www.fivefortykitesports.co.uk'); // eg, https://localhost define('ENABLE_SSL', true); // secure webserver for checkout procedure? define('HTTP_COOKIE_DOMAIN', 'www.fivefortykitesports.co.uk'); define('HTTPS_COOKIE_DOMAIN', 'www.fivefortykitesports.co.uk'); define('HTTP_COOKIE_PATH', '/shop/'); define('HTTPS_COOKIE_PATH', '/shop/');
×