Skip to main content

show shipping cost on product page

More
12 years 1 week ago #172795 by 888
-- HikaShop version -- : 2.3.3
-- Joomla version -- : 3.3.4
-- PHP version -- : 5.5.14-1

Hi
How do i show shipping cost on product page

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

More
12 years 1 week ago #172812 by Xavier
Hi,

The shipping cost depend generally on the selected shipping method, so there can be a lot of shipping methods based on different restrictions like zones, prices, weights, etc...

Do you have many shipping methods ?
Are you using the "price per product" option in the shipping method ?

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

More
12 years 1 week ago #173064 by 888
3 shipping method all HikaShop manual shipping plugin price per product
and all are free but vendors add inn Shipping prices in produgt.

1. pickup in store
2. virtualbox (my download)
3. home delivery

I need to get this and show on product page
from table hikashop_shipping_price -> shipping_price_value

It would be really nice if vendors could choose / mark
ignore quantity in shipping prices so the shipping price
are fix as 1 shipping price per order. Regardless of quantity

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

More
12 years 1 week ago - 12 years 1 week ago #173205 by Jerome
Hi,

For your HikaMarket requests, it is easier (and better) to use the HikaMarket forum section.
I noted your feature request about the plugin "shipping price per product" and his integration with HikaMarket.

As you have already notice, the prices are stored in the table "shipping_price".
It means that you have to perform an SQL query in the product page in order to load the shipping prices (and why not, some shipping data in the same time), in order to be able to display them.
Something like :
Code:
$db = JFactory::getDBO(); $query = 'SELECT sp.*, s.* FROM #__hikashop_shipping_price AS sp INNER JOIN #__hikashop_shipping AS s ON sp.shipping_id = s.shipping_id WHERE sp.shipping_price_ref_id = '.(int)$this->element->product_id.' AND sp.shipping_price_ref_type = ' . $db->Quote('product').' ORDER BY s.shipping_id ASC, s.shipping_price_min_quantity ASC'; $db->setQuery($query); $shipping_prices = $db->loadObjectList();

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Last edit: 12 years 1 week ago by Jerome.

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

More
12 years 1 week ago #173269 by 888
HI
I'm using show_tabular and did add your SQL query in but I got a blank page
I'm doing something wrong can you give me some more hints so i can add SQL query to the correct line and pages

and thank you Xavier and Jerome for being so efficient to answer

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

More
12 years 1 week ago #173277 by Jerome
Hi,

If you got a blank page it means that you have a PHP fatal error.
Please check your PHP error log ; I may have made a mistake in the PHP code I gave you (just write it like that).

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

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

More
12 years 1 week ago #173301 by 888
hi
PHP code did have small error in 1 line $db = JFactory::getDBO(): i did fix like $db = JFactory::getDBO();
but now i have error 1054

Regards,

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

More
12 years 1 week ago #173305 by Jerome
Hi,

Error 1054 is a SQL error ; you should be able to see the error details by activating the debug mode with the "mysqli" driver (if you are using the "mysql" driver in Joomla 3, please use the "mysqli" one)

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

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

Time to create page: 0.289 seconds
Powered by Kunena Forum