unflatpack Posted January 13, 2014 Share Posted January 13, 2014 Hi all, hope someone who knows the PS database structure can help me.We have a 'bridge' that copies order data from the PS database directly into our CMS. THis works great for most items.We have some items that have text fields from the Customisation feature. I cant find where this data is stored and how it is referenced to an order ID. If someone could explain the structure to me I would be very grateful. I am using 1.5.4. Thanks John Link to comment Share on other sites More sharing options...
stottycabanas Posted January 14, 2014 Share Posted January 14, 2014 Hi John, Look for the tables ps_customiz* - there are four of them. Looks like the link is via id_cart, a column in ps_customization. Cheers, Dave Link to comment Share on other sites More sharing options...
unflatpack Posted January 14, 2014 Author Share Posted January 14, 2014 Dave you are a star. thanks for that. Link to comment Share on other sites More sharing options...
stottycabanas Posted January 14, 2014 Share Posted January 14, 2014 No problem. If that answers your query, you can mark the topic as 'Solved'. Thanks, Dave 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