Importing directly into the MYSQL table

[Art Munson]

I’ve been importing my products directly into the MYSQL table wp_wp_eStore_tbl and it’s been working great. I build my products in an Excel spreadsheet and this is a much quicker route for me. I started by creating a product within eStore, exporting that CSV file to make sure I had the fields populated they way I wanted. Do you see a problem with this?

Also, I am not using the categories in eStore but do I need to populate the table wp_wp_eStore_cat_prod_rel_tbl so all the products reference category “0”?

A CSV import function might be a handy feature.

Thanks

Art

[amin007]

There is nothing wrong with directly importing product info into your MySQL database table. I do intend to add in a CSV import functionality later. You can also use the copy a product function in the “Add/Edit Products” menu.

[Art Munson]

Also, I am not using the categories in eStore but do I need to populate the table wp_wp_eStore_cat_prod_rel_tbl so all the products reference category “0”?

[chardixon]

hi,

Artmuns – could you detail how you use excel and then import into your mysql database. i would like to try that, but have no experience doing so.

Thanks,

Charlotte

[frantv]

Followed import instructions for use with the import plugin but products not showing up in store. Pls advise.

[amin007]

Did you save the CSV file a .csv? Some people mistakenly saves it as an excel file after they modify it with their values.

Did you try with one or two products first to see how that goes? This way if there is an error with the data entry then you can find it out easily.

[Author]

Posts