Items Id, Product Id's & Product Codes


Where can we find all our product ID's & Items ID. I need them to map fields for an addon that works with items ID instead of working with product ID/Product codes.

In which table of my DB can I find all this information ?

Thanks !

Product ID can be found in the cscart_products table

Item ID id generated on the fly. It takes into account product ID, selected options and additional parameters from addons. You can check the fn_generate_cart_id function in the app/addons/fn.cart.php file

The "items" in an order are located in the cscart_order_details table and are referenced by 'order_id'. For carts, they are in cscart_user_session_products.