My last Order ID is 16777215 and I cannot successfully place any new orders in CS-Cart Print

  • 4

This is caused because the "Initial order ID" setting value in Admin --> Administration --> Settings--> General is set greater than 16777215.
Due to the field type used for orders in the database (MEDIUM INT, 8), the highest # that this field can handle is 16777215.

To fix this issue:

  1. Delete the order with ID: 16777215
  2. In CS-Cart, update the "Initial order ID" setting value in Admin --> Administration --> Settings--> General to a # significantly lower than 16777215.
  3. In phpMyAdmin or whatever database management tool available on your hosting account, run the following queries on your CS-Cart database:
    ALTER TABLE `cscart_orders` AUTO_INCREMENT=$Initial order ID
    ALTER TABLE `cscart_new_orders` AUTO_INCREMENT=$Initial order ID

    Notes:
    - in the above queries, you will replace "$Initial order ID" with the new value in the settings for "Initial order ID"
    Example: ALTER TABLE `cscart_orders` AUTO_INCREMENT=122345
    - the table names may vary from "cscart_" shown above, depending upon how CS-Cart was configured during the install. You may need to update these queries with the correct table names to match your database.
  4. Place a test order and configure that the new order uses the Order ID that you specified for "Initial order ID".

Was this answer helpful?

« Back