[SOLVED] Shipping calculation problem

  • Posts: 332
  • Thank you received: 6
10 years 5 months ago #158688

-- url of the page with the problem -- : CarterRabbitBlanks.com
-- HikaShop version -- : HikaShop Business: 2.3.0
-- Joomla version -- : Joomla! 2.5.20 Stable
-- PHP version -- :5.3.28
-- Browser(s) name and version -- : Firefox 29.0.1
-- Error-message(debug-mod must be tuned on) -- : No Error message

I have a client that wants only her PJ's to be charged shipping using a fixed amount of $3.25 + $.35 per each and if the qty is over 110, then there is '0' zero shipping. I setup two manual shipping methods and they work fine.

All others are to be based on a fixed shipping cost based on price as you can see below.



Now each of these fixed shipping methods are limited to the 'Price Warehouse'. All of the products other than PJ's are set to 'Price Warehouse'. I 'had' assumed that when the shipping was calculated, that it would only calculate fixed shipping on products that were assigned to 'Price Warehouse' and that 'non-Price Warehouse' products (ie: Pajamas) would not use that shipping method. But this screen shows a shipping cost of $4.65 on a total price of $32.00. The Pajamas shipping is $3.25 + $.35 per qty so $3.25 + $1.40 ($.35x4) is how the shipping is calculated but it should have used the fixed shipping which would be $8.50 for total order price of $25.01 - $50.00. Here is the screenshot of the order:



So I removed the 'Pajamas Warehouse' restriction on the Pajamas shipping methods. and I got this result:



Viola! That is the correct shipping cost of $5.50 'Priority Shiping' for a total price of $24.00.

BUT if I increase the quantity by '1' for a total of 4, total price of $32.00, I get no shipping charge of $8.50 for $25.01 - $50.00 and I get the error message "The total of your order is too high for all the possible shipping methods'. ARGH!!!!!!!!!!!!!!!!!!!!!



So how can I have one product category charged using one series of shipping methods and have other product categories use another series of shipping methods?

Last edit: 10 years 5 months ago by LukeDouglas.

Please Log in or Create an account to join the conversation.

  • Posts: 82910
  • Thank you received: 13379
  • MODERATOR
10 years 5 months ago #158848

Hi,

In that case you need two warehouses. One for each group of products.
In each product to set wether they are in the warehouse 1 or 2 and then you set the warehouse in each one of your shipping methods.
The system will then group the products per warehouse in the checkout and display/calculate the shipping methods of each group separately.

Please Log in or Create an account to join the conversation.

  • Posts: 332
  • Thank you received: 6
10 years 5 months ago #158855

Nicolas,

That is exactly how I had it setup. However, after reading your response, I decided to do some testing. I have put the 'Price Warehouse' only in the 'main' product record and NOT in any variants. So I took one variant, change the warehouse to 'Price Warehouse' for a non-pajama product and it correctly calculated the shipping price using the Price shipping method. I then took one variant for one of the pajama products, set it to 'Pajama Warehouse' and it correclty calculated the shipping price using the Pajama shipping method.

So that means that Hikashop will not use the main product warehouse as the default warehouse for all of the variants IF no warehouse is set in the variants. This means that you must put the warehouse into EVERY variant record, otherwise, the shipping will not calculate properly.

To be honest, this is sheer lunacy and it creates a 'lot' of work. You could literally have dozens of variants based on color, size, texture, etc. Hikashop SHOULD use the main product warehouse if 'no' warehouse is set in the variant records to determine shipping.

So I guess I'll be spending the next few hours updating all of the variant records to the proper warehouse. :( :( :( :(

Last edit: 10 years 5 months ago by LukeDouglas.

Please Log in or Create an account to join the conversation.

  • Posts: 82910
  • Thank you received: 13379
  • MODERATOR
10 years 5 months ago #158857

You need to put it in the variants. You can do that with mass actions or with a simple MySQL query if you want to do it faster that via the interface.

Please Log in or Create an account to join the conversation.

  • Posts: 332
  • Thank you received: 6
10 years 5 months ago #159007

Nicolas,

I have and the shipping costs are being calculated properly.

I do recommend that you put my suggestion on your to-do list as it just makes 'common' sense that if a warehouse is not set in the variant but is set in the main product record, then that is the warehouse that should be used for that variant. If a person wanted a specific variant to be set to a different warehouse, well then they could set the warehouse in that variant. This would save a ton of work when 'adding' new products as not everyone knows how to do SQL statements. I do! :)

Please Log in or Create an account to join the conversation.

  • Posts: 82910
  • Thank you received: 13379
  • MODERATOR
10 years 5 months ago #159027

Yes, why not !

Please Log in or Create an account to join the conversation.

  • Posts: 332
  • Thank you received: 6
10 years 5 months ago #159147

That's the spirit. May the keyboard gods be with you! :)

Please Log in or Create an account to join the conversation.

  • Posts: 82910
  • Thank you received: 13379
  • MODERATOR
10 years 5 months ago #159196

Amen :D

Please Log in or Create an account to join the conversation.

Time to create page: 0.064 seconds
Powered by Kunena Forum