Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

[SSPP] Separate Shipping Per Product----Support Forum


rpdesign

Recommended Posts

@@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 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

 

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 by rpetet

Always backup your files! You will be glad you did

My add-ons :

SSPP Seperate Shipping Per Product v2.5| Support
Gift 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

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.

Always backup your files! You will be glad you did

My add-ons :

SSPP Seperate Shipping Per Product v2.5| Support
Gift 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

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

 

Always backup your files! You will be glad you did

My add-ons :

SSPP Seperate Shipping Per Product v2.5| Support
Gift 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

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

Link to comment
Share on other sites

@@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 by rpetet

Always backup your files! You will be glad you did

My add-ons :

SSPP Seperate Shipping Per Product v2.5| Support
Gift 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

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.

Always backup your files! You will be glad you did

My add-ons :

SSPP Seperate Shipping Per Product v2.5| Support
Gift 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

@@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 by rpetet

Always backup your files! You will be glad you did

My add-ons :

SSPP Seperate Shipping Per Product v2.5| Support
Gift 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

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

Always backup your files! You will be glad you did

My add-ons :

SSPP Seperate Shipping Per Product v2.5| Support
Gift 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

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 by burt
remove limitation per Open Source ethos

Always backup your files! You will be glad you did

My add-ons :

SSPP Seperate Shipping Per Product v2.5| Support
Gift 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

SSPP v1.81:

 

It is finally here!

I will upload and compile it tonight.

Always backup your files! You will be glad you did

My add-ons :

SSPP Seperate Shipping Per Product v2.5| Support
Gift 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

********************************************************************************************************************************************************************************

[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.

 

 

Link to comment
Share on other sites

@@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 by rpetet

Always backup your files! You will be glad you did

My add-ons :

SSPP Seperate Shipping Per Product v2.5| Support
Gift 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

.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

 

 

Always backup your files! You will be glad you did

My add-ons :

SSPP Seperate Shipping Per Product v2.5| Support
Gift 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 screen shots!

 

Secondary Config:

 

 

 

Close up:

 

 

Always backup your files! You will be glad you did

My add-ons :

SSPP Seperate Shipping Per Product v2.5| Support
Gift 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

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

Always backup your files! You will be glad you did

My add-ons :

SSPP Seperate Shipping Per Product v2.5| Support
Gift 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

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

post-326009-0-02165800-1388568956_thumb.png

Link to comment
Share on other sites

Simple! you do not have

Use default rates?

 

set to Table or Table per item (w00t) :thumbsup:

Always backup your files! You will be glad you did

My add-ons :

SSPP Seperate Shipping Per Product v2.5| Support
Gift 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

@

 

Here are some screen shots for you.

 

This is what it should look like

post-274161-0-67848600-1388609503_thumb.png

 

this is where you edit this setting

post-274161-0-28111700-1388609504_thumb.png

 

You must press update

post-274161-0-67450700-1388609504_thumb.png

 

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 by rpdesign

Always backup your files! You will be glad you did

My add-ons :

SSPP Seperate Shipping Per Product v2.5| Support
Gift 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

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 by rpdesign

Always backup your files! You will be glad you did

My add-ons :

SSPP Seperate Shipping Per Product v2.5| Support
Gift 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

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 by rpdesign

Always backup your files! You will be glad you did

My add-ons :

SSPP Seperate Shipping Per Product v2.5| Support
Gift 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

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

post-326009-0-12064000-1388735678_thumb.png

post-326009-0-18067300-1388735684_thumb.png

Link to comment
Share on other sites

@

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 by rpdesign

Always backup your files! You will be glad you did

My add-ons :

SSPP Seperate Shipping Per Product v2.5| Support
Gift 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

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 by plorenz
Link to comment
Share on other sites

@

 

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 by rpdesign

Always backup your files! You will be glad you did

My add-ons :

SSPP Seperate Shipping Per Product v2.5| Support
Gift 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

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 by plorenz
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...