Adding food items using SQL
This support request was posted in BBQ by kapostolou
- kapostolou December 14, 2013 at 9:51 pm
I have a spreadsheet of all my items and descriptions, price etc.
I’m comfortable running sql queries to just do a batch-insert and save a tonne of copy and pasting, but I can’t seem to find the table that it’s supposed to go in.
What table do the food items and categories go in??
Juanfra Aldasoro December 14, 2013 at 10:28 pmHello there,
Thanks for writing. WordPress got its own tables. All posts, pages, and custom post types are stored usually in the table wp_posts.
It is not recommended to insert data directly through SQL.
I’d recommend you in any case to check the WordPress importers, to see if there’s any better solution for your case. Maybe generating a custom XML file with the information to import. Unfortunately this is not part of the theme, but WordPress. So we won’t be able to assist you.
Best,
Juan.kapostolou December 15, 2013 at 12:50 amHi Juan,
Yeah, I realize it wasn’t supported. I just thought if there was an “easy” way to do it for a more advanced user.
No problem. I’ll look into your suggestion.
Thanks.
Juanfra Aldasoro December 15, 2013 at 3:03 pmHi There,
No problem. I suggest you to look over what I’ve mentioned before, or if you want to make a custom script for your import, maybe you can use the WordPress native functions like wp_insert_post or similar. You can find all the information related to these functions in the codex.http://codex.wordpress.org/Function_Reference/wp_insert_post
Best,
Juan.
You must be logged in to reply to this topic.