Start counting "id_cart" not from zero but from number 1500

[Artemis909]

Hi,

 

it is possible to change start value of id_cart to start not from zero but from 1500 for example? Increment will be same so +1.

 

In database ps_cart I have manually change last id-cart to 1500 but when new order is made, Presta somehow know that last order was (for example) 37, so Presta set new id_cart to 38 and just ignore last manually added value 1500.

 

Is there some way to persuade Prestashop to count id_cart value not from zero ?

 

We are speaking about PS 1.6.0.9

 

 

[NemoPS]

You have to set the auto increment value in the table to 1500

 

 

ALTER TABLE ps_cart AUTO_INCREMENT = 1500

[Artemis909]

Yes, this is no problem but it is some kind of dirty solution in my opinion. But at the moment do not have better. 

[NemoPS]

Well no, it's not a dirty solution, it's the only way. Unless you want to create 1499 carts

[viscaro]

Thanks for this topic and for the answer. Where can I find the table to modify? In phpMyAdmin?

[NemoPS]

yes, it's ps_cart, or whatever prefix you use

[viscaro]

Thanks for your reply.

I tried, but there's no field where I can put the starting number. There's only "Autoincrement" and a flag activate or deactivate it

[NemoPS]

You need to run that query in the sql tab

[viscaro]

Sorry, but it didn't work. I tried many times, but I must be wrong somewhere.
I go to ps_cart, I click con SQl tab, type ALTER TABLE ps_cart AUTO_INCREMENT = 1500 but...nothing changes

[NemoPS]

So when you create a new cart it doesn't start from 1500? Do you get a confirmation after running the query?

[viscaro]

It says that the query was successful.
Now, if I go in the "operation" tab that's what I see: "Auto increment 1504", but a new order will start again from 39...

I send you a screenshot in attachment

[viscaro]

Ok, I did it!
The solution was to change both ps_orders and ps_cart.

Thank you so much for helping