Invoice no longer displaying custom fields

  • Posts: 31
  • Thank you received: 0
  • Hikashop Business
8 years 7 months ago #237460

-- HikaShop version -- : 2.6.2
-- Joomla version -- : 3.5.1

Since updating to 2.6.2, invoices no longer display custom fields for products. This was working properly before the update. I am able to see the custom field responses when viewing the individual order, but when I try to print the invoice only the name of the product is displayed. The custom fields are published for front-end, back-end form, and back-end listing. Please advise.

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

  • Posts: 82867
  • Thank you received: 13374
  • MODERATOR
8 years 7 months ago #237474

Hi,

We've actually changed the display settings of the custom item/product fields. So there is no frontend/backend form/backend listing settings for them anymore.
Edit your custom fields via the menu Display>Custom fields and configure the settings in the Display area the way you want and it should display fine again.

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

  • Posts: 32
  • Thank you received: 2
8 years 7 months ago #238122

I'm experiencing same issue after updated to 2.6.2...
All new display settings are configured correctly.

[hikashop_field]
We got many products (~120) with many custom fields (~20)
~8 custom fields are linked to products only:
- field_categories: all ## field_products: ,1,2,3,4,5,6,7,10,

~9 categories only:
- field_categories: ,20,21,22,23, ## field_products:

and 2 both:
- field_categories: ,24,25,26,27,28,29, ## field_products: ,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,10,

after some backtrace, i'm able to detect issue in:
-> $itemFields = $this->fieldsClass->getFields('display:field_item_invoice=1',$product,'item');
-> $this->getCategories($type, $data);
-> $this->getData($area, $type, false, $allCat);
who lead to a SQL with empty result

SELECT * FROM #__hikashop_field as a WHERE a.`field_published` = 1 AND a.`field_display` LIKE '%;field\_item\_shipping\_invoice=1;%' AND a.field_table='item' AND (a.field_access = 'all' OR a.field_access LIKE '%,8,%') AND ((((field_with_sub_categories=0 AND (field_categories="all" OR field_categories="" OR field_categories LIKE '%,28,%'))OR (field_with_sub_categories=1 AND (field_categories="all" OR field_categories="" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%' OR field_categories LIKE '%,13,%' OR field_categories LIKE '%,28,%'))) AND field_products="") OR (field_products LIKE '%,52,%')) ORDER BY a.`field_ordering` ASC

If i remove all the were clause this works fine.

NB: I also noticed before updated, they were a possible value for field_products in hikashop_field: ",0,"

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

  • Posts: 82867
  • Thank you received: 13374
  • MODERATOR
8 years 7 months ago #238127

Hi,

Could you provide a screenshot of the setting of your custom field ?
Also, can you provide the id of the product in the order and the id of the category of that product ?

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

  • Posts: 32
  • Thank you received: 2
8 years 6 months ago #238196

Field display for all:
;field_item_show_cart=1;
field_item_backend_cart_details=1;
field_item_checkout=1;
field_item_order=1;
field_item_product_listing=1;
field_item_product_show=1;
field_item_product_cart=1;
field_item_order_form=1;
field_item_invoice=1;
field_item_shipping_invoice=1;
field_item_edit_product_order=1;
field_item_order_notification=1;
field_item_order_status_notification=1;
field_item_order_creation_notification=1;
field_item_order_admin_notification=1;
field_item_payment_notification=0;

field_frontcomp : 1
field_backend : 0
field_backend_listing : 1

Id of category product: 28
ID of product: 52 (this is a variant; product got 4 variants)

Hope this help.

Last edit: 8 years 6 months ago by PortobelloDigital.

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

  • Posts: 4747
  • Thank you received: 644
  • MODERATOR
8 years 6 months ago #238221

Hello,

In order to help you, we need your screenshot as Nicolas ask you :

Could you provide a screenshot of the setting of your custom field ?
Also, can you provide the id of the product in the order and the id of the category of that product ?


Awaiting news from you.

Regards,

Last edit: 8 years 6 months ago by Philip.

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

  • Posts: 82867
  • Thank you received: 13374
  • MODERATOR
