× [JOOMLA 2.5 IS NO LONGER SUPPORTED]
Looking for a useful answer?

Read this first and make sure you checked all steps: www.csvimproved.com/frequently-asked-questions/635-troubleshooting-import-errors

Don't just say it doesn't work but describe in detail what is happening and add the following information:
* VirtueMart version
* CSVI version (Latest is not a version number)
* Sample of the file being imported
* Collected debug information

Without this information you won't get a useful answer. If no debug log is attached, you will get a request to post it.

Where to get the debug information?

A tutorial ( www.csvimproved.com/frequently-asked-questions/390-how-to-collect-debug-information ) has been written to help you collect your debug information.

Custom field export and import

  • jodee.peevor
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
2 years 9 months ago #50683 by jodee.peevor
jodee.peevor replied the topic: Custom field export and import
I have followed the instructions and component is not picking up the other fields in my spreadsheet. You will see from the spreadsheet attached that there are 3 fields but in the screenshot of the import preview it only shows the SKU. Is this something to do with the component?
Attachments:

Please Log in or Create an account to join the conversation.

More
2 years 9 months ago #50685 by tharuna
tharuna replied the topic: Custom field export and import
Hello,
Try to update your available fields and see if you can see other fields. If you still have issues, post the sample of your import file to check.

Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory

Please Log in or Create an account to join the conversation.

  • jodee.peevor
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
2 years 9 months ago #50691 by jodee.peevor
jodee.peevor replied the topic: Custom field export and import
That did work as it picked up the fields but I have an error when I try to upload the file I have. The error is below and I have also attached a screenshot:

Duplicate entry '2653' for key 'PRIMARY' SQL=UPDATE `#__virtuemart_products` SET `virtuemart_product_id`='2653',`virtuemart_vendor_id`='1',`product_parent_id`='0',`product_weight`='0.0000',`product_weight_uom`='KG',`product_length`='0.0000',`product_width`='0.0000',`product_height`='0.0000',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='0',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='2013-04-09 00:00:00',`product_availability`='',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='default',`published`='1',`pordering`='0',`created_on`='2014-05-05 15:17:46',`created_by`='992',`modified_on`='2016-08-03 10:19:06',`modified_by`='553',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='ANO 21 20 02'

I have also attached the file that I am trying to upload. The import hasn't been successful and this error message seems as though it is only do do with one entry not all of them so I'm not sure what has happened. Please can you advise on what to do next?
Attachments:

Please Log in or Create an account to join the conversation.

More
2 years 9 months ago #50692 by tharuna
tharuna replied the topic: Custom field export and import
Hello,
You seem to have two products with same SKU, which is not correct. SKU field should be unique for products. Can you try to go to phpmyadmin, look for table `#__virtuemart_products` and on the SQL tab, paste the below query and click Go, check how many rows you see?. Dont forget to replace #_ with your table prefix before running the query.

You can also check by going to product list in VirtueMart and filter on this SKU.
Select * from #__virtuemart_products where product_sku ='ANO 21 20 02'

Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory

Please Log in or Create an account to join the conversation.