Shipping methods and categories

  • Posts: 26
  • Thank you received: 0
12 years 4 months ago #57608

I am facing the difficulty where if someone adds two different items from different categories it does not work out the shipping correctly.
What I need to do is have a different shipping cost for different items in different categories.
I have 2 categories, the products in each category have different shipping costs.
I am using the manual shipping plugin and have differentiated between the two categories by using volume for one and weight for the other.
The problem arises when two products, one from each category is added to the cart. The plugin uses the shipping cost of the first item loaded into the cart and although it shows both shipping costs you can only select 1.

I can see the 'Use the prices per product' option, however I cannot see if you can add this to specific products or if it is for all products.

Hika 1.5.8 Joomla 2.5.6

Thank you

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

  • Posts: 12953
  • Thank you received: 1778
12 years 4 months ago #57617

Hello,

You maybe should use the "Use the prices per product" option because it will enable you to use a specific shipping price for each products, you'll just have to :

- Enable the "Use the prices per product" option of your manual shipping method.
- Go to each product page and set a new shipping price into the "Shipping prices" tab.

Hope this will help you.

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

  • Posts: 26
  • Thank you received: 0
12 years 4 months ago #57619

Hi Thelji,

This does not seem to be working for me, I can see the shipping section at the bottom of the product listing however I cannot add the shipping, I can see a green cross but not the text ADD as on the others.

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

  • Posts: 12953
  • Thank you received: 1778
12 years 4 months ago #57623

You'll just have to use the "green cross" button to add the shipping price :).

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

  • Posts: 26
  • Thank you received: 0
12 years 4 months ago #57625

I have tried that, however when I save the product the shipping is not saved

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

  • Posts: 12953
  • Thank you received: 1778
12 years 4 months ago #57671

Ok, did you :

- use the green cross button
- add a minimum quantity and a price
- save

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

  • Posts: 26
  • Thank you received: 0
12 years 4 months ago #57746

Yes I did exactly that, and for some reason it is not saving

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

  • Posts: 12953
  • Thank you received: 1778
12 years 4 months ago #57753

Hello,

Can you please :

- Active the joomla debug mode ("Administration->Global configuration->System->Debug System/Language")
- SET a new shipping price into the "Shipping prices" tab and SAVE
- Tell me if it display an error message

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

  • Posts: 26
  • Thank you received: 0
12 years 4 months ago #57795

The error is:

JDatabaseMySQLi::query: 1054 - Unknown column 'shipping_fee_value' in 'field list' SQL=INSERT IGNORE INTO r85qa_hikashop_shipping_price (`shipping_id`,`shipping_price_ref_id`,`shipping_price_ref_type`,`shipping_price_min_quantity`,`shipping_price_value`,`shipping_fee_value`) VALUES (7,160,'product',1,10,0)

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

  • Posts: 82819
  • Thank you received: 13366
  • MODERATOR
12 years 4 months ago #57855

That means that you had a problem during the installation/update of Hikashop and the hikashop_shipping_price couldn't be installed properly.
The simplest is to delete that table via PHPMyAdmin, donwload HikaShop from our website and install again HikaShop on your website. That should add back that table and hopefully fix the error.

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

  • Posts: 26
  • Thank you received: 0
12 years 4 months ago #57879

I have done that however when I reinstall Hika Shop it is not adding the table back. Could you send me the mysql file to add in phpmyadmin

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

  • Posts: 82819
  • Thank you received: 13366
  • MODERATOR
12 years 4 months ago #57936

You already have it.
It's the file tables.sql in the folder back of the installation package.

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

  • Posts: 26
  • Thank you received: 0
12 years 3 months ago #58280

Hi Nicolas,

I added the table which now shows up the shipping on the product page, however it does not seem to work for me. Keep getting the "The cart items combined volume is too big for all the possible shipping methods" error.
The product has no weight and no size values.
The Use the prices per product is set to yes.
I add the price and a min and max price.
Add product to cart and get the above error

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

  • Posts: 82819
  • Thank you received: 13366
  • MODERATOR
12 years 3 months ago #58335

Please do a screenshot of each one of your shipping methods. They must not be configured properly.

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

  • Posts: 187
  • Thank you received: 10
12 years 3 months ago #58484

Just want to mention that I have exactly thet same issue of the missing table, despite two reinstall.
Please note that this is an 'upgrade' Hikashop on a test machine.
Might be something to double check.

JDatabaseMySQLi::query: 1054 - Unknown column 'shipping_fee_value' in 'field list' SQL=INSERT IGNORE INTO igd3f_hikashop_shipping_price (`shipping_id`,`shipping_price_ref_id`,`shipping_price_ref_type`,`shipping_price_min_quantity`,`shipping_price_value`,`shipping_fee_value`) VALUES (2,9,'product',1,127,5.95)

Checking the table, I am missing the last field: "shipping_fee_value"
Fixed the Table and it now works.

Bastiaan

Last edit: 12 years 3 months ago by zebrafilm.
The following user(s) said Thank You: nicolas

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

Time to create page: 0.105 seconds
Powered by Kunena Forum