[Skip to main content](#vessel-content) # Map Fields From Add Item To Back End Database Fields ## - **[jo15765](/forum/user/49997-jo15765 "View jo15765's Profile")** - [![jo15765's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/49997-jo15765 "View jo15765's Profile") Topic Author - [ Offline](/forum/user/49997-jo15765) Less More - Posts: 4 - Thank you received: 0 - - 9 years 3 months ago [\#275231](#275231) by [jo15765](/forum/user/49997-jo15765 "View jo15765's Profile") *[Map Fields From Add Item To Back End Database Fields](/forum/2-general-talk-about-hikashop/891385-map-fields-from-add-item-to-back-end-database-fields#275231 "Good day to all, I have been attempting to map fields from the front end add product page to the corresponding back-end database tables. The fields that I am stuck on, are under the Prices and Taxes...")* was created by *[jo15765](/forum/user/49997-jo15765 "View jo15765's Profile")* Good day to all, I have been attempting to map fields from the front end add product page to the corresponding back-end database tables. The fields that I am stuck on, are under the Prices and Taxes header, and they are (well the black text) Tax Category: Retail Price: Then under Restrictions: Price Price with tax Currency Quantity To this point everything I have been looking for is located in the hikashop_Product table, but the fields in questoin above do not seem to be. I have also looked at the hikashop_tax & hikashop_tabable table to no avail. Where do the above fields map to? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg5MTM4NS1tYXAtZmllbGRzLWZyb20tYWRkLWl0ZW0tdG8tYmFjay1lbmQtZGF0YWJhc2UtZmllbGRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 9 years 3 months ago [\#275246](#275246) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Map Fields From Add Item To Back End Database Fields](/forum/2-general-talk-about-hikashop/891385-map-fields-from-add-item-to-back-end-database-fields#275246 "Good day to all, I have been attempting to map fields from the front end add product page to the corresponding back-end database tables. The fields that I am stuck on, are under the Prices and Taxes...")* Hello, The retail price is also called "msrp" ; that's under that name that you'll find the field. The prices are stored in a specific table (hikashop_price) and you won't find the price with tax which is generated dynamically depending the product tax id. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg5MTM4NS1tYXAtZmllbGRzLWZyb20tYWRkLWl0ZW0tdG8tYmFjay1lbmQtZGF0YWJhc2UtZmllbGRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[jo15765](/forum/user/49997-jo15765 "View jo15765's Profile")** - [![jo15765's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/49997-jo15765 "View jo15765's Profile") Topic Author - [ Offline](/forum/user/49997-jo15765) Less More - Posts: 4 - Thank you received: 0 - - 9 years 2 months ago [\#276019](#276019) by [jo15765](/forum/user/49997-jo15765 "View jo15765's Profile") Replied by *[jo15765](/forum/user/49997-jo15765 "View jo15765's Profile")* on topic *[Map Fields From Add Item To Back End Database Fields](/forum/2-general-talk-about-hikashop/891385-map-fields-from-add-item-to-back-end-database-fields#276019 "Good day to all, I have been attempting to map fields from the front end add product page to the corresponding back-end database tables. The fields that I am stuck on, are under the Prices and Taxes...")* > Jerome wrote: Hello, > > The retail price is also called "msrp" ; that's under that name that you'll find the field. > The prices are stored in a specific table (hikashop\_price) and you won't find the price with tax which is generated dynamically depending the product tax id. > > Regards, Thank you for the response. my hikashop_price table is empty?! Could there be a diff location where this information is stored? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg5MTM4NS1tYXAtZmllbGRzLWZyb20tYWRkLWl0ZW0tdG8tYmFjay1lbmQtZGF0YWJhc2UtZmllbGRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 9 years 2 months ago [\#276022](#276022) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Map Fields From Add Item To Back End Database Fields](/forum/2-general-talk-about-hikashop/891385-map-fields-from-add-item-to-back-end-database-fields#276022 "Good day to all, I have been attempting to map fields from the front end add product page to the corresponding back-end database tables. The fields that I am stuck on, are under the Prices and Taxes...")* Hello, If your HikaShop price table is empty it means that you did not configure any price for your HikaShop products. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg5MTM4NS1tYXAtZmllbGRzLWZyb20tYWRkLWl0ZW0tdG8tYmFjay1lbmQtZGF0YWJhc2UtZmllbGRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) 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.072 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)