1. peter@housecalltech.com
  2. RO CSVI
  3. Tuesday, 23 February 2016
  4.  Subscribe via email
After gladly purchasing CSVImproved I have spent the last 6 hours scouring the web for step by step instructions on how to import into Virtuemart 3 from a csv file that has 3 columns (Category\Product\Price) and two thousand products. Can someone please help me. I am using Joomla 3. You would think that someone had simple, step by step instructions somewhere!! Please help guys!
Accepted Answer Pending Moderation
Hello,
Thank you for your interest in CSVI. Have a look at our Getting started Tutorial to know how to start with CSVI. First you need to create a import template, create template fields(as per your post it is category, price and product) and then run the import. If you have any issues with the import send us the information requested at top of this page under "Looking for a useful answer?" section and we will help you out.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hello Peter,

The New button on the templates in CSVI is a step by step process, that didn't help you to create the template? After that you can run your import. Assuming your import file is correct of course :)
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Thanks Guys for your reply. The part that is confusing to me is I have 3 fields with almost 2 thousand product records. Do I create one template or 3? One template per field? Also, how do i prepare the csv file for the import?
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
This is the message i get when trying to preview. This preview shows how CSVI reads your file, not how the file is imported. The fields you see here are not validated yet, that will happen once you start the import. In case your file contains unsupported fields, CSVI will skip them during import as it will not know how to handle them.
Import file contains 1857 lines
No supported fields have been found in the import file

This is the message that i get when starting import.

An error has occured during the import. Below the information received from the server.
Status error: 200
Status message: OK

Fatal error: Call to a member function reset() on a non-object in /home/fitzadmin/public_html/administrator/components/com_csvi/addon/com_virtuemart/model/import/category.php on line 379
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Here is my question guys!

Using Joomla 3, VirtueMart 3, CSVI Pro 6.5.2 with a csv file containing 3 columns, almost 2,000 product records. What steps would you take to import those into Virtuemart so I don't have to add each individual product record?
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hello Peter,

What steps would you take to import those into Virtuemart so I don't have to add each individual product record?
What do you mean by adding each individual product record? Some background information, when you import a product it needs to have a unique identifier. This is called the product SKU and is a required field. CSVI checks if the SKU exists, if it does, the product is updated. If the SKU does not exist, CSVI adds the product to the system.

Also, how do i prepare the csv file for the import?
Usually people use a spreadsheet to prepare their CSV import files.

Do I create one template or 3?
You need only 1 template with 3 fields as you can add multiple fields to a single template.

No supported fields have been found in the import file
This means that your CSV file does not contain column headers with the CSVI names but most likely a name of your own choosing. I can't comment further because there is no sample CSV included and the debug log. If you use the names as mentioned in your first post Category\Product\Price, you cannot use the option Use file for configuration. This must be set to No and you have to add the fields to your template. You can also use the CSVI names instead which are category_path, product_sku, product_price.

Fatal error: Call to a member function reset() on a non-object in /home/fitzadmin/public_html/administrator/components/com_csvi/addon/com_virtuemart/model/import/category.php on line 379
This looks like it happened because no language has been chosen in the template so the language table could not be loaded.

Although this is the category import, I thought you want to do a product import. You can also use the Fieldmapper in CSVI to help you create a template. Now it looks like you have the wrong kind of template set. You need a template of the type Import / VirtueMart / Product.
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Thank you so much for your response Rolland. I am going to try your suggestions now. Please stay tuned.
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Still no luck. Can you put together something simple like this link for the versions that i am using? https://www.ostraining.com/blog/joomla/how-to-import-products-to-virtuemart-using-csv-import-improved/
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
I won't be writing such a specific tutorial for your particular case. Let's start by providing the sample file and the debug log as requested at the top of this page under Looking for a useful answer?. With that we can tell you what you need to change.

Some more information than "Still no luck" would also be helpful. Let me know what you do and where it goes wrong for you.
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
I understand Rolandd. I just thought it would be easier for you to write out the few steps. I attached a sample file. Here are the steps that i took.

