Hi,
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.