Sort on SKU
8 years 7 months ago #289468
by Joomill
Sort on SKU was created by Joomill
Hi,
My customer would like to sort products by product SKU.
I couldn't find this setting, so can you tell me where to find it or can you add it?
Kind regards,
Jeroen | Joomill
My customer would like to sort products by product SKU.
I couldn't find this setting, so can you tell me where to find it or can you add it?
Kind regards,
Jeroen | Joomill
Please Log in or Create an account to join the conversation.
8 years 7 months ago #289482
by lousyfool
Need help with customisations of layouts, style or other site development? PM me!
(Don't forget to turn on "E-mail notification of new messages" )
Replied by lousyfool on topic Sort on SKU
Hi,
Unless you're using a separate (custom) field for SKU, "product_code" should be what you're looking for.
Unless you're using a separate (custom) field for SKU, "product_code" should be what you're looking for.
Need help with customisations of layouts, style or other site development? PM me!
(Don't forget to turn on "E-mail notification of new messages" )
Please Log in or Create an account to join the conversation.
8 years 7 months ago #289485
by Joomill
Replied by Joomill on topic Sort on SKU
Thanks,
Yes i expected this, but there is also no product_code option to select in the sort-field
Thanks.
Yes i expected this, but there is also no product_code option to select in the sort-field
Attachment not found
Thanks.
Please Log in or Create an account to join the conversation.
8 years 7 months ago #289496
by lousyfool
Need help with customisations of layouts, style or other site development? PM me!
(Don't forget to turn on "E-mail notification of new messages" )
Replied by lousyfool on topic Sort on SKU
Oh, so it's about a filter to apply on "Sort"...
True, product_code is not available there by default.
This thread is already a bit older, but it should still be valid: www.hikashop.com/forum/product-category-...by-product-code.html
Alternatively, you may also consider using a custom field of the type "product" for SKU. It would then be available as "sort by" option.
True, product_code is not available there by default.
This thread is already a bit older, but it should still be valid: www.hikashop.com/forum/product-category-...by-product-code.html
Alternatively, you may also consider using a custom field of the type "product" for SKU. It would then be available as "sort by" option.
Need help with customisations of layouts, style or other site development? PM me!
(Don't forget to turn on "E-mail notification of new messages" )
Please Log in or Create an account to join the conversation.
8 years 7 months ago #289498
by Joomill
Replied by Joomill on topic Sort on SKU
Hi,
Sorry, this way is for v2.6 and don't work anymore for me.
Creating a new field is also no option as we already have 3700+ products in our store.
Sorry, this way is for v2.6 and don't work anymore for me.
Creating a new field is also no option as we already have 3700+ products in our store.
Please Log in or Create an account to join the conversation.
8 years 7 months ago #289500
by lousyfool
Well, if I were in your shoes, I'd create the custom field, then use a query in PhpMyAdmin to copy product_code over. But that's not everyone's cup of tea, I guess.
So then, let's see what the official support gurus come up with. Sorry I couldn't help.
Need help with customisations of layouts, style or other site development? PM me!
(Don't forget to turn on "E-mail notification of new messages" )
Replied by lousyfool on topic Sort on SKU
Joomill wrote: Creating a new field is also no option as we already have 3700+ products in our store.
Well, if I were in your shoes, I'd create the custom field, then use a query in PhpMyAdmin to copy product_code over. But that's not everyone's cup of tea, I guess.
So then, let's see what the official support gurus come up with. Sorry I couldn't help.
Need help with customisations of layouts, style or other site development? PM me!
(Don't forget to turn on "E-mail notification of new messages" )
Please Log in or Create an account to join the conversation.
8 years 7 months ago #289489
by nicolas
Replied by nicolas on topic Sort on SKU
Hi,
In that case, add the line:
after the line:
in the file administrator/components/com_hikashop/types/product_information.php and that should allow you to select them.
In that case, add the line:
Code:
$this->values[] = JHTML::_('select.option', 'b.product_code',JText::_('PRODUCT_CODE'));
Code:
$this->values[] = JHTML::_('select.option', 'b.product_name',JText::_('PRODUCT_NAME'));
Please Log in or Create an account to join the conversation.
8 years 7 months ago #289521
by Joomill
Replied by Joomill on topic Sort on SKU
Thank you, this works.
Will this be part of the new Hikashopversion or is there a way i can make an override for this file?
Will this be part of the new Hikashopversion or is there a way i can make an override for this file?
Please Log in or Create an account to join the conversation.
8 years 7 months ago #289532
by nicolas
Replied by nicolas on topic Sort on SKU
We'll add that to the next version.
Please Log in or Create an account to join the conversation.
Time to create page: 0.171 seconds