How to show weight and brand on product page?

foxy3433
Topic Author
Offline

13 years 10 months ago #78253 by foxy3433

How to show weight and brand on product page? was created by foxy3433

When i remove:

.hikashop_product_weight_main{
display:none;
}

The Weight and Size does not automatically move to specification area on product page....

Separate Query

If I've imported 18000 products but then noticed the size for products have been auto assigned to M instead of mm how can i rectify this throughout my whole product listing

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

Jerome
Offline
HikaShop core developer

13 years 10 months ago #78271 by Jerome

Replied by Jerome on topic How to show weight and brand on product page?

Hi,

1. Weight and Size display depends on your product page layout, on the view "show_block_dimensions" and of the value (is not value, it is not displayed).
Can you give a link to a product page of your store ?

2. You can reimport with the fix value or you can update your database thanks to PhpMyAdmin and a SQL request.

Code:

UPDATE #__hikashop_product SET product_dimension_unit = 'mm' WHERE product_dimension_unit = 'M';

(Replace the "#_" by your database prefix).

Regards,

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

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

foxy3433
Topic Author
Offline

13 years 10 months ago #78365 by foxy3433

Replied by foxy3433 on topic How to show weight and brand on product page?

Cheers mate i sent the link to the url via private message and i will now try and execute the mysql query and get bk to ya!

Thanks again!

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

Jerome
Offline
HikaShop core developer

13 years 10 months ago - 13 years 10 months ago #78375 by Jerome

Replied by Jerome on topic How to show weight and brand on product page?

Hi,

You have to override your "product / show_default" view in order to move the display of "show_block_dimensions".
In the view, you would find:

Code:

  <?php
    //LAYOUT show_block_dimensions
    $this->setLayout('show_block_dimensions');
    echo $this->loadTemplate();
  ?><br />

You can remove this code.
You would paste it, in another view : "show_block_custom_main".

In the view "show_block_custom_main", replace

Code:

<div id="hikashop_product_custom_info_main" class="hikashop_product_custom_info_main">
  <h4><?php echo JText::_('SPECIFICATIONS');?></h4>
  <table width="100%">

By:

Code:

<div id="hikashop_product_custom_info_main" class="hikashop_product_custom_info_main">
  <h4><?php echo JText::_('SPECIFICATIONS');?></h4>
  <table width="100%">
<?php
    //LAYOUT show_block_dimensions
    $this->setLayout('show_block_dimensions');
    echo $this->loadTemplate();
  ?>

And in the view "show_block_dimensions", replace each

Code:

    <span id="hikashop_product_weight_main" class="hikashop_product_weight_main">
      <?php echo JText::_('PRODUCT_WEIGHT').': '.rtrim(rtrim($this->element->product_weight,'0'),',.').' '.JText::_($this->element->product_weight_unit); ?><br />
    </span>

by his table form, like:

Code:

    <tr id="hikashop_product_weight_main" class="hikashop_product_weight_main">
      <td class="key"><span class="hikashop_product_custom_name"><?php echo JText::_('PRODUCT_WEIGHT');?></span></td>
      <td><span class="hikashop_product_custom_value"><?php echo rtrim(rtrim($this->element->product_weight,'0'),',.').' '.JText::_($this->element->product_weight_unit); ?></span></td>
    </tr>

Regards,

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

Last edit: 13 years 10 months ago by Jerome.

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

foxy3433
Topic Author
Offline

13 years 10 months ago #78376 by foxy3433

Replied by foxy3433 on topic How to show weight and brand on product page?

Cheers mate for the swift reply AGAIN.......

