- Posts: 240
- Thank you received: 13
Order Number code
1 year 2 months ago #367831
by khashiz
Order Number code was created by khashiz
-- HikaShop version -- : 6.0.0
-- Joomla version -- : 5.3.2
-- PHP version -- : 8.1
how can i set my order code generation number to start with 100001 (not 000001)
-- Joomla version -- : 5.3.2
-- PHP version -- : 8.1
how can i set my order code generation number to start with 100001 (not 000001)
Please Log in or Create an account to join the conversation.
1 year 2 months ago #367832
by nicolas
Replied by nicolas on topic Order Number code
Hi,
Go in your PHPMyAdmin and change the auto_increment of the hikashop_order table to 100000
Next order will be 100001 automatically.
stackoverflow.com/questions/5665571/auto...rement-in-phpmyadmin
Go in your PHPMyAdmin and change the auto_increment of the hikashop_order table to 100000
Next order will be 100001 automatically.
stackoverflow.com/questions/5665571/auto...rement-in-phpmyadmin
The following user(s) said Thank You: khashiz
Please Log in or Create an account to join the conversation.
11 months 2 days ago #369106
by khashiz
Replied by khashiz on topic Order Number code
can i do the same for product codes ?
i want each product code be a number like 1001, 1002, 1003 and so on
i want each product code be a number like 1001, 1002, 1003 and so on
Please Log in or Create an account to join the conversation.
11 months 1 day ago #369116
by nicolas
Replied by nicolas on topic Order Number code
Hi,
The product code is not generated by HikaShop. It's something you can enter in the "product code" input field of each product. So you can use the format you want without changing anything in HikaShop.
The product code is not generated by HikaShop. It's something you can enter in the "product code" input field of each product. So you can use the format you want without changing anything in HikaShop.
Please Log in or Create an account to join the conversation.
11 months 1 day ago #369117
by khashiz
Replied by khashiz on topic Order Number code
I know
this is exactly what i want to do ... to create the product codes automaticly
somthing like auto increament of product ids
this is exactly what i want to do ... to create the product codes automaticly
somthing like auto increament of product ids
Please Log in or Create an account to join the conversation.
11 months 17 hours ago #369118
by nicolas
Replied by nicolas on topic Order Number code
Hi,
Then, you can create a massaction with triggers "when product is created" and "when product is updated" and an action "update the values" on the "product_code" column with the mode "operation" and the value: product.product_id
This way, the product code will get the id of the product as value automatically.
Then, you can create a massaction with triggers "when product is created" and "when product is updated" and an action "update the values" on the "product_code" column with the mode "operation" and the value: product.product_id
This way, the product code will get the id of the product as value automatically.
The following user(s) said Thank You: khashiz
Please Log in or Create an account to join the conversation.
Time to create page: 0.207 seconds