In a beautiful day, my client requires updating the product stock status for around 200,000 products in Magento, the data gets from the XML files. The issue is the XML files will be renewed every day, it means I need to finish updating all products within 24 hours. There is a problem for 200,000 products Full Article…
Viewing 1 to 2 of 2 items
Easiest way to open CSV with commas in Excel
CSV files are automatically associated with Excel but when I open them, all the rows are basically in the first column, like this: Turns out it was a regional setting issue; Go into your control panel –> Regional Settings –> Advanced Settings and change your list separator to a comma. Mine was set to semi-colon for South Africa after Full Article…