riteman Posted March 20, 2011 Share Posted March 20, 2011 I need to be able to access the Cart contents/orders and have looked into MySQL but not been able to find in what table(s) that informaqion is stored.Ideally I need the customer info and the information regarding ordered parts like PartID, Partdescription, no of units, price, discounts etcHope somebody can point me to the right spot .. Link to comment Share on other sites More sharing options...
shokinro Posted March 20, 2011 Share Posted March 20, 2011 assume your DB table prefix default ps_, thencart information should be in following tables ps_cart ps_cart_discount ps_cart_product order information should be in following tables ps_orders ps_order_detail ps_order_discount ps_order_history ps_order_history_latest ps_order_message ps_order_message_lang ps_order_return ps_order_return_detail ps_order_return_state ps_order_return_state_lang ps_order_slip ps_order_slip_detail customer information is in ps_ customerThe tables are linked by id.You can find id_customer in ps_cart table and ps_order table Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now