[Skip to main content](#vessel-content) # Wrong data when reïmporting product variants ## - **[Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")** - [![Marjoline's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/time_eye.jpg)](/forum/user/32405-marjoline "View Marjoline's Profile") Topic Author - [ Offline](/forum/user/32405-marjoline) Less More - Posts: 52 - Thank you received: 0 - - 10 years 11 months ago [\#221055](#221055) by [Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile") *[Wrong data when reïmporting product variants](/forum/37-import-export-csv-xls/880551-wrong-data-when-reimporting-product-variants#221055 "-- HikaShop version -- : Up to date -- Joomla version -- : Recent -- PHP version -- : 5.5.24 -- Browser(s) name and version -- : Multiple browsers -- Error-message(debug-mod must be tuned on) -- : No error message, only wrong data Hi, hope you can help us with this problem. We are in urgent need of suddenly updating a large number of prices a.o. for option variants. A. We exported the option variants and imported into MS Access, where we changed the prices. B. We reimported the option variants with the new prices into our test system 123.valkyrie-guitars.com. To our dismay we found that the system had replaced null values and some others with the price of 999.9900. C. We re-exported the option variants to be able to show you this behaviour. We made screen prints of the csv and txt files as they opened in excel, to show you the strange changes. What is happening here, and how can we avoid the system adding fictive 999.9900 prices to our product variants? Cheers, Marjoline P.s.: The *.txt files for A. and C. were actually csv files, I had to change the extension because this form would not let me upload *.csv files.")* was created by *[Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")* -- HikaShop version -- : Up to date -- Joomla version -- : Recent -- PHP version -- : 5.5.24 -- Browser(s) name and version -- : Multiple browsers -- Error-message(debug-mod must be tuned on) -- : No error message, only wrong data Hi, hope you can help us with this problem. We are in urgent need of suddenly updating a large number of prices a.o. for option variants. A. We exported the option variants and imported into MS Access, where we changed the prices. B. We reimported the option variants with the new prices into our test system 123.valkyrie-guitars.com. To our dismay we found that the system had replaced null values and some others with the price of 999.9900. C. We re-exported the option variants to be able to show you this behaviour. We made screen prints of the csv and txt files as they opened in excel, to show you the strange changes. What is happening here, and how can we avoid the system adding fictive 999.9900 prices to our product variants? Cheers, Marjoline P.s.: The *.txt files for A. and C. were actually csv files, I had to change the extension because this form would not let me upload *.csv files. - [ ![A-image.png](/forum/attachment/27743) ](/forum/attachment/27743 "A-image.png") [ ](/forum/attachment/27743?download=1 "A-image.png") - [ ![B-image.png](/forum/attachment/27745) ](/forum/attachment/27745 "B-image.png") [ ](/forum/attachment/27745?download=1 "B-image.png") - [ ![C-image.png](/forum/attachment/27747) ](/forum/attachment/27747 "C-image.png") [ ](/forum/attachment/27747?download=1 "C-image.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODA1NTEtd3JvbmctZGF0YS13aGVuLXJlaW1wb3J0aW5nLXByb2R1Y3QtdmFyaWFudHM/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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 10 years 11 months ago [\#221787](#221787) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Wrong data when reïmporting product variants](/forum/37-import-export-csv-xls/880551-wrong-data-when-reimporting-product-variants#221787 "-- HikaShop version -- : Up to date -- Joomla version -- : Recent -- PHP version -- : 5.5.24 -- Browser(s) name and version -- : Multiple browsers -- Error-message(debug-mod must be tuned on) -- : No error message, only wrong data Hi, hope you can help us with this problem. We are in urgent need of suddenly updating a large number of prices a.o. for option variants. A. We exported the option variants and imported into MS Access, where we changed the prices. B. We reimported the option variants with the new prices into our test system 123.valkyrie-guitars.com. To our dismay we found that the system had replaced null values and some others with the price of 999.9900. C. We re-exported the option variants to be able to show you this behaviour. We made screen prints of the csv and txt files as they opened in excel, to show you the strange changes. What is happening here, and how can we avoid the system adding fictive 999.9900 prices to our product variants? Cheers, Marjoline P.s.: The *.txt files for A. and C. were actually csv files, I had to change the extension because this form would not let me upload *.csv files.")* Hi, Hi, We are not able to reproduce the problem. I've imported the B CSV on a test website on my end and the products didn't get a price of 999.99 Could it be that you configured some mass actions via the menu System>Mass actions which would do that ? What if you disable all your mass actions ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODA1NTEtd3JvbmctZGF0YS13aGVuLXJlaW1wb3J0aW5nLXByb2R1Y3QtdmFyaWFudHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")** - [![Marjoline's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/time_eye.jpg)](/forum/user/32405-marjoline "View Marjoline's Profile") Topic Author - [ Offline](/forum/user/32405-marjoline) Less More - Posts: 52 - Thank you received: 0 - - 10 years 11 months ago [\#221841](#221841) by [Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile") Replied by *[Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")* on topic *[Wrong data when reïmporting product variants](/forum/37-import-export-csv-xls/880551-wrong-data-when-reimporting-product-variants#221841 "-- HikaShop version -- : Up to date -- Joomla version -- : Recent -- PHP version -- : 5.5.24 -- Browser(s) name and version -- : Multiple browsers -- Error-message(debug-mod must be tuned on) -- : No error message, only wrong data Hi, hope you can help us with this problem. We are in urgent need of suddenly updating a large number of prices a.o. for option variants. A. We exported the option variants and imported into MS Access, where we changed the prices. B. We reimported the option variants with the new prices into our test system 123.valkyrie-guitars.com. To our dismay we found that the system had replaced null values and some others with the price of 999.9900. C. We re-exported the option variants to be able to show you this behaviour. We made screen prints of the csv and txt files as they opened in excel, to show you the strange changes. What is happening here, and how can we avoid the system adding fictive 999.9900 prices to our product variants? Cheers, Marjoline P.s.: The *.txt files for A. and C. were actually csv files, I had to change the extension because this form would not let me upload *.csv files.")* Hi, We are going to help you on this one I think. We will update our test environment to the current situation and give you access. My webmaster has discovered that there is significant behaviour difference when reuploading "old-style"-processed variants, which come out just fine, no problem there. But when re-uploading new style variants as created after a recent major Hikashop updat, the trouble begins. Our webmaster had the impression that perhaps the import/export functionalities for variants have not completely kept up with the new processes around the Hikashop variant functionalities. We will try to get a suitable test environment available to you tomorrow. Thanks for looking into it so far for us. Cheers, Marjoline Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODA1NTEtd3JvbmctZGF0YS13aGVuLXJlaW1wb3J0aW5nLXByb2R1Y3QtdmFyaWFudHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")** - [![Marjoline's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/time_eye.jpg)](/forum/user/32405-marjoline "View Marjoline's Profile") Topic Author - [ Offline](/forum/user/32405-marjoline) Less More - Posts: 52 - Thank you received: 0 - - 10 years 11 months ago - 10 years 11 months ago [\#222889](#222889) by [Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile") Replied by *[Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")* on topic *[Wrong data when reïmporting product variants](/forum/37-import-export-csv-xls/880551-wrong-data-when-reimporting-product-variants#222889 "-- HikaShop version -- : Up to date -- Joomla version -- : Recent -- PHP version -- : 5.5.24 -- Browser(s) name and version -- : Multiple browsers -- Error-message(debug-mod must be tuned on) -- : No error message, only wrong data Hi, hope you can help us with this problem. We are in urgent need of suddenly updating a large number of prices a.o. for option variants. A. We exported the option variants and imported into MS Access, where we changed the prices. B. We reimported the option variants with the new prices into our test system 123.valkyrie-guitars.com. To our dismay we found that the system had replaced null values and some others with the price of 999.9900. C. We re-exported the option variants to be able to show you this behaviour. We made screen prints of the csv and txt files as they opened in excel, to show you the strange changes. What is happening here, and how can we avoid the system adding fictive 999.9900 prices to our product variants? Cheers, Marjoline P.s.: The *.txt files for A. and C. were actually csv files, I had to change the extension because this form would not let me upload *.csv files.")* Ok, we have now recreated the site in a test environment that we can let you access, how do we proceed? We have also encountered another urgent problem, probably associated. If customers order an item that has options (which have the variant choices), it now throws the checkout process into confusion. We want to bill the customers once for the shipment. However, customers are billed separately by the system for the shipping of the products which do not have options, and a second time for the products which do have options, see attached image. So the shipping part of the checkout process is duplicated. How can we ensure that shipping is only charged once to the customer? This is very embarrassing and will definitely cost us customers. It has only come about since we reïmported the new prices for the variant options. I have now sent in details of the testsite through your contact form. The products which cause the problems are from this series: [ 123.valkyrie-guitars.com/nl/webshop/category/23-ml-factory.html](https://123.valkyrie-guitars.com/nl/webshop/category/23-ml-factory.html) and then particularly with those which have options, which is most of the MLFactory guitars. If you order any of those, even without choosing any options, and then you ad anything more, like a can of spray paint, these problems start showing. The MLFactory guitars are the ones for which we had to export and import the data in order to change the prices. Kind regards, Marjoline - [ ![Cart_2015-12-02_23_49_00.png](/forum/attachment/28164) ](/forum/attachment/28164 "...2_23_49_00.png") [ ](/forum/attachment/28164?download=1 "...2_23_49_00.png") - [ ![Double-shipping-charge-2015-12-02_23_52_57.png](/forum/attachment/28165) ](/forum/attachment/28165 "...2_23_52_57.png") [ ](/forum/attachment/28165?download=1 "...2_23_52_57.png") - [ ![Shipping-12-02-23_51_08.png](/forum/attachment/28166) ](/forum/attachment/28166 "...2-23_51_08.png") [ ](/forum/attachment/28166?download=1 "...2-23_51_08.png") Last edit: 10 years 11 months ago by [Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODA1NTEtd3JvbmctZGF0YS13aGVuLXJlaW1wb3J0aW5nLXByb2R1Y3QtdmFyaWFudHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")** - [![Marjoline's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/time_eye.jpg)](/forum/user/32405-marjoline "View Marjoline's Profile") Topic Author - [ Offline](/forum/user/32405-marjoline) Less More - Posts: 52 - Thank you received: 0 - - 10 years 11 months ago [\#222890](#222890) by [Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile") Replied by *[Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")* on topic *[Wrong data when reïmporting product variants](/forum/37-import-export-csv-xls/880551-wrong-data-when-reimporting-product-variants#222890 "-- HikaShop version -- : Up to date -- Joomla version -- : Recent -- PHP version -- : 5.5.24 -- Browser(s) name and version -- : Multiple browsers -- Error-message(debug-mod must be tuned on) -- : No error message, only wrong data Hi, hope you can help us with this problem. We are in urgent need of suddenly updating a large number of prices a.o. for option variants. A. We exported the option variants and imported into MS Access, where we changed the prices. B. We reimported the option variants with the new prices into our test system 123.valkyrie-guitars.com. To our dismay we found that the system had replaced null values and some others with the price of 999.9900. C. We re-exported the option variants to be able to show you this behaviour. We made screen prints of the csv and txt files as they opened in excel, to show you the strange changes. What is happening here, and how can we avoid the system adding fictive 999.9900 prices to our product variants? Cheers, Marjoline P.s.: The *.txt files for A. and C. were actually csv files, I had to change the extension because this form would not let me upload *.csv files.")* In reply to the suggestion about mass actions, to my knowledge we have not used that functionality so far. Though looking at it now, it seems a very interesting functionality well worth using. But we will not confuse things by starting to use it right now. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODA1NTEtd3JvbmctZGF0YS13aGVuLXJlaW1wb3J0aW5nLXByb2R1Y3QtdmFyaWFudHM/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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 10 years 11 months ago [\#223029](#223029) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Wrong data when reïmporting product variants](/forum/37-import-export-csv-xls/880551-wrong-data-when-reimporting-product-variants#223029 "-- HikaShop version -- : Up to date -- Joomla version -- : Recent -- PHP version -- : 5.5.24 -- Browser(s) name and version -- : Multiple browsers -- Error-message(debug-mod must be tuned on) -- : No error message, only wrong data Hi, hope you can help us with this problem. We are in urgent need of suddenly updating a large number of prices a.o. for option variants. A. We exported the option variants and imported into MS Access, where we changed the prices. B. We reimported the option variants with the new prices into our test system 123.valkyrie-guitars.com. To our dismay we found that the system had replaced null values and some others with the price of 999.9900. C. We re-exported the option variants to be able to show you this behaviour. We made screen prints of the csv and txt files as they opened in excel, to show you the strange changes. What is happening here, and how can we avoid the system adding fictive 999.9900 prices to our product variants? Cheers, Marjoline P.s.: The *.txt files for A. and C. were actually csv files, I had to change the extension because this form would not let me upload *.csv files.")* Hi, That's because your products and options products have different warehouses assigned to them. Make sure that you assign them all to the same warehouse and you won't get that problem. The following user(s) said Thank You: [Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODA1NTEtd3JvbmctZGF0YS13aGVuLXJlaW1wb3J0aW5nLXByb2R1Y3QtdmFyaWFudHM/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.090 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)