We have a full ecommerce site running and have been having difficulty with our data.
1) We have a generated CSV export that when we upload
- Short and Long Descriptions have an upload character limit of 255. But our descriptions are much longer
- Tax Classes seem to be ignored going in
- When prices are in the format 29.95, they upload as $2995.00, instead of $29.95
- We have to convert our CSV file UTF8 before uploading, but that a problem, just a step in the process.
Resolutions: Work with the uploaded CSV file to see if we can resolve the above issues. If changes need to be made to CSV, please make recommendations or describe how to change it to make it work for import.
2) Then on the front end, sometimes the price appears and some times it doesn't. If we go into an individual product and then SAVE it, it will appear. But that isn't very helpful when you upload 1500 products.
Attached is our CSV file for reference.