How to import Excel xls to pages & content?

Asked on October 18, 2015 in How To.

Hello ,

i am working on this project for a tuning site with all cars with models and engine types (pages) and how much power is added before and after tuning (content)

you can see an example here in picture below ill explain what i am looking for as best as possible.

1. The make (page)

2. The Model (page)

3. The Year (Page)

4. The engine type + Power added (page & final content)

This is the final result i am looking for , i have this excel xls file as you can see the layout in this screenshot . al cells are plain text so i think easy to import.

Now my big question is , is it easy to make this kind of thing with a good plugin or do you guys have any suggestions , you know there are alot of cars so it would be almost insane to put them in manualy make pages for them one by one , if there is an easier way if there are no plugins please tell me.

Thanks for the help beforehand.

Kind regards

Dieter

Dieter Jeanty Layers User
Reply
  • Possible Answers to Your Question:

  • 1 Answer(s)
    Answered on October 21, 2015.

    Hi there,

    First let me prepare you that this is a major undertaking and will require a lot of prep work both on the file and in WordPress which is outside the scope of what Layers does for your site.

    Unfortunately there is no support for CSV importing within WordPress itself so you must use a plugin like this one:

    https://wordpress.org/plugins/wp-all-import/

    Be sure to go through their documentation to understand how to prepare the columns and headings in your document:

    http://www.wpallimport.com/documentation/

    Now with regard to that data and what fields they need to match for WordPress, the bigger question is how you need this content organized in WordPress and whether it needs to generate its own archives.  If I understand what you are trying to do, you have several makes of auto, each with several models. Each model has several tuning files that contain a standard power, upgraded power, standard torque ad upgraded torque value along with its normal content.

    Using the content management tools WordPress gives us by default, you would need to do this with Posts, not pages, in order to take advantage of the hierarchal power of the category and tags.

    Posts have the following major elements:

    1. Title
    2. Content
    3. Excerpt
    4. Category
    5. Tags

    These can translate like this:

    1. Tuning file title, ie Tuning file BMW 1 serie
    2. The page content, including the green checkmark list
    3. N/A
    4. The car make and model, ie BMW > BMW 1 Serie 
    5. The year value ie F20 – 2011 

    Because you are not using a standard Year value here, tags make it easier to generate archives on a custom value like this that is used on multiple models that are not necessarily the same make.

    With regards to the taxonomy, make sure you are setting up the plugin as noted in the Nested Parent-child Category doc:
    http://www.wpallimport.com/documentation/taxonomies/nested/

    The first tier of your categories should be the Make of car, ie BMW, Citroen etc
    The next is the models  ie BMW 1M would be a sub-category of BMW

    Make > Model
    or BMW > BMW M1, BMW > M2 and so on

    You will end up with this Category structure in WordPress, more or less:

    BMW
    –BMW M1
    –BMW M2
    Citroen
    –etc

    This allows WordPress to automatically generate archives for BMW which display all tuning files for BMW, or specifically BMW M1, It also generates archives for each tag, so you can see a list of all tuning files for F20 -2011 and so on.  Now to get these archives to display on the front-end in the styles you have there require either a plugin like ShortCodes Ultimate that can output custom post lists using a shortcode (which you can then put inside a toggle in a page if you want) or a child theme with custom category and tag archives that you design like the above.

    Where it gets really complicated is your power and torque values.  The best way to manage those is with custom fields. If you want to stay away from a lot of PHP programming in a child theme, you can use the Advanced Custom Fields plugin to create these four text fields and add them to Posts.

    http://www.advancedcustomfields.com/

    You get to choose the field name, so you could create standard_power, upgraded_power, standard_torque and upgraded_torque. Then you would map the values of those columns to these fields in the importer plugin.

    To output them on the front end, ACF provides super-simple template tags you can use, so all you have to do is design the table, and  add a variable in the loop that grabs the field value for the given post on that row.

    For in-depth help with construcing the child theme, pleasecheck out the Theming Guide under Developer Resources in our main menu here. Further info on category and tag templates can be found here:

    https://codex.wordpress.org/Category_Templates

    The WordPress Support community is a great resource for getting help with custom queries and template building:
    https://wordpress.org/support/forum/themes-and-templates

    Hi ,

    so i tried a little bit and tested it out , now i got to the point i could set everything up , so i got everything imported to Posts and the values torque and Power are correct how i want it to be . so first this is how i did set up the all import options

    1. the description setup.

    2. The category’s

    3. the final upload with unique ID

    So i think everything is correct like this ?
    so when i go to a finished post for example BMW 1 Series ill get something like this :

    that is what i want , now the only problem i have is how to get to that post?
    i don’t know where to start with this .

    like the post before picture 1 2 and 3 and then choose the post ?
    or they have also something like this , a drop down for everything
    the make / model / type and year.
    then when you press search or more info you go to that corresponding post.

    you can see an example here :

    any idea what the best solution would be ?

    thanks for all the help.

    Kind regards
    Dieter

    on October 30, 2015.

    Hi there,

    You can create a filter with drop downs above, which seems logical if you want people to be able to build a specific combination for search criteria,   since the individual custom field values don’t have a view that pulls up the parent post unless you make one. The dropdowns would need to filter by the attribute, so either the category, subcategory, year custom field value, or other custom field value. There may be a  plugin that allows you to build custom jump menus to save you the pain of doing it yourself, (look for something like a multi-level custom search)

    on November 2, 2015.

    Hi ,

    sorry for the post , i wasn’t sure if you did get it or not.

    thanks for the extra info i will try find my way with that .
    hope there is a plugin for this.

    thanks

    on November 2, 2015.

    Programs that can be easily read and write medium, so xls file is the safest and fastest way to open the program is given a familiar Excel or another program in Illustrations.

    on September 11, 2019.

    A good and idealistic article it is and liked by me a lot. I want people would surf the VAN rental Sydney on the internet so that they can know facts and figures in a more better and elegant way. Overall the whole blog is very impressive and good..!!

    on January 5, 2020.

    If you want to buy a used car so you need to visit auto for trade i fond BMW 5 Series 520d SE Touring 2.0 5dr now from this site reasonable price and they are guiding me because i was thing bout a new BMW Now i save my money.

    on September 14, 2020.
    Reply