how do I charge for extra cooling at checkout?

[jenso]

Hi

In my shop we have food and nonfood items.

When it comes to shipping we now need to charge an extra amount for food items (it is getting to warm and they need to be cooled, which cost extra)

How do I charge the customer at checkout this extra money?

 

If the customer has only nonfood stuff, like a T-Shirt, I cannot charge for cooling in the checkout.

 

So any idea how I can do this? Any Tip and Trick, or a Contrib???

 

Please give feedback

 

Thanks

 

Rich

[mijman2]

Why not incude it in the cost already?

[AlanR]

Why not incude it in the cost already?

Sounds right to me.

 

Change the prices based on the season. More in the summer, less in the winter.

[jenso]

Why not incude it in the cost already?

Sounds right to me.

 

Change the prices based on the season. More in the summer, less in the winter.

Thanks for the responds AlanR and mijman2

 

You are right I could do that, but the extra charge applies only once for a shiping.

Some customers buy 2 items other 1 and so on.

Also the extra cooling charge is not included in the shipping rate, which would be an easier way to implement it. But we offer free shipping as well and that module can not handle a extra fee.

 

The easy way would be to make it an extra charge - "cooling transport fee $xxx.xx"

I looked into some contrib like "handling fee", "low ordering fee".

All of them are linked to a total prize and they are unable to tell if the order has only food, non food, or mixed item in the shopping cart.

When the customer has only "non food" we do not have to use the cooling transportation.

 

My idea is that somehow a module in order total can find out if their is a food product in the shopping cart and apply the extra cost in a line before "Order Total".

 

The problem I have is to figure out the "How to".

 

Any idea?! Anyone!

[AlanR]

The first thing I would do is to design the product numbers with a prefix or suffix that defined that class of product.

 

Then you'll need to do a little coding to detect whether the cart contains one such item and add the extra charge. I haven't seen any contribution that addresses such a specific need.

[jenso]

The first thing I would do is to design the product numbers with a prefix or suffix that defined that class of product.

 

Then you'll need to do a little coding to detect whether the cart contains one such item and add the extra charge. I haven't seen any contribution that addresses such a specific need.

Hi AlanR

 

That aproach with a prefix or suffix sounds a bit easier than my thinking.

I thought to look up the product and match the category. In a secound step to look if the category Number (cPath) to see if it does match with the category Number listed to have the extra charge... Well a bit complicated

 

Your aproach is a bit easier, well just have to change the product number of the listed items.

 

I am thinking to take one of the contrib I have mentioned earlier and try to put the needed code into the contrib.

 

I hope I can make it.

 

This is now to evryone who is reading this post:

Until I post my efforts, please feel free to discuss this aspect and mybe come up with some coding as well.

 

Thanks for the input and help

 

Rich

[duddy6600]

Hi..

I am also looking the solution for additional price for food shipping...

 

Anybody has the solution and like to share the module? Pleaseeee....

[noob]

u culd make a tax class for it and for all the food products set it

for example

under taxable goods wher u have ur state's tax

make a new tax clas for food

then for all the items not food

make a new thingy instead of taxable goods and set it to all non food products

then all u have to do wen winter comes is disable the tax class for food

 

hope that made sence :huh: lol

[duddy6600]

Hi Noob,

 

Thanks for the idea.....

 

Your idea will make all of food product price increase because of the tax ..

 

But what I really want is to have additional shipping price for food product.

So that when people buy food product, automatically there is additional charge for cooling box...

 

sound simple, but still complicated for me... :(

[kepa]

I would go with an attribute for those products and build the added cost into the attributes.

[duddy6600]

Hi Kepa,

 

Can u explain more how to add the attributes..

 

I am newbie here... :(

 

Thanks a lot for sharing ur knowledge with us..

[duddy6600]

I Found module which is quiet close to what I want:

Free Item Handling

 

That module will search user shopping cart for free item and then calculate the shipping cost for them.

 

In my case, the program should be able to search specific product ID, ie. food product ID. If found one then put additional shipping cost only ONCE in total order.

 

From the module above, I think I have to play around with this part of code:

 

$freequery = tep_db_query("SELECT SUM(cb.customers_basket_quantity) AS total FROM " . TABLE_CUSTOMERS_BASKET . " cb LEFT JOIN " . TABLE_PRODUCTS . " p ON cb.products_id = p.products_id WHERE cb.customers_id =  '" . $customer_id . "' AND cb.final_price <  '0.01' AND p.products_price <  '0.01'");
$freestuff = tep_db_fetch_array($freequery);
$freeitems = $freestuff['total'];
$handlingfee = ($freeitems * MODULE_ORDER_TOTAL_HANDLING_FEE);

 

Hmmm..

 

Can Anybody suggest, how to start the coding and define specific product ID ...?

 

 

Dudi

[Sheila]

Hi all..

 

I read this thread carefully...

 

This is exactly the same condition I am trying to solve for my shop..

 

Does anybody get a clue for this ?? :thumbsup:

 

Sheila