Error on Import
Permalink Browser Info Environment
Receiving this message upon import. Odd thing is, some products import and they look fine. When I go back it wants to continue the import, and it imports a few more, then stops.
mysqli error: [1054: Unknown column 'Array' in 'field list'] in EXECUTE("insert into CoreCommerceProducts (prName, prDescription, prRequiresShipping, prPhysicalGood, prQuantity, prMinimumPurchaseQuantity, prQuantityUnlimited, prQuantityAllowNegative, prStatus, prPrice, prSpecialPrice, prWeight, prWeightUnits, prDimL, prDimW, prDimH, prDimUnits, prRequiresTax, prUseTieredPricing, prRequiresLoginToPurchase, prShippingModifier, prLanguage, prDateAdded) values ( Array, '', 0, 1, 0, 1, '1', 0, 1, '0', 0, NULL, NULL, 0, 0, 0, NULL, 1, 0, 0, NULL, NULL, '2016-08-26 16:22:15')")
mysqli error: [1054: Unknown column 'Array' in 'field list'] in EXECUTE("insert into CoreCommerceProducts (prName, prDescription, prRequiresShipping, prPhysicalGood, prQuantity, prMinimumPurchaseQuantity, prQuantityUnlimited, prQuantityAllowNegative, prStatus, prPrice, prSpecialPrice, prWeight, prWeightUnits, prDimL, prDimW, prDimH, prDimUnits, prRequiresTax, prUseTieredPricing, prRequiresLoginToPurchase, prShippingModifier, prLanguage, prDateAdded) values ( Array, '', 0, 1, 0, 1, '1', 0, 1, '0', 0, NULL, NULL, 0, 0, 0, NULL, 1, 0, 0, NULL, NULL, '2016-08-26 16:22:15')")
Type: | Discussion |
---|---|
Status: | In Progress |
It looks to me like some of the products in your XML file have multiple "name" tags. There should only be one name per product.
Looked through the file and I can't find any instances of that. Can you take a quick peek at my import file and see if there is anything obviously wrong?
Ah. I reviewed the XML file. The problem is that some of the products have an empty name tag. For example, search for the product with the product_number HMHMUM674. You'll need to add a name for those products.
Well, THAT could be an issue. Seems as though some of the products have numbers and latin names and descriptions but no names. Can't use a placeholder either. If we are importing based on product number do we HAVE to have a name? If so, is there any way to bypass? I will check with the client to see if there is a work around. Thanks!
You could also remove the empty "name" tags. The problem is that the tag is present but empty.
Ohh, I can do that! Thanks!
Well that did the trick, and the client is filtering out the records with no names, so it's a win-win. Thanks!
You're welcome. I'm glad we were able to sort this out.