Jump to content
thirty bees forum
  • 0

Back Office Sales per customer wrong after migration. Just affects split orders.

Ian Ashton


After migrating to TB 1.4 from PS 1.6.24 I noticed the Sales column in the Back Office Customer display was different from the corresponding Prestashop screen for a subset of customers. The TB total was greater than the PS total.

After investigating I noticed the 'problem' customers had split orders in the tb_orders table. i.e. two or more rows with the same order reference.

This means that there's a many to many relationship between tb_orders and tb_order_payment using tb_orders.reference and tb_order_payment.order_reference.

I'm not exactly sure under what circumstances split orders are created in TB or PS.

So is this a 'feature' of the database I've transitioned ( in which case I can live with it ) or does TB also create split orders under some circumstances? And if so will some totals also be wrong?

As far as I can see this only affect the Back office displays. 





Link to comment
Share on other sites

0 answers to this question

Recommended Posts

There have been no answers to this question yet

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
  • Create New...