1

I am using M2E Pro and sometimes Magento shows me an error stating that invoice or shipment is not created.

Error for invoice creation: Invoice was not created. Reason: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '53000000066' for key 'UNQ_SALES_FLAT_INVOICE_INCREMENT_ID'

Error for Shipment creation: Shipment was not created. Reason: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '53000000001' for key 'UNQ_SALES_FLAT_SHIPMENT_INCREMENT_ID'

May I please know how can I solve these errors?

closed as off-topic by Raphael at Digital Pianism, Fabian Schmengler, Qaisar Satti, philwinkle Apr 22 '16 at 19:52

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions about third-party modules are generally off-topic because the scope of functionality and code are not available. For more information, see this meta post/answer." – Raphael at Digital Pianism, Fabian Schmengler, Qaisar Satti, philwinkle
If this question can be reworded to fit the rules in the help center, please edit the question.

  • This looks like a server resource error, regardless you should open a ticket with M2E – brentwpeterson Jul 9 '14 at 13:54
  • This may or may not be an issue with M2E. I've asked them for input. – benmarks Mar 1 '15 at 20:25
3

This error is not related to M2E Pro, but to the state of the data in the database. It looks like increment ID is not valid, because of some activity.

This issue might appear if you use Fooman's SameOrderInvoiceNumber extension or have made a migration of your site to another hosting recently.

Please check this post about how to fix this issue here: http://www.elevateweb.co.uk/magento-ecommerce/magento-error-creating-orders-unq_sales_flat_invoice_increment_id

Not the answer you're looking for? Browse other questions tagged or ask your own question.