(MYSQL Query worked a Treat (Anyone trying this...please REMEMBER the MYSQL query has to UNDERSCORES remove 1 and change # to your database prefix)

I will now try to move the weight and size fields

CHEERS

HIKASHOP IS THE BEST Support is the level on Extreme!!!!!!

THANKS LADS & LADDETTS!!!!

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

foxy3433
Topic Author
Offline

13 years 10 months ago #78381 by foxy3433

Replied by foxy3433 on topic How to show weight and brand on product page?

Thanks mate that worked but the Width Column is not Bold like the rest of the Specification list.... The Weight is set as bold...

Is this a case of locating in css and changing to bold....?

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

Xavier
Offline

13 years 10 months ago #78400 by Xavier

Replied by Xavier on topic How to show weight and brand on product page?

Yes you have to locate the class to edit, and add a css property.
www.hikashop.com/en/support/documentation/faq.html#css

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

foxy3433
Topic Author
Offline

13 years 10 months ago #78533 by foxy3433

Replied by foxy3433 on topic How to show weight and brand on product page?

Where is and what is the width class???? as i need to set it to bold

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

Jerome
Offline
HikaShop core developer

13 years 10 months ago #78552 by Jerome

Replied by Jerome on topic How to show weight and brand on product page?

Hi,

Each line should have a specific "id" and a specific class like
<tr id="hikashop_product_weight_main" class="hikashop_product_weight_main">

After that, the first "<td>" have a key class and contains a span.
I don't know what your CSS contains and I don't know what's your website so it is difficult to give you the right answer

Regards,

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

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

foxy3433
Topic Author
Offline

13 years 10 months ago #78639 by foxy3433

Replied by foxy3433 on topic How to show weight and brand on product page?

OK i'm now back onto this simple field changing to bold The Field i need to change is WIDTH on the actually product page, i can't seem to find any reference to it within the Frontend CSS file....

Can someone point me in the correct direction!

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

Jerome
Offline
HikaShop core developer

13 years 10 months ago #78647 by Jerome

Replied by Jerome on topic How to show weight and brand on product page?

Hi,

Could we have a link to a product page ?
Without it, we are a little bit "blind".

Thanks,

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

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

foxy3433
Topic Author
Offline

13 years 10 months ago #78651 by foxy3433

Replied by foxy3433 on topic How to show weight and brand on product page?

I've posted you a link via private message

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

Jerome
Offline
HikaShop core developer

13 years 10 months ago #78660 by Jerome

Replied by Jerome on topic How to show weight and brand on product page?

Hi,

It's like you have just modify the half of what you have to do.

And in the view "show_block_dimensions", replace EACH

You have just replace for "weight" block, like in my example but it's like you didn't modify the others. But you have to.

Regards,

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

The following user(s) said Thank You: foxy3433

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

foxy3433
Topic Author
Offline

13 years 10 months ago #78661 by foxy3433

Replied by foxy3433 on topic How to show weight and brand on product page?

wooooopssssss my fault i couldn't find any others via find and replace... i'll have another look SORRRRRRRRYYYYY LADS

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

foxy3433
Topic Author
Offline

13 years 10 months ago #78664 by foxy3433

Replied by foxy3433 on topic How to show weight and brand on product page?

That worked a treat............!!!!!!

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

foxy3433
Topic Author
Offline

13 years 10 months ago - 13 years 10 months ago #78798 by foxy3433

Replied by foxy3433 on topic How to show weight and brand on product page?

In regards to the MYSQL query you gave me earlier, would this query add the price in my Custom Field "Delivery" to product price

UPDATE #__hikashop_price SET price_delivery_value = price_value

Or

UPDATE #__hikashop_price SET price_delivery_value = price_value * 1.35;

But i have already added the 35% so now confused!!!!

Last edit: 13 years 10 months ago by foxy3433.

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

Jerome
Offline
HikaShop core developer

13 years 10 months ago #78823 by Jerome

Replied by Jerome on topic How to show weight and brand on product page?

Hi,

There is no custom field in the table "hikashop_price".
Product custom fields are stored in the table "hikashop_product".

If you want to roll back, you can make the reversed update

Code:

UPDATE #__hikashop_price SET price_value = price_value / 1.35;

If you create a column in the table "hikashop_price", it wouldn't be possible for HikaShop to retrieve this data.
If you have to use a product custom field but it means that, all of your product just have one single price.

Code:

UPDATE #__hikashop_product AS a INNER JOIN #__hikashop_price AS b ON a.product_id = b.price_product_id AS price_access = "all" AND price_min_quantity <= 1 AND b.price_currency_id = 000 SET a.price_delivery_value = b.price_value * 1.35;

Don't forget to replace the "000" for the currency_id, with your default currency id.

Regards,

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

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

foxy3433
Topic Author
Offline

13 years 10 months ago - 13 years 10 months ago #78859 by foxy3433

Replied by foxy3433 on topic How to show weight and brand on product page?

I did it this formula Price_Value = Price Value + Delivery *1.35

I'm going to have to write a plugin to do the job on cron update... I'll let you know how i get on but for now i have what i needed

Cheers ALL that have given me update for this BUILD it has been really APPRECIATED!!!

Forgot to add i have to now write a plugin do the MYSQL job before cron update information is processed... WISH ME LUCK!

Last edit: 13 years 10 months ago by foxy3433.

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

Jerome
Offline
HikaShop core developer

13 years 10 months ago #78863 by Jerome

Replied by Jerome on topic How to show weight and brand on product page?

Good luck !
You will see, a HikaShop cron plugin is not too complicated

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