Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Invoice Number & Order Id Change To Custom Number Rate Topic   - - - - -

 

Posted 28 June 2021 - 11:39 AM #1

Dear Community,

 

We have a new brand e-commerce where we finally almost ready to start selling to our customers, we  have an issues  where we need the first order to have an invoice number with 10 digits due to European (Bulgarian) law on e-commerce. So we need to change parameters on cs-cart so we are getting invoice numbers like 

0000000001

0000000002

0000000003

0000000004

 

Is this possible without buying an extra plug in ? We have tried all the possible solutions we found on the web. Looking now for more expert to see this. 

 

Any suggestions would be welcomed. 



 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 22192 posts

Posted 28 June 2021 - 01:18 PM #2

Looks like there is no ready to use addon with the required functionality

 

You can only set initial order number to 1000000001


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)

 

Posted 28 June 2021 - 06:06 PM #3

Looks like there is no ready to use addon with the required functionality

 

You can only set initial order number to 1000000001

Any thought how it can be made this function? at least like 1000000001 ?



 
  • Alt-team
  • CS-Cart Developer
  • Authorized Reseller
  • Join Date: 18-Jan 11
  • 2841 posts

Posted 29 June 2021 - 06:17 AM #4

Any thought how it can be made this function? at least like 1000000001 ?

Hello,

 

Check the PM. We have sent you a message about this feature. 

 

Best regards,

Alt-team.


ADD-ONS  Web development service  | CS-Cart dedicated developers

Buy MULTIVENDOR - USD 1250 (14% off)   Buy CS-CART LICENCE - USD 345 (13% off)

 Email - manager@alt-team.com | Skype - Altteam    


 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 22192 posts

Posted 29 June 2021 - 06:33 AM #5

Any thought how it can be made this function? at least like 1000000001 ?

 

Settings -> Checkout -> Initial order ID value


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)

 

Posted 29 June 2021 - 05:10 PM #6

Settings -> Checkout -> Initial order ID value

I am receiving 

 

WarningThe value you entered for the "Initial order ID value" setting is not supported. Only integers from 1 to 10000000 are supported


 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 12091 posts

Posted 29 June 2021 - 05:22 PM #7

Change the 'type' of order_id from mediumint( 8) to int(11) and it should work for you.  Be sure that it remains as "Unsigned".

 

Update mediumint 8

Stupid form code keeps changing it to a smiley face.


EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 22192 posts

Posted 30 June 2021 - 06:20 AM #8

Change the 'type' of order_id from mediumint( 8) to int(11) and it should work for you.  Be sure that it remains as "Unsigned".

 

Update mediumint 8

Stupid form code keeps changing it to a smiley face.

 

Not good solution since other related tables still will have mediumint(8) type for order id 

 

@contact@dytrading.us looks like it is not possible to solve your issue without additional changes in the structure of database


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)

 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 12091 posts

Posted 30 June 2021 - 04:21 PM #9

Yes, there are associated tables that use it as a key.  I should have mentioned it in my post....Of course you could change every table that uses a mediumint(8) to an int(11) without issue.


EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.