Jump to content
Latest News: (loading..)

franktechniek

Members
  • Content count

    15
  • Joined

  • Last visited

Profile Information

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. franktechniek

    NEW! Complete Order Editing Tool!

    Thanks John, after some time I figured out there was an ommission in my own modfications I made to facilitate intracommute orders (b2b) inside the EU that don't have tax added. I decided to turn off the ajax functions also. They are nice to have, but since the code is too complicated for my own level of understanding, I decided it is better to do without - for now anyway.. Nice when things start to work ;-)
  2. franktechniek

    NEW! Complete Order Editing Tool!

    And now I modified \includes\modules\order_total\ot_tax so that I can enter negative quantities for products without loosing the total for tax completely. I want it to work that way, because occasionally I need to create a credit invoice for customers that return product(s). In function process() it is just a simple change: foreach($order->info['tax_groups'] as $key => $value) { // if ($value > 0) { if ($value != 0) { // also allow negative tax for negative quantities of products that are returned and have to be credited on the (credit) invoice $this->output[] = array('title' => $key . ':', 'text' => $currencies->format($value, true, $order->info['currency'], $order->info['currency_value']), 'value' => $value); } Next step is to figure out why the order editor looses the tax that is part of the shipping cost. A new order that is placed has the correct total for tax, for products and shipping combined, but as soon as I hit update even without changing any fields, the total tax is changed to products only. Once the order editor behaves correctly, I guess I would like a button to create a blank order for a particular customer and then fill/modify it as desired. That should not be too difficult. But that shipping tax......
  3. franktechniek

    NEW! Complete Order Editing Tool!

    Hmm, forget that, I was messing with the wrong file.. Sorry folks ;-)
  4. franktechniek

    NEW! Complete Order Editing Tool!

    Well, the shop runs fine, all orders have everything in the right place, with correct taxes. As soon as I use the order editor, things go wrong. The shipping quotes that I see on the left, the top one (coming from table rate) has no tax, and the second one (coning from flat rate) has 21% tax (high level tax). Both shipping methods are configured for 21% tax. That's why I added the echo lines to check if the right country data was applied, and to check what percentage was set in the quotes. It goes wrong at fetching the quotes. Table rate give 0%. Even when I hard coded the qoute method to return a fixed number, 22 to distinguish from the configured 21, it still shows 0% for table rate, but 22 for flat rate. Have to check that again, still can't believe it.. so weird.
  5. franktechniek

    NEW! Complete Order Editing Tool!

    Tax problems with the shipping cost in the order editor 1.2.5 - my findings sofar. In admin\edit_orders.php, I added 4 echoes at the bottom of this: // Edit Order case 'edit': if (!isset($_GET['oID'])) { $messageStack->add(ERROR_NO_ORDER_SELECTED, 'error'); break; } $oID = tep_db_prepare_input($_GET['oID']); $orders_query = tep_db_query("select orders_id from orders where orders_id = '" . (int)$oID . "'"); $order_exists = true; if (!tep_db_num_rows($orders_query)) { $order_exists = false; $messageStack->add(sprintf(ERROR_ORDER_DOES_NOT_EXIST, $oID), 'error'); break; } $order = new manualOrder($oID); $shippingKey = $order->adjust_totals($oID); $order->adjust_zones(); $cart = new manualCart(); $cart->restore_contents($oID); $total_count = $cart->count_contents(); $total_weight = $cart->show_weight(); // Get the shipping quotes $shipping_modules = new shipping; $shipping_quotes = $shipping_modules->quote(); echo $order->delivery['country']['id'] . ' country id<br>'; echo $order->delivery['zone_id'] . ' zone id<br>'; echo $shipping_quotes[0]['tax'] . ' %tax ' . $shipping_quotes[0]['module'] . ' first quote<br>'; echo $shipping_quotes[1]['tax'] . ' %tax ' . $shipping_quotes[0]['module'] . ' second quote<br>'; break; That tells me that the first shipping quote (table shipping) on the left, in the order editor use 0% tax (should be 21). The second quote (flat rate) is fine, 21% indeed. if I hard code 22 in both shipping cost modules, the first quote stubbornly shows 0, the second quote 22. That is weird. I don't understand that at all. Any ideas?
  6. Recently I installed a new shop and also installed order editor v1.2.5 which works but has some problems. Tried to find out but this code is too complicated for me, and I have not enough knowledge to figure out what is causing my problem. When I change the number of items, the total is updated ok, but the total of the tax only reflects the tax that is applied to the products, but not the tax that is part of the shipping costs. My shipping costs usually are 6.95 euro, which is caclulated from 5.74 euro + 21% tax (1.21 euro). If I place an order with a product of 121 euro (100 euro + 21 euro tax) and 6.95 euro shipping cost (with 1.21 euro tax in it) my order looks just fine, with a total tax displayed of 101.21 euro. If I edit my order, change the number or add another product, the shipping cost stay ay 6.95 but the total tax only shows the tax that is applied for the product. Another issue is that when setting the amount of products to -1 (when creating an invoice for a returned product) the tax total disappears completely. So, what I need, is that tax that is part of the shipping costs is included in the tax total, and also that tax is always calculated even when products have a negative price. Any ideas where to look are highly appreciated. As a workaround I now manually edit the order_total table, but that is quite tricky and time consuming... Best regards, Frank
  7. franktechniek

    Shop not working after moving from subdomain

    Thank you Henry, above settings match mine, but for some reason I had to use this to make it work: define('HTTP_COOKIE_DOMAIN', $_SERVER["SERVER_NAME"]); define('HTTPS_COOKIE_DOMAIN', $_SERVER["SERVER_NAME"]); Cheers, Frank
  8. franktechniek

    Shop not working after moving from subdomain

    Hey, this is interesting. My definitions using the $_SERVER["SERVER_NAME"] reference, all work fine. I even used that in my current/old shop, no problems. But your advice to look into the old configure.php did bring the solution. Old configure.php: define('HTTP_COOKIE_DOMAIN', $_SERVER["SERVER_NAME"]); define('HTTPS_COOKIE_DOMAIN', $_SERVER["SERVER_NAME"]); The new configure.php had this: define('HTTP_COOKIE_DOMAIN', ''); define('HTTPS_COOKIE_DOMAIN', ''); So I copied those COOKIE_DOMAIN entries from the old configure.php, and all of sudden it works! Not that I understand why - this is totally beyond me. Thank you so much Raiwa! Cheers, Frank
  9. franktechniek

    Shop not working after moving from subdomain

    I think so, about the configure.php anyway. I tried to replace the current .htaccess with the new one, which was never touched, but also makes no difference. It is really weird ;-) <?php define('HTTP_SERVER', 'https://' . $_SERVER["SERVER_NAME"]); // eg, http://localhost - should not be empty for productive servers define('HTTPS_SERVER', 'https://' . $_SERVER["SERVER_NAME"]); // eg, https://localhost - should not be empty for productive servers // define('HTTP_SERVER', 'http://osc234.videofrank.nl'); // define('HTTPS_SERVER', 'http://osc234.videofrank.nl'); define('ENABLE_SSL', true); define('HTTP_COOKIE_DOMAIN', ''); define('HTTPS_COOKIE_DOMAIN', ''); define('HTTP_COOKIE_PATH', '/'); define('HTTPS_COOKIE_PATH', '/'); define('DIR_WS_HTTP_CATALOG', '/'); define('DIR_WS_HTTPS_CATALOG', '/'); // define('DIR_FS_CATALOG', '/var/www/vhosts/videofrank.nl/osc234.videofrank.nl/'); define('DIR_FS_CATALOG', $_SERVER["DOCUMENT_ROOT"] . '/'); define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/'); define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/'); define('DB_SERVER', 'localhost:xxxxxxxxxxxxxxxxxxx'); define('DB_SERVER_USERNAME', '**********************'); define('DB_SERVER_PASSWORD', '**********************'); define('DB_DATABASE', 'xxxxxxxxxxxxxxxxxx'); define('USE_PCONNECT', 'false'); define('STORE_SESSIONS', 'mysql'); define('CFG_TIME_ZONE', 'Europe/Amsterdam'); ?> And .htaccess #<IfModule mod_setenvif.c> # <IfDefine SSL> # SetEnvIf User-Agent ".*MSIE.*" \ # nokeepalive ssl-unclean-shutdown \ # downgrade-1.0 force-response-1.0 # </IfDefine> #</IfModule> # If Search Engine Friendly URLs do not work, try enabling the # following Apache configuration parameter # AcceptPathInfo On # Fix certain PHP values # (commented out by default to prevent errors occuring on certain # servers) # php_value session.use_trans_sid 0 # php_value register_globals 1 <IfModule mod_headers.c> Header unset ETag </IfModule> FileETag None ## EXPIRES CACHING ## ## https://gtmetrix.com/leverage-browser-caching.html ## <IfModule mod_expires.c> ExpiresActive On ExpiresByType image/jpg "access plus 1 year" ExpiresByType image/jpeg "access plus 1 year" ExpiresByType image/gif "access plus 1 year" ExpiresByType image/png "access plus 1 year" ExpiresByType text/css "access plus 1 month" ExpiresByType application/pdf "access plus 1 month" ExpiresByType text/x-javascript "access plus 1 month" ExpiresByType application/x-shockwave-flash "access plus 1 month" ExpiresByType image/x-icon "access plus 1 year" ExpiresByType application/javascript "access plus 1 year" ExpiresDefault "access plus 2 days" </IfModule> ## EXPIRES CACHING ## <IfModule mod_rewrite.c> Options +FollowSymLinks RewriteEngine on RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteRule .* index.php [L] </IfModule>
  10. franktechniek

    Shop not working after moving from subdomain

    Thank you , but alas, that also makes no difference...
  11. franktechniek

    Shop not working after moving from subdomain

    Thank you, but that is not the problem here. I use a new database. And everything works when my new shop sits in the subdomain I used for testing it. Once I move the new files to my website root, the login.php is not able to handle a login. Best regards, Frank
  12. Probably hard to answer this one - but any ideas where to look are welcome. I created a new shop, a 2.3.4 BS one, placed it in a subdomain and it works like a charm. About time to put it live, so I did and nothing worked of course. After some fiddling, things started to work, the only problem was that I could not log in as a customer. Put the old shop back, and started to scratch my head. My nest step was to rename the \includes (to \includers) folder in my old shop, and also the references to it in configure.php so that everything kept working. That allowed me to copy the \include directory from my new shop without breaking the old shop. Did a similar trick with the admin directory, and that also works like a charm. Then I copied a single page from the new shop to the old, and that also works also: https://www.videofrank.nl/holidays.php Next was to rename the old login.php to login2.php and reference to make sure my old shop keeps working. Upload the new login.php file which gave an error 'Can not redeclare class cm_login_form'. I could not find any reason why this happens, and fixed it (if you call that a fix hmm) by adding a condition for the class declaration (around line 13 in cm_login_form.php) like follows: if(('cm_login_form') === false or !class_exists('cm_login_form')) { class cm_login_form { var $code; var $group; ................ } That at least made the login page display itself: http://www.videofrank.nl/login.php But the problem is, I can not log in. It does not generate an error when I use a wrong password or non existing email address, neither does it redirect me to index.php when using a correct user email and password. What would your next step be to investigate? Thank you for your time, Frank
  13. Found one little thing: Edge newer than 10th September 2016 (hardcoded paths) Point 4, ...still contains some references to DIR_WS_IMAGES, which causes products with only one main image to display the 'no image available' image. But that was fixed easily. Cheers, Frank
  14. Wow, thank you very much indeed! You really made me very happy! I just installed it, only 15 minutes of work. The changes in product_info.php were very well documented, my compliments for all your good work there! http://osc234.videofrank.nl/product_info.php?cPath=190_204&products_id=2645 How nice is that :-) Very nice!! Thanks a lot!!
  15. I am trying to move from MS2.2 to v2.3.4.1 BS and now I am stuck with the multiple images. I have many products with multiple images, and was happy to see this colorbox thing already build in! My test installation is quite clean, no templates installed. I wrote a script to copy my products to the new database, and also copied all my images. In my old shop I have a multiple image system that uses extra image files with names like product_id-number.jp and my migration script finds all these additional images and puts them into the products_images table. And it works. But the thumbnails below the main image look funny, flattened in height. When enlarged, they look fine. You can see the problem here: http://osc234.videofrank.nl/product_info.php?cPath=190_204&products_id=2632 The crazy thing is, when I add a product manually, it works just fine, and the thumbnails look perfect: http://osc234.videofrank.nl/product_info.php?cPath=190_204&products_id=2940 Quite puzzled, I compared as much as I could but see no difference in the database entries etc. Any clues where to look? Thanks in advance, Frank
×