Map Fields From Add Item To Back End Database Fields

  • Posts: 4
  • Thank you received: 0
7 years 4 months ago #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 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 or Create an account to join the conversation.

  • Posts: 26166
  • Thank you received: 4030
  • MODERATOR
7 years 4 months ago #275246

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.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 4
  • Thank you received: 0
7 years 4 months ago #276019

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 or Create an account to join the conversation.

  • Posts: 26166
  • Thank you received: 4030
  • MODERATOR
7 years 4 months ago #276022

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.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

Time to create page: 0.060 seconds
Powered by Kunena Forum