Magento 1.9.1. --) Magento 1.9.4
I am setting up a newer version of our store on a different hosting account. I need to export PRODUCTS. I have tried to do a regular EXPORT and IMPORT but that just gives way too many Errors and I didn't get far trying to fix those.
So I decided to do the Dataflow - Profiles import. I did the export on the old 1.9.1 system, found the file in public_html/var/export, uploaded the file on the new Dataflow - Profiles 1.9.4 server and ran it. It gave me the following Error:
Image does not exist.
It says this:
Found 1057 rows. Starting catalog/convert_adapter_product :: parse
Processed 100% 1057/1057 records Imported 8 records Please wait while
the indexes are being refreshed. Finished profile execution.
And it indeed created 8 products only. Those products seem to have all the information EXCEPT FOR the product image. I have just copied all the images from the old system's media/catalog/product folder to the same (media/catalog/product) on the new 1.9.4 environment. I am guessing this is not correct?
Two questions then:
- Where to put the product photos so that they get picked up and inserted into the right products?
- Do I have to create all the websites and categories before I run this Dataflow IMPORT?
Is there anything else I should pay attention to?
UPDATED on January 30th, 2019:
I have done what was suggested here (exported the same file on the old 1.9.1 and the new 1.9.4) and gone through all the fields to compared them. Here is what I found:
extra fields in new 1.9.4 system:
website (there is also a websites field on both old and new) - what is
this field for and do I need to worry about that?
_media_image for example: /t/e/test.jpg
_media_lable
_media_position
_media_is_disabled
Do I need to worry about the _media_.... columns?
Both the old (1.9.1) and new (1.9.4) site's export files have these columns:
image
small_image
thumbnail
The old 1.9.1 exported file has the file paths filled in such as /d/e/productname.jpg while the new 1.9.4 has these empty. What does that mean and what do I need to do here?
extra fields in the Products exported file on the old 1.9.1 system:
cube_category_Bestsellers
cube_category_featured
I have no idea what these are so maybe I could just delete them?
So far I have uploaded all product images in their respective folders into media/catalog/product and that does not seem to be working. Shall I re-upload them/move them to media/import?
UPDATED again later on January 30th, 2019:#
I have now copied all folders, sub folders and files from the media/catalog/product directory into media/import directory and I am getting ready to run the IMPORT again. The only thing I am really still not sure about is the issue with categories. I can create the same categories on the new system but the CSV file seems to only have 1 column concerning categories:
- category_ids
Now the problem is - when I create the same categories in the same category structure, the new system will assign a different category ID, won't it? So what does that mean? Do I have to go through all the 1000+ products and correct the category ID on each? I assume I also have to create the additional websites/stores/storefronts before I run the IMPORT?
UPDATED on February 4th:
I am having a huge problem with categories. When I tried to do the import at first - it gave me Errors saying the categories do not exist. So I created all the categories by hand with subcategories and subcategories of the subcategories, put in all the meta info and all. The issue is that every and each category on the new system has a different category ID than on the old system so I'm having to go through all of them one by one in the exported Excel file and change the numbers. I made me a table of which old category corresponds to which new category but it's driving me completely crazy because:
When I use the REPLACE function of Microsoft Excel - it often does not replace the number correctly especially when working with single digit numbers (it throws the commas off and effectively change the other category ID's on the same product)
after I've changed a number for example 2 to 25; if I later need to search and replace 25 (from the old system to let's say 16 on the new system) then it also replaces a number I already replaced (2 to 25).
Surely, there must be a more sophisticated way to do this?
system->import/export->import
this way? this is better compare to data-flow profile also easy