[Skip to main content](#vessel-content) # Profile for sthomas ## [![sthomas's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3545-sthomas "View sthomas's Profile") **[ Offline](/forum/user/3545-sthomas)** - **User Type:** User - **Register Date:** 02 Aug 2011 - **Last login:** 12 years 4 months ago - **Time Zone:** UTC +0:00 - **Local Time:** 19:08 - **Posts:** 9 - **Profile views:** 206 - **Gender:** Unknown - **Birthdate:** Unknown - Posts # sthomas recent posts (9 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 | [ ](#forumbottom) | Subject | Replies / Views | Last Post | [ ](#forumtop) | |---|---|---|---|---| | [](/forum/26-product-category-display/865154-how-can-i-sell-half-units-of-an-item#140386) | [How can I sell half units of an item?](/forum/26-product-category-display/865154-how-can-i-sell-half-units-of-an-item#140386 "Hi, I am setting up a shop for a company selling lengths of fabric, they have entered all the products as per metre units but I am now told they want to sell in half metre increments, is there any (simple) way I can allow half units to be sold in hikashop? I am using the latest version of hikashop business (2.2.3) and Joomla 2.5.17") Category: [Product & Category Display](/forum/26-product-category-display "Questions about product and category display. You can't find how to make Hikashop looks incredible? The answer is here!") Topic started 12 years 9 months ago, by [sthomas](/forum/user/3545-sthomas "View sthomas's Profile") [Last Post](/forum/26-product-category-display/865154-how-can-i-sell-half-units-of-an-item#140404 "Hi, So basically you want to divide all the prices by 2 ? You can do that with a mass action via the menu System>Mass action and an action "update the values" on the "price_value" column with an operation price.price_value/2 Also, you can say that your products are sold by 50 cm so that when they buy 2, they actually get 1 meter.") 12 years 9 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:309 | [Last Post](/forum/26-product-category-display/865154-how-can-i-sell-half-units-of-an-item#140404 "Hi, So basically you want to divide all the prices by 2 ? You can do that with a mass action via the menu System>Mass action and an action "update the values" on the "price_value" column with an operation price.price_value/2 Also, you can say that your products are sold by 50 cm so that when they buy 2, they actually get 1 meter.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 12 years 9 months ago | | [](/forum/4-how-to/59489-modify-email-to-show-product-options#59489) | [Modify email to show product options](/forum/4-how-to/59489-modify-email-to-show-product-options#59489 "Hi, I'm trying to add the options to the email templates. I've got this: And added a modified template - it's all working, except I can't show the options... I also tried: All it displays is an empty bracket. How can I display the options?") 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 14 years 3 months ago, by [sthomas](/forum/user/3545-sthomas "View sthomas's Profile") [Last Post](/forum/4-how-to/59489-modify-email-to-show-product-options#59558 "It's an array, so you need to do like that: echo " (" . $item->order_product_options . ")";") 14 years 3 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:535 | [Last Post](/forum/4-how-to/59489-modify-email-to-show-product-options#59558 "It's an array, so you need to do like that: echo " (" . $item->order_product_options . ")";") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 14 years 3 months ago | | [](/forum/4-how-to/56110-shipping-per-quantity#56110) | [Shipping per quantity](/forum/4-how-to/56110-shipping-per-quantity#56110 "Hi, I'm trying to figure out if this is possible - We have a range of products within a similar weight range, and looking to split the shipping based on the number of products ordered, eg: 1-6 : £5 7-12 : £7 13+ : free What would be the best approach for this? I could set up a generic weight, but this needs to work with the specific number of products, not overall weight/volume. We're using the latest Business version. Any ideas?") 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 14 years 4 months ago, by [sthomas](/forum/user/3545-sthomas "View sthomas's Profile") [Last Post](/forum/4-how-to/56110-shipping-per-quantity#56164 "Hi, I don't see the difference between "specific number of products" and "overall weight/volume" if the weight is the same. For example, if you have a weight of 1kg for each one of your products, if you create three manual shipping methods with weight ranges like that: 0 to 6.5kg => £5 6.5kg to 12.5kg => £7 from 12.5kg => £0 That will do exactly what you want if I understood correctly what you want.") 14 years 4 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:676 | [Last Post](/forum/4-how-to/56110-shipping-per-quantity#56164 "Hi, I don't see the difference between "specific number of products" and "overall weight/volume" if the weight is the same. For example, if you have a weight of 1kg for each one of your products, if you create three manual shipping methods with weight ranges like that: 0 to 6.5kg => £5 6.5kg to 12.5kg => £7 from 12.5kg => £0 That will do exactly what you want if I understood correctly what you want.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 14 years 4 months ago | | [](/forum/4-how-to/46420-show-only-countries-in-english#46420) | [Show only countries in english](/forum/4-how-to/46420-show-only-countries-in-english#46420 "I'm having a little problem - Many countries in the address forms seem to display the countries in english, then in the local language, eg: Austria (Österreich) and so on... How can I simply display Austria, and so on for every country, without having to edit every country zone? Can this be done? Am I missing an option in the configuration. I'm running 1.5.6 Business.") 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 14 years 6 months ago, by [sthomas](/forum/user/3545-sthomas "View sthomas's Profile") [Last Post](/forum/4-how-to/46420-show-only-countries-in-english#46561 "There is no option for that. You will have to do them one by one or run the query below in your phpmyadmin: UPDATE jos_hikashop_zone SET zone_name='' WHERE zone_type='country';") 14 years 6 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:697 | [Last Post](/forum/4-how-to/46420-show-only-countries-in-english#46561 "There is no option for that. You will have to do them one by one or run the query below in your phpmyadmin: UPDATE jos_hikashop_zone SET zone_name='' WHERE zone_type='country';") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 14 years 6 months ago | | [](/forum/2-general-talk-about-hikashop/36775-sagepay-direct-support-uk#43948) | [Sagepay Direct Support Uk?](/forum/2-general-talk-about-hikashop/36775-sagepay-direct-support-uk#43948 "Hi we must admit we are very impressed with Hikashop especially with custom fields. Just one thing i noticed is sagepay extension does it only support the re direct option or does it support sage pay...") Category: [General Talk about HikaShop](/forum/2-general-talk-about-hikashop "Suggest your feature requests and ideas for HikaShop") Topic started 14 years 9 months ago, by [david34ni](/forum/user/5775-david34ni "View david34ni's Profile") [Last Post](/forum/2-general-talk-about-hikashop/36775-sagepay-direct-support-uk#43951 "You should use the "form" option.") 14 years 7 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:2423 | [Last Post](/forum/2-general-talk-about-hikashop/36775-sagepay-direct-support-uk#43951 "You should use the "form" option.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 14 years 7 months ago | | [](/forum/4-how-to/32930-product-export-ordering#32930) | [Product Export Ordering](/forum/4-how-to/32930-product-export-ordering#32930 "I'm confused about how the export of products is sorted. I would have assumed that the export would be the same as the import - our client is expoecting a CSV file with the same order/formatting...") 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 14 years 10 months ago, by [sthomas](/forum/user/3545-sthomas "View sthomas's Profile") [Last Post](/forum/4-how-to/32930-product-export-ordering#32951 "Hi, It's indeed random. There is no ordering set in the query for the export so the order of the products is whatever mysql feels. We didn't thought that it would make any difference. And no one told us that it was a problem so far so it's still like that. If you want to have them ordered by id, you can change the line: $query = 'SELECT * FROM '.hikashop_table('product').$where.' ORDER BY product_parent_id ASC'; to: $query = 'SELECT * FROM '.hikashop_table('product').$where.' ORDER BY product_parent_id ASC, product_id ASC'; in the file administrator/components/com_hikashop/classes/product.php We'll do that change on our end as it makes sense to export the products in the order they were inserted.") 14 years 10 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:715 | [Last Post](/forum/4-how-to/32930-product-export-ordering#32951 "Hi, It's indeed random. There is no ordering set in the query for the export so the order of the products is whatever mysql feels. We didn't thought that it would make any difference. And no one told us that it was a problem so far so it's still like that. If you want to have them ordered by id, you can change the line: $query = 'SELECT * FROM '.hikashop_table('product').$where.' ORDER BY product_parent_id ASC'; to: $query = 'SELECT * FROM '.hikashop_table('product').$where.' ORDER BY product_parent_id ASC, product_id ASC'; in the file administrator/components/com_hikashop/classes/product.php We'll do that change on our end as it makes sense to export the products in the order they were inserted.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 14 years 10 months ago | | [](/forum/4-how-to/28799-importing-products-add-images-for-categories#28799) | [Importing products, add images for categories](/forum/4-how-to/28799-importing-products-add-images-for-categories#28799 "Like the subject - How would I add images to categories that are created when I import the products? If I can do this, what would be the column name for the CSV file? Alternatively, could I set up the categories at the top of the products CSV file? e.g.: category category product product product product product ??") 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 15 years 1 day ago, by [sthomas](/forum/user/3545-sthomas "View sthomas's Profile") [Last Post](/forum/4-how-to/28799-importing-products-add-images-for-categories#28816 "It's not possible to add the image of categories via a CSV import.") 15 years 1 day ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:624 | [Last Post](/forum/4-how-to/28799-importing-products-add-images-for-categories#28816 "It's not possible to add the image of categories via a CSV import.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 15 years 1 day ago | | [](/forum/4-how-to/27509-import-products-with-variants-issue-with-codes#27518) | [Import products with variants, issue with codes](/forum/4-how-to/27509-import-products-with-variants-issue-with-codes#27518 "I'm having a little difficulty in importing a range of products with variants. My main issue is with the column 'product_code', as I need to set this correctly. I'm about to import 3000+ items, and this is driving me a little insane. Here's my csv file as it is. product_code,product_id,product_parent_id,product_name,product_short_desc,product_description,product_quantity,product_dimension_unit,product_width,product_length,product_height,product_access,price_value ,price_currency_id ,categories,parent_category,product_published,images,related,options,Frame Number,Locking Options,Frame Size,Colours 27.12.75.00,27.12.75.00,,MTE 12H ,Holds 12 frames with 75mm spacing. Options of locking or non-locking with fixings and turning key.,Single Rod aluminium. Option of either open or locking with turning key. Holds 12 glasses. Distance between the frame holders 75mm.,-1,mm,1060,170,190,all,67.90,4,Single Rods/Mini Tubix,Mini Tubix,1,4,,,,Non-locking,, 27.12.75.05,27.12.75.05,27.12.75.00,MTE 12H ,Holds 12 frames with 75mm spacing. Options of locking or non-locking with fixings and turning key.,Single Rod aluminium. Option of either open or locking with turning key. Holds 12 glasses. Distance between the frame holders 75mm.,-1,mm,1060,170,190,all,111.80,4,Single Rods/Mini Tubix,Mini Tubix,1,4,,,,locking,, My issue is this: The main product will have a product_code of : 27.12.75.00, and the variant is the locking version, with 27.12.75.05. All good so far. But... The main product and first variant are the same product and theoretically the same product code. At the moment, the import adds both items, but only shows the locking version, with the non-locking imported but not available. I found an example which I've tried to follow: product_code,product_parent_id,color,size prod1,,blue,10 prod1_1,prod1,blue,10 prod1_2,prod1,red,10 In my case, prod1 and prod1_1 are the same item, and need the same code. This is already defined in a published catalogue, so cannot accept alternatives. If I'm doing anything wrong, I'll certainly experiment. I'm also using the latest version of hikashop.") 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 15 years 2 weeks ago, by [sthomas](/forum/user/3545-sthomas "View sthomas's Profile") [Last Post](/forum/4-how-to/27509-import-products-with-variants-issue-with-codes#27518 "Hi, Yeah, I figured that would be the case. I've been setting up new codes for the main product, as you have to select a variant, which shows up in the order at checkout as the right code. So if I select locking, I would see: MTE12H : 27.12.75.05 in the checkout area, which is what I want. Many thanks, and an awesome product thus far. Now for editing the CSV file :S") 15 years 2 weeks ago by [sthomas](/forum/user/3545-sthomas "View sthomas's Profile") | Replies:2 Views:1288 | [Last Post](/forum/4-how-to/27509-import-products-with-variants-issue-with-codes#27518 "Hi, Yeah, I figured that would be the case. I've been setting up new codes for the main product, as you have to select a variant, which shows up in the order at checkout as the right code. So if I select locking, I would see: MTE12H : 27.12.75.05 in the checkout area, which is what I want. Many thanks, and an awesome product thus far. Now for editing the CSV file :S") by [sthomas](/forum/user/3545-sthomas "View sthomas's Profile") 15 years 2 weeks ago | | [](/forum/4-how-to/27509-import-products-with-variants-issue-with-codes#27509) | [Import products with variants, issue with codes](/forum/4-how-to/27509-import-products-with-variants-issue-with-codes#27509 "I'm having a little difficulty in importing a range of products with variants. My main issue is with the column 'product_code', as I need to set this correctly. I'm about to import 3000+ items, and this is driving me a little insane. Here's my csv file as it is. product_code,product_id,product_parent_id,product_name,product_short_desc,product_description,product_quantity,product_dimension_unit,product_width,product_length,product_height,product_access,price_value ,price_currency_id ,categories,parent_category,product_published,images,related,options,Frame Number,Locking Options,Frame Size,Colours 27.12.75.00,27.12.75.00,,MTE 12H ,Holds 12 frames with 75mm spacing. Options of locking or non-locking with fixings and turning key.,Single Rod aluminium. Option of either open or locking with turning key. Holds 12 glasses. Distance between the frame holders 75mm.,-1,mm,1060,170,190,all,67.90,4,Single Rods/Mini Tubix,Mini Tubix,1,4,,,,Non-locking,, 27.12.75.05,27.12.75.05,27.12.75.00,MTE 12H ,Holds 12 frames with 75mm spacing. Options of locking or non-locking with fixings and turning key.,Single Rod aluminium. Option of either open or locking with turning key. Holds 12 glasses. Distance between the frame holders 75mm.,-1,mm,1060,170,190,all,111.80,4,Single Rods/Mini Tubix,Mini Tubix,1,4,,,,locking,, My issue is this: The main product will have a product_code of : 27.12.75.00, and the variant is the locking version, with 27.12.75.05. All good so far. But... The main product and first variant are the same product and theoretically the same product code. At the moment, the import adds both items, but only shows the locking version, with the non-locking imported but not available. I found an example which I've tried to follow: product_code,product_parent_id,color,size prod1,,blue,10 prod1_1,prod1,blue,10 prod1_2,prod1,red,10 In my case, prod1 and prod1_1 are the same item, and need the same code. This is already defined in a published catalogue, so cannot accept alternatives. If I'm doing anything wrong, I'll certainly experiment. I'm also using the latest version of hikashop.") 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 15 years 2 weeks ago, by [sthomas](/forum/user/3545-sthomas "View sthomas's Profile") [Last Post](/forum/4-how-to/27509-import-products-with-variants-issue-with-codes#27518 "Hi, Yeah, I figured that would be the case. I've been setting up new codes for the main product, as you have to select a variant, which shows up in the order at checkout as the right code. So if I select locking, I would see: MTE12H : 27.12.75.05 in the checkout area, which is what I want. Many thanks, and an awesome product thus far. Now for editing the CSV file :S") 15 years 2 weeks ago by [sthomas](/forum/user/3545-sthomas "View sthomas's Profile") | Replies:2 Views:1288 | [Last Post](/forum/4-how-to/27509-import-products-with-variants-issue-with-codes#27518 "Hi, Yeah, I figured that would be the case. I've been setting up new codes for the main product, as you have to select a variant, which shows up in the order at checkout as the right code. So if I select locking, I would see: MTE12H : 27.12.75.05 in the checkout area, which is what I want. Many thanks, and an awesome product thus far. Now for editing the CSV file :S") by [sthomas](/forum/user/3545-sthomas "View sthomas's Profile") 15 years 2 weeks ago | [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.060 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)