You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
Pages: 1
It appears that the only way to add multiple products at once to the catalog is to create a CSV file in the ecom_prod order, then navigate to Raw Database Admin, navigate to ecom_prod, and insert the CSV.
If this is the only way, then is there a way to restrict what tables the Raw Database Admin shows? Right now it displays all the core_ and ecom_ tables, but also shows all the other non-related tables that are in that database.
Thanks!
Offline
You are correct.
No. Raw DB Admin is just that, a Raw Database Admin view. All tables are presented there. Just pick the ecom_prod table and work with it on it's own.
Offline
jeffk wrote:
You are correct.
When adding products via the CSV, do the columns need to be in specific order, or does the script determine what column matches what DB field according to the title of the column?
Offline
The column order doesn't matter and you can't import some of them, it has to contain all of the column names present in your ecom_prod database table.
P.S. as a not the primary key (id field for products in this case) should always be the first column, after the primary key the other columns don't matter what order they are in.
John
Offline
If you 'export' the database table to a CSV file, it will then be in the correct format for re-import after editing.
Nigel
Offline
Perfect, thank you. Since someone who is unfamiliar with everything will be doing the product upload, I've done two things to ensure that data is safe and accurate:
-I've played the shopping cart tables in their own database
-I colored the fields in Excel that she should add values to, and placed them all together in the file. I discovered that they only need all be in the file, it doesn't matter what order in the file.
Thanks!
Offline
Pages: 1