- Posts: 28
- Thank you received: 0
Private sales
14 years 9 months ago #33945
by jerome-b
Private sales was created by jerome-b
Hello Hikashop guys,
What do you think about this feature request :
Another kind of categories like manufacturers : sales with a "start date" and an "end date"... for privates sales...
Regards,
Jérôme
What do you think about this feature request :
Another kind of categories like manufacturers : sales with a "start date" and an "end date"... for privates sales...
Regards,
Jérôme
Please Log in or Create an account to join the conversation.
14 years 8 months ago #34000
by nicolas
Replied by nicolas on topic Re: Private sales
Hi,
There is already a start and end date for each product.
The manufacturer id is directly in the product table so you could really easily change the start/end date of all the products of a manufacturer with one MySQL query run in your phpmyadmin. Something like that:
UPDATE jos_hikashop_product SET product_sale_start=X, product_sale_end=Y WHERE product_manufacturer_id=Z;
where X and Y are dates in the unix timestamp format www.google.com/search?sourceid=chrome&ie...&q=date+to+timestamp and Z the id of the manufacturer.
There is already a start and end date for each product.
The manufacturer id is directly in the product table so you could really easily change the start/end date of all the products of a manufacturer with one MySQL query run in your phpmyadmin. Something like that:
UPDATE jos_hikashop_product SET product_sale_start=X, product_sale_end=Y WHERE product_manufacturer_id=Z;
where X and Y are dates in the unix timestamp format www.google.com/search?sourceid=chrome&ie...&q=date+to+timestamp and Z the id of the manufacturer.
Please Log in or Create an account to join the conversation.
14 years 8 months ago #35396
by jerome-b
Replied by jerome-b on topic Re: Private sales
Great idea...
I 've made a little script for my customers...
Thanks
Jérôme
I 've made a little script for my customers...
Thanks
Jérôme
Please Log in or Create an account to join the conversation.
Time to create page: 0.209 seconds