rpdesign Posted November 10, 2013 Author Share Posted November 10, 2013 Ok i'm sorry everyone, found out that i uploaded the v2.3.3 file for the separate_rate.php in the v2.2 folder! So let me work on this for the evening Quote Always backup your files! You will be glad you didMy add-ons :SSPP Seperate Shipping Per Product v2.5| SupportGift vouchers for SPPC 4.22 v2.1 | Support |Catalog Infobox v1.0 | Sorry no support for Catalog Infobox |HTML Mail v2.0 | Support |Upcoming Add ons:Addon Manager | Separate Pricing Per Product Qty |Coupon Populate | EZ-PDF Catalog Link to comment Share on other sites More sharing options...
rpdesign Posted November 10, 2013 Author Share Posted November 10, 2013 @@stragami Ok i think i know what is happening is that i uploaded the wrong ver of my separate_rate.php file in to the v2.2 folder installation! oops So without futher ado i'll correct it and have a new ver up by tomorow! Quote Always backup your files! You will be glad you didMy add-ons :SSPP Seperate Shipping Per Product v2.5| SupportGift vouchers for SPPC 4.22 v2.1 | Support |Catalog Infobox v1.0 | Sorry no support for Catalog Infobox |HTML Mail v2.0 | Support |Upcoming Add ons:Addon Manager | Separate Pricing Per Product Qty |Coupon Populate | EZ-PDF Catalog Link to comment Share on other sites More sharing options...
rpdesign Posted November 10, 2013 Author Share Posted November 10, 2013 (edited) URGENT UPDATE FOR USERS OF OSCOMM V2.2 RC2 ONLY!!! Please upload this separate_rate.php file to your catalog/admin folder. This is v1.5 of the file separate_rate.php for oscommmerce 2.2 and can be used with v 1.7 except you will loose the Table per individual item feature for the table rates. Until I add these features and fix ver 1.7 of this file which will be downloaded as v1.71 to fix this bug please download the uploaded file here: you need to replace your file with this one in your catalog/admin folder Edited November 10, 2013 by rpetet Quote Always backup your files! You will be glad you didMy add-ons :SSPP Seperate Shipping Per Product v2.5| SupportGift vouchers for SPPC 4.22 v2.1 | Support |Catalog Infobox v1.0 | Sorry no support for Catalog Infobox |HTML Mail v2.0 | Support |Upcoming Add ons:Addon Manager | Separate Pricing Per Product Qty |Coupon Populate | EZ-PDF Catalog Link to comment Share on other sites More sharing options...
stragami Posted November 10, 2013 Share Posted November 10, 2013 Hi Robert, ok update the file. now the screen is avalible but whatever i setup nothing will be displayedin shopping cart need i to downgrade to 1.5? yes looks not so easy to setup a video will help (if you can show sampls how to setup and how to show this in shopping cart / will be perfect if you can show us diffferend setup /flat /item per product rgds alfred Quote Link to comment Share on other sites More sharing options...
stragami Posted November 10, 2013 Share Posted November 10, 2013 short question i use v2.2 with php 5.4 this makes no problems? Quote Link to comment Share on other sites More sharing options...
stragami Posted November 10, 2013 Share Posted November 10, 2013 (edited) my setup looks like this: Seperate Shipping Per Product/Category Seperate Shipping Per Product/Category Enable Seperate Shipping Method True Use Default Rates? Yes Default Table Rate 25:8.50,50:5.50,10000:0.00 Use Default Table Rates? Table per item Default Flat Rate 1 Enable Default Flat Rate? Flat per item Max Shipping Rate 50.00 Setting category Use Default Rates? Yes Shipping Method qty Handling Fee 0 Tax Class 19% MwSt. Shipping Zone DE Sort Order 5 so i m add a flat rate 1 eur / max 50 euro this woks if i order 60 pcs 50 euro shipping is ok now i setup by artikel Flat/Free Shipping Rate: 15.00 Use Standard Flat Shipping? No Use Free Shipping? N for my understandug now if the user buy this prduct 15 (for 1 to x products) euro must be charge rigjht? but in shoppingcart only the mainsetup will be used 1 / pcs max 50 so whats wrong? Edited November 10, 2013 by stragami Quote Link to comment Share on other sites More sharing options...
rpdesign Posted November 14, 2013 Author Share Posted November 14, 2013 @@stragami the second use default rates was supposed to be Inherit rates i will change this or you can within the configuration table look for MODULE_SHIPPING_SEPARATE_INHERIT in the configuration_key and change configuration_title to Inherit Rates? ok here is how your main config should work if you want per product. Seperate Shipping Per Product/Category Enable Seperate Shipping Method True Use Default Rates? No Default Table Rate 25:8.50,50:5.50,10000:0.00 Use Default Table Rates? Table per item Default Flat Rate 1 Enable Default Flat Rate? Flat per item Max Shipping Rate 50.00 Setting // this is where you set per item or per category product Use Default Rates? // this should be Inherit Rates? as explained how to change above. this is only for categories so not needed but can be expanded Yes Shipping Method // this is used for tables only as per product bases the shipping by qty qty Handling Fee 0 Tax Class 19% MwSt. Shipping Zone DE Sort Order 5 After setting the main configuration up as so you need to set the secondary configuration for each item using the top portion for flat rates and the bottom portion for table rates If you want to apply a flat rate for all products here are the settings Seperate Shipping Per Product/Category Enable Seperate Shipping Method True Use Default Rates? Yes Default Table Rate 25:8.50,50:5.50,10000:0.00 Use Default Table Rates? //this disables the default table rate No Default Flat Rate 15.00 Enable Default Flat Rate? //leave this setting as is Flat per item Max Shipping Rate 50.00 Setting // this doesn't really matter unless you want to apply a rate to all products in a certain category then select category otherwise select product category Use Default Rates? // Again should be Inherit Rates? as described above. This is used for categories but can be expanded Yes Shipping Method // this is used for both the individual per category, per product, and default table rates qty Handling Fee 0 Tax Class 19% MwSt. Shipping Zone DE Sort Order 5 I hope this answers you question and yes i will be configuring a new video on youtube on how this all works. I needed to anyhow for the new features of my module. I might have an upload section for developers to help me out, because for right now i'm a one man show. I do not want to open up the download section to public uploads until i approve of the coding. Quote Always backup your files! You will be glad you didMy add-ons :SSPP Seperate Shipping Per Product v2.5| SupportGift vouchers for SPPC 4.22 v2.1 | Support |Catalog Infobox v1.0 | Sorry no support for Catalog Infobox |HTML Mail v2.0 | Support |Upcoming Add ons:Addon Manager | Separate Pricing Per Product Qty |Coupon Populate | EZ-PDF Catalog Link to comment Share on other sites More sharing options...
rpdesign Posted November 14, 2013 Author Share Posted November 14, 2013 Ok I will work on this and give you guys a better understanding of the inner workings of my module. :) Quote Always backup your files! You will be glad you didMy add-ons :SSPP Seperate Shipping Per Product v2.5| SupportGift vouchers for SPPC 4.22 v2.1 | Support |Catalog Infobox v1.0 | Sorry no support for Catalog Infobox |HTML Mail v2.0 | Support |Upcoming Add ons:Addon Manager | Separate Pricing Per Product Qty |Coupon Populate | EZ-PDF Catalog Link to comment Share on other sites More sharing options...
stragami Posted November 16, 2013 Share Posted November 16, 2013 (edited) Hi Robert, It looks like that there is a entry mising (in my verson) this us from your Posting: Setting // this is where you set per item or per category product Use Default Rates? // this should be Inherit Rates? as explained how to change above. this is only for categories so not needed but can be expanded Yes Shipping Method // this is used for tables only as per product bases the shipping by qty qty this is my adminside: http://www.geschenkwelt24.de/forum/1.jpg using i incorrect version? rgds alfred Edited November 16, 2013 by stragami Quote Link to comment Share on other sites More sharing options...
rpdesign Posted November 17, 2013 Author Share Posted November 17, 2013 (edited) @@stragami yes this is right. However as explained you need to set up your individual rates in the separate_rate.php in the Separate Rate Box on the left hand side hmmm, this is strange that you do not have the Inherit Rates? item try this : insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Inherit Rates?', 'MODULE_SHIPPING_SEPARATE_INHERIT', 'No', 'Allow sub-categories to inherit rates from main categories?', '6', '0', 'tep_cfg_select_option(array('Yes', 'No'), ', now()) in your phpmyadmin side making sure you are in the right database more insite, please press the sql tab and copy and paste the above code into the box. If you want to translate into german please do so i would welcome it! And I will help you find out where to change the text. Edited November 17, 2013 by rpetet Quote Always backup your files! You will be glad you didMy add-ons :SSPP Seperate Shipping Per Product v2.5| SupportGift vouchers for SPPC 4.22 v2.1 | Support |Catalog Infobox v1.0 | Sorry no support for Catalog Infobox |HTML Mail v2.0 | Support |Upcoming Add ons:Addon Manager | Separate Pricing Per Product Qty |Coupon Populate | EZ-PDF Catalog Link to comment Share on other sites More sharing options...
rpdesign Posted November 18, 2013 Author Share Posted November 18, 2013 Update ver 1.71 is available! Hello everybody, I have finally uploaded the 1.71 ver for both v2.2 and v2.3 of oscommerce This fixes the above issues and adds some features that were missing. As always you can find it in my signature below. Quote Always backup your files! You will be glad you didMy add-ons :SSPP Seperate Shipping Per Product v2.5| SupportGift vouchers for SPPC 4.22 v2.1 | Support |Catalog Infobox v1.0 | Sorry no support for Catalog Infobox |HTML Mail v2.0 | Support |Upcoming Add ons:Addon Manager | Separate Pricing Per Product Qty |Coupon Populate | EZ-PDF Catalog Link to comment Share on other sites More sharing options...
rpdesign Posted November 20, 2013 Author Share Posted November 20, 2013 Well I've done it again! I'm so sorry for those who are using v2.2 of OsCommerce. When i developed the last querys and all I neglected to test my module in OsCommerce v2.2 and only tested it in v2.3.3 of oscommerec! So I'm working as fast as i can to de-bugg OsCommerce v2.2 files. For now you can use the default rates until i have the per item solved! This should only take two days at most. Again I'm sorry. :'( Quote Always backup your files! You will be glad you didMy add-ons :SSPP Seperate Shipping Per Product v2.5| SupportGift vouchers for SPPC 4.22 v2.1 | Support |Catalog Infobox v1.0 | Sorry no support for Catalog Infobox |HTML Mail v2.0 | Support |Upcoming Add ons:Addon Manager | Separate Pricing Per Product Qty |Coupon Populate | EZ-PDF Catalog Link to comment Share on other sites More sharing options...
rpdesign Posted November 21, 2013 Author Share Posted November 21, 2013 Ver 1.8 is on the way! new version makes it easier to configure rates can now be removed/ deleted max shipping can be applied to individual products fixed bug for v2.2 Oscommerce users so they can use the fuctions for v1.7 and v1.8 of SSPP instalation video will be included as well as configuration video update.sql file version number is displayed Quote Always backup your files! You will be glad you didMy add-ons :SSPP Seperate Shipping Per Product v2.5| SupportGift vouchers for SPPC 4.22 v2.1 | Support |Catalog Infobox v1.0 | Sorry no support for Catalog Infobox |HTML Mail v2.0 | Support |Upcoming Add ons:Addon Manager | Separate Pricing Per Product Qty |Coupon Populate | EZ-PDF Catalog Link to comment Share on other sites More sharing options...
marcndannie Posted November 22, 2013 Share Posted November 22, 2013 Hi, I just installed this and it seems to be working well but when I go to checkout, I am receiving the error message: Warning: mysql_fetch_assoc() expects parameter 1 to be resource, null given in ... I also am using Paypal standard and could not find the line: require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CREATE_ACCOUNT); or anything similar. Any help would be greatly appreciated. :) Quote Link to comment Share on other sites More sharing options...
rpdesign Posted November 25, 2013 Author Share Posted November 25, 2013 (edited) @@marcndannie yes sorry about that from your reply it looks like you are using v2.2 of OsCommerce. And according to previous posts i am working fearlessly on v1.8 to correct several flaws for the 1.7 version of the module for OsComm 2.2 users. You can read them in the previous two posts from me: http://www.oscommerce.com/forums/topic/391994-sspp-separate-shipping-per-product-support-forum/page__st__120#entry1685829 The error above also suggests that you are trying to use the table rates For this error try entering in any value for the flat rates for your products. I should have the new version out by thanks giving hopefully. For right now please use the default rates or flat rates per item v1.8 will have several benifits such as being able to delete individual rates and less stress on your databases. For the paypal express this was for OsComm v2.3.3 express.php file and not sure about the 2.2 ver, but should work by placing the code in the begining, maybe after require("application_top.php"); Edited November 25, 2013 by rpetet Quote Always backup your files! You will be glad you didMy add-ons :SSPP Seperate Shipping Per Product v2.5| SupportGift vouchers for SPPC 4.22 v2.1 | Support |Catalog Infobox v1.0 | Sorry no support for Catalog Infobox |HTML Mail v2.0 | Support |Upcoming Add ons:Addon Manager | Separate Pricing Per Product Qty |Coupon Populate | EZ-PDF Catalog Link to comment Share on other sites More sharing options...
Marvin Miller Posted November 27, 2013 Share Posted November 27, 2013 (edited) Hi Robert; I'm running 2.3.3.4 and there seems to be an error/issue with the docs... Step 5 Add these lines to catalog/admin/includes/column_left.php after include(DIR_WS_BOXES . 'modules.php'); //SSPP Begin include(DIR_WS_BOXES . 'separate_rate.php'); //SSPP End Yet that file looks like this; <?php /* $Id$ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2013 osCommerce Released under the GNU General Public License */ if (tep_session_is_registered('admin')) { $cl_box_groups = array(); if ($dir = @@dir(DIR_FS_ADMIN . 'includes/boxes')) { $files = array(); while ($file = $dir->read()) { if (!is_dir($dir->path . '/' . $file)) { if (substr($file, strrpos($file, '.')) == '.php') { $files[] = $file; } } } $dir->close(); natcasesort($files); foreach ( $files as $file ) { if ( file_exists(DIR_FS_ADMIN . 'includes/languages/' . $language . '/modules/boxes/' . $file) ) { include(DIR_FS_ADMIN . 'includes/languages/' . $language . '/modules/boxes/' . $file); } include($dir->path . '/' . $file); } } function tep_sort_admin_boxes($a, $B) { return strcasecmp($a['heading'], $b['heading']); } usort($cl_box_groups, 'tep_sort_admin_boxes'); function tep_sort_admin_boxes_links($a, $B) { return strcasecmp($a['title'], $b['title']); } foreach ( $cl_box_groups as &$group ) { usort($group['apps'], 'tep_sort_admin_boxes_links'); } ?> <div id="adminAppMenu"> <?php foreach ($cl_box_groups as $groups) { echo '<h3><a href="#">' . $groups['heading'] . '</a></h3>' . '<div><ul>'; foreach ($groups['apps'] as $app) { echo '<li><a href="' . $app['link'] . '">' . $app['title'] . '</a></li>'; } echo '</ul></div>'; } ?> </div> <script type="text/javascript"> $('#adminAppMenu').accordion({ autoHeight: false, collapsible: true, <?php $counter = 0; foreach ($cl_box_groups as $groups) { foreach ($groups['apps'] as $app) { if ($app['code'] == $PHP_SELF) { break 2; } } $counter++; } echo 'active: ' . (isset($app) && ($app['code'] == $PHP_SELF) ? $counter : 'false'); ?> }); </script> <?php } ?> Edited November 27, 2013 by Marvin Miller Quote Best & Thanks;Marvin----------------------osCommerce 2.3.3.4 Link to comment Share on other sites More sharing options...
rpdesign Posted November 27, 2013 Author Share Posted November 27, 2013 (edited) ok unfortutunatly this module will not work untill i program it for v2.3.3.4. This is the problem with Beta versions of Oscommerce Edited November 27, 2013 by rpetet Quote Always backup your files! You will be glad you didMy add-ons :SSPP Seperate Shipping Per Product v2.5| SupportGift vouchers for SPPC 4.22 v2.1 | Support |Catalog Infobox v1.0 | Sorry no support for Catalog Infobox |HTML Mail v2.0 | Support |Upcoming Add ons:Addon Manager | Separate Pricing Per Product Qty |Coupon Populate | EZ-PDF Catalog Link to comment Share on other sites More sharing options...
rpdesign Posted November 27, 2013 Author Share Posted November 27, 2013 @@Marvin Miller Although after reading the above post, I'll be able to convert my module to work with the 2.3.3.4 ver of Oscommerce by de-compiliing the code for how the other boxes are displayed. Each ver of OsCommerce has had a different ver of the InfoBoxes on the left and right hand side in how they were designed. Therefore one that was designed for ver2.2 would not work for v2.3 and visa versa. This is why i think Oscomm should be backward compatible with old versions not a " oh **** what happened to my store!!! :o " after upgrading and the upgrade files only upgrade the database not the addons that were developed for. Also the multiple table layout of OsComm, in my opinion, is outdated and needs to go. [by the way i'm looking at developing a commercial ver of a bootstrapped OsComm using the bootstrap development enviroment. Mobile [iphone, Tablet], dynamic, and modular design. No more copy and paste code in several files for addons, just press install and go! ] If you want this module i will work on a 2.3.3.4 ver as of right now it works with v2.2 and 2.3.1 so far after those ver not sure :unsure: Quote Always backup your files! You will be glad you didMy add-ons :SSPP Seperate Shipping Per Product v2.5| SupportGift vouchers for SPPC 4.22 v2.1 | Support |Catalog Infobox v1.0 | Sorry no support for Catalog Infobox |HTML Mail v2.0 | Support |Upcoming Add ons:Addon Manager | Separate Pricing Per Product Qty |Coupon Populate | EZ-PDF Catalog Link to comment Share on other sites More sharing options...
Marvin Miller Posted November 27, 2013 Share Posted November 27, 2013 Thanks Robert - that saves me from scratching me head for a long period of time :) I'm no even sure if this is the right mod for me. What I need is to be able to set the shipping rate for each product at a fixed price one or domestic and one for international on a per-item basis. Quote Best & Thanks;Marvin----------------------osCommerce 2.3.3.4 Link to comment Share on other sites More sharing options...
rpdesign Posted December 2, 2013 Author Share Posted December 2, 2013 @@Marvin Miller What I need is to be able to set the shipping rate for each product at a fixed price one or domestic and one for international on a per-item basis. Excellent idea!! I'll try to incorporate this in future ver. This needs to take a page from the zone shipping module which does by the way work, you just have to know how to set it up. However, it is not easy as the querys to perform this feat are escaping me at the moment,but it does have room for ideas. Beta Testers wanted!! If you want to be a beta tester please ask! v1.8 is in the works and as always will be better. Hopefully it will be ready by tomorrow 12/02/13 :thumbsup: new items: a way to delete rates! tbl rates do not need a flat rate to work less querys in the code // more for me from a programing point :D per item for both flat and tbl rates working on a separate inherit property for individual sub categories! Quote Always backup your files! You will be glad you didMy add-ons :SSPP Seperate Shipping Per Product v2.5| SupportGift vouchers for SPPC 4.22 v2.1 | Support |Catalog Infobox v1.0 | Sorry no support for Catalog Infobox |HTML Mail v2.0 | Support |Upcoming Add ons:Addon Manager | Separate Pricing Per Product Qty |Coupon Populate | EZ-PDF Catalog Link to comment Share on other sites More sharing options...
vasvikpro Posted December 3, 2013 Share Posted December 3, 2013 @@Marvin Miller Excellent idea!! I'll try to incorporate this in future ver. This needs to take a page from the zone shipping module which does by the way work, you just have to know how to set it up. However, it is not easy as the querys to perform this feat are escaping me at the moment,but it does have room for ideas. Beta Testers wanted!! If you want to be a beta tester please ask! v1.8 is in the works and as always will be better. Hopefully it will be ready by tomorrow 12/02/13 :thumbsup: new items: a way to delete rates! tbl rates do not need a flat rate to work less querys in the code // more for me from a programing point :D per item for both flat and tbl rates working on a separate inherit property for individual sub categories! Can i have version 1.8? I have oscommerce 2.3.4 Thank you Quote Link to comment Share on other sites More sharing options...
rpdesign Posted December 3, 2013 Author Share Posted December 3, 2013 @@vasvikpro Working on it right now and yes just send me a pm with your email and i'll get back to you. I should have a version to download by tonight. However i haven't worked with v2.3.4 of OsCommerce and would love for you to test out he install,etc... Please use the OsComm v2.3.3 folder for your install. And please send videos or screen shots of any errors you come accross and document everything! Camstudio works excelent for screen capture for the video. Quote Always backup your files! You will be glad you didMy add-ons :SSPP Seperate Shipping Per Product v2.5| SupportGift vouchers for SPPC 4.22 v2.1 | Support |Catalog Infobox v1.0 | Sorry no support for Catalog Infobox |HTML Mail v2.0 | Support |Upcoming Add ons:Addon Manager | Separate Pricing Per Product Qty |Coupon Populate | EZ-PDF Catalog Link to comment Share on other sites More sharing options...
Holder Posted December 10, 2013 Share Posted December 10, 2013 (edited) How to configure so that would be shipping for a category of "Hardware" and subcategories in it's $10 for "Software" category and subcategories in it - $20, for "DVD Movies" and subcategories in it - $30 I can't configure! Shipping is always - $0! version of osCommerce-2.2rc2a Thank you!!! still have 2 errors on the page checkout_shipping.php and what happened next was not working! Edited December 10, 2013 by Holder Quote Link to comment Share on other sites More sharing options...
Holder Posted December 10, 2013 Share Posted December 10, 2013 2 errors Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/project5/public_html/includes/modules/shipping/separate.php on line 167 Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/project5/public_html/includes/modules/shipping/separate.php on line 190 Quote Link to comment Share on other sites More sharing options...
Holder Posted December 11, 2013 Share Posted December 11, 2013 Can i have version 1.8? I have oscommerce 2.2 RC2a Thank Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.