[Skip to main content](#vessel-content) Board Categories Import & Export (CSV, XLS…) ## # [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "View Category 'Import & Export (CSV, XLS…)'") 782 topics | Questions about import and export will find an answer here | |---| ## | [ ](#forumbottom) | Subject | Replies / Views | Last Post | |---|---|---|---| | [](/forum/37-import-export-csv-xls/100000022-import-from-hikashop-what-exactly-it-imports) | ['Import from HikaShop' what exactly it imports?](/forum/37-import-export-csv-xls/100000022-import-from-hikashop-what-exactly-it-imports "-- url of the page with the problem -- : j6.studio-general.eu -- HikaShop version -- : 6.6.0 business -- Joomla version -- : 6.1.4 -- PHP version -- : 8.4 -- Browser(s) name and version -- : Firefox 115.0 -- Error-message(debug-mod must be tuned on) -- : no What EXACTLY does it import 'Import from HikaShop' ? Images, that's great, but what else? Also some shop-setup?  I don't want to destroy and start again the setup /views, taxes, etc./. Test-site, though.") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 4 weeks 2 days ago, by [janos](/forum/user/33148-janos "View janos's Profile") [Last Post](/forum/37-import-export-csv-xls/100000022-import-from-hikashop-what-exactly-it-imports#100000092 "Alright, I found in the present doc, that; Configuration settings Tax rates and zones Categories (with hierarchy) Products, variants, prices, and images Custom fields Users and addresses Coupons Orders, order addresses, and order products Order statuses Warehouses Shipping methods and payment methods (configurations included) That's a great tool for migrating an entire Shop, but I would need only for: Categories (with hierarchy) Products, variants, prices, and images Custom fields") 4 weeks 2 days ago by [janos](/forum/user/33148-janos "View janos's Profile") | Replies:1 Views:131 | [Last Post](/forum/37-import-export-csv-xls/100000022-import-from-hikashop-what-exactly-it-imports#100000092 "Alright, I found in the present doc, that; Configuration settings Tax rates and zones Categories (with hierarchy) Products, variants, prices, and images Custom fields Users and addresses Coupons Orders, order addresses, and order products Order statuses Warehouses Shipping methods and payment methods (configurations included) That's a great tool for migrating an entire Shop, but I would need only for: Categories (with hierarchy) Products, variants, prices, and images Custom fields") by [janos](/forum/user/33148-janos "View janos's Profile") 4 weeks 2 days ago | | [](/forum/37-import-export-csv-xls/910723-data-export-to-csv-wrong-formats-for-price) | [Data Export to CSV - wrong formats for price](/forum/37-import-export-csv-xls/910723-data-export-to-csv-wrong-formats-for-price "-- HikaShop version -- : 652 -- Joomla version -- : 547 -- PHP version -- : 8.3 -- Browser(s) name and version -- : firefox Hi there, when exporting products into CV-file in the column AT (=product_sort_price) some prices are shown in the right format (Excel. "Standard"). Others are given in a date-format, e.g. "Sep99"; although in the backend the correct price "9.99" (EUR) was entered. Please see CSV-file in attachment, column AT. Thanks. Rolf P.S.: Additional question - what format must CSV-file be stord CSV /S-DOS, or CSV-separators?") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 3 months 1 week ago, by [tkult120](/forum/user/78462-tkult120 "View tkult120's Profile") [Last Post](/forum/37-import-export-csv-xls/910723-data-export-to-csv-wrong-formats-for-price#372979 "Hi, There is no category import for now in HikaShop. You would have to do it via PHPMyAdmin's import feature on the hikashop_category table. It's possible but not that easy. AI could help you there. However, that's something we're working on for the next version of HikaShop in order to provide a proper import for categories.") 3 months 1 day ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:13 Views:652 | [Last Post](/forum/37-import-export-csv-xls/910723-data-export-to-csv-wrong-formats-for-price#372979 "Hi, There is no category import for now in HikaShop. You would have to do it via PHPMyAdmin's import feature on the hikashop_category table. It's possible but not that easy. AI could help you there. However, that's something we're working on for the next version of HikaShop in order to provide a proper import for categories.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 3 months 1 day ago | | [](/forum/37-import-export-csv-xls/910571-import-brands) | [Import Brands](/forum/37-import-export-csv-xls/910571-import-brands "-- HikaShop version -- : 6.5.0 -- Joomla version -- : 6 -- PHP version -- : 8.4 HI Team I noticed that I am able to import products into HikaShop, but I am having trouble finding the option to import brands. I have approximately 150-200 brands to add and do not want to do it manually. Is it possible to import these via a CSV file, or is there an option to use AI for this process within HikaShop please? Thank you") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 5 months 2 days ago, by [lucad](/forum/user/83792-lucad "View lucad's Profile") [Last Post](/forum/37-import-export-csv-xls/910571-import-brands#372171 "Noted Thank you Nicolas") 5 months 1 day ago by [lucad](/forum/user/83792-lucad "View lucad's Profile") | Replies:2 Views:422 | [Last Post](/forum/37-import-export-csv-xls/910571-import-brands#372171 "Noted Thank you Nicolas") by [lucad](/forum/user/83792-lucad "View lucad's Profile") 5 months 1 day ago | | [](/forum/37-import-export-csv-xls/910502-charecteristic-imported-accidentally) | [Charecteristic imported accidentally](/forum/37-import-export-csv-xls/910502-charecteristic-imported-accidentally "Hello. Client imported a csv and after that the 80% of products have a characteristic with no other values. No chold products . Can you please tell is where this information is kept so that we can delete it. I cannot find the characteristic "sockssize" in the products table.") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 5 months 4 weeks ago, by [verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile") [Last Post](/forum/37-import-export-csv-xls/910502-charecteristic-imported-accidentally#371807 "Hi, This indicates that you have an entry linking the characteristic with the main product in the hikashop_variant table without an entry linking one of the values of that characteristic with the main product in that same table.") 5 months 4 weeks ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:405 | [Last Post](/forum/37-import-export-csv-xls/910502-charecteristic-imported-accidentally#371807 "Hi, This indicates that you have an entry linking the characteristic with the main product in the hikashop_variant table without an entry linking one of the values of that characteristic with the main product in that same table.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 5 months 4 weeks ago | | [](/forum/37-import-export-csv-xls/910173-add-products-without-price-to-google-product-feed) | [Add products without price to google product feed](/forum/37-import-export-csv-xls/910173-add-products-without-price-to-google-product-feed "-- HikaShop version -- : 6.3.0 -- Joomla version -- : 5.3.0 -- PHP version -- : 8.1.32 Hi, Do you think it would be useful to have the option in the plg_hikashop_google_products plugin, to be able to select whether to also appear in the feed products that do not have set the price? At the moment, products that do not have a price do not appear in the feed and I have a situation where I would like to at least be able to generate the feed with all the products, even if I then deactivate the option.") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 7 months 3 weeks ago, by [oxido](/forum/user/29793-oxido "View oxido's Profile") [Last Post](/forum/37-import-export-csv-xls/910173-add-products-without-price-to-google-product-feed#370762 "Hi, Hi, The <g:price> attribute is required by Google Merchant Center. Products without a price would be rejected by Google and flagged as errors in your feed, which can negatively impact the health score of your entire feed. That's why the plugin excludes them. If you need all your products in the feed, the best approach would be to assign them a price (even a minimal one) rather than including them without one.") 7 months 3 weeks ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:481 | [Last Post](/forum/37-import-export-csv-xls/910173-add-products-without-price-to-google-product-feed#370762 "Hi, Hi, The attribute is required by Google Merchant Center. Products without a price would be rejected by Google and flagged as errors in your feed, which can negatively impact the health score of your entire feed. That's why the plugin excludes them. If you need all your products in the feed, the best approach would be to assign them a price (even a minimal one) rather than including them without one.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 7 months 3 weeks ago | | [](/forum/37-import-export-csv-xls/909989-prices-in-csv) | [Prices in CSV](/forum/37-import-export-csv-xls/909989-prices-in-csv "-- url of the page with the problem -- : metalearth.shop -- HikaShop version -- : 6.1.1 -- Joomla version -- : 5.4.0 -- PHP version -- : 8.2 -- Browser(s) name and version -- : firefox Hello, I want to change prices of products in my shop. So, I export to .CSV file, opened in EXCEL. Then prices are given in format "Standard" and e.g. like 14.99 (numbers with a DOT). When I change the price in this CSV-file the format is changed, e.g. "14.99" I want to change in "9.99" but what appears is "346094" ???? How can I solve this problem ? Thanks for help- Rolf") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 10 months 1 week ago, by [tkult120](/forum/user/78462-tkult120 "View tkult120's Profile") [Last Post](/forum/37-import-export-csv-xls/909989-prices-in-csv#369895 "Hi , all the best for you and the staff in 2026. Will check the COMMA/POINT issue . Best regards Rolf") 10 months 3 days ago by [tkult120](/forum/user/78462-tkult120 "View tkult120's Profile") | Replies:4 Views:621 | [Last Post](/forum/37-import-export-csv-xls/909989-prices-in-csv#369895 "Hi , all the best for you and the staff in 2026. Will check the COMMA/POINT issue . Best regards Rolf") by [tkult120](/forum/user/78462-tkult120 "View tkult120's Profile") 10 months 3 days ago | | [](/forum/37-import-export-csv-xls/909945-how-to-import-multilingual-products) | [How to import multilingual products](/forum/37-import-export-csv-xls/909945-how-to-import-multilingual-products "In documentation i see that it is a possibility to import products with different languages, but cant figure out how to do that. And yes, my system is ready for different languages and i see...") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 11 months 1 day ago, by [arnask](/forum/user/6752-arnask "View arnask's Profile") [Last Post](/forum/37-import-export-csv-xls/909945-how-to-import-multilingual-products#369638 "Hi, The HikaShop built in translation system indeed relies on the Joomla translation override files. Based on our tests, this works great as the PHP function to parse translation files is really optimized for it. If you wish for the translations to be stored in the database, that's possible too with the use of the extension Falang. The translation system in HikaShop will automatically integrate with it if it is installed on the website and store the translations in the database of Falang. However, due to the way Falang works, it can noticeably slow down a website.") 11 months 16 hours ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:675 | [Last Post](/forum/37-import-export-csv-xls/909945-how-to-import-multilingual-products#369638 "Hi, The HikaShop built in translation system indeed relies on the Joomla translation override files. Based on our tests, this works great as the PHP function to parse translation files is really optimized for it. If you wish for the translations to be stored in the database, that's possible too with the use of the extension Falang. The translation system in HikaShop will automatically integrate with it if it is installed on the website and store the translations in the database of Falang. However, due to the way Falang works, it can noticeably slow down a website.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 11 months 16 hours ago | | [](/forum/37-import-export-csv-xls/909941-product-data-images-imported-into-incorrect-product-record) | [Product data/images imported into incorrect product record](/forum/37-import-export-csv-xls/909941-product-data-images-imported-into-incorrect-product-record "-- HikaShop version -- : 6.1.1 -- Joomla version -- : ‎5.4.1 -- PHP version -- : 8.2.14 -- Browser(s) name and version -- : Firefox 145.0.1 -- Error-message(debug-mod must be tuned on) -- : no error message We are importing products on a scheduled basis from a CSV file. We noticed that some product data was being imported into an existing product that was not the same product as what was being imported, instead of creating a new product. We believe we've tracked it down to an issue with product codes being too similar and Hikashop potentially not taking into consideration the full product code. For example, we have several products that have codes like: Brookstone-1234 Brookstone-1432 Brookstone-1342 Regency-1234 Regency-1324 Regency-1432 What we're seeing is that in some cases, the product is missing but the product's images/data were imported into a different product of a similar name - eg. Brookstone-1432 doesn't exist but Brookstone-1234 contains images for Brookstone-1432. We have many other products importing without any issue. It's only products that have these similar product codes that are being erroneously merged in some cases.") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 11 months 2 days ago, by [3by400](/forum/user/6842-3by400 "View 3by400's Profile") [Last Post](/forum/37-import-export-csv-xls/909941-product-data-images-imported-into-incorrect-product-record#369640 "Understood. Thank you.") 11 months 16 hours ago by [3by400](/forum/user/6842-3by400 "View 3by400's Profile") | Replies:5 Views:573 | [Last Post](/forum/37-import-export-csv-xls/909941-product-data-images-imported-into-incorrect-product-record#369640 "Understood. Thank you.") by [3by400](/forum/user/6842-3by400 "View 3by400's Profile") 11 months 16 hours ago | | [](/forum/37-import-export-csv-xls/909942-force-thumbnail-regeneration-upon-product-import) | [Force thumbnail regeneration upon product import](/forum/37-import-export-csv-xls/909942-force-thumbnail-regeneration-upon-product-import "-- HikaShop version -- : 6.1.1 -- Joomla version -- : 5.4.1 -- PHP version -- : 8.2.14 -- Browser(s) name and version -- : Firefox 145.0.1 -- Error-message(debug-mod must be tuned on) -- : No error message We are importing products from a CSV file using the Hikashop Products Cron Update Plugin. Also, our client is keeping a consistent image file naming scheme, meaning even if the image has changed since the last import, the file name remains the same. This appears to result in the product thumbnails not being recreated when the import occurs. You can see from the link provided that the initial thumbnail is one image (the old image), but when clicking on the image to view the full size image its a different image (the new image.) Is there a way to force all thumbnails to be regenerated when products are imported?") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 11 months 2 days ago, by [3by400](/forum/user/6842-3by400 "View 3by400's Profile") [Last Post](/forum/37-import-export-csv-xls/909942-force-thumbnail-regeneration-upon-product-import#369625 "Thank you. We've setup a cron job to empty the thumbnails folder.") 11 months 1 day ago by [3by400](/forum/user/6842-3by400 "View 3by400's Profile") | Replies:2 Views:568 | [Last Post](/forum/37-import-export-csv-xls/909942-force-thumbnail-regeneration-upon-product-import#369625 "Thank you. We've setup a cron job to empty the thumbnails folder.") by [3by400](/forum/user/6842-3by400 "View 3by400's Profile") 11 months 1 day ago | | [](/forum/37-import-export-csv-xls/909866-import-prices) | [Import prices](/forum/37-import-export-csv-xls/909866-import-prices "Hello ! I have a csv importing quanity field that works perfectly with a mass action I created , trigered with a cron task every 30 minutes. The csv looks like this Now the client asks to update the column price. Will this work ? I m asking because I don t want to add new prices. Only replace the existing prices. Like the csv with the quantity does. Thank you.") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 11 months 4 weeks ago, by [verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile") [Last Post](/forum/37-import-export-csv-xls/909866-import-prices#369478 "Hi, If you don't have any price column in your CSV, the prices won't be touched for the products being imported / updated. Note however that the "product_quantity" column only supports integers, no floats so your current CSV won't work properly. If, by "product_quantity" you actually meant "price_value", then it is as you guessed: the price_access will be lost. In fact, if you have several prices added for the product, they will all be deleted to be replaced by the one in the CSV without any access level restriction.") 11 months 1 week ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:633 | [Last Post](/forum/37-import-export-csv-xls/909866-import-prices#369478 "Hi, If you don't have any price column in your CSV, the prices won't be touched for the products being imported / updated. Note however that the "product_quantity" column only supports integers, no floats so your current CSV won't work properly. If, by "product_quantity" you actually meant "price_value", then it is as you guessed: the price_access will be lost. In fact, if you have several prices added for the product, they will all be deleted to be replaced by the one in the CSV without any access level restriction.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 11 months 1 week ago | | [](/forum/37-import-export-csv-xls/909718-how-to-set-default-variant-in-import-file) | [How to set default variant in import file.](/forum/37-import-export-csv-xls/909718-how-to-set-default-variant-in-import-file "-- HikaShop version -- : 6.1.0 -- Joomla version -- : 5.3.3 -- PHP version -- : 8.2.14 -- Browser(s) name and version -- : Firefox -- Error-message(debug-mod must be tuned on) -- : The default value of one of the characteristics of that product isn't available as a variant. Please check the characteristics and variants of that product When importing variants via a CSV how do we set the default variant? I'm not seeing a column used to set that value. As a consequence of not having the default variant set in the import, all variants are being set as default and on the frontend we see this message on the product details view: "The default value of one of the characteristics of that product isn't available as a variant. Please check the characteristics and variants of that product" When I manually edit the product and set a single default variant and save, then the error on the frontend clears.") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 1 year 1 month ago, by [3by400](/forum/user/6842-3by400 "View 3by400's Profile") [Last Post](/forum/37-import-export-csv-xls/909718-how-to-set-default-variant-in-import-file#368591 "Hi, When you import a CSV with products with variants, you have one row for the main products and one row for each variant. And you have one column for each characteristic. On the row of the main products in the characteristic columns, you can provide the default value for each characteristic so that it corresponds to one of the variant.") 1 year 1 month ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:1203 | [Last Post](/forum/37-import-export-csv-xls/909718-how-to-set-default-variant-in-import-file#368591 "Hi, When you import a CSV with products with variants, you have one row for the main products and one row for each variant. And you have one column for each characteristic. On the row of the main products in the characteristic columns, you can provide the default value for each characteristic so that it corresponds to one of the variant.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 1 year 1 month ago | | [](/forum/37-import-export-csv-xls/909569-apply-enter-user-address-function-to-already-imported-orders) | [Apply 'Enter user address' function to already imported orders?](/forum/37-import-export-csv-xls/909569-apply-enter-user-address-function-to-already-imported-orders "-- HikaShop version -- : 6.0.0 -- Joomla version -- : 5.3.2 -- PHP version -- : 8.2.28 Hello, I have imported several orders via CSV, and each one is correctly assigned a user_id. The user is properly linked in the backend, but the address data is not filled in. When assigning a user manually to an order in the backend, a popup appears with the switch "Enter user address", which fills in the user's address fields in the order. Is there a way to apply this action in bulk or automatically to existing orders? That is, to have the user's address data applied to orders that already exist, as if the switch had been activated manually. Thanks for your help.") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 1 year 3 months ago, by [UPL](/forum/user/83461-upl "View UPL's Profile") [Last Post](/forum/37-import-export-csv-xls/909569-apply-enter-user-address-function-to-already-imported-orders#367846 "Hi, There is no ready made tool for this. However, it should be fairly easy to configure a mass action (menu System>Mass actions) to do that: www.hikashop.com/support/documentation/167-massaction-form.html You'll want to : - use the "order" data - use a filter on "order_billing_address_id" being equal to 0 - use an action "run MySQL query" with the query: When you run that mass action, it will process all the orders (the first 500 if you leave the "limitation" value to 500. You can potentially increase that value to a few thousands, but more than that and the PHP process will likely crash in the middle. However, you can just process the mass action several times until all the orders are processed) and set the billing address of these orders to be one of the billing addresses of the user. Then, rinse and repeat for "shipping" instead of "billing" if you also want to set the shipping address.") 1 year 3 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:1204 | [Last Post](/forum/37-import-export-csv-xls/909569-apply-enter-user-address-function-to-already-imported-orders#367846 "Hi, There is no ready made tool for this. However, it should be fairly easy to configure a mass action (menu System>Mass actions) to do that: www.hikashop.com/support/documentation/167-massaction-form.html You'll want to : - use the "order" data - use a filter on "order_billing_address_id" being equal to 0 - use an action "run MySQL query" with the query: When you run that mass action, it will process all the orders (the first 500 if you leave the "limitation" value to 500. You can potentially increase that value to a few thousands, but more than that and the PHP process will likely crash in the middle. However, you can just process the mass action several times until all the orders are processed) and set the billing address of these orders to be one of the billing addresses of the user. Then, rinse and repeat for "shipping" instead of "billing" if you also want to set the shipping address.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 1 year 3 months ago | | [](/forum/37-import-export-csv-xls/909242-import-error-array-change-key-case-argument-1-array-must-be-of-type-array) | [Import error array\_change\_key\_case(): Argument #1 ($array) must be of type array](/forum/37-import-export-csv-xls/909242-import-error-array-change-key-case-argument-1-array-must-be-of-type-array "-- HikaShop version -- : 5.1.5 -- Joomla version -- : 5.2.3 -- PHP version -- : 8.3 Hello! I created a csv to import and I get array_change_key_case(): Argument #1 ($array) must be of type array, false given Can you help please?") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 1 year 7 months ago, by [verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile") [Last Post](/forum/37-import-export-csv-xls/909242-import-error-array-change-key-case-argument-1-array-must-be-of-type-array#366528 "Hi, Maybe the configuration of your server changed somehow? Like an update of PHP ? Note that it could also be a security mechanism, like a firewall extension, or a modification of the htaccess, which blocks the download of the images. Unfortunately, not much HikaShop can do by itself. If PHP can't download the file of the image with the URL provided, it can't do it, and no PHP code in HikaShop can fix that. That's why I proposed to circumvent the problem. But if you can figure out what is blocking PHP from accessing the files (maybe your hosting can help with this ?), then it should be easy to correct the problem, allowing PHP, and thus HikaShop, to access the URLs again.") 1 year 7 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:6 Views:1148 | [Last Post](/forum/37-import-export-csv-xls/909242-import-error-array-change-key-case-argument-1-array-must-be-of-type-array#366528 "Hi, Maybe the configuration of your server changed somehow? Like an update of PHP ? Note that it could also be a security mechanism, like a firewall extension, or a modification of the htaccess, which blocks the download of the images. Unfortunately, not much HikaShop can do by itself. If PHP can't download the file of the image with the URL provided, it can't do it, and no PHP code in HikaShop can fix that. That's why I proposed to circumvent the problem. But if you can figure out what is blocking PHP from accessing the files (maybe your hosting can help with this ?), then it should be easy to correct the problem, allowing PHP, and thus HikaShop, to access the URLs again.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 1 year 7 months ago | | [](/forum/37-import-export-csv-xls/909293-product-export-undefined-array-key-error) | [Product Export Undefined Array Key Error](/forum/37-import-export-csv-xls/909293-product-export-undefined-array-key-error "-- HikaShop version -- : 5.1.5 -- Joomla version -- : 4.4.12 -- PHP version -- : 8.2.27 -- Browser(s) name and version -- : Firefox 136.0.4 -- Error-message(debug-mod must be tuned on) -- : No system error messages are displayed. In Products when I try to Export, I receive these error messages: Warning: Undefined array key 0 in .../administrator/components/com_hikashop/views/product/tmpl/export.php on line 163 Warning: Attempt to read property "currency_code" on null in .../administrator/components/com_hikashop/views/product/tmpl/export.php on line 163 Warning: Cannot modify header information - headers already sent by (output started at .../administrator/components/com_hikashop/views/product/tmpl/export.php:163) in .../administrator/components/com_hikashop/helpers/spreadsheet.php on line 82 Warning: Cannot modify header information - headers already sent by (output started at .../administrator/components/com_hikashop/views/product/tmpl/export.php:163) in .../administrator/components/com_hikashop/helpers/spreadsheet.php on line 83 How can I repair the Export function and download the spreadsheet?") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 1 year 7 months ago, by [cmb](/forum/user/9805-cmb "View cmb's Profile") [Last Post](/forum/37-import-export-csv-xls/909293-product-export-undefined-array-key-error#366443 "Hi, Thank you for your feedback. Adding a message on the screen is not possible. When an export is done, the file is sent back to the browser for it to trigger the file download process (which opens the dialog box for the user to save the file where he wants on his computer). As far as I know, it is not technically possible to return to the browser something else than the file at the same time in order to display a message. The only option would be to cancel the export to display the error message. Basically, what was already happening before, but with a nicer message. I think the error is minor enough (the currency column just won't have anything in it for these products in the exported file), and rarer enough (no one else reported the problem in 15 years even though that potential error was always there and clearly blocking as the error couldn't be bypassed. So if someone else would have had the problem, they would have definitely reported it), that it is not that big of a deal to not let the user know directly about the problem and block him from getting his export file. That's why I decided to log an error and let the export proceed. Regarding the log files, we don't want to delete anything normally. Sometimes, you want to be able to look at the logs weeks after something happened. And if the administrator really wants to delete them, he can do so via FTP. So I'm not sure if we want to offer that capability. We'll see. Thanks for your input.") 1 year 7 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:5 Views:878 | [Last Post](/forum/37-import-export-csv-xls/909293-product-export-undefined-array-key-error#366443 "Hi, Thank you for your feedback. Adding a message on the screen is not possible. When an export is done, the file is sent back to the browser for it to trigger the file download process (which opens the dialog box for the user to save the file where he wants on his computer). As far as I know, it is not technically possible to return to the browser something else than the file at the same time in order to display a message. The only option would be to cancel the export to display the error message. Basically, what was already happening before, but with a nicer message. I think the error is minor enough (the currency column just won't have anything in it for these products in the exported file), and rarer enough (no one else reported the problem in 15 years even though that potential error was always there and clearly blocking as the error couldn't be bypassed. So if someone else would have had the problem, they would have definitely reported it), that it is not that big of a deal to not let the user know directly about the problem and block him from getting his export file. That's why I decided to log an error and let the export proceed. Regarding the log files, we don't want to delete anything normally. Sometimes, you want to be able to look at the logs weeks after something happened. And if the administrator really wants to delete them, he can do so via FTP. So I'm not sure if we want to offer that capability. We'll see. Thanks for your input.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 1 year 7 months ago | | [](/forum/37-import-export-csv-xls/907263-export) | [Export](/forum/37-import-export-csv-xls/907263-export "-- HikaShop version -- : 5.0.0 -- Joomla version -- : 3.10.12. -- PHP version -- : 8.1 -- Browser(s) name and version -- : Firefox 119.0.1 (64bit) Hi How do i do a full export of all the products, products information, price and all the phots. What i need to do is export it from joomla 3 to a new site i am going to build on joomla 4 or 5. Thanks in advance for all your help") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 2 years 11 months ago, by [Uniweb](/forum/user/40722-uniweb "View Uniweb's Profile") [Last Post](/forum/37-import-export-csv-xls/907263-export#365838 "Hi, The characteristics are in the table hikashop_characteristic, the variants are in the table hikashop_product, along with the products, and the links between the variants / products and the characteristics / values are in the table hikashop_variant. So, if you followed my previous instructions and exported / imported all the hikashop_* tables, it should also include these 3 tables and you shouldn't have lost your characteristics. So I'm not sure what you did to loose them.") 1 year 8 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:4 Views:1444 | [Last Post](/forum/37-import-export-csv-xls/907263-export#365838 "Hi, The characteristics are in the table hikashop_characteristic, the variants are in the table hikashop_product, along with the products, and the links between the variants / products and the characteristics / values are in the table hikashop_variant. So, if you followed my previous instructions and exported / imported all the hikashop_* tables, it should also include these 3 tables and you shouldn't have lost your characteristics. So I'm not sure what you did to loose them.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 1 year 8 months ago | | [](/forum/37-import-export-csv-xls/909187-clone-hikashop-to-a-new-site) | [Clone Hikashop to a new site](/forum/37-import-export-csv-xls/909187-clone-hikashop-to-a-new-site "-- url of the page with the problem -- : www.polytaridis.gr -- HikaShop version -- : 5.0.0 -- Joomla version -- : 3.10.12 -- PHP version -- : 8.1.31 Hello, I have a Hikashop installation with over 5000 products hosted on a Joomla 3.10.12 site. I tried to upgrade the Joomla site but had many issues, so I decided to make a new one from scratch. How to make a full backup of my Hikashop? I mean everything: settings, products, categories, taxes, zones, payments, shipping, orders, plugins, etc. so to migrate to the new site? Best regards. Makis") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 1 year 8 months ago, by [xatzopou](/forum/user/35543-xatzopou "View xatzopou's Profile") [Last Post](/forum/37-import-export-csv-xls/909187-clone-hikashop-to-a-new-site#365840 "Hi, You can do it via PHPMyAdmin for the database and FTP for the uploaded images / files, as per : www.hikashop.com/support/forum/install-u...-joomla4.html#346259") 1 year 8 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:827 | [Last Post](/forum/37-import-export-csv-xls/909187-clone-hikashop-to-a-new-site#365840 "Hi, You can do it via PHPMyAdmin for the database and FTP for the uploaded images / files, as per : www.hikashop.com/support/forum/install-u...-joomla4.html#346259") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 1 year 8 months ago | | [](/forum/37-import-export-csv-xls/908981-corrected-url-for-a-link-in-the-import-documentation) | [Corrected URL for a Link in the Import Documentation](/forum/37-import-export-csv-xls/908981-corrected-url-for-a-link-in-the-import-documentation "-- url of the page with the problem -- : www.hikashop.com/support/documentation/7...port.html#virtuemart -- HikaShop version -- : 5.1.2 -- Joomla version -- : 4.4.9 -- PHP version -- : 8.2.26 -- Browser(s) name and version -- : Firefox 133.0.3 -- Error-message(debug-mod must be tuned on) -- : none The link in the last paragraph of the www.hikashop.com/support/documentation/7...port.html#virtuemart section should be corrected. The Export VirtueMart data and import to HikaShop tutorial has moved to rolandd.com/documentation/ro-csvi/hikash...d-import-to-hikashop .") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 1 year 10 months ago, by [cmb](/forum/user/9805-cmb "View cmb's Profile") [Last Post](/forum/37-import-export-csv-xls/908981-corrected-url-for-a-link-in-the-import-documentation#365007 "Hello, Thanks for your report! We have correct this. Best regards") 1 year 10 months ago by [Philip](/forum/user/34318-philip "View Philip's Profile") | Replies:1 Views:926 | [Last Post](/forum/37-import-export-csv-xls/908981-corrected-url-for-a-link-in-the-import-documentation#365007 "Hello, Thanks for your report! We have correct this. Best regards") by [Philip](/forum/user/34318-philip "View Philip's Profile") 1 year 10 months ago | | [](/forum/37-import-export-csv-xls/908980-issue-when-importing) | [Issue when importing.](/forum/37-import-export-csv-xls/908980-issue-when-importing "-- url of the page with the problem -- : ayam.com -- HikaShop version -- : 5.1.2 Hi, We are running some test on the website. While we are importing the file to the Hikashop, we empty the column for product categories and product related on the file. But on the Hikashop we have field for the product categories and product related. While importing the file, it not overwrite and empty the column for field on product categories and product related. Can you explain about this issue?") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 1 year 10 months ago, by [alainz](/forum/user/44013-alainz "View alainz's Profile") [Last Post](/forum/37-import-export-csv-xls/908980-issue-when-importing#365003 "Hi, Thanks for your feedback. HikaShop doesn't allow a product to not be linked to any category. If that was the case, then you wouldn't be able to find the products without categories on the frontend or backend. In fact, if you try to remove all the categories of a product in the backend interface, HikaShop will link it to the main category of the shop automatically in order to avoid having the product without any category. So, if you provide a CSV with nothing in the "categories" column, the import system will just ignore it. So what you're talking about is meant to be this way for a good reason. However, regarding the related products, you're indeed correct that this case is currently not supported while it would make sense to support it. In fact, it's the same for options and bundles. So, I've looked into it and I've made a patch to support that. Download again the install package of the 5.1.2 on our website and install it on yours and you'll get the patch to support that.") 1 year 10 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:891 | [Last Post](/forum/37-import-export-csv-xls/908980-issue-when-importing#365003 "Hi, Thanks for your feedback. HikaShop doesn't allow a product to not be linked to any category. If that was the case, then you wouldn't be able to find the products without categories on the frontend or backend. In fact, if you try to remove all the categories of a product in the backend interface, HikaShop will link it to the main category of the shop automatically in order to avoid having the product without any category. So, if you provide a CSV with nothing in the "categories" column, the import system will just ignore it. So what you're talking about is meant to be this way for a good reason. However, regarding the related products, you're indeed correct that this case is currently not supported while it would make sense to support it. In fact, it's the same for options and bundles. So, I've looked into it and I've made a patch to support that. Download again the install package of the 5.1.2 on our website and install it on yours and you'll get the patch to support that.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 1 year 10 months ago | | [](/forum/37-import-export-csv-xls/908859-xml-feed-products) | [xml feed products](/forum/37-import-export-csv-xls/908859-xml-feed-products "-- HikaShop version -- : 5.1.1 -- Joomla version -- : 4.9 -- PHP version -- : 8.2 Hello, I'm using the shop for the first time and everything is working fine. I now want to create an XML feed so that I can transfer the articles. Where can I find the XML file for this? Atom and RSS feed are activated. Thanks for the help") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 1 year 11 months ago, by [thhu](/forum/user/82891-thhu "View thhu's Profile") [Last Post](/forum/37-import-export-csv-xls/908859-xml-feed-products#364451 "Thanks for the quick help. I hope it works") 1 year 11 months ago by [thhu](/forum/user/82891-thhu "View thhu's Profile") | Replies:9 Views:1070 | [Last Post](/forum/37-import-export-csv-xls/908859-xml-feed-products#364451 "Thanks for the quick help. I hope it works") by [thhu](/forum/user/82891-thhu "View thhu's Profile") 1 year 11 months ago | | [](/forum/37-import-export-csv-xls/908833-updating-product-codes-using-import-function) | [Updating Product Codes Using Import Function](/forum/37-import-export-csv-xls/908833-updating-product-codes-using-import-function "-- HikaShop version -- : 5.1.1 Biz -- Joomla version -- : 4.4.9 -- PHP version -- : 8.2.25 -- Browser(s) name and version -- : Firefox -- Error-message(debug-mod must be tuned on) -- : none Greetings, My client is redefining their part #'s. We have over 700 product codes to update including both main products and variants. I'm attempting to use the product import function to perform these updates. After some trial and error I've found a .csv file format that uploads without generating hikashop errors. My latest iteration of .csv file format looks like this..... product_id,product_parent_id,product_code,product_type 557,556,8511-BX,variant 558,556,8511-CS,variant 570,,690-159200201,main 581,,6400-SERIES,main 601,,TYPE-I-BARRICADE-SERIES,main 602,,TYPE-II-BARRICADE-SERIES,main ..... It successfully uploads but leaves me with mixed results.... - some main products and variants update fine - some update the product_code but also alter other fields.....descriptions, seo fields and others contents have disappeared, quantity has been changed to 0 - some products are updated in the database but no longer appear in the front end nor backend of the site. got any ideas on what i;m doing wrong ? your support is always appreciated, Dave") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 1 year 11 months ago, by [daduts](/forum/user/1658-daduts "View daduts's Profile") [Last Post](/forum/37-import-export-csv-xls/908833-updating-product-codes-using-import-function#364318 "Hi, No, the mass action import also bases itself on the product_code, not the product_id.") 1 year 11 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:1206 | [Last Post](/forum/37-import-export-csv-xls/908833-updating-product-codes-using-import-function#364318 "Hi, No, the mass action import also bases itself on the product_code, not the product_id.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 1 year 11 months ago | | [ ](#forumtop) | | [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.057 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)