Quote Originally Posted by stuffwo View Post
Hello,
I have redone a new sheet and this did upload and show these readings at bottom: but no products in the category
Filename: Full-EP2015Sep27-212544.csv

UPDATED! - Model: SSP-100 | 1 | silver/SSP | 5 carat ge | ★Cente | | | | | | | | | | | 60 | | 360 | 0.33 | 0 | 0 | 1 | 1 | 0 | 0 | | 2015-07-24 | 1 | Stuffwhole | Handcrafte | ^Libra est | ^英镑的 | --none-- | 1 | 1 | 1 | 1 | 1 | 0 | 5 cart 7 x | genuine to | 5 cart 7 x | | | | | | | http://www |
UPDATED! - Model: TNE-1000 | 1 | silver/tur | Double str | Double str | | | | | | | | | | | 45 | | 99 | 0.4 | 0 | 1 | 1 | 1 | 0 | 0 | | 2015-07-24 | 10 | Stuffwhole | Handcrafte | ^Libra est | ^英镑的 | --none-- | 1 | 1 | 1 | 1 | 1 | 0 | Double str | Genuine st | Double str | | | | | | | http://www |
UPDATED! - Model: PSC4 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 2 | 1 | 1 | 0 | 0 | | 09/27/15 | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC9 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 3 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC6 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 4 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC7 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 5 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC8 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 6 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC10 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 7 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC11 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 8 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC12 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 9 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC13 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 10 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC14 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 11 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC15 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 12 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC16 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 13 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC17 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 14 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC18 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 15 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |

Finished Processing Import File

Updated records: 3
New Imported records: 13
Errors Detected: 0
Warnings Detected: 0
Memory Usage: 7396432
Memory Peak: 7676528
Execution Time: 0.28616714477539 seconds.
So I haven't uploaded it here, but I had taken one of the previous files and modified it to the format I would have expected to find it, I then uploaded and imported it to a test site, and all product appeared including the generation of category that didn't previously exist... The site only had two languages and therefore had errors reported for trying to import the third language version.

I didn't check the second language version mostly because I don't expect that it necessarily worked properly because the category name began with a carat divider (^) which is the character to be used to indicate a sub-category from the previous category/sub-category. It may result in category population in the sub-category with no problem, but that's a different issue.

Now as for the above product not appearing in the category(ies), where was looked to see if/if not present? Admin? Store-front? Do they differ? Does this category exist already and have other sub-categories in it? From the detail at the bottom, it does appear that something was done where there were product updated and product added...