[Skip to main content](#vessel-content) # Asking for a quote of HikaShop customization project. ## - **[ranthongs.com](/forum/user/57373-ranthongs-com "View ranthongs.com's Profile")** - [![ranthongs.com's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/57373-ranthongs-com "View ranthongs.com's Profile") Topic Author - [ Offline](/forum/user/57373-ranthongs-com) Less More - Posts: 1 - Thank you received: 0 - - 8 years 4 weeks ago [\#299132](#299132) by [ranthongs.com](/forum/user/57373-ranthongs-com "View ranthongs.com's Profile") *[Asking for a quote of HikaShop customization project.](/forum/9-commercial-jobs/895966-asking-for-a-quote-of-hikashop-customization-project#299132 "-- HikaShop version -- : 3.5.1 -- Joomla version -- : 3.8.13 -- PHP version -- : 7.1.18 -- Browser(s) name and version -- : all Subject: Asking for a quote of HikaShop customization project. System Information HikaShop version--: 3.5.1 Joomla version--: 3.8.13 PHP version--: 7.1.18 Database Version--:5.6.39-cll-lve Browser(s) name and version--: All Hosting--:Shared I would like to have an option to automatically input both Retail price and Price by writing php script to retrieve referential prices from my local mysql data base. These prices must have a place holder to hold these retrieved price for price calculation before filling in product price field. For more understanding, I also enclose two images coming along with explanations step by step. Step 1 At product page, choose automatically instead of default manually located near price field. Step 2 Under specification window, click “Plus Button” to add the third referential price. Name the field. Let say “Offering” for this example. Write php script in Value field, fill in both caption and description. And then click OK button for saving. Step 3 Click on Calculation tab (This calculation tab is supposed to be shown up after clicking OK button at step 2). Click the drop down on the left of equal symbol to pick up an exist field or write the new one such as “Price before tax” and write calculation formula on the right of equal symbol. And then click “Save this calculation” button. Start over calculation formula writing process for “VAT”, and “Price” sequentially (as picture 2). Consequently, product’s price being come from these calculation methods should be shown up correctly at the front end. Also, I want the cron task to refresh these product prices.")* was created by *[ranthongs.com](/forum/user/57373-ranthongs-com "View ranthongs.com's Profile")* -- HikaShop version -- : 3.5.1 -- Joomla version -- : 3.8.13 -- PHP version -- : 7.1.18 -- Browser(s) name and version -- : all Subject: Asking for a quote of HikaShop customization project. System Information HikaShop version--: 3.5.1 Joomla version--: 3.8.13 PHP version--: 7.1.18 Database Version--:5.6.39-cll-lve Browser(s) name and version--: All Hosting--:Shared I would like to have an option to automatically input both Retail price and Price by writing php script to retrieve referential prices from my local mysql data base. These prices must have a place holder to hold these retrieved price for price calculation before filling in product price field. For more understanding, I also enclose two images coming along with explanations step by step. Step 1 At product page, choose automatically instead of default manually located near price field. Step 2 Under specification window, click “Plus Button” to add the third referential price. Name the field. Let say “Offering” for this example. Write php script in Value field, fill in both caption and description. And then click OK button for saving. Step 3 Click on Calculation tab (This calculation tab is supposed to be shown up after clicking OK button at step 2). Click the drop down on the left of equal symbol to pick up an exist field or write the new one such as “Price before tax” and write calculation formula on the right of equal symbol. And then click “Save this calculation” button. Start over calculation formula writing process for “VAT”, and “Price” sequentially (as picture 2). Consequently, product’s price being come from these calculation methods should be shown up correctly at the front end. Also, I want the cron task to refresh these product prices. - [ ![dev1.png](/forum/attachment/45097) ](/forum/attachment/45097 "dev1.png") [ ](/forum/attachment/45097?download=1 "dev1.png") - [ ![dev2.png](/forum/attachment/45098) ](/forum/attachment/45098 "dev2.png") [ ](/forum/attachment/45098?download=1 "dev2.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzktY29tbWVyY2lhbC1qb2JzLzg5NTk2Ni1hc2tpbmctZm9yLWEtcXVvdGUtb2YtaGlrYXNob3AtY3VzdG9taXphdGlvbi1wcm9qZWN0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[brown12](/forum/user/55979-brown12 "View brown12's Profile")** - [![brown12's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/55979-brown12 "View brown12's Profile") - [ Offline](/forum/user/55979-brown12) Less More - Posts: 15 - Thank you received: 2 - - 8 years 4 weeks ago [\#299142](#299142) by [brown12](/forum/user/55979-brown12 "View brown12's Profile") Replied by *[brown12](/forum/user/55979-brown12 "View brown12's Profile")* on topic *[Asking for a quote of HikaShop customization project.](/forum/9-commercial-jobs/895966-asking-for-a-quote-of-hikashop-customization-project#299142 "-- HikaShop version -- : 3.5.1 -- Joomla version -- : 3.8.13 -- PHP version -- : 7.1.18 -- Browser(s) name and version -- : all Subject: Asking for a quote of HikaShop customization project. System Information HikaShop version--: 3.5.1 Joomla version--: 3.8.13 PHP version--: 7.1.18 Database Version--:5.6.39-cll-lve Browser(s) name and version--: All Hosting--:Shared I would like to have an option to automatically input both Retail price and Price by writing php script to retrieve referential prices from my local mysql data base. These prices must have a place holder to hold these retrieved price for price calculation before filling in product price field. For more understanding, I also enclose two images coming along with explanations step by step. Step 1 At product page, choose automatically instead of default manually located near price field. Step 2 Under specification window, click “Plus Button” to add the third referential price. Name the field. Let say “Offering” for this example. Write php script in Value field, fill in both caption and description. And then click OK button for saving. Step 3 Click on Calculation tab (This calculation tab is supposed to be shown up after clicking OK button at step 2). Click the drop down on the left of equal symbol to pick up an exist field or write the new one such as “Price before tax” and write calculation formula on the right of equal symbol. And then click “Save this calculation” button. Start over calculation formula writing process for “VAT”, and “Price” sequentially (as picture 2). Consequently, product’s price being come from these calculation methods should be shown up correctly at the front end. Also, I want the cron task to refresh these product prices.")* Hi, I can help. You can reach me on Skype: cisin.arnold or Email: arnold2@talentsfromindia.com so that we can discuss this further. Arnold Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzktY29tbWVyY2lhbC1qb2JzLzg5NTk2Ni1hc2tpbmctZm9yLWEtcXVvdGUtb2YtaGlrYXNob3AtY3VzdG9taXphdGlvbi1wcm9qZWN0P3RtcGw9bWFya2Rvd24=) 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.056 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)