(SOLVED) Extra items in PDF invoice

[batman42ca]

Has anyone seen this problem before? Look at the top 2 products in the image of the PDF invoice I generated. The top 2 products don't even exist in my store and they did not contribute to the total. How is this even possible? (I'm using Prestashop 1.5.5.0)

 

Edited January 6, 2014 by batman42ca (see edit history)

[bellini13]

have you attempted to delete orders in your store?  Perhaps orders that were created during a testing cycle?

[batman42ca]

have you attempted to delete orders in your store?  Perhaps orders that were created during a testing cycle?

 

Yes, but there is no way the orders I deleted could have included orders for those extra products by that customer. All the default products were removed long before a test purchase by that particular customer could have occurred.

[bellini13]

apparently not in this case.

 

If you do not delete every single record from the orders database tables, then orphaned records remain.  Then when you create new orders, the id_order value restarts from 1, and the old order products with the same id_order will show up.

 

Look at your database for the id_order in question and you will see for yourself.

[batman42ca]

It appears that the only order in the ps_orders database table is the one belonging to the picture in my original post, but other tables, such as ps_order_details and anything else starting with ps_orders, have records. It seems the plugin I used to delete the test orders was not very thorough.

 

Is it safe for me to empty all the ps_orders_* records (since I know there are no real orders yet)?

[batman42ca]

After a little more research, I've discovered that the method I used to delete test orders is known to be incomplete. Since there are no real orders yet anyway, I just used the Prestashop Cleaner plugin to remove all orders and all customers.

 

Thanks for your help bellini13

Edited January 6, 2014 by batman42ca (see edit history)

[bellini13]

yup, good find, the cleaner module was designed to remove all test data before launching the store, so seems you are on your way.  good luck

[leowls]

Is the module known as Prestashop Cleaner as below?

 

http://

[bellini13]

yes