shipment# increments

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
4 年 前
Hi,

I am trying to find where about's in the database that i can increment the Shipment # so its not on number 5 and only incrementing by 1 every time.

So i need to the increment the shipment number on every order that is raised, like order 123 with shipment no #3234 and the next order 1234 with shipment no say an increment of 20 becomes 3254, in this admin panel page https://somedomain.com/Admin/Order/Edit/3968926

I have looked in the locale resource string in the admin panel of NopCommerce 4.20 but i can only edit the wording and not anything else.

I have looked in the db but cannot find anything.

Regards
4 年 前
garrie007 wrote:
Hi,

I am trying to find where about's in the database that i can increment the Shipment # so its not on number 5 and only incrementing by 1 every time.

So i need to the increment the shipment number on every order that is raised, like order 123 with shipment no #3234 and the next order 1234 with shipment no say an increment of 20 becomes 3254, in this admin panel page https://somedomain.com/Admin/Order/Edit/3968926

I have looked in the locale resource string in the admin panel of NopCommerce 4.20 but i can only edit the wording and not anything else.

I have looked in the db but cannot find anything.

Regards


There is Auto-increment Identity key on Id column of Shipment table.

You need to do some customization and also you need to remove that auto-increment values from db.
4 年 前
SuperNopCommerce wrote:


There is Auto-increment Identity key on Id column of Shipment table.

You need to do some customization and also you need to remove that auto-increment values from db.


Thank you very much.
4 年 前
You can reset the next/starting number as per this topic/example
https://www.nopcommerce.com/boards/topic/36237/editing-shipment-number-to-be-same-as-order-number

But due note that SQL Server, when it restarts, will increase the next sequence number to use  (e.g. add 1000 to it).

As per above,  having it be some specific value requires customization.
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.