Jump to content

How to access cart / Order content


riteman
 Share

Recommended Posts

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 etc

Hope somebody can point me to the right spot ..

Share this post


Link to post
Share on other sites

assume your DB table prefix default ps_, then

cart 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_ customer

The tables are linked by id.

You can find id_customer in ps_cart table and ps_order table

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More