Resolved Joomla Content: Wrong export file with issues

Hello,

I've tried two things now:

1. I have deleted the two fields and tried to import the manufacturers categories as file, Error 500. So as, I wrote before, I added the categories after deleting trhe old ones by my own again (only 5 categories). Then I have imported the manfucaturers without the id fields, result: https://gyazo.com/6bcb6ca8a0e09f04a1601843451eebf8 categories are missing. You can see the file in the attachement.

2. I've deleted all products and deleted the _id field in the products import file. Result: Same Error as before... https://gyazo.com/dd5286898035d324f0cfe7bd4b5534d5
Link to file (17MB!), 2000 products... https://www.beast-supplements.de/VM-Products.csv

Hello,

1. I have deleted the two fields and tried to import the manufacturers categories as file, Error 500. So as, I wrote before, I added the categories after deleting trhe old ones by my own again (only 5 categories). Then I have imported the manfucaturers without the id fields, result: http://gyazo.com/6bcb6ca8a0e09f04a1601843451eebf8 categories are missing. You can see the file in the attachement.

Lets first fix the manufacturer category issue and then go to product import. To add category to manufacturer you need add field mf_category_name in your import file with category name. Try this and let me know. Attach the debug log if you have any issue.

Hello,

I've added the field to my manufaturers import file, but without success: https://gyazo.com/2b6c565078fece2011c5cfe89bf281d7

The manufacturers categoiers in the two shops are looking like this, so it should work normally...

Live shop: https://gyazo.com/4dbd26464190dace7a25ef7f5eb95a1b
New hop (manually added!): https://gyazo.com/9a97e8a9c7315a28027a8aa04cd6150b

You can see the lofgile here:http://www.beast-supplements.de/com_csvi.log.65.txt

Thx!

Hello,
There are few issues in your import file, the fields file_meta and file_title are duplicated, you need to remove them. The mf_category_name field values are empty, you need to provide a category name for manufacturer in this field in your import file. Also, please load the attached patch file and then try the import with corrections in your import file.


patch_manufacturer_category_2016_12_08.zip

Hello,

thx for the patch. I have deleted the two fields and loaded the patch. What du you mean with "The mf_category_name field values are empty, you need to provide a category name for manufacturer in this field in your import file." I have added somehting by the "value field", but this didn't work.

Hello,
I mean that mf_category_name field is empty in your import file. You need to put your manufacturer category name as in https://gyazo.com/9a97e8a9c7315a28027a8aa04cd6150b in mf_category_name field so CSVI will link the category to manufacturer. Hope it is clear now.

Hello,

I have added "Sportnahrung" on the "value default" field and imported the file, it's working. The few other categories were easy to fix manually. Finally it's time for the biggest thing, the products.

The export file is here: http://www.beast-supplements.de/VM-Products.csv
The import has worked now, I got a few little things messed up.

- Manufacturers and mini-thimbs are missing live: https://gyazo.com/6d8b764f768433682b0485d9b3f072ae new: https://gyazo.com/64d36b47686e91b06ee5505f7497a2fa Price is no problem cause it will be fixed later automatically and daily via cronjob script, also the taxes, weight, description and so on.
- Currency is missing

Here is the logfile for you:http://www.beast-supplements.de/com_csvi.log.77.txt

Hello,
Again there are few problems in your import file, file_url_thumb field is duplicated, need to remove one. The field custom is not needed too. As much as i can see in your import file custom_ordering and custom_param field has value ~~~~~ in the import file. Not sure if there is any actual data for these fields. You can remove them if there is no data. Correct these in your import file and apply the below patch file so your manufacturer thumb images imports correct. For currency you need to have product_currency field with currency value added in your import file. Let me know if these solves your issues.

patch_product_media_2016_12_08.zip

Hello,

Sorry for answering so late,... my hoster a a few issues with the servers yesterday and the FTP was brocken down. I'm sorry for that... allright I have deleted the fields and added tha patch and "currency" as default value to the product_currency field.

Result after the import:https://gyazo.com/7a24d4d6b5ad224a0e5ba52a5c0df238

Lokking quite good! As I said before, we are getting the newest datas via cronjob from our vendor, so prices, taxes, descriptions and custom fields (size, flavour abd so on) are getting updated daily. At the Moment there are only two missing things: Mini thumbs and currency. At hte moment I couldn't find more issues and I'm really glad that the VM Import is soon done! Thx for the help until now!

My files for you:
Export file:http://www.beast-supplements.de/VM-Products.csv
Log: http://www.beast-supplements.de/com_csvi.log.81

Hello,
For the mini images, please try to load the attached patch file and try the import again. Your currency seems to be imported correct, what is the problem you see in that? See the sample query from your debug log below, 47 is the currency id for EUR

