rpdesign Posted December 13, 2013 Author Share Posted December 13, 2013 (edited) @@Holder Hi I have just given you the link to the new ver and will be giving a new configure video out today or tomorow 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 167Warning: 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 This simply means that you have no results for the querys. but thank you for showing me the errors. Just make sure you have an entry in the flat or table rates. Shipping is always - $0! This is more than likely because you set use default rates to yes or you set the setting to products instead of categories. But rest assured i'll have a new configuratioon video up for you and everyone else! :thumbsup: Edited December 13, 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 December 16, 2013 Author Share Posted December 16, 2013 Beta Testers: Holder Vasvikpro Alfred Lundt Brett Gowler To all the beta testers thankyou! :D :D :D :D :thumbsup: :thumbsup: :thumbsup: :thumbsup: To every one else i will upload the config videos for v1.8 and i will show you how to configure 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...
rpdesign Posted December 16, 2013 Author Share Posted December 16, 2013 YouTube video!!!! This is to tantalize your taste buds for the new ver! I took this video off my online test site http://demo.r-pdesign.com This is only a test site so no products will be shipped. This might also help with the previous versions 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 16, 2013 Share Posted December 16, 2013 YouTube video!!!! This is to tantalize your taste buds for the new ver! I took this video off my online test site http://demo.r-pdesign.com This is only a test site so no products will be shipped. This might also help with the previous versions Hello again, I have osc 2.3.3.4. i have problem with checkout_shipping.php. The error is: arning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/www/users/pcclub/includes/modules/shipping/separate.php on line 167. Any idea? :) Thank you Quote Link to comment Share on other sites More sharing options...
rpdesign Posted December 16, 2013 Author Share Posted December 16, 2013 (edited) @@vasvikpro ahhh, yes!! This is a result of not cleaning up my code! :- Thank you for your bug result. Here is a proper ver1.71 separate.php Replace your file with this one for everyone else please take out [ /* ] from line 155 and [ */ ] from line 156 after the query I will upload ver1.72 with this bug fix in a moment. Edited December 16, 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 December 16, 2013 Author Share Posted December 16, 2013 SSPP v1.72 SSPP v1.72 has been uploaded with the above bug fix! V1.8 is on its way! INPUT WANTED!!!! I need your help with the look and feel of the new ver as far as how to select the rates for the products as well as the categories What happened is that i noticed that you could accidentally select both a flat as well as a table rate for an individual product and category. So I need your input as far as how to select the rate for the product/category. So do you want a drop down or a set of radio buttons? I will upload a couple images for you to decide. 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 December 22, 2013 Author Share Posted December 22, 2013 (edited) @@vasvikpro @@Holder Update 1.73: Again I noticed that i uploaded a fix for v 2.2 and not 2.3.3 :- Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/includes/modules/shipping/separate.php on line 167. Both files are updated for the above bug Edited December 22, 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 December 24, 2013 Author Share Posted December 24, 2013 Merry Christmas :P!!! !!! V1.81 will be advailible ------------------------------ ----------------------------------------New Items:---------------------------------------------------------------------------------------- Update Query A way to delete rates Inherit rates now works for both the products in a sub-category as well as products in the main category A more secure way of determining flat rate vrs tbl rate per product/category bug via a drop down: [A bug was found that if you had both a flat rate and a table rate set to yes for a product/category they would both be added in the total shipping] Per Item Rates are now accurate by subtracting one times the individual rate [A bug was found that if you set per item and had 10 products the shipping would calculate for 11 products] ------------------------------ -----------------------------------------Future Items:------------------------------------------------------------------------------------- Separating the mode for table rates such as one product that has shipping based on qty one product has shipping based on weight and one product with shipping based on price in the same basket. [Currently this setting applies to all table rates] Making the module work with PWA [Purchase without Account] Separate Inherit rates so that one sub-category inherits rates from the main category while another sub category in the same main category does not . For Ex: using the default OsComm as an example; Main Category Software, Sub categories Action, Simulation, and Strategy. Sub Categories' Strategy and Action will inherit rates from Software while the Sub Category Simulation will not. Zone-Based shipping: Example Europe will have free shipping USA will have regular rates Australia will have 25% shipping fee added 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 December 24, 2013 Author Share Posted December 24, 2013 (edited) Continued from page 8 A Table of Contents or TOC has been added to both files Beta Testers have been added ******************************************************************************************************************************************************************************** Note if you were part of the Beta test and would like your website added to the list please ask me and send an email to rapetet [at] gmail.com If you would like to help out in codeing as well [credits only] or would like to be a part of the next beta test please send me an email. ****************************************************************************************************************************************************************************** Edited December 28, 2013 by burt remove limitation per Open Source ethos 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 December 27, 2013 Author Share Posted December 27, 2013 SSPP v1.81: It is finally here! I will upload and compile it tonight. 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...
burt Posted December 27, 2013 Share Posted December 27, 2013 ******************************************************************************************************************************************************************************** [snip]A whole load of BS ****************************************************************************************************************************************************************************** This is unwelcome. You may not place limitations on what anyone can or cannot do with any code you provide to the community. I have reviewed the existing module and see some issues with regards to GPL. Contact me to iron them out, PRIOR to uploading any new code. Quote Link to comment Share on other sites More sharing options...
rpdesign Posted December 28, 2013 Author Share Posted December 28, 2013 (edited) @@burt I have since taken steps to take out any limitations on the modules code. Thank you for reminding me that this is a community of open source developers. Please see my reply to your pm. Have a happy holiday :) To everyone else disregard everything after: ******************************************************************************************************************************************************************************** Note if you were part of the Beta test and would like your website added to the list please ask me and send an email to rapetet [at] gmail.com If you would like to help out in codeing as well [credits only] or would like to be a part of the next beta test please send me an email. in the post above Edited December 28, 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 December 28, 2013 Author Share Posted December 28, 2013 .SSPP ver 1.81 : It is finally ready!!! Just needs approval from burt. screenshots below: Admin full v2.2 Admin full v2.3.3 Admin close up v2.2 Admin close up v2.3.3 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 December 28, 2013 Author Share Posted December 28, 2013 More screen shots! Secondary Config: Close up: 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 December 30, 2013 Author Share Posted December 30, 2013 Update v1.811 is uploaded!! I have finaly uploaded the lastest version. I have de-bugged it in both v2.2 and v2.3.3 of OsCommerce in my live test sites. All features work in both versions! If you have a bug report please do so in the following format: Bug Report # [start with 1.812 as the first number] :( //if someone has a bug report before you such as Bug Report 1.83 please add yours as Bug Report 1.831 and so on Version of OsCommerce you are using: Description of the bug and steps to reproduce: Screenshots or a copy of the error: If you have a suggestion please do so in the following format: Suggestion: [type] [ name of suggestion] Description of the suggestion on how to improve the module, added functionality, etc.... :shifty: Tell me why you think this would be a great addition Again Thanks goes out to my Beta Testers. :thumbsup: If you want to contribute to my code or test the Beta's please send me an email to rapetet [at] gmail.com :P 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...
Pauleo Posted January 1, 2014 Share Posted January 1, 2014 Hi Robert, unfortunateley I don´t get the Default Table Rate running. My calculation is price based. My settings are looking like in the attachted file. I´m using oscommerce 2.2 MS2. Do you have an idea what´s going wrong? The shipping rate is always 0.00 EUR. Best and thank you in advance, Patrick Quote Link to comment Share on other sites More sharing options...
rpdesign Posted January 1, 2014 Author Share Posted January 1, 2014 Simple! you do not have Use default rates? set to Table or Table per item (w00t) :thumbsup: 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 January 1, 2014 Author Share Posted January 1, 2014 (edited) @ Here are some screen shots for you. This is what it should look like this is where you edit this setting You must press update Hope this straitens everything out :D By the way, I'm currently working on a German language ver and would like your input as well as others. The language pack should be ready to download by Friday. It will include English, Spanish and German. If you would like other languages please ask! I'm using a free translation software called free translator 3.3. I have noticed that your table rates are kindof messed up if you want to use price setting please round up your prices to the next highest price so your entry should look like 58:3.5, 60:0 // up to $58 charge 3.5 shipping from 58 - 60 charge 0 I would suggest putting in a large number such as 58:3.5, 100:0 for your table rate here is the german translation for this setting for the description Die Versand Tabelle wird auf die Gesamtmenge, Kosten, oder das Gewicht der Einzelteile. Beispiel: 25:8.50,50:5.50, etc.. Bis zu 25 aufladen 8.50, von dort zu 50 Gebühr 5.50, etc Edited January 1, 2014 by rpdesign 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 January 2, 2014 Author Share Posted January 2, 2014 (edited) Bug Report 1.812 After looking back at my code i noticed i forgot a else statement in the separate.php file. This results in 0.00 for shipping if using the table rates. I have since fixed this bug and have uploaded the full package. If you would like to fix this bug for your ver please place the word [ else ] without the brackets on line 341 after the closing curly brace [ } ] then place an opening curly brace [ { ]after the word else on line 341 and a closing curly brace [ } ] on the line before $this->quotes = array('id' => $this->code, Edited January 2, 2014 by rpdesign 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 January 2, 2014 Author Share Posted January 2, 2014 (edited) SSPP v1.812 uploaded The bug report above has been fixed. If using v1.811 of SSPP please just replace the catalog/includes/modules/shipping/separate.php Edited January 2, 2014 by rpdesign 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...
Pauleo Posted January 3, 2014 Share Posted January 3, 2014 Thank you for your reply. The new version SSPP v1.812 fixed my problem. Now the table rate is working fine for every product. In the next step I want to define a product, that doesn´t use the table rate. The product shall use a flat rate of 0.00 EUR. I tried to realize that effect by the following settings (see attachted files). But it doesn´t work. The shipping is still 3.50 EUR for that specific product. Please let me know if you need any translation help to German. If the new version is uploaded, I will check the German translation. Best, Patrick Quote Link to comment Share on other sites More sharing options...
rpdesign Posted January 3, 2014 Author Share Posted January 3, 2014 (edited) @ yes you now need to set Use default rates? to No or what you had before :thumbsup: and you do not have to set to 0.00 for free shipping, just select free shipping. Basically the Use Default Rate? setting is for all products regardless of what is individually set and uses the default flat or the default table rate. I also would warn about using decimals in the table setting as i'm not sure how this would effect your calculations in the shipping if you could round this number up this would be preferable. However, if you are going to use the price of the items to calculate the table rate i don't see the harm. but, if you are going to use the qty, or by weight i would suggest leaving the decimals out. Just to make it easier. :D When you turn this off you need to set a rate for all of your products individually so if you have 20 products you should have 20 rates . (w00t) To convert your table rates you would press new table rate button and put 58.99 in the first input box and 3.5 in the second box. After saving press new table rate and do the same thing except use 59 and 0 for your values However, as i explained you do not need to set 0.00 in the individual product configuration if you want free shipping. Just select free in the drop down. This is also useful if you want to temporarily give your customers free shipping without loosing your regular rate :thumbsup: I will probably just upload a language pack. When converting to a different language i also have to convert the definitions for my if then statements into the new language. And thank you for your offer to help with the translation. If you want I can give you a microsoft exel file with the name of the page and line number where the text is found. as well as the english text. :thumbsup: Just ask This does arise at an interesting problem though. If you want to apply a table rate to all products but 1 or apply a flat rate to all but 1 how do you do this without configuring individually the same thing? Currently you would have to have the same setting for all products except for the one that you want free shipping for. So if you have 20 products you will have to repeat the table rate or flat rate for 19 products and then select free for the one product. hmmm, this might be an idea for a new function Edited January 3, 2014 by rpdesign 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...
Pauleo Posted January 3, 2014 Share Posted January 3, 2014 (edited) This does arise at an interesting problem though. If you want to apply a table rate to all products but 1 or apply a flat rate to all but 1 how do you do this without configuring individually the same thing? Currently you would have to have the same setting for all products except for the one that you want free shipping for. So if you have 20 products you will have to repeat the table rate or flat rate for 19 products and then select free for the one product. hmmm, this might be an idea for a new function That´s exactly my problem. I have over thousand of products. For all these products is the default table rate valid. Except of six products (coupons that will be send via email). I think changing the logic would be a good solution. If there exists a default table rate and you define an additional flat rate per product, the validation of the flat rate must be stronger. Please send me the excel file. Edited January 3, 2014 by plorenz Quote Link to comment Share on other sites More sharing options...
rpdesign Posted January 4, 2014 Author Share Posted January 4, 2014 (edited) @ Are the coupons downloadable? If they are you might not have to set shipping on digital media such as downloads. Anyhow I think the solution would be to build another entry into the database tables separate_rate and separate_table_rate called c_default and p_default with 0 and 1 as the setting if c_default xor p_default == '1' use default rates if '0' use rate set up for the individual product. Give me the weekend to add this functionality. Please send me an email at rapetet [at] gmail.com. Replace [at] with the symbol @ this is for the exel file. Please place SSPP translation in the subject. This will also take some time to develop as i have to find all instances of the english words and how they relate to either the function of my module or the text that you see in admin and the catalog side of things. So to answer your problem more efficiently, I would have to guess that if you have anything more than No in the Use Default Rates? setting that the Use Individual rates for this product/category? [NEW] in the individual setting would automatically be no or '0' so that for the few items you want to be apart from the default rate you will set to Yes or '1' . I should have a solution by Mon 1/6 my time most likely it will be ready in the morning of Tue 1/7 your time. If you send me an email i can send to you even sooner. I will also create an update.sql for you as well to add this functionality with instructions on how to add it. This should be as simple as running the update.sql querys and replacing the catalog/admin/separate_rate.php file :P Edited January 4, 2014 by rpdesign 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...
Pauleo Posted January 5, 2014 Share Posted January 5, 2014 (edited) Unfortunately the coupons are not downloadable. I have to generate them manually. Thank you very much for supporting me. Your solution sounds great. I sent you an email. Edited January 5, 2014 by plorenz 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.