How to show weight and brand on product page?

  • Posts: 81
  • Thank you received: 6
12 years 1 day ago #78253

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.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
12 years 1 day ago #78271

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.

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.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 81
  • Thank you received: 6
12 years 19 hours ago #78365

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.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
12 years 18 hours ago #78375

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:

  <?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
<div id="hikashop_product_custom_info_main" class="hikashop_product_custom_info_main">
  <h4><?php echo JText::_('SPECIFICATIONS');?></h4>
  <table width="100%">
By:
<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
    <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:
    <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.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
Last edit: 12 years 18 hours ago by Jerome.

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

  • Posts: 81
  • Thank you received: 6
12 years 18 hours ago #78376

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.

  • Posts: 81
  • Thank you received: 6
12 years 17 hours ago #78381

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.

  • Posts: 13201
  • Thank you received: 2322
12 years 16 hours ago #78400

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.

  • Posts: 81
  • Thank you received: 6
11 years 11 months ago #78533

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.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
11 years 11 months ago #78552

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.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 81
  • Thank you received: 6
11 years 11 months ago #78639

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.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
11 years 11 months ago #78647

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.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 81
  • Thank you received: 6
11 years 11 months ago #78651

I've posted you a link via private message

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
11 years 11 months ago #78660

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.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
The following user(s) said Thank You: foxy3433

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

  • Posts: 81
  • Thank you received: 6
11 years 11 months ago #78661

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.

  • Posts: 81
  • Thank you received: 6
11 years 11 months ago #78664

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

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

  • Posts: 81
  • Thank you received: 6
11 years 11 months ago #78798

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: 11 years 11 months ago by foxy3433.

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
11 years 11 months ago #78823

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

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

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 81
  • Thank you received: 6
11 years 11 months ago #78859

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: 11 years 11 months ago by foxy3433.

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
11 years 11 months ago #78863

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

Regards,

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

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

Time to create page: 0.057 seconds
Powered by Kunena Forum