1. Joomla Admin. Console.
2. Components
3. CSVI Pro
4. Templates and then New
5. Name - Products \Action-Import\Component-Virtuemart\Operation-Custom field
6. Next - Load from your computer
7. Next Autodetect delimiters-yes \ field delimiter- (,)\Text Enclosure (blank) \I'am Mac-No\Use file for configuration-Yes\Skip first line- (i tried no and yes) \ Record name (blank)
8. Next and then Next: Finalize \ Close
9. Template Field \Field name-virtuemart_custom_id
10. Your field - product_sku\default value (empty)\rules-don't use\ordering\0.....

same for: product_sku \ product_name\ category_path \product_description \product_price

11. Import\ choose template Products
12. Click Select File
13. Browse to peter_sample01.csv
14. Click Preview and i get error: Import file contains 8 lines
No supported fields have been found in the import file

15. Click Start import and i get log details: 7
Filename
peter_sample01.csv
Debug log
No debug log found

All I want to do is import my product list into virtuemart. So I can see my categories\productname\price in virtuemart.
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
Hello Peter,
1. Joomla Admin. Console.
2. Components
3. CSVI Pro
4. Templates and then New
5. Name - Products \Action-Import\Component-Virtuemart\Operation-Custom field

You need to do a product import, so first thing is that Operation here should be Product and not Custom field.

6. Next - Load from your computer
7. Next Autodetect delimiters-yes \ field delimiter- (,)\Text Enclosure (blank) \I'am Mac-No\Use file for configuration-Yes\Skip first line- (i tried no and yes) \ Record name (blank)
8. Next and then Next: Finalize \ Close
9. Template Field \Field name-virtuemart_custom_id
10. Your field - product_sku\default value (empty)\rules-don't use\ordering\0....

You dont need virtuemart_custom_id instead your template fields should be product_sku, product_name, category_path,product_desc and product_price. Also you can leave your field empty as the header names in the file has the same name as the template fields. If you don't find any of these template fields try Updating Available fields.

Try doing the import doing these changes and let me know how it goes.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
Thanks, Tharuna!! You are awesome! We are making progress. Using the steps below the product_sku did import successfully but not the product_name, category_path, product_description and product_price. Maybe my expectations are wrong. Should I expect CSVI to import keeping the record association?
  1. more than a month ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
Hello,
Can you send the debug log of the import? You can check "Where to get the debug information?" on top of this page to know how to get the debug log.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
CSVImproved is a great product with wonderful support. My issue was resolved by upgrading to the newest version. I am now able to see all of my Virtuemart tables inside of template fields. All products have been imported successfully.
  1. more than a month ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
I have made a lot of progress, thanks to you guys. But I am still having a tough time with some of the imports into virtuemart. Virtuemart has tables for categories and products but not categories-products. I need to import a csv file with the categories and products columns so I don't have to select categories for each product. Any suggestions? Please see attachment for clarity.
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 15
Accepted Answer Pending Moderation
Hello Peter,
You can relate product and category by using product_sku and category_path fields in your import file. CSVI will create or update product and category based on these two fields and also an entry into virtuemart_product_categories table. Try import with these two fields and if you still have problem send us the debug log, we will check it.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 16
Accepted Answer Pending Moderation
Hello Tharuna,

Again. Thank you and CSVI for all of your help. Unfortunately the import using category_path and product_sku didn't work. No errors, the product_sku ended up populating the category field. I couldn't find where the category_path imported items ended up. This is a commercial project and my deadline is Friday the 11th. I started the pain staking task adding the categories to the products one at a time. Again, no errors... If you have any other suggestions please let me know.
  1. more than a month ago
  2. RO CSVI
  3. # 17
Accepted Answer Pending Moderation
Hello,
Please post the debug log and sample import file you used, Without that i will not be able to help you in finding what went wrong.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 18
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!