socks Posted February 10, 2015 Share Posted February 10, 2015 Hi, I'm looking to duplicate an order wholesale, with no changes. I Investigated a little, and it seems like the order details are stored in multiple tables, as shown below: psc_orders psc_order_carrier psc_order_cart_rule psc_order_detail psc_order_detail_tax psc_order_history psc_order_invoice psc_order_invoice_payment psc_order_invoice_tax psc_order_message psc_order_message_lang psc_order_payment Is this correct? If so, then I can probably just do a quick sql command to copy it to a new row. I just need to confirm it. In the meantime, I'll do some testing. Link to comment Share on other sites More sharing options...
tuk66 Posted February 13, 2015 Share Posted February 13, 2015 You need not one SQL query, but many queries. I would use a PHP script. Link to comment Share on other sites More sharing options...
socks Posted February 16, 2015 Author Share Posted February 16, 2015 Noted, assuming those are the correct tables, it shouldn't be too hard to do a quick and dirty php script the duplicate orders using an ID. If it works, I'll just drop the script here for other people to use. 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