[Skip to main content](#vessel-content)

#  Profile for jaystore

##

[![jaystore's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31616-jaystore "View jaystore's Profile")

**[ Offline](/forum/user/31616-jaystore)**

- **User Type:** User

- **Register Date:** 11 Mar 2014
- **Last login:** 9 years 2 weeks ago
- **Time Zone:**  UTC +0:00
- **Local Time:** 17:48

- **Posts:** 8
- **Profile views:** 56

- **Gender:** Unknown
- **Birthdate:** Unknown

- Posts

#  jaystore's recent posts  (8 messages )

All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year     All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year

| <a id="forumtop"> </a> [  ](#forumbottom) | Subject | Replies / Views | Last Post | <a id="forumbottom"> </a> [   ](#forumtop) |
|---|---|---|---|---|
| [](/forum/4-how-to/890804-product-variant-price#272395) | [Product variant price](/forum/4-how-to/890804-product-variant-price#272395 "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.1  We have a product with 3 characterisrtics and generates 112 variants, we updated prices for all of them. Now we added a characteristic with 3 options and variants increased to 336, to update 224 variat prices is crazy, I looked ad DB tables and found how to select variants &quot;SELECT &#42; FROM &#96;jay&#95;hikashop&#95;product&#96; WHERE product&#95;parent&#95;id = 759&quot; but I don't know how to set prices using and UPDATE statement because I can't find where the prices are stored.  However the handling of variants is really time consuming every time we add something, it should be done in a diffenet way.")         Category: [How to?](/forum/4-how-to "If you didn't find the answer on our documentation neither on existing posts, please ask your question here.")     Topic started 9 years 4 months ago, by [jaystore](/forum/user/31616-jaystore "View jaystore's Profile")       [Last Post](/forum/4-how-to/890804-product-variant-price#272395 "As far as I understand Options are connected to products and for example the size is a characteristic and you could set different price for each size. Then we add 20 different colours and we have...") 9 years 4 months ago     by [jaystore](/forum/user/31616-jaystore "View jaystore's Profile") | Replies:3  Views:1563 | [Last Post](/forum/4-how-to/890804-product-variant-price#272395 "As far as I understand Options are connected to products and for example the size is a characteristic and you could set different price for each size. Then we add 20 different colours and we have...") by [jaystore](/forum/user/31616-jaystore "View jaystore's Profile")      9 years 4 months ago |
| [](/forum/4-how-to/890804-product-variant-price#272329) | [Product variant price](/forum/4-how-to/890804-product-variant-price#272329 "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.1  We have a product with 3 characterisrtics and generates 112 variants, we updated prices for all of them. Now we added a characteristic with 3 options and variants increased to 336, to update 224 variat prices is crazy, I looked ad DB tables and found how to select variants &quot;SELECT &#42; FROM &#96;jay&#95;hikashop&#95;product&#96; WHERE product&#95;parent&#95;id = 759&quot; but I don't know how to set prices using and UPDATE statement because I can't find where the prices are stored.  However the handling of variants is really time consuming every time we add something, it should be done in a diffenet way.")         Category: [How to?](/forum/4-how-to "If you didn't find the answer on our documentation neither on existing posts, please ask your question here.")     Topic started 9 years 4 months ago, by [jaystore](/forum/user/31616-jaystore "View jaystore's Profile")       [Last Post](/forum/4-how-to/890804-product-variant-price#272395 "As far as I understand Options are connected to products and for example the size is a characteristic and you could set different price for each size. Then we add 20 different colours and we have...") 9 years 4 months ago     by [jaystore](/forum/user/31616-jaystore "View jaystore's Profile") | Replies:3  Views:1563 | [Last Post](/forum/4-how-to/890804-product-variant-price#272395 "As far as I understand Options are connected to products and for example the size is a characteristic and you could set different price for each size. Then we add 20 different colours and we have...") by [jaystore](/forum/user/31616-jaystore "View jaystore's Profile")      9 years 4 months ago |
| [](/forum/4-how-to/890804-product-variant-price#272327) | [Product variant price](/forum/4-how-to/890804-product-variant-price#272327 "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.1  We have a product with 3 characterisrtics and generates 112 variants, we updated prices for all of them. Now we added a characteristic with 3 options and variants increased to 336, to update 224 variat prices is crazy, I looked ad DB tables and found how to select variants &quot;SELECT &#42; FROM &#96;jay&#95;hikashop&#95;product&#96; WHERE product&#95;parent&#95;id = 759&quot; but I don't know how to set prices using and UPDATE statement because I can't find where the prices are stored.  However the handling of variants is really time consuming every time we add something, it should be done in a diffenet way.")         Category: [How to?](/forum/4-how-to "If you didn't find the answer on our documentation neither on existing posts, please ask your question here.")     Topic started 9 years 4 months ago, by [jaystore](/forum/user/31616-jaystore "View jaystore's Profile")       [Last Post](/forum/4-how-to/890804-product-variant-price#272395 "As far as I understand Options are connected to products and for example the size is a characteristic and you could set different price for each size. Then we add 20 different colours and we have...") 9 years 4 months ago     by [jaystore](/forum/user/31616-jaystore "View jaystore's Profile") | Replies:3  Views:1563 | [Last Post](/forum/4-how-to/890804-product-variant-price#272395 "As far as I understand Options are connected to products and for example the size is a characteristic and you could set different price for each size. Then we add 20 different colours and we have...") by [jaystore](/forum/user/31616-jaystore "View jaystore's Profile")      9 years 4 months ago |
| [](/forum/35-orders-management/889516-invoice-number-not-reset-at-beginning-of-the-year#265973) | [Invoice number not reset at beginning of the year](/forum/35-orders-management/889516-invoice-number-not-reset-at-beginning-of-the-year#265973 "The invoice number was not reset at the beginning of the year as we have configured in Syste/Configutration/Order tab. We have to update manually the invoice number because it continues to calculate...")         Category: [Orders management](/forum/35-orders-management "You can ask here your questions about orders management")     Topic started 9 years 7 months ago, by [jaystore](/forum/user/31616-jaystore "View jaystore's Profile")       [Last Post](/forum/35-orders-management/889516-invoice-number-not-reset-at-beginning-of-the-year#266106 "Hi,  Well, I don't see how that's possible and I can't reproduce. Please provide a backend access, a FTP access and a PHPMyAdmin access (ideally of a copy of your website) so that we could debug the situation because I'm out of ideas here.  You can use our contact form to provide that along with a link to this thread:   www.hikashop.com/support/contact-us.html") 9 years 6 months ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:7  Views:814 | [Last Post](/forum/35-orders-management/889516-invoice-number-not-reset-at-beginning-of-the-year#266106 "Hi,  Well, I don't see how that's possible and I can't reproduce. Please provide a backend access, a FTP access and a PHPMyAdmin access (ideally of a copy of your website) so that we could debug the situation because I'm out of ideas here.  You can use our contact form to provide that along with a link to this thread:   www.hikashop.com/support/contact-us.html") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      9 years 6 months ago |
| [](/forum/35-orders-management/889516-invoice-number-not-reset-at-beginning-of-the-year#265968) | [Invoice number not reset at beginning of the year](/forum/35-orders-management/889516-invoice-number-not-reset-at-beginning-of-the-year#265968 "The invoice number was not reset at the beginning of the year as we have configured in Syste/Configutration/Order tab. We have to update manually the invoice number because it continues to calculate...")         Category: [Orders management](/forum/35-orders-management "You can ask here your questions about orders management")     Topic started 9 years 7 months ago, by [jaystore](/forum/user/31616-jaystore "View jaystore's Profile")       [Last Post](/forum/35-orders-management/889516-invoice-number-not-reset-at-beginning-of-the-year#266106 "Hi,  Well, I don't see how that's possible and I can't reproduce. Please provide a backend access, a FTP access and a PHPMyAdmin access (ideally of a copy of your website) so that we could debug the situation because I'm out of ideas here.  You can use our contact form to provide that along with a link to this thread:   www.hikashop.com/support/contact-us.html") 9 years 6 months ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:7  Views:814 | [Last Post](/forum/35-orders-management/889516-invoice-number-not-reset-at-beginning-of-the-year#266106 "Hi,  Well, I don't see how that's possible and I can't reproduce. Please provide a backend access, a FTP access and a PHPMyAdmin access (ideally of a copy of your website) so that we could debug the situation because I'm out of ideas here.  You can use our contact form to provide that along with a link to this thread:   www.hikashop.com/support/contact-us.html") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      9 years 6 months ago |
| [](/forum/35-orders-management/889516-invoice-number-not-reset-at-beginning-of-the-year#265945) | [Invoice number not reset at beginning of the year](/forum/35-orders-management/889516-invoice-number-not-reset-at-beginning-of-the-year#265945 "The invoice number was not reset at the beginning of the year as we have configured in Syste/Configutration/Order tab. We have to update manually the invoice number because it continues to calculate...")         Category: [Orders management](/forum/35-orders-management "You can ask here your questions about orders management")     Topic started 9 years 7 months ago, by [jaystore](/forum/user/31616-jaystore "View jaystore's Profile")       [Last Post](/forum/35-orders-management/889516-invoice-number-not-reset-at-beginning-of-the-year#266106 "Hi,  Well, I don't see how that's possible and I can't reproduce. Please provide a backend access, a FTP access and a PHPMyAdmin access (ideally of a copy of your website) so that we could debug the situation because I'm out of ideas here.  You can use our contact form to provide that along with a link to this thread:   www.hikashop.com/support/contact-us.html") 9 years 6 months ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:7  Views:814 | [Last Post](/forum/35-orders-management/889516-invoice-number-not-reset-at-beginning-of-the-year#266106 "Hi,  Well, I don't see how that's possible and I can't reproduce. Please provide a backend access, a FTP access and a PHPMyAdmin access (ideally of a copy of your website) so that we could debug the situation because I'm out of ideas here.  You can use our contact form to provide that along with a link to this thread:   www.hikashop.com/support/contact-us.html") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      9 years 6 months ago |
| [](/forum/35-orders-management/889516-invoice-number-not-reset-at-beginning-of-the-year#265901) | [Invoice number not reset at beginning of the year](/forum/35-orders-management/889516-invoice-number-not-reset-at-beginning-of-the-year#265901 "The invoice number was not reset at the beginning of the year as we have configured in Syste/Configutration/Order tab. We have to update manually the invoice number because it continues to calculate...")         Category: [Orders management](/forum/35-orders-management "You can ask here your questions about orders management")     Topic started 9 years 7 months ago, by [jaystore](/forum/user/31616-jaystore "View jaystore's Profile")       [Last Post](/forum/35-orders-management/889516-invoice-number-not-reset-at-beginning-of-the-year#266106 "Hi,  Well, I don't see how that's possible and I can't reproduce. Please provide a backend access, a FTP access and a PHPMyAdmin access (ideally of a copy of your website) so that we could debug the situation because I'm out of ideas here.  You can use our contact form to provide that along with a link to this thread:   www.hikashop.com/support/contact-us.html") 9 years 6 months ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:7  Views:814 | [Last Post](/forum/35-orders-management/889516-invoice-number-not-reset-at-beginning-of-the-year#266106 "Hi,  Well, I don't see how that's possible and I can't reproduce. Please provide a backend access, a FTP access and a PHPMyAdmin access (ideally of a copy of your website) so that we could debug the situation because I'm out of ideas here.  You can use our contact form to provide that along with a link to this thread:   www.hikashop.com/support/contact-us.html") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      9 years 6 months ago |
| [](/forum/35-orders-management/889516-invoice-number-not-reset-at-beginning-of-the-year#265765) | [Invoice number not reset at beginning of the year](/forum/35-orders-management/889516-invoice-number-not-reset-at-beginning-of-the-year#265765 "The invoice number was not reset at the beginning of the year as we have configured in Syste/Configutration/Order tab. We have to update manually the invoice number because it continues to calculate...")         Category: [Orders management](/forum/35-orders-management "You can ask here your questions about orders management")     Topic started 9 years 7 months ago, by [jaystore](/forum/user/31616-jaystore "View jaystore's Profile")       [Last Post](/forum/35-orders-management/889516-invoice-number-not-reset-at-beginning-of-the-year#266106 "Hi,  Well, I don't see how that's possible and I can't reproduce. Please provide a backend access, a FTP access and a PHPMyAdmin access (ideally of a copy of your website) so that we could debug the situation because I'm out of ideas here.  You can use our contact form to provide that along with a link to this thread:   www.hikashop.com/support/contact-us.html") 9 years 6 months ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:7  Views:814 | [Last Post](/forum/35-orders-management/889516-invoice-number-not-reset-at-beginning-of-the-year#266106 "Hi,  Well, I don't see how that's possible and I can't reproduce. Please provide a backend access, a FTP access and a PHPMyAdmin access (ideally of a copy of your website) so that we could debug the situation because I'm out of ideas here.  You can use our contact form to provide that along with a link to this thread:   www.hikashop.com/support/contact-us.html") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      9 years 6 months ago |

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.134 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)

[](#top)
