[Skip to main content](#vessel-content)
# Profile for zaurb
##
[](/forum/user/7791-zaurb "View zaurb's Profile")
**[ Offline](/forum/user/7791-zaurb)**
- **User Type:** User
- **Register Date:** 11 Jun 2012
- **Last login:** 14 years 4 months ago
- **Time Zone:** UTC +0:00
- **Local Time:** 05:24
- **Posts:** 3
- **Profile views:** 34
- **Gender:** Unknown
- **Birthdate:** Unknown
- Posts
# zaurb's recent posts (3 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/4-how-to/44631-solved-how-to-reinstall-hikashop#53622) | [SOLVED How to reinstall Hikashop](/forum/4-how-to/44631-solved-how-to-reinstall-hikashop#53622 "I have a problem with the Hikashop database tables (self-inflicted and no backup - I'm just playing with Hikashop at the moment to get to know it) but now I'm stuck. I would like to completely remove and reinstall Hikashop. I've tried doing this through the usual Joomla methods but am getting SQL errors during uninstall and reinstall. Is there a reliable way to convince the Hikashop installer to recreate the tables from scratch? I don't mind losing all my Hikashop work to date.") 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 7 months ago, by [robgibney](/forum/user/6773-robgibney "View robgibney's Profile") [Last Post](/forum/4-how-to/44631-solved-how-to-reinstall-hikashop#53624 "You can just empty the hikashop_category, hikashop_product, hikashop_variant, hikashop_price and hikashop_product_category table in your database via phpmyadmin and install again HikaShop.") 14 years 4 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:1622 | [Last Post](/forum/4-how-to/44631-solved-how-to-reinstall-hikashop#53624 "You can just empty the hikashop_category, hikashop_product, hikashop_variant, hikashop_price and hikashop_product_category table in your database via phpmyadmin and install again HikaShop.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 14 years 4 months ago |
| [](/forum/4-how-to/53589-fix-products-and-catgories-tables#53589) | [Fix Products and Catgories tables](/forum/4-how-to/53589-fix-products-and-catgories-tables#53589 "Hello, I've accidentally dropped tables: hikashop_product hikashop_product_category hikashop_category hikashop_cart_product I've re-imported from CSV the products and categories data and received a message that all products were successfully imported, however nothing appears under products. When I go to Products --> Categories in the Explorer window I see nothing, however I see all the categories in the main screen with categories listing. Products are not seen at all. Is there a way to fix this or I have to remove HikaShop completely and reinstall it again? Many thanks in advance!") 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 [zaurb](/forum/user/7791-zaurb "View zaurb's Profile") [Last Post](/forum/4-how-to/53589-fix-products-and-catgories-tables#53684 "Do you have your products in the hikashop_product table ? Try to import again the CSV with the debug mode of the joomla configuration activated. That might display an error if there is a problem with the database (for example if you didn't add back a table of HikaShop properly).") 14 years 4 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:2 Views:610 | [Last Post](/forum/4-how-to/53589-fix-products-and-catgories-tables#53684 "Do you have your products in the hikashop_product table ? Try to import again the CSV with the debug mode of the joomla configuration activated. That might display an error if there is a problem with the database (for example if you didn't add back a table of HikaShop properly).") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 14 years 4 months ago |
| [](/forum/4-how-to/53533-create-a-csv-file-from-ms-sql-server-query#53533) | [Create a CSV file from MS-SQL server query](/forum/4-how-to/53533-create-a-csv-file-from-ms-sql-server-query#53533 "Hi! I need to produce an input CSV file for importing into HikaShop. I've created an export file which is attached to this post. The data is related to food products and has several custom fields, like EAN code, Ingredients, Original Description, etc., various categories and subcategories. The products can be sold either in standard cartons or as single items. For this I have created variant which is called Unit (of measure) with two options Scatole (Boxes) and Pezzi (single items). The original data is all on a Microsoft SQL Server and I can create a simple SELECT query to produce a table with item numbers, descriptions, prices, categories, etc. However, when I do export from HikaShop product page to see the format of the file to be created, I notice that it's not just a simple table, but some rows are dedicated only to categories and subcategories, while some are specific to variants, etc. So, I'm a bit confused about producing an input CSV file. Can you advise how to produce such table using a SQL query? Or any other way to accomplish this task? Also, if possible, I would like to automate importing proc using a CRON job once I figure out the way to produce an import CSV file for HikaShop. Many thanks in advance!") 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 [zaurb](/forum/user/7791-zaurb "View zaurb's Profile") [Last Post](/forum/4-how-to/53533-create-a-csv-file-from-ms-sql-server-query#53607 "Hi, The lines regarding the categories are not necessary. They can be used to import a category structure. If you already have your categories, or if you don't have ambiguous category names (several different categories with the same name), you should not need them. Regarding variants/characteristics, when you have characteristics attached to a product in HikaShop, each combination of characteristic values corresponding to a variant. Each variant of the product is stored in the hikashop_product table. That allows you to specify different prices,quantities, information, etc for different variants. Without the variants generated the characteristics won't display properly on the product page. I can't tell you how to do your query. It depends on your MSSQL database structure which I don't know. What I can say though is that it sure is possible to import it automatically. In the commercial editions of Hikashop, there is a data feed plugin which uses the cron system available to automatically import CSV files in HikaShop. You could either use it if the format is the correct one, or modify it to adapt the data of your CSV to HikaShop (so that could be a solution in order to inject the variants in the CSV, if you can't generate these lines with your MSSQL CSV export).") 14 years 4 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:2133 | [Last Post](/forum/4-how-to/53533-create-a-csv-file-from-ms-sql-server-query#53607 "Hi, The lines regarding the categories are not necessary. They can be used to import a category structure. If you already have your categories, or if you don't have ambiguous category names (several different categories with the same name), you should not need them. Regarding variants/characteristics, when you have characteristics attached to a product in HikaShop, each combination of characteristic values corresponding to a variant. Each variant of the product is stored in the hikashop_product table. That allows you to specify different prices,quantities, information, etc for different variants. Without the variants generated the characteristics won't display properly on the product page. I can't tell you how to do your query. It depends on your MSSQL database structure which I don't know. What I can say though is that it sure is possible to import it automatically. In the commercial editions of Hikashop, there is a data feed plugin which uses the cron system available to automatically import CSV files in HikaShop. You could either use it if the format is the correct one, or modify it to adapt the data of your CSV to HikaShop (so that could be a solution in order to inject the variants in the CSV, if you can't generate these lines with your MSSQL CSV export).") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 14 years 4 months ago |
[](/forum/topics/feed/mode-topics?format=feed&type=rss)
Time to create page: 0.184 seconds
[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
[](#top)