UPDATE `s4z67_virtuemart_product_prices` SET `virtuemart_product_id`='3942',`virtuemart_shoppergroup_id`='0',`product_price`='42.98',`override`='0',`product_currency`='47',`product_price_publish_up`='0000-00-00 00:00:00',`product_price_publish_down`='0000-00-00 00:00:00',`price_quantity_start`='0',`price_quantity_end`='0',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='0000-00-00 00:00:00',`modified_by`='0',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_price_id`='5896'

patch_product_media_2016_12_09.zip

Hello,

I've used the patch and started the import again with a new exported file. The images aren't there. To explain, I mean the small pictures in the VM Backend here. I guess they were imported correctly, cause the number shows the files, but aren't shown.
Live shop: https://gyazo.com/abcaf3d888fa1eabc0629627b8f3aadb
New shop: https://gyazo.com/d2eae5f20b03ece47f4106c9b752cea2

About the currencies, please see live shop: https://gyazo.com/5cc5567437a2ec5e619b0a7c1eb66712 and new one: "EUR" doesn't appear there. Hmmm...

Import file has same adress as before, logfile is here: http://www.beast-supplements.de/com_csvi.log.84.txt

Hello,
Your thumb images are also imported correct, see the query below for file_url_thumb field. Is your images available in images/stories/virtuemart/product/resized folder in your new shop? Can you also share screenshot of currency issue in new shop?

UPDATE `s4z67_virtuemart_medias` SET `virtuemart_vendor_id`='1',`file_title`='MetaSport_BCAA_P_50618f2e03fb6.jpg_product',`file_description`='',`file_meta`='MetaSport BCAA Pur, 300 g Dose',`file_class`='',`file_mimetype`='image/jpeg',`file_type`='product',`file_url`='images/stories/virtuemart/product/metasport-bcaa-pur.jpg',`file_url_thumb`='images/stories/virtuemart/product/resized/metasport-bcaa-pur_100x100.jpg',`file_is_product_image`='1',`file_is_downloadable`='0',`file_is_forSale`='0',`file_params`='',`file_lang`='',`shared`='0',`published`='0',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='0000-00-00 00:00:00',`modified_by`='0',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_media_id`='103'

Hello,
I see the problem with your prices, there are prices with your old import and so currency is a issue. I would suggest you to clean the prices from CSVI maintenance menu, select VirtueMart in first option and Remove product prices in second option and click Continue. This will remove all the prices for products. Now do a fresh import and new prices will be added with your currency.

Thx, this was helpful. Now currencies are in the new shop.

I have downloaded the images from the live shop and uploaded them into the new, thaught perhaps there has been an issue in the last upload. All files have been allready uploaded successfully. The problems was the layout view.... 30 products = NO IMAGES ...lol 15 are working!

https://gyazo.com/f8298634693c7fac2524c7fc37a4875c

So I think: WE GOT IT! I will now look around for any issues and get back to you on monday. Thx a lot for your help. I will write a review!

Thank you so much, Glad to know that your issues are all solved

Your welcome!

My review: https://gyazo.com/1a3342c6f516cdf3dbb6ad1e12454243

Good morning from Germany,

in the meantime, I have all the imports tested. In the category overview, I do not see any products pictures although these are on the server. I thought first it was the attitude of the "available pieces", unfortunately this was not the case. You can see it here: http://new3.beast-supplements.de/index.php/shop/arginin

Then I've tried to import the menus, there I got several issues with ordering and links...

Please see:
live shop: https://gyazo.com/5944a945ff27a178e9f75f4570be5dc3 (correct VM category link)
correct ordering https://gyazo.com/9c0510a178dea01faac4c2de9463f06d

nerw shop:link https://gyazo.com/a18003d7b126a4b1ee6815f43c199aa8 ("Weight Gainer" is wrong, it's in every case)
wrong ordering: https://gyazo.com/366bec4a65b1136521fc31492267240b

And then finally I can't import any VM users...

A lot more things to dol, bute hope we will get it fixed :-)
Have nice start into the week, best wishes.

Hello,
Lets us focus on one issue at a time, first lets fix the problem with product images. Your product images are not published and it is not seen on front end. I published the first image on your site and it is shows on front end In your import you can add a field media_published and set the default value to 1 to publish all your product images during import. Try and let me know if it solves this issue.

Hello,

I've set the value to 1 into the import template, but this doesn't fix the problem, pleawse see:

Backend: https://gyazo.com/4b0fbfaae712c7fa43d68b277ce897c0
CSVI settings: https://gyazo.com/ee29e1ffd49c80325312580ee8a97472

Hello,
Can you post the debug log of the import?