Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

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


rpdesign

Recommended Posts

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

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

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

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

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

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

Link to comment
Share on other sites

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

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

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

Ok I will work on this and give you guys a better understanding of the inner workings of 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

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

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

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.

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

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. :'(

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

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

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,

 

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. :)

Link to comment
Share on other sites

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

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 by Marvin Miller

Best & Thanks;
Marvin
----------------------
osCommerce 2.3.3.4 

Link to comment
Share on other sites

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

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

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

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.

Best & Thanks;
Marvin
----------------------
osCommerce 2.3.3.4 

Link to comment
Share on other sites

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

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

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

Link to comment
Share on other sites

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

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

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

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

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