Kryptronic Software Support Forum

No.  It's used to update inventory numbers for existing inventory.  To bulk load inventory, it would be best to use System / Database / Raw DB Admin to load new rows into the ecom_inventory table.  Download a copy of the table in CSV format, create your new rows in it based on what's there, remove the old/current rows so only your new items are in the file, then import that data using Raw DB Admin.

The CSV import through Raw DB Admin updates existing database table rows if the data submitted is found in the table and adds news rows for data that's not in the table.  So you can upload a CSV with just new items in it and it will save just the new items and not touch anything that exists in the table already.

I recommend downloading a copy of the full table via CSV (export it) and then pick an existing row that matches closely with the data you're adding and use that as a template.  You can remove all the other rows, but leave the header.  When you're done adding your new rows, delete your template row so it doesn't get updated.

The best way to verify the data looks good is to use Raw DB Admin to browse the table and compare your new rows to existing working/good rows.  A simple left to right scroll looking at all the data values should point out quickly where you might have to make adjustments to your CSV to re-import it.

That is correct.

No, it really doesn't matter if you use Google Sheets or Excel.  Just be aware that if you use ids with leading zeroes you'll need to import carefully to retain those.