[Skip to main content](#vessel-content) # Redshop Tax Rate Problem with Importing into HikaShop ## - **[soliver](/forum/user/35048-soliver "View soliver's Profile")** - [![soliver's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar35048.png)](/forum/user/35048-soliver "View soliver's Profile") Topic Author - [ Offline](/forum/user/35048-soliver) Less More - Posts: 15 - Thank you received: 0 - - 9 years 6 months ago [\#267079](#267079) by [soliver](/forum/user/35048-soliver "View soliver's Profile") *[Redshop Tax Rate Problem with Importing into HikaShop](/forum/37-import-export-csv-xls/889758-redshop-tax-rate-problem-with-importing-into-hikashop#267079 "-- HikaShop version -- : 3.0.1 -- Joomla version -- : 3.6.5 -- PHP version -- : 5.6.30 -- Browser(s) name and version -- : Safari 10.1 -- Error-message(debug-mod must be tuned on) -- : Unknown column 'rstr.tax_rate_id' in 'field list' SQL=INSERT IGNORE INTO `#__hikashop_tax` (`tax_namekey`,`tax_rate`) SELECT CONCAT('REDS_TAX_', rstr.tax_rate_id),rstr.tax_rate FROM `#__redshop_tax_rate` AS rstr WHERE rstr.tax_rate_id > 0 I am receiving the following error when trying to import RedShop. I can't even get out of the starting gate as soon as I click Import I get the error: Unknown column 'rstr.tax_rate_id' in 'field list' SQL=INSERT IGNORE INTO `#__hikashop_tax` (`tax_namekey`,`tax_rate`) SELECT CONCAT('REDS_TAX_', rstr.tax_rate_id),rstr.tax_rate FROM `#__redshop_tax_rate` AS rstr WHERE rstr.tax_rate_id > 0 The RedShop Shopping Cart has many Categories and Related Products. It would be very nice if I could get the Import function to work. Any help would be greatly appreciated. Thank You Scott")* was created by *[soliver](/forum/user/35048-soliver "View soliver's Profile")* -- HikaShop version -- : 3.0.1 -- Joomla version -- : 3.6.5 -- PHP version -- : 5.6.30 -- Browser(s) name and version -- : Safari 10.1 -- Error-message(debug-mod must be tuned on) -- : Unknown column 'rstr.tax_rate_id' in 'field list' SQL=INSERT IGNORE INTO `#__hikashop_tax` (`tax_namekey`,`tax_rate`) SELECT CONCAT('REDS_TAX_', rstr.tax_rate_id),rstr.tax_rate FROM `#__redshop_tax_rate` AS rstr WHERE rstr.tax_rate_id > 0 I am receiving the following error when trying to import RedShop. I can't even get out of the starting gate as soon as I click Import I get the error: Unknown column 'rstr.tax_rate_id' in 'field list' SQL=INSERT IGNORE INTO `#__hikashop_tax` (`tax_namekey`,`tax_rate`) SELECT CONCAT('REDS_TAX_', rstr.tax_rate_id),rstr.tax_rate FROM `#__redshop_tax_rate` AS rstr WHERE rstr.tax_rate_id > 0 The RedShop Shopping Cart has many Categories and Related Products. It would be very nice if I could get the Import function to work. Any help would be greatly appreciated. Thank You Scott Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODk3NTgtcmVkc2hvcC10YXgtcmF0ZS1wcm9ibGVtLXdpdGgtaW1wb3J0aW5nLWludG8taGlrYXNob3A/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 9 years 6 months ago [\#267086](#267086) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Redshop Tax Rate Problem with Importing into HikaShop](/forum/37-import-export-csv-xls/889758-redshop-tax-rate-problem-with-importing-into-hikashop#267086 "-- HikaShop version -- : 3.0.1 -- Joomla version -- : 3.6.5 -- PHP version -- : 5.6.30 -- Browser(s) name and version -- : Safari 10.1 -- Error-message(debug-mod must be tuned on) -- : Unknown column 'rstr.tax_rate_id' in 'field list' SQL=INSERT IGNORE INTO `#__hikashop_tax` (`tax_namekey`,`tax_rate`) SELECT CONCAT('REDS_TAX_', rstr.tax_rate_id),rstr.tax_rate FROM `#__redshop_tax_rate` AS rstr WHERE rstr.tax_rate_id > 0 I am receiving the following error when trying to import RedShop. I can't even get out of the starting gate as soon as I click Import I get the error: Unknown column 'rstr.tax_rate_id' in 'field list' SQL=INSERT IGNORE INTO `#__hikashop_tax` (`tax_namekey`,`tax_rate`) SELECT CONCAT('REDS_TAX_', rstr.tax_rate_id),rstr.tax_rate FROM `#__redshop_tax_rate` AS rstr WHERE rstr.tax_rate_id > 0 The RedShop Shopping Cart has many Categories and Related Products. It would be very nice if I could get the Import function to work. Any help would be greatly appreciated. Thank You Scott")* Hi, Well, that means that RedShop's database structure has changed since we developed that import tool. Could you provide an export of the table redshop_tax_rate so that we could adapt the code ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODk3NTgtcmVkc2hvcC10YXgtcmF0ZS1wcm9ibGVtLXdpdGgtaW1wb3J0aW5nLWludG8taGlrYXNob3A/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[soliver](/forum/user/35048-soliver "View soliver's Profile")** - [![soliver's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar35048.png)](/forum/user/35048-soliver "View soliver's Profile") Topic Author - [ Offline](/forum/user/35048-soliver) Less More - Posts: 15 - Thank you received: 0 - - 9 years 6 months ago [\#267183](#267183) by [soliver](/forum/user/35048-soliver "View soliver's Profile") Replied by *[soliver](/forum/user/35048-soliver "View soliver's Profile")* on topic *[Redshop Tax Rate Problem with Importing into HikaShop](/forum/37-import-export-csv-xls/889758-redshop-tax-rate-problem-with-importing-into-hikashop#267183 "-- HikaShop version -- : 3.0.1 -- Joomla version -- : 3.6.5 -- PHP version -- : 5.6.30 -- Browser(s) name and version -- : Safari 10.1 -- Error-message(debug-mod must be tuned on) -- : Unknown column 'rstr.tax_rate_id' in 'field list' SQL=INSERT IGNORE INTO `#__hikashop_tax` (`tax_namekey`,`tax_rate`) SELECT CONCAT('REDS_TAX_', rstr.tax_rate_id),rstr.tax_rate FROM `#__redshop_tax_rate` AS rstr WHERE rstr.tax_rate_id > 0 I am receiving the following error when trying to import RedShop. I can't even get out of the starting gate as soon as I click Import I get the error: Unknown column 'rstr.tax_rate_id' in 'field list' SQL=INSERT IGNORE INTO `#__hikashop_tax` (`tax_namekey`,`tax_rate`) SELECT CONCAT('REDS_TAX_', rstr.tax_rate_id),rstr.tax_rate FROM `#__redshop_tax_rate` AS rstr WHERE rstr.tax_rate_id > 0 The RedShop Shopping Cart has many Categories and Related Products. It would be very nice if I could get the Import function to work. Any help would be greatly appreciated. Thank You Scott")* HikaShop, Please see attached redshop_tax_rate. If you like, I can send you the entire Redshop Database Export so you know if there are any additional changes. *This attachment is hidden for guests. Please log in or register to see it.* Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODk3NTgtcmVkc2hvcC10YXgtcmF0ZS1wcm9ibGVtLXdpdGgtaW1wb3J0aW5nLWludG8taGlrYXNob3A/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 9 years 6 months ago - 9 years 6 months ago [\#267243](#267243) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Redshop Tax Rate Problem with Importing into HikaShop](/forum/37-import-export-csv-xls/889758-redshop-tax-rate-problem-with-importing-into-hikashop#267243 "-- HikaShop version -- : 3.0.1 -- Joomla version -- : 3.6.5 -- PHP version -- : 5.6.30 -- Browser(s) name and version -- : Safari 10.1 -- Error-message(debug-mod must be tuned on) -- : Unknown column 'rstr.tax_rate_id' in 'field list' SQL=INSERT IGNORE INTO `#__hikashop_tax` (`tax_namekey`,`tax_rate`) SELECT CONCAT('REDS_TAX_', rstr.tax_rate_id),rstr.tax_rate FROM `#__redshop_tax_rate` AS rstr WHERE rstr.tax_rate_id > 0 I am receiving the following error when trying to import RedShop. I can't even get out of the starting gate as soon as I click Import I get the error: Unknown column 'rstr.tax_rate_id' in 'field list' SQL=INSERT IGNORE INTO `#__hikashop_tax` (`tax_namekey`,`tax_rate`) SELECT CONCAT('REDS_TAX_', rstr.tax_rate_id),rstr.tax_rate FROM `#__redshop_tax_rate` AS rstr WHERE rstr.tax_rate_id > 0 The RedShop Shopping Cart has many Categories and Related Products. It would be very nice if I could get the Import function to work. Any help would be greatly appreciated. Thank You Scott")* Hi, Indeed, if I compare with for example: [ github.com/haanhredweb/Redgadgets/blob/m...ables/tax\_detail.php](https://github.com/haanhredweb/Redgadgets/blob/master/administrator/components/com_redshop/tables/tax_detail.php) you can see that the tax_rate_id that was there before is now called "id". Regarding an easy solution for you, you can just change tax_rate_id to id in the file administrator/components/com_hikashop/helpers/import/reds.php and that will fix the MySQL error. Yes, please provide a full export of all the redshop tables because they might have changed other things and it will be good updating the import script. Last edit: 9 years 6 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODk3NTgtcmVkc2hvcC10YXgtcmF0ZS1wcm9ibGVtLXdpdGgtaW1wb3J0aW5nLWludG8taGlrYXNob3A/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[soliver](/forum/user/35048-soliver "View soliver's Profile")** - [![soliver's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar35048.png)](/forum/user/35048-soliver "View soliver's Profile") Topic Author - [ Offline](/forum/user/35048-soliver) Less More - Posts: 15 - Thank you received: 0 - - 9 years 6 months ago [\#267258](#267258) by [soliver](/forum/user/35048-soliver "View soliver's Profile") Replied by *[soliver](/forum/user/35048-soliver "View soliver's Profile")* on topic *[Redshop Tax Rate Problem with Importing into HikaShop](/forum/37-import-export-csv-xls/889758-redshop-tax-rate-problem-with-importing-into-hikashop#267258 "-- HikaShop version -- : 3.0.1 -- Joomla version -- : 3.6.5 -- PHP version -- : 5.6.30 -- Browser(s) name and version -- : Safari 10.1 -- Error-message(debug-mod must be tuned on) -- : Unknown column 'rstr.tax_rate_id' in 'field list' SQL=INSERT IGNORE INTO `#__hikashop_tax` (`tax_namekey`,`tax_rate`) SELECT CONCAT('REDS_TAX_', rstr.tax_rate_id),rstr.tax_rate FROM `#__redshop_tax_rate` AS rstr WHERE rstr.tax_rate_id > 0 I am receiving the following error when trying to import RedShop. I can't even get out of the starting gate as soon as I click Import I get the error: Unknown column 'rstr.tax_rate_id' in 'field list' SQL=INSERT IGNORE INTO `#__hikashop_tax` (`tax_namekey`,`tax_rate`) SELECT CONCAT('REDS_TAX_', rstr.tax_rate_id),rstr.tax_rate FROM `#__redshop_tax_rate` AS rstr WHERE rstr.tax_rate_id > 0 The RedShop Shopping Cart has many Categories and Related Products. It would be very nice if I could get the Import function to work. Any help would be greatly appreciated. Thank You Scott")* Nicolas, How can I send you the database without making this public? Scott Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODk3NTgtcmVkc2hvcC10YXgtcmF0ZS1wcm9ibGVtLXdpdGgtaW1wb3J0aW5nLWludG8taGlrYXNob3A/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[soliver](/forum/user/35048-soliver "View soliver's Profile")** - [![soliver's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar35048.png)](/forum/user/35048-soliver "View soliver's Profile") Topic Author - [ Offline](/forum/user/35048-soliver) Less More - Posts: 15 - Thank you received: 0 - - 9 years 6 months ago [\#267262](#267262) by [soliver](/forum/user/35048-soliver "View soliver's Profile") Replied by *[soliver](/forum/user/35048-soliver "View soliver's Profile")* on topic *[Redshop Tax Rate Problem with Importing into HikaShop](/forum/37-import-export-csv-xls/889758-redshop-tax-rate-problem-with-importing-into-hikashop#267262 "-- HikaShop version -- : 3.0.1 -- Joomla version -- : 3.6.5 -- PHP version -- : 5.6.30 -- Browser(s) name and version -- : Safari 10.1 -- Error-message(debug-mod must be tuned on) -- : Unknown column 'rstr.tax_rate_id' in 'field list' SQL=INSERT IGNORE INTO `#__hikashop_tax` (`tax_namekey`,`tax_rate`) SELECT CONCAT('REDS_TAX_', rstr.tax_rate_id),rstr.tax_rate FROM `#__redshop_tax_rate` AS rstr WHERE rstr.tax_rate_id > 0 I am receiving the following error when trying to import RedShop. I can't even get out of the starting gate as soon as I click Import I get the error: Unknown column 'rstr.tax_rate_id' in 'field list' SQL=INSERT IGNORE INTO `#__hikashop_tax` (`tax_namekey`,`tax_rate`) SELECT CONCAT('REDS_TAX_', rstr.tax_rate_id),rstr.tax_rate FROM `#__redshop_tax_rate` AS rstr WHERE rstr.tax_rate_id > 0 The RedShop Shopping Cart has many Categories and Related Products. It would be very nice if I could get the Import function to work. Any help would be greatly appreciated. Thank You Scott")* Nicolas, I made the tax ID change you suggested and all went well till I got to Step 4 and then the import stop. No error message, it just shows the Imported categories and provides a Next Step Link. When you click on the Next Step Link, it looks like it is running a process but it gets stuck at this point. I hope this helps....Please see attached image. [ ![ImportFromRedShop.png](/forum/attachment/37632) ](/forum/attachment/37632 "...romRedShop.png") Scott - [ ![ImportFromRedShop.png](/forum/attachment/37632) ](/forum/attachment/37632 "...romRedShop.png") [ ](/forum/attachment/37632?download=1 "...romRedShop.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODk3NTgtcmVkc2hvcC10YXgtcmF0ZS1wcm9ibGVtLXdpdGgtaW1wb3J0aW5nLWludG8taGlrYXNob3A/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 9 years 6 months ago [\#267264](#267264) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Redshop Tax Rate Problem with Importing into HikaShop](/forum/37-import-export-csv-xls/889758-redshop-tax-rate-problem-with-importing-into-hikashop#267264 "-- HikaShop version -- : 3.0.1 -- Joomla version -- : 3.6.5 -- PHP version -- : 5.6.30 -- Browser(s) name and version -- : Safari 10.1 -- Error-message(debug-mod must be tuned on) -- : Unknown column 'rstr.tax_rate_id' in 'field list' SQL=INSERT IGNORE INTO `#__hikashop_tax` (`tax_namekey`,`tax_rate`) SELECT CONCAT('REDS_TAX_', rstr.tax_rate_id),rstr.tax_rate FROM `#__redshop_tax_rate` AS rstr WHERE rstr.tax_rate_id > 0 I am receiving the following error when trying to import RedShop. I can't even get out of the starting gate as soon as I click Import I get the error: Unknown column 'rstr.tax_rate_id' in 'field list' SQL=INSERT IGNORE INTO `#__hikashop_tax` (`tax_namekey`,`tax_rate`) SELECT CONCAT('REDS_TAX_', rstr.tax_rate_id),rstr.tax_rate FROM `#__redshop_tax_rate` AS rstr WHERE rstr.tax_rate_id > 0 The RedShop Shopping Cart has many Categories and Related Products. It would be very nice if I could get the Import function to work. Any help would be greatly appreciated. Thank You Scott")* Hi, If you provide the tables structure and not the table data in the export, like you did, then there is none of your data in the export and thus you can provide it publicly. But you can also send us that to contact AT hikashop DOT com with a link to this thread. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODk3NTgtcmVkc2hvcC10YXgtcmF0ZS1wcm9ibGVtLXdpdGgtaW1wb3J0aW5nLWludG8taGlrYXNob3A/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[soliver](/forum/user/35048-soliver "View soliver's Profile")** - [![soliver's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar35048.png)](/forum/user/35048-soliver "View soliver's Profile") Topic Author - [ Offline](/forum/user/35048-soliver) Less More - Posts: 15 - Thank you received: 0 - - 9 years 6 months ago [\#267299](#267299) by [soliver](/forum/user/35048-soliver "View soliver's Profile") Replied by *[soliver](/forum/user/35048-soliver "View soliver's Profile")* on topic *[Redshop Tax Rate Problem with Importing into HikaShop](/forum/37-import-export-csv-xls/889758-redshop-tax-rate-problem-with-importing-into-hikashop#267299 "-- HikaShop version -- : 3.0.1 -- Joomla version -- : 3.6.5 -- PHP version -- : 5.6.30 -- Browser(s) name and version -- : Safari 10.1 -- Error-message(debug-mod must be tuned on) -- : Unknown column 'rstr.tax_rate_id' in 'field list' SQL=INSERT IGNORE INTO `#__hikashop_tax` (`tax_namekey`,`tax_rate`) SELECT CONCAT('REDS_TAX_', rstr.tax_rate_id),rstr.tax_rate FROM `#__redshop_tax_rate` AS rstr WHERE rstr.tax_rate_id > 0 I am receiving the following error when trying to import RedShop. I can't even get out of the starting gate as soon as I click Import I get the error: Unknown column 'rstr.tax_rate_id' in 'field list' SQL=INSERT IGNORE INTO `#__hikashop_tax` (`tax_namekey`,`tax_rate`) SELECT CONCAT('REDS_TAX_', rstr.tax_rate_id),rstr.tax_rate FROM `#__redshop_tax_rate` AS rstr WHERE rstr.tax_rate_id > 0 The RedShop Shopping Cart has many Categories and Related Products. It would be very nice if I could get the Import function to work. Any help would be greatly appreciated. Thank You Scott")* Nicolas, Please see the Table Structure as you have requested. *This attachment is hidden for guests. Please log in or register to see it.* Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODk3NTgtcmVkc2hvcC10YXgtcmF0ZS1wcm9ibGVtLXdpdGgtaW1wb3J0aW5nLWludG8taGlrYXNob3A/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 9 years 6 months ago [\#267355](#267355) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Redshop Tax Rate Problem with Importing into HikaShop](/forum/37-import-export-csv-xls/889758-redshop-tax-rate-problem-with-importing-into-hikashop#267355 "-- HikaShop version -- : 3.0.1 -- Joomla version -- : 3.6.5 -- PHP version -- : 5.6.30 -- Browser(s) name and version -- : Safari 10.1 -- Error-message(debug-mod must be tuned on) -- : Unknown column 'rstr.tax_rate_id' in 'field list' SQL=INSERT IGNORE INTO `#__hikashop_tax` (`tax_namekey`,`tax_rate`) SELECT CONCAT('REDS_TAX_', rstr.tax_rate_id),rstr.tax_rate FROM `#__redshop_tax_rate` AS rstr WHERE rstr.tax_rate_id > 0 I am receiving the following error when trying to import RedShop. I can't even get out of the starting gate as soon as I click Import I get the error: Unknown column 'rstr.tax_rate_id' in 'field list' SQL=INSERT IGNORE INTO `#__hikashop_tax` (`tax_namekey`,`tax_rate`) SELECT CONCAT('REDS_TAX_', rstr.tax_rate_id),rstr.tax_rate FROM `#__redshop_tax_rate` AS rstr WHERE rstr.tax_rate_id > 0 The RedShop Shopping Cart has many Categories and Related Products. It would be very nice if I could get the Import function to work. Any help would be greatly appreciated. Thank You Scott")* Hi, Thanks. Unfortunately that didn't help. Could you provide a backend access, a FTP access and a database access via out contact form so that we can have a look at the situation ? [ www.hikashop.com/support/contact-us.html](https://www.hikashop.com/support/contact-us.html) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODk3NTgtcmVkc2hvcC10YXgtcmF0ZS1wcm9ibGVtLXdpdGgtaW1wb3J0aW5nLWludG8taGlrYXNob3A/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[soliver](/forum/user/35048-soliver "View soliver's Profile")** - [![soliver's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar35048.png)](/forum/user/35048-soliver "View soliver's Profile") Topic Author - [ Offline](/forum/user/35048-soliver) Less More - Posts: 15 - Thank you received: 0 - - 9 years 6 months ago [\#267428](#267428) by [soliver](/forum/user/35048-soliver "View soliver's Profile") Replied by *[soliver](/forum/user/35048-soliver "View soliver's Profile")* on topic *[Redshop Tax Rate Problem with Importing into HikaShop](/forum/37-import-export-csv-xls/889758-redshop-tax-rate-problem-with-importing-into-hikashop#267428 "-- HikaShop version -- : 3.0.1 -- Joomla version -- : 3.6.5 -- PHP version -- : 5.6.30 -- Browser(s) name and version -- : Safari 10.1 -- Error-message(debug-mod must be tuned on) -- : Unknown column 'rstr.tax_rate_id' in 'field list' SQL=INSERT IGNORE INTO `#__hikashop_tax` (`tax_namekey`,`tax_rate`) SELECT CONCAT('REDS_TAX_', rstr.tax_rate_id),rstr.tax_rate FROM `#__redshop_tax_rate` AS rstr WHERE rstr.tax_rate_id > 0 I am receiving the following error when trying to import RedShop. I can't even get out of the starting gate as soon as I click Import I get the error: Unknown column 'rstr.tax_rate_id' in 'field list' SQL=INSERT IGNORE INTO `#__hikashop_tax` (`tax_namekey`,`tax_rate`) SELECT CONCAT('REDS_TAX_', rstr.tax_rate_id),rstr.tax_rate FROM `#__redshop_tax_rate` AS rstr WHERE rstr.tax_rate_id > 0 The RedShop Shopping Cart has many Categories and Related Products. It would be very nice if I could get the Import function to work. Any help would be greatly appreciated. Thank You Scott")* Nicolas, I sent you the info you requested via the Contact Page. Thank You Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODk3NTgtcmVkc2hvcC10YXgtcmF0ZS1wcm9ibGVtLXdpdGgtaW1wb3J0aW5nLWludG8taGlrYXNob3A/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[soliver](/forum/user/35048-soliver "View soliver's Profile")** - [![soliver's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar35048.png)](/forum/user/35048-soliver "View soliver's Profile") Topic Author - [ Offline](/forum/user/35048-soliver) Less More - Posts: 15 - Thank you received: 0 - - 9 years 6 months ago [\#267639](#267639) by [soliver](/forum/user/35048-soliver "View soliver's Profile") Replied by *[soliver](/forum/user/35048-soliver "View soliver's Profile")* on topic *[Redshop Tax Rate Problem with Importing into HikaShop](/forum/37-import-export-csv-xls/889758-redshop-tax-rate-problem-with-importing-into-hikashop#267639 "-- HikaShop version -- : 3.0.1 -- Joomla version -- : 3.6.5 -- PHP version -- : 5.6.30 -- Browser(s) name and version -- : Safari 10.1 -- Error-message(debug-mod must be tuned on) -- : Unknown column 'rstr.tax_rate_id' in 'field list' SQL=INSERT IGNORE INTO `#__hikashop_tax` (`tax_namekey`,`tax_rate`) SELECT CONCAT('REDS_TAX_', rstr.tax_rate_id),rstr.tax_rate FROM `#__redshop_tax_rate` AS rstr WHERE rstr.tax_rate_id > 0 I am receiving the following error when trying to import RedShop. I can't even get out of the starting gate as soon as I click Import I get the error: Unknown column 'rstr.tax_rate_id' in 'field list' SQL=INSERT IGNORE INTO `#__hikashop_tax` (`tax_namekey`,`tax_rate`) SELECT CONCAT('REDS_TAX_', rstr.tax_rate_id),rstr.tax_rate FROM `#__redshop_tax_rate` AS rstr WHERE rstr.tax_rate_id > 0 The RedShop Shopping Cart has many Categories and Related Products. It would be very nice if I could get the Import function to work. Any help would be greatly appreciated. Thank You Scott")* Nicolas, Checking back with you. I sent the info you requested last week. I really would like to get this move from RedShop to Zika shop complete. Scott Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODk3NTgtcmVkc2hvcC10YXgtcmF0ZS1wcm9ibGVtLXdpdGgtaW1wb3J0aW5nLWludG8taGlrYXNob3A/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[soliver](/forum/user/35048-soliver "View soliver's Profile")** - [![soliver's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar35048.png)](/forum/user/35048-soliver "View soliver's Profile") Topic Author - [ Offline](/forum/user/35048-soliver) Less More - Posts: 15 - Thank you received: 0 - - 9 years 6 months ago [\#267870](#267870) by [soliver](/forum/user/35048-soliver "View soliver's Profile") Replied by *[soliver](/forum/user/35048-soliver "View soliver's Profile")* on topic *[Redshop Tax Rate Problem with Importing into HikaShop](/forum/37-import-export-csv-xls/889758-redshop-tax-rate-problem-with-importing-into-hikashop#267870 "-- HikaShop version -- : 3.0.1 -- Joomla version -- : 3.6.5 -- PHP version -- : 5.6.30 -- Browser(s) name and version -- : Safari 10.1 -- Error-message(debug-mod must be tuned on) -- : Unknown column 'rstr.tax_rate_id' in 'field list' SQL=INSERT IGNORE INTO `#__hikashop_tax` (`tax_namekey`,`tax_rate`) SELECT CONCAT('REDS_TAX_', rstr.tax_rate_id),rstr.tax_rate FROM `#__redshop_tax_rate` AS rstr WHERE rstr.tax_rate_id > 0 I am receiving the following error when trying to import RedShop. I can't even get out of the starting gate as soon as I click Import I get the error: Unknown column 'rstr.tax_rate_id' in 'field list' SQL=INSERT IGNORE INTO `#__hikashop_tax` (`tax_namekey`,`tax_rate`) SELECT CONCAT('REDS_TAX_', rstr.tax_rate_id),rstr.tax_rate FROM `#__redshop_tax_rate` AS rstr WHERE rstr.tax_rate_id > 0 The RedShop Shopping Cart has many Categories and Related Products. It would be very nice if I could get the Import function to work. Any help would be greatly appreciated. Thank You Scott")* Nickolas, Any idea when you might be able to help. I am in a real bind as I dislike RedShop but I cant get the help I need to Import the RedShop database into HikaShop. You guys are a lot smarter than I. I have run out of things to try and make this work. I really wanted this to be a HiikaShop Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODk3NTgtcmVkc2hvcC10YXgtcmF0ZS1wcm9ibGVtLXdpdGgtaW1wb3J0aW5nLWludG8taGlrYXNob3A/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 9 years 6 months ago [\#267873](#267873) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Redshop Tax Rate Problem with Importing into HikaShop](/forum/37-import-export-csv-xls/889758-redshop-tax-rate-problem-with-importing-into-hikashop#267873 "-- HikaShop version -- : 3.0.1 -- Joomla version -- : 3.6.5 -- PHP version -- : 5.6.30 -- Browser(s) name and version -- : Safari 10.1 -- Error-message(debug-mod must be tuned on) -- : Unknown column 'rstr.tax_rate_id' in 'field list' SQL=INSERT IGNORE INTO `#__hikashop_tax` (`tax_namekey`,`tax_rate`) SELECT CONCAT('REDS_TAX_', rstr.tax_rate_id),rstr.tax_rate FROM `#__redshop_tax_rate` AS rstr WHERE rstr.tax_rate_id > 0 I am receiving the following error when trying to import RedShop. I can't even get out of the starting gate as soon as I click Import I get the error: Unknown column 'rstr.tax_rate_id' in 'field list' SQL=INSERT IGNORE INTO `#__hikashop_tax` (`tax_namekey`,`tax_rate`) SELECT CONCAT('REDS_TAX_', rstr.tax_rate_id),rstr.tax_rate FROM `#__redshop_tax_rate` AS rstr WHERE rstr.tax_rate_id > 0 The RedShop Shopping Cart has many Categories and Related Products. It would be very nice if I could get the Import function to work. Any help would be greatly appreciated. Thank You Scott")* Hello, I'm sorry but that kind of work is very long and complicated. Due to the fact that our team is currently reduced for a short period (holidays) and Nicolas is currently traveling ( he will be in JoomlaDay Norway tomorrow ), it will be complicated for our team to provide a fast resolution ! Thank you for your understanding. --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODk3NTgtcmVkc2hvcC10YXgtcmF0ZS1wcm9ibGVtLXdpdGgtaW1wb3J0aW5nLWludG8taGlrYXNob3A/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[soliver](/forum/user/35048-soliver "View soliver's Profile")** - [![soliver's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar35048.png)](/forum/user/35048-soliver "View soliver's Profile") Topic Author - [ Offline](/forum/user/35048-soliver) Less More - Posts: 15 - Thank you received: 0 - - 9 years 6 months ago [\#268148](#268148) by [soliver](/forum/user/35048-soliver "View soliver's Profile") Replied by *[soliver](/forum/user/35048-soliver "View soliver's Profile")* on topic *[Redshop Tax Rate Problem with Importing into HikaShop](/forum/37-import-export-csv-xls/889758-redshop-tax-rate-problem-with-importing-into-hikashop#268148 "-- HikaShop version -- : 3.0.1 -- Joomla version -- : 3.6.5 -- PHP version -- : 5.6.30 -- Browser(s) name and version -- : Safari 10.1 -- Error-message(debug-mod must be tuned on) -- : Unknown column 'rstr.tax_rate_id' in 'field list' SQL=INSERT IGNORE INTO `#__hikashop_tax` (`tax_namekey`,`tax_rate`) SELECT CONCAT('REDS_TAX_', rstr.tax_rate_id),rstr.tax_rate FROM `#__redshop_tax_rate` AS rstr WHERE rstr.tax_rate_id > 0 I am receiving the following error when trying to import RedShop. I can't even get out of the starting gate as soon as I click Import I get the error: Unknown column 'rstr.tax_rate_id' in 'field list' SQL=INSERT IGNORE INTO `#__hikashop_tax` (`tax_namekey`,`tax_rate`) SELECT CONCAT('REDS_TAX_', rstr.tax_rate_id),rstr.tax_rate FROM `#__redshop_tax_rate` AS rstr WHERE rstr.tax_rate_id > 0 The RedShop Shopping Cart has many Categories and Related Products. It would be very nice if I could get the Import function to work. Any help would be greatly appreciated. Thank You Scott")* HikaShop, I feel stranded. I guess I need to know if you all can help me or should I stay with RedShop. I have a customer that is running out of patients and I need to deliver a working shopping cart. The RedShop is working but I just hate to use it if I can get HikaShop working. I have provided everything you have asked for but I don't see us moving forward. If you can help, when should I expect it? Thank you Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODk3NTgtcmVkc2hvcC10YXgtcmF0ZS1wcm9ibGVtLXdpdGgtaW1wb3J0aW5nLWludG8taGlrYXNob3A/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[soliver](/forum/user/35048-soliver "View soliver's Profile")** - [![soliver's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar35048.png)](/forum/user/35048-soliver "View soliver's Profile") Topic Author - [ Offline](/forum/user/35048-soliver) Less More - Posts: 15 - Thank you received: 0 - - 9 years 5 months ago [\#268827](#268827) by [soliver](/forum/user/35048-soliver "View soliver's Profile") Replied by *[soliver](/forum/user/35048-soliver "View soliver's Profile")* on topic *[Redshop Tax Rate Problem with Importing into HikaShop](/forum/37-import-export-csv-xls/889758-redshop-tax-rate-problem-with-importing-into-hikashop#268827 "-- HikaShop version -- : 3.0.1 -- Joomla version -- : 3.6.5 -- PHP version -- : 5.6.30 -- Browser(s) name and version -- : Safari 10.1 -- Error-message(debug-mod must be tuned on) -- : Unknown column 'rstr.tax_rate_id' in 'field list' SQL=INSERT IGNORE INTO `#__hikashop_tax` (`tax_namekey`,`tax_rate`) SELECT CONCAT('REDS_TAX_', rstr.tax_rate_id),rstr.tax_rate FROM `#__redshop_tax_rate` AS rstr WHERE rstr.tax_rate_id > 0 I am receiving the following error when trying to import RedShop. I can't even get out of the starting gate as soon as I click Import I get the error: Unknown column 'rstr.tax_rate_id' in 'field list' SQL=INSERT IGNORE INTO `#__hikashop_tax` (`tax_namekey`,`tax_rate`) SELECT CONCAT('REDS_TAX_', rstr.tax_rate_id),rstr.tax_rate FROM `#__redshop_tax_rate` AS rstr WHERE rstr.tax_rate_id > 0 The RedShop Shopping Cart has many Categories and Related Products. It would be very nice if I could get the Import function to work. Any help would be greatly appreciated. Thank You Scott")* Hello Fellow HikaShop users, Does anyone have any ideas on how I can import my RedShop Products into HikaShop. The Import feature does not work with RedShop and I can not get any help from the HikaShop team. It starts OK and then gets stuck on importing Categories. It imports the categories fine but does not move on to products, it just stays at categories, I dislike Redshop very much and want to make the move to Hikashop but I can not find any help. Thank you... Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODk3NTgtcmVkc2hvcC10YXgtcmF0ZS1wcm9ibGVtLXdpdGgtaW1wb3J0aW5nLWludG8taGlrYXNob3A/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.490 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)