8 years 6 months ago #238675

Hi,

We got your screenshot. In it I don't see the product 52 or the category 28 selected in the custom field, so it's normal that this custom field is not displaying for your product in your invoice, it shouldn't even display on the product page of the product.
So I suppose that the screenshot you provided doesn't correspond to the example you talked about in your first message. So it's hard to conclude anything. Also, can you confirm that you saved the fields once with the display settings like you want ?

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

  • Posts: 252
  • Thank you received: 3
8 years 6 months ago #238824

Perhaps we are talking about the same issue.
Is there a way to bring in the charactaristics value in the invoice.

Since this has been removed we get all sorts of complains from our customers.
The can not see what size or colour they have ordered.
Thanks in advance

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

  • Posts: 82867
  • Thank you received: 13374
  • MODERATOR
8 years 6 months ago #238835

Hi,

The characteristics values are still added to the invoices.
If that's not the case, do you have them on the cart after the add to cart ? If not, then it means that the problem comes from the customization of the product page layout on your website. Rename the folder templates/YOUR_TEMPLATE/html/com_hikashop/product to deactivate the overrides and check if that work. If it does, it will confirm that it comes from there and you'll have to move your modifications to the new versions of the view files (at least the file causing the problem in that folder).

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

  • Posts: 252
  • Thank you received: 3
8 years 6 months ago #238864

Hi,
I have renamed the map tot product1
/domains/dodowear.nl/public_html/templates/rnshop/html/com_hikashop/product1
Is that OK?

After that we got a new order.
It just shows the name of the selected items, but rather no size characteristic

Attachments:

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

  • Posts: 82867
  • Thank you received: 13374
  • MODERATOR
8 years 6 months ago #238929

Hi,

Thank you for the screenshot. From what I can see your problem is different.
It's that in your product variants, you've entered the same name as the main product name. And thus, instead of generating the variant name out of the selected characteristic values, it uses the variant name instead.
Empty the name of the variants of your product and you'll see that it will work fine.
You can run a mass action via the menu System>Mass actions in order to empty the product_name of all the variants with one click.

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

  • Posts: 13201
  • Thank you received: 2322
8 years 6 months ago #238979

Hi,

The mass action can be set like that: take.ms/sMLDs
As you know, we recommend to do a backup of your database before running any mass actions for more security.

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

  • Posts: 32
  • Thank you received: 2
8 years 6 months ago #239097

Any new information about mine issue?
This is really urgent, there is no more details in invoice... hope you understand

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

  • Posts: 82867
  • Thank you received: 13374
  • MODERATOR
8 years 6 months ago #239219

Hi,

Could you provide a backend access so that we could check on the problem directly in your backend as we don't have the problem on our end ?
Please use our contact form and add a link to this thread:
www.hikashop.com/support/contact-us.html

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

  • Posts: 4747
  • Thank you received: 644
  • MODERATOR
8 years 6 months ago #239646

Hello,

We were unable to help you because you don't give us elements, and that's why I post this :

In order to help you, we need your screenshot as Nicolas ask you :

Could you provide a screenshot of the setting of your custom field ?

Also, can you provide the id of the product in the order and the id of the category of that product ?


You don't give these elements, and when I access to your backend I see nothing

And so, I'm always unable to help you, can you give us asked elements and some access rightsto the user access Hikashop please.

I can't tell you more for now.

Regards.

Attachments:
Last edit: 8 years 6 months ago by Philip.

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

  • Posts: 32
  • Thank you received: 2
8 years 6 months ago #239667

Pls, erase your image and dont write url/name of client...

Then, just add in url after administrator eg: /administrator?option=com_hikashop
and you will be able to access hikashop -you got right acl- , just dunno why extension tab dot not appear

Thx in advance

EDIT: i already sended by contact form all other elements (last week)

Last edit: 8 years 6 months ago by PortobelloDigital.

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

  • Posts: 4747
  • Thank you received: 644
  • MODERATOR
8 years 6 months ago #239671

It's done, sorry I forgot to mask your Url

Regards.

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

Time to create page: 0.081 seconds
Powered by Kunena Forum