[Skip to main content](#vessel-content) # Product Details after checkout! ## - **[mick](/forum/user/2865-mick "View mick's Profile")** - [![mick's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/duck.gif)](/forum/user/2865-mick "View mick's Profile") Topic Author - [ Offline](/forum/user/2865-mick) Less More - Posts: 23 - Thank you received: 0 - - 15 years 4 months ago [\#18455](#18455) by [mick](/forum/user/2865-mick "View mick's Profile") *[Product Details after checkout!](/forum/2-general-talk-about-hikashop/18455-product-details-after-checkout#18455 "I m using Hikashop in joomla 1.6.I am having an extra cost on user choice which adds to the product full price. i am succesful in getting user response from a drop down where in user can say yes or no...")* was created by *[mick](/forum/user/2865-mick "View mick's Profile")* I m using Hikashop in joomla 1.6.I am having an extra cost on user choice which adds to the product full price. i am succesful in getting user response from a drop down where in user can say yes or no to extra cost. Depending upon that extra cost gets added to real price. but i am stuck now as after checkout(Authorize.net) the product details are displayed i want to add that extra cost there also...I m succesfull in inserting it to order_product table. please guide where to edit the cost so that in biiling cost that extra cost can be displayed. and $order_product_total_price ![=(](/frown.gif "=(")$product->order_product_price+$product->order_product_support)*$product->order_product_quantity; please ang guide properly as i m new to MVC structure. thnks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzE4NDU1LXByb2R1Y3QtZGV0YWlscy1hZnRlci1jaGVja291dD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86316 - Thank you received: 14276 - - 15 years 4 months ago [\#18457](#18457) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Product Details after checkout!](/forum/2-general-talk-about-hikashop/18455-product-details-after-checkout#18457 "I m using Hikashop in joomla 1.6.I am having an extra cost on user choice which adds to the product full price. i am succesful in getting user response from a drop down where in user can say yes or no...")* If you use the latest version of HikaShop, the total price calculation can be overriden via a joomla system plugin implementing the override functions as explained in : [ www.hikashop.com/support/documentation/6...tation.html#override](http://www.hikashop.com/support/documentation/62-hikashop-developer-documentation.html#override) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzE4NDU1LXByb2R1Y3QtZGV0YWlscy1hZnRlci1jaGVja291dD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mick](/forum/user/2865-mick "View mick's Profile")** - [![mick's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/duck.gif)](/forum/user/2865-mick "View mick's Profile") Topic Author - [ Offline](/forum/user/2865-mick) Less More - Posts: 23 - Thank you received: 0 - - 15 years 4 months ago [\#18506](#18506) by [mick](/forum/user/2865-mick "View mick's Profile") Replied by *[mick](/forum/user/2865-mick "View mick's Profile")* on topic *[Re: Product Details after checkout!](/forum/2-general-talk-about-hikashop/18455-product-details-after-checkout#18506 "I m using Hikashop in joomla 1.6.I am having an extra cost on user choice which adds to the product full price. i am succesful in getting user response from a drop down where in user can say yes or no...")* Thanks alot for reply..but creating new custom field only create it in address table.... ..(screen shot attched)... where to create custom field in product n cart table...according to suggestion u gave.... but the way i m moving is with out layout override manually have created filed in db product , cart, order table n have changed insert,Update queries accordingly at every step. just stuck in last ..which function of authorize.php is taking values from order table to payement url defined in plugin. sending u next screenshot of the detail page where i want to add extra cost and display it with an extra coloumn there also so that customer knows how much is bieng added to final total. plz help project is on dead line. [ ![[img](http://www.hikashop.com/media/kunena/attachments/legacy/images/screenshot_customfield.png) ](http://www.hikashop.com/media/kunena/attachments/legacy/images/screenshot_customfield.png "[img") - [ ![screenshot_customfield.png](/forum/attachment/1256) ](/forum/attachment/1256 "...ustomfield.png") [ ](/forum/attachment/1256?download=1 "...ustomfield.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzE4NDU1LXByb2R1Y3QtZGV0YWlscy1hZnRlci1jaGVja291dD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mick](/forum/user/2865-mick "View mick's Profile")** - [![mick's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/duck.gif)](/forum/user/2865-mick "View mick's Profile") Topic Author - [ Offline](/forum/user/2865-mick) Less More - Posts: 23 - Thank you received: 0 - - 15 years 4 months ago [\#18507](#18507) by [mick](/forum/user/2865-mick "View mick's Profile") Replied by *[mick](/forum/user/2865-mick "View mick's Profile")* on topic *[Re: Product Details after checkout!](/forum/2-general-talk-about-hikashop/18455-product-details-after-checkout#18507 "I m using Hikashop in joomla 1.6.I am having an extra cost on user choice which adds to the product full price. i am succesful in getting user response from a drop down where in user can say yes or no...")* here goes screenshot of where i want to display on extra filed which is extra cost. plz guide properly told u im fresh wd cake php structure. n chnges i told you in my earlier msg are breaking cart functionality somewhere wch is i am aware of and will come in testing phase. thnkx alot [ ![[img](http://www.hikashop.com/media/kunena/attachments/legacy/images/test.png) ](http://www.hikashop.com/media/kunena/attachments/legacy/images/test.png "[img") - [ ![test.png](/forum/attachment/1257) ](/forum/attachment/1257 "test.png") [ ](/forum/attachment/1257?download=1 "test.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzE4NDU1LXByb2R1Y3QtZGV0YWlscy1hZnRlci1jaGVja291dD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mick](/forum/user/2865-mick "View mick's Profile")** - [![mick's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/duck.gif)](/forum/user/2865-mick "View mick's Profile") Topic Author - [ Offline](/forum/user/2865-mick) Less More - Posts: 23 - Thank you received: 0 - - 15 years 4 months ago [\#18508](#18508) by [mick](/forum/user/2865-mick "View mick's Profile") Replied by *[mick](/forum/user/2865-mick "View mick's Profile")* on topic *[Re: Product Details after checkout!](/forum/2-general-talk-about-hikashop/18455-product-details-after-checkout#18508 "I m using Hikashop in joomla 1.6.I am having an extra cost on user choice which adds to the product full price. i am succesful in getting user response from a drop down where in user can say yes or no...")* have upgraded to new version...help-> update ...downloaded n installed without uninstalling ealier one. it showed version at the footer 'HikaShop Starter 1.5.1, Joomla!™ Shopping Cart Extension' but cant notice custom filed chnge...is that the right way to upgrade..? thnkx Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzE4NDU1LXByb2R1Y3QtZGV0YWlscy1hZnRlci1jaGVja291dD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86316 - Thank you received: 14276 - - 15 years 4 months ago [\#18513](#18513) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Product Details after checkout!](/forum/2-general-talk-about-hikashop/18455-product-details-after-checkout#18513 "I m using Hikashop in joomla 1.6.I am having an extra cost on user choice which adds to the product full price. i am succesful in getting user response from a drop down where in user can say yes or no...")* Custom fields of the table "item" are only available in the Business edition of HikaShop. Upgrading means going from one edition to another. Updating means going form one version of an edition to another. So you have the latest version of the Starter edition which doesn't enable you to do that. That's normal. You can get the Business edition on that page: [ www.hikashop.com/en/hikashop/business.html](http://www.hikashop.com/en/hikashop/business.html) HikaShop gets the information from the order and sends it to authorize.net in the function onAfterOrderConfirm, so that's the one you're looking for. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzE4NDU1LXByb2R1Y3QtZGV0YWlscy1hZnRlci1jaGVja291dD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mick](/forum/user/2865-mick "View mick's Profile")** - [![mick's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/duck.gif)](/forum/user/2865-mick "View mick's Profile") Topic Author - [ Offline](/forum/user/2865-mick) Less More - Posts: 23 - Thank you received: 0 - - 15 years 4 months ago [\#18593](#18593) by [mick](/forum/user/2865-mick "View mick's Profile") Replied by *[mick](/forum/user/2865-mick "View mick's Profile")* on topic *[Re: Product Details after checkout!](/forum/2-general-talk-about-hikashop/18455-product-details-after-checkout#18593 "I m using Hikashop in joomla 1.6.I am having an extra cost on user choice which adds to the product full price. i am succesful in getting user response from a drop down where in user can say yes or no...")* thkns, Sorry but order table has my value i somehow found that, and onAfterOrderConfirm function too ...but where only five values are printed...on payement page... thnks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzE4NDU1LXByb2R1Y3QtZGV0YWlscy1hZnRlci1jaGVja291dD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86316 - Thank you received: 14276 - - 15 years 4 months ago [\#18598](#18598) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Product Details after checkout!](/forum/2-general-talk-about-hikashop/18455-product-details-after-checkout#18598 "I m using Hikashop in joomla 1.6.I am having an extra cost on user choice which adds to the product full price. i am succesful in getting user response from a drop down where in user can say yes or no...")* I don't understand your problem. Could you explain more ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzE4NDU1LXByb2R1Y3QtZGV0YWlscy1hZnRlci1jaGVja291dD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mick](/forum/user/2865-mick "View mick's Profile")** - [![mick's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/duck.gif)](/forum/user/2865-mick "View mick's Profile") Topic Author - [ Offline](/forum/user/2865-mick) Less More - Posts: 23 - Thank you received: 0 - - 15 years 4 months ago [\#18689](#18689) by [mick](/forum/user/2865-mick "View mick's Profile") Replied by *[mick](/forum/user/2865-mick "View mick's Profile")* on topic *[Re: Product Details after checkout!](/forum/2-general-talk-about-hikashop/18455-product-details-after-checkout#18689 "I m using Hikashop in joomla 1.6.I am having an extra cost on user choice which adds to the product full price. i am succesful in getting user response from a drop down where in user can say yes or no...")* Hello, Screen shot for authorize.net in previous post has the product information like description,product name,qty..etc. i want to know that from where this data is going? which is the file....data coming from order table i know but it has lot more fields...how it is sending only these 5 fields...i will add my extra cost there ...as i have it in order table.... Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzE4NDU1LXByb2R1Y3QtZGV0YWlscy1hZnRlci1jaGVja291dD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86316 - Thank you received: 14276 - - 15 years 4 months ago [\#18707](#18707) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Product Details after checkout!](/forum/2-general-talk-about-hikashop/18455-product-details-after-checkout#18707 "I m using Hikashop in joomla 1.6.I am having an extra cost on user choice which adds to the product full price. i am succesful in getting user response from a drop down where in user can say yes or no...")* That's an authorize.net page. You can't change the number of columns. The data of these lines are generated in the function _loadStandardVars in the foreach: foreach($order->cart->products as $product){ on the line: $vars["x_line_item"][]=substr($product->order_product_code,0,30).'<|>'.substr($product->order_product_name,0,30).'<|><|>'.$product->order_product_quantity.'<|>'.round($product->order_product_price,(int)$currency->currency_locale).'<|>'.$has_tax; Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzE4NDU1LXByb2R1Y3QtZGV0YWlscy1hZnRlci1jaGVja291dD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mick](/forum/user/2865-mick "View mick's Profile")** - [![mick's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/duck.gif)](/forum/user/2865-mick "View mick's Profile") Topic Author - [ Offline](/forum/user/2865-mick) Less More - Posts: 23 - Thank you received: 0 - - 15 years 4 months ago [\#18713](#18713) by [mick](/forum/user/2865-mick "View mick's Profile") Replied by *[mick](/forum/user/2865-mick "View mick's Profile")* on topic *[Re: Product Details after checkout!](/forum/2-general-talk-about-hikashop/18455-product-details-after-checkout#18713 "I m using Hikashop in joomla 1.6.I am having an extra cost on user choice which adds to the product full price. i am succesful in getting user response from a drop down where in user can say yes or no...")* it shows no effect if i add my value..tried commenting that code than also it takes data.... Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzE4NDU1LXByb2R1Y3QtZGV0YWlscy1hZnRlci1jaGVja291dD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86316 - Thank you received: 14276 - - 15 years 4 months ago [\#18724](#18724) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Product Details after checkout!](/forum/2-general-talk-about-hikashop/18455-product-details-after-checkout#18724 "I m using Hikashop in joomla 1.6.I am having an extra cost on user choice which adds to the product full price. i am succesful in getting user response from a drop down where in user can say yes or no...")* If you remove that line, it's impossible that authorize display the order details as it won't know it. You can't just add new info at the end... You need to add your data in the existing fields. Authorize.net does not allow you to add new columns to that table. We can't do nothing about that. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzE4NDU1LXByb2R1Y3QtZGV0YWlscy1hZnRlci1jaGVja291dD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mick](/forum/user/2865-mick "View mick's Profile")** - [![mick's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/duck.gif)](/forum/user/2865-mick "View mick's Profile") Topic Author - [ Offline](/forum/user/2865-mick) Less More - Posts: 23 - Thank you received: 0 - - 15 years 4 months ago [\#18726](#18726) by [mick](/forum/user/2865-mick "View mick's Profile") Replied by *[mick](/forum/user/2865-mick "View mick's Profile")* on topic *[Re: Product Details after checkout!](/forum/2-general-talk-about-hikashop/18455-product-details-after-checkout#18726 "I m using Hikashop in joomla 1.6.I am having an extra cost on user choice which adds to the product full price. i am succesful in getting user response from a drop down where in user can say yes or no...")* Thankx.... added my value to total...again where is this total price in screenshot....either guide to remove it or edit as above...total [ ![[img](http://www.hikashop.com/media/kunena/attachments/legacy/images/test-20110614.png) ](http://www.hikashop.com/media/kunena/attachments/legacy/images/test-20110614.png "[img") - [ ![test-20110614.png](/forum/attachment/1279) ](/forum/attachment/1279 "test-20110614.png") [ ](/forum/attachment/1279?download=1 "test-20110614.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzE4NDU1LXByb2R1Y3QtZGV0YWlscy1hZnRlci1jaGVja291dD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86316 - Thank you received: 14276 - - 15 years 4 months ago [\#18730](#18730) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Product Details after checkout!](/forum/2-general-talk-about-hikashop/18455-product-details-after-checkout#18730 "I m using Hikashop in joomla 1.6.I am having an extra cost on user choice which adds to the product full price. i am succesful in getting user response from a drop down where in user can say yes or no...")* The total is set in the line: "x_amount" => round($order->cart->full_total->prices[0]->price_value_with_tax,(int)$currency->currency_locale), Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzE4NDU1LXByb2R1Y3QtZGV0YWlscy1hZnRlci1jaGVja291dD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mick](/forum/user/2865-mick "View mick's Profile")** - [![mick's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/duck.gif)](/forum/user/2865-mick "View mick's Profile") Topic Author - [ Offline](/forum/user/2865-mick) Less More - Posts: 23 - Thank you received: 0 - - 15 years 4 months ago [\#18735](#18735) by [mick](/forum/user/2865-mick "View mick's Profile") Replied by *[mick](/forum/user/2865-mick "View mick's Profile")* on topic *[Re: Product Details after checkout!](/forum/2-general-talk-about-hikashop/18455-product-details-after-checkout#18735 "I m using Hikashop in joomla 1.6.I am having an extra cost on user choice which adds to the product full price. i am succesful in getting user response from a drop down where in user can say yes or no...")* Thanks tried adding static value here... "x_amount" => round($order->cart->full_total->prices[0]->price_value_with_tax+'10',(int)$currency->currency_locale) no resluts...my value is here $product->cart_product_support ; guide how to add it so that is shows in total....have used same to add extra cost in items total.. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzE4NDU1LXByb2R1Y3QtZGV0YWlscy1hZnRlci1jaGVja291dD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86316 - Thank you received: 14276 - - 15 years 4 months ago [\#18741](#18741) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Product Details after checkout!](/forum/2-general-talk-about-hikashop/18455-product-details-after-checkout#18741 "I m using Hikashop in joomla 1.6.I am having an extra cost on user choice which adds to the product full price. i am succesful in getting user response from a drop down where in user can say yes or no...")* $product does not exists there since you're not in a products foreach. You need to calculate the total of your products support price before that, and then add it to the total. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzE4NDU1LXByb2R1Y3QtZGV0YWlscy1hZnRlci1jaGVja291dD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mick](/forum/user/2865-mick "View mick's Profile")** - [![mick's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/duck.gif)](/forum/user/2865-mick "View mick's Profile") Topic Author - [ Offline](/forum/user/2865-mick) Less More - Posts: 23 - Thank you received: 0 - - 15 years 4 months ago [\#18798](#18798) by [mick](/forum/user/2865-mick "View mick's Profile") Replied by *[mick](/forum/user/2865-mick "View mick's Profile")* on topic *[Re: Product Details after checkout!](/forum/2-general-talk-about-hikashop/18455-product-details-after-checkout#18798 "I m using Hikashop in joomla 1.6.I am having an extra cost on user choice which adds to the product full price. i am succesful in getting user response from a drop down where in user can say yes or no...")* i am unable to add to calculate it ....either explain where to add or just remove it as total is displayed above no need for it again....plzz have added in classes/order.php like this $order->products[$k]->order_product_total_price_no_vat = ($product->order_product_price+$product->order_product_support)*$product->order_product_quantity; i cn see in cart.php & currenct.php total is calcualting don't know where to add exactly... Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzE4NDU1LXByb2R1Y3QtZGV0YWlscy1hZnRlci1jaGVja291dD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mick](/forum/user/2865-mick "View mick's Profile")** - [![mick's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/duck.gif)](/forum/user/2865-mick "View mick's Profile") Topic Author - [ Offline](/forum/user/2865-mick) Less More - Posts: 23 - Thank you received: 0 - - 15 years 4 months ago [\#18799](#18799) by [mick](/forum/user/2865-mick "View mick's Profile") Replied by *[mick](/forum/user/2865-mick "View mick's Profile")* on topic *[Re: Product Details after checkout!](/forum/2-general-talk-about-hikashop/18455-product-details-after-checkout#18799 "I m using Hikashop in joomla 1.6.I am having an extra cost on user choice which adds to the product full price. i am succesful in getting user response from a drop down where in user can say yes or no...")* how order table is getting values can't find insert query for it.. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzE4NDU1LXByb2R1Y3QtZGV0YWlscy1hZnRlci1jaGVja291dD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86316 - Thank you received: 14276 - - 15 years 4 months ago [\#18830](#18830) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Product Details after checkout!](/forum/2-general-talk-about-hikashop/18455-product-details-after-checkout#18830 "I m using Hikashop in joomla 1.6.I am having an extra cost on user choice which adds to the product full price. i am succesful in getting user response from a drop down where in user can say yes or no...")* You should do like that: $support = 0; foreach($order->cart->products as $product){ $support+=$product->order_product_support; } at the beginning of the function _loadStandardVars Then you could simply have: "x_amount" => round($order->cart->full_total->prices[0]->price_value_with_tax+$support,(int)$currency->currency_locale), There is no insert query for data in HikaShop. It's done automatically with the hikashopClass class functions in administrator/components/com_hikashop/helpers/helper.php. The data of the order is given to it in components/com_hikashop/controllers/checkout.php in the function after_confirm. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzE4NDU1LXByb2R1Y3QtZGV0YWlscy1hZnRlci1jaGVja291dD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mick](/forum/user/2865-mick "View mick's Profile")** - [![mick's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/duck.gif)](/forum/user/2865-mick "View mick's Profile") Topic Author - [ Offline](/forum/user/2865-mick) Less More - Posts: 23 - Thank you received: 0 - - 15 years 4 months ago [\#18836](#18836) by [mick](/forum/user/2865-mick "View mick's Profile") Replied by *[mick](/forum/user/2865-mick "View mick's Profile")* on topic *[Re: Product Details after checkout!](/forum/2-general-talk-about-hikashop/18455-product-details-after-checkout#18836 "I m using Hikashop in joomla 1.6.I am having an extra cost on user choice which adds to the product full price. i am succesful in getting user response from a drop down where in user can say yes or no...")* order_product_support this field is in order_product not in order table will the code u gave will work fine Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzE4NDU1LXByb2R1Y3QtZGV0YWlscy1hZnRlci1jaGVja291dD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.237 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)