X-Cart forums

[chamberinternet]

Hello ...

I need to get a specific extra field from the product data and output on the Shopping Cart & Checkout Page for each product.

Has anyone done this before ? Any pointers towards the right direction?

Can anyone help ?

Thanks & Regards

Shafiq :sK

[mikalou]

I needed to do the same thing. The following procedure works for me. I'm using Xcart 4.1.9.

Modified files: (BACKUP YOUR FILES BEFORE YOU MAKE CHANGES)
1. include/func/func.cart.php
2. skin1/customer/main/cart.tpl

Step 1:
You'll need to modify the "select" query statement that Xcart uses to get the field values for the products that have been added to the cart so that it will also include fields from the "xcart_extra_field_values" table. This select query statement is located within the function "func_products_from_scratch" within the file include/func/func.cart.php.

At approximately line 1718, you'll see the following query statement. The changes you need to make are in bold text: (note: I'm using "live" as a pseudonym for the field name but you can use whatever name you want)

$products_array = func_query_first("SELECT $sql_tbl[products].*, MIN($sql_tbl[pricing].price) as price, IF($sql_tbl[images_T].id IS NULL, '', 'Y') as is_thumbnail, $sql_tbl[images_T].image_path, $sql_tbl[images_T].image_x, $sql_tbl[images_T].image_y, IF($sql_tbl[images_P].id IS NULL, '', 'P') as is_pimage, $sql_tbl[images_P].image_path as pimage_path, $sql_tbl[images_P].image_x as pimage_x, $sql_tbl[images_P].image_y as pimage_y, $sql_tbl[extra_field_values].value as live FROM $sql_tbl[pricing],$sql_tbl[products] LEFT JOIN $sql_tbl[images_T] ON $sql_tbl[images_T].id = $sql_tbl[products].productid LEFT JOIN $sql_tbl[extra_field_values] ON $sql_tbl[extra_field_values].productid = $sql_tbl[products].productid LEFT JOIN $sql_tbl[images_P] ON $sql_tbl[images_P].id = $sql_tbl[products].productid WHERE $sql_tbl[products].productid=$sql_tbl[pricing].productid AND $sql_tbl[products].forsale != 'N' AND $sql_tbl[products].productid='$productid' AND $avail_condition ".(empty($active_modules['Wholesale_Trading']) ? "$sql_tbl[pricing].quantity = 1" : "$sql_tbl[pricing].quantity<='$amount'")." AND $sql_tbl[pricing].membershipid IN('$membershipid', '0') AND $sql_tbl[pricing].variantid = '$variantid' GROUP BY $sql_tbl[products].productid ORDER BY $sql_tbl[pricing].quantity DESC");

Step 2:
Modify skin1/customer/cart.tpl to display the value for the extra field.
Locate the section loop "{section name=product loop=$products}" within cart.tpl. Then place the smarty tag {$products[product].live} within that section loop to display the extra field value.

[retrtrtrytrutru]

Dear mikalou,

Thank you very much for sharing! Just what I needed! I applied your changes to func.cart.php but use a different code for cart.tpl since I had no loop in there. It has a foreach statement instead (v4.2). I simply use in cart.tpl:

{$product.live}

Does the trick for me