[Skip to main content](#vessel-content) # CSV Import of Variants, pricing not updated ## - **[IRedsell](/forum/user/29345-iredsell "View IRedsell's Profile")** - [![IRedsell's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/29345-iredsell "View IRedsell's Profile") Topic Author - [ Offline](/forum/user/29345-iredsell) Less More - Posts: 16 - Thank you received: 0 - - 12 years 7 months ago [\#146797](#146797) by [IRedsell](/forum/user/29345-iredsell "View IRedsell's Profile") *[CSV Import of Variants, pricing not updated](/forum/37-import-export-csv-xls/866371-csv-import-of-variants-pricing-not-updated#146797 "-- url of the page with the problem -- :www.safec.co.uk -- HikaShop version -- :2.3.0 -- Joomla version -- : 2.5.16 -- PHP version -- :5.2.6 -- Browser(s) name and version -- : Chrome I am creating import files for a number of products that have extensive numbers of variants. Each variant has a price and a parent product that already exists. Most of the time the import works fine. In some cases however the import appears to work but prices are not updated. I have put debugging on and I can see the select and delete statements from the queries. When I look at the price table after looking at the variants in the administrator I notice that the variants are not loaded properly, they appear to have been deleted. I am trying to understand what is different with the failing cases. I know that there are some variants that do have a null characteristic price causes the import to fail? My process is to set all variants to unpublished and then import with a published = 1 for the imported products. I see in the debugging some deletes from the price table - are these done for the unpublished records? I have an import file to view thanks for any tips Ian")* was created by *[IRedsell](/forum/user/29345-iredsell "View IRedsell's Profile")* -- url of the page with the problem -- :www.safec.co.uk -- HikaShop version -- :2.3.0 -- Joomla version -- : 2.5.16 -- PHP version -- :5.2.6 -- Browser(s) name and version -- : Chrome I am creating import files for a number of products that have extensive numbers of variants. Each variant has a price and a parent product that already exists. Most of the time the import works fine. In some cases however the import appears to work but prices are not updated. I have put debugging on and I can see the select and delete statements from the queries. When I look at the price table after looking at the variants in the administrator I notice that the variants are not loaded properly, they appear to have been deleted. I am trying to understand what is different with the failing cases. I know that there are some variants that do have a null characteristic price causes the import to fail? My process is to set all variants to unpublished and then import with a published = 1 for the imported products. I see in the debugging some deletes from the price table - are these done for the unpublished records? I have an import file to view *This attachment is hidden for guests. Please log in or register to see it.* thanks for any tips Ian Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjYzNzEtY3N2LWltcG9ydC1vZi12YXJpYW50cy1wcmljaW5nLW5vdC11cGRhdGVkP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[IRedsell](/forum/user/29345-iredsell "View IRedsell's Profile")** - [![IRedsell's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/29345-iredsell "View IRedsell's Profile") Topic Author - [ Offline](/forum/user/29345-iredsell) Less More - Posts: 16 - Thank you received: 0 - - 12 years 7 months ago [\#146849](#146849) by [IRedsell](/forum/user/29345-iredsell "View IRedsell's Profile") Replied by *[IRedsell](/forum/user/29345-iredsell "View IRedsell's Profile")* on topic *[CSV Import of Variants, pricing not updated](/forum/37-import-export-csv-xls/866371-csv-import-of-variants-pricing-not-updated#146849 "-- url of the page with the problem -- :www.safec.co.uk -- HikaShop version -- :2.3.0 -- Joomla version -- : 2.5.16 -- PHP version -- :5.2.6 -- Browser(s) name and version -- : Chrome I am creating import files for a number of products that have extensive numbers of variants. Each variant has a price and a parent product that already exists. Most of the time the import works fine. In some cases however the import appears to work but prices are not updated. I have put debugging on and I can see the select and delete statements from the queries. When I look at the price table after looking at the variants in the administrator I notice that the variants are not loaded properly, they appear to have been deleted. I am trying to understand what is different with the failing cases. I know that there are some variants that do have a null characteristic price causes the import to fail? My process is to set all variants to unpublished and then import with a published = 1 for the imported products. I see in the debugging some deletes from the price table - are these done for the unpublished records? I have an import file to view thanks for any tips Ian")* Further to my last update I have now identified that the import works and the pricing works, but I have been checking it in the product Manage Variants and checking the debug code I can see that the Manage Variants is doing a delete from product and product_price hence me seeing no data. I have used PHP Mysql to prove the data is there and I can see the variants so long as I do not do a Manage Variants. Is there a logic issue here, does the manage Variants not check to see if there are logical children in place? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjYzNzEtY3N2LWltcG9ydC1vZi12YXJpYW50cy1wcmljaW5nLW5vdC11cGRhdGVkP3RtcGw9bWFya2Rvd24=) 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) - 12 years 7 months ago [\#147138](#147138) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[CSV Import of Variants, pricing not updated](/forum/37-import-export-csv-xls/866371-csv-import-of-variants-pricing-not-updated#147138 "-- url of the page with the problem -- :www.safec.co.uk -- HikaShop version -- :2.3.0 -- Joomla version -- : 2.5.16 -- PHP version -- :5.2.6 -- Browser(s) name and version -- : Chrome I am creating import files for a number of products that have extensive numbers of variants. Each variant has a price and a parent product that already exists. Most of the time the import works fine. In some cases however the import appears to work but prices are not updated. I have put debugging on and I can see the select and delete statements from the queries. When I look at the price table after looking at the variants in the administrator I notice that the variants are not loaded properly, they appear to have been deleted. I am trying to understand what is different with the failing cases. I know that there are some variants that do have a null characteristic price causes the import to fail? My process is to set all variants to unpublished and then import with a published = 1 for the imported products. I see in the debugging some deletes from the price table - are these done for the unpublished records? I have an import file to view thanks for any tips Ian")* Hi, I am sorry but I don't visualize the problem with the variant. Could you provide some screenshot in order to show us the trouble with this "manage variant" and the "missing variants" ? Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjYzNzEtY3N2LWltcG9ydC1vZi12YXJpYW50cy1wcmljaW5nLW5vdC11cGRhdGVkP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[IRedsell](/forum/user/29345-iredsell "View IRedsell's Profile")** - [![IRedsell's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/29345-iredsell "View IRedsell's Profile") Topic Author - [ Offline](/forum/user/29345-iredsell) Less More - Posts: 16 - Thank you received: 0 - - 12 years 7 months ago [\#147147](#147147) by [IRedsell](/forum/user/29345-iredsell "View IRedsell's Profile") Replied by *[IRedsell](/forum/user/29345-iredsell "View IRedsell's Profile")* on topic *[CSV Import of Variants, pricing not updated](/forum/37-import-export-csv-xls/866371-csv-import-of-variants-pricing-not-updated#147147 "-- url of the page with the problem -- :www.safec.co.uk -- HikaShop version -- :2.3.0 -- Joomla version -- : 2.5.16 -- PHP version -- :5.2.6 -- Browser(s) name and version -- : Chrome I am creating import files for a number of products that have extensive numbers of variants. Each variant has a price and a parent product that already exists. Most of the time the import works fine. In some cases however the import appears to work but prices are not updated. I have put debugging on and I can see the select and delete statements from the queries. When I look at the price table after looking at the variants in the administrator I notice that the variants are not loaded properly, they appear to have been deleted. I am trying to understand what is different with the failing cases. I know that there are some variants that do have a null characteristic price causes the import to fail? My process is to set all variants to unpublished and then import with a published = 1 for the imported products. I see in the debugging some deletes from the price table - are these done for the unpublished records? I have an import file to view thanks for any tips Ian")* To be specific Using the import file above, the import does not complete as follows:- 1. In Hikashop_product The product_parent_id is sometimes left null and I have had to tidy it up using PHP Myadmin 2. In Hikashop_price The product_price_value is not always created Is this because if a product uses a characteristic that has say 25 variants from a 5 x 5 matrix and I only import 15 as some do not apply to this product does this cause a problem with the code? What I have been doing is creating the product, selecting the characteristics, marking all variants as unpublished and then importing published variants, but this solution works inconsistently. I now have two "broken" products in the system that do not show all characteristics See FBP-All and FBP-All2 as examples I have fixed up the parent ids and checked that there are product_prices for each and viewed the variant records from the front end and yet they are still "broken" You can see on the import file that I point to the parent by name, but I have also tried doing it by parent_id numeric and this does not improve the reliability. Could you first check the import file above and see if it is properly constructed? thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjYzNzEtY3N2LWltcG9ydC1vZi12YXJpYW50cy1wcmljaW5nLW5vdC11cGRhdGVkP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[IRedsell](/forum/user/29345-iredsell "View IRedsell's Profile")** - [![IRedsell's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/29345-iredsell "View IRedsell's Profile") Topic Author - [ Offline](/forum/user/29345-iredsell) Less More - Posts: 16 - Thank you received: 0 - - 12 years 7 months ago [\#148576](#148576) by [IRedsell](/forum/user/29345-iredsell "View IRedsell's Profile") Replied by *[IRedsell](/forum/user/29345-iredsell "View IRedsell's Profile")* on topic *[CSV Import of Variants, pricing not updated](/forum/37-import-export-csv-xls/866371-csv-import-of-variants-pricing-not-updated#148576 "-- url of the page with the problem -- :www.safec.co.uk -- HikaShop version -- :2.3.0 -- Joomla version -- : 2.5.16 -- PHP version -- :5.2.6 -- Browser(s) name and version -- : Chrome I am creating import files for a number of products that have extensive numbers of variants. Each variant has a price and a parent product that already exists. Most of the time the import works fine. In some cases however the import appears to work but prices are not updated. I have put debugging on and I can see the select and delete statements from the queries. When I look at the price table after looking at the variants in the administrator I notice that the variants are not loaded properly, they appear to have been deleted. I am trying to understand what is different with the failing cases. I know that there are some variants that do have a null characteristic price causes the import to fail? My process is to set all variants to unpublished and then import with a published = 1 for the imported products. I see in the debugging some deletes from the price table - are these done for the unpublished records? I have an import file to view thanks for any tips Ian")* I still have this problem on import hikashop_product Product ID = 85383 when imported has no parent_product_id I fixed wthis manually with phpmyadmin set to 84570 In the front end I can see the product but it has Free against it (W600 H 500) I look in hikashop_price and can see that product_id 85383 has a correct price in that table 104.49 per the import CSV so my question is can someone take a look at my import file and process and let me know what is incorrect. I have truncated it for easier troubleshooting (attached) This product import in particular has caused me much trouble, I am trying to see what is different could it be some hidden escape characters? I have removed the / from the import to test? Aidez mois SVP Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjYzNzEtY3N2LWltcG9ydC1vZi12YXJpYW50cy1wcmljaW5nLW5vdC11cGRhdGVkP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[paulvanharen](/forum/user/20480-paulvanharen "View paulvanharen's Profile")** - [![paulvanharen's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/20480-paulvanharen "View paulvanharen's Profile") - [ Offline](/forum/user/20480-paulvanharen) Less More - Posts: 45 - Thank you received: 0 - - 12 years 7 months ago [\#148603](#148603) by [paulvanharen](/forum/user/20480-paulvanharen "View paulvanharen's Profile") Replied by *[paulvanharen](/forum/user/20480-paulvanharen "View paulvanharen's Profile")* on topic *[CSV Import of Variants, pricing not updated](/forum/37-import-export-csv-xls/866371-csv-import-of-variants-pricing-not-updated#148603 "-- url of the page with the problem -- :www.safec.co.uk -- HikaShop version -- :2.3.0 -- Joomla version -- : 2.5.16 -- PHP version -- :5.2.6 -- Browser(s) name and version -- : Chrome I am creating import files for a number of products that have extensive numbers of variants. Each variant has a price and a parent product that already exists. Most of the time the import works fine. In some cases however the import appears to work but prices are not updated. I have put debugging on and I can see the select and delete statements from the queries. When I look at the price table after looking at the variants in the administrator I notice that the variants are not loaded properly, they appear to have been deleted. I am trying to understand what is different with the failing cases. I know that there are some variants that do have a null characteristic price causes the import to fail? My process is to set all variants to unpublished and then import with a published = 1 for the imported products. I see in the debugging some deletes from the price table - are these done for the unpublished records? I have an import file to view thanks for any tips Ian")* I run into the same or similar problem. I found out the following: in case the main product is in the same file as the variant, the import works OK. In case only the variant is updated and the main is not in the .csv file, the product_parent_id is not filled in. This loads OK: Code: product_name;product_code;product_type;product_parent_id;char_package;price_value lekkere wijn;lekkere_wijn;main;;; ;lekkere_wijn_fles;variant;lekkere_wijn;Fles;3.45 This is not OK: Code: product_name;product_code;product_type;product_parent_id;char_package;price_value ;lekkere_wijn_fles;variant;lekkere_wijn;Fles;3.45 In PhPMyAdmin I can see that the import of the variant is done, but the parent_id is not set. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjYzNzEtY3N2LWltcG9ydC1vZi12YXJpYW50cy1wcmljaW5nLW5vdC11cGRhdGVkP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[IRedsell](/forum/user/29345-iredsell "View IRedsell's Profile")** - [![IRedsell's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/29345-iredsell "View IRedsell's Profile") Topic Author - [ Offline](/forum/user/29345-iredsell) Less More - Posts: 16 - Thank you received: 0 - - 12 years 7 months ago [\#148659](#148659) by [IRedsell](/forum/user/29345-iredsell "View IRedsell's Profile") Replied by *[IRedsell](/forum/user/29345-iredsell "View IRedsell's Profile")* on topic *[CSV Import of Variants, pricing not updated](/forum/37-import-export-csv-xls/866371-csv-import-of-variants-pricing-not-updated#148659 "-- url of the page with the problem -- :www.safec.co.uk -- HikaShop version -- :2.3.0 -- Joomla version -- : 2.5.16 -- PHP version -- :5.2.6 -- Browser(s) name and version -- : Chrome I am creating import files for a number of products that have extensive numbers of variants. Each variant has a price and a parent product that already exists. Most of the time the import works fine. In some cases however the import appears to work but prices are not updated. I have put debugging on and I can see the select and delete statements from the queries. When I look at the price table after looking at the variants in the administrator I notice that the variants are not loaded properly, they appear to have been deleted. I am trying to understand what is different with the failing cases. I know that there are some variants that do have a null characteristic price causes the import to fail? My process is to set all variants to unpublished and then import with a published = 1 for the imported products. I see in the debugging some deletes from the price table - are these done for the unpublished records? I have an import file to view thanks for any tips Ian")* I agree that the parent ID can only be updated if the system knows explicitly or by reference which product the variants refer to. In my example though the parent ID is SOMETIMES updated and sometimes not even though I use the same data file. So something seems to abort the import without an error message. As I say I can fix this manually, however even when fixed, the characteristic pricing does not appear at the front end even though I can see a variant price in the Hikashop_price table. Is there another table relationship between product, variant and price? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjYzNzEtY3N2LWltcG9ydC1vZi12YXJpYW50cy1wcmljaW5nLW5vdC11cGRhdGVkP3RtcGw9bWFya2Rvd24=) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86293 - Thank you received: 14271 - - 12 years 7 months ago [\#148583](#148583) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[CSV Import of Variants, pricing not updated](/forum/37-import-export-csv-xls/866371-csv-import-of-variants-pricing-not-updated#148583 "-- url of the page with the problem -- :www.safec.co.uk -- HikaShop version -- :2.3.0 -- Joomla version -- : 2.5.16 -- PHP version -- :5.2.6 -- Browser(s) name and version -- : Chrome I am creating import files for a number of products that have extensive numbers of variants. Each variant has a price and a parent product that already exists. Most of the time the import works fine. In some cases however the import appears to work but prices are not updated. I have put debugging on and I can see the select and delete statements from the queries. When I look at the price table after looking at the variants in the administrator I notice that the variants are not loaded properly, they appear to have been deleted. I am trying to understand what is different with the failing cases. I know that there are some variants that do have a null characteristic price causes the import to fail? My process is to set all variants to unpublished and then import with a published = 1 for the imported products. I see in the debugging some deletes from the price table - are these done for the unpublished records? I have an import file to view thanks for any tips Ian")* Hi, I don't see any column for the characteristic name in your CSV. When you import products with variants, you need to have a column for each characteristic of the product and for each variant you need to have in that column the corresponding value of the characteristic. And in the main product, you need to have the default value of the characteristic. Without that information, the system is not able to match the variants with the characteristic of the product and thus it fails to set the variants of the product. If you look at our documentation on the import process, we explain that principle: [ www.hikashop.com/support/support/documen...hikashop-import.html](http://www.hikashop.com/support/support/documentation/73-hikashop-import.html) Also, if you click on the "export" button of your products listing, you'll get a CSV example of what should be done to import the products you have already created and you'll see that you have a column for each characteristic and that the column is filled according to my explanation. That should hopefully help you understand why it doesn't work. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjYzNzEtY3N2LWltcG9ydC1vZi12YXJpYW50cy1wcmljaW5nLW5vdC11cGRhdGVkP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[IRedsell](/forum/user/29345-iredsell "View IRedsell's Profile")** - [![IRedsell's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/29345-iredsell "View IRedsell's Profile") Topic Author - [ Offline](/forum/user/29345-iredsell) Less More - Posts: 16 - Thank you received: 0 - - 12 years 7 months ago - 12 years 7 months ago [\#148767](#148767) by [IRedsell](/forum/user/29345-iredsell "View IRedsell's Profile") Replied by *[IRedsell](/forum/user/29345-iredsell "View IRedsell's Profile")* on topic *[CSV Import of Variants, pricing not updated](/forum/37-import-export-csv-xls/866371-csv-import-of-variants-pricing-not-updated#148767 "-- url of the page with the problem -- :www.safec.co.uk -- HikaShop version -- :2.3.0 -- Joomla version -- : 2.5.16 -- PHP version -- :5.2.6 -- Browser(s) name and version -- : Chrome I am creating import files for a number of products that have extensive numbers of variants. Each variant has a price and a parent product that already exists. Most of the time the import works fine. In some cases however the import appears to work but prices are not updated. I have put debugging on and I can see the select and delete statements from the queries. When I look at the price table after looking at the variants in the administrator I notice that the variants are not loaded properly, they appear to have been deleted. I am trying to understand what is different with the failing cases. I know that there are some variants that do have a null characteristic price causes the import to fail? My process is to set all variants to unpublished and then import with a published = 1 for the imported products. I see in the debugging some deletes from the price table - are these done for the unpublished records? I have an import file to view thanks for any tips Ian")* Nicolas The Two characteristics that drive the code are Width and Height They are both within the file and contain values for each that match the product_code. However I have now checked the export file and see that I have on this version of the file - incorrectly formatted them without the mm and in the export file I can see that they are imported (Because of the correctly formatted product code - but not properly associated with the characteristic) So I am getting warm. I will report back Thank you Ian Last edit: 12 years 7 months ago by [IRedsell](/forum/user/29345-iredsell "View IRedsell's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjYzNzEtY3N2LWltcG9ydC1vZi12YXJpYW50cy1wcmljaW5nLW5vdC11cGRhdGVkP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[IRedsell](/forum/user/29345-iredsell "View IRedsell's Profile")** - [![IRedsell's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/29345-iredsell "View IRedsell's Profile") Topic Author - [ Offline](/forum/user/29345-iredsell) Less More - Posts: 16 - Thank you received: 0 - - 12 years 7 months ago [\#149110](#149110) by [IRedsell](/forum/user/29345-iredsell "View IRedsell's Profile") Replied by *[IRedsell](/forum/user/29345-iredsell "View IRedsell's Profile")* on topic *[CSV Import of Variants, pricing not updated FIXED](/forum/37-import-export-csv-xls/866371-csv-import-of-variants-pricing-not-updated#149110 "-- url of the page with the problem -- :www.safec.co.uk -- HikaShop version -- :2.3.0 -- Joomla version -- : 2.5.16 -- PHP version -- :5.2.6 -- Browser(s) name and version -- : Chrome I am creating import files for a number of products that have extensive numbers of variants. Each variant has a price and a parent product that already exists. Most of the time the import works fine. In some cases however the import appears to work but prices are not updated. I have put debugging on and I can see the select and delete statements from the queries. When I look at the price table after looking at the variants in the administrator I notice that the variants are not loaded properly, they appear to have been deleted. I am trying to understand what is different with the failing cases. I know that there are some variants that do have a null characteristic price causes the import to fail? My process is to set all variants to unpublished and then import with a published = 1 for the imported products. I see in the debugging some deletes from the price table - are these done for the unpublished records? I have an import file to view thanks for any tips Ian")* Aha - the answer was as ever simple but hard to find Someone had introduced a custom field called Height and this is why the imports stopped working, I have also explicitly told the import file what the parent product IDs are for the avoidance of doubt and the import now works reliably again Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjYzNzEtY3N2LWltcG9ydC1vZi12YXJpYW50cy1wcmljaW5nLW5vdC11cGRhdGVkP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 12 years 7 months ago [\#149112](#149112) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[CSV Import of Variants, pricing not updated FIXED](/forum/37-import-export-csv-xls/866371-csv-import-of-variants-pricing-not-updated#149112 "-- url of the page with the problem -- :www.safec.co.uk -- HikaShop version -- :2.3.0 -- Joomla version -- : 2.5.16 -- PHP version -- :5.2.6 -- Browser(s) name and version -- : Chrome I am creating import files for a number of products that have extensive numbers of variants. Each variant has a price and a parent product that already exists. Most of the time the import works fine. In some cases however the import appears to work but prices are not updated. I have put debugging on and I can see the select and delete statements from the queries. When I look at the price table after looking at the variants in the administrator I notice that the variants are not loaded properly, they appear to have been deleted. I am trying to understand what is different with the failing cases. I know that there are some variants that do have a null characteristic price causes the import to fail? My process is to set all variants to unpublished and then import with a published = 1 for the imported products. I see in the debugging some deletes from the price table - are these done for the unpublished records? I have an import file to view thanks for any tips Ian")* Hi, Indeed a custom field with this kind of name can broke the import. Thanks to have shared your solution. This will help other users. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjYzNzEtY3N2LWltcG9ydC1vZi12YXJpYW50cy1wcmljaW5nLW5vdC11cGRhdGVkP3RtcGw9bWFya2Rvd24=) 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.